Invoke-DbaWhoIsActive View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves real-time information about active SQL Server sessions and currently running queries
Description Executes Adam Machanic’s sp_WhoIsActive stored procedure to display detailed information about currently running sessions, active queries, and their resource consumption. This is the go-to command for troubleshooting performance issues, identifying blocking chains, and monitoring SQL Server activity in real-time.
New-DbaDiagnosticAdsNotebook View Source Gianluca Sartori (@spaghettidba) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Generates a Jupyter Notebook containing Glenn Berry’s SQL Server diagnostic queries for Azure Data Studio
Description Converts Glenn Berry’s well-known SQL Server diagnostic queries into a Jupyter Notebook (.ipynb) file that can be opened and executed in Azure Data Studio. The function automatically detects your SQL Server version or accepts a target version parameter, then creates a notebook with version-specific diagnostic queries formatted as executable cells.
Save-DbaCommunitySoftware View Source Andreas Jordan, @JordanOrdix Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Downloads and caches popular SQL Server community tools from GitHub for use by dbatools installation commands
Description Downloads and extracts popular SQL Server community tools from GitHub repositories to maintain a local cache used by dbatools installation commands.
This function automatically manages the acquisition and versioning of essential DBA script collections, eliminating the need to manually download and organize multiple tool repositories.
Save-DbaDiagnosticQueryScript View Source Andre Kamman (@AndreKamman), andrekamman.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Downloads Glenn Berry’s SQL Server Diagnostic Information Queries for performance monitoring and troubleshooting
Description Downloads the latest versions of Glenn Berry’s renowned SQL Server Diagnostic Information Queries from his website. These DMV-based scripts are essential tools for DBAs to assess SQL Server health, identify performance bottlenecks, and gather comprehensive system information across all SQL Server versions including Azure SQL Database and Managed Instance.
Uninstall-DbaSqlWatch View Source Ken K (github.com/koglerk) Windows only On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Completely removes SqlWatch monitoring solution from a SQL Server instance
Description Performs a complete uninstallation of the SqlWatch performance monitoring solution by removing all associated database objects, SQL Agent jobs, and historical data. This includes dropping all SqlWatch tables (containing performance metrics history), views, stored procedures, functions, Extended Events sessions, Service Broker components, assemblies, and user-defined table types.
Update-DbaMaintenanceSolution View Source Andreas Jordan, @JordanOrdix Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Updates existing Ola Hallengren Maintenance Solution stored procedures to the latest version
Description Updates the stored procedures for Ola Hallengren’s Maintenance Solution on SQL Server instances where it’s already installed. This function downloads the latest version from GitHub and replaces only the procedure code, leaving all existing tables, jobs, and configurations intact.
Recently, I presented to the Philadelphia PowerShell User Group about Contributing to Open Source PowerShell projects using GitHub Desktop. I chose this topic because a number of people have asked for step-by-step instructions on how to work with GitHub.
I love the command line, but with Git? I think it’s important to get the concepts down first and the Desktop version makes that a lot easier to contribute to projects like dbatools, dbareports and even PowerShell itself.
dbatools