May
17
revised UPDATE performance where no data changes
Updating Paul White blog post link
May
8
revised AlwaysON AG Readable Secondary is set to 'Yes'. How to connect from the client?
Moving comment into question
May
4
revised Why is sp_Blitz executing for more than 5 hours
Removing sp_AskBrent tag since that's not relevant here
Apr
30
revised Why does sp_whoisactive show locks on databases, but not tables?
Clarifying title
Apr
25
revised Error 5123 when creating a database with my SQL Server on Linux
Making title more intuitive
Apr
21
revised SQL Profiler for Mac OS
Adding Azure Data Studio's Profiler extension
Mar
3
revised How do you enable SQL Server 2019's result set caching?
Updating ALTER syntax
Feb
23
revised Need to maintain transactional consistency of the data across both servers, need to achieve these goals without manual intervention
Fixing title typo
Feb
14
revised Why Do My Nonclustered Indexes Use More Space When I Delete Rows?
Adding a clarification about the AG
Feb
14
revised Why Do My Nonclustered Indexes Use More Space When I Delete Rows?
Adding screenshot
Jan
18
revised Enlighten me about INCLUDE on indexes
Switched it to Erik since it's his post
Jan
8
revised Delete queries blocks other concurrent transactions
Adding a reference to their deadlock graph.
Jan
4
revised Trigger error in MySQL
Translated to English, fixed tags
Jan
3
revised Several questions about sp_BlitzIndex
Clarifying that it's sp_BlitzIndex doing the indexing work
2018
Dec
21
revised Redo lag on AG readable secondaries: is there a way to overcome it?
Adding info about parallel redo
Dec
1
revised SQL Server 2019 CTP 2.1 on Ubuntu fails after powering off
Clarifying version in title since it's pre-release
Nov
30
revised Is there an easy way to have a non-IDENTITY, auto incrementing column based on another column?
Fixing typo in title
Nov
8
revised sp_WhoIsActive vs sp_BlitzFirst @ExpertMode = 1
Adding sp_WhoIsActive note
Oct
30
revised How to add the Debug button to SSMS v18?
Clarifying version number
Oct
9
revised SQL Server 2012 Aggressive Over-Indexing when i run sp_BlitzIndex
Adding index details