OK, so it’s one week to Christmas and I have to resort to a holiday theme of some sort. Things are a bit laid back this year. Our family has resorted to the Secret Santa thing to reduce the number of ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

Using compression with SSMS is just as easy. Simply set the compression option on the Options page of the Back up Database dialog. You may be asking yourself: How effective is this compression? The ...

SQL Server’s first attempt at Data Compression actually looks pretty good. As I noted in my beta preview (see “Microsoft’s ‘Katmai’ is filled to the brim”), SQL Server 2008 provides two types of ...

Microsoft's latest relational database management system contains a host of new features, but are they enough to make you migrate? The wait is over. Microsoft has finally released SQL Server 2008, the ...

Data Compression, PowerShell integration, and Policy-Based Management, not to mention Server Groups, should make a big splash in almost any environment. Just keep in mind that the benefits you get ...

Just keep in mind that the benefits you get from Data Compression (which works at the page level, replacing repeating data with lookup pointers) will depend on the nature of the data in your table and ...