Monthly Archives: April 2015

April Blogger Challenge 4–Filtered Index Limitations

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?

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

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

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

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

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

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

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

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

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