Topic: Data warehousing
-
-
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. Today we are announcing the general availability of the highest requested feature -
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 -
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 -
SQL Server 2008 and 2008 R2 are reaching end of support. What’s next?
SQL Server 2008 and 2008 R2 have had a tremendous run. But all good things come to an end, right? On July 9, 2019, Microsoft will end Extended Support, which means no more updates or support of any kind, potentially leaving you vulnerable to security and compliance issues. The good news is, you still have -
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 -
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 -
Eight scenarios with Apache Spark on Azure that will transform any business
This post was authored by Rimma Nehme, Technical Assistant, Data Group. Since its birth in 2009, and the time it was open sourced in 2010, Apache Spark has grown to become one of the largest open source communities in big data with over 400 organizations from 100 companies contributing to it. Spark stands out for -
The elastic future of data warehousing
This post was authored by Joseph Sirosh, Corporate Vice President, Data Group. Announcing the general availability of Azure SQL Data Warehouse, an elastic, parallel, columnar data warehouse as a service. A defining characteristic of cloud computing is elasticity – the ability to rapidly provision and release resources to match what a workload requires – so -
Real-Time Operational Analytics Using In-Memory Technology
Operational workloads refer to the business transactions that are critical to running a business. For example, a retail store has a transactional system to create or modify new orders, and a credit card company tracks all charges made by vendors on behalf of its customers. These transactional systems are critical to businesses, as any downtime -
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 -
Azure SQL Data Warehouse opens for Limited Public Preview
By Tiffany Wissner, Senior Director, Data Platform At the Build conference in April, we announced Azure SQL Data Warehouse, our new enterprise-class elastic data warehouse-as-a-service. Today, we’re pleased to announce that Azure SQL Data Warehouse is open for Limited Public Preview. With growing data volumes, you have been telling us that you want to take -
Top reasons why enterprises should choose Azure SQL Data Warehouse
Guest post by Tiffany Wissner, Senior Director, Data Platform Yesterday at Microsoft’s Ignite conference, we demoed the first sneak peek of Azure SQL Data Warehouse. As you build more applications in the cloud and with the increase in cloud-born data, there is strong customer demand for a data warehouse solution in the cloud to manage -
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 -
APS Best Practice: How to Optimize Query Performance by Minimizing Data Movement
by Rob Farley, LobsterPot Solutions The Analytics Platform System, with its MPP SQL Server engine (SQL Server Parallel Data Warehouse) can deliver performance and scalability for analytics workloads that you may not have expected from SQL Server. But there are key differences in working with SQL Server PDW and SQL Server Enterprise Edition that one