News

First introduced in SQL Server 2012, columnstore indexes can give you major performance gains -- provided you have the right workloads. Here's how columnstore indexes work and what types of data ...
In Azure SQL Database you can also set a HISTORY_RETENTION_PERIOD (and should be able to do it in SQL Server 2017) to control how far back in time your history will extend. Converting Existing Table ...
Azure will default to the Standard pricing tier, but if you want to consider adding a higher-performance server for your SQL database, click the arrow to reveal Figure D. The basic pricing tier ...
If you've used Azure in the past, you probably know that there are two main ways to deploy SQL Server on Microsoft's cloud—Azure SQL Database, the PaaS offering; and Azure VMs running SQL Server.
A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.