In a few previous articles, I have talked a lot about Managed Service Accounts (MSA) and Service Principal Names (SPN) and given examples of managing the separately. As a...
2022-11-11 (first published: 2022-11-01)
276 reads
Managed Service Accounts (MSA) are intended to run as a service and not to be used by an end user to logon interactively; however, there are some cases where...
2022-03-15
4 reads
In my previous post, I discussed how to setup Kerberos constrained delegation and a limitation of using that method. This post will discuss how we can used resource-based Kerberos...
2022-03-01
17 reads
For those of you that need to setup Kerberos constrained delegation for Group Managed Service Accounts, you will likely get more familiar with msDS-AllowedToDelegateTo. This attribute stores a list...
2022-02-15
112 reads
Kerberos delegation is not a new concept in Active Directory; however, setting it up for Group Managed Service Accounts (gMSA) can be a bit confusing. Unlike normal domain accounts,...
2022-02-01
3 reads
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
5 reads
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
91 reads
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
37 reads
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
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
1 reads
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...
By Steve Jones
Today’s coping tip is to find a new way to tell someone you appreciate...
I was given 4.5 months notice this past June and was fortunate to find...
Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...
Comments posted to this topic are about the item The Availability Group Secondary Connection
I am getting the following error when I try to use the Expression below....
Ask SSC