Mar 11, 2011
Something for the Weekend – SQL Server Links 11/03/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
- 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).