Database engineer with a passion for automation
This is now the third post in a series on Azure tags. You can read the other two posts here to get up to speed with where we’ve been, however that isn’t required for this post . Keeping track of Azure resources with tags – Part 1 Keeping track of Azure resources with tags –…
Last week, in Part 1, we talked about how to easily keep track of our resources with tags. There are many strategies for tagging your resources but I specifically focused on adding a ‘dateCreated’ tag so we could see when resources were created – since this isn’t available by default. During that post we identified…
I’ve been working on some Azure exams recently, and I personally learn best by fiddling with things. The Microsoft learn content is excellent, and I’d highly recommend that for any of the Azure exams I’ve taken so far. However, I also like to build things myself and experiment a little with all the available options.…
Shout out to Brent Ozar (b|t) for hosting this month’s TSQL2sday. It’s time again for this monthly blog party and he wants to know all about our favourite or least favourite data types. To start with I was having a hard time thinking of a favourite data type. I know I have favourite words (merge…
Another week and another useful dbatools snippet for you today. Last week at work I was given a folder of 1,500 scripts – each containing a create table statement. Can you imagine having to open each file in Management Studio to be able to execute it? Thank goodness we have PowerShell and dbatools on our…
I was working in my lab environment this weekend, playing with some SQL Servers that I had built with PowerShell DSC a while ago. I had installed SQL Server with mostly defaults, including not changing the engine and agent service accounts. For the blog post I thought I was going to write next, I wanted…
It’s time for February’s monthly blog party. This month is hosted by Mikey Bronowski (b|t) and he’s asking us to write about our ‘tools of the trade’. He’s looking for those tools that make our lives easier, ones we couldn’t imagine going without. Thanks for hosting Mikey, can’t wait to read everyone’s contributions and add…
I was listening to a podcast last week about PowerShell, when one of the hosts mentioned having to ‘up arrow’ back through your history to find a command you wanted to rerun. This made me realise that I should write this quick post on using PSReadLine’s interactive search function. This tip is a serious time…
When granting permissions to SQL Server resources we have a few options. One option is to grant permissions to Active Directory groups instead of individual users. This has several benefits, for example, improved security over using SQL logins, and the ability to create a separation of duties when controlling database access. However, it does add…
Have you ever wanted to quickly backup/restore a database to the same instance to do some side by side testing? Perhaps to make some index changes or code changes, without actually changing the live copy of the database? Ideally you’d already have another environment for this sort of work, but even then sometimes it’s handy…