Sep 2, 2011
Something for the Weekend – SQL Server Links 02/09/11
I hope you’ve had a great week!
Every DBA needs a vacation (How to Raise Your Game By Doing Nothing) and I’m most certainly no exception to the rule. In the not too distant future I will be taking my leave of you for a short while, meaning there will be no weekly post for you to enjoy. Fear not however, for I shall of course return.
As is often the case in life, with misfortune also comes opportunity for those who are prepared to see it and brave enough to take it. So whilst I’m away I would be delighted for one of you to take the SFTW baton from my hand and play host for a week or two. You might want stick with the existing format or even add your own spin on it. It’s your call and opportunity to shine. Drop me an email if you’re interested.
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Can a SELECT query cause page splits? - Advanced, well at least I think so , query plan investigations from Paul White (Blog|Twitter).
- Building a Completely Free Playground for SQL Server - Part 2 of Jonathan Kehayias’s (Blog|Twitter) series on building your very own SQL Server playground. This week looking at setting up your AD and Virtual SAN.
- Secret New SQL Server Denali Feature: Data Director - Brent Ozar (Blog|Twitter) is pitching this as potentially the most exciting feature of SQL Server Denali. What do you think?
- The Dedicated Admin Connection: Why You Want It, When You Need It, and How To Tell Who’s Using It - Every self respecting DBA should know about this, no excuses. Kendra Little (Blog|Twitter) is here to fill you in.
- SQL Server Hardware Choices Made Easy - Everyone loves a freebie and when the quality is this high who can blame them. Courtesy of the talents and hard work of Glenn Berry (Blog|Twitter), you can get your hands on this excellent knowledge packed ebook absolutely free. Be sure to thank the man himself and provide your feedback/comments via his blog.
- Stop and checked your Virtual Log Files (VLFs) - I can tell you on good on authority that this really does make a difference when it comes to the performance of your Replication topologies. Here to explain all it’s those clever folks from the Microsoft SQL Server Replication Support Team(Blog).
- “QUOTED_IDENTIFIER” causes Unexpected Query Plan for Persisted Computed Column query - More performance tuning insights from Microsoft SQLCAT (Blog).
- How to Prove It’s a SAN Problem Webcast Video - As if you ever needed proof, Brent Ozar (Blog|Twitter) shows you how in this video.
- Applied SQL: Server Side Traces - It’s been a four day working week here in the UK, so most of us have been scrambling to get things done but if you just can’t get enough SQL Server action and feel the need to flex those brain muscles some more then Jen McCown (Blog|Twitter) has got an assignment for you.
- Sometimes it’s the little things… - Ah the jokes we could have with this post tittle at the expense of Mr Rob Farley (Blog|Twitter), too easy I say. Instead check out the new features in SQL Server Management Studio (Denali) that he kindly highlights for us.
- Indexing for Deletes - Is your indexing strategy all about read performance? You may be missing out on performance improvement opportunities as Jeremiah Peschka (Blog|Twitter) explains.
UK SQL Server Upcoming Events
- SOUTHAMPTON - Wed 7 Sep - Simon Sabin (MCMMVP) and Jessica Meats presenting at the Southampton User Group.
- LONDON - Sep 12 – 14 - Advanced SQL Server Troubleshooting Workshop
- SQLBits 9 - Thur 29 Sep – 1 Oct – The UKs largest SQL Server event heads to Liverpool.
- SQLRelay - Mon 3 Oct – Thur 6 Oct – 13 SQL Server Events taking place across 4 days throughout the whole of the UK.
Misc Technology Posts
- Are You Willing To Relocate?
- Germany lifts Doom sales ban after 17 years
- FT pulls app over customer data dispute with Apple
- ‘Black swans’ busting IT budgets
Even More SQL Server Stuff
What’s that you say, you still hunger for even more SQL Server goodness? Check out my most Popular Posts area, where you can see what other readers have enjoyed reading as well as my personal favourites.
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).
Did you enjoy reading this weeks post? The best way you can show your support is by clicking the Like and/or Google Plus 1 button at the top of this post. It spreads the word helping our SQL community grow and shows you care
Have a great weekend!