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
728 reads
Python
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,100 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
2025-11-17
3,631 reads
Implementing PostgreSQL with Python for Real-Time Logging and Monitoring
Learn how you can create a logging module in Python that can be used to insert real-time records in a PostgreSQL database and display them on a dashboard.
2025-11-12
1,710 reads
Getting Started with Bayesian Modeling
Multivariate analysis in data science is a type of analysis that tackles multiple input/predictor and output/predicted variables. This tip explores the problem of predicting air pollution measured in particulate matter (PM) concentration based on ambient temperature, humidity, and pressure using a Bayesian Model.
2025-09-19
Using the FP-Growth Algorithm to Mine Useful Patterns in Data
This article looks at using the FP-Growth algorithm from Python to mine data in SQL Server.
2025-09-08
2,738 reads
Using psycopg2 to Connect Python to PostgreSQL
Learn how to connect to a PostgreSQL database from Python with this popular library.
2025-09-02 (first published: 2025-08-25)
2,016 reads
Load Data into Snowflake Using Python with Pandas
Loading data into Snowflake is a common need. Using Python and pandas is a common go-to solution for data professionals
2025-04-21
Dynamic T-SQL Script Parameterization Using Python
Learn how dynamic SQL and sp_executeSQL can be used together from Python.
2025-03-24
3,676 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers