Why Blog?
The main reason I started blogging was a community thing. I leeched from the community to get me to where...
2013-09-04
1,006 reads
Simple SQL Server
Query Stats
DBAs rarely use the full potential of sys.dm_exec_query_stats. It’s common to see the queries for looking at the most expensive...
2013-09-04 (first published: 2013-08-27)
3,742 reads
SQL Saturday 250 – Pittsburgh – Advice for My Presentation on Monitoring and Baselines
I’ll be presenting at SQL Saturday 250 in Pittsburgh on Baselining and Monitoring. This is my first public presentation, and...
2013-08-20
766 reads
Fixing Page Life Expectancy (PLE)
What is Page Life Expectancy (PLE), what makes it drop, and how can I manage memory better? Abusing disks slows...
2013-08-20 (first published: 2013-08-19)
4,629 reads
Sys.dm_os_performance_counters Demystified
The dmv sys.dm_os_performance_counters is awesome, if you can understand it. This is how I make it easy to read and...
2013-08-13
2,546 reads
Deadlock – A quick, easy view
Deadlocks are rough to work with. Here are the scripts I use to capture deadlocks, find which ones are reoccurring,...
2013-08-06
2,077 reads
SQL Server Running Slow
A user calls to say the app or server is slow today. Here’s a quick summary of how I get...
2013-06-20
863 reads
Recently Recompiled Resource Hogs
It’s not too uncommon for a query to get a new execution plan that performs a lot worse than it...
2013-06-24 (first published: 2013-06-19)
1,793 reads
Reading Traces
Capturing information is useless unless you know how to use it. Here’s what I use to get the most out...
2013-06-18
1,388 reads
Tracing Introduction
SQL Server tracing is essential for troubleshooting performance issues, yet it can put loads on your server that would cause...
2013-06-16
1,060 reads
Blogs
Advice I Like: Art
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize...
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
Forums
Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL
Comments posted to this topic are about the item Think LSNs Are Unique? Think...
The AI Bubble and the Weak Foundation Beam
Comments posted to this topic are about the item The AI Bubble and the...
Question of the Day
A Big PK
In SQL Server 2025, how many columns can be included in a Primary Key constraint?
See possible answers