Spring Boot + PostgreSQL
Advanced Performance Tuning in 2026Continue reading on Towards AI »
coding, programming, spring-boot, sql, Technology
sql
data-analysis, data-analytics, data-engineering, query-optimization, sql
5 SQL Mistakes I Made as a Junior Analyst (That I Still See Seniors Making)
A confessional guide to the queries that burned me — and the fixes I wish someone had shown me on day one.I’m going to tell you something embarrassing.Three months into my first data analyst role, I brought down a production dashboard. Not with some ex…
ChatGPT, data-engineering, generative-ai-tools, github-copilot, sql
How AI Writes SQL for You — and When Not to Trust It
ChatGPT, Copilot, and Gemini can write SQL fast. Sometimes it’s brilliant. Sometimes it’s subtly wrong in ways that will ruin your numbers. Here’s how to tell the difference.SQL is the language of data. If you work anywhere near a database, you’re writ…
sql, SQLite
SQLite 3.53.0
SQLite 3.53.0
SQLite 3.52.0 was withdrawn so this is a pretty big release with a whole lot of accumulated user-facing and internal improvements. Some that stood out to me:
ALTER TABLE can now add and remove NOT NULL and CHECK constraints – I’ve …
data-governance, dbt, snowflake, snowflake-cortex, sql
Scaling Data Governance: Autogenerating Documentation and Tags with Snowflake Cortex and DBT
Image Generated by GeminiIn the modern data stack, the “Build” phase is usually fast, but the “Govern” phase is notoriously slow. We’ve all been there: you finish a complex Snowflake pipeline only to realize you now have to manually write descriptions …
Artificial Intelligence, data-science, sql, sql-for-beginners, sql-tutorial
SQL Fundamentals: A Hands-On Guide to Working with Databases
IntroductionContinue reading on Medium »
analytics, edge computing, high availability, sql
Why High Availability at the Edge Is the Next Frontier for SQL Server
The edge is where it all happens. It is where innovation is created and where it is delivered. SQL Server workloads must therefore be just as resilient and highly available there as they are in the cloud or in a traditional data center.
The post Why …
agentic-engineering, ai-assisted-programming, sql, SQLite, tools
Syntaqlite Playground
Tool: Syntaqlite Playground
Lalit Maganti’s syntaqlite is currently being discussed on Hacker News thanks to Eight years of wanting, three months of building with AI, a deep dive into exactly how it was built.
This inspired me to revisit a res…
analytics-engineering, data-engineering, dbt, sql
dbt Explained Simply — and How AI Makes It Even Easier
You keep hearing about dbt. Your data team uses it. Job listings mention it. Here’s what it actually is, why engineers love it, and how AI tools are making it accessible even if you’ve never touched it before.If you’ve spent any time in data circles re…
data-analysis, data-engineering, power-bi, python, sql
I Automated My Entire Weekly Report With Python in Fabric Notebooks — Here’s the Exact Code
Every Monday morning for eight months, I spent three hours copying numbers into a spreadsheet. Then I spent one Saturday afternoon building the thing that gave those hours back forever.Every Monday morning, without fail, for eight straight months — I m…