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
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
In two weeks from now, on 23rd of February, I will be speaking at SQLBits 2018! It’s my first time on the largest SQL Server conference in Europe for data professionals. I will deliver a session about SQL Server Reporting Services and PowerShell titled - "Administrating SSRS without boring web based clicks". You can check … Continue reading I will be speaking at SQL Bits 2018
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
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
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?
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
I'm working on a environment where I have to deal with multiple domains. The user's password needs to be updated each 40/45 days (it depends on the domain). Can you see the pain? This means that every month and half I have to dedicate like 20 minutes to change my password on 10 different domains … Continue reading [PowerShell] From 20 minutes to 20 seconds – Change domain user password on multiple domains without login into each one
This month’s T-SQL Tuesday is brought to us by my good friend Rob Sewell (b | t) and we will "Let’s get all Posh – What are you going to automate today?"
I was using open source PowerShell module dbatools (GitHub repository) to get the list of SQL Server services I have on a bunch of hosts so I could confirm if they are in "running" state.