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

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

With every release of SQL Server come the new Microsoft certification exams. In 2000 we had the MCDBA. In 2005 and 2008 we had the MCTS and the MCITP. Now in 2012 we have the MCSA and the MCSE. (Not ...

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...

Sometimes, life really is like a box of chocolates. The same can also be said for software upgrades. Take, for instance, Visual Studio 2008. After all its various CTPs and RTMs, I feel like I've been ...