Select Page
State of the SQL Server tools

State of the SQL Server tools

This week we're announcing the general availability of SQL Server 2019, a significant milestone for Azure Data and for SQL Server customers. This presents a good moment to give an update on the state of tooling for SQL Server.Since SQL ... continue reading
Query.Results.png

T-SQL DDL support for Windows users migration from SQL Server databases to SQL Managed Instance

We are happy to announce a public preview for T-SQL DDL support for Windows domain users migration from SQL Server on-premises databases to SQL managed instance (MI) with Azure AD authentication. The migration process for databases from SQL Server on-premises ... continue reading

New Data Exposed episode: It’s just SQL: Native Backup and Restore

In this Data Exposed episode Alain Dormehl and Colin Murphy show you how easy it is to restore an existing SQL Database to Azure SQL Managed Instance. More information: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance ... continue reading
Blog1.png

Monitoring Azure SQL Database with Telegraf

In a prior blog, we had described the Real-time monitoring for Azure SQL Database Managed Instance using the Telegraf SQL plugin. In addition to Managed Instance support, Telegraf now also includes support for Azure SQL Database single databases, and can ... continue reading
Countdown to End of Support 2020!

Countdown to End of Support 2020!

All good things come to end and the end is nearing. What am I talking about you ask? That is end of support for several Microsoft server products in just 5 short months. Yes friends, in 5 short months there ... continue reading
backup-database-audit.PNG

Track unauthorized backups on Azure SQL Database Managed Instance using Auditing

Azure SQL Database Managed Instance provides T-SQL surface area functionalities that are very close to the SQL Server functional surface area. One of the SQL Server feature that is available in Managed Instance is taking the COPY_ONLY backups of the ... continue reading

Automate migration to SQL Managed Instance using Azure PowerShell and DbaTools

In Azure cloud, you can easily migrate your databases from SQL Server on-premises or Azure VMs to fully-managed PaaS database service – Azure SQL Managed Instance. In this post you will see how to create PowerShell scripts that automate migration ... continue reading

Automate migration to Managed Instance using PowerShell

In Azure cloud, you can easily migrate your databases from SQL Server on-premises or Azure VMs to fully-managed PaaS database service – Azure SQL Managed Instance. In this post you will see how to create PowerShell scripts that automate migration ... continue reading
io-perf.png

Increase data file size to improve HammerDB workload performance on General Purpose Managed Instance

General Purpose tier of Managed Instance uses Azure Premium Storage to store database files. In Azure Premium Storage IO performance depends on the file size. Increasing file size might be easy way to improve your performance. In this post you ... continue reading
DC1.png

Announcing the General Availability of SQL Data Discovery & Classification

We are excited to announce the general availability (GA) of SQL Data Discovery & Classification in Azure SQL databases, Azure SQL Data Warehouse and Azure SQL Database managed instance. SQL Data Discovery & Classification provide a set of built in ... continue reading