Importing Excel files into SQL Server using DuckDB and Python
Learn to use DuckDB to read data from Excel and then send it to SQL Server with Python and Pandas.
2026-09-02
4,875 reads
Python
How to get clean, usable data out of SQL Server into Python
Build scalable data pipelines by pushing transformations into SQL and keeping Python focused on analysis.
2026-08-14
Connect an Azure Function to Azure SQL database Using a Managed Identity
In this article, you’ll learn step-by-step setup, Python code implementation, troubleshooting, and best practices to ensure your solution is secure and scalable.
2026-07-20
1,657 reads
You Probably Don't Need a Vector Database
Introduction Conversations about RAG almost always start with a vector database. This article suggests you dig deeper before implementing one.
2026-06-19
1,342 reads
What Happens When You Ask a Local AI to Query Your Database?
Learn how you can run a simple LLM on your own machine with Python.
2026-06-17
4,173 reads
How data scientists work with PostgreSQL from Python (and how to write queries that don’t break at scale)
In this article, learn how PostgreSQL powers data science workflows, including query execution, performance optimization, indexing, data retrieval, and more.
2026-06-12
Python is good, but not perfect – here are 10 reasons to avoid it
Four years ago I wrote a blog on this site explaining why Python is better than C# and, arguably, most other programming languages. To redress the balance, here are 10 reasons why you might want to avoid getting caught up in Python’s oh-so-tempting coils – particularly when building large, long-lived systems.
2026-03-02
Automating Database Cleanup for PostgreSQL Using Python
This article shows a technique for cleaning out older data from PostgreSQL tables using Python to follow a set of rules you create.
2026-01-30
998 reads
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
We have a script that can be used to help tune ind...
2026-01-21
1,718 reads
How to Build an AI-Powered T-SQL Assistant with Python & SQL Server
If you’re a SQL Server DBA or developer looking to harness AI for your everyday scripting workflows, this article will walk you through building an AI-powered T-SQL assistant using Python and SQL Server.
2025-11-19
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I