I was pretty excited to see the launch of a new website from SQLSentry. SQLPerformance is going to be a great resource for the SQL Server community. Congrats to SQL Server MVPs Aaron Bertrand and Kevin Kline on the launch of the site.
Read Aaron Bertrand’s announcement here.
Check out the free tool SQL Sentry Plan Explorer v1.3 . We use it a lot to review queryplans.
I needed a quick query to get some server information using sys.dm_os_sys_info and SERVERPROPERTY ( propertyname ) . It is budget time so folks want to know some specifics about some of the current infrastructure. This is a nice way to provide a high level look at you infrastructure. Tested on SQL 2005 and SQL 2008 R2.
The SQLOS Team has a neat article about changes in 2012 for the DMV.
There are tons of thing in this world that I really don’t understand. SQL Server XQuery is just one of those just out of reach. Poking around trying to answer a question for a developer, I found the following XML script examples. Teh writer provides excellent explanations and examples. Immediately found the right path(pun intended) to go down. I so wished my brain worked this way!
Jun 26 2008 3:41PM by Jacob Sebastian
A coworker shared this awesome script to monitor backup and restore operation progress. I am not sure of the origin, but is definitely has become an essential member of my SQL scripts folder.
Works on SQL 2005 – SQL2008 R2. Not tested on SQL 2012.
SQLServerCentral.com has an excellent series on indexing. Indexing seems pretty straightforward, improve queries performance. Blah. Blah. In reality, they can get away from even the most seasoned DBA. The stairway series are great to learn or RE-learn SQL server specific topics. Excellent resource!