Select Page
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
createnewSQLDB.png

Getting started with Azure SQL Database Hyperscale

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

The best practices for performance comparison between Azure SQL Managed Instance and SQL Server

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
SSMS Server Dashboard - CPU.png

Monitor CPU usage on SQL Server and Azure SQL

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
Gif image for creating a new automated machine learning experiement

A look at Azure’s automated machine learning capabilities

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
Step-By-Step: Creating a SQL Server Always On Availability Group

Step-By-Step: Creating a SQL Server Always On Availability Group

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
Step-By-Step: Creating a SQL Server AlwaysOn Availability Group

Step-By-Step: Creating a SQL Server AlwaysOn Availability Group

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
Software Update Dashboard by Collections

Software Update Dashboard by Collections

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

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
ConfigMgr Console Slowness After moving to SQL Always ON - Multi Subnet Configuration

ConfigMgr Console Slowness After moving to SQL Always ON – Multi Subnet Configuration

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