Posted on: February 8, 2017

It’s hard to believe, but it’s been less than a year since Microsoft announced the general availability of its incredible Azure SQL Data Warehouse. This move made it possible for the masses to access a SQL-based, petabyte-scale cloud solution for data warehousing that is also 100% managed! Suddenly, Microsoft fans found themselves empowered with the strength of the most elastic data warehouse possible, freeing up warehouse archiving on-site and improving big data analytical capabilities.

It’s no wonder, then, that the use of Azure SQL Data Warehouse exploded in 2016. Even major companies like MediaBrix have taken to the warehousing solution, improving their ability to gain valuable insights and heighten their business models. It’s been pretty amazing to watch the story unfold, but it’s even cooler to group everything together and see what a lasting mark Azure SQL Data Warehouse has already made in just a single year. So, as we head further into the new year, we want to pay tribute to all of the data warehouse’s accomplishments in 2016.

Availability on a Global Scale

As of the beginning of 2017, Microsoft Azure SQL Data Warehouse is now available in 23 regions across the globe. This fact is especially impressive when you consider the fact that nine of those regions have been added since July of 2016 alone. At this point, Azure SQL Data Warehouse is available in more regions than any other cloud provider, and we expect its growth to expand even more in the coming year.

Industry Leader for Analytics Queries

Microsoft Azure SQL Data Warehouse, which is powered by SQL Server, has proven itself to be a force to be reckoned with, having achieved industry-leading performance levels for analytic queries in 2016. Microsoft has worked relentlessly to improve data compression, as well as segment elimination, which reduces the IO each time large numbers of rows are processed. When batch mode is executed on top of columnstore, queries are sped up even further. The end result is that users are able to gain incredible insights with more simplicity and ease than ever before. 

Superior Migration, Monitoring, and SQL Tooling

One great thing that Azure SQL Data Warehouse did was to offer new updates to the entire Azure portal, as well as to the SQL Server Management Studio, which makes it possible for users to enjoy a much more seamless experience whenever they are loading, monitoring, or developing a SQL Data Warehouse. Users enjoy increased functionality and fast, simple access and management of all databases. 


When it comes to analytic look-up queries, the need for speed is a very real thing. The majority of such queries are generally bogged down, as they must aggregate large quantities of data and scan the columnstore segments. Unfortunately, this tedious process doesn’t always unveil the right information. Azure SQL Data Warehouse makes it possible to improve searches by quickly and efficiently seeking out that “needle in a haystack” nugget of information that makes all the difference. 

Getting On Board in 2017

If you haven’t yet embraced the power of Azure SQL Data Warehouse, we encourage you to get on board right now. Microsoft recently announced the availability of an exclusive one-month, free trial for those interested in seeing all that the incredible solution has to offer. Getting started early on in the year is the best way to make sure that you’re able to take advantage of everything that Azure SQL Data Warehouse will offer to businesses in 2017 and beyond.

Ready to get started? Reach out to us to learn more about Microsoft Azure SQL Data Warehouse right away. You’ll be absolutely amazed at all that this incredible Microsoft solution can do for your enterprise, both now and in the future.