January 2009 Blog Posts
Despite the best laid plans, sometimes circumstances or project scope change and the definition of one or more tables in your database must be altered after they have been created. It's just a fact of life for a DBA.
Frequently these changes affect more than one database in your environment. The development, test, and eventually even the production databases must have their definitions updated to reflect the newly implemented changes.
For cases like this, I generally prefer to script out the necessary changes rather than using the Management Studio tools. Scripting reduces the likelihood of an unintentionally errant...
The past couple of years has seen a great increase in the interest of server consolidation and virtualization. Once considered an almost impossible to achieve ideal, today more and more companies are taking a serious look at its benefits. And those benefits are quite alluring.
I have talked with colleagues who swear by virtualization. They claim that when properly configured, SQL Server can perform every bit as well on a virtual server as when on a dedicated box. So for them, the benefits greatly outweigh any potential drawbacks.
Although I don't have a great deal of experience with server virtualization, I...
Happy New Years! (noise makers sounding in the background, confetti and streamers softly floating down behind me). I hope you all had a wonder New Year's Day holiday. Now it's back to work.
This fall was quite busy for me. I spoke at a couple of user group meetings, two conferences in two countries, and best of all received into this world a new son, Timothy. For anyone counting that makes four children for me and my wonderful bride of 11+ years.
I also received word yesterday that I was re-awarded as a Microsoft SQL Server MVP for 2009. It's the fifth...