Learn how to use data compression in SQL Server, what are the benefits and trade-offs, and how to monitor and manage compressed data.

Do not try this at home. SQL Server 2008 Data Compression is an intelligent compression strategy. It saves space and delivers better performance through less IO.

An installable assembly for SQL Server that adds Deflate (the algorithm used by GZip) Compression functions for nvarchar values. Download the latest release from the Download page. Please note that ...

This is an example of using Sql Server Data Tools and Visual Studio to build a .dacpac file. The .dacpac file allows for automated deployment via TFS or any other CI/CD tool. The other project ...

In July 2024, SQL Server Stretch Database will be discontinued for SQL Server 2022, 2019, 2017 and 2016. Learn more.

Microsoft's SQL Server evolution. Microsoft is claiming a five-times data compression improvement in its in-memory column-store index technology in SQL Server 2014.

When copies are updated, only deltas are saved. Using this feature can result in dramatic savings when dealing with testing and development environments that utilize multiple instances of the same ...

Microsoft tests tool for migrating MySQL to SQL Server Ever since Oracle made overtures to buy Sun (and get MySQL in the process), Microsoft's been more of a MySQL foe than friend.

SQL Server 2016 delivers unparalleled performance and security built-in for your most mission critical transactional systems and data warehouses, along with an integrated business intelligence and ...