Category: Information Systems
Managed Identity between Azure Data Factory and Azure storage
Last month Microsoft announced that Data Factory is now a ‘Trusted Service’ in Azure Storage and Azure Key Vault firewall. Accordingly, Data Factory can...
Introduction to SSIS and making it metadata independent
Introducing SSIS In the Microsoft Sql Server Integration services (SSIS), we have a variety of tasks to perform ETL. However, with changing data landscape and newer...
Azure Synapse Analytics: Azure SQL Data Warehouse revamped
Prologue On 5th November 2019, I read an early morning announcement of Azure Synapse Analytics. It was formerly known as Azure SQL Data warehouse. This announcement took...
Comparing SSIS Lookup and SQL Joins
Motivating SSIS lookups Denormalization is the stepping stone of data warehouse creation; usually performed to extract the surrogate key of a dimension to a fact table....
Is Artificial Intelligence a threat to Software Engineers?
The fear of the singularity Every threat is an opportunity The Forbes magazine article Software Ate The World, Now AI Is Eating Software reminded me of the movie...
What is a Data Hub: Concepts and Guidelines
The V’s of Big Data: Before Data Hub Life was simple when we restricted ourselves to spreadsheets and relational data stores. Data was structured, databases were...