Skip to content

SQL Server Blog

Recent Posts

Improvements to machine learning capabilities in SQL Server 2019 

Many organizations seek to do more with their data than pump out dashboards and reports. Applying advanced analytical approaches such as machine learning is an essential arena of knowledge for any data professional. While database administrators (DBAs) don’t necessarily have to become data scientists, they should have a deep understanding of the machine learning technologies...Read more

Tools and commands for running SQL Server 2019 on Linux 

Organizations that embraced the option to run Microsoft SQL Server 2017 on Linux have been looking forward to the release of SQL Server 2019. Regardless of which operating system (OS) you choose, it’s the same SQL Server database code, and includes even more of the same features and services as the Windows release. This introductory...Read more

What’s new with SQL Server 2019 Linux features 

With SQL Server 2017, Microsoft entered the world of multi-OS platform support for SQL Server. For many technical professionals, the ability to run SQL Server on the same open source operating system as the rest of the application stack is not just a goal, but a dream that Microsoft made come true. With the release...Read more

How to configure persistent memory for SQL Server on Linux 

With the release of SQL Server 2019 on Linux, Microsoft introduced persistent memory (PMEM) support on Linux. This is an exciting development, as previous versions of SQL Server on Linux didn’t support PMEM. Let’s look at how to configure the PMEM for SQL Server on Linux. SQL Server 2016 introduced support for non-volatile DIMMs and...Read more

How to deploy SQL Server 2019 Big Data Clusters 

SQL Server 2019 Big Data Clusters is a scale-out, data virtualization platform built on top of the Kubernetes container platform. This ensures a predictable, fast, and elastically scalable deployment, regardless of where it’s deployed. In this blog post, we’ll explain how to deploy SQL Server 2019 Big Data Clusters to Kubernetes. First, the tools Deploying...Read more

Reflections on PASS Summit 2019 from the SQL Tools Team 

Last September at Microsoft Ignite 2018, Rohan Kumar, Corporate Vice President of Azure Data, announced the general availability of Azure Data Studio. This month, a little over a year later, Azure Data Studio took PASS Summit 2019 by storm, from keynote demos to community sessions to customer conversations at the Microsoft booth, we experienced overwhelming...Read more

Five essential skills for today’s database administrators 

DevOps, the cloud, and new database technologies mean our jobs as database administrators (DBAs) are changing at an ever-faster pace. If you’re fascinated by data and all the things you can do with it, it’s a thrilling time to be in the business. Here are five of the skills we see as essential parts of...Read more

Build an intelligent analytics platform with SQL Server 2019 Big Data Clusters 

In the most recent releases, SQL Server went beyond relational data and enabled support for graph data, R, and Python machine learning, while making SQL Server available on Linux and containers in addition to Windows. At the same time, organizations are challenged with the amount of data stored in different formats, in silos, and the...Read more

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...Read more

State of the SQL Server tools 

This week we’re announcing the general availability of SQL Server 2019, a significant milestone for Azure Data and for SQL Server customers. This presents a good moment to give an update on the state of tooling for SQL Server. Since SQL Server 2016, the tools for SQL Server have been released independently “out of box”...Read more

The November 2019 release of Azure Data Studio is now available 

Today we are announcing the November release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started. Please note: After downloading Azure Data Studio, say Yes to enabling the preview features so that you can use the extensions. Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals...Read more