I hope you’ve had a great week!
Make sure you don’t miss out on posts by Subscribing to the Blog Feed. You can also receive this Blog feed via Email.
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.
Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.
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).