Python Day 2024 Slide Deck Summary

Is there a free version of SQL Server or Azure SQL?

• Yes, there is a free version of SQL Server called SQL Server Express Edition.
• Azure SQL also offers a free tier with limited resources for development and testing purposes.

Can I run SQL Server on Linux?

• Yes, SQL Server can be run on Linux using Docker containers or installed directly on a Linux machine.

Why should I bother about Azure SQL or SQL Server? Why you keep saying “Azure SQL and SQL Server”? Are they different?

• Both Azure SQL and SQL Server are relational database management systems, with Azure SQL being a cloud-based service while SQL Server can be deployed on-premises or on cloud VMs.
• Azure SQL offers scalability, built-in security features, and high availability compared to traditional SQL Server deployments.

Which version should I choose to get started?

• For beginners, SQL Server Express Edition or Azure SQL Free Tier are great options to get started with.
• As you advance, you may look into different editions of SQL Server or Azure SQL based on your requirements.

What library can I use to connect to SQL Server using Python?

• pyodbc and pymssql are popular libraries for connecting to SQL Server from Python.
• pandas and sqlalchemy can also be used for interacting with SQL databases in Python.

---

The session at Python Day 2024 covered topics such as integrating with Langchain and creating an end-to-end chatbot using Azure SQL and SQL Server. The slide deck provided a comprehensive overview of SQL Server and Azure SQL, their differences, and how Python developers can leverage these technologies. The presentation is available online for further reference and the recorded session demonstrates practical examples of integration and development with Azure SQL and SQL Server.