December 27, 2020

GMSA: SERVER PREPARATION AND MODIFY THE INSTALL

In my previous blogs I talked about what Group Managed Service accounts are, what you need to have enabled in your Active Directory and the AD objects we needed before we can even think about using them to ease our SQL installation. But we are not there yet. In this blog post I will talk about further AD Actions and what you can do to install your server immediately with that GMSA account.

December 27, 2020

GMSA: CREATE THE ACCOUNTS AND THE GROUP

So… After creating the KDC keys in your Active Directory we can continue with where it all is about: creating the GMSA. Before we will create the account, we first need to create a group. This group will hold all of the computeraccounts of the servers which run the services with the gMSA acccounts. It is a good practice to follow your conventions. These conventions will merely hold naming conventions, place where your group will reside and supportable items.

December 27, 2020

GROUP MANAGED SERVICE ACCOUNTS: PREPARE YOUR DOMAIN

Last posts I have been talking about Group Managed Service Accounts (GMSA). I will continue on that journey with this blog. Group managed Service accounts are nice, but you need to prepare it very well, otherwise you end up with a non working non supported estate. There are some things one should know before continue. It is wise to make all your steps repeatable, each time, over and over. You also should test it on a test environment first.

December 27, 2020

GROUP MANAGED SERVICE ACCOUNTS

Like said in my previous post for TSql Tuesday, I am a big fan of automating stuff to be become secure by default. One of the measurements we have taken on my assignment is to implement Group Managed Service Accounts. But what are they? How can you use them and what are the benefits for SQL Server for example. In this post I will try to answer those questions. Back in the time that Windows 2012 was introduced, they also introduced Managed Service Accounts.

May 12, 2020

T-SQL TUESDAY #126 – HELPING TO SURVIVE COVID-19

This months invitation for T-SQL tuesday came from Glenn Berry (B | L | T) . His original request is explained here. ](https://glennsqlperformance.com/2020/05/05/t-sql-tuesday-126-foldinghome/) Glenn’s invite asks us to what we have done in response to Covid-19. I first needed to think very deep about that question… What I have done in response to Covid-19? Or what Covid-19 has done to me? While the last question was not part of Glenn’s question, I just wanted to answer that also.

September 10, 2019

T-SQL TUESDAY #118 – MY WISH

Thanks Kevin Chant (b|t) for hosting this Tsql Tuesday. You make it hard for me to answer this one. Especially since it is my first official post for a TSQL Tuesday. As a Database Infrastructural engineer there are some behaviors which you want to change. I am focused on security and ease of working I do not have many fantasies on SQL Server, but some improvements on the normal components would be nice to have.

May 9, 2019

MICROSOFT ROK LICENSE ON HYPER-V GUEST

You all have dealt with this situation. You bought a new box for a customer. Then you adjust your plans, just because Hyper-V is cool. You think… Lets install Hyper-V on that box and create some VM’s on it. One with the SBS or Essentials Server and a few additional VM’s Then you start to to setup the hardware, make sure you enabled Virtualization on that ML10 and off you go.

Dataweekender 3.1

As some of you know I am volunteering in Dataweekender. This event which gives you the ability to learn new things in short sessions of 50 minutes. New in this is that there are also a few tracks which have 10 minute tracks. This is mainly used by new presenters, or by experienced people who want to help you jumpstart on a specific topic. Dataweekender is having these short tracks in Track 4.