SQL Server

News and technical articles about Microsoft’s SQL Server

Transforming your data in Azure SQL Database to columnstore format

We are excited to reveal a public preview of a new feature in Azure SQL Database, both in logical server and Managed Instance, called CLUSTERED COLUMNSTORE ONLINE INDEX build. This operation enables you to migrate your data stored in row-store format to the columnstore format and maintain your columnstore data structures with the minimal downtime […]

Transforming your data in Azure SQL Database to columnstore format Continue Reading

Azure Backup can automatically protect SQL databases in Azure VM through auto-protect

We are excited to share the auto-protection capability for SQL Server in Azure Virtual Machines (VM). This is a key addition to the public preview of Azure Backup for SQL Server on Azure VM, announced earlier this year. Azure Backup for SQL Server is an enterprise credible, zero-infrastructure pay as you go (PAYG) service that

Azure Backup can automatically protect SQL databases in Azure VM through auto-protect Continue Reading

Automate Always On availability group deployments with SQL Virtual Machine resource provider

We are excited to share that a new, automated way to configure high availability solutions for SQL Server on Azure Virtual Machines (VMs) is now available using our SQL VM resource provider. To get started today, follow the instructions in the table below. High availability architectures are designed to continue to function even when there

Automate Always On availability group deployments with SQL Virtual Machine resource provider Continue Reading

Modernize your Java Spring Boot application with Azure Database for MySQL

This blog post is co-authored by Parikshit Savjani, Senior Program Manager, Azure OSS Database service. Spring is a well-known Java-based framework for building web and enterprise applications addressing the modern business needs. One of the advantages of using the Spring Boot framework is that it simplifies the data access from relational and NoSQL data stores. Spring

Modernize your Java Spring Boot application with Azure Database for MySQL Continue Reading

Azure Hybrid Benefit for SQL Server on Azure Virtual Machines

Azure Hybrid Benefit (AHB) for SQL Server allows you to use on-premises licenses to run SQL Server on Azure Virtual Machines. If you have Software Assurance, you can use AHB when deploying a new SQL VM or activate SQL Server AHB for an existing SQL VM with a pay as you go (PAYG) license. Bring

Azure Hybrid Benefit for SQL Server on Azure Virtual Machines Continue Reading

SSMS 17.9.1 is now generally available

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9.1. Download SSMS 17.9.1 today and for details please see the Release Notes. This is a minor update to 17.9 with the following important improvements: Occasionally, SSMS closes MFA query editor connections with no outstanding transactions. A simple way to repro this

SSMS 17.9.1 is now generally available Continue Reading

Real-time event processing with Azure Database for PostgreSQL and Event Grid integration

Most modern applications are built using events whether it is reacting to changes coming from IoT devices, responding to a new listing in a marketplace solution, or initiating business processes from customer requests. PostgreSQL is a popular open source database with rich extensibility to meet the event-based notification and distributed design needs of the modern

Real-time event processing with Azure Database for PostgreSQL and Event Grid integration Continue Reading

Create Azure SQL Managed Instance using Azure CLI

Azure command line interface (CLI) is a set of commands that you can use to create and manage Azure resources. In this post your will see how can you create Managed Instance using Azure CLI. The Azure CLI is Microsoft’s cross-platform command-line experience for managing Azure resources. You can use it in your browser with

Create Azure SQL Managed Instance using Azure CLI Continue Reading

What Azure permissions are required to create SQL Managed Instance?

Azure SQL Managed Instance is a fully managed SQL Server Instance hosted in Azure cloud that is placed in your Azure VNet. Users who are creating instances need to have some permissions. In this post you will see the minimal permissions required to create managed instance. If you are owner of your Azure subscription, you

What Azure permissions are required to create SQL Managed Instance? Continue Reading

SQL Server IaaS Extension Query Service for SQL Server on Azure VM

SQL Server IaaS Extension is installed by default on Azure virtual machines deployed from SQL Server based images on Azure Market Place. SQL Server IaaS extension manages SQL Server configurations on the VM including SQL server connectivity, storage configuration, automated backup, automated security patching and AKV integration. SQL IaaS Extension automates all these administrative tasks

SQL Server IaaS Extension Query Service for SQL Server on Azure VM Continue Reading