What's New for SQL Server in Azure - September 2016

Author by Jes Borland

Microsoft has expanded their global presence again. Two datacenters are now available in the UK. This is great news for global companies striving to keep assets close to locations. Read Microsoft Azure now available from UK datacenters.

In addition to adding more datacenters, SQL Data Warehouse is available in more regions. 4 have been added - North Europe, Japan East, Brazil South, and Australia Southeast - to bring the total to 18. If you need to process large volumes of data - relational or non-relational - to populate data warehouses, you should be researching SQL Data Warehouse. You have the ability to take advantage of Massive Parallel Processing (MPP), scale processing power up or down, even pause it. And, you can do this without putting a single rack of equipment in your datacenter.

Within SQL Database, improvements have been made to the Advisor. These changes will return recommendations within a day, rather than the week previously used. You can read more about this improvement at Improved Automatic Tuning boosts your Azure SQL Database performance.

In the security space, Microsoft completed a second Azure Payment Card Industry (PCI) Attestation of Compliance (AoC) for 2016. Among the 40 services covered are SQL VMs, SQL Database, and SQL Data Warehouse; Power BI has now been added to this list. You can get more information from the Trust Center.

There have been several exciting improvements to the data experience in Azure this month!

Author

Jes Borland

Senior SQL Server Engineer