Back in May 2024, I had the opportunity to write a guest column for Database Trends and Applications Magazine, a publication I once where I once wrote a monthly column on Microsoft SQL Server and Azure SQL for many years. I thought I'd take a moment to bring it to your attention. I'd love to hear your feedback! Cheers, -Kevin Earlier this year, I had the privilege of serving on the organizing committee for the DataTune conference in my hometown of Nashville, Tenn. Unlike many database-specific or platform-specific conferences, which tend to focus on analytics and data science, … [Read more...]
Powerful ETL Technologies in the Microsoft Data Platform
October 31, 2017 by Leave a Comment
POWERFUL ETL TECHNOLOGIES IN THE MICROSOFT DATA PLATFORM Microsoft first truly disrupted the ETL marketplace with the introduction of SQL Server Integration Services (SSIS) back with the release of SQL Server 2005. Microsoft has upped the ante yet again by bringing to market powerful ETL features to the cloud via the Azure Data Factory, which enables IT shops to integrate a multitude of data sources, both on-premises and in the cloud, via a workflow (called a "pipeline) that utilizes Hive, Pig, and customized C# programs. READ MORE... Originally Posted March 03, 2016 … [Read more...]
Is There Such a Thing as Easy ETL?
June 30, 2011 by 1 Comment
E.T.L. That's Extract - Transform - Load. That doesn't sound like a lot of work when all you need to get loaded is a simple Access database or an Excel spreadsheet. In a situation like that, the process is so simple, all you really need to focus on is the L in ETL. There's not a whole lot of E.T. to process, despite how wonderful that movie is. [pun intended] But as soon as your data loading process involves some difficult or sophisticated cleansing or transformations, it gets really, really hard. The other cross-thread that had really caught my interest lately is the USA federal … [Read more...]
