Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This article lists and describes what's new in the versioned releases of the Microsoft SQL Server Tools on Linux and macOS.
New item | Details |
---|---|
Sqlcmd AAD rename | Renamed Azure Active Directory to Entra ID. |
BCP AAD rename | Renamed Azure Active Directory to Entra ID. |
New item | Details |
---|---|
Alpine ARM64 | Only released for Alpine Linux. This version now supports the ARM64 platform on Alpine Linux. |
New item | Details |
---|---|
Sqlcmd Bugfix | Fixed issue with command line parameters not being hidden |
New item | Details |
---|---|
Sqlcmd Bugfix | Fixed issue where -M option required an argument. |
Sqlcmd Bugfix | Fixed issue where nohup and SIGHUP can cause it to hang in certain situations. |
Sqlcmd Bugfix | Fixed specifying input codepage with -f option. |
Sqlcmd Bugfix | Fixed detection of current character encoding. |
Sqlcmd Bugfix | Fixed input file codepage option. |
New item | Details |
---|---|
Sqlcmd Bugfix | Fixed issue where -M option required an argument. |
Sqlcmd Bugfix | Fixed issue where nohup and SIGHUP can cause it to hang in certain situations. |
New item | Details |
---|---|
Sqlcmd Bugfix | Fixed extraneous trailing bytes after encoding conversion. |
TDS 8.0 | Add support for TDS 8.0 strict encryption |
Secure by default | Following the change in Microsoft ODBC Driver 18 for SQL Server to default Encrypt to yes , sqlcmd and bcp both require encryption and validate certificates, by default. In sqlcmd, use -No to connect with optional encryption. In bcp, use -Yo to connect with optional encryption. For more information, see Connecting with sqlcmd and Connecting with bcp. |
New item | Details |
---|---|
Sqlcmd Bugfix | Fixed extraneous trailing bytes after encoding conversion. |
New item | Details |
---|---|
Package update | Updated RPM packages for Red Hat 7, Red Hat 8, SUSE 12, and SUSE 15 to use SHA256 RPM signing. |
Feature added | Details |
---|---|
Sqlcmd Token Authentication | Now supported. See Connecting with sqlcmd |
BCP Token Authentication | Now supported. See Connecting with bcp |
Feature added | Details |
---|---|
Sqlcmd Bugfix | Fixed input redirection bug and empty lines leading to repeated execution. |
Sqlcmd Bugfix | Fixed mistaken error reporting for r, p, X and k options under certain formatting. |
Sqlcmd -z/-Z "Password" Option | Now supported. |
Feature added | Details |
---|---|
Sqlcmd Command Line Parser Updated | Fixed bugs where unexpected behavior occurred when using certain options in different orders. |
Sqlcmd Error Messages Updated | Fixed various inconsistencies in how errors in sqlcmd were returned. |
Sqlcmd -Y Option Fixed | Fixed issue where -Y option was ineffective |
Sqlcmd Column Name Truncation Fixed | Fixed issue where column names would be truncated incorrectly |
Sqlcmd Linux Exit Codes | Fixed issue where process exit code was missing on Linux |
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Learning path
SQL Server on Linux - Training
SQL Server now runs on your choice of operating system. In this learning path, you'll discover the fundamentals of SQL Server on Linux, before discovering how to run SQL Server on Linux containers and deploy SQL Server on Linux. You'll then learn how to automatically tune your SQL Server on Linux deployment.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
Connecting from Linux or macOS - ODBC Driver for SQL Server
Learn how to create a connection to a database from Linux or macOS using the Microsoft ODBC Driver for SQL Server.
Known issues for the ODBC driver on Linux and macOS - ODBC Driver for SQL Server
Learn about known issues with the Microsoft ODBC Driver for SQL Server on Linux and macOS and steps for troubleshooting connectivity issues.
System Requirements (ODBC Driver for SQL Server) - ODBC Driver for SQL Server
This lists the system requirements for the ODBC Driver for SQL Server on Linux and macOS operating systems.