SQL Server Team, Author at Microsoft SQL Server Blog

Events

Published February 19, 2020

3 min read

SQL Bits 2020 is happening in London: join us September 29 to October 4

It’s that time of the year when the Microsoft Azure Data engineering team is getting ready to participate at SQL Bits 2020. Excitement for this year’s show is everywhere, as SQL Bits provides us with a unique opportunity to learn, connect, and share with you, our SQL Server community.

Published February 13, 2020

2 min read

The February 2020 release of Azure Data Studio is now available

We are excited to share that the February release of Azure Data Studio is now available.

Published January 29, 2020

2 min read

The ultimate performance for your big data with SQL Server 2019 Big Data Clusters

Microsoft SQL Server 2019 Big Data Cluster enables intelligence over all your data and helps remove data silos by combining both structured and unstructured data across the entire data estate.

Published December 17, 2019

2 min read

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.

Published December 5, 2019

2 min read

Easier management of PolyBase and relational data through SQL Server 2019

The days when a database administrator (DBA) could specialize solely in a single database technology are rapidly ending. Today, we’re much more likely than ever before to be asked to bring together many types of data from diverse sources. Although specialization still has its place, having the knowledge and tools at our disposal to cross those boundaries makes us much more useful.

Published December 3, 2019

2 min read

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 an optimization called Tail of the Log Caching on NVDIMM.

Published November 19, 2019

2 min read

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.

Published November 12, 2019

2 min read

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 the modern DBA’s toolkit.

Published November 5, 2019

6 min read

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.

Published October 17, 2019

3 min read

Mssql extension for Visual Studio Code now has Object Explorer and IntelliCode

Today we’re introducing a new release for the mssql extension for Visual Studio Code which is now available! The mssql extension for Visual Studio Code is the official SQL Server extension that supports connections to SQL Server and rich editing experience for T-SQL in your favorite developer tool, Visual Studio Code. You can download the mssql extension and try out a tutorial to get started.

Published October 2, 2019

3 min read

The October 2019 release of Azure Data Studio is now available

Today we’re announcing the October release of Azure Data Studio (formerly known as SQL Operations 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 preview features so that you can use the extensions.

Published September 10, 2019

3 min read

The September release of Azure Data Studio is now available

Today we’re announcing the September release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio and review the Release notes to get started. Please note: After downloading Azure Data Studio, click Yes to enabling preview features so that you can use the extensions.

SQL Server Team articles

SQL Bits 2020 is happening in London: join us September 29 to October 4

The February 2020 release of Azure Data Studio is now available

The ultimate performance for your big data with SQL Server 2019 Big Data Clusters

Improvements to machine learning capabilities in SQL Server 2019

Easier management of PolyBase and relational data through SQL Server 2019

How to configure persistent memory for SQL Server on Linux

How to deploy SQL Server 2019 Big Data Clusters

Five essential skills for today’s database administrators

The November 2019 release of Azure Data Studio is now available

Mssql extension for Visual Studio Code now has Object Explorer and IntelliCode

The October 2019 release of Azure Data Studio is now available

The September release of Azure Data Studio is now available

Explore SQL Server 2022