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

Those restrictions (and others) were removed in SQL Server 2016. There are still some limitations on memory-optimized tables: you can't use data compression with them; replication is only supported ...

Inline deduplication and compression reduce overhead for highly repetitive SQL Server workloads. “We've engaged with Microsoft to optimize performance and reduce the cost of SQL Server storage by ...