I hope you’ve had a great week!
Subscribe to the Blog Feed now to ensure you catch all posts. Don’t miss out on your weekly fix of SQL Server Links, community news and technology banter. You can also receive posts via Email.
The regulars will know that I really enjoy reading and not just about SQL Server. I’m very interested in Professional/Personal Development, in case you had not guessed from some of my posts, as well as economics, blogging, marketing and even the odd lighter read too. There’s a lot of great stuff out there and I wanted to share with you what I have enjoyed reading, both SQL server titles and more.
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links

Replication = SQL Marmite
- Removing duplicate indexes – Duplicate indexes have the potential to hurt your performance, fact! Kimberly Tripp (Blog|Twitter) shared her excellent stored procedure code that will help you identify those obvious and more importantly not so obvious, duplicate indexes within your databases.
- Join Performance, Implicit Conversions, and Residuals – Extremely interesting post this week form Paul White (Blog|Twitter), sharing more SQL query tuning internals. If you’re a DB Dev you really want to get your head around this information and to educate/share the knowledge with your coding teams and data modellers.
- The Difficulty with Deadlocks – An impressive look at Deadlocks from Jeremiah Peschka (Blog|Twitter) this week. Discussions focus on good design and architecture rather than diagnosis.
- USE GUID’S (UNIQUEIDENTIFIER) FOR KEYS WHEN STORING DATA ON SSD’S (PART 2 – INITIAL DATABASE SCHEMA) – I almost decided not to include this post because of the ridiculously long title but then to be expected from academic types I suppose ;-) Some thought provoking discussions on SSDs from Tony Rogerson (Blog|Twitter). Be sure to check out Part 1 too!
- Land a Dream DBA or Developer Job: Seven Questions to Ask – Great advice courtesy of Kendra Little (Blog|Twitter).
- Stored procedure recompile caused by alter table on temp table – Another real world customer case from the CSS SQL Server Engineers (Blog).
- ACID Properties By Example (And Counterexample) Part Zero – Michael J. Swart (Blog|Twitter) kicking off his new post series on ACID, in his characteristic unique and creative style.
- How to find replicated tables – In the words of our author “Replication is the SQL equivalent of Marmite”, so so true. Richard Douglas (Blog|Twitter) shares some Replication wisdom.
- Denali SQLPS First Impressions – A sneak peak of what’s to come in Denali for PowerShell courtesy of Chad Miller (Blog|Twitter).
UK SQL Server Upcoming Events
- SOUTHAMPTON – Wed 10 Aug – Neil Hambly presenting on partitioning and John Q Martin Esq presenting SQL Server, the DBA and Compliance.
- CARDIFF – Thu 11 Aug – Why are we Waiting…a 2 hour deep dive session into Wait Types and performance tuning with Neil Hambly
- EDINBURGH – Wed 17 Aug – Reporting Services and Sharepoint Integration with Rob Carrol
- LONDON – Thur 18 Aug –
- SURREY – Thu 18 Aug – A packed evening covering Business Intelligence, Denali and a newcommer’s first session!
- MANCHESTER – Wed 24 Aug – Replication by Neil Hambly and Cube versus tables with Steve Powell at the Coop
- LEEDS -Thu 25 Aug – XQuery Fundamentals with Neil Hambly
Misc Technology Posts
- Fake Apple stores found in Kunming city, China
- Google to warn PC virus victims via search site
- Google+ and the friends v acquaintances debate
That’s it for this week. If you’ve read a post this week that you think deserves a mention be sure to let me and other readers know by using comments section below. You can also reach me on email and find me on Twitter(@JohnSansom).
Have a great weekend!