Skip to content

SQL Server Blog

Recent Posts

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

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. Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the...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

Azure Migration Virtual Event: Best practices for Windows Server and SQL Server 

Many customers impacted by end of support for Windows Server and SQL Server 2008 and 2008 R2 are considering migrating to the cloud. With security and compliance being key drivers, the move from on-premises infrastructure to the cloud seems more obvious now than ever. Migration is the first step in the journey to the cloud...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

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