May 20, 2011
Something for the Weekend – SQL Server Links 20/05/11
I hope you’ve had a great week!
The BIG news on the block this week is that the PASS Summit 2013 will be held in Charlotte NC. For the last 5 years it has been Seattle that has played host. You can find out more about the announcement on the PASS Blog. As with any decision that the PASS Board makes, there have been mixed opinions on the decision. Personally I think it’s a great step forward that will provide an opportunity for PASS to reach out to and interact with a different area of the SQL community.
I’m delighted to share with you the fantastic news that this week saw the start of a new SQL Server User Group here in the UK. It’s brilliant to see our community growing from strength to strength but what really makes this a great story is that the group was brought to life single-handedly through some serious hard work and grit on the part of Jonathan Allen (Blog|Twitter). Congratulations to SQL South West! If you are a Data Professional in and around the South West area then now is the time for you to get involved and be there at the start of something great. It’s also one of Your Techie Resolutions for this year.
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- SQL University – Internals by the Numbers – It’s Internals week at the SQL University this week, a tough topic and Erin Stellato (Blog|Twitter) handles it well for us.
- SharePoint Adventures : ADFS Setup – Part 1 – If SharePoint is your idea of an adventure then go ahead and knock yourself out, literally . More tales from CSS SQL Server Engineers (Blog).
- May 2011 SQL Server 2008 Diagnostic Information Queries – A good DBA can never have too many awesome scripts in his (or her) toolbox and Glenn Berry (Blog|Twitter) released an update to his awesome diagnostic queries this week. Be sure to get yourself copy and express your thanks/feedback.
- Cloud Computing and the Code-Based Infrastructure – Quite a ponderous discussion this week from Buck Woody (Blog|Twitter). I’ve got to admit I’m “still” not convinced about the Cloud but I really do want to be.
- Don’t Shrink TempDB! – A real world lesson shared by Nicholas Cain (Blog|Twitter). Funnily enough I was wrestling with a tempdb only last week myself so make sure you know what to do in such a crisis.
- Okay, You’ve Found Blocking, Now What? – This week Michael J. Swart (Blog|Twitter) looks at what you can do to minimise, if not eliminate excessive blocking.
- Slow performance and out of memory issues caused by large batch – Another story from the field brought to you by the CSS SQL Server Engineers (Blog). I really like these posts because they give you a valuable insight into other peoples problems. Who knows maybe one day they’ll be yours too.
- Covering, schmuvvering – when a covering index is actually rubbish – Proof that covering indexes are not the best thing since sliced bread, it’s Rob Farley (Blog|Twitter).
- SQL University – Internals Week – More from the SQLU theme of the week it’s Thomas Larock (Blog|Twitter).
- On Transactions, errors and rollbacks – A very interesting look at error handling and transaction management from Gail Shaw (Blog|Twitter) this week. I’ll be very surprised if you do not learn something from this insightful post.
UK SQL Server Upcoming Events
- SURREY - Wed 25 May - Sessions from Keith Burns (Microsoft) and Justin Langford (SQL Server MVP)
- HERTFORDSHIRE - Thur 16 May - SQL Herts User Group Meeting
- 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
Misc Technology Posts
- IT Is Too Darn Slow – This is a very interesting read. Some big picture IT thinking, if a bit on the long side, so be sure to grab the coffee.
- Sony faces further security woes – Issues again with Sony’s online gaming platform this week, after having only gone live once again this past Sunday. The Call of Duty fanboys must be going crazy….
- Why are Microsoft and Intel slapping and pulling hair?
- Fake security software catches out Apple owners
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 on Twitter(@JohnSansom).