Patrick

Patrick Keisler is a Senior CSA - Engineering for Microsoft with over 20 years of SQL Server experience working in various fields such as financial, healthcare, and government. You can follow him on Twitter or listen to him speak at various SQL Saturdays and user group meetings.

Twitter: @patrickkeisler
Website: https://www.patrickkeisler.com
LinkedIn: https://www.linkedin.com/in/patrickkeisler/

All authors

Managed Service Account Naming Convention

by Patrick

Everyday SQL

A while back I had to help a customer update their naming standard for their Managed Service Accounts, so I thought I would share some of those details. The...

2022-01-18

91 reads

Get Certificate Details for SQL Encryption In-Transit Using PowerShell

by Patrick

Everyday SQL

In my opinion, all customers should be encrypting connections to their SQL Servers to secure data in-transit, but that’s a discussion for another day. Today, I wanted to discuss...

2022-01-04

345 reads

Finding the NTFS Allocation Unit Size for Mount Points

by Patrick

Everyday SQL

The 64Kb Allocation Unit size is one of the easiest SQL Server best practice items to complete during your new builds, but from time to time, I still see...

2021-12-07

553 reads

PASS is Gone

by Patrick

Everyday SQL

On January 15, 2021, PASS will cease to exist. https://www.pass.org/PASS-Blog/ArticleID/888/ArtMID/99177/preview/true I cannot tell you how much this disappoints me. PASS has been around for my entire database career, and...

2020-12-29

Management Studio Find & Replace Using Regular Expressions

by Patrick

Everyday SQL

In my last Management Studio tip, I demonstrated how you can drag and drop column names to a query window. The only part I do not like about that...

2020-07-28

6 reads

Management Studio Drag & Drop Column Names

by Patrick

Everyday SQL

Continuing on my recent trend of Management Studio tips, here is another that could save you a few minutes. In today’s scenario, we need to write a select statement...

2020-07-07

9 reads