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
111 reads
Everyday SQL
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
354 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
744 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
3 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
12 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
11 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
170 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,650 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,509 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,288 reads
Blogs
Get required permissions for DMVs
Part of my job at work is to update Transact-SQL reference content. System dynamic...
A New Word: Rivener
By Steve Jones
rivener – n. a chilling hint of distance that creeps slowly into a relationship...
AI and Cybersecurity: the Genie is Out of the Bottle
By Brian Kelley
Today's reality is that cybercriminals are increasingly using AI to develop better attacks. This...
Forums
2 table designs within one section to keep data for one section value within one
My requirement is to display data for a number of routes within 2 tables...
How to Resolve SQL Server Error 9100?
Is there any professional method to resolve SQL server error 9100.
Why Tech Events Matter for Data Pros (and why I’m grateful)
Comments posted to this topic are about the item Why Tech Events Matter for...
Question of the Day
New Backup Compression
What is the new software backup compression algorithm in SQL Server 2025?
See possible answers