Identify Tables With Dropped Columns
On my last article - What happens when we drop a column on a SQL Server table? Where’s my space? - I have shown what happens when we drop...
2024-07-22 (first published: 2024-07-09)
385 reads
Deleting Old Local Git Branches–#SQLNewBlogger
I had a lot of local branches for a repo (actually a few repos). I know these are old and not used anymore, so how do I delete them?...
2024-07-08
40 reads
Use Your Voice
If you want more of a career and less of a job, one thing you will have to do is learn to use your voice. I mean this on...
2024-07-08
42 reads
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've been yearning for a risk-free environment to test, experiment, and refine your SQL queries against...
2024-07-17 (first published: 2024-07-06)
382 reads
Set a Runtime Variable in an Azure DevOps Pipeline
Note: I DO NOT recommend this. Any changes to a pipeline should be in code and through a PR. That being said, I know this information is out there...
2024-07-22 (first published: 2024-07-05)
357 reads
A New Word: Symptomania
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly captures the kind of person you are, tying together your many flaws and contradictions into...
2024-07-05
40 reads
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned off, which was strange as that particular database has seen quite a few performance issues...
2024-07-15 (first published: 2024-07-04)
821 reads
Modifying sp_QuickieStore Returned Column Order
I love QuickieStore, but I wanted some columns to be at the front end of the results returned. Namely, I wanted top_waits, query_sql_text, and query_plan right after database name....
2024-07-15 (first published: 2024-07-03)
323 reads
EightKB 2024 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced! We’re kicking off at 1pm UTC on August 8th (8th of the 8th…get it? 🙂...
2024-07-03
84 reads
Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory
I had a customer that was looking to document a restore that had occurred on one of their systems and didn’t see it. They had concerns about SQL Server...
2024-07-03
697 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers