Querying Deadlocks From System_Health XEvent
It’s easy to query XEvents to see some of the basic info in deadlocks, including the system_health session which is already capturing this information by default. This script will,...
2016-01-25
95 reads
Querying Deadlocks From System_Health XEvent
It’s easy to query XEvents to see some of the basic info in deadlocks, including the system_health session which is...
2016-01-27 (first published: 2016-01-25)
2,916 reads
Speaking at SQL Saturday #500 in Boston!
I have been selected to speak at SQL Saturday #500 in Boston on March 19th - I will be speaking (at...
2016-01-25
474 reads
Things I learned in 2015
Happy 2016!
I continue my tradition of summarizing the things I learned in the past year (as a reminder, here’s what...
2016-01-25
661 reads
Monday Morning SQL Break – January 18, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-01-25
428 reads
Monday Morning SQL Break – January 11, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-01-25
528 reads
CISL 1.1.0: cstore_doMaintenance (Columnstore Maintenace Solution Explained)
After the initial release of the SQL Server Maintenance Solution in CISL 1.1.0, I felt that a separate blog post...
2016-01-24
643 reads
Notes from the January 2016 MagicPASS Meeting
I did my presentation on automated restores for the second time, changed a few things. It was/is a presentation with...
2016-01-22
653 reads
Notes from SQLSaturday #480 in Nashville
Late posting, so reduced notes!
Speaker party was good. Room was loud when full due to wood walls and nothing to...
2016-01-22
631 reads
The SQL Server Security Model, Part 1: Logins [Foundations Friday]
How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...
2016-01-22
768 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers