Select Page

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

Unified Azure SQL experience

Azure SQL is a modern SQL platform that provides simple discovery, creation, and management by unifying SQL Server offerings in Azure. In this platform, you will see an overview of all Azure SQL offerings along with a guided create experience ... continue reading
backup-database-audit.PNG

Track unauthorized backups using Azure SQL Managed Instance Audits

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
DP_Summit_LOGO-1.png

Meet the SQL Product Team at Data Platform Summit 2019

Several members of the SQL Team represented by Product Managers from Azure SQL Database (@azuresqldb) and SQL Server (@mssqltiger) Engineering will be speaking at Data Platform Summit 2019 (#DPS10), Asia’s Premier Data & Analytics Conference taking place on August 22-24 ... continue reading

Native database backup in Azure SQL Managed Instance

First published on MSDN on Oct 16, 2017 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 ... continue reading
QS_SSMS_Reports_m.jpg.png

Using Query Store with least privileges instead of db_owner to archive Separation of Duties

When using the Query Store in a production environment, sometimes customers need to delegate very specifically who can do what in terms of Performance Analysis and/or Tuning. The Query Store is a component that can be activated per database and ... continue reading
Screenshot of the Windows Admin Center - Azure Hybrid Center

Run Windows Server and SQL Server workloads seamlessly across your hybrid environments

In recent weeks, we’ve been talking about the many reasons why Windows Server and SQL Server customers choose Azure. Security is a major concern when moving to the cloud, and Azure gives you the tools and resources you need to ... continue reading