The blog has reached 700 articles. Here is why I write, plus updates since article 600: the SQL Server MVP award, user group work and 4 million visitors.
SQL SERVER – Explanation about Usage of Unique Index and Unique Constraint
When should you use a Unique Index and when a Unique Constraint? Imran Mohammed explains, and shows how to handle a column with more than one NULL.
The Tools a DBA Installs on Day One
The tools a DBA installs on day one include SSMS, command line utilities, a checked script library, and managed source control.
SQLAuthority Author Visit – Microsoft Student Partner Conference
On August 30, 2008 I presented a technical session at the Microsoft Student Partner conference in my city, and I explain what the MSP program offers students.
SQLAuthority News – 4 Million Visits – over 675 SQL Server Articles
Thank you to every reader: this blog has reached 4 Million Visits and over 675 SQL Server articles, and I was awarded SQL MVP along the way.
Spotting Agent Jobs That Run Longer Than Usual
Spot Agent jobs that run longer than usual by decoding msdb duration, comparing recent runs, and checking jobs still active now.
Finding the Client IP Address of a Connection
Find the client IP address of a SQL Server connection with DMVs and CONNECTIONPROPERTY, and understand proxy and local transport limits.