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
123 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
360 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
784 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
4 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
14 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
12 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
175 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,662 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,573 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,293 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers