New-DbaDiagnosticAdsNotebook View Source Gianluca Sartori (@spaghettidba) Windows, Linux, macOS 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 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 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, Linux, macOS 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. The function also unpublishes the SqlWatch DACPAC registration to ensure clean removal.
Update-DbaMaintenanceSolution View Source Andreas Jordan, @JordanOrdix Windows, Linux, macOS 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.
Use this when you need to get bug fixes or improvements in the maintenance procedures without disrupting your existing backup, integrity check, and index optimization jobs.
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