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
Today I will write just a short blog post to do a quick reminder! I still hear a lot of people suggesting CTEs because they think it works like a temporary table (you populate the table and then it can be/is reutilized). It doesn't! From de documentation: Specifies a temporary named result set, known as … Continue reading Using Common Table Expression (CTE) – Did you know…
This month’s T-SQL Tuesday is brought to us by Ewald Cress (blog | twitter) and is all about "folks who have made a difference" in our careers.