skip to Main Content

Azure Synapse Analytics, the Next Evolution of Azure SQL Data Warehouse

Microsoft AzureMicrosoft has launched Azure SQL Data Warehouse as Azure Synapse Analytics. Taking its data-warehouse solution to the next level in both performance and capabilities.

With Azure Synapse, you can build, manage, collaborate and analyse your data all within the same service.

Key Features & Capabilities

  • This is the first and currently the only analytics system to run all TPC-H queries at petabyte-scale.
  • Data professionals can query both relational and non-relational data using the SQL language. Query using serverless on-demand queries or provisioned resources, the single service works for both.
  • The scale is limitless. Data professionals can optimize all queries with intelligent workload management, workload isolation and boundless concurrency.
  • Get insights from all your data at high speeds across data warehouse and big data analytics systems.
  • Azure Synapse is integrated with Power BI and Azure Machine Learning meaning business intelligence and machine learning is built-in.
  • Effortlessly apply intelligence to all your data, whether it is from Dynamics 365, Office 365 or SaaS services.
  • The Azure Synapse provides an end-to-end unified experience in an integrated workspace for data prep, data management, data warehousing, big data, and AI tasks
  • Enjoy the advanced security and privacy features which are built into Azure. This includes automated threat detection and always-on data encryption.
  • Apply column-level security, native row-level security and dynamic data masking to protect data in real-time for fine-grained access control.

Find out More

Organizations can continue using their existing data warehouse workloads and new capabilities will be automatically applied as they come out of preview. On an immediate basis, organizations can put their data to work with Azure Synapse to enjoy higher speeds, security and increased productivity.


Post Terms: Azure SQL | Azure SQL Data Warehouse | Azure Synapse Analytics | Data Warehouse

About the Author

BC Comms Team

Our communications team bring you Ballard Chalmers announcements, client news, technical updates such as feature releases or end of support and social responsibility activities.

Our Technologies



Ballard Chalmers is one of the UK’s leading software development companies, specialising in engineering enterprise applications on the Microsoft Platform. We are principally dedicated to custom software development and integration for the Microsoft Cloud, as well as on-premises and hybrid systems. Our expertise is in Microsoft .NET and Azure, SQL Server, BizTalk Server, SharePoint Server and Xamarin.

01342 410223

[email protected]



This form collects your name and details so that we may answer you. Check out our Privacy Policy for full details on how we protect and manage your data.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

© 2020 Ballard Chalmers Ltd. All Rights Reserved

Back To Top