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
924 reads
Articles
Exploiting SQL Server Date Correlation Optimization: How Tampered Backups Enable Cross-Database Data Leaks
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.
2026-01-30
Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform
This next article in the Fabric Modern Data Platform looks at DuckDB, an analytical database platform designed for analytics
2026-01-28
1,724 reads
T-SQL in SQL Server 2025: Fuzzy String Search I
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 […]
2026-01-28 (first published: 2026-01-16)
3,139 reads
Power BI Quick Reference Guide
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?
2026-01-28
Building a Real-Time Analytics Pipeline with Azure Stream Analytics and SQL Server
Learn how a real time analytics solution for ETL and reporting can be built with SQL Server, Power BI, and Stream Analytics.
2026-01-26
1,310 reads
How to Create a SQL Server Linked Server to Oracle 26ai Free
Easily move data from SQL Server to Oracle 26ai Free with this step-by-step guide.
2026-01-26
T-SQL in SQL Server 2025: Fuzzy String Search II
In the last article, we examined fuzzy string matching in SQL Server 2025 with a few new functions. We know 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 […]
2026-01-23
2,094 reads
Sending messages to Slack from SQL Server 2025
In an earlier tip, A history of accessing REST APIs and web pages from SQL Server, I talked about reaching out to external endpoints from SQL Server, including the new sys.sp_invoke_external_rest_endpoint procedure that hit the on-premises editions in SQL Server 2025. This seemed like an ideal use case to enhance our current solution for sending a message to Slack: using xp_cmdshell to call a PowerShell script that calls Invoke-RestMethod. In this tip, I’ll describe how we changed our implementation and why it is a marked improvement for us.
2026-01-23
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,547 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Alamat Kantor BCA KCU Green Garden Tlp:08217555651
Hub Via Wa:628217555651 Alamat: Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3,...
Alamat Kantor BCA KCU Sunter Telp:08217555651
Hub Via Wa:628217555651 Alamat: Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18,...
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers