May 27, 2023

Crossing the Pedestrian Area to York

While my walk to DataYork continues, I investigate various things to find out if I can simulate some of the requirements. During that discovery I find sometimes very interesting Resources. One of them is the GitHub repository from the Defender for Cloud team: GitHub – Azure/Microsoft-Defender-for-Cloud: Welcome to the Microsoft Defender for Cloud community repository This repo has a ton of information and true course on Defender for Cloud. Since Defender is part of it, some tests can be found there.

May 26, 2023

Walking in the right direction: DataYork

Welcom back. Yesterday I created the LAW and added a sentinel solution to it. Next to that we also configured some values which you should do. As promised I would continue my preparation today. Not to difficult but it had to be done. I have fresh Windows 11 NUC on which I do work on a daily base. The nuc is capable enough, i7 and 16 GB. So I decided to add Hyper-V to it.

May 25, 2023

Another step to York

Hello all. I must admit, last week I was counterproductive. There where reasons… The most influencing was the fact that my monitor died. Would not be a big problem, but I cannot work without my 43 inch IIyama.. It gives me enough room to work on various things, including my day to day work. But.. I survived. I will continue today on my journey towards #DataYork. Another thing we need to do is to create the Log Analytics workspace and add the Defender stuff to it.

May 16, 2023

Next step to York

When connecting to my Azure tenant, I found out that I have no uhh… active subscription created. But in another tenant I have one. So with AZ login I switched to another tenant. If you want to know how to validate some subscription stuff and related items, you can go to the CodingWithAZ.blog page: https://codingwithtaz.blog/2021/08/20/create-management-groups-and-subscriptions-with-bicep/ That page was helpful for me. I needed to have my details like billing account etc.

May 9, 2023

Preparing for York

As people know I am publicly speaking at York User group. My chat will be about how Defender for SQL can be useful to protect your SQL data. Microsoft has delivered Defender for SQL first for cloud, but now you can also use this on premise. In this Series of Blogs I will keep you posted on how I prepare for the first speak. I have done a similar talk in my company, but I must admit, that is much easier.

April 5, 2023

Speaking at the Rabobank Engineering Week

This week was somewhat really exciting. A few weeks ago I opted for doing a session at the Rabobanks Internal Engineering Week conference. I had the idea to talk about how we help protecting our customers against all threads towards their databases. Initially I thought, I will do it big. Will tell everything what we know about it. Going through my documents, emails and code we have created.. I can of course find some ransomware which i can deploy to a VM running SQL… and then wait until Security comes and get me.

March 22, 2023

Speaking at York Data

Yesterday I catched a note in the POD from someone looking for speakers. I took the opportunity to get in contact with him. Now it is a fact: I am speaking at Data York. My first public speaking! The subject will be Defender for SQL as part of your Defense in Depth strategy. I hope to get a lot of valuable feedforward (Yes, i need to learn from this!) from all of you!

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.