Significant Achievements
As a few of you know, I took the Microsoft Certified Master (MCM): SQL Server 2008 lab at this year’s...
2012-11-28
737 reads
StrateSQL
Lost in Translation – Deprecated System Tables – sysreferences
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-28
1,337 reads
Querying Performance Counters in SQL Server
In a previous post, there was a comparison between sysperfinfo and sys.dm_os_performance_counters which included the use of a simple query. ...
2012-12-06 (first published: 2012-11-27)
6,813 reads
Help Bring #SQLFamily to Fargo, North Dakota
Did you know that a SQL Saturday in Fargo is in the works? If not them, hey… there’s a SQL...
2012-11-30 (first published: 2012-11-26)
1,179 reads
Cyber Monday: Performance Indexing Book is $15
Ever thought you could learn a little bit more about indexing? Now here’s the perfect opportunity. Today only you can...
2012-11-26
810 reads
Last Weeks Top 10 “Reading” Links #8
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-11-26
634 reads
Reblog: November 16 to November 22
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-11-23
648 reads
Lost in Translation – Deprecated System Tables – sysperfinfo
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-22
1,331 reads
Lost in Translation – Deprecated System Tables – sysobjects
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-22
1,559 reads
Lost in Translation – Deprecated System Tables – sysusers
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-21
1,770 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers