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 – Microsoft SQL Server 2008 Report Builder 2.0
Download Report Builder 2.0 for SQL Server 2008 Reporting Services, with table, matrix and chart wizards, plus a note on SQL Server 2008 R2 Report Builder 3.0.
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.
SQLAuthority News – Tip of the Minute
My personal website has a new Tip of the Minute section that shows a fresh SQL Server tip on every refresh. A few sample tips and a small challenge inside.