Why do i do this?

This post is a response to this month’s T-SQL Tuesday #111prompt by Andy Leonard.  T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional topics every month. In this month’s topic Andy asks why do we do what we do? First and foremost, because i like it and because … Continue reading Why do i do this? →

Analyzing an environment

In my previous blog i shared my experience on my first day of work at a new client (https://wordpress.com/read/feeds/90430081/posts/2132980200). After this initial day, time to get to know the sql estate at hand. Accounts were already taken care of, and i got the admin level. I can check whatever i want and it shows a … Continue reading Analyzing an environment →

Deletes on large table

I had to help a collegue out today. He had to delete about 12 million rows on a 13 billion row table. And his statement (delete from [table name] where spec_id = 1) never got anywhere. First thing i tried was to encapsulate the statement in a transaction. This transaction was put within a while … Continue reading Deletes on large table →

2018 review

Blog number 5 and already looking back? Sure, to appreciate the future, you have to know the past. Or something like that đŸ˜‰ 2018 has been a very, very interesting year. The first half started out quite normal, besides writing an advanced SQL training that lasts two days. I don't know how i got round … Continue reading 2018 review →

Building my own Availability Group on Windows Server Core

My way of creating a SQL Server 2017 Failover Cluster on Windows Server 2016 Core edition.

An evening of Docker

It's been too long since my last blog, time for a new one! I got an email today from docker with an invitation for a webinar. As i'm interested in the subject, i took the invitation and tonight (20:00 local time) the webinar started.  It started with some survey results from Forrester about the usage … Continue reading An evening of Docker →

Powershell

Ok, so besides my wonderfull adventures in Docker, i'm on a different quest as well. I'm trying to get familiar with Powershell.  Long story short, if you want to manage a system quickly, easily and without too much RSI, use Powershell. It does take a bit of time to get used to, but it is … Continue reading Powershell →

Starting with docker

First off, i've got zero experience with Docker, so i just started googling around to find out what i had to do. To get things running, i started off with Windows 10 pro and a basic understanding of Powershell. To install Docker, i went to the Docker download site, got the installer and ran it. … Continue reading Starting with docker →