Practical guides and insights for modern data practitioners
Hello and welcome to my T-SQL Tuesday contribution for this month, based on automating a complex Database refresh. For those of you who want to know more about this month’s T-SQL Tuesday topic “Automate all the things” you can click here. I’ve been a big believer of automation for a long time now. The main … Read more
Introduction In this post I thought I would discuss various cloud infrastructure options to consider when choosing a provider. Since I touched on the topic of using a cloud-based solution in my previous post I thought I would do a follow up. This post should be useful whether you’re looking at cloud providers or just … Read more
Introduction I’ve decided to post about building a test lab to use outside of work. Because it’s something most data platform professionals deal with at one stage or another. Some of you can also consider this a primer for future posts. Now if you’re lucky your workplace already has a test environment where you can … Read more
In this post I want to cover useful SQL Server related PowerShell Modules for the DBA. With this in mind, lets start with the one which is probably the most common module. SQLServer First of all, lets clear one thing up. To clarify, the SQLServer PowerShellmodule is the replacement for the old PSSQL module. So, if … Read more