Something for the Weekend – SQL Server Links 22/07/11

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).