Aug 22, 2010
Something for the Weekend – SQL Server Links for the week 20/08/10
I hope you’ve had a great week!
Congratulations to Tracey Hamlin(@tracyhhamlin), Winner of the 2010 Exceptional DBA of the Year Award!
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Taking A Hint – A fantastic in depth article, courtesy of Brad Schulz, that walks the reader through a real world performance tuning scenario utilising Query Hints.
- How to change the SQL Replication Agent History Cleanup Job – A simple but important tip here, especially if you are administering high throughput OLTP topologies, courtesy of the Microsoft Replication Team Blog,
- Proper Usage of MAXDOP Setting When Compressing Indexes in SQL Server 2008/2008 R2 – Discussed here by Glenn Berry.
- This Blog Post Won’t Explain Anything – There’s been a lot of discussion regarding the PASS Directors nominations and the selection process involved. Thomas Larock provides his thoughts here.
- Thoughts On The 2010 PASS BoD Elections Candidate List – Kendal Van Dyke shares his thoughts on recent events.
- How To Find Duplicate Indexes – This is a powerful and often overlooked performance optimization opportunity. Find out how you can benefit from it using this excellent walk-through with example code, brought to you by Thomas Larock.
- How Do You Defragment Your SQL Server Indexes – Continuing the performance optimization theme, here are some interesting results of a Survey carried out by Brag McGehee, providing insight into how other SQL Server data professionals are administering the indexes in their environments.
- Integer List Splitting: A SQL Fable – Another great post, again coming to you from Brad Schulz.
- How to Performance Tune a VLDB on your Desktop – A discussion into some uses for SQL Virtual Restore, a relatively new product offering from RedGate.
SQL Server Upcoming Events
- UK SQL Server Usergroups
- Bracknell - 17th September – SQL Server CLR and T-SQL Functions – Colin Leversuch-Roberts aka GrumpyDBA, Data Tier Applications (DCA) – Neil Hambly
- Leeds - 15th September – Using XML data in SQL Server with Anthony Brown, and Martin Bell explores change management in SQL Server 2008 and Iain Kicks from Quest Software.
- Manchester - 16th September – User group evening with Allan Mitchell and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown.
- Cardiff - 23rd Septemeber – Chris Testa O’Neill will be creating a cube with SSAS, Ian Archibald from Attunity demonstrating their CDC products.
- Edinburgh - 7th October – Implementing Hierarchies using TSQL and the HierarchyId type and understanding aggregation problems (Tony Rogerson); TBD (Allan Mitchell).
- Leeds - 27th October – User group evening with Martin Bell and SQL Server and Virtualisation with Mike Kiersey.
- Manchester - 28th October – SQL Server Replication with Neil Hambly and Martin Bell explores change management in SQL Server 2008.
- SQLBits 7 – 30th September – 2nd October – The Seven Wonders of SQL. Pricing
- Keeping up with PASS - Useful links for keeping up with all the PASS community events, collated by BradMcGehee.
Misc Technology News
- PlayStation 3 ‘hacked’ by hardware crackers
- Ofcom report highlights ‘multi-tasking media users’ – Interesting to see how users now regularly consume multiple media streams in parallel.
That’s it for this week. If I’ve missed anything that you think deserves a mention this week then be sure to let me know! You can leave a comment below, send me an email or message me on Twitter(@JohnSansom).