Database engineer with a passion for automation
Have you ever had someone send you the name of a SQL Server and database to do some work, but when you try to connect to the server you can’t? Then,come to find out, there are four named instances on the box and you don’t know which one hosts the database? No? Just me? Luckily,…
Recently I was tasked with troubleshooting an incident on a SQL Server at a certain point in the past, the issue being a high CPU alert. It’s hard (without monitoring solutions set up) to go back in time and determine what the issue is. However, one thing we can check is the windows event log…
TLDR; This code will script out foreign keys and views (including object level permissions), drop the objects, truncate all the tables, and recreate the objects. The Details The most popular post on my blog so far was called ‘Disable all Triggers on a Database’ and this one is a good follow up from that post.…
I’m a SQL Server Database Engineer by day, but I must say my blog has a lot more PowerShell and automation posts than T-SQL. However, last week I found a really great T-SQL aggregate function that I had no idea existed, so I thought I’d share it with you. I have been working on a…
I feel like I say this every month, but it’s already time for another edition of T-SQL Tuesday. This months blog party is hosted by Kenneth Fisher (B|T) and he’s looking for tips & tricks, but nothing DBMS related. As you might already know, I love shortcuts and tips & tricks – so I was…
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…