Topic: Data warehousing

Published 
2 min read

New in Azure Synapse Analytics: CICD for SQL Analytics using SQL Server Data Tools 

At Microsoft Ignite 2019, we announced Azure Synapse Analytics, a major evolution of Azure SQL Data Warehouse. The same industry leading data warehouse now provides a whole new level of performance, scale, and analytics capabilities. One of these capabilities is SQL Analytics, which provides a rich set of enterprise data warehousing features.
Published 
2 min read

SQL Server 2017 achieves top TPC benchmarks for OLTP and DW on Linux and Windows 

Once again, SQL Server 2017 has led the pack with three new TPC benchmarks published in April 2019, ranking SQL Server 2017 as the fastest database for online transaction processing (OLTP) and data warehouse (DW) workloads on Windows and Linux. Together with our partners, SQL Server continues to innovate with high-performing, enterprise-ready solutions that deliver unparalleled price performance.
Published 
6 min read

SQL Server 2019 preview combines SQL Server and Apache Spark to create a unified data platform 

Today at Ignite, Microsoft announced the preview of SQL Server 2019. For 25 years, SQL Server has helped enterprises manage all facets of their relational data. In recent releases, SQL Server has gone beyond querying relational data by unifying graph and relational data and bringing machine learning to where the data is with R and Python model training and scoring.
Published 
2 min read

Gartner names Microsoft a leader in the Magic Quadrant for Data Management Solutions for Analytics (DMSA) 

This post was authored by Rohan Kumar, General Manager, DS SQL Engineering. We’re excited that Gartner has recognized Microsoft as a leader in the Magic Quadrant for Data Management Solutions for Analytics (DMSA). Gartner defines the DMSA as a system for storing, accessing, processing, and delivering data intended for one of the primary use cases that support analytics.
Published 
<1 min read

Windows Server 2016 and SQL Server 2016: Leveraging Hyper-V large-scale VM performance for in-memory transaction processing 

This post was authored by Liang Yang, Principal Performance Engineer on the Hyper-V team and Jos de Bruijn, Senior Program Manager on the SQL Server team. With Windows Server 2016, Microsoft has significantly bumped up the Hyper-V Virtual Machine (VM) scale limit to embrace new scenarios such as running e-commerce large in-memory databases for Online Transaction Processing (OLTP) and Data Warehousing (DW) purposes.
Published 
1 min read

Analytics Platform System Update 4 Generally Available 

Matt Usher, Senior Program Manager, DS SQL Engineering We are pleased to announce the general availability of Appliance Update 4 for the Microsoft Analytics Platform System. The Microsoft Analytics Platform System is a turnkey big data analytics appliance, combining Microsoft’s massively parallel processing (MPP) data warehouse technology with HDInsight, Microsoft’s 100% Apache Hadoop distribution, and delivering it as a turnkey appliance.
Published 
1 min read

Explore In-Memory Technologies at Ignite 

You’ve probably already heard why you should use the in-memory tech built into Microsoft SQL Server: 30 times faster transaction speed, 100 times the query speed, and millions of rows of data analyzed every second. If you want to learn more about the how, check out the Microsoft Ignite session with the no-nonsense title, In-Memory Technologies Overview.