SQLAuthority.com crossed 5 million visitors and turned 2 years old. I also share my note on the economy slow down and job opportunity for SQL Server folks.
SQL SERVER – Clear Drop Down List of Recent Connection From SQL Server Management Studio
Is the SSMS connect drop down list full of old server names? Delete the mru.dat file for SQL Server 2005 or 2008 to clear it and start fresh.
Tracking Job Failures Across Servers
Tracking job failures across servers takes a daily msdb report, a central instance list, and notifications that reach someone who can act.
Installing sqlcmd and bcp on a Clean Machine
Installing sqlcmd and bcp on Windows starts with the current Microsoft command line utilities, then PATH and version checks.
Handing Over a Database to Another Team
Handing over a database should include a current map, tested recovery path, access transfer, open risks, and a defined support period.
Seeing What Is Running Right Now
See what is running right now in SQL Server with request DMVs, statement text, plans, waits, and blocking details in one reusable query.
SQLAuthority News – SQL Injection – SQL Joke, SQL Humor, SQL Laugh
The SQL Injection cartoon readers sent me many times, finally on the blog. Plus a demo of how dynamic SQL opens the door to it, and a way to close it.