Now, the problem is if you have hundreds of server to support, copying, pasting, and compiling the procedures provided by SQL-Server-First-Responder-Kit is a tedious task. So, now the kit includes a sql script named ‘Install-All-Procs.sql’ for compiling all procs all together. But, for me, I never intended to use all of the procedures rather only specific ones like sp_Blitz, sp_BlitzFirst, sp_BlitzCache, sp_BlitzIndex, and Adam Mechanic’s sp_whoIsActive. In order to achieve this, I have created a PowerShell module that will help us to compile all the required procedures scripts against any server as per our need just by calling
Apply-FirstResponderKit function as below.
If we ever want to read more about Apply-FirstResponderKit function, we can get its details using Get-Help.
Now, we can either import the module explicitly by using Import-Module command like below, or we can place the entire module in any of the directory inside
I am Microsoft Certified Professional having 10+ years of experience in SQL Server Querying, Database Design, and Administration. I am fond of Query Tuning and like to automate things using TSQL & PowerShell. I also have experience of implementing end-to-end Data Warehouse solution, and Data Migration using ETL tools SQL Server Integration Services (SSIS), Pentaho Business Analytics, and have designed Database Inventory through PowerShell, Python, and Django etc.