I’ve been using the SSMS preview for v21. This is the next evolution of SSMS, where the VS shell is…
Browsing: SQL
I’m excited to announce that on June 17 – 18, 2025, I’ll be running a special Online Live Training event…
I’ll walk through the KDA UI and tackle the first challenge before diving into the real cases.The UI layoutThis is…
I was chatting with a customer recently and they wanted to know which host was sending in queries that were…
I heard someone say recently that you can’t change a primary key value in a row. That’s not the case,…
Photo by Lucian Alexe on Unsplashpg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database as…
If you ever wondered why a query that looks harmless is performing poorly despite having indexes in place, the answer…
In this post, I will guide you on how to deploy a dockerized simple flask-based TODO application to Azure Container…
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best way). It was incredible to see…
Photo by Markus Winkler on Unsplash This came up one day at my work when a developer was using it.…