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
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 … Doorgaan met het lezen van Powershell