Blog Post

SQL Server Blog
2 MIN READ

mssql-python 1.10.0: Service Principal Bulk Copy, More Reliable Arrow Text, and a Core Timeout Fix

DavidLevy's avatar
DavidLevy
Icon for Microsoft rankMicrosoft
Jun 26, 2026

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:

import mssql_python

conn = mssql_python.connect(
    "Server=tcp:myserver.database.windows.net;"
    "Database=mydb;"
    "Authentication=ActiveDirectoryServicePrincipal;"
    "UID=<client-id-guid>;"
    "PWD=<client-secret>;"
    "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

pip install --upgrade mssql-python

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.

Updated Jun 25, 2026
Version 1.0
No CommentsBe the first to comment