This article shows a technique for cleaning out older data from PostgreSQL tables using Python to follow a set of rules you create.

There Are a Lot of Databases

by Steve Jones

SQLServerCentral

Databases

Steve notes today that there are many, many database platforms out there you can use for your next application.

Exploiting SQL Server Date Correlation Optimization: How Tampered Backups Enable Cross-Database Data Leaks

by Additional Articles

SimpleTalk

SQL Server security

This article is a follow-up to SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data, in which we saw some vulnerabilities that affected pretty much all DBaaS offerings available in the cloud. Now, we’ll look at another vulnerability that once again affects every major cloud vendor.

Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform

by John Miner

SQLServerCentral

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

This next article in the Fabric Modern Data Platform looks at DuckDB, an analytical database platform designed for analytics

T-SQL in SQL Server 2025: Fuzzy String Search I

by Steve Jones

SQLServerCentral

Comparing strings has always been hard when we don't have great data quality. If we need exact matches, SQL Server works great. However, we often expect users to enter values without typos and know what values they want to find. Or at least know part of the string. However, matching with wildcards or partial strings […]

Power BI Quick Reference Guide

by Additional Articles

MSSQLTips.com

Power BI

I need a structured reference guide to help me get started or expand on Power BI knowledge. I want to be able to bookmark a resource and then use it daily when needed as I build my data sets, reports, and dashboards. Can you please enumerate some common and helpful resources as a Power BI Quick Reference guide?