It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Azure Data Factory and SSIS are both data movement tools, but built for different purposes. In this session you will learn pros and cons of using each technology, and best practices of using each in real world scenarios.

This all demo session build around a real life case study from one of the largest organizations in the world. will take you through a case of how to build a completely meta-driven SSIS solution relaying on BIML and MDS to do the hard-work for you.

Need to automate a process in your database? Create audit tables, generate stored procedures, or any other type of manually repeatable process? In this session we'll look at how to start and the thought processes and design considerations involved.

In this session, we show how SSIS and HDInsight can work together, as well as how Hadoop jobs can be executed and how data can be transferred with SSIS between HDInsight, SQL Server, and other sources or destinations.

As data warehouse developers we deliver data to business users... but we don't deliver data as fast as we want. There are many things you can do to increase your own productivity and become a more efficient data warehouse developer.

Join me for an hour of playing with different ETL patterns by using Clustered Columnstore Indexes. Using different Hardware might lead you to different conclusions,and the size of the workload is always the paramount of your performance.Loading data first and then creating a Clustered Columnstore or creating Clustered Columnstore and than loading - join me to find the answers!

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years and have all been given the MVP award by Microsoft