In-Depth Laying the Groundwork for Microsoft SQL Server 2008 Redmond's new database server is a complex product often running mission-critical apps. You can't afford to not get it right. By Josh Jones ...

At first glance, I was a bit critical of the latest version of the Upgrade Advisor. Well, after going through that painful process, I proceeded onto my upgrade from SQL Server 2005 to 2008 using the ...

For instance, if you copy a SQL 2000 database to SQL Server 2008, the new copy is an upgrade to the new internal format but retains a Compatibility Level of “80” which represents SQL 2000 aka SQL 8.0.

While the situation at each organization is unique, there are three broad classes of users that will look to upgrade to SQL Server 2008: existing SQL Server 2000 users (possibly concerned about ...

The company I work at started very small but has been growing at a silly rate for the last few years now. They started with a server that was sharing a few other duties and also running the SQL DBs.

New BI and reporting features in SQL Server 2008 R2 hit the mark, but other additions leave SQL Server shops wanting more With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its ...