#sqlhelp With SQL Server Availability Groups (2016) can you up the threshold for Flow Control Gates? I thought I read something saying how to do this, but can't find it again so might be misremembering.

In a recent post I talked about how great Query Store was for performance troubleshooting. Here's a quick guide on how to use it. matthewmcgiffen.com/2023/05/31/int…

What is Always Encrypted and how does it work? matthewmcgiffen.com/2023/06/05/wha…

Setting Up Always Encrypted matthewmcgiffen.com/2023/06/06/set…

Does anyone know how you set up a new account on the SQL Community Slack these days (old link not working)? #sqlhelp

Identify the (Top 20) most expensive queries across your SQL Server using Query Store matthewmcgiffen.com/2023/06/07/ide…

Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good? matthewmcgiffen.com/2023/06/08/par…

Success vs. Scalability: Why your biggest success might also be your biggest disaster matthewmcgiffen.com/2023/06/12/suc…

Executing Queries Using Always Encrypted matthewmcgiffen.com/2023/06/13/exe…

What Happens in the Background when Executing Queries with Always Encrypted matthewmcgiffen.com/2023/06/15/wha…

Under Promise and Overdeliver matthewmcgiffen.com/2023/06/19/und… #tsql2sday

Indexes and Statistics with Always Encrypted matthewmcgiffen.com/2023/06/20/ind…

What are Statistics in SQL Server? matthewmcgiffen.com/2023/06/21/wha…

When do SQL Server Statistics get updated? matthewmcgiffen.com/2023/06/28/whe…

Statistics and the Ascending Key Problem matthewmcgiffen.com/2023/07/21/sta…

Manually Updating Statistics in SQL Server matthewmcgiffen.com/2023/09/06/man…

T-SQL Tuesday: Encryption and Data Protection matthewmcgiffen.com/2023/09/29/t-s… #tsql2sday

T-SQL Tuesday 167 - Encryption and Data Protection Roundup #tsql2sday matthewmcgiffen.com/2023/10/17/t-s…

What I Love About My Job matthewmcgiffen.com/2023/12/07/wha…