Jun 3, 2011
Something for the Weekend – SQL Server Links 03/06/11
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
- 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
- Google boss: I screwed up on social networking boom
- Sony investigating another hack
- Windows 8 previewed by Microsoft
- Skype reverse-engineered and open sourced
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).