FileSystem

Show-DbaDbList

Chrissy LeMaire (@cl), netnerds.net

Show-DbaDbList View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Displays available databases in an interactive selection window Description Creates a Windows Presentation Framework dialog that connects to a SQL Server instance and presents all databases in a visual tree view for selection. This eliminates the need to hardcode database names in scripts or remember exact database names when building interactive tools. The function returns the name of the selected database as a string, making it ideal for building user-friendly maintenance scripts, allowing end users to choose databases without SQL Server Management Studio, or creating dynamic tools that work across different environments where database names may vary.

Show-DbaInstanceFileSystem

Chrissy LeMaire (@cl), netnerds.net

Show-DbaInstanceFileSystem View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Displays a GUI tree view for browsing remote SQL Server file systems and returns the selected directory path Description Similar to the remote file system popup you see when browsing a remote SQL Server in SQL Server Management Studio, this function allows you to traverse the remote SQL Server’s file structure. This replaces the need to manually type or guess directory paths when setting up backup locations, restore operations, or specifying data and log file paths.