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.