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

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

SQL Server 2008 supports two levels of data compression – row and page level. There is also backup compression which is completely separate but very useful too. Row level compression looks at each ...

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

Embarcadero Technologies on Monday is unveiling its DBArtisan Workbench 8.0 database administration tool, featuring enhanced backup capabilities for Microsoft SQL Server databases and support for ...