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
Azure Master Class

Azure Master Class with John Savill
Live Online Training: Thursdays August 10th to August 31st
Register by August 3rd and Save 20%!

Every organization is currently evaluating how they can utilize the public cloud, what it means, and how to actually get started. 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) ×