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. Especially when looking at SQL2019 there are huge improvements. Angela Ross Innes was the third presentation…

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. This awesome event is organized by volunteers and does not have any funding from commercial parties. This time, I am moderating in track…

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. As we saw previously, we have a GMSA account now, a Group where we need to put the computeraccounts in and something arranged for getting our Service…

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. In my case, I will just create a group named “Maroli-mgmt.SQL2019DE.gs” This is the group which will hold all the SQL…

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. You can create a simpel test environment on your laptop with Lability or just with hyper-v enabled. It is up to…

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. 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. As some people might know I got hit by a Bell Paralyse in the beginning of January. I had my cures and some accupuncture to heal faster. This…

T-SQL TUESDAY #118 – MY WISH…

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.

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!