# Python Driver for SQL Server

Published articles for Python Driver for SQL Server.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Introducing Apache Arrow Support in mssql-python

DevFeed: [Introducing Apache Arrow Support in mssql-python](<https://devfeed.tech/articles/introducing-apache-arrow-support-in-mssql-python-20347.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/python/introducing-apache-arrow-support-in-mssql-python/>)

Author: Saumya Garg

Published: 2026-05-04T04:33:00Z

Content type: release

Language: en

Sources: [Microsoft Python Engineering](<https://devfeed.tech/sources/microsoft-python-engineering.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [data-processing](<https://devfeed.tech/topics/data-processing.md>), [interoperability](<https://devfeed.tech/topics/interoperability.md>), [data](<https://devfeed.tech/topics/data.md>), [pandas](<https://devfeed.tech/topics/pandas.md>)

Tags: [apache-arrow](<https://devfeed.tech/tags/apache-arrow.md>), [arrow](<https://devfeed.tech/tags/arrow.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [client-driver](<https://devfeed.tech/tags/client-driver.md>), [data-processing](<https://devfeed.tech/tags/data-processing.md>), [interoperability](<https://devfeed.tech/tags/interoperability.md>), [pandas](<https://devfeed.tech/tags/pandas.md>), [python](<https://devfeed.tech/tags/python.md>), [python-driver-for-azure-sql](<https://devfeed.tech/tags/python-driver-for-azure-sql.md>), [python-driver-for-sql-server](<https://devfeed.tech/tags/python-driver-for-sql-server.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>), [zero-copy](<https://devfeed.tech/tags/zero-copy.md>)

### AI overview

Microsoft introduces Apache Arrow support in mssql-python, enabling SQL Server data to be fetched directly into Arrow structures for Polars, Pandas, DuckDB, and other Arrow-native libraries. The approach is intended to reduce Python object creation and memory overhead during data processing.

### Source excerpt

Reviewed by Sumit Sarabhai Fetching a million rows from SQL Server into a Polars DataFrame used to mean a million Python objects, a million GC allocations, and then throwing it all away to build a DataFrame. Not anymore. mssql-python now supports fetching SQL Server data directly as Apache Arrow structures - a faster and more [...] The post Introducing Apache Arrow Support in mssql-python appeared first on Microsoft for Python Developers Blog.

## Write SQL Your Way: Dual Parameter Style Benefits in mssql-python

DevFeed: [Write SQL Your Way: Dual Parameter Style Benefits in mssql-python](<https://devfeed.tech/articles/write-sql-your-way-dual-parameter-style-benefits-in-mssql-python-20356.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/python/write-sql-your-way-dual-parameter-style-benefits-in-mssql-python/>)

Author: Jahnvi Thakkar

Published: 2026-04-07T16:12:05Z

Content type: article

Language: en

Sources: [Microsoft Python Engineering](<https://devfeed.tech/sources/microsoft-python-engineering.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Python](<https://devfeed.tech/topics/python.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Microsoft](<https://devfeed.tech/topics/microsoft.md>), [Azure](<https://devfeed.tech/topics/azure.md>)

Tags: [azure](<https://devfeed.tech/tags/azure.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [client-driver](<https://devfeed.tech/tags/client-driver.md>), [code](<https://devfeed.tech/tags/code.md>), [developers](<https://devfeed.tech/tags/developers.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [python](<https://devfeed.tech/tags/python.md>), [python-driver-for-azure-sql](<https://devfeed.tech/tags/python-driver-for-azure-sql.md>), [python-driver-for-sql-server](<https://devfeed.tech/tags/python-driver-for-sql-server.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>)

### AI overview

Microsoft's mssql-python driver now supports both qmark positional parameters and pyformat named parameters for Python applications using SQL Server and Azure SQL. The driver automatically detects the parameter style from the supplied tuple, list, or dictionary, while preserving existing qmark code without configuration changes.

### Source excerpt

Reviewed by: Sumit Sarabhai If you've been writing SQL in Python, you already know the debate: positional parameters (?) or named parameters (%(name)s)? Some developers swear by the conciseness of positional. Others prefer the clarity of named. With mssql-python, you no longer need to choose - we support both. We've added dual parameter style support to mssql-python, enabling both qmark and pyformat parameter styles in Python [...] The post Write SQL Your Way: Dual Parameter Style Benefits in mssql-python appeared first on Microsoft for Python Developers Blog.

## Simplifying Resource Management in mssql-python through Context Manager

DevFeed: [Simplifying Resource Management in mssql-python through Context Manager](<https://devfeed.tech/articles/simplifying-resource-management-in-mssql-python-through-context-manager-20355.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/python/simplifying-resource-management-in-mssql-python-through-context-manager/>)

Author: Jahnvi Thakkar

Published: 2025-09-26T09:49:51Z

Content type: tutorial

Language: en

Sources: [Microsoft Python Engineering](<https://devfeed.tech/sources/microsoft-python-engineering.md>)

Topics: [Python](<https://devfeed.tech/topics/python.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Exception](<https://devfeed.tech/topics/exception.md>)

Tags: [azure](<https://devfeed.tech/tags/azure.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [cleanup](<https://devfeed.tech/tags/cleanup.md>), [client-driver](<https://devfeed.tech/tags/client-driver.md>), [databases](<https://devfeed.tech/tags/databases.md>), [exception-handling](<https://devfeed.tech/tags/exception-handling.md>), [python](<https://devfeed.tech/tags/python.md>), [python-driver-for-azure-sql](<https://devfeed.tech/tags/python-driver-for-azure-sql.md>), [python-driver-for-sql-server](<https://devfeed.tech/tags/python-driver-for-sql-server.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [sql-server-2025](<https://devfeed.tech/tags/sql-server-2025.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

This tutorial explains context manager support in the mssql-python driver for Python applications using SQL Server and Azure SQL. It describes how context managers manage connections and cursors, commit successful transactions, roll back transactions when exceptions occur, and close connections automatically.

### Source excerpt

Reviewed by: Sumit Sarabhai and Gaurav Sharma If you've worked with databases in Python, you know the boilerplate: open a connection, create a cursor, run queries, commit or rollback transactions, close cursors and connection. Forgetting just one cleanup step can lead to resource leaks (open connections) or even inconsistent data. That's where context managers step [...] The post Simplifying Resource Management in mssql-python through Context Manager appeared first on Microsoft for Python Developers Blog.