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,…
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’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…
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…
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…
Sometimes it’s best not to ask why. However, if for some reason you have a number of triggers on tables within a database that you would like to temporarily disable, read on. I came across a situation recently while automating a process to refresh test environments where this exact scenario came up. As part of…
There have been a lot of blog posts and talk around upgrading your servers in the past. However, the chatter always seems to intensify when we start getting close to that dreaded ‘end of support’ date for your older Windows and SQL Server versions. I hope this isn’t the first place you are discovering this,…
This weekend, while I was having a great time at SQL Saturday Cleveland, I ran into my friend Bert (b|t). He had some dbatools questions, which I was happy to help him with. Now that dbatools has over 500 commands, it is both awesome and terrifying. Bert wanted to know how to automate his database…
I recently set up an Availability Group with the intent of using the secondary as a read only replica for reporting. We have a few AG’s in our environment already but currently none are using this feature. I’m not going to step through setting up the AG or configuring the readable secondary as there are…
I recently gave my first usergroup presentation in Cleveland, closely followed by my first SQL Saturday presentation in Columbus. My chosen topic was row store data compression and I had a few great questions that I plan on answering with blog posts. First up… What happens if I use data compression and backup compression, do…