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

Troubleshooting Database Mail issues in Azure SQL Managed Instance

Azure SQL Database - Managed Instance enables you to directly send the email messages to the external email servers. You can send email messages directly using sp_send_dbmail procedure or via SQL Agent Jobs as alerts. Learn more about Database Mail ... continue reading

Do you need to 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
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
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
SQL Vulnerability Assessment now supports Azure SQL Data Warehouse and Azure SQL Database Managed Instance

SQL Vulnerability Assessment now supports Azure SQL Data Warehouse and Azure SQL Database Managed Instance

First published on MSDN on Sep 25, 2018 SQL Vulnerability Assessment is now available for Azure SQL Data Warehouse and for Azure SQL Database Managed Instance. The assessment functionality and experience are similar to that of SQL Vulnerability Assessment for ... continue reading
Back up SQL Server in Azure VM using Azure Backup.

Enterprise-scale Backup for SQL Server Databases

More and more organizations are moving to the cloud to leverage the key benefits of agility and reduce overall cost. Its likely that at some point in time, your SQL Server will manifest as either of the three implementations in ... continue reading
Identify log write limits on Azure SQL Managed Instance using QPI library

Identify log write limits on Azure SQL Managed Instance using QPI library

Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. Managed Instance introduces some limits such as max log write throughput that can slow down your workload. In this post you will see how to identify ... continue reading
Running Azure CosmosDB queries from SQL Server using ODBC driver

Running Azure CosmosDB queries from SQL Server using ODBC driver

Azure CosmosDB provides ODBC driver that enables you to query CosmosDB collections like classic databases. In this post you will see how to query CosmosDB collections from Sql Server using Transact-Sql. Why querying CosmosDB from SQL Server? Cosmos DB enables ... continue reading