Database engineer with a passion for automation
I’ve written previously about using containers for demos on my laptop, specifically for my data compression talk. Since I switched those demos over I haven’t looked back- if it’s possible to run my demos off of containers I always choose that option. I recently presented a talk called ‘Life Hacks: dbatools edition’ which walks through…
Well it’s May T-SQL Tuesday time! Honestly I’m not sure if time is crawling or flying by, it seems like forever ago we got writing for the April prompt on unit testing databases. Thanks to Glenn (b|t) this month for hosting an interesting topic. I’m looking forward to reading all the responses. Also a bigger…
I wrote previously about how I loved little life hacks and shortcuts for my February T-SQL Tuesday prompt. If you read that you’ll know I use VSCode a lot and really love all the shortcuts available in that program. This is just a quick tip that I’m so glad I found, read – took the…
It’s an interesting time we’re living in right now. I’m based in the UK and we just received the announcement last week that we have at least three more weeks of lockdown. I’ve been working at home for over a month now and I feel really lucky that I can work from home. There are…
It’s T-SQL Tuesday time again! March felt really long for a lot of us as we got used to our new way of life, so I’m excited we made it to April’s prompt. This month’s topic is asking for a discussion around whether unit testing for databases is valuable. Since getting involved with dbatools and…
I was browsing twitter the other day when a tweet about dbatools caught my eye (I use TweetDeck and so have a column for tweets that contain @PSdbatools). A dbatools bug!! Oh no! One of the reasons this caught my eye was that I’ve seen this error in my environment with that same command. I…
A short while ago (it’s getting further and further away, but let’s stick with short for now) I was a football/soccer player. As with many athletes, I was pretty superstitious as far as my pregame routine. I always felt better going out onto the pitch if everything had gone smoothly as I got ready. I…
I’ve recently found myself in a few situations where I’ve needed a certain lab setup to test something. Most scenarios these days I find myself firing up some docker containers to run demos or tests against. However, there are a few circumstances where you may need a little more than that, perhaps to test something…
I have just a quick tip for you today using the BurntToast module to notify us when a backup is complete. As DBAs there is always plenty to do, so we don’t want to have to sit and watch a long running script to catch the moment when it finishes. Usually what happens to me…
There was an amazing response to my TSQL2sday prompt for February 2020 where I encouraged folks to share their life hacks. So firstly, thanks to everyone who participated. A lot of people had more than one life hack so I recommend reading all of the posts linked to below. For this summary post I’ve tried…