Upgrading to SQL Server 2014 – Campus Days talk (slides in Danish)

Below you will find slides, demos, and references for my Campus Days talk on “Upgradring to SQL Server 2014”. The slides are in Danish, as it was a Danish conference.

Slides

Demos

Demos can be found at github.

Further reading / references

Upgrading to SQL Server 2014 – Campus Days talk (slides in Danish)

Integration Services (SSIS) for the DBA

Below you will find slides, demos, and references for my PASS Summit 2014 talk on “Integration Services (SSIS) for the DBA”.

Slides

Demos

Demos can be found at github.

Further reading / references

Integration Services (SSIS) for the DBA

Bulk load: methods for better data warehouse load performance

Slides and demo scripts are now available for my talk at SQLSaturday #337 Oregon today.

Abstract

When loading a data warehouse you want the data inserted into the tables as fast as possible. You know you have to use bulk loading, but what do you need to do to ensure a minimal footprint on the transaction log? In this session, you will learn about minimal logged operations. You will also learn about the different methods for bulk loading data into your data warehouse; using SSIS, BCP and T-SQL.

Slides

Demos

Demos can be found at github.

Bulk load: methods for better data warehouse load performance