SQL Server Team, Author at Microsoft SQL Server Blog

Published March 26, 2020

2 min read

Use hyperscale for your most demanding cloud-born workloads

Sometimes resource demands increase beyond your expectations. Azure SQL Database service continues to meet your needs regardless of your speed of growth. The hyperscale service tier for a single database enables you to scale to 100 TB with fast backup and restore capabilities.

Published March 24, 2020

2 min read

Azure SQL Database managed instance vs. SQL Server

As organizations face increasing pressure to modernize their applications and infrastructure, the benefits of the cloud have become impossible to ignore. Fortunately, Azure SQL Database managed instance makes it easy to move your SQL Server workloads to the cloud.

Published March 23, 2020

3 min read

The March 2020 release of Azure Data Studio is now available

The March 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 preview features so that you can use extensions.

Published March 19, 2020

2 min read

How to provision a Linux SQL Server Virtual Machine in Azure

You’re an existing SQL Server customer and are looking to explore the fast-growing Linux operating system. Whether on-premises or in the cloud, Microsoft has you covered. With SQL Server 2017, and now SQL Server 2019, SQL Server is available on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu.

Published March 17, 2020

3 min read

Tips to select the best Azure SQL deployment option

When it comes time to migrate your SQL workloads to Azure, you have a choice of two main deployment options: SQL Server on Azure Virtual Machines and Microsoft Azure SQL Database. Each offers its own benefits, so how do you know which is right for your workload?

Published March 12, 2020

2 min read

When to use SQL Server on Azure Virtual Machines

Rearchitecting applications to run in the cloud can be a significant undertaking requiring time, money, and the appropriate skills. If you want to move existing on-premises apps to the cloud, but don’t have the necessary resources to rearchitect your applications, consider SQL Server on Azure Virtual Machines to get there quickly and easily.

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.

SQL Server Team articles

Use hyperscale for your most demanding cloud-born workloads

Azure SQL Database managed instance vs. SQL Server

The March 2020 release of Azure Data Studio is now available

How to provision a Linux SQL Server Virtual Machine in Azure

Tips to select the best Azure SQL deployment option

When to use SQL Server on Azure Virtual Machines

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

Explore SQL Server 2022