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

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

A CLR UDT has a limit of 8000 bytes - I doubt thats big enough to pack a file into. I guess you could use custom serialization and store the compressed file in a different table using the ...

FlashVols are volumes that are pinned in SSD so applications run at maximum performance without the potential delay due to caching algorithms or tiering policies. Combined with Tegile's de-duplication ...

One of the long-standing differentiators between SQL Server’s Enterprise Edition (EE) and Standard Edition (SE), besides price, were the large number of features available only in EE. This is also ...