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
- How It Works: Timer Outputs in SQL Server 2008 R2 – Invariant TSC – Wisdom shared by the CSS SQL Server Engineer’s team.
- The New World of Work: Swarms – The changing landscape of the role of the Data Professional discussed here by Buck Woody(@Buck Woody). I’ve seen and taken part in these work groups myself. It would seem that they are becoming more common and so it’s important that as Data Professionals we understand how to leverage and be effective within them.
- SQL Server Trivia – A bit of SQL Trivia Fun here from Joe Web, although if I’m still undecided if it’s a good thing knowing the answers to these or not :-)
- Scripting Database Mail Configuration with Powershell and SMO – A useful Powershell script here from Jonathan Kehayias.
- Its all about the end result – Richard Douglass shares his thoughts on change control for the Data Professional. It’s not the most exciting topic but it is arguably one of the most important and Richard does an excellent job of putting forward findings from his experiences.
- Replication Gotcha: Blank XML – A nice find here from Kendal Van Dyke, highlighting a recently discovered Transactional Replication gotcha.
- Query performance and table variables – More from the real world customer case files of the CSS SQL Server Engineers team.
- Ten Things I Hate to See in T-SQL – Are some of your pet peeves on the list? Find out what gets on Michael J Swart‘s goat.
- T-SQL UDTs. (Huh!) What are they good for? – I still don’t know. Maybe here’s where we find out….
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
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).