Use an explicit anniversary rule for calculating age in T-SQL, including February 29, years-months-days output and birthday lookups.
SQL SERVER – Get Time in Hour:Minute Format from a Datetime – Get Date Part Only from Datetime
Get the time in Hour:Minute Format, or just the date, from a DATETIME with CONVERT styles 108 and 101, or with the TIME and DATE types in SQL Server 2008.
SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server
No OS access? Run xp_fixeddrives from Management Studio to list each fixed hard drive with its free space, then plan where TempDB and indexes go.
SQL SERVER – Forgot the Password of Username SA
Forgot the password of username SA? Resetting it is easy when another sysadmin login or a Windows admin account can get in. Here are your options.
MIN and MAX Text: Collation Chooses the Extremes
MIN and MAX text use collation ordering, not numeric magnitude. Compare digit strings, empty text and NULL using an explicit BIN2 contract.
Monitoring With What You Already Have
Build useful SQL Server alerts with Agent, operators, failed-job notifications, and a review routine that verifies the whole delivery path.
Date Conversion Styles: Disambiguate Day and Month
Date conversion styles define how incoming text becomes a date. Compare month-first and day-first interpretations without guessing. Keep invalid dates separate from missing input.