Stairway to Transaction Log Management in SQL Server, Level 5: Managing the Log in Full Recovery Mode
In FULL recovery mode it is possible to do a point-in-time restore of a database. It is thankfully a rare event. Tony explains what's involved
The Technical Debt Anchor
Technical debt is something all of us deal with in our systems, and today Steve has a few thoughts on the impact of debt on database sysstems.
SQL Server Developer Standard Edition: A Gift to Developers!
Starting in SQL Server 2025, a new edition is available for installation: SQL Server Developer Standard Edition. This article dives into this edition, the problems it solves, and why it is a great addition for development teams that use SQL Server!
The Data Warehousing Choice
What is your choice for data warehousing? Is it a cloud platform? Which one is attractive to you?
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Misusing MAXDOP can silently kill performance across your SQL Server. In this deep dive, we uncover how one bad query caused CPU meltdown, run real-world tests, and show how tuning—not parallelism—often holds the true fix.
Recovering data in SQL Server without full backup
There are multiple reasons for no full backup: corrupted backups, taking too much time to restore, etc. In this post, I want to show an alternative for these cases, an ace up one’s sleeve, that you can use to recover data.
Shades and Reflecting on SQLBits and the Bright Future of Data
There is something magical about SQLBits. Whether it is the technical sessions, the sense of community and fun, or the relentless commitment to learning about the latest innovation, this event continues to serve as a pulse check for where data is today and where it’s going tomorrow. This year’s SQLBits at the ExCel in London […]
How to Choose the Right Tool for MS SQL to PostgreSQL Migration
Learn about a few different options for migrating from Microsoft SQL Server to PostgreSQL.
Multiple Monitoring Tools
Steve wonders if it is worth it to use multiple monitoring systems for a database.
Segments for Protection
Computer network security is important, and it's something we ought to be more concerned with as data professionals.
Blogs
Measuring and Improving SQL Server Query Plan Cache Efficiency
By SQLPals
Measuring and Improving SQL Server Query Plan Cache Efficiency The query...
Communicate to the Individual
By Brian Kelley
I may think I'm trying to reach the crowd, but I'm really trying to...
Monday Monitor Tips: Searching Permission Changes
By Steve Jones
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
Forums
The Technical Debt Anchor
Comments posted to this topic are about the item The Technical Debt Anchor
Getting the Updated Column List
Comments posted to this topic are about the item Getting the Updated Column List
SSRS: An error occurred during local report processing. The definition of ...
Here's the complete error: An error occurred during local report processing. The definition of...
Question of the Day
Getting the Updated Column List
What happens when I run this code in SQL Server 2022?
UPDATE dbo.CustomerLarge SET CustomerContactFirstName = 'Andy' WHERE CustomerID = 1 SELECT COLUMNS_UPDATED()See possible answers