Store dbatools PowerShell module as a package in Azure DevOps

In this post I want to cover how you can store dbatools PowerShell module as a package in Azure DevOps. By using the Azure Artifacts service. I want share some knowledge about this because did a demo of it at Malta Data Saturday. By the end of this post you will have a better understanding … Read more

T-SQL Tuesday #110 – Automating a complex Database refresh

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

Useful SQL Server related PowerShell Modules for the DBA

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