May 27, 2011
Something for the Weekend – SQL Server Links 27/05/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
- The most important consulting skill is… effective communication – Being one of the most renowned SQL consulting outfits there is, these folks would certainly know. This week Paul Randal (Blog|Twitter) shares with us the most important consulting skill.
- PowerShell script to help uninstall SQL Server 2008 R2 Evaluation Edition – A handy tip/script here from Rob Farley (Blog|Twitter).
- SQL Azure Query Tuning – Taking a look at the subset of DMVs that ARE available for us to use in SQLAzure it’s, Grant Fritchey (Blog|Twitter).
- Sweet Charlotte! – The big news last week was that the PASS Summit will be moving. Here PASS Board member Thomas Larock (Blog|Twitter) discusses some of the reasoning behind the decision.
- Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 1 – If you’re interested in storage hardware performance, let’s face it who isn’t, then you will want to check out this post from Wes Brown (Blog|Twitter).
- SQL Server Filegroup Piecemeal Restores – It’s been a while since Jes Borland (Blog|Twitter) has featured on SFTW, this week giving us an excellent technical walkthrough.
- I Think You’re Exceptional. No, Really. – A motivation piece here from Brent Ozar (Blog|Twitter), encouraging you to take part in this years Exceptional DBA Awards.
- Understanding Non-Uniform Memory Access/Architectures (NUMA) – High quality technical content as always from Jonathan Kehayias (Blog|Twitter), good stuff!
- Benchmarking: Multiple data files on SSDs (plus the latest Fusion-io driver) – More storage goodness from Paul Randal (Blog|Twitter) with some very interesting results reported. You don’t want to miss this.
- Covering Index because it’s Covering up the truth? – Closer inspection of query plans is on the agenda this week from Rob Farley (Blog|Twitter). It’s without a doubt very interesting reading but I can’t help but wonder about the of real world application given the contrived examples. What do you think?
- Pssdiag/Sqldiag Configuration Manager released to codeplex – This tool from the CSS SQL Server Engineers (Blog) has the potential to be very useful indeed! I’ve yet to play with it so I’d be very interested to hear about how you get on.
- New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO – A new Whitepaper is available this week and shared via Robert L. Davis(Blog|Twitter).
UK SQL Server Upcoming Events
New This Week: Advanced SQL Server Troubleshooting Workshop in Central London: September 12 – 14. In this 3 intensive days workshop Klaus Aschenbrenner shows you the right tools and gives you the knowledge to resolve advanced performance and troubleshooting scenarios
- 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
- PayPal sues Google over mobile wallet technology
- Billionaire Zuckerberg kills to eat
- Aurasma: Augmented reality future or forgettable fun?
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).