ConvertTo-DbaTimeline View Source Marcin Gminski (@marcingminski) Windows, Linux, macOS Synopsis Generates interactive HTML timeline visualizations from SQL Server job history and backup history data
Description Transforms SQL Server job execution and backup operation data into visual timeline reports for analysis and troubleshooting. Takes piped output from Get-DbaAgentJobHistory and Get-DbaDbBackupHistory and generates a complete HTML file with an interactive Google Charts timeline.
Perfect for analyzing job schedules, identifying backup windows, troubleshooting overlapping operations, or creating visual reports for management.
Simone Bizzotto (@niphold) | Friedrich Weinmann (@FredWeinmann)
Get-DbaBuild View Source Simone Bizzotto (@niphold) , Friedrich Weinmann (@FredWeinmann) Windows, Linux, macOS Synopsis Retrieves detailed SQL Server build information including service pack, cumulative update, KB articles, and support lifecycle dates
Description Identifies the specific build version of SQL Server instances and translates build numbers into meaningful patch levels with their corresponding KB articles.
This function helps DBAs quickly determine what service packs and cumulative updates are installed, whether builds have been retired by Microsoft, and when support ends.
Get-DbaDependency View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Maps SQL Server object dependencies and generates creation scripts in proper deployment order
Description This function discovers SQL Server object dependencies using SMO (SQL Server Management Objects) and returns detailed information including creation scripts and deployment order.
By default, it finds all objects that depend on your input object - perfect for impact analysis before making changes or understanding what might break if you modify something.
Get-DbaInstanceInstallDate View Source Mitchell Hamann (@SirCaptainMitch), mitchellhamann.com Windows, Linux, macOS Synopsis Retrieves SQL Server installation dates by querying system tables for compliance auditing and infrastructure tracking.
Description Queries system tables (sys.server_principals or sysservers) to determine when SQL Server was originally installed on each target instance. This information is essential for compliance auditing, license management, and tracking hardware refresh cycles. The function automatically handles different SQL Server versions using the appropriate system table, and can optionally retrieve the Windows OS installation date through WMI for complete infrastructure documentation.
Get-DbaLastGoodCheckDb View Source Jakob Bindslet ([email protected]) Windows, Linux, macOS Synopsis Retrieves the last successful DBCC CHECKDB timestamp and integrity status for databases
Description Retrieves and compares the timestamp for the last successful DBCC CHECKDB operation along with database creation dates. This helps DBAs monitor database integrity checking compliance and identify databases that need attention.
The function returns comprehensive information including days since the last good CHECKDB, database creation date, current status assessment (Ok, New database not checked yet, or CheckDB should be performed), and data purity settings.
Get-DbaPowerPlan View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves Windows Power Plan configuration from SQL Server hosts to verify High Performance settings.
Description Checks the active Windows Power Plan configuration on SQL Server host computers to ensure they follow performance best practices. SQL Server performance can be significantly impacted by power management settings that throttle CPU frequency or put processors to sleep during idle periods.
By default, returns the currently active power plan for each specified computer.
Get-DbaProductKey View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves SQL Server product keys from registry data for license compliance and inventory management.
Description Decodes SQL Server product keys from registry DigitalProductID entries across all installed instances on target computers. This is essential for license compliance auditing, asset inventory during migrations, and generating compliance reports for auditors. The command handles different SQL Server versions (2005+), supports clustered instances, and automatically identifies Express editions that don’t require product keys.
Get-DbaSchemaChangeHistory View Source Stuart Moore (@napalmgram), stuart-moore.com Windows, Linux, macOS Synopsis Retrieves DDL change history from the SQL Server default system trace
Description Queries the default system trace to track CREATE, DROP, and ALTER operations performed on database objects, providing a complete audit trail of schema modifications. This helps DBAs identify who made changes, when they occurred, and which objects were affected without needing to manually parse trace files or enable custom auditing.
Get-DbaUptime View Source Stuart Moore (@napalmgram), stuart-moore.com Windows, Linux, macOS Synopsis Retrieves uptime information for SQL Server instances and their hosting Windows servers
Description This function determines SQL Server uptime by checking the tempdb creation date and calculates Windows server uptime using CIM/WMI calls to get the last boot time. Essential for monitoring system stability, troubleshooting unexpected restarts, and generating compliance reports that require uptime documentation. Returns both raw TimeSpan objects for calculations and formatted strings for reporting, covering both the SQL Server service and the underlying Windows host.
Import-DbaCsv View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Imports CSV files into SQL Server tables using high-performance bulk copy operations.
Description Import-DbaCsv uses .NET’s SqlBulkCopy class to efficiently load CSV data into SQL Server tables, handling files of any size from small datasets to multi-gigabyte imports. The function wraps the entire operation in a transaction, so any failure or interruption rolls back all changes automatically.
When the target table doesn’t exist, you can use -AutoCreateTable to create it on the fly with basic nvarchar(max) columns.
dbatools