Query Store Wait Statistics with sys.query_store_wait_stats

The second best thing to questions that people ask is when I sit down to write a book. It’s so...

Restrict the usage of a SQL Server Authenticated Application Id

SQL Server login ids may not be the most secure thing in the world but they are likely to be...

SQL Server 2016 – How to use Dynamic Data Masking (DDM)?

Dynamic Data Masking (DDM) is new feature of SQL Server 2016. DDM helps in preventing unauthorized access to sensitive data....

SQL Server DBCC CHECKDB – Going Parallel

DBCC CHECKDB has the ability to perform parallel checking of objects. However, it absolutely depends on the edition of SQL...

The Fine Art Of Translation

I remember being thoroughly baffled in grade school by word problems. How in the world was I supposed to translate...

T-SQL Tuesday #097: Learning Plans

If you are not progressing, you are regressing. In the same vein, if you are not learning, you are regressing.
Related Posts:

T-SQL Tuesday #102: Giving Back May 8, 2018

T-SQL...

T-SQL Tuesday #097: Learning Plans

Stylishly Late
I am fabulously late and therefor breaking the guiding rules that make up TSQLTuesday. Where’s the ruler to slap...

T-SQL Tuesday #97 Roundup: Learning goals for 2018

T-SQL Tuesday is a monthly blog party started by respected SQL Guru Adam Machanic. I was honored with hosting this...

When do usernames and passwords belong in connection strings

tl;dr: When using a windows or active directory authenticated id you do not put the username or password into your...

Some Thoughts on Community, Leadership, and Continuous Improvement

The SQL Server community is just awesome. I can’t say that enough. I may sound like a broken record when...