Monthly Archives: November 2014

Personal Development

Posted on November 28, 2014 by

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

Posted on November 27, 2014 by

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

Posted on November 25, 2014 by

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

Posted on November 24, 2014 by

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?

Posted on November 24, 2014 by

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

Posted on November 21, 2014 by

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

Posted on November 21, 2014 by

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?

Posted on November 20, 2014 by

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

Posted on November 20, 2014 by

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

Posted on November 20, 2014 by

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