I hope you’ve had a great week!
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Getting graphical ShowPlans back in SQL Server 2008 R2 – “If it’s not broke then don’t…” oh wait it is. Aaron Bertrand (Blog|Twitter) with the fix.
- Over and under indexing – how bad is it out there? – Some fantastic community contribution and excellent analysis of the results from Paul Randal (Blog|Twitter). I wonder what you will find out about your environments?
- Congrats to Lori Brown and her SQL Server and Trace Replay article – With thanks and some pretty diagrams it’s Lee Everest (Blog).
- How to Estimate Data Utilization – A really interesting perspective provided on how you use your data, courtesy of Michelle Ufford(Blog|Twitter).
- So You Want To Be Mission Critical? Hire a DBA – Taking no nonsense and telling it like it this week, it’s Allan Hirt (Blog|Twitter).
- Code to list index counts per table – Here’s the accompanying code resulting from the earlier post by Paul Randal (Blog|Twitter).
- Stopping a Series of SQL Agent Jobs – A handy T-SQL snippet from Mike Hilwig (Blog|Twitter).
- Everybody Needs a Test Harness – We most certainly do and Kevin Kline(Blog|Twitter) shows us how.
- Are You Approaching Your Partition Range Limits – The second offering this week from Michelle Ufford(Blog|Twitter) with a T-SQL snippet.
- New SQL Server 2012 Licensing Changes Mean Nothing To Me – You and me both. Thomas Larock (Blog|Twitter) is getting his rant on.
- The case against INFORMATION_SCHEMA views – If you’re not already using the Catalog Views, here’s Aaron Bertrand (Blog|Twitter) with why you darn well should be.
- SQL Tribal Knowledge – Fancy yourself as a SQL Server author but not had the opportunity to make your début? Now’s your chance thanks to Jen McCown (Blog|Twitter).
UK SQL Server Upcoming Events
- SOUTHAMPTON – Wed 9 Nov -Allan Mitchell and James Rowland-Jones taking over the evening.
- DUNDEE – Sat 19 Nov – A FREE single-day software development conference.
- LEEDS – Wed 23 Nov – Cursors are evil, and shouldnt be used with Dave Ballantyne and a session from James Boother.
- MANCHESTER – Thur 24 Nov – Cursors are evil, and shouldnt be used with Dave Ballantyne and a session from James Boother.
Misc Technology Posts
- Groupon share sale raises more than expected
- Free wi-fi in central London promotion launched
- Asus Eee Pad Transformer is Stuff’s gadget of the year
That’s it for this week. If you’ve read a post this week that you think deserves a mention be sure to let me and other readers know by using comments section below. You can also reach me on email and find me on Twitter(@JohnSansom).
Have a great weekend!
Did you enjoy this post? The best way to show your support is by clicking the Like/Google Plus 1 button at the top of the on site post.
It spreads the word helping our SQL community grow and shows you care :-)