Sessions & Content

Search
Content Type
Conference
Tags
Faster SSIS Andy Leonard
Learn tips and tricks to make SSIS perform better.
Azure Data Factory v2 with Data Flows capabilities Kamil Nowinski
We will review this new feature of ADFv2, do deep dive to understand the mentioned techniques, compare them to SSIS and/or T-SQL and learn how modelled data flow runs Scala behind the scenes.
Biml Tips and Tricks: Not just for SSIS packages! Cathrine Wilhelmsen
Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.
Deeper Integration and New Transformation for SSIS in ADF Sandy Winarko
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR).
How to Make Sure Your SSIS Packages Will Never Fail Guy Glantser
If you never have errors in your SSIS packages, then you don't need to attend this session. But if you want your packages to be reliable and safe, and to handle errors appropriately, then this session is for you.
The Self-Tuning SSIS Package Ben Weissman (he/him)
This session is about using the Business Intelligence Markup Language (Biml) to monitor and control your orchestration patterns. By automatically analyzing the results in ETL logs, we’ll be able to automate our staging orchestration!
Deep Dive into SSIS 2017 and Beyond Jimmy Wong
We will showcase the latest feature of SSIS 2017 such as connectors for Azure Data Lake Store (ADLS), Azure SQL Data Warehouse (SQL DW), SSIS Scale-Out at package level for the box product as well as the SSIS package execution on Azure Data Factory
Solving ETL bottlenecks with SSIS Scale Out Steph Martin
Do you have large-scale SSIS platforms which experience bottlenecks due to the number of packages or volumes of data that need to be processed? Yes! Then you need to explore SSIS scale out.
What’s New with SSIS in ADFv2 Sandy Winarko
See the latest features of SSIS in ADFv2, e.g. ARM VNet, Enterprise Edition, Custom Setup Interface, Execute SSIS Package Activity, etc.
Deep Dive into SSIDB Catalog Prathy Kamasani
A session to understand the available functionality of SSISDB Catalog
Analysing Text with SQL Server 2014 Dejan Sarka
This session introduces SQL Server 2012 and 2014 text mining capabilities.
Building a meta-driven near realtime ETL solution with BIML Rasmus Reinholdt Nielsen
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.
Delivering Agile Analytics with Azure Machine Learning Adam Jorgensen
Does the concept of analytics make you nervous? Are you being asked to do more advanced analysis with existing tools? Come learn how to take your predictive capabilities to the next level with new azure technologies.
Going Asynchronous with Service Broker Jonathan Kehayias
This session will explain the benefits of asynchronous processing in Service Broker compared to other options like SQL Agent jobs or SSIS packages, and how to implement the basic components required.
Increase your SSIS productivity with Biml Reeves Smith
Discover the power of Business Intelligence Markup Language (Biml) and increase your Integration Services development productivity.
SSIS & HDInsight Tillmann Eitelberg
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.
Tools and Tips: From accidental to efficient DWH developer Cathrine Wilhelmsen
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.
Hadoop: Big Data or Big Deal? Eduard Erwee
Hadoop (Big Data) vs SQL Server. A view from a SQL Server DBA / Developer
Performance Tuning SQL Server Integration Services (SSIS) Brian Knight
In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS).
Practical Unit Testing for SSIS Packages John Welch
Unit and integration testing for SSIS packages can be challenging. Come to this session to learn how to leverage open-source tools to drive the testing of your packages and the resulting data.
Cleaning Up Dirty Data with SSIS Tim Mitchell
In this session, we'll review methods for cleaning up dirty data using SQL Server Integration Services. We will review the various cleansing tools accessible from within SSIS including native components, T-SQL, SSIS scripting, and DQS.
ETL shootout-SSIS vs Powershell Andre Kamman
I know what you're thinking, Powershell is not an ETL tool. And you're probably right. But I keep running into weird requests that were just easier to fix with Powershell. I'll show you why some things are not easy in SSIS.
Scaling Out SSIS With Parallelism Chris Adkin
An introduction to scaling out packages using parallelism with the "Work pile" pattern, balanced data distributor and "Roll your own" techniques.
SSIS 2012 logging and monitoring Peter ter Braake
In this session we will learn about the SSISDB catalog views. We will use this info plus our own info to build a monitoring solution for SSIS using SSRS.
A better SSIS? Migrating a datawarehouse to SQL Server 2012 Andre Kamman
SSIS in SQL Server 2012 has a lot of new features to help control larger projects. I'm doing a trial migration of our datawarehouse (100+ packages, 1TB+ db size) This session will be a will be a walkthrough of this process and a lessons learned
A lap around the SSIS Catalog Jamie Thomson
SQL Server Integration Services (SSIS) 2012 includes a new database referred to as the SSIS Catalog. Come to this session to learn what it does and how its going to change how you do SSIS development.
Accelerating BI Projects with Varigence Varigence
Learn how Varigence tools accelerate BI development, enhance reusability, and improve agility through the use of customizable patterns and automation scripts and transform your metadata into comprehensive BI solutions.
Loading Data Warehouse Dimensions in SSIS Alex Whittles
This session looks at some of the different methods available to load slowly changing dimension data into a data warehouse, and compares the relative performance given different data scenarios and traditional storage compared with FusionIO
SSIS in SQL Server 2012, Part 1: Developer Enhancements Matt Masson
This demo intensive session will show off the new features and enhancements designed to ease adoption for new users and increase productivity for experienced SSIS developers
SSIS with BidsHelper-Getting into BIML Varigence
Learn all about the integration of Business Intelligence Markup Language (BIML) into BIDS Helper and see what it can do for you. BIML can help you automate the creation of SSIS packages, reduce maintenance and help code re-use across projects.
Unit Testing SSIS Packages John Welch
Unit testing is incredibly beneficial, but is very difficult to do effectively in SSIS. If you have wanted to do this, but aren't sure how, this session will cover the options and demonstrate a free tool for unit testing packages.
Creating a Meta Data Driven SSIS Solution with Biml Marco Schreuder
In this session you'll get a good introduction of the concepts and advantages of Biml as we walk to the creation of Meta Data Driven SSIS Solution.
Designing an SSIS Framework Andy Leonard
In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging.
Handling Advanced Data Warehouse Scenarios in SSIS John Welch
Do you have complex dimensions in your data warehouse? Parent-child, late arriving, type 3 or type 6? In this session, we'll cover some SSIS patterns for handling each of these, along with tips for making them perform well.
28 Weeks later - How to scale-out your MS Business Intelligence environment Sascha Lorenz
The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.
Back to the SSIS Future Jamie Thomson
A look at the new SSIS features in SQL Server code-named Denali
Executing SSIS Packages Peter Doyle
Executing SSIS Packages and handling the errors
SSIS Custom Components Dave Ballantyne
Writing your first SSIS custom components can seem like a very steep learning curve. In this session i shall walk you through a simple skeletal one to start you on your way.
SSIS Dataflow Performance tuning Jamie Thomson
Building performant data flows takes more than just dragging a few boxes onto a design surface. In this session I'll demonstrate that SSIS perf tuning is less about fine-grained tweaks and more about designing packages correctly in the first place.
Attunity Change Data Capture for SSIS Attunity
Attunity will be presenting their award winning change data capture (CDC) products for SSIS. This session will discuss whatchange data capture is, why it's used, and will demonstrate how CDC processingcan be seamlessly integrated into SSIS.
Automating SSIS Andre Kamman
I had to import and process 100+ files for my latest project and wondered if there was a way to generate SSIS packages based on a repository table containing the rules. As it turns out, this can be done but the programming model is a bit awkward. The samples that you can find online are not allways functional and debugging is difficult. I did get it to work though and will show you how I did it and what problems I ran into. After this session you will know how to generate packages that contain sources, destinations, cached lookups, derived columns, conditional splits, sorts, union all, etc. This session is not about the script component inside SSIS but about generating SSIS packages and programmatically reading and changing properties of existing packages.This session should also be usefull if you're not a full blown developer but more of a DBA type. I'm a DBA and I got through this :-)
Designing and Tuning high speed data loading Thomas Kejser
My Name is Thomas Keyser and I work for Microsoft in the SQLCAT team. I hold the land speed record for data loading in SQL Server so come here my talk on the options you have.
SSIS Dataflow Performance tuning Jamie Thomson
Need to eek out a bit more oomph from your dataflows. This session might be of some use.
SSIS Fieldnotes Darren Green
After years of careful observation and recording of the Species SSIS, Genus ETL, in both natural and artificial environments, I’ve gathered a large collection of fieldnotes. Find out the little decisions that get made that can have big impacts on you project later on. What option to choose for better performance, or better management, and what are the trade-offs? This session won’t just focus on holy grail of performance, it will review the way you build and use SSIS taking into account the on going maintenance and management aspects as well.
Design patterns for SSIS Performance Darren Green
Do you wonder about SSIS performance? Well I do, and I've compiled my research into this session. We'll cover various design patterns for solving common problems like inserts vs. updates, is it faster to use a lookup, or can you just catch the errors and process them afterwards? As well as the richer patterns we'll look at some straight comparisons between two components that can be used to do perform the same task and ask which one is quicker?
Designing and Tuning high speed data loading Thomas Kejser
If you want to understand how to load data into Sql Server very quickly then this is the session for you.
Fast Track Foundations: Get Serious about Sequential I/O James Rowland-Jones
Fast Track is a new reference data warehousing architecture provided by Microsoft. More than this it represents a new way of thinking about data warehousing. A Fast Track system is measured by its raw compute power - not by a DBAs ability to tune an index. Fast Track is an appliance-like solution that delivers phenomenal performance from a pre-defined, balanced configuration of CPU, memory and storage using nothing but commodity hardware. Of particular interest in a Fast Track system is the way in which the storage and SQL Server are configured. To achieve the fantastic throughput without using SSDs requires some careful configuration. This configuration is designed to make use of Sequential I/O to dramatically improve disk I/O performance. Interested? If you have a large data warehouse that's seen better days or perhaps you are about to embark on a new warehousing project then you should be! Fast Track is a great solution with a fantastic value proposition. In this one hour session we'll aim to get under the skin of Fast Track and get some answers as to how it delivers such great throughput on commodity hardware. In the process we'll aim to answer the following questions: * When might I need Fast Track? * What is Sequential I/O? * How does Sequential I/O improve performance? * What do I need to do to get Sequential I/O? * How can I monitor for Sequential I/O ? * What may I need to change in my ETL to get the benefit of sequential I/O? Still reading? I'll save you a front row seat....
A whistlestop tour of SSIS add-ins Jamie Thomson
There are a number of 3rd party add-ins available that may aid your SQL Server Integration Services (SSIS) development. In this session I will demonstrate some of them.
Common Integration Services Problems Allan Mitchell
Common Integration Services Problems and Solutions
SSIS in SQL Server 2008 Allan Mitchell
A look at some of the things that make using SSIS in SQL Server 2008 a very good choice for your ETL requirements
<<12>>