Monthly Archives: November 2014

Personal Development

This editorial was originally published on July 14, 2010. It is being re-run as Steve is on holiday. When we go to upgrade an instance, most of us have a process. We have a list of things we need to … Continue reading

Posted in Editorial | Tagged

Minimal Meetings

This editorial was originally published on April 24, 2010. It is being re-run as Steve is out of town at the PASS Summit. I read something the other day that struck me. It’s obvious, but I hadn’t really thought about … Continue reading

Posted in Editorial | Tagged

Consolidating Again and Again and Again

This editorial was originally published on November 12, 2009. It is being re-run as Steve is on holiday.  In reading about virtualization, one of the main things that drives its acceptance is cost. It’s the reduction in actual physical resources … Continue reading

Posted in Editorial | Tagged ,

Placeholders for Emergencies

A long time ago I worked in a large corporation where we managed lots of servers, each of which performed a variety of different functions. Some were Exchange, some SQL, some file servers, etc. and they would come and go … Continue reading

Posted in Blog | Tagged , | 7 Comments

How Often Does Production Drift?

One of the new products that Red Gate Software is working on is SQL Lighthouse, which is designed to track and alert you on “database drift“, which are the changes in your schema. I hadn’t really heard the concept in the past, though … Continue reading

Posted in Editorial | Tagged , , , ,

Off

I’m off for a few days. Actually, today and most of next week. I completed my achievement, getting all my vacation scheduled, and this one of those days. I also have most of next week off, so I’ll be taking … Continue reading

Posted in Blog | Tagged

Real World T-SQL Tricks

I’ve been playing more with T-SQL this year, doing some testing and development in various places. I’ve been trying to improve my skills, and keeping up with the advancements the language has made in the last few versions. Like many … Continue reading

Posted in Editorial | Tagged ,

Encryption in Colorado Springs – Encrypting in the Application?

Last night was my annual presentation at the Colorado Springs SQL Server User Group. I try to make sure I get down there at least once a year, and it’s been only once a year for the last few years. … Continue reading

Posted in Blog | Tagged , , , ,

Achievement Unlocked: Balance 0

Earlier this week I got a notice that I hadn’t completed a task this year. It’s one that I’ve rarely finished in the past, and probably not in any year in the last 10. However I decided this year that … Continue reading

Posted in Editorial | Tagged

Practical Problems with CI

I agree. Continuous Integration has issues in the real world, at least it probably does in many companies. The more tests you have, the more likely you refactoring or changes will break something. The more things break, the more people … Continue reading

Posted in Blog | Tagged , | 2 Comments