Cloud Concerns
Security is a concern in the cloud, but should it be your number one concern? Steve Jones notes that business continuity might be a bigger issue.
2026-11-11 (first published: 2012-12-13)
268 reads
Security is a concern in the cloud, but should it be your number one concern? Steve Jones notes that business continuity might be a bigger issue.
2026-11-11 (first published: 2012-12-13)
268 reads
Yesterday was the first day of sessions at the PASS Data Community Summit (after pre-cons on Monday). It’s a smaller event, but fun and more intimate. A few long...
2026-11-11
82 reads
2026-11-11
794 reads
Next year the PASS Data Community Summit is in DENVER! and London, but Denver is the big news. My hometown and I’m excited. And tickets are cheaper. $799 now,...
2026-11-11
54 reads
This is an interesting invitation this month. Jeff Ianucci is a new host, and also has agreed to start taking over some of the T-SQL Tuesday management. Mike Walsh...
2026-11-10
40 reads
I’m really excited about some growth in Flyway support. I’ve been asking about this for some time and we now have Databricks and Snowflake support. I’ve been working with...
2026-11-09
45 reads
2026-11-09
74 reads
2026-11-09
1,222 reads
I was looking over the CHOOSE() function while editing an article at SQL Server Central. I realized there isn’t a documentation note on how many parameters can be included....
2026-11-06 (first published: 2026-10-28)
353 reads
2026-11-06
95 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