OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...

A common task that all database and system administrators face is patching systems. Patching your systems is very important -- first and foremost, security fixes are included in patches. Patches also ...

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

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

Idera, Inc., a provider of database and IT productivity solutions, today announced the general availability of SQL Diagnostic ...

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

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

When operating web applications or business systems for many years, the 'database (DB) performance degradation problem' is something that cannot be avoided.Many engineers and web managers have likely ...