More in SQL Server

  • 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 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 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
  • 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
  • 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
  • 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 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 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 1: Why is SSAS Multidimensional Still Important?  

    Running Time: 58 minutes | In this session, you learn why SSAS Multidimensional is not ready for retirement....More
  • Jul 23, 2014
    Education

    Session 2: Designing Large Cubes  

    Running Time: 60 minutes | In this session, you will learn specific techniques for designing dimensions and cubes to optimize the storage and retrieval of large data....More
John Savill's Azure Master Class

Join John Savill and become an Azure Master!
Thursdays, August 4th through August 25th

Enroll by July 29th and SAVE $130!

This 12 session Master Class will equip you with everything you need to understand, evaluate, deploy and maintain environments that utilize Microsoft Azure including hybrid scenarios.

 

Join the Conversation

Sponsored Introduction Continue on to (or wait seconds) ×