Read on for more detail on SQL Server Management Studio and management improvements, Resource Governor, Change Data Capture and nonlogged inserts, Data Compression, Backup Compression, index ...

Here's what else is cool: You can change the default compression behavior of your entire server. On the Database Settings tab of the Server Properties dialog, you can select the option Compress Backup ...

TPC-C compression results. I tested several tables in the TPC-C database with randomly generated ... management hooks and even skips the SQL-level of translation and talks to the storage engine ...

My last day in Seattle started with the key note session with David Dewitt of Microsoft who gave us an interesting lesson on “Shared Nothing” partitioning using distributed database strategies.