SqlBuild

Get-DbaBuild

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.

New-DbaConnectionStringBuilder

zippy1981 | Chrissy LeMaire (@cl)

New-DbaConnectionStringBuilder View Source zippy1981 , Chrissy LeMaire (@cl) Windows, Linux, macOS Synopsis Creates a SqlConnectionStringBuilder object for constructing properly formatted SQL Server connection strings Description Creates a Microsoft.Data.SqlClient.SqlConnectionStringBuilder object from either an existing connection string or individual connection parameters. This allows you to programmatically build, modify, or validate connection strings without manually concatenating string values. The function handles authentication methods, encryption settings, connection pooling, and other SQL Server connection options, making it useful for scripts that need to connect to different SQL Server instances with varying configurations.

Test-DbaBuild

Simone Bizzotto (@niphold) | Friedrich Weinmann (@FredWeinmann)

Test-DbaBuild View Source Simone Bizzotto (@niphold) , Friedrich Weinmann (@FredWeinmann) Windows, Linux, macOS Synopsis Tests SQL Server build versions against patching compliance requirements Description Evaluates SQL Server instances or build versions against organizational patching policies to determine compliance status. Returns detailed build information including service pack level, cumulative update, reference KB, and end-of-support dates with a compliance flag. Helps DBAs audit patch levels across environments and identify instances that fall below minimum security or stability requirements.

Update-DbaBuildReference

Simone Bizzotto (@niphold) | Friedrich Weinmann (@FredWeinmann)

Update-DbaBuildReference View Source Simone Bizzotto (@niphold) , Friedrich Weinmann (@FredWeinmann) Windows, Linux, macOS Synopsis Downloads the latest SQL Server build reference database used for patch compliance and version tracking Description Refreshes the comprehensive SQL Server build reference database that powers Get-DbaBuild and Test-DbaBuild functions with current patch level information. This database contains detailed mappings between build numbers, service packs, cumulative updates, KB articles, release dates, and support lifecycle dates for all SQL Server versions.