Siddharth Tandon's Blog

  • Article

Workaround for Identity column in APS

While working on a problem which involves migrating SSIS package from SQL Server to APS, there was...

Author: SiddharthTandon1990 Date: 09/24/2015

Truncate Table referenced by a Foreign key

Last night, I was truncating some tables from an alien database, and while truncating one table I...

Author: SiddharthTandon1990 Date: 05/20/2015

Use Microsoft Translator APIs & SQL CLR for language translation in SQL Server

Recently I got the chance to explore the Microsoft Translator API. As per technet gallery, the API...

Author: SiddharthTandon1990 Date: 04/13/2015

Compare Look up transformation over Truncate load in case of Incremental load

While populating data warehouse, we have to do incremental load, and to do so, there are multiple...

Author: SiddharthTandon1990 Date: 04/08/2015