I hope you’ve had a great week!
If you have not seen it already, you have to watch this but make sure you wear headphones as it’s not suitable for work (NSFW): Hilarious Video: Relational Database Vs NoSQL Fanbois
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Where Have All The Good Managers Gone? – Brilliant thought provoking post from Thom Larock(@SQLRockstar), that looks at the myth behind where all the expert DBA’s have gone. This is really well written and I encourage you to take a look.
- SQL Server DBA Scripts: How to Find Slow SQL Server Queries – Brent is back and is it just me or does he seem to be a tad bit more cocky. Dam, so would I be had I landed an awesome gig with the clever folks at SQLSKills! Glad to have you back blogging regularly.
- A Better DBA Job Description For Everyone – The second contribution from Thom this week, which also stirred up a lot of discussion, looks at how to write a better job description by providing a real world example of what not to do.
- Tuning Tip: Identifying Overlapping Statistics – An interesting performance tuning tip here from Kendal Van Dyke and not one that I have come across previously.
- Moving Away From Relational Storage – Introduction – Jeremiah Peschka discusses.
- More On Overlapping Statistics – The follow up to Kendal Van Dyke statistics post earlier in the week.
- Links for Patterns and Practices for the Data Professional – Some weekend reading here with this very useful list of references from Buck Woody.
SQL Server Upcoming Events
- 24 Hours of PASS Kicks off next week – Make sure you set aside time in your week to get some free SQL Server training streamed live right to your desk!
- SQLBits 7 – 30th September – 2nd October – The Seven Wonders of SQL.
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.
- Maidstone – 22nd September – Kent User Group – Analysis Services (Andrew Calvett), TSQL Techniques (Dave Ballantyne)
- 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.
Misc Technology Posts
- Scale-out vs Scale-up – An excellent discussion of these two often contrasted architecture solutions.
- Hilarious Video: Relational Database Vs NoSQL Fanbois – If you have not seen it already, you have to watch this.
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 emailor message me on Twitter(@JohnSansom).