Now is the time to migrate off SQL Server 2012, this blog looks at the options available: SQL Server 2019, Azure Virtual Machines and Azure SQL Managed Instance.
SQL Server Big Data Clusters was released with SQL Server 2019. It works by uniting the SQL engine with Apache Spark and Apache Hadoop, creating a single, secure and unified platform that extends the analytics capabilities beyond in-database processing of transactional and analytical workloads. The CU11 release in early July brought us some new capabilities for Big Data Clusters. The largest of which is the expansion of data encryption at rest.
In June, support for SQL Server in data flows (in Azure Data Factory and Azure Synapse) became generally available.
In this post, we focus on using SQL in Azure Synapse Analytics and conduct tasks such as creating tables and views, testing the tables, and formatting the data.
SQL Server Management Studio had four releases in 2020, and a lot of the known issues have now been resolved. Don’t forget that since version 18.7, Azure Data Studio is included with SQL Server Management Studio.