Tim Mitchell Founder and Principal Data Architect at Tyleris Data Solutions LLC

Could your seemingly normal SQL Server Integration Services (SSIS) package be hiding a disaster, waiting to detonate at the most inconvenient time? Integration Services is an incredibly flexible product, and that flexibility can lead to good—and occasionally bad—design patterns. Small and seemingly trivial design decisions can lead to big issues down the road, including leaky data flows, data quality issues, paralyzing performance problems and other explosive behaviors. In this session, we will explore some of the most common SSIS design patterns that are potentially more harmful than they first appear. From package configuration to control flow constraints, and data flow transformations to logging, we'll demonstrate what can go wrong and show some alternative designs that can prevent these types of problems from developing into bigger issues.

PPT Download

For years, SQL Server Reporting Services and Power BI lived in their own separate worlds: SSRS as an on-premises solution and Power BI in the cloud. However, with the release of Power BI Report Server, SSRS and Power BI can live happily together as an on-premises solution. In this presentation, we'll cover the basics of Power BI Report Server. We'll discuss the essential moving parts and will walk through what your organization will need to get started using this new union of Power BI and SSRS.

PPT Download