ETL Atomicity
I still remember the first real ETL process I developed. I was working for a hospital at the time, going...
2016-11-04
759 reads
I still remember the first real ETL process I developed. I was working for a hospital at the time, going...
2016-11-04
759 reads
I’m trying to look back at some of the events of the recent Summit, and Game Night was one of...
2016-11-04
558 reads
Join me online on Tuesday, November 15th at 1:00PM as I host a webinar entitled “Managing Data Warehouse Incremental Loads...
2016-11-04
429 reads
[2016-Nov-04] Open data is like a soup, some people like it hot (or made with all the latest updates); some people...
2016-11-04
624 reads
I have a need to encrypt a column within my SQL Database (Azure). I decided to use Always Encrypted. This feature...
2016-11-04
734 reads
Recently, while applying SQL Server 2012 Service Pack 3, encountered the following error and SQL Patch failed to upgrade.
"The patch...
2016-11-04
6,971 reads
I am so glad that the time has arrived to announce my next project – the Columnstore.NET! This site will incorporate...
2016-11-03
399 reads
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-03
644 reads
I recently wrote an introductory post about the importance of statistics. I just received a reinforcement on how important they...
2016-11-10 (first published: 2016-11-03)
1,236 reads
Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new...
2016-11-03
439 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. 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 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