Monthly Archives: May 2016

The Clustered Index is not the Primary Key

Posted on May 24, 2016 by way0utwest

I was reading through a list of links for Database Weekly and ran across this script from Pinal Dave, looking for tables where the clustered index isn’t the PK. It struck me that this is one of those facts I … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

What’s Your Test Plan?

Posted on May 20, 2016 by way0utwest

I ran across a post on upgrading a SQL Server instance, where the original poster (OP) was asking about a document to upgrade from SQL Server 2008 to 2014. That’s a big ask, especially as not many documents tend to … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on What’s Your Test Plan?

The Complexity of Branches

Posted on May 19, 2016 by way0utwest

Branching code is hard.  Well, branching isn’t hard. Just right click in some GUI or or type “git branch” and off you go. The actual branching of code is pretty simple and painless. In some sense, branching might be too … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Complexity of Branches

Changing a Computed Column–#SQLNewBlogger

Posted on May 18, 2016 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was working with a computed column the other day, and realized I had the wrong definition. In this … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Changing a Computed Column–#SQLNewBlogger