2021-04-23
682 reads
2021-04-23
682 reads
An ETL issue with Excel causes issues, because the users didn't realize a limitation.
2026-01-23 (first published: 2020-10-19)
528 reads
Learn how you can use Change Tracking to incrementally load data with Azure Data Factory
2022-04-18 (first published: 2020-10-13)
16,330 reads
Learn how you can use Polybase technology in Azure Synapse to load data into your warehouse.
2020-07-28
28,162 reads
In this next level of the Stairway to Azure Data Factory, learn how to build your first ADF environment.
2020-01-15 (first published: 2019-09-04)
4,357 reads
There are a variety of days to move data between MongoDB and SQL Server. This article covers some of your options and gives you ideas on which method might work best for you.
2019-07-22
14,073 reads
In this post, Tim Smith will look at some of the considerations for both data rules and logic to prevent invalid data early in the ETRL process.
2018-05-02
3,324 reads
In this post, Tim Smith looks at the different options you can use to audit your SQL Server extracts and loads during the ETL process.
2017-07-04
3,755 reads
People were doing ETL long before ETL packages were invented. Some of those facilities still have worth today
2016-08-15
6,716 reads
Jeremy Kadlec introduces the Enhanced Data Integration Suite (EDIS), a SQL Server T-SQL stored procedure based solution to automate, manage, and audit ETL processes so you no longer have to manually build SSIS Packages.
2016-02-03
6,164 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,...
Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal Sudirman...
Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec. Cilandak, Kota...
Comments posted to this topic are about the item Switching Schema II
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