Data | dbatools | Command-line superpowers for SQL Server automation

Set-DbaDefaultPath

Chrissy LeMaire (@cl), netnerds.net

Set-DbaDefaultPath View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Configures the default file paths for new databases and backups on SQL Server instances Description Modifies the server-level default paths that SQL Server uses when creating new databases or performing backups without specifying explicit locations. This eliminates the need to manually specify file paths for routine database operations and ensures consistent placement of files across your environment. The function validates that the specified path is accessible to the SQL Server service account before making changes.

Write-DbaDbTableData

Chrissy LeMaire (@cl), netnerds.net

Write-DbaDbTableData View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Performs high-speed bulk inserts of data into SQL Server tables using SqlBulkCopy. Description Imports data from various sources (CSV files, DataTables, DataSets, PowerShell objects) into SQL Server tables using SqlBulkCopy for optimal performance. This command handles the heavy lifting of data type conversion from PowerShell to SQL Server, automatically creates missing tables when needed, and provides fine-grained control over bulk copy operations.