- Follow Big Data and Analytics on WordPress.com
My latest entries
TagsActive Operations Best Practices Big Data BIML C# catalog.executions catalog.stop_operation Clustered Columnstore Index Compression Data loading Data mapping Data modelling Data Warehouse DB Recovery Model ETL Execution_ID Fact Table Indexes Integration Services Catalogs Lookup Maxdop Minimally logged operations NoSQL Partition Function Partition Switch Partition Switching Partition Switch Out Performance POC Lessons Rebuild Index Rebuild Index Big Table Rebuild Partition Service Pack SQL Joins SQL Log SQL Parameters SQL Server SQL Server 2016 CTP SQL Server environment SQL Server Management Studio SQL Service SSIS SSIS.Catalog SSIS Package Paramater SSIS Project Paramater SSMS Custom Color SSMS Customisation SSMS Project sysobjects Trace Flag 610 TSQL Windows Server
Tag Archives: ETL
This is the third in a series of blogs about partition switching for SQL Server 2014. This blog will focus on the actual Alter Table … Switch statement spoken about in the first blog. A number of steps has to … Continue reading
This is a follow up post on the first post my colleague and owner (Louw Fouche) of sabigdata, wrote around BIML and generating SSIS packages. This article will focus on some of the insights we gained using BIML for Source to … Continue reading
The SQL CAT team has loads of experience in loading large volumes of data using SQL Server Integration Services. Thanks to the team for putting this wonderful post together. Here are highlights plus some of my own tips: Do all … Continue reading
Here is a very interesting site from the SQL Team on their World Record ETL Performance loading 1.18 TB in under 30 minutes.