When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...
Microsoft confirmed Windows updates since Oct 13 leave SQL Server linked server connections open to Oracle and PostgreSQL.
Microsoft confirms recent Windows updates cause SQL Server performance and stability issues. An emergency fix is coming.
CPU issues have long been the bane of database and system administrators. I have worked on enterprise databases since the mid-1980s and seen three significant eras for CPU architecture and ...
One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...
Microsoft has confirmed that Windows updates released since the October 2026 Patch Tuesday are causing SQL Server performance and stability issues.
SQLDiag is a free tool that collects and centralises data from PerfMon, SQL traces, and other outputs (e.g. VBScript, T-SQL, DOS, custom script outputs). It can be run as a console app, windows ...
This Book aims to provide solutions to the most common problems encountered by the inexperienced (accidental) DBA. How does it fare? The premise behind the book’s title is that many DBA roles are ...
The problem is that after the October 13 (KB5126646) update, connections created by SQL Server linked server queries might remain open. According to Microsoft, "As additional queries are performed, ...
One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...