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.
Stairway to Transaction Log Management in SQL Server Level, 8: Optimizing Log Throughput
This level takes a deeper look at how log fragmentation can affect the performance of operations that need to read the log, such as log backups, or the crash recovery process.
Stairway to Transaction Log Management in SQL Server, Level 6: Managing the Log in BULK_LOGGED Recovery Model
A DBA may consider switching a database to the BULK_LOGGED recovery model in the short term during, for example, bulk load operations. When a database is operating in the BULK_LOGGED model these, and a few other operations such as index rebuilds, can be minimally logged and will therefore use much less space in the log
Stairway to Transaction Log Management in SQL Server, Level 7: Dealing with Excessive Log Growth
This level will examine the most common problems and forms of mismanagement that lead to excessive growth of the transaction log.
Blogs
SQL Bits 2025 Wrap
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed
By Rohit Garg
As data becomes the backbone of modern business, understanding how to manage and analyze...
Simplify Kubernetes Security With Kyverno and OPA Gatekeeper
Here’s how these tools can make Kubernetes security easier and help you avoid common...
Forums
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Using Heaps
Comments posted to this topic are about the item Using Heaps
Question of the Day
Using Heaps
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers