AzureFeeds

We have released mssql-python 1.10.0 with improvements focused on authentication flexibility, cross-platform text reliability, and bulk load stability.

Highlights

1) Bulk Copy now supports ActiveDirectoryServicePrincipal

Bulk Copy can now use Authentication=ActiveDirectoryServicePrincipal.

This release adds a token-factory callback path for Bulk Copy so tenant-aware tokens can be created during the FedAuth handshake, using the STS URL supplied by SQL Server.

Why this matters:

• You can use service principals in Bulk Copy flows without switching auth modes.


• The behavior aligns better with real enterprise automation scenarios and non-interactive jobs.

Example:

conn = mssql_python.connect(
“Server=tcp:myserver.database.windows.net;”
“Database=mydb;”
“Authentication=ActiveDirectoryServicePrincipal;”
“UID=;”
“PWD=;”
“Encrypt=yes;”
)

cur = conn.cursor()
cur.bulkcopy(“mytable”, [(1, “a”), (2, “b”)])

2) Arrow text fetching is more robust across locale and OS differences

In the Arrow fetch path, SQL_CHAR values are now requested as SQL_C_WCHAR to ensure consistent Unicode handling. This makes Arrow-based reads more predictable across Windows, Linux, and macOS, including different encoding and locale configurations.

3) Updated mssql-py-core to 0.1.5

This release bumps the bundled Rust core dependency from 0.1.4 to 0.1.5, bringing in fixes for bulk load connection timeout scenarios.

Additional quality updates

Non-ASCII VARCHAR data in Arrow fetch path

The Arrow fetch path now requests SQL_CHAR as SQL_C_WCHAR (UTF-16LE) instead of using the narrow character path. This ensures correct decoding independent of encoding settings, locale, or operating system, with no significant performance impact observed.

Bulk Copy connection timeouts

Bulk copy timeout fixes from Rust core are now included by bumping bundled mssql_py_core from 0.1.4 to 0.1.5.

Upgrade

If you use Azure Entra ID authentication with Bulk Copy, you’ll want this update.

Thank you

Thanks to everyone who reported issues, validated fixes, and contributed code and tests.