Skip to content
SQL Server Blog

Migrate SQL workloads to the cloud with confidence 

Wouldn’t it be great if you could see how a workload will perform in a new environment before migrating a database to the cloud? Then you could fix any queries that have compatibility errors or move forward with the migration with confidence. That type of crystal ball is essentially what Microsoft gives us in the...Read more

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. Learn about other options for running Microsoft SQL Server in Azure in...Read more

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. Nearly 100 percent compatible with the latest SQL Server on-premises database engine, this fully managed service...Read more

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. For our purposes, I’m going...Read more

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? If you’re ready to learn more about moving...Read more

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. If you’re still...Read more

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

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