Azure Data Factory and the Case of the Missing JRE That Wasn’t
On a recent project I used Azure Data Factory (ADF) to retrieve data from an on premises SQL Server 2014...
2017-05-11 (first published: 2017-05-01)
1,312 reads
On a recent project I used Azure Data Factory (ADF) to retrieve data from an on premises SQL Server 2014...
2017-05-11 (first published: 2017-05-01)
1,312 reads
I’ve spent the last couple of months working on a project that includes Azure Data Factory and Azure Data Warehouse. ADF...
2017-04-11
616 reads
This month’s T-SQL Tuesday – hosted by Kennie T Pontoppidan(@KennieNP) – is called “The daily (database-related) WTF“. He asked us to be...
2017-03-27 (first published: 2017-03-14)
2,794 reads
I showed in my previous post how we generated the datasets for our Azure Data Factory pipelines. In this post, I’ll...
2017-03-21 (first published: 2017-03-10)
1,746 reads
Apologies for the overly acronym-laden title as I was trying to keep it concise but descriptive. And we all know...
2017-03-03
630 reads
I spent a good bit of time looking for the definitions/descriptions of the TMSCHEMA DMVs that allow us to view...
2016-11-07
778 reads
A client wanted to upgrade their SSAS model to SSAS 2016 to take advantage of some of the features of...
2016-10-21 (first published: 2016-10-14)
4,916 reads
If you were used to documenting your SSAS model using the MDSchema rowsets, you might have noticed that some of them...
2016-10-05
1,419 reads
This is just a quick note (since I apparently forgot and was puzzled for a moment) that the MDSCHEMA_CUBES DMV...
2016-09-21
504 reads
I was working on a SSAS Tabular 2016 solution for a project for which I had no data (an empty...
2016-09-03
666 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