Select Page

Do you need more memory on Azure SQL Managed Instance?

Azure SQL Managed Instance is fully-managed SQL Server database engine where you can easily choose the size of the instance with the amount of resources you want to use. Sometime, it is hard to determine what instance size you need ... continue reading
The case of (un)explained – ConfigMgr Console Slowness After moving to SQL Always ON — Multi Subnet Configuration

The case of (un)explained – ConfigMgr Console Slowness After moving to SQL Always ON — Multi Subnet Configuration

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
D38K-2rU0AYUR0m.png

Public endpoint for SQL Database Managed Instance is available as of today

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
SQL Server Management Studio (SSMS) 18.0 released for general availability

SQL Server Management Studio (SSMS) 18.0 released for general availability

When I joined the SQL Tools team as a PM back in October 2018, my top priority was to release SQL Server Management Studio (SSMS) 18. I expected a fair amount of work but didnt realize how complicated the process ... continue reading
ClientCacheRefreshPolicy

Governance setting for cache refreshes from Azure Analysis Services

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
debugg.png

Azure AD Service Principal authentication to SQL DB – Code Sample

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
Step-By-Step: How to Configure A SQL Server 2008 R2 Failover Cluster Instance on Windows Server 2008 R2 In Azure

Step-By-Step: How to Configure A SQL Server 2008 R2 Failover Cluster Instance on Windows Server 2008 R2 In Azure

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
image002.png

Using a TCP proxy to connect to SQL Database over VPN

( 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

Simplify Always On availability group deployments on Azure VM with SQL VM CLI

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
Azure Data Studio – Setting up your environment

Azure Data Studio – Setting up your environment

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
Loading...