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,011 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,753 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
777 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,765 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,632 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,088 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
869 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,802 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,390 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,074 reads
Blogs
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
Forums
ALAMAT BCA KCU SCBD Telp:08218154392
WA CS:08218154392 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl....
Alamat Kontak BCA KCU BEKASI WA CS:08218154392
WA CS:08218154392 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks,...
ALAMAT BANK BCA KCU GUNSA 45 TLP/WA 08218154374
Hub Cs: 08218154374 Jl. Gn. Sahari No.45, RT.7/RW.5, Gn. Sahari Utara, Kecamatan Sawah Besar,...
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers