Joe Webb

Musing and observations about SQL Server, other technogies, and sometimes just life in general
posts - 85, comments - 857, trackbacks - 0

My Links


This blog has moved!

Click here for the new location.

Follow me on Twitter
Add to Technorati Favorites

Search this Blog


Post Categories

About me

January 2009 Blog Posts

Adding a column to every table in a database

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...

posted @ Thursday, January 15, 2009 8:59 AM | Feedback (23) | Filed Under [ T-SQL ]

Desktop Virtualization

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...

posted @ Wednesday, January 14, 2009 7:38 AM | Feedback (24) | Filed Under [ Other Technologies ]

Welcome 2009!

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...

posted @ Friday, January 02, 2009 8:36 AM | Feedback (0) | Filed Under [ Misc Community ]

Powered by:
Powered By Subtext Powered By ASP.NET