Select Page
Configure Azure Storage for SQL Database backups

Configure Azure Storage for SQL Database backups

SQL Server 2012+ and Azure SQL Managed Instance support native BACKUP commands that can backup a database to Azure Blob Storage URL. Setting-up Azure Storage account might not be so easy as you think because there are some constraints. You ... continue reading

Native database backup in Azure SQL Managed Instance

Azure SQL Managed Instance is a new fully managed PaaS offering in Azure cloud that will be publicly available in the near future. It will expose entire SQL Server Instance, support almost all features available in SQL Server 2017 and ... continue reading
Enhancing query performance with Adaptive Query Processing in SQL Server 2017

Enhancing query performance with Adaptive Query Processing in SQL Server 2017

This post was authored by Joe Sack, Principal Program Manager, Data Systems Group, Microsoft SQL Server 2017 and Azure SQL Database introduce a new generation of query processing improvements that will adapt optimization strategies to your application workload’s runtime conditions ... continue reading

ConfigMgr 1702: Adding a new Secondary Replica to an existing SQL AO AG

Hello everyone, Our colleague Umair Kahn has a helpful post on his blog where he and Sean Mahoney walk through adding a new secondary replica node to an existing SQL Server Always On availability group for a primary site server ... continue reading

Configuration Manager SQL queries for helping the IT Pro report on KBs related to MS17-010

NOTE: This information is now available in multiple languages in the Microsoft Knowledge Base article Configuration Manager SQL Server queries for compliance reporting related to MS17-010. The following is shared by CSS Support Escalation Engineer Vinay Pamnani, to help give ... continue reading
60916-01

Configuring Email Notification for Configuration Manager Reports

This blog is a step-by-step example for the configuration of email notification for Configuration Manager Reports and well as for deleting the email subscriptions. We will also cover a bit of background changes (like in database & SSRS Config file) ... continue reading
SuperServer 2028U-TRT+

Ultimate Performance for Database Storage with Windows Server 2016 and Hyper-converged Infrastructure

High-performing all flash array storage solution using Storage Spaces Direct on Windows Server 2016continue reading