Category: PowerShell

dbachecks – A different approach for an in-progress and incremental validation

~ Cláudio Silva ~ 1 Comment

dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. If you don't know dbachecks, we have released a good amount of blog posts that will help you: Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances by Rob Sewell introducing dbachecks - a new module from … Continue reading dbachecks – A different approach for an in-progress and incremental validation

dbachecks – Using Power BI dashboards to analyse results

~ Cláudio Silva ~ 9 Comments

For the last couple of months, members of the dbatools team have been working on a new PowerShell module called dbachecks. This open source PowerShell module will enable you to validate your SQL Instances. Today it is released for you all to start to use 🙂 dbachecks launch - the blog posts series Here you … Continue reading dbachecks – Using Power BI dashboards to analyse results

Using dbatools to verify your SQL Server instances version compliance

~ Cláudio Silva ~ 3 Comments

One of the main DBA's duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service Packs, Cumulative Updates or Security Updates). Recently, dbatools added a new command that turns this validation a piece of cake. Thanks to Simone Bizzotto (@niphlod) for baking up the command that Shawn Melton (@wsmelton) and … Continue reading Using dbatools to verify your SQL Server instances version compliance

New version of sp_WhoIsActive (v11.20) is available – Deployed on 123 instances in less than 1 minute

~ Cláudio Silva ~ 2 Comments

Last night, I received Adam Machanic's (b | t) newsletter "Announcing sp_whoisactive v11.20: Live Query Plans". For those who don't know about it, sp_WhoIsActive is a stored procedure that provides detailed information about the sessions running on your SQL Server instance. It is a great tool when we need to troubleshoot some problems such as … Continue reading New version of sp_WhoIsActive (v11.20) is available – Deployed on 123 instances in less than 1 minute

PowerShell Modules Central – Share with community – What PowerShell modules are you using?

~ Cláudio Silva ~ 1 Comment

Like the blog post title states this is all about sharing with others! My idea is to share with the community which PowerShell modules you are using. Let me introduce to you the PowerShell Modules Central PowerShellModulesCentral is a GitHub repository that was founded as a central hub to a list of PowerShell modules that … Continue reading PowerShell Modules Central – Share with community – What PowerShell modules are you using?

Generate Markdown Table of Contents based on files within a folder with PowerShell

~ Cláudio Silva ~ 1 Comment

Last week I was talking with Constantine Kokkinos (b | t) about generating a Table Of Contents (TOC) for a GitHub repository. He wrote a cool blog post - Generating Tables of Contents for Github Projects with PowerShell - about it and I will write this one with a different problem/solution. Context I’m working on … Continue reading Generate Markdown Table of Contents based on files within a folder with PowerShell