• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

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

July 22, 2011 by John Sansom 3 Comments

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

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
Use the SQL Server Event Calendar to keep informed of all upcoming SQL Server events, User Groups, and training opportunities here in the UK. You can also add this calendar alongside you existing Google calendar.

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!

Filed Under: Link Posts, SQL Server Community

About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy