Power BI Fun With Travels
I’m back from a great vacation. I had the chance to visit two new countries (for me and my wife) and many new cities as we cruised around the...
2026-10-23 (first published: 2026-10-22)
1,319 reads
I’m back from a great vacation. I had the chance to visit two new countries (for me and my wife) and many new cities as we cruised around the...
2026-10-23 (first published: 2026-10-22)
1,319 reads
2026-10-16
1,137 reads
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that Look Too Easy. I decided to give you a few thoughts from me on the...
2026-10-14 (first published: 2026-10-05)
397 reads
2026-10-14
907 reads
This is timely, as I’m currently on a boat in the Adriatic taking a break with my wife. I think I’m in Croatia (or off the coast) today, but...
2026-10-13
70 reads
2026-10-12
577 reads
2026-10-09 (first published: 2014-07-24)
286 reads
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the object history for different schema changes, so as you are evaluating how your changes might...
2026-10-09 (first published: 2026-09-28)
201 reads
2026-10-09
881 reads
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight for Brussels and this is my last day at work for a couple of weeks....
2026-10-07
60 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers