More in SQL Server

  • Mar 3, 2015
    Education

    Session 3: Managing Security in SSIS  

    Presented by: Tim Mitchell | Running Time: 62 minutes In this session, we'll cover the essentials of securing the SSIS catalog. We will walk through security of individual packages, including package/project protection levels. We will cover the configuration story, and demonstrate how to properly secure sensitive information (such as connection strings) outside of the package. Finally, we will discuss and demonstrate security in the catalog itself, including management of who can (and cannot) browse, edit, and execute packages....More
  • Mar 3, 2015
    Education

    Session 2: The SSIS Execution Life Cycle  

    Presented by: Tim Mitchell | Running Time: 65 minutes In this session, we'll cover the life cycle of a package post-deployment. Specifically, we'll address the different ways in which packages may be executed from the SSIS catalog, monitoring in-progress packages, and proper logging techniques. This presentation will be mostly demo, so attendees will get a driver's seat perspective on what is involved in managing packages deployed to the SSIS catalog....More
  • Mar 3, 2015
    Education

    Session 1: Exploring the SSIS Catalog  

    Presented by: Tim Mitchell | Running Time: 65 minutes In this session, we will walk through the SSIS catalog: its moving parts, the deployment story, and day-to-day management. We will examine how packages are stored in the catalog, how package configurations have changed (for the better!), and what takes place during a package execution. Much of this presentation will be demo-based, so you'll get to see all of these moving parts in action....More
  • Mar 3, 2015
    Education

    Session 3: Using Service Broker to do ETL from an OLTP Database  

    Presented by: Allen White Running Time: 67 minutes Most of the time you'll see Extract, Transform, Load (ETL) being done with a tool such as SSIS, but what if you need near-real time reporting? This session will demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database....More
  • Mar 3, 2015
    Education

    Session 2: Insuring Successful Business Data Delivery with Service Broker  

    Presented by: Allen White Running Time: 69 minutes How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and provide a consistent delivery of your business data....More
  • Mar 3, 2015
    Education

    Session 1: Demystifying Asynchronous Messaging  

    Presented by: Allen White | Running Time: 69 minutes Service Broker is seldom used because it isn't well understood. In this session, Allen will walk you through the basics of Service Broker, including the components involved in getting messages sent from one place to another. He will talk about both normal and external activation, where an application – rather than a stored procedure – receives and processes the messages, and he'll discuss strategies to handle various problems like poison messages....More
  • Jul 23, 2014
    Education

    Session 3: Advanced Catalog Customization  

    Running Time: 63 minutes | A deep dive into SSIS execution in the SSIS Catalog commensurate with a deeper look at the SSIS Catalog reporting solution built into SQL Server management Studio. Included is a discussion about security, roles, and the implications of both to the enterprise data integration life cycle....More
  • Jul 23, 2014
    Education

    Session 2: Catalog Features  

    Running Time: 70 minutes | An exploration of SSIS Catalog functionality applied to the modern data integration enterprise, featuring discussion and demonstrations of SSIS project and package parameters, SSIS project connection managers, and SSIS Catalog environments and references. Together, these features facilitate enterprise connections management – one of the most important functions of any data integration framework....More
  • Jul 23, 2014
    Education

    Session 1: Introduction to the SSIS Catalog  

    Running Time: 70 minutes | An introduction to SSIS Catalog installation, features, and operation that provides a solid foundation for data integration developers new to the SSIS Catalog and developers transitioning from SSIS 2005, 2008, or 2008 R2 to 2012 or 2014....More
  • Jul 23, 2014
    Education

    Session 3: Implementing Large Cubes  

    Running Time: 63 minutes | In this session, we teach you how best to manage cube processing when you need to load fresh data....More

Join the Conversation

Sponsored Introduction Continue on to (or wait seconds) ×