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 :...
André is a Data Engineer and architect mostly in Azure. He has done a lot of DBA work on 1000’s of SQL Servers where he discovered his love for Powershell, architecting data solutions, building and tuning ETL processes (with BIML), and even implementing PDW. Having to wrangle a lot of data he's using Python, SparkSQL in Azure Databricks, Data Factory, dbt and Power BI as well these days. André is a Data Platform MPV since 2009, Dutch Microsoft Data Platform Meetup lead, organiser of Data Saturday Holland and Data & BI track volunteer for Techorama Holland