I hope you’ve had a great week!
New to SQL Server or just getting started on the road to becoming a DBA? Then you will want to check out the SQL Server Essentials Series.
With the Holiday Season coming to an end it’s time to get the SQL Server Guru Challenge under way. If you have not entered yet then you’re almost out of time. Basically, you have between now and the time I send out the first challenge next week to get your entry in.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
PASS Virtualization VC: Now Open for Syndication – Brent Ozar has done a cracking job pulling together the Virtualization Chapter of PASS and along with his fantastic team, they are now centralising their content for the benefit of us all. I for one really enjoy this new and rapidly expanding subject area and appreciate the effort that goes into producing such excellent content. Great work chaps!
EXISTS vs IN – Gail Shaw sets the record straight on this matter, walking you through the problem solving process. Includes source code and execution plan screen caps.
Correlate Session State Information With Cached Query Plans – Tim Ford provides this little tip, utilising the SQL Server DMV’s.
Top 10 T-SQL Code Smells – Excellent set of smells to watch out for. This is the first article I have read by the author, Merrill Aldrich and I would certainly be interested in more.
Performance impact: tempdb and update statistics – A nice detailed article here, courtesy of Linchi Shea.
A Unicode Compression example – Those clever chaps from the SQL Server Storage Team walk us through the the Unicode compression capability introduced in SQL Server 2008R2.
Misc Techie Stuff
Tech giants unite against Google – The latest developments in Google’s world domination plan.
My Non-SQL Server Pick of the Week
All Programming is Web Programming – Jeff Atwod (aka Coding Horror) discusses in response to a rant.
Have a great weekend!