I hope you’ve had a great week!
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
- 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!