Monthly Archives: April 2015

April Blogger Challenge 4–Filtered Index Limitations

Posted on April 30, 2015 by

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to motivate and cheer people on. Filtered Index Limits I ran across a limitation recently with filtered indexes and was surprised. … Continue reading →

Posted in Blog | Tagged , , , , | 1 Comment

Is It Time to Upgrade?

Posted on April 30, 2015 by

There was a post from the SQL Server Data Platform Advisor the other day that noted it’s been almost 10 years since SQL Server 2005 was released and it’s time to upgrade. At least, if you want to remain in support. Microsoft … Continue reading →

Posted in Editorial | Tagged ,

Altering a column to add NOT NULL

Posted on April 29, 2015 by

I had to do this recently and needed to look up the syntax as I couldn’t remember it. I don’t do this often, but I was working on a particular item and wanted to test this. I had a table, … Continue reading →

Posted in Blog | Tagged , | 2 Comments

Dig Out the Root Cause

Posted on April 28, 2015 by

Early in my career in technology, I worked as a system administrator on a Novell network. Periodically we’d have crashes of servers on our network, or application failures, and while we understood that sometimes these were caused by transient errors, … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

The May Blogger Challenge–Continuing On

Posted on April 27, 2015 by

Last month I participated in Ed Leighton-Dick’s April Challenge. My four posts were tagged the April Challenge, and this month I plan to continue, and hopefully get a few more people to up their blogging. Building on April To make … Continue reading →

Posted in Blog | Tagged , , ,

Microsoft Exercise

Posted on April 27, 2015 by

Have we got a deal for you! Microsoft is concerned about the health of your company and is doing something about it. There’s a trend in modern society of obesity, complacency, and general laziness. Not only does is this bad … Continue reading →

Posted in Editorial | Tagged ,

Implementing Continuous Integration in Redmond

Posted on April 24, 2015 by

On May 15, 2015, Redgate Software and one of our partners, Northwest Cadence, will be presenting one of the DLM Training Workshops I helped build in Redmond, WA. I’m excited to be traveling up to WA for the event and … Continue reading →

Posted in Blog | Tagged , , ,

Code Reviews

Posted on April 24, 2015 by

When I first started to be paid money to write software, I worked on my own. I had to test my own code, decide when it could be deployed, and make the decision to deploy it. I had to notify … Continue reading →

Posted in Editorial | Tagged

Searching for Plans

Posted on April 23, 2015 by

Today’s editorial was originally published on Sept 13, 2010. It is being re-run as Steve is away at training. I was re-reading Conor Cunningham’s “Does Join Order Matter?” recently and found this quote in the post that stood out. As … Continue reading →

Posted in Editorial | Tagged ,

Security Through Chaos

Posted on April 22, 2015 by

This editorial was originally published on June 16, 2005. It is being re-run as Steve is away at training. I can’t really disclose who told me this, or at which company, but I found it very interesting. Recently there was … Continue reading →

Posted in Editorial | Tagged