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.
SQLAuthority News – Author Visit – Virtual Tech Days August 2009
My notes from Microsoft Virtual Tech Days August 2009, where I presented two sessions, and how presenting online differs from a user group.
SQL SERVER – Introduction to SQL Server 2008 Profiler – Complete
A complete introduction to SQL Server 2008 Profiler: creating, watching, storing and replaying traces, and whether to run it on a production server.
SQLAuthority News – Proposed eGov Standards Policy – Benefit for All or Only A Chosen Few
Does India’s proposed eGov Standards Policy help everyone or only a chosen few? My thoughts on why a single mandated standard can shut out Indian ISVs.