Lukas Vileikis in Security and Compliance How to secure MySQL and PostgreSQL in the world of AI Learn how AI is transforming database security and discover best practices to secure MySQL and PostgreSQL against AI-driven threats, faster... 04 March 2026 11 min read 11
Matt Gantz in Database Administration Replacing a Column in a Large Active SQL Server Table In a previous post I showed how to use a batching strategy to remove large amounts of data from a... 19 June 2025 11 min read 11
Aaron Bertrand in Database Administration SQL Server 2025 ZSTD Backup Compression Guide SQL Server 2025 adds Zstandard (ZSTD) backup compression with LOW, MEDIUM, and HIGH levels. Compare ZSTD vs MS_XPRESS performance, syntax,... 11 June 2025 15 min read 1
Edward Pollack in Database Administration TempDB Resource Governor Space Controls in SQL Server 2025 This article was updated in September 2025 following the SQL Server 2025 (17.x) Preview release. TempDB is a system database... 09 June 2025 15 min read 21
Rodrigo Ribeiro Gomes in Database Administration Recover SQL Server Data Without Full Backup Recover deleted or updated SQL Server data without a full backup. Step-by-step guide using transaction log analysis, DBCC PAGE, and... 13 May 2025 33 min read 321
Aaron Bertrand in Database Administration It’s a recovery strategy, not a backup strategy I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. I can’t possibly... 08 July 2024 12 min read
T-SQL Programming Aaron Bertrand in T-SQL Programming Snake draft sorting in SQL Server, part 4 Part of a series: [ Part 1 | Part 2 | Part 3 | Part 4 ] In the previous... 27 May 2024 9 min read
T-SQL Programming Aaron Bertrand in T-SQL Programming Snake draft sorting in SQL Server, part 3 Part of a series: [ Part 1 | Part 2 | Part 3 | Part 4 ] In part 2... 15 May 2024 5 min read
T-SQL Programming Aaron Bertrand in T-SQL Programming Snake draft sorting in SQL Server, part 2 Part of a series: [ Part 1 | Part 2 | Part 3 | Part 4 ] In my previous... 15 April 2024 7 min read
T-SQL Programming Aaron Bertrand in T-SQL Programming Snake draft sorting in SQL Server, part 1 Part of a series: [ Part 1 | Part 2 | Part 3 | Part 4 ] I recently had... 12 April 2024 8 min read
Database Administration Aaron Bertrand in Database Administration Get the most out of SQL Server Agent logs If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on SQL Server Agent... 11 March 2024 6 min read
Database Administration Aaron Bertrand in Database Administration Upgrade SQL Server on your workstation Lately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. The main source... 26 February 2024 6 min read
Database Administration Aaron Bertrand in Database Administration Leave it better than you found it This is for the folks who still have to log into remote machines and do work manually on the box.... 12 February 2024 8 min read
Database Administration Edward Pollack in Database Administration The Importance of Retention It is always an afterthought. New objects are created that start off small and current. New feature development takes over... 19 January 2024 24 min read
Database Administration Aaron Bertrand in Database Administration Optimized locking in Azure SQL Database I don’t think I’ve ever had a great impression of Azure SQL Database as a place for production applications. In... 08 January 2024 8 min read
Database Administration Aaron Bertrand in Database Administration Moving SQL Server To The Cloud: Modernizing Stack Overflow for Teams Earlier this year, we migrated the entire Stack Overflow for Teams platform to Azure. This was a lengthy endeavour and... 06 November 2023 11 min read
Database Administration Adrien Muhlemann in Database Administration Analyze and Tune SQL Server Statistics Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and I believe that... 22 September 2023 34 min read
Database Administration Edward Pollack in Database Administration Running Queries Across Many SQL Server Databases A challenge that reappears periodically in the world of databases (especially database management) is the need to run code on... 31 July 2023 14 min read
T-SQL Programming Aaron Bertrand in T-SQL Programming Changing log growth strategy in SQL Server 2022 When I first saw a bullet item stating SQL Server 2022 would support instant file initialization for log file growth,... 15 May 2023 6 min read
Database Administration Edward Pollack in Database Administration Building blocks of Extended Events data collection Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of... 14 September 2021 14 min read
