- I hope you’ve had a great week!
Make sure you don’t miss out on posts by Subscribing to the Blog Feed. You can also receive this Blog feed via Email.
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- March 2011 Version of SQL Server 2005 and 2008 Diagnostic Queries – I actually now consider this resource an essential tool in my arsenal. Go and take a look at these tremendous queries for the DBA from Glenn Berry (Blog|Twitter).
- An XEvent a Day (23 of 31) – How it Works – Multiple Transaction Log Files – This is a brilliant and in depth article from Jonathan Kehayias (Blog|Twitter) that I highly recommend you read.
- Scaling Up or Scaling Out? – Part 2 of this excellent SQL Server architectural discussion from Brent Ozar (Blog|Twitter) looks at your choices and decisions for Scaling Out.
- Geek City: What gets logged for index rebuild operations? – More SQL Server Internals analysis from Kalen Delaney (Blog|Twitter).
- Tempdb configuration survey results and advice – More fascinating insights into the SQL Server playing field via another excellent research effort from Paul Randal (Blog|Twitter). How does your environment compare?
- Aggregating With Correlated Sub-Queries #tsql2sday – Another contribution from this weeks T-SQL Tuesday Jason Strate (Blog|Twitter) looks at the importance of aggregate operation ordering in your execution plans.
- Configuring SQL Server to use Windows Large-Page allocations – More real world troubleshooting tales from Pradeep Adiga (Blog|Twitter).
- T-SQL Tuesday #016: AWF-Inspiring Queries – A wonderfully detailed walk through with examples here courtesy of Brad Schulz (Blog).
- Comparing Different Results with RCSI & Read Committed – More real world customer case experience from the Microsoft SQL Server Development Customer Advisory Team.
- Full backups, the log chain and the COPY_ONLY option – Attempting to clear up the confusions surrounding the interaction between the Transaction Log and database backups, I give you Gail Shaw (Blog|Twitter).
- Disaster recovery 101: fixing metadata corruption without a backup – It’s not supported but you want to have a go anyway right. Getting his hands dirty with the system tables and showing you how it’s done, Paul Randal (Blog|Twitter).
UK SQL Server Upcoming Events
- CARDIFF – Thur 24 Mar – Cardiff User Group with RedGate SQL Monitor, Alex Whittles on using SSRS, DMVs & spatial data to visualise SSAS cube structures, also Chalk and Talk on HA/DR/Scaling with Tony Rogerson
- EDINGBURGH – Thur 31 Mar – Scottish Area User Group Meeting – April
- SOUTHAMPTON – Wed 13 April – User group evening of Neil Hambly.
- SQLBits 8 – 7th – 9th April – Europe’s biggest SQL Server event will be at he seaside this time around. Only a few place remain now
- LEEDS – Wed 11 May – Leeds UG meeting – Resource Govenor and Policy Based Management with Chris Testa-O’Neill
- SOUTHAMPTON – Wed 11 May – User group evening of TBA.
- MANCHESTER – Thu 12 May – Planning for Stored Procedures with Munsoor Negyal and another speaker- Thursday night meeting at BSS
- SOUTHAMPTON – Wed 8 Jun – User group evening of TBA.
Misc Technology Posts
- iPad 2 sales kick off in dead of night
- Google aids Japan quake victims
- Sony gets PS3 import ban lifted
- Home wi-fi ‘30% slower’ than fixed broadband
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 emailand find me on Twitter(@JohnSansom).