How to use Statistics IO to Improve Your Query Performance
SQL Server’s STATISTICS IO reporting is a great tool to help you performance tune queries.Usually the goal of performance tuning...
2017-12-05
3,532 reads
Blog Posts
How to use Statistics IO to Improve Your Query Performance
SQL Server's STATISTICS IO reporting is a great tool to help you performance tune queries.
Usually the goal of performance tuning is to make your query run faster. One of...
2017-12-05
66 reads
New version of sp_WhoIsActive (v11.20) is available - Deployed on 123 instances in less than 1 minute
Last night, I received Adam Machanic’s (b | t) newsletter “Announcing sp_whoisactive v11.20: Live Query Plans”.
For those who don’t know about it, sp_WhoIsActive is a stored procedure that provides...
2017-12-05
25 reads
Power BI Custom Visuals Class (Module 79 – Venn Diagram MAQ Software)
In this module you will learn how to use the Venn Diagram Custom Visual by MAQ Software. The Venn Diagram...
2017-12-05 (first published: 2017-11-28)
1,636 reads
SQL Prompt Gets Even Better
SQL Prompt v9 came out recently, and just when you thought they couldn’t make it better, they found a way....
2017-12-05
860 reads
An introduction to a SQL Server 2017 Graph database
What is a graph database?
A graph is composed of two elements: a NODE (vertices) and an EDGE (relationship). Each node...
2017-12-04
802 reads
Attracting Non-Technical Speakers to Your SQLSat Events
Fellow DBA and community leader Peter Shore of the Columbus SQL PASS UG and SQLSat Columbus OH asked me via Twitter, "What is the...
2017-12-04
395 reads
Auto-Tuning and the #1 Mindset Problem I Had as a DBA
A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs for SQL Server? In this week’s episode, I talk about why...
2017-12-04
21 reads
Book Review – The Biml Book
After years of waiting, a book about Biml has been published! It’s conveniently titled “The Biml Book” (subtitled Business Intelligence and...
2017-12-04
885 reads
Configure Always on AG with SQL 2017
One of the new features that we have with SQL 2017 is that you no longer need a Windows cluster to enable the AlwaysOn feature with SQL server (remember...
2017-12-04
56 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers