Showing posts from September, 2023

How to persist SQL Agent job history in Azure SQL Managed Instance

Azure SQL Managed Instance provides a robust environment for running SQL Server workloads in the cloud. However, it does come with certain limitations, one of which revolves around the retention of SQL Agent job history. In t…

Uncovering High-CPU Queries: A Guide for Database Optimization

In the world of database management, identifying queries responsible for high CPU usage is paramount for maintaining optimal performance. This article will guide you through two essential SQL statements that can help you pin…

Load More
That is All