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 … Doorgaan met het lezen van Analyzing an environment
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 … Doorgaan met het lezen van Deletes on large table
My first T-SQL Tuesday post!
This year, i'm starting with my first real DBA consultancy job! 😀
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 … Doorgaan met het lezen van 2018 review
My way of creating a SQL Server 2017 Failover Cluster on Windows Server 2016 Core edition.
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 … Doorgaan met het lezen van An evening of Docker