February 14, 2023

T-SQL Tuesday 159 – What is my Favorite 2022 Feature?

This months invitation for T-SQL tuesday came from Deepthi Goguri (B | L | T) . Here original request is explained here. The invite can be found here. Deepthi surprised me with hosting this TSQL tuesday. It is well deserved that she is hosting this months edition. I know here since a few years when I was helping on Dataweekender. Sometimes Deepthi is a bit naughty. She does not ask for one thing, but for two.

December 27, 2020

LESSONS LEARNED FROM MODERATING TRACK 5 OF DATAWEEKENDER2

Today I was moderating in Track 5 of Dataweekender. We started with Uwe Ricken. He was showing what you all could achieve with Database Configuration settings. In my opinion this is something what is way better than server scoped settings, allthough it is worth to have it somehow registerd per database. Next was Erland Sommarskog. We all know that triggers are creating trauma’s. Erland showed by using examples that you can do better without them, but also that there are reasons for using them.

December 27, 2020

VOLUNTEERING FOR DATAWEEKENDER

This time I do wan to share something interesting. I am volunteering again for Dataweekender. The first time it was organized, I was moderating in Track 1. I signed up for half a day, but the fun was that great that I stayed in the track until it closed. For those of you who do not know what Dataweekeder is, it is a one day event for people who are interested in Data, data manipulation and data presentation.

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.