Yes, you read it right, Service Pack 1 to SQL Server 2008 R2 was just released. This service pack (as ever) is a bundle of all the cumulative updates thus far for SQL Server 2008 R2. It includes, amongst others, the following things: DMVs for increased supportability DAC Framework for improved database upgrades Disk space control for PowerPivot And while you're looking into the SQL Server 2008 R2 SP1 download , you can also check out the Denali CTP3 download as well (they've been busy as...
Well I guess this Microsoft's way of telling you that you should install already the SQL Server 2005 Service Pack 2 , as the Lifecycle Supported Service Packs has announced that the support for SQL Server 2005 Service Pack 1 will end on the 8th of April 2008.
I'll start by describing Data Dude (or DB Dude) first to all of us who don't use it, now shall I? It's a tool for the management of databases, enabling you to keep track of version history of a database with a source control on the scripts that build the database. The tool was first introduced to the very talented DBA in my department – Boris Kogan – by Maor David from SRL. Boris was obviously very pleased to have a bit of work and headache saved with this new tool. Just a week ago, Microsoft released...