More considerations for the clustering key – the clustered index debate continues!

OK, I've talked about the clustering key many times. Here, I thought I'd bring together one final series of details (and links) to help you really understand why I'm so adamant about DESIGNING a clustering key and not just letting SQL Server pick it for you (for example when it defaults to making the primary […]

Where in the World – Alaska – Part II

I thought I would get this done in one post but I realized quickly that it would take a couple! This is part II focusing on our trip in Alaska (Summer 2010). If you want to read a bit about the first part of the trip (Anchorage to Denali National Park to Seward), read this […]

Where in the World summary and other photography related stuff!

Paul's usually the one who writes our "where in the world" posts  (here's his category link) but after a few folks specifically came up to us at SQLConnections and SQLPass and told us how much they enjoyed our shots, I thought I'd put together a summary post with a few of my favorites and a […]

How much does that key cost? (plus sp_helpindex9)

OK, two in two days? What's wrong with me (is what Paul said) after he said – who are you and where is my wife? But, this one is a short one, specifically a follow-on to my prior post about "Disk space is cheap…" I did a bit of simple math on the internal overhead and […]

Disk space is cheap…

.  THAT'S NOT THE POINT!!! .  The simple point is that bad (or sloppy/lazy) design cannot be tuned. If you think that data type choice, nullability, keys – don't really matter – you won't scale. It is possible that you may completely fail because of this. Have you ever heard (or possibly said?), let's just […]

Exciting news for the Microsoft Certified Masters (MCM) Program!

Paul's blogged quite a few of the details here: Big changes to the MCM program and how SQLskills can help you and there's not too much to add except that we'll have some locations and dates to announce soon. And, we're tweaking our current Immersion Event training (even the one in San Diego, CA in December) […]

TSQL Tuesday – Why DBA skills are important

  Paul's hosting the T-SQL Tuesday theme this month and the theme revolves around DBA skills. Specifically, "why are DBA skills necessary?" His specific post is here: Invitation to participate in T-SQL Tuesday #12 – Why are DBA skills necessary?. This is a topic near and dear to me and one that I've found myself […]