Every now and then (actually, quite often now I think of it) I need to test code on a bunch of different versions of SQL Server. And I prefer those SQL Server instances to be fresh every time. Quickest way that works for me, fire up my Azure Cloud...
Gary Bargsley (b|t) is the host of this months T-SQL Tuesday #110 – ” Automate All the Things” The question he asks is easy: What do you want to automate or what automation are you proud of completing? My answer to that is simple...
January 1st, 1989 was my first day at work for my first job in IT. You would think that everything was completely different 30 years ago. The advance in sheer computing power and the evolution of languages and frameworks had me think for a bit that...
I’m a big fan of SQL Saturdays. I frequently speak at them and I’m part of the team behind SQL Saturday Holland. This year (2016), the Data Discovery team from InfoSupport made a great video about our event. I’m so proud to be a...
I presented for the PASS Powershell Virtual Chapter on June 15th, 2016 It was an online session and it was recorded, the youtube video of it is here I figured out what was wrong with the two little demo fails. I was pressing F8 to only execute my...
For 10 weeks in a row now I’ve been participating in Steve Stedman’s “Database Corruption Challenge”. I’ve learned a ton of stuff and I was able to add some new scripts to my toolbelt because I needed them to solve the...
For people who have seen my presentation and are interested to play with the demo code. Please find the PDF of the presentation and the demo scripts here Pre-Requisites: Create a database called BlitzOutput and run sp_blitz, make sure it safes the...
With just a couple of weeks to go I wanted to emphasise something that is not completely clear from the title and abstract. It says that the session is for DBAs but that title is not complicated enough, it should read something like :...
I’m a SQL Server consultant based in the Netherlands. I’m a SQL Server MVP and I’m the co-founder and current chairman of the Dutch PASS Chapter and a member of the volunteer team for the Dutch SQL Saturday’s. I’ve done a whole lot of pure DBA work managing 100′s of servers and learning something new every day.
These days I spend a lot of time on just a few servers containing some large databases and the better part of the day is spent with SSIS. In both roles I’ve been using Powershell a lot. I joke sometimes that I replaced myself with a powershell script when leaving the DBA role, but these days I automate so much that I have to watch myself and not actually do just that