Funny Money: #SQLNewBlogger
While wandering around the documentation looking for some Question of the Day topics, I learned something new about the money data type. This post discusses what I learned. Another...
2026-06-10
117 reads
Blog Posts
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a few aggregations — and watched your machine struggle — there's a better tool for the...
2026-06-10 (first published: 2026-05-21)
637 reads
Understanding Fabric Ontology
What problem is Fabric Ontology trying to solve? For years, most data conversations have started with tables. We ask where the data lives, what columns are available, how the...
2026-06-10 (first published: 2026-05-20)
496 reads
Un-Migrating From the Cloud: T-SQL Tuesday #199
This month we have a very interesting invitation from Koen Verbeeck. He has hosted once before, and agreed to help me out this month by tackling another topic. We’ve...
2026-06-09
196 reads
Why Database AI Agents need Layers?
Third part in my Ai series with databases. When building AI solutions within the database realm the first thing that people do is a straightforward concept, connect the LLM...
2026-06-09
217 reads
QUOTENAME Basics: #SQLNewBlogger
Recently I ran across some code that used a lot of QUOTENAME() calls. A colleague was having some trouble with the code, but what struck me was that I...
2026-06-08 (first published: 2026-05-20)
492 reads
When growing companies outgrow Excel
There are some telltale signs that your growing business has outgrown Excel for your reporting needs. Excel is probably the most adopted piece of software out there, and I...
2026-06-08 (first published: 2026-05-20)
412 reads
Keeping your tech ego in check
In my usual twitter doom scrolling, I came across this post the other day Now it’s pretty obvious to me that this is one of the standard “engagement bait”...
2026-06-07
154 reads
A New Word: La Guadière
la guadière – n. a glint of goodness you notice in something that you wouldn’t expect, which is often only detectable by sloshing them back and forth in your...
2026-06-05
58 reads
AI Insights for Database Monitoring: A DBA’s Perspective
Second in a series on Ai and databases. One Story, three signals – I have a backup of a critical database that has failed three times, the recovery point...
2026-06-05 (first published: 2026-06-04)
82 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers