Managed Service Account Naming Convention
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
132 reads
Patrick
- Twitter: @patrickkeisler
- Website: https://www.patrickkeisler.com
- LinkedIn: https://www.linkedin.com/in/patrickkeisler/
Get Certificate Details for SQL Encryption In-Transit Using PowerShell
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
363 reads
Finding the NTFS Allocation Unit Size for Mount Points
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
845 reads
PASS is Gone
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
5 reads
Management Studio Find & Replace Using Regular Expressions
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
26 reads
Management Studio Drag & Drop Column Names
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
13 reads
SQL Server Audit Recipe – xp_cmdshell
This article assumes you already have a basic understanding of SQL Server Audit, but if not, use this link to catch...
2018-07-17
179 reads
SQL Server Morning Health Checks
Every now and again as a Microsoft PFE, you get a chance to make a big difference for a customer....
2018-01-08 (first published: 2018-01-02)
2,665 reads
Create a Whitelist for SQL Server - UPDATED!!!
A while back, I posted an article about creating a WhiteList for access to SQL Server. Since then I have...
2017-05-16
4,640 reads
Dear McAfee, Why are you destroying my buffer pool?
For the past few months, one my customers had been trying to diagnose an issue with SQL Server paging out...
2017-05-02
1,297 reads
Blogs
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Google – NotebookLM on ThakurVinay blog
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Distance Metrics for Semantic Similarity Searches in SQL Server 2025
Next up in my series talking about The Burrito Bot is diving into the...
Forums
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now
Comments posted to this topic are about the item Five SQL Server 2022 T-SQL...
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers