Blog Post

FabCon Vienna 2025 Recap

Holy cow FabCon Vienna was incredible! This recap is extremely delayed because I’ve run into some serious decision fatigue about what to include (and my amazing hubby got me...

2025-11-18

26 reads

Blog Post

Power BI PBIR Format Admin Setting

The Power BI Enhanced Report Format (PBIR) will soon become the default, and that’s a good thing because it significantly makes git integration easier. You can already enable it...

2025-11-20 (first published: )

164 reads

Blog Post

Advice I Like: Failure

If it fails where you thought it would fail that is not a failure. – from Excellent Advice for Living This is a great quote, especially for those of...

2025-11-28 (first published: )

446 reads

Blogs

Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents

By

(This is the third post in a three-part series on how AI is changing...

SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL

By

Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...

Yippee-Kai-Yay 2027 Summit in Denver

By

Next year the PASS Data Community Summit is in DENVER! and London, but Denver...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance, which is...

Life hack that has worked well for me

By skeleton567

I wrote about this several years ago but will contribute again a life hack...

Trying to make this faster using not exists

By krypto69

Hi I have this query that is slow during the 'not in' part of...

Visit the forum

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.beer
What happens?

See possible answers