SQL Server

News and technical articles about Microsoft’s SQL Server

How to deal with Scheduled Maintenance Mode and SQL Always On

First published on TECHNET on Mar 08, 2018 UPDATE: November 2018 the 9 th – For SCOM 2016 only this issue has been fixed in UR6 Hi everyone, Bruno here. Today I will cover a topic that came to my attention several times, without being previously discussed broadly and deeply. The topic: Have you ever […]

How to deal with Scheduled Maintenance Mode and SQL Always On Continue Reading

Performance troubleshooting using new Azure Database for PostgreSQL features

At Ignite 2018, Microsoft’s Azure Database for PostgreSQL announced the preview of Query Store (QS), Query Performance Insight (QPI), and Performance Recommendations (PR) to help ease performance troubleshooting, in response to customer feedback. This blog intends to inspire ideas on how you can use features that are currently available to troubleshoot some common scenarios. A

Performance troubleshooting using new Azure Database for PostgreSQL features 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

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

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