The SQL Server 2016 version of Integration Services includes many new features. In this course, What's New in SQL Server 2016 Integration Services, you'll explore all of those latest features in great detail. First, you'll learn how to use new control flow tasks and data flow components in Integration Services packages. Next, you'll discover how to configure Integration Services, set up packages to use SQL Server high availability and data encryption features, and to perform data integration with the Azure platform. Finally, you'll dive into learning about the new deployment and logging options. By the end of this course, you'll have a clear understanding of what's new in Integration Services and how to start using the features that matter most to you.
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.
Course Overview Hi. I'm Stacia Varga, and welcome to my course, What's New in SQL Server 2016 Integration Services? I'm a business intelligence consultant and instructor at Data Inspirations, a company I started back in 2006 to help people understand what their data is telling them. There's actually quite a lot of new things in this particular release, probably the most new things that I've seen in integration services since it first was released in SQL Server 2005, so in this course we're going to go down every nook and cranny to see what's new, see how it works, and explore a few implications about these new features that might not be so obvious on the surface. So what is new in this release? Well, there's several features that affect package development, features that are supposed to make it easier for you to build your packages more efficiently and faster. Also in this release, support has been added for high availability and data encryption features that exist in SQL Server 2016, and we'll look at what's included in the Azure Feature Pack for SQL Server 2016. Then last, we'll wrap up this course by exploring the features that help us deploy and manage packages, things like performing incremental deployments, and new ways to capture logging information about package execution. Now you can watch this course from beginning to end, which I hope you do, or you can just dive in wherever you need to and learn exactly what you need about the features that matter most to you.