Change Event Streaming (CES) in SQL Server 2025 and Azure SQL enables event-driven architectures by streaming JSON records from table activity to Azure Event Hub, with Entra support now available in ...
Monitoring database health is essential for maintaining optimal performance in any SQL Server environment. One of the most powerful built-in mechanisms for tracking performance is SQL Server ...
MySQL and PostgreSQL are two of the most used open source SQL databases, and both fulfill the role of a general-purpose database well. How do you choose which one to use for a project? Let's look at ...
Understanding what SQL Server is currently doing can be quite challenging, especially if you are not a database administrator. Besides identifying which queries are being executed, you can also ...
Gain insights from all your data by querying across your entire data estate—SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Azure Cosmos DB, MySQL, PostgreSQL, MongoDB, Oracle, Teradata, and ...
Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...
A Java-based SQL Server Profiler tool that monitors and analyzes SQL Server database activities, referencing the .NET project ExpressProfiler. emp-sqlserver-profiler is a lightweight, cross-platform ...
This project is largely based off of a fork of the SignalR Core Redis provider, reworked to use the underlying concepts of the classic ASP.NET SignalR SQL Server backplane. This means it supports ...
As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...