Jun 3, 2011

Something for the Weekend – SQL Server Links 03/06/11

I hope you’ve had a great week!

You can make sure you don’t miss out on future posts right now by Subscribing to the Blog Feed. You can also receive posts via Email.

Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!

SQL Server Links

Top 10 Keys to Deploying SQL Server on VMware – A lot of SQL Server DBAs are now really starting to get stuck in with Virtualization. This week Brent Ozar (Blog|Twitter) offers some outstanding advice on the matter.
Creating All New Database with Full Recovery Model – An administrative tip here from Pinal Dave (Blog|Twitter).
SQL Server Locking and You! – Some people just know how to write well and this week Jeremiah Peschka (Blog|Twitter) is on form again.
A Round-up of Round-ups and other Meta Things – A fantastic list of community Meta resources if I don’t say so myself, courtesy of Michael J. Swart (Blog|Twitter). Thanks for the mention my good sir.
Puzzle – Statistics are not Updated but are Created Once – Everybody loves a good T-SQL puzzle, well OK maybe not everybody but if puzzles and learning are your thing then you’ll be sure enjoy this post from Pinal Dave (Blog|Twitter).
The pros and cons of trace flags – What, you mean I shouldn’t just turn them all on for fun? More fascinating survey result from Paul Randal (Blog|Twitter) and don’t forget to also take part in this weeks Survey: do you regularly reboot SQL Server?.
June 2011 Version of SQL Server 2008 Diagnostic Queries - Glenn Berry (Blog|Twitter) shares with us the latest edition of his Diagnostic Queries. Add them to your DBA Toolbox.
How to Design Multi-Client Databases – More quality content from Brent Ozar (Blog|Twitter) and the PLF crew.
Understanding Quorum in a Failover Cluster by Symon Perriman – An nice detailed and technical article from the Failover Clustering and Network Load Balancing Team Blog (Blog).
SQL University Troubleshooting Week: Having a Plan for Every Situation – The theme for SQLU this week is Troubleshooting and here David Levy(Blog|Twitter) holds class.
Performance issues from wasted buffer pool memory – More sage advice from Paul Randal (Blog|Twitter).
Be Careful Installing Windows Features – A cautionary tale from Nicholas Cain (Blog|Twitter).
Dipping My Toes Into SQL Azure – Getting the RML Utitlies to play nicely with SQL Azure, courtesy of the CSS SQL Server Engineers (Blog).
SSAS 2008 R2 Operations Guide – Don’t say I never give you Analysis Services folks anything. Andrew Calvett (Blog) shares the link to a recently published White Paper that I imagine will become essential reading for all SSAS DBAs. Best get the coffee in first though, it’s a big read.

UK SQL Server Upcoming Events

LONDON - Tue 7 Jun - An evening with the SQL Server Leadership Team
SOUTHAMPTON - Wed 8 Jun – User group evening of TBA
MANCHESTER - Wed 15 Jun - Andrew Fryer from Microsoft and Allan Mitchell
LONDON – Thu Jun 16 - Tony Rogerson (MVP) and Neil Hambly (Wait Stats) + Guest presenter – Topics to be updated shortly
LEEDS - Thu 16 Jun – UG meeting with Andrew Fryer from Microsoft and Allan Mitchell
LONDON - Mon 20 Jun – Multi Day Seminar – SQLskills Immersion Event on Internals and Performance – 5 day event 20th June – 25th June
EDINBURGH - Thu 23 Jun – Scottish Area User Group Meeting
LONDON - Fri 15 Jul – SQL in the City
LONDON - September 12 – 14 - Advanced SQL Server Troubleshooting Workshop

Misc Technology Posts

That’s it for this week. What was your favourite post? If I’ve missed anything that you think deserves a mention then be sure to let me know! You can leave your comments below, send me an email and find me onTwitter(@JohnSansom).

One Comment

Michael J Swart
Jun 03, 2011 @ 22:10:37

You’re welcome John, I was going to warn you against including a round up of round ups inside your round up. I felt like the world would implode (or at least the world wide web).
I guess we dodged a bullet there.

Have a good weekend sir.