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 ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...

Although there was significant fanfare surrounding SQL Server Query Store's initial release in SQL Server 2016, many companies have been hesitant about adopting the performance monitoring and ...

SQL Server performance tuning is a complex topic due to how layered it is. While performance problems can often be traced back to data storage issues, the performance tuning process is a "holistic ...

A popular performance tuning book gets updated for SQL Server 2025, how does it fare? Ian Stirk takes and in depth look and finds it pretty good. This well-liked SQL Server book examines performance ...

A popular performance tuning book gets updated for SQL Server 2022, how does it fare? This well-liked SQL Server book examines performance from various angles, but concentrates on improvements related ...

With so much hype around AI, generative AI and cybersecurity, it can be tough to generate excitement around something as ubiquitous as databases. But without that foundation, none of today’s tech – ...

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).

CAMBRIDGE, England--(BUSINESS WIRE)--As part of its ongoing mission to enable any organization to get the most value out of any database, on any platform, anywhere, Redgate’s popular database ...

SQL Server Drill Down explores all aspects of Microsoft SQL Server and related applications, with a particular emphasis on issues of interest to SQL Server data professionals. Key areas of focus ...

In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have ...