SQL Server Team articles

Avatar photo
SQL Server Team
Published 
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 
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 
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 
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.