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

Azure SQL Database Hyperscale (or Hyperscale for short) takes your database to the next level by removing size and query limitations typically found in cloud databases. Your database can scale up to 100 TB in size and handle more queries ... continue reading

One of the most common tasks that you are performing while migrating from SQL Server to Managed Instance is a comparison of workload performance between the source and destination instance. In this post you will see some recommended tools and ... continue reading

Monitoring CPU usage on your SQL Server or Azure SQL is one of the most important monitoring tasks in performance monitoring and troubleshooting. In addition, CPU usage is one of the most important parameters that you need to measure to ... continue reading

The automated machine learning capability in Azure Machine Learning service allows data scientists, analysts, and developers to build machine learning models with high scalability, efficiency, and productivity all while sustaining model quality. Automated machine learning builds a set of machine ... continue reading

One of the most requested features in SQL, from as far back as SQL 2012, has been Always On Availability Groups. This takes disaster recovery and high availability to a new level by enabling multiple copies of the database to ... continue reading

One of the most requested features in SQL, from as far back as SQL 2012, has been AlwaysOn Availability Groups. This takes disaster recovery and high availability to a new level by enabling multiple copies of the database to be ... continue reading

Hello everyone, Matt Novitsch (SCCM Premier Field Engineer) here to talk to you about a Power BI Dashboard that I created using SCCM data. <# Script Disclaimer. The sample scripts provided here are not supported under any Microsoft standard support ... continue reading

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

Hi there! Back to you with another installment of the unexplained series. Introduction 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 ... continue reading