SQL Server Notes
A collection of notes for myself! Backup up an Express instance of SQL ServerEasy! Follor this tutorial: https://support.microsoft.com/en-us/help/2019698/how-to-schedule-and-automate-backups-of-sql-server-databases-in-sql-se
SQL
A collection of 3 posts
MySQL – Get the First Day of the Month (for a given date)
This is one of those simple problems for which a multitude of answers present themselves. But which is better? For starters, your "given date" could be the current date, or an arbitrary date
Sunset and Sunrise Calculation Based on Latitude, Longitude and UTC Offset for MySQL
This is an implementation of the United States Naval Observatory's algorithm for calculating sunrise/sunset based on latitude, longitude, and current timezone. It is a translation of a solution published on CodeProject by