Data Lost in the Cloud
AWS admits some data is was holding is gone forever. We can only hope their customers made copies.
2026-11-18
5 reads
AWS admits some data is was holding is gone forever. We can only hope their customers made copies.
2026-11-18
5 reads
2026-11-18
5 reads
I wrote about Flyway Desktop Object History in a previous tip. This feature has been enhanced, so I wanted to write an update. More History The changes now can...
2026-11-16
31 reads
2026-11-16
74 reads
2026-11-16
788 reads
I had seen these roles in various instances, but never dug into the new Fixed Server roles added to SQL Server. They are supposed to help ensure the principle...
2026-11-16 (first published: 2026-11-04)
136 reads
semaphorism – n. a conversational hint that you have something personal to say on the subject but don’t go any further – an emphatic nod, a half-told anecdote, an...
2026-11-13
31 reads
2026-11-13
1,056 reads
I got an interesting message from my daughter recently. She’s doing graduate studies in Belgium at KU Leuven. Her field is literature and linguistics, and as part of that, she has to analyze various writings. While visiting with her last month, she mentioned that her professor was using R (R Language) and giving them scripts […]
2026-11-13
77 reads
I have a few Azure subscriptions, which are fairly small and not used that often. Mainly I do some SQL Server or Azure SQL experimentation. Sometimes I might create...
2026-11-11 (first published: 2026-11-02)
114 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