Hi there! Back to you with another installment of the unexplained series. If you ever get into an issue where things got slow after moving to SQL Always ON like 1 minute delay etc. while doing basic things in console ... continue reading

Public endpoint for Azure SQL Database Managed Instance provides the ability to connect to Azure SQL Database Managed Instance from the Internet without using a VPN and is for data communication only. Public endpoint for data can simultaneously coexist with ... continue reading

Built on the proven analytics engine in Microsoft SQL Server Analysis Services, Azure Analysis Services delivers enterprise-grade BI semantic modeling capabilities with the scale, flexibility, and management benefits of the cloud. The success of any modern data-driven organization requires that ... continue reading

The following application provides an example of using Azure AD Service Principal (SP) to authenticate and connect to Azure SQL database. This application measures the time it takes to obtain an access token, total time it takes to establish a ... continue reading

Intro On July 9, 2019, support for SQL Server 2008 and 2008 R2 will end. That means the end of regular security updates. However, if you move those SQL Server instances to Azure, Microsoft will give you three years of ... continue reading

( Reviewed by Srdan Bozovic ) Today customers connect to SQL Database from on-premises by allowing outbound traffic to well-known IP addresses for Azure SQL Database gateway for your Azure region that are documented here However, this traffic goes over ... continue reading

First published on TECHNET on Jul 05, 2017 Any time we see newly created work items stuck with a “New” status, it generally means that the Service Manager workflows are not processing or are processing slowly. Monitoring the “Minutes behind” ... continue reading

First published on TECHNET on Mar 21, 2017 There may be circumstances where creating SQL replica automatically over the network may not be possible due to network bandwidth constraint between DPM server and SQL server(situations where DPM and protected server ... continue reading

Always On availability groups (AG) provide high availability and disaster recovery capabilities to your SQL Server database, whether on-premises, in the cloud, or a combination of both. Manually deploying an availability group for SQL Server on Azure Virtual Machines (VM) ... continue reading

This blog entry comes from Buck Woody, who recently rejoined the SQL Server team from the Machine Learning and AI team. For those of you who havent met me or read any of my books or blog entries, its great ... continue reading