Every place I've ever worked has an irrational aversion to in-place upgrades. So the alternative is to prop up a new server / instance and migrate databases and redirect connections....

It became clear early in my 30 year career in IT that life had to be supplemented with physical activity. While IT is a physically non-demanding career, it is...

SSIS is a huge improvement over DTS and it created a framework for custom components that will carry ETL well into the future. Custom SharePoint Source integration is a...

I have my MCITP in SQL2K5 and SQL2K8 by way of the single upgrade exam 70-453. That single upgrade exam gave me both my MCTS and MCITP in SQL2K8....

Really? Just trying to save you some trouble. Enjoy.

The SQL Server Central Management Server does not require the registered servers to be SQL2K8. You can register SQL2K servers and execute T-SQL against them from a central location...

I remain confused by the purpose of this project. SQL Server 2008 provides Centralized Management Server which allows you to register all of your servers in a single location...

I subscribe to the "data is data" argument. A database developer works closer to the business rules than a DBA, however even with a developer, previous industry experience is...

Mark,

Best practices would dictate a separate POINTS table that held a row for each time points were added (or subtracted). This accomplishes two things. Normalized schema and an...

Oh grasshopper, you're digging a deep hole. All that is required as was stated earlier is DATEDIFF() using GETDATE() as one of your arguments, which will give you the...