Free SQL Server Training Webinars

We provide an array of sessions for those needing introduction, mid-level and even expert topics. Over 300 SQL Server data platform topics are covered including topics great for DBA’s and BI/Analytics professionals.   

Enhance your SQL Skills with Pragmatic Works 2 times a week.

 

Speaker Description
John Welch John Welch

Accelerate your Development Life Cycle with Azure

Instructor: John Welch

Date/Time: 4/23/2014 11:00 AM

Today's business environments change quickly. Companies want to take advantage of new opportunities as soon as they arise, with ever-tightening deadlines for their IT groups to support these new initiatives and deliver value. It's critical that as IT and data professionals, we look for ways to deliver faster, while still providing quality solutions. During this session, we'll look at how you can use Azure as part of your data related projects to accelerate the time to value for the business, with less up-front time and dollar investment.

Jason Strate Jason Strate

Getting Started with Windows Azure and SQL Databases

Instructor: Jason Strate

Date/Time: 4/22/2014 11:00 AM

The Microsoft Windows Azure platform provides service-based offerings for your data needs. These include services from file storage to SQL databases that are scalable to your specific needs. Regardless of the size of your data platform, Windows Azure has options that fit to your business needs. In this session, we'll discuss the Windows Azure platform and discuss how the SQL Database and other services enhance and extend your data platform. By session end, you'll understand how Windows Azure is able to fit into your environment and be ready to start using Windows Azure.

Adam Jorgensen Adam Jorgensen

Why the cloud is your best strategic opportunity

Instructor: Adam Jorgensen

Date/Time: 4/21/2014 11:00 AM

Today’s businesses are experiencing exciting growth. This renewed growth requires the need for improved strategies to scale and grow while remaining flexible and agile. Gartner and Forrester are backing this up with their push to evaluate the cloud market as a top strategic priority for today’s modern business. Join Tim Moolic and Adam Jorgensen COO and President of Pragmatic Works as they bring their decades of experience to discuss why and how the modern business re-platforms at a fraction of the effort and cost by using the cloud for data, applications, and analytics. This session will include specific customer cases and high level customer architectures along with a C-Level guide to the state of the cloud and it’s benefits for your organization.

Brian Knight Brian Knight

How to use Power Query as your Self-Service BI ETL tool

Instructor: Brian Knight

Date/Time: 4/18/2014 11:00 AM

In a Self-Service BI environment there is a need to import, transform and cleanse data from various sources just like in your traditional BI world. Let me show you how Power Query can perform these same tasks and introduce you to the M language.

Devin Knight Devin Knight

Creating Power Map Reporting Solutions

Instructor: Devin Knight

Date/Time: 4/17/2014 11:00 AM

Excel 2013 with Office 365 brings many new features to the realm of Self-Service BI. There are now new ways to extract, model and present data all within Excel. One of these newest ways to present data is called Power Map. Power Map allows you to create engaging 3D map visualizations to help understand your geographical data better. This session will walk you through the beginning to end process of creating Power Map tours.

Bradley Schacht Bradley Schacht

Interactive Reporting with Power View

Instructor: Bradley Schacht

Date/Time: 4/16/2014 11:00 AM

Power View provides users with the ability to create interactive visualizations inside SharePoint and Excel 2013. It provides users with an easy to use drag and drop interface to quickly and easily create tables, charts, scatter plots and maps. Power View is the go to self-service reporting tool in the Microsoft ecosystem that is full featured enough to provide in depth data exploration and easy enough that a sales person can use it! This session will guide you through the process of creating a Power View report that will leverage all the requirements to get you up and running as well as core functionality including slicers, filtering, animated scatter plots, tiles, cards, maps and cross-filtering data in different objects.

Devin Knight Devin Knight

Bringing Power BI Q&A to your Organization

Instructor: Devin Knight

Date/Time: 4/15/2014 11:00 AM

Q&A is an amazing new feature of Power BI that allows you to ask you data question. No longer do you have to write complex SQL queries to get results. Simply type traditional English sentences to return interesting results about your data. This session will walk through how to get a Power Pivot data model ready to use and also the end user experience of Q&A from the Power BI site.

Brian Knight Brian Knight

Quick Start to PowerPivot

Instructor: Brian Knight

Date/Time: 4/14/2014 11:00 AM

In this session, you’ll learn how to use PowerPivot to create self-service analytics in your organization. You’ll see how Office and SQL Server will help your users answer their own questions and bring together datasets that may be heterogeneous like a SQL Server table and data feed from a website. Then, you’ll see how to take that data and create a striking report for your end users and collaborate with the data in SharePoint.

Bradley Schacht Bradley Schacht

Introduction to Microsoft Parallel Data Warehouse (PDW)

Instructor: Bradley Schacht

Date/Time: 4/10/2014 11:00 AM

Microsoft's Parallel Data Warehouse platform has seen a huge increase in popularity over the last couple of year but remains a mystery to most of the SQL Server community. Parallel Data Warehouse (PDW) is a Microsoft answer to massively parallel processing (MPP) competition. You don't need hundreds of terabytes of data to be a good use case for PDW. In this session you will receive an overview of what PDW is and discuss real world use cases, some large data sets and some small. We will talk about how PDW can offer improvements over the SQL Servers you have in your environment today and where it really fits in the grand scheme of your organization. This session wouldn't be any fun if it was all marketing material and slides, so Brad will be sure to make the examples real by giving you a live look at queries running on an actual PDW; no tricks just a real world comparison between PDW and the SQL Server your used to seeing day in and day out.

Gareth Swanepoel Gareth Swanepoel

Introduction to Extended Events in SQL Server 2012

Instructor: Gareth Swanepoel

Date/Time: 4/8/2014 11:00 AM

As a lone DBA in the scary new world of SQL Server Extended Events, you may be wary of the multiple threats of the deprecated profiler feature, Event Tracing for Windows and the Events themselves. In this session, come and learn how to map your way through these threats using the Extended Events User Interface and Admin Console. In addition, I will be detailing what “events” are and how they relate to YOUR SQL Server.

Kathi Kellenberger Kathi Kellenberger

SSIS Deployment and Configuration

Instructor: Kathi Kellenberger

Date/Time: 4/3/2014 11:00 AM

Microsoft gave SSIS a complete makeover with SQL Server 2012. Many of these changes are cosmetic in nature and don’t really affect the way you work with SSIS. Deployment and configuration are the exceptions. Attend this session to learn what you need to know to take advantage of the new Project Deployment model, the best thing about SSIS 2012!

Michael Reed Michael Reed

Improving query performance

Instructor: Michael Reed

Date/Time: 4/1/2014 11:00 AM

The 'out of the box' SQL Server installation and configuration is generally useless in an enterprise of any size and will lead to unbelievably poor query performance. In this hour we will discuss the basics of SQL Server deployment and configuration, the tools at your disposal to optimize query execution, and some tricks to make your queries perform at their best...all from the 'magic wand' approach where we start with 'most optimal' then adjust as necessary to suit the circumstances. Expect to learn a little bit of everything...from SQL Server deployment and configuration to indexing and statistics to stored procedures and functions to query design to database architecture.

Tyrone Brown Tyrone Brown

Intro to Reporting Services

Instructor: Tyrone Brown

Date/Time: 3/27/2014 11:00 AM

SQL Server Reporting Services (SSRS) is a robust reporting engine that is suited to meet the reporting needs of large and small companies alike. SSRS provides many options and tools that will allow you to develop, manage and deploy reports. In this session we will cover the introductory topics such as the SSRS architecture, installation and building basic reports.

Kevin Kline Kevin Kline

Convince Me – Persuasion Techniques That Get Things

Instructor: Kevin Kline

Date/Time: 3/26/2014 11:00 AM

Ever wanted to convince the boss try something new, but didn't know where to start? Ever tried lead your peers only to fail to achieve your goals? This session teaches you the eight techniques of influencing professionals, so that you can innovate and achieve change in your organization.

Christopher Schmidt Christopher Schmidt

Introducing DAX

Instructor: Christopher Schmidt

Date/Time: 3/25/2014 11:00 AM

Once you've discovered Power Pivot and learned how to import your data from multiple sources, the next task is to clean it all up. With DAX, we have a new language that can clean and manipulate our data to business friendly rules and names. First we'll cover an introduction to DAX, and some functions that we can use to manipulate strings, if…then conditions, and navigation. Then we'll cover how to incorporate time intelligence and building key performance indicators, all from within Power Pivot!

Bradley Schacht Bradley Schacht

Getting Started with Analysis Services

Instructor: Bradley Schacht

Date/Time: 3/20/2014 11:00 AM

Congratulations, you have taken the first step and built a data warehouse. Now it’s time to empower users to discover and explore the data all on their own. There is no better way to accomplish that goal than through SQL Server Analysis Services (SSAS). How do we make the dimensional model more user friendly? How can we centralize logic? How can I help my users drilldown and find the answers to business questions? All of these can be answered by building an SSAS cube or tabular model on top of your warehouse. We will explore the pros and cons of both SSAS Multidimensional and Tabular, discuss design patterns for each and even load some data to show how they both work. After this session you will be able to build a basic cube and tabular model that will give your users access to all the information they need with the click of a button right inside Excel.

Mike Davis Mike Davis

Intro to ETL versus ELT using SSIS

Instructor: Mike Davis

Date/Time: 3/18/2014 11:00 AM

In the session Mike will show you the differences between ETL (Extract Transform Load) and ELT(Extract Load Transform) and why you would use one over the other. This will be done using examples is SSIS and white boarding. You will see why ETL is not always the right choice. You will also see some examples of how this work in terms of a Microsoft PDW appliance.

Devin Knight Devin Knight

Introduction to Power BI

Instructor: Devin Knight

Date/Time: 3/13/2014 11:00 AM

The future of Business Intelligence has many new and exciting features. This world that was once reserved for only experts in SQL Server technologies has expanded to serve the masses with more and more self-service innovations. In this session you will gain an understanding of what Power BI is and get an overview of each of the components. This includes Power Pivot, Power View, Power Query and Power Map, Mobile Power BI and Q&A.

Mark Vaillancourt Mark Vaillancourt

MDX Trek: First Contact

Instructor: Mark Vaillancourt

Date/Time: 3/11/2014 11:00 AM

Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment.

Jason Strate Jason Strate

Introduction to Columnstore Indexes

Instructor: Jason Strate

Date/Time: 3/6/2014 11:00 AM

Columnstore indexes were first introduced in SQL Server 2012. Columnstore indexes provide the ability to flip-over your indexes from column-based to row-based, leading to dramatic changes in the storage and performance of your data. In this session, we'll review the basic concepts of columnstore indexes and look at the changes coming to them in SQL Server 2014.

Jason Strate Jason Strate

Introduction to Clustered Indexes and Heaps

Instructor: Jason Strate

Date/Time: 3/4/2014 11:00 AM

It's the age old question, do I put a clustered index on the table or leave it as a heap? While a simple question, this can have serious impacts on the performance of the table in queries. In this session, we'll review the basics of both clustered indexes and heaps; identifying key differences and cases where you might choose one over another.

Bradley Ball Bradley Ball

Data Internals Deep Dive Part 2

Instructor: Bradley Ball

Date/Time: 2/27/2014 11:00 AM

Pragmatic Works is bringing to you the cure for your Summit Hang over! A look into some of the presentations that were given. This is part 2 of the 90 minute spotlight talk that was given at the PASS Summit 2013 in Charlotte. In this session we finish covering SQL Data Internals and discuss other key concepts like the internal components of SQL Server, Concepts such as Latches, ACID, and give a preview of Hekaton and discuss how it’s introduction will affect the internals in SQL Server 2014.

Bradley Ball Bradley Ball

Data Internals Deep Dive Part 1

Instructor: Bradley Ball

Date/Time: 2/25/2014 11:00 AM

Pragmatic Works is bringing to you the cure for your Summit Hang over! A look into some of the presentations that were given. This is part 1 of the 90 minute spotlight talk that was given at the PASS Summit 2013 in Charlotte. As a DBA we learn backwards. Most of the time you get a DBA job and you have Databases, that have tables, and in those tables you have data. Nobody tells you that we have records, stored on Pages, grouped in Extents, assigned by Allocation Bitmaps, with IAM Pages and Allocation Units that span Partitions and Filegroups. Today is your lucky day, we will start at the bottom and build our way up. We'll cover byte swapping, bitmaps, and dive a little into decoding Hex & binary. Working to give you a full understanding of database internals, and how you use them every day!

Bradley Schacht Bradley Schacht

New BI Features in SharePoint 2013

Instructor: Bradley Schacht

Date/Time: 2/20/2014 11:00 AM

SharePoint 2013 is out and ready for prime time with new features and enhancements. Brad will show you some of the welcome changes available in Central Administration centered on streamlined configuration and security of business intelligence applications. Then it's all about the users as we showcase some major enhancements to PerformancePoint and Excel services. We will walk step by step through a few of the amazing new features in Reporting Services provided by the 2012 release of SQL Server. This is a must see session for every SharePoint administrator and anyone spending time developing SharePoint BI content. Whether you’re looking for a reason to upgrade or are just curious about the future, you won't want to miss this demo filled session!

Brian Knight Brian Knight

Introduction to Data Mining in SQL Server Analysis Services

Instructor: Brian Knight

Date/Time: 2/18/2014 11:00 AM

Data mining is one of the key hidden gems inside of Analysis Services but has traditionally had a steep learning curve. In this session, you’ll learn how to create a data mining model to predict who is the best customer for you and learn how to use other algorithms to spend your marketing model wisely. You’ll also see how to use Time Series analysis for budget and forecast prediction. Finally, you’ll learn how to integrate data mining into your application through SSIS or custom coding.

Jorge Segarra Jorge Segarra

What Is a BI DBA?

Instructor: Jorge Segarra

Date/Time: 2/13/2014 11:00 AM

Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment then tune in to this webcast!

Devin Knight Devin Knight

Choosing the Right Analysis Services: MOLAP vs. Tabular

Instructor: Devin Knight

Date/Time: 2/11/2014 11:00 AM

Determining whether multidimensional or tabular is the optimum solution for your organization is a key step when working with SQL Server Analysis Services 2012. And this session will introduce you to some of the common pitfalls with each solution and how you can avoid them. By the end of this session, you’ll have a clearer understanding of the strengths and weakness of each model and how your organization can optimally leverage the strengths of SSAS 2012.

John Welch John Welch

Practical Unit Testing for SSIS Packages

Instructor: John Welch

Date/Time: 2/6/2014 11:00 AM

Unit testing is a widely accepted best practice, yet it is difficult to do well with SSIS packages. This session will focus on a brief introduction to unit testing principles, and then focus on examples of testing your SSIS packages using ssisUnit. It will cover in depth how to set up your development environment to support test driven development and what techniques can be used to make this practical for SSIS. We’ll show how to handle test data, how to set up the environment for multiple developers, how to make tests flexible, and how to ensure that the tests remain valuable over time.

Kathi Kellenberger Kathi Kellenberger

Write Better Queries with Window Functions

Instructor: Kathi Kellenberger

Date/Time: 2/4/2014 11:00 AM

SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could. This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.

Brian Knight Brian Knight

BI xPress v.5.0 Launch Party

Instructor: Brian Knight

Date/Time: 1/31/2014 1:00 PM

Join our BI xPress development team for a special look at our new features! BI xPress' newest feature, Data Generation, will enable users to populated databases with "real-world-like" data. Often when developing a BI solution, the organization will need data to test the "edge" cases which will save time and money in the long run when the BI solutions is up and running. Data comes in many forms and often relies on other data for the complete picture; and Test Data Generation empowers users to create data just as complex. We will also look at SSIS Unit Testing which allows developers, users, and package lifecycle administrators to ensure that a package is performing exactly what the developer implemented and handling unexpected circumstances with predefined behavior.

Brian Knight Brian Knight

Performance Tuning SSIS with Task Factory Components

Instructor: Brian Knight

Date/Time: 1/30/2014 11:00 AM

Do you have massive amounts of data that you want to move quickly? In this session, you’ll learn how to increase the performance of SSIS runs with some of the task factory components and how to speed up development so you don’t have to do the same thing twice ever again.

Bradley Schacht Bradley Schacht

Change Data Capture (CDC) Made Easy With SSIS 2012

Instructor: Bradley Schacht

Date/Time: 1/28/2014 11:00 AM

One of the hidden gems introduced in SQL Server 2008 was change data capture. Loading your data warehouse has never been easier thanks to new components in SSIS 2012 designed specifically to consume CDC data. This amazing feature automates the process of detecting inserts, updates and deletes in your data; a vital step in determining type 1 and type 2 record updates. This session will begin by discussing the setup and configuration of CDC. Next Brad will jump into SQL Server Data Tools and walk you step by step through creating an SSIS package to load a dimension that will leverage all the new tasks and components. After this session you will have a very powerful tool in your SSIS tool belt.

Brian Knight Brian Knight

Doc xPress v2.0 Launch Party

Instructor: Brian Knight

Date/Time: 1/23/2014 1:00 PM

Join our free webinar and see how you can generate database and BI documentation quickly and efficiently with DOC xPress! Our new Data Dictionary feature gives users the ability to add extra pieces of crucial information throughout your documentation such as SLA's, persons responsible for the data and more. Users can customize the output generated by DOC xPress to create documents with more or less detail for different audiences with our Configurable Output feature. With Hive Documentation and Oracle Documentation users can now snapshot, document, validate and compare Hive and Oracle metadata. The new Import External Sources allows users to gather data using providers, and if there is no existing provider for a source users can import metadata files. Watch our developers show off all these new features live!

Mickey Stuewe Mickey Stuewe

Scalable SSRS Reports Achieved Through the Powerful Tablix

Instructor: Mickey Stuewe

Date/Time: 1/23/2014 11:00 AM

In this demo-heavy session, you'll learn how to create a columnar report that grows vertically as well as horizontally. You'll see the magic of having multiple layouts for the same data on the same report. You'll see how to do more useful things with fewer reports, and you’ll come away with a bag full of new tricks to make your reports flexible and scalable works of art.

Jason Strate Jason Strate

The Flavors of Non-Clustered Indexes

Instructor: Jason Strate

Date/Time: 1/21/2014 11:00 AM

A non-clustered index is just another way to get to data. Add in a couple columns and off you go. Not too much to think about, just fire and forget. But it’s not really that easy. Non-clustered indexes have a number of various ways in which they can be built and designed that can have significant impacts on performance. In this session we’ll look at what can go into a non-clustered index. We will explore what you can put into a non-clustered index and what you can expect back out from performance.

Jason Strate Jason Strate

Necessarily Evils, Building Optimized CRUD Procedures

Instructor: Jason Strate

Date/Time: 1/16/2014 11:00 AM

Every developer loves them and a lot of DBAs hate them. But there are many and valid reasons for creating generic SELECT, INSERT, UPDATE, and DELETE procedures. In this session, we’ll go through designing CRUD procedures that utilize new and existing SQL features to create CRUD procedures that are optimized for performance.

William Anton William Anton

Bus Matrix – the foundation of your Data Warehouse

Instructor: William Anton

Date/Time: 1/14/2014 11:00 AM

The Bus Matrix is the the cornerstone of a good Data Warehouse program. This document serves many purposes: from communicating requirements, capabilities, and expectations with the business users to the prioritization and delegation of tasks across the development team. Join me in this session and learn what a Bus Matrix is, why it is the most important document in your Data Warehouse program, what can go wrong without it (with actual real-world examples), and finally how to create one and maintain it over time.

Devin Knight Devin Knight

Performance Tuning Reporting Service Reports

Instructor: Devin Knight

Date/Time: 1/9/2014 11:00 AM

Do you have slow running reports? Have you done everything possible to tune the dataset query but still aren’t happy with the performance of your report? Reporting Services has some key features to help you monitor and tune report performance and in this session you will learn about how to use several of these key features including Caching, Execution Log and Performance Monitor.

Kathi Kellenberger Kathi Kellenberger

T-SQL Window Functions Performance

Instructor: Kathi Kellenberger

Date/Time: 1/7/2014 11:00 AM

Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.

Tim Murphy Tim Murphy

Translating the SSIS Expression Language

Instructor: Tim Murphy

Date/Time: 12/19/2013 11:00 AM

Have you ever written an expression that doesn’t do what you thought it should do? There are some keys to making the expression language in SSIS work for you. This session will give you the basics of successfully creating efficient expressions that will get the results you intend.

Nick Dillon Nick Dillon

Hurdle Helper for Multidimensional SSAS 2012

Instructor: Nick Dillon

Date/Time: 12/17/2013 11:00 AM

SQL Server Analysis Services 2012 provides massive computational power to meet your OLAP needs. Don’t let common logical and technical hurdles get in your way of mastering your analytical data and making it obvious to end users. This session will describe the most common hurdles that you may encounter when building your cubes and will teach you how to clear them with ease.

Tyrone Brown Tyrone Brown

SSIS Tips to Improve Performance

Instructor: Tyrone Brown

Date/Time: 12/12/2013 11:00 AM

In SSIS there are many ways to perform certain tasks that include using an SSIS component, SQL task, script task, or a third party component. Each way comes with pros and cons when it comes to performance, development effort and maintenance. This session will explore these options in-depth to help you make informed decisions when developing your next package.

David Siska David Siska

Window Functions for Analysis

Instructor: David Siska

Date/Time: 12/10/2013 11:00 AM

Window functions are powerful set based functions that we can take advantage of to write elegant, clean, and efficient solutions. SQL Server 2012 added increased features for Window functions, though they have been implemented since SQL Server 2005. This session will cover the basics of window functions and how to use them effectively.

Michael Reed Michael Reed

Big Data: Be there or wish you were

Instructor: Michael Reed

Date/Time: 12/5/2013 11:00 AM

Join me for an hour long presentation on the Big Data phenomenon where I will share insights and opinions from industry experts along with my own musing on Big Data, what it is, and what it can do for your career should you choose to accept the challenge.

James Phillips James Phillips

Creating an SSIS Framework

Instructor: James Phillips

Date/Time: 12/3/2013 11:00 AM

Using SQL 2012 we will discuss some of the best ways to implement a SSIS Framework. We will answer some of the important questions regarding what should a SSIS Framework have. Why is it important to implement a framework? What roles do parameters play? How can a BIXpress help ease the implementation process?

Steve Wake Steve Wake

Master the Date Dimension Like a Time Lord

Instructor: Steve Wake

Date/Time: 11/26/2013 11:00 AM

All data warehouses need a Date dimension to enable analysis by date. Most DW designers will just use a default one provided by the tools, but what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any Date dimension you want by using a single SQL script that can be modified and rerun as necessary to update the dimension. By the end of this session, you’ll be a Time Lord in your own company!

T.J. Brown T.J. Brown

Controlling your SSIS Control Flow using Containers

Instructor: T.J. Brown

Date/Time: 11/21/2013 11:00 AM

The Control Flow of SSIS provides numerous ways to control the processing of your ETL tasks. Fortunately, programming is no longer required to control looping and processing logic as they were in DTS due to the introduction of SSIS containers. In this session we’ll learn how containers can control looping, support parallel processing, and other use cases for SSIS containers.

Jason Strate Jason Strate

XQuery Basics for the DBA

Instructor: Jason Strate

Date/Time: 11/20/2013 11:00 AM

For the past few years, XML has been making its way more and more into our SQL Server instances. For a moment let’s forget that developers often find the need to store XML data in their databases. Outside of those databases, XML has already invaded our SQL Servers. It’s made its way into execution plans with the SHOWPLAN XML. It’s telling us about deadlock through deadlock graphs. It’s also presented to us through service broke, event notifications, and extended events. XML is there and we need to learn how to query it. In this session, we’ll explore some of the basic methods for querying XML through XQuery. By the end of the session you’ll be equipped with the tools and understanding needed to ease yourself into XQuery.

Bradley Schacht Bradley Schacht

Practical SSAS: Getting Started with Analysis Services

Instructor: Bradley Schacht

Date/Time: 11/14/2013 11:00 AM

Congratulations, you have taken the first step and built a data warehouse. Now it’s time to empower users to discover and explore the data all on their own. There is no better way to accomplish that goal than through SQL Server Analysis Services (SSAS). How do we make the dimensional model more user friendly? How can we centralize logic? How can I help my users drilldown and find the answers to business questions? All of these can be answered by building an SSAS cube or tabular model on top of your warehouse. We will explore the pros and cons of both SSAS Multidimensional and Tabular, discuss design patterns for each and even load some data to show how they both work. After this session you will be able to build a basic cube and tabular model that will give your users access to all the information they need with the click of a button right inside Excel.

Bradley Schacht Bradley Schacht

SSIS Design Patterns for Loading a Data Warehouse

Instructor: Bradley Schacht

Date/Time: 11/12/2013 11:00 AM

Loading a data warehouse can be a tricky task. A system that tracks history on some tables and keeps daily snapshots on others requires planning from the business and the developer. With all the requirements gathered it’s time to start building! Join us as we load type 1 and type 2 dimensions, fact tables and create a master package framework to control it all. We will explore the built in tools, like the slowly changing dimension wizard, then tell you all about why it should be avoided and show how to replace the functionality with much faster components. You will also learn how to handle special business scenarios, such as late arriving dimension members, in a variety of ways. After loading your warehouse come back and learn how to consume this data in SSAS.

Devin Knight Devin Knight

Touring your Data with Power Map

Instructor: Devin Knight

Date/Time: 11/7/2013 11:00 AM

Excel 2013 brings many new features to the realm of Self-Service BI. There are now new ways to extract, model and present data all within Excel. One of these newest ways to present data is called Power Map. Power Map allows you to create engaging 3D map visualizations to help understand your geographical data better. This session will walk you through the beginning to end process of creating Power Map tours.

Kathi Kellenberger Kathi Kellenberger

Index Fragmentation

Instructor: Kathi Kellenberger

Date/Time: 11/5/2013 11:00 AM

Index fragmentation is bad. We all know that. But do you understand the causes and what to do about it? Join this session to learn how to design indexes to prevent fragmentation and maintain indexes for best performance.

Mike Davis Mike Davis

Mastering the Technology Interview

Instructor: Mike Davis

Date/Time: 10/31/2013 11:00 AM

Join Mike as he shows you how to be prepared for technology job interviews. Learn the do's and don'ts of interviewing for technology jobs. Learn what your resume says about you and your ability to grow. Learn how passion can overcome a lack of skills.

Chris Price Chris Price

Introduction to Pig & Hive

Instructor: Chris Price

Date/Time: 10/29/2013 11:00 AM

In this session we will walk-through a common sense introduction to ETL and Data Warehousing on an HDInsight (Hadoop) cluster. Starting with Pig as an ETL tool, this session will introduce you to Pig Latin, user-defined functions (UDFs) and techniques to make you immediately productive in extracting, transforming and loading data. Next, we will dig into Hive to demonstrate how tables are defined, the data types that are available, how tables are loaded and subsequently queried with the Hive Query Language (HQL). We will also introduce how Hive parallels what you already know about SQL Server through the use of partitioning, indexing and views.

Kathy Vick Kathy Vick

DQS: Business logic meets Integration

Instructor: Kathy Vick

Date/Time: 10/24/2013 11:00 AM

Data Quality Services brings a new way to clean bad data as it's entering your data warehouse environment. In this session, we'll discuss what benefits using data quality services provides and how it can make development simpler in the long run. We'll show how to create a knowledge base, data quality projects, and administration of your data quality server. Finally, we'll use SSIS to consume this project and load into a data mart for cleaner data.

Brian Knight Brian Knight

Document your BI Environment with the new DOC xPress v1.7

Instructor: Brian Knight

Date/Time: 10/23/2013 11:00 AM

Join our developers as they show off the new features in DOC xPress v1.7 including the ability to produce documentation in CHM format, easier management of your snapshots and transfer of history between metabases and add images to your documentation allowing you to gain new visual insights.

John Welch John Welch

Moving Big Data - SSIS, Pig, and Sqoop

Instructor: John Welch

Date/Time: 10/22/2013 11:00 AM

Wondering how all that big data is going to be moved around? Or how you are going to move any of it into your SQL Server environment? Come to this session, and learn about some of the familiar and not so similar tools you can use for moving big data. We’ll compare the options, discuss how they can work with your existing Microsoft technologies, and provide some guidance on when to use each of the tools.

Jason Strate Jason Strate

How Do Non-Clustered Indexes Improve Performance?

Instructor: Jason Strate

Date/Time: 10/17/2013 11:00 AM

We've all heard the mantra about the importance of clustered indexes, but what about non-clustered indexes? Do you really need non-clustered indexes or are they just something that consultants recommend to increase their billable hours? In this session, we'll investigate the various flavors of non-clustered indexes and how they can be used to provide significant performance improvements.

Shawn Harrison Shawn Harrison

Introduction to C# Scripting in SSIS

Instructor: Shawn Harrison

Date/Time: 10/15/2013 11:00 AM

Even though SSIS is a powerful ETL tool, every BI developer will eventually have a need to do something that SSIS can’t do natively. In this hour long session, Shawn will explain why we need scripting, cover the basics of the script task and script component, and demonstrate some commonly used C# scripts.

Jason Strate Jason Strate

Choosing Your Clustered Index

Instructor: Jason Strate

Date/Time: 10/10/2013 11:00 AM

We often hear that you should always have clustered indexes on your tables. What's left off of this discussion is the how to choose the columns for this index. Should it be the primary key? Or some other column or set of columns? Having the wrong key column(s) in the clustered index can lead to performance problems, possibly worse than having no clustered index on the table at all. In this session, we'll review common patterns for selecting clustered indexes and how to determine which pattern you need. Also, we'll look at how to analyze tables to help select the best clustered index for every table.

Brian Knight Brian Knight

Sail through QA in hours not days with the new BI xPress 4.9

Instructor: Brian Knight

Date/Time: 10/9/2013 1:00 PM

Join us as we take a look at BI Data Testing, which allows developers and QA to ensure that databases contain consistent and accurate results, and User Defined Best Practices, which lets you create and enforce your own organizational development standards for SSIS packages.

Bradley Ball Bradley Ball

SQL Server 2014: A First Look at What’s New!

Instructor: Bradley Ball

Date/Time: 10/8/2013 11:00 AM

Microsoft has announced that our next version of SQL Server will be SQL Server 2014. SQL Server 2012 had some major upgrades in AlwaysOn Availability Groups, ColumnStore Indexes, and Resource Governor. SQL 2014 takes those features to the next level and introduces a whole lot more! Rebuild Indexes and Statistics by Partition? Yes! A new Optimizer/Cardinality Estimator that you can choose for your Queries? Yes! Hekaton in memory data tables that exist separate to the buffer pool and use HASH indexes instead of B-TREE? YES! Plus SSD Buffer Pool Extensions, Read-Write ColumnStore Indexes and much more!

Bradley Schacht Bradley Schacht

SSIS Tips and Tricks

Instructor: Bradley Schacht

Date/Time: 10/3/2013 11:00 AM

Whether you are just getting started with SSIS or have been using it for years the tips and tricks you will learn are sure to take your skills to the next level! In this session Brad will show you the secrets to making your SSIS package dynamic using expressions, how to build loops so logic can be reused, a really easy way to log all errors with a single execute SQL task and which data flow transformations to use and which ones to avoid. After this session you will have the confidence to tackle some of the major issues faced by all SSIS developers and even learn a couple of nifty testing tricks that will save you a ton of time!

Chris Schmidt Chris Schmidt

The Business Intelligence Management Data Mart

Instructor: Chris Schmidt

Date/Time: 10/1/2013 11:00 AM

Once you've built you're Business Intelligence ecosystem, you want to ensure that everything is running smoothly. SSIS packages should be timely, analysis services databases should be logging their usage, and reports should be monitored for improvement where, and when, possible. In this session, we'll start out by discussing why a management data mart is a good thing, and why you need this tool in your business intelligence environment to properly monitor and manage usage. Later, we'll discuss how to report off of this new data mart and the best way to deliver this report to management or your DBA for some much needed insight.

Devin Knight Devin Knight

Understanding Microsoft Self-Service Business Intelligence

Instructor: Devin Knight

Date/Time: 9/26/2013 11:00 AM

Self-service BI is the latest trend in implementing Business Intelligence. Using these new self-service technologies you can often lesson the dependence on IT for smaller scale projects. This session will discuss the roles involved in implementing self-service BI solution including the often forgotten data steward. You will then walk through implementing a prototype using the Microsoft self-service tools. This will be done using Power Query, Power Pivot, Power View and Power Map

Roger Wolter Roger Wolter

SQL Server File System Basics

Instructor: Roger Wolter

Date/Time: 9/24/2013 11:00 AM

Reading data from and writing data to disk is usually the most critical part of SQL Server performance. To make this process as fast as possible, SQL Server has implemented its own file system on top of the Windows file system. In this presentation you will learn the basics of how the SQL Server and Windows file systems interact to store data efficiently. Understanding how SQL Server data is stored is critical to understanding how to manage disk storage for maximum SQL Server performance.

Chris Schmidt Chris Schmidt

An Introduction to HDInsight

Instructor: Chris Schmidt

Date/Time: 9/19/2013 11:00 AM

Microsoft has recently released HDInsight, which is an Apache Hadoop based solution in Azure for big data. Unlike traditional SQL Server, HDInsight can handle either structured or unstructured data and can provide this data to SSAS, PowerPivot, PowerView, or Excel. In this session, we'll talk about what HDInsight is or isn't, and how we can use it for analysis and visualization to gain new insights into data that was previously much more difficult to work with.

Adam Jorgensen Adam Jorgensen

Creating your personal Big Data Sandbox in 60 minutes or less

Instructor: Adam Jorgensen

Date/Time: 9/18/2013 11:00 AM

We need to have a place to work on all these new Big Data solutions! Building yours is not that complicated. Join Adam as he walks you through the process of creating a virtual test environment live in our Free Training!

Chris Price Chris Price

The BI Guys Little Guide to Big Data

Instructor: Chris Price

Date/Time: 9/17/2013 11:00 AM

You know Pig is more than a farm animal and that Hive is not some ultra-hip bar. You've beyond the buzz words and the word count demos. Now…you're ready to figure out how it all fits in. In this session we will review common integration scenarios, proven patterns and best practices for integration Big Data solutions into your existing data warehouse and BI architecture. Learn how you too can ride the Big Data wave without reinventing the wheel to both enhance the information you currently deliver while solving problems that were previously unapproachable.

Jason Strate Jason Strate

Recognizing the Parallel Data Warehouse (PDW) Workload

Instructor: Jason Strate

Date/Time: 9/16/2013 11:00 AM

If you are like many, you've been hearing a lot about Parallel Data Warehouse (PDW) lately. PDW is Microsoft's appliance solution with SQL Server 2012 that allows massively parallel processing (MPP) of database workloads. But how do you know that you have a workload that requires or could benefit from MPP over the standard symmetric multiprocessing (SMP) architecture? In this session, we'll review that question and more with a run through of how to identify MPP workloads? As part of the session, we'll also review some of the key components and differentiators of the PDW platform.

Jason Strate Jason Strate

Transform Your Profiler Skills to Extended Events

Instructor: Jason Strate

Date/Time: 9/12/2013 11:00 AM

Do you still reach for SQL Profiler, even though you could use extended events? It's a common choice, built upon our familiarity and habit in using Profiler. The times, they are changing, and it won't be long before Profiler is no longer available in SQL Server. Already, the types of tracing available in extended events exceeds Profiler. In this session, we'll look at common use cases for SQL Profiler and translate those directly into Extended Events. We'll also look at how those scenarios can be improved upon just by changing tools.

Patrick Leblanc Patrick Leblanc

Synchronizing Data with SQL Azure Data Sync

Instructor: Patrick Leblanc

Date/Time: 9/10/2013 11:00 AM

In this demo-heavy session we will take a close look at SQL Data Sync and how it can be used to provide an on-going link between Windows Azure SQL databases or On Premise SQL databases and Windows Azure SQL databases. We will explain how the Integrated Azure portal User-interface can be used to configure the data sync.

Dustin Ryan Dustin Ryan

Building Your First Tabular Model: Tips and Tricks

Instructor: Dustin Ryan

Date/Time: 9/5/2013 11:00 AM

In this all demo webinar, Dustin will walk you through building your first Tabular model. This webinar is fast paced and action packed! You’ll learn to create a Tabular Model featuring multiple data sources, calculated columns, measures, KPI’s, partitions, and security! Dustin will point out valuable tips and tricks to building an efficient and powerful Tabular Model, as well as common pitfalls to avoid.

Kathi Kellenberger Kathi Kellenberger

SSIS 2012

Instructor: Kathi Kellenberger

Date/Time: 9/3/2013 11:00 AM

Many SQL professionals went through the transition from DTS to SSIS when SQL Server 2005 was released. With SQL Server 2012, Microsoft has given SSIS a thorough makeover. Join this session to learn that these changes are more than cosmetic.

Jason Thomas Jason Thomas

Telling Stories with Excel GeoFlow

Instructor: Jason Thomas

Date/Time: 8/30/2013 11:00 AM

In today’s world, data is omnipresent and all businesses collect it in one form or the other - financial, demographic, sales, marketing, customer relations, or some other type. Data tells us whether the marketing efforts were effective and whether the sales are trending up. Data can help identify any behavioural patterns and whether a particular segment is more prone to default on payments. In short, data can tell us stories. The challenge is to interpret these stories correctly and for that, we need the help of data visualization tools like Excel GeoFlow. Excel GeoFlow is an add-in for Excel 2013 that turns spread-sheet jockeys into mapmakers. It lets them take geographic data stored in Excel and display it on a 3D map from Bing Maps. Join me in this session as I use Excel GeoFlow to tell stories with data.

Bradley Schacht Bradley Schacht

Data Mining with the Data Mining Plugin for Excel

Instructor: Bradley Schacht

Date/Time: 8/29/2013 11:00 AM

In this session, you’ll learn how to install, configure and ultimately use the Data Mining Plugin for Excel. The plugin allows you to do light to moderate data mining inside the Excel interface and simplifies a complex topic to two clicks in many cases. In this session, you’ll learn how to forecast future sales, pick the best customers to chase and how to determine where there are outliers in your data.

Anthony Martin Anthony Martin

Excel Tips and Tricks

Instructor: Anthony Martin

Date/Time: 8/28/2013 11:00 AM

Excel is quickly becoming the focal point of the Microsoft Business Intelligence stack with all the new Self-Service tools such as PowerPivot, Power View, GeoFlow, and Data Explorer integrated directly into Excel. Given this direction, combined with a lot of new functionality released in Excel 2013 it is important to know how to work with Excel as effectively as possible. Join me as I cover tips and tricks for working with Excel such as Conditional Formatting, Flash Fill, Apps for Office, Recommended Charts, What if Analysis, and Power View.

Devin Knight Devin Knight

Introduction to Power Query

Instructor: Devin Knight

Date/Time: 8/27/2013 11:00 AM

Power Query is a free add-in for Excel 2010 and up that provide users an easy way to discover, combine and refine data all within the familiar Excel interface. With Power Query you can now combine and transform data from a variety of unusual data sources all within Excel, which would have previously required a complex ETL job. Join Devin and learn how you can use Power Query to take your Self-Service BI solutions to the next level.

Chris Schmidt Chris Schmidt

Introducing DAX

Instructor: Chris Schmidt

Date/Time: 8/26/2013 11:00 AM

Once you've discovered Power Pivot and learned how to import your data from multiple sources, the next task is to clean it all up. With DAX, we have a new language that can clean and manipulate our data to business friendly rules and names. First we'll cover an introduction to DAX, and some functions that we can use to manipulate strings, if…then conditions, and navigation. Then we'll cover how to incorporate time intelligence and building key performance indicators, all from within Power Pivot!

John Welch John Welch

Practical Unit Testing for SSIS Packages

Instructor: John Welch

Date/Time: 8/22/2013 11:00 AM

Unit testing is a widely accepted best practice, yet it is difficult to do well with SSIS packages. This session will focus on a brief introduction to unit testing principles, and then focus on examples of testing your SSIS packages using ssisUnit. It will cover in depth how to set up your development environment to support test driven development and what techniques can be used to make this practical for SSIS. We’ll show how to handle test data, how to set up the environment for multiple developers, how to make tests flexible, and how to ensure that the tests remain valuable over time.

Jason Strate Jason Strate

Building Security Audits with Extended Events

Instructor: Jason Strate

Date/Time: 8/20/2013 11:00 AM

It's 11 AM, do you know what your users are doing? One of the important roles for any database administrator is that of The Gatekeeper - standing in front of the data platform ensuring that only those with permission have access to the database. Along with that, DBAs also need to ensure that users are not abusing the access that they have already in the database. In this session, we'll review these challenges and discuss how you can leverage extended with security audits.

Shawn Harrison Shawn Harrison

Environment Documentation with Doc xPress

Instructor: Shawn Harrison

Date/Time: 8/15/2013 11:00 AM

Do you need in-depth environment documentation, but don’t have the time to complete it? Have you ever thought it would be nice to have known that making that one little change on that table would have destroyed those reports before you did it? Well, now you can satisfy both of those needs, and many more, with Doc xPress. Join us for this one hour presentation to see how you can have all the information you could ever need, generated at lightning fast speeds.

Chris Price Chris Price

Into the Wild...Taming Unstructured Data with Semantic Search

Instructor: Chris Price

Date/Time: 8/13/2013 11:00 AM

There is runaway growth in the data volumes many organizations are facing today. The bad news is that much of this data is unstructured which means your traditional RDBMS just isn't capability of helping you deal with it. As a result significant emphasis has been put on technologies like Hadoop, No SQL and other distributed databases which are better suited to handling unstructured data. With the latest release SQL Server 2012 however, Microsoft has provided new features which will help tame some of this unstructured data. This session will dive into the new FileTable and Statistical Semantic Search features. We will show you how they work and highlight real world examples for integrating these exciting new features into your organization.

Chris Schmidt Chris Schmidt

Merge against SSIS

Instructor: Chris Schmidt

Date/Time: 8/8/2013 11:00 AM

If you’ve used the merge statement in SQL 2008, you’ve no doubt encountered the power that this new set based query tool provides. If you haven’t used this tool yet, come spend some time with us and find out why you should add this tool into your data arsenal. Join us as we walk through some of the benefits of the merge statement and when it might make sense to use this over SSIS. When is it better to use SSIS to get the job done? Finally, we’ll leverage the powers of both of these tools to make extremely effective and powerful SSIS packages.

James Serra James Serra

Best Practices to Deliver BI Solutions

Instructor: James Serra

Date/Time: 8/6/2013 11:00 AM

If your company is planning to build a data warehouse or BI solution, you need to be aware that BI projects have high failure rates. Gartner says between 70% to 80% of corporate business intelligence projects fail. And with “big data” adding more complexity you can expect even more failures. However, the major causes of these failures are well known and can be avoided by implementing a set of best practices.

I have worked on dozens of end-to-end BI projects and have seen my share of successes and failures. I will talk about the reasons BI projects fail and share best practices and lessons learned so your BI project will fall into the “successful” category.

Kathi Kellenberger Kathi Kellenberger

Writing Better Queries with Window Functions

Instructor: Kathi Kellenberger

Date/Time: 8/1/2013 11:00 AM

SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could. This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.

Julie Koesmarno Julie Koesmarno

Understanding Query Modes in Tabular Model

Instructor: Julie Koesmarno

Date/Time: 7/30/2013 11:00 AM

SQL Server Analysis Services Tabular Model allows rapid and simplified data modelling of Business Intelligence solutions. An important aspect that is often overlooked when building a tabular model, is meeting real-time requirements. In this session you will learn how to tackle immediate (or close to) real time requirements using the different types of Data Access and Query Modes of Tabular Model and how your choice impacts your reporting options in the Microsoft BI stack...

Brian Knight Brian Knight

DOC xPress Launch Party v1.3

Instructor: Brian Knight

Date/Time: 7/25/2013 1:00 PM

Join our free webinar on how you can generate database and BI documentation quickly and efficiently with DOC xPress! You can also view and navigate the lineage of your data interactively - where does the data in this column come from, and where does it go? Users can produce complete documentation for SQL Server instances, Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS). Snapshots of the environment can be captured with a few clicks, making it easy to capture what an environment looks like before making changes. In addition, documentation can be produced from any daily snapshot, allowing users to see what the environment looked like in the past.

Jason Strate Jason Strate

5 Amazing Reasons DBAs Need to Love Extended Events

Instructor: Jason Strate

Date/Time: 7/25/2013 11:00 AM

Extended events provide DBAs with a powerful tool that can be used to troubleshoot and investigate SQL Server. Throughout this session, you’ll walk through five great reasons, with demos. By the end of the webcast, you’ll be itching to grab the scripts from the demos to start building your own extended event sessions today.

Bradley Ball Bradley Ball

Partitioning in SQL Server 2012

Instructor: Bradley Ball

Date/Time: 7/23/2013 11:00 AM

VLDB’s are the way of the world. Years ago a large database was anything over 10 GB, then it was 100 GB, and now 1 TB sized databases are common place. Querying large tables takes a lot of time, archiving data takes forever, inserting new rows take hours, and rebuilding indexes take longer and longer. In this session we will talk about how to effectively use Partitions for Fast Loading and Fast Archiving data. We’ll cover sliding windows, using views for partition elimination, Partition Schemas, Functions, and things to keep in mind when querying from partitioned tables.

Shawn Harrison Shawn Harrison

SSIS Best Practices Checklist

Instructor: Shawn Harrison

Date/Time: 7/18/2013 11:00 AM

There are multiple ways to solve most problems in SSIS, but some approaches are better than others. In this presentation, we’ll show some of the common approaches that can impact the performance, maintainability, and understandability of your packages. We’ll discuss how to tell if a particular scenario is a cause for concern, and how to address the problem, and how to update the package to a better approach if necessary. We’ll also cover using BI xPress’s Best Practices Analyzer to quickly identify trouble spots in your packages.

Jason Strate Jason Strate

5 Ways to Improve Performance through Indexing

Instructor: Jason Strate

Date/Time: 7/16/2013 11:00 AM

Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this session, we’ll look at five ways that performance of a database can be improved through indexing. When we finish, you’ll be armed with scripts and methodologies that you can put into place today to improve database performance.

Bradley Schacht Bradley Schacht

Combining Azure and Business Intelligence

Instructor: Bradley Schacht

Date/Time: 7/11/2013 11:00 AM

With more and more companies moving to the cloud it’s important to understand how that affects data analytics. It’s great to store data on Azure but what about your BI applications? How does this affect reporting services, analysis services cubes, PowerPivot and Excel. We will explore how to integrate an Azure database with the rest of the Microsoft BI stack on premises and also walk through Reporting Services on Azure.

Brian Knight Brian Knight

BI xPress Demo v4.7 Improve SSIS Development

Instructor: Brian Knight

Date/Time: 7/10/2013 11:00 AM

In this session we'll cover SSIS Unit Testing, which helps you find regression errors and bugs in your SSIS packages prior to QA. We'll also show the SSIS Best Practices Analyzer, which can be used to examine your SSIS packages and determine if you are following good development and performance guidelines.

Jorge Segarra Jorge Segarra

Azure Virtual Machines: A Walk in the Cloud

Instructor: Jorge Segarra

Date/Time: 7/9/2013 11:00 AM

Now that Windows Azure virtual machines are generally available to the public, how does this offering affect you? In this session we'll review this offering, walkthrough creating and deploying a virtual machine with SQL Server on it. We'll also discuss how you can leverage this offering to your existing infrastructure!

Brian Knight Brian Knight

Doubling Your Salary in 3 Years

Instructor: Brian Knight

Date/Time: 7/8/2013 1:00 PM

The technology field is full of amazing jobs but you need to stand out to get the perfect job and salary. Learn about the jobs and salaries that are available in the market and do a check to see if you’re on track to achieve one of the amazing jobs in business intelligence or software development. Also, learn how to make your resume shine against thousands of people competing for the same jobs.

Anthony Sammartino Anthony Sammartino

A Balanced BI Approach (Self-Service & Corporate)

Instructor: Anthony Sammartino

Date/Time: 6/27/2013 11:00 AM

In this session I will cover how PowerPivot and BISM Tabular complement each other in the domains of self-service and corporate BI. Let's face it, The Finance department does not have the expertise to model a database for reporting, and IT doesn't have the expertise in advanced financial calculations that the executive team is interested in. To bridge the gap from a large requirements process with the risk of functionality lost in translation, I will show you how you can roll out a PowerPivot model for business units in your organization and when it makes sense to centralize it in a BISM Tabular model.

Chris Schmidt Chris Schmidt

Advanced Concepts in Tabular

Instructor: Chris Schmidt

Date/Time: 6/25/2013 11:00 AM

In this session, we'll cover some of the more advanced concepts in tabular databases. First we'll take a look at things like partitions and perspectives, and how we can use them to assist in management and maintenance of an Analysis Services database. Then we'll look at implementing dynamic security into our solution, and finally we'll briefly explore the types of query modes available to tabular.When should In-Memory, DirectQuery, or one of the hybrids be used?

Shawn Harrison Shawn Harrison

BI xPress: Demonstration of Several Top Features

Instructor: Shawn Harrison

Date/Time: 6/21/2013 11:00 AM

In this 2 hour session, you will get a thorough demonstration of the commonly used features of BI xPress and see them applied in real world scenarios. Go from a blank project to a fully functional SSIS package with all the enhancements that BI xPress has to offer. The following features are covered in depth:

  • Package builder wizard
  • Configuration Manager
  • Quick Config Editor
  • Auditing and Notification frameworks
  • Monitoring Console
  • Deployment Wizard
As an added bonus, Shawn will also touch on the features of DBA xPress that are packaged with the Professional Edition of BI xPress.

Angel Abundez Angel Abundez

Measuring the Subscription Economy

Instructor: Angel Abundez

Date/Time: 6/20/2013 11:00 AM

In today's mobile landscape, many companies such as Spotify, Dropbox, XBox Live, and Netflix are succeeding with subscription-based business models. Measuring and monitoring subscription data can provide a wealth of information, but conventional methods using CRM and ERP systems to track such business simply don’t work. Several key metrics in membership and revenue exist that should be used to monitor the health of this type of business model. In this session we'll show you how to dimensionally model the subscription economy and uncover these key metrics. We'll explore lessons learned, team requirements, and business rules you can take away in modeling the subscription economy. You’ll be faced with hard questions around “freemium” subscriptions, grace periods, and legacy data we’ll cover that, too . Then, we’ll end with some good data visualizations you can use to uncover additional value from these critical measures.

Devin Knight Devin Knight

Creating Real World PowerPivot Models

Instructor: Devin Knight

Date/Time: 6/18/2013 11:00 AM

The popularity of PowerPivot has grown rapidly since being introduced. With so many different features it’s hard to determine where to focus your learning. In this session we will quickly create a data model then move on to making it more useful in the real world. Importing data from a warehouse, Excel or even the web can add great value to your existing data model. Creating relationships, setting up your dates and creating hierarchies are all key to a robust model, are necessary to leverage the full power of DAX and provide maximum usability with Power View. We will also show you how to build calculations and KPIs (Key Performance Indicators) right into the model to help produce more actionable reports.

James Serra James Serra

Building an effective Data Warehouse Architecture

Instructor: James Serra

Date/Time: 6/13/2013 11:00 AM

You’re a DBA, and your boss asks you to determine if a data warehouse would help the company. So many questions pop into your head: Why use a data warehouse? What’s the best methodology to use when creating a data warehouse? Should I use a normalized or dimensional approach? What’s the difference between the Kimball and Inmon methodologies? Does the new Tabular Model in SQL Server 2012 change things? What’s the difference between a data warehouse and a data mart? Is there any hardware I can purchase that is optimized for a data warehouse? What if I have a ton of data? Join this session for the answers to all these questions. You’ll leave with information that will amaze your boss and lead to a big raise… – or at least lead you down the correct path to adding business value to your organization!

Anthony Martin Anthony Martin

Exploring SSAS Tabular Security Features

Instructor: Anthony Martin

Date/Time: 6/11/2013 11:00 AM

Security may not be at the top of the list of what BI developers think about when starting to developing an SSAS Tabular solution, but I'll bet it's a top priority of your Management team with all the valuable insights you've made available in your solution at stake! In this session we'll start off by understanding how roles are implemented to restrict permissions. We will then move on to basic and advanced data security features that can allow a user to only see a specific subsets of data. We'll finish up by walking through several options for testing the security model.

Chris Schmidt Chris Schmidt

Power Pivot and Complex DAX expressions

Instructor: Chris Schmidt

Date/Time: 6/6/2013 11:00 AM

PowerPivot is a powerful new tool able to slice and dice data in memory very fast. In this session you will learn how to build complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships and learn some string manipulations. Come see these complex DAX functions and leave with some great DAX knowledge.

Brian Knight Brian Knight

Excel 2013: BI for the Masses

Instructor: Brian Knight

Date/Time: 6/4/2013 11:00 AM

With the release of Excel 2013 many new features have taken what has always been the most popular Business Intelligence tool to a new level of greatness. This session highlights many of those new Excel 2013 features like Flash Fill, Office Apps, Inquire Add-in, PowerPivot, Power View, GeoFlow, and Data Explorer.

Shawn Harrison Shawn Harrison

Complete Environment Documentation with BI Documenter

Instructor: Shawn Harrison

Date/Time: 5/30/2013 11:00 AM

Documentation at the end of a project is important, but also tedious and time consuming. I would venture to say that it’s probably the one piece that no one wants to do. Instead of spending so much time manually creating documentation, BI Documenter do all the work for you. In this session, you will learn how to use BI Documenter to create a complete documentation of your SQL servers, and everything in the BI stack. Stop wasting time on documentation when it can be done at the push of a button!

Bradley Schacht Bradley Schacht

New Hotness: SQL Server 2012 and SharePoint 2013

Instructor: Bradley Schacht

Date/Time: 5/28/2013 11:00 AM

The new hotness that is SharePoint 2013 is out and ready for prime time with new features and enhancements. We will show you some of the welcome changes available in Central Administration centered on streamlined configuration and security of business intelligence applications. Then it's all about the users as we showcase some major enhancements to PerformancePoint and Excel services. We will walk step by step through a few of the amazing new features in Reporting Services provided by the 2012 release of SQL Server. This is a must see session for every SharePoint administrator and anyone spending time developing SharePoint BI content. Whether you’re looking for a reason to upgrade or are just curious about the future, you won't want to miss this demo filled session!

Chris Price Chris Price

Get On Point with SharePoint PerformancePoint Services

Instructor: Chris Price

Date/Time: 5/23/2013 11:00 AM

The practice of Business Intelligence lives at the intersection of strategic, operational and tactical business decisions and the information that drives them. The critical function in this area is the delivery of information in a manner than enables your business community to measure, analysis and make the daily decisions necessary. SharePoint 2012 PerformancePoint Services provides a robust platform to facilitate the delivery of this information. In this session, we will explore PerformancePoint and how you can connect data from disparate data sources in the Dashboard Designer to deliver advanced reports, dashboards and scorecards. Features such as implementing KPIs/Indicators, designing reports or dashboards and working with filters will all be covered in this demo-centric presentation.

Devin Knight Devin Knight

Ad-hoc Reporting with SharePoint

Instructor: Devin Knight

Date/Time: 5/21/2013 11:00 AM

Your business users have a demand for self-service ad-hoc reporting and you are more than happy to help them solve this problem because you have more than a 100 reports queued up waiting for you to develop. You see this as an opportunity to not only help them but help yourself tackle larger projects. Walk through what Microsoft has to offer for ad-hoc reporting with SharePoint, the ideal central storage for all the reports they develop. This session reviews using Excel Services, Power View, PowerPivot, Report Builder and Power View for ad-hoc reporting.

John Hoang John Hoang

Microsoft Parallel Data Warehouse V2 New Features

Instructor: John Hoang

Date/Time: 5/16/2013 11:00 AM

With SQL Server 2012 Parallel Data Warehouse (PDW) we are introducing a new hardware platform and software architecture featuring higher performance and more cost effective hardware, column store index (XVelocity), workload management, integrated connectivity and query to Hadoop (Polybase), as well as extended TSQL surface area for improved third party tool connectivity. The new architecture delivers considerable performance improvement (10x or more in many DW workloads) compared to the existing AU3.5 product, and greatly increases scalability, allowing customers to scale from 80TB to over 5PB. With Polybase, we are integrating support for connectivity and query to Hadoop clusters, allowing customers to build end-to-end solutions leveraging their Big Data infrastructure and unstructured data sources. This session provides an overview of SQL Server 2012 PDW, showing details on the new features and how these all add up to make this release a generational leap forward.

Devin Knight Devin Knight

Creating an End to End Power View Reporting Solution

Instructor: Devin Knight

Date/Time: 5/14/2013 11:00 AM

Power View has the capability of creating eye-popping visualizations within SharePoint and Excel 2013. It provides intuitive ad-hoc reporting that can be used by a variety of business users to make critical decisions. Before you can begin building these incredible reports you must have your data properly prepared. This session will give you a beginning to end view of what is needed to create Power View reports from organizing a PowerPivot source to preparing the actual Power View report.

Bradley Schacht Bradley Schacht

Dashboard Reporting with SharePoint

Instructor: Bradley Schacht

Date/Time: 5/9/2013 11:00 AM

In today's fast paced business world decisions have to be made quickly and information consumed rapidly. Serving up dashboards and scorecards using the business intelligence features of SharePoint can provide a quick view of how each part of a business is performing. A good dashboard not only provides the high level view, indicating that sales may be down for instance, but the ability to drill into details and gain insight into the data behind the scenes. In this session we will explore how to not only create meaningful dashboard but also provide the ad-hoc functionality that is necessary to dig deep into the data. We will look at the functionality and limitations of Excel, PerformancePoint and Power View.

Adam Jorgensen Adam Jorgensen

Handle Your Big Data with HDInsight

Instructor: Adam Jorgensen

Date/Time: 5/7/2013 11:00 AM

Do you have data that you think is “unstructured”, Semi-structured or just doesn’t fit in your data warehouse plans? Come learn how integrating that data allows you to look at your organization and ask questions in ways you never could before. We’ll leverage Microsoft’s Hadoop offering, HDInsight in Windows Azure Services to show off some of the great functionality that allows your end users to work with your “Big Data” with native MSFT BI tools and Excel!

Jason Strate Jason Strate

SQL Server Security

Instructor: Jason Strate

Date/Time: 5/2/2013 11:00 AM

One of the most often overlooked feature sets of SQL Server is it's security features. The focus is often on what type of data, how to store the data, and how to get the data out of SQL Server. As DBAs, we also need to be consider how to lock down the data and implement security. In this session, we'll investigate the basic components of security within SQL Server. Also, we'll review some practices for that you may want to adopt to secure your environment.

Mike Davis Mike Davis

Intro to Business Intelligence

Instructor: Mike Davis

Date/Time: 4/30/2013 11:00 AM

In this session Mike will cover the reasons for having a Business Intelligence solution and the Microsoft tools to use to build it. He will show the entire BI life cycle from dimensional modeling, loading a data warehouse, and reporting. After this session you will have an understanding of why your company needs a business intelligence solution.

Shawn Harrison Shawn Harrison

SSRS Basics

Instructor: Shawn Harrison

Date/Time: 4/25/2013 11:00 AM

SQL Server Reporting Services is a powerful tool for data visualization. In addition to providing end users the data they need in an endless variety of ways, it is also a great first step for those wanting to enter the realm of BI. This one hour session will cover the basics of SSRS and its uses.

Jorge Segarra Jorge Segarra

SQL Server: Ground Zero

Instructor: Jorge Segarra

Date/Time: 4/23/2013 11:00 AM

In this absolute basics session, we’ll be talking about databases and SQL Server from an absolute beginner’s perspective. We’ll talk about what is a database, a table, an index, what are the basic terms of SQL Server and so on. This session is meant to introduce one to SQL Server and databases for the very first time.

Chris Price Chris Price

Building an Enterprise ETL Framework with SSIS 2012

Instructor: Chris Price

Date/Time: 4/18/2013 11:00 AM

A lot has been said about ETL Frameworks and it's an important topic considering these frameworks are the cornerstone of any data warehouse implementation. This session will discuss building a robust enterprise ETL Framework while leveraging the architectural enhancements available in SQL Server 2012. Topics include auditing, logging, designing for fault tolerance and recoverability, handling orchestration, parallelism and finally scheduling in a dynamic and configurable manner.

Chad Churchwell Chad Churchwell

Introduction to Backup and Recovery

Instructor: Chad Churchwell

Date/Time: 4/16/2013 11:00 AM

This session is a beginner level session focused on the basics of taking database backups and being able to restore databases for purpose of recovery. We will discuss backup types, recovery models, and restoration including point in time recovery.

Bradley Schacht Bradley Schacht

Back to Basics: SharePoint for Business Intelligence

Instructor: Bradley Schacht

Date/Time: 4/11/2013 11:00 AM

SharePoint has a lot of useful features and can be quite overwhelming. Do I build a dashboard or combine web parts? Do I use normal SSRS or Power View? The list of options could go on. In this session Bradley will take you on a tour of all the major BI features and show you some of use cases for each. Topics will include PerformancePoint, SSRS, Excel Services, PowerPivot, Power View and Power Bars. Ok, that last one isn’t really a SharePoint thing; I just making sure you were still paying attention. This will be a very demo heavy session showing development and use of each feature with very little time spent explaining the setup in Central Administration, but feel free to bring your questions about both admin (setup and configuration) and development!

Kathi Kellenbeger Kathi Kellenbeger

Get Started with Indexes: The Basics

Instructor: Kathi Kellenbeger

Date/Time: 4/9/2013 11:00 AM

SQL Server databases have indexes to help applications and reports run with the best performance. But, did you know that too many indexes or the wrong ones can actually hurt performance? Do you know what a clustered index is? What a non-clustered index is? How SQL Server actually uses indexes to help return the correct data? Attend this session to learn the basics about indexes and the answers to your indexing questions.

John Welch John Welch

Unit Tests for SSIS Packages

Instructor: John Welch

Date/Time: 4/4/2013 11:00 AM

Unit testing is a widely accepted best practice, yet it is difficult to do well with SSIS packages. This session will focus on both the practice of test driven development as it applies to SSIS, and the tools for actually implementing it. It will cover in depth how to set up your development environment to support test driven development and what techniques can be used to make this practical for SSIS. You will also see how to automate the testing of SSIS packages, using the open source ssisUnit framework. The session will cover several of the common questions about automated unit testing, including how to handle test data, how to set up the environment for multiple developers, how to make tests flexible, and how to ensure that the tests remain valuable over time.

Devin Knight Devin Knight

Introduction to SQL Server Analysis Services (SSAS)

Instructor: Devin Knight

Date/Time: 4/2/2013 11:00 AM

In this session, you’ll learn how to build a highly efficient analytical platform by using Analysis Services (SSAS). You’ll learn the how to create and configure a cube to pre-aggregate your data and then how to create hierarchies to make your users more effective. Lastly, you will learn about the major difference between Multidimensional and Tabular Analysis Services and how each play different roles.

Melissa Coates Melissa Coates

Maximizing the Data Exploration Capabilities of Power View

Book Cover

Instructor: Melissa Coates

Date/Time: 3/28/2013 11:00 AM

Would business users in your organization love to get their hands on an interactive, visually-oriented, data exploration tool? If so, Power View may be a useful addition to your BI environment to handle certain types of self-service reporting requirements. In this session we will demonstrate the features and functionality of Power View including highlighting, cross-filtering, play axis, small multiples, tiles, cards, maps, filtering, and exporting. We will identify which situations Power View is most suited for, as well as its strengths and limitations. Capabilities in SharePoint 2010/2013 vs. Excel 2013 will be reviewed, as well as restrictions on types of data sources allowed. We will also discuss how to prepare a dataset in order to maximize the usability and functionality of Power View. Join us for this session to discover how to get the most out of Power View!

Julie Koesmarno Julie Koesmarno

High Volume Data Processing Techniques Without Driving Your DBA Crazy!

Book Cover

Instructor: Julie Koesmarno

Date/Time: 3/26/2013 11:00 AM

Ever wondered how to process millions of rows daily? Is partitioning the only solution? Fear not, SQL Server 2012 comes with new TSQL functions and index enhancement to help solve high volume data processing with techniques that will be kind to your server. Giving you less reason to drive your DBA crazy with poorly performing code. View a demo on the ultimate batching techniques to conquer high volume data processing in SQL Server 2012, and comparing it with SQL Server 2008R2. Justify investment for SQL Server 2012 from both a development and performance point of view and understand how to achieve the same objective in SQL Server 2008.

Cindy Gross Cindy Gross

HDInsight: Jiving about Hadoop and Hive with CAT

Book Cover

Instructor: Cindy Gross

Date/Time: 3/21/2013 11:00 AM

Hearing the buzz about Big Data and Hadoop? Wondering if you need to be involved? Want to know how to reuse your SQL Pro skills in Hadoop via Hive? We’ll discuss how Microsoft is packaging Hadoop into HDInsight, how Hive fits into Hadoop, why you as a SQL Pro should be involved, and how to use Hive with SQL, AS, and BI.

Kathi Kellenberger Kathi Kellenberger

AlwaysOn Availability Groups

Book Cover

Instructor: Kathi Kellenberger

Date/Time: 3/19/2013 11:00 AM

Clustering, Database Mirroring, Log Shipping… You have many choices today when designing your HADR solution. AlwaysOn Availability Groups is new with SQL Server 2012. Attend this session to learn how to simplify your HADR strategy, save your company money, and attain the uptime your business requires.

Jes Borland Jes Borland

The What, Why, and How of Filegroups

Book Cover

Instructor: Jes Borland

Date/Time: 3/14/2013 11:00 AM

Having multiple database files and filegroups is one of many strategies to improve performance and make administration easier. What are filegroups, and how do you use them? In this session, I'll show you how to create filegroups, create objects in them or move objects to them, and discuss how they can help performance. I'll also cover Enterprise-level features like piecemeal restores.

Sharon Dooley Sharon Dooley

What on earth is a contained database?

Book Cover

Instructor: Sharon Dooley

Date/Time: 3/12/2013 11:00 AM

Anyone who has ever needed to move a database from one server to another has experienced the pain of dealing with mismatched SQL Server authentication logins. In this session, I will describe what a contained database is and how this new 2012 feature can ease your pain. I'll look at some of the advantages and disadvantages of this feature and talk about the new SQL Users with Passwords and Windows users. I'll demonstrate how to create a contained database and how to connect to it. Then I will demonstrate the process of making an existing database contained. If time permits, I'll also talk about the way contained databases handle differences in collation between the contained database and tempdb.

Denise McInerney Denise McInerney

A Case for Women in Technology

Book Cover

Instructor: Denise McInerney

Date/Time: 3/7/2013 11:00 AM

Increased gender diversity in tech has a positive impact on women and on the companies that employ them. Did you know having women on your team can increase innovation and productivity, or that employing women can help a company's bottom line? What does it mean for women and their families when they have access to hi-tech jobs? Join us as we discuss the effects women in technology can have on your team, your business and your world.

Kim Hathaway Kim Hathaway

SQL Waits and Queues

Book Cover

Instructor: Kim Hathaway

Date/Time: 3/5/2013 11:00 AM

SQL Server captures and records wait statistics data for passive and active tasks. Specific Waits can be considered acceptable in one environment yet can be a point of contention in another. This presentation will help guide you to the use of SQL Waits and Queues to monitor your environments and to research potential performance problem areas of an instance.

Jason Strate Jason Strate

A Functions Is A Function – Comparison of the Performance Impacts of User Defined Functions

Instructor: Jason Strate

Date/Time: 2/28/2013 11:00 AM

User defined functions provide a means to encapsulate business logic in the database tier. Often the purpose of the encapsulation is to provide standard method access segments of data within the database. Unfortunately, not all methods of creating user defined functions are equal. In this session we’ll review the types of user defined functions and investigate the performance impact in selecting the different types.

Bradley Schacht Bradley Schacht

Back to the Basics: SSIS 2012 for Beginners

Instructor: Bradley Schacht

Date/Time: 2/26/2013 11:00 AM

Whether you are a junior developer or a senior DBA knowing the basics of SSIS can be vital to your job. SSIS is all about process automation and moving data. In this session Brad will walk you through the basics of SSIS. This will include the differences between the control flow and data flow, running tasks in parallel, connecting to data sources and even creating your first data flow. Bring your notepad as this will be a demo heavy session with a lot of information. Brad’s focus will be SSIS 2012, but the concepts can easily be applied to SSIS 2008 as well.

Jason Strate Jason Strate

What Are You Waiting For – Explanation of the Value of Performing Wait Analysis

Instructor: Jason Strate

Date/Time: 2/21/2013 11:00 AM

You’ve spent the afternoon sweating over your T-SQL query. You’ve wrung out all of the wrinkles. It’s deployed, it’s running… now its waiting. In SQL Server the most performant query can become a problem query if there aren’t any resources in the SQL Server for it to use. In this session, we’ll look at wait statistics and what they are. We’ll look into how they are accumulated and how they can be monitored. By the end of the session, you’ll be equipped with the tools needed to determine if there are resource issues in your environment and methods to start mitigating them.

Kathi Kellenberger Kathi Kellenberger

Is SQL Server Enterprise Edition the Best Choice for Your Data?

Instructor: Kathi Kellenberger

Date/Time: 2/19/2013 11:00 AM

Is SQL Server Enterprise Edition the Best Choice for Your Data? SQL Server is known to be a great value with distinct SKUs, not with a bunch of expensive add-ons to get the functionality you need like other platforms. You get many advanced features when you jump from Standard Edition to Enterprise Edition, but how do you know if it is worth it to make that jump? Join this session to learn how Enterprise Edition can not only improve performance and availability, but also save your company money.

Anthony Sammartino Anthony Sammartino

Self-Service Visualization with Power View

Instructor: Anthony Sammartino

Date/Time: 2/14/2013 11:00 AM

In this session I will give a brief history of Power View and the two applications in which it can be used; SharePoint 2010 and now Excel 2013. I will then cover what sources can be used to create a Power View report then jump into a demo and create a few visualizations from a blank canvas to demonstrate how easy, yet powerful this visualization tool really is. I will then dive into a few tips and tricks that make the visualizations shine as well as the sites in SharePoint that host them.

Shawn Harrison Shawn Harrison

Monitoring Package Performance With the BI xPress Monitoring Console

Instructor: Shawn Harrison

Date/Time: 2/12/2013 11:00 AM

Does the thought of the unknown frighten you? Do you feel anxiety when faced with uncertainty? Do you feel over burdened by looking through agent history logs when you find out that jobs failed over night? Well, friends, let us show you how to eliminate all of the stress and give you a clear insight into what is happening behind the scenes. In this webinar, Shawn will demonstrate how to use BI xPress to monitor SSIS packages in real time, along with reading execution trends, performance history and cutting down on troubleshooting time. DBA’s and developers alike can benefit from this hour long webinar.

Devin Knight Devin Knight

Choosing a Microsoft Reporting Technology

Instructor: Devin Knight

Date/Time: 2/7/2013 11:00 AM

The Microsoft BI stack is fairly complex, especially on the front-end. In this session, we will cover when to use PerformancePoint, Reporting Services, Power View, PowerPivot or Excel Services. You will also see a little of each of these tools in action.

Steve Wake Steve Wake

ABCs of CDC with SSIS 2012

Instructor: Steve Wake

Date/Time: 2/5/2013 11:00 AM

SQL Server Integration Services (SSIS) 2012 added full support for Change Data Capture (CDC) on databases. In this session we will cover the basics of CDC in SQL Server 2012 and then how to build SSIS 2012 packages that make using CDC to load your Data Warehouses easier than they were before. No previous knowledge of CDC is required for this session, but some knowledge of any version of SSIS will make it easier to understand.

Shawn Harrison Shawn Harrison

Letting Go of DTS Once and For All

Instructor: Shawn Harrison

Date/Time: 1/31/2013 11:00 AM

DTS has finally reached its end of life. However, there are still so many businesses that are clinging to their DTS packages. Whether it is lack of resources, lack of knowledge, or fear of the unknown, it is time to let go. In this webinar, Shawn will demonstrate how to easily migrate dts packages using DTS xChange. Let us show you how quickly and painlessly Pragmatic Works can make the process for you. This is a must see for anyone that needs to let go of the past and move into the present!

Robert Cain Robert Cain

Become a PowerShell Pop Star

Instructor: Robert Cain

Date/Time: 1/24/2013 11:00 AM

So you've heard about this cool scripting language from Microsoft called PowerShell. Maybe you've even thought "I need to learn something about that." Well today is your lucky day, in this session we'll take you from a PowerShell "noob" to Pop Star. In this session we'll start with the basics, discussing cmdlets, variables, and providers.

Chad Churchwell Chad Churchwell

Protect Your Replication Environment with AlwaysOn Availability Groups

Instructor: Chad Churchwell

Date/Time: 1/22/2013 11:00 AM

This session is intended to show how you can combine AlwaysOn Availability Groups to protect your replication environment for High Availability. We will cover supported scenarios for replication, publisher and subscriber setup, and different failure points in your replication topology. We will conclude with a demo on failover of a publisher and subscriber.

Jorge Segarra Jorge Segarra

What Is a BI DBA?

Instructor: Jorge Segarra

Date/Time: 1/17/2013 11:00 AM

Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment then tune in to this webcast!

Chris Schmidt Chris Schmidt

SSIS 2012 Reporting: Now what?

Instructor: Chris Schmidt

Date/Time: 1/15/2013 11:00 AM

Now that packages can be tracked by SQL Server natively in 2012 with the new SSISDB, what can we leverage out of all of these new tables to track package performance? Interested in run time information? Error logging? Warnings? Come join a demo-packed hour where we’ll explore bringing SSIS performance into SSRS, SSAS, Power Pivot, and more!

Bradley Ball Bradley Ball

Inside the Query Optimizer

Instructor: Bradley Ball

Date/Time: 1/10/2013 11:00 AM

When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”. The answer understanding the first step in that process Is understanding the Query Optimizer. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.

Jason Strate Jason Strate

Extended Events: Work Smarter, Not Harder

Instructor: Jason Strate

Date/Time: 1/8/2013 11:00 AM

Of the many ways to monitor your SQL Server environment, Extended Events is one of the newer platforms that can help you investigate and resolve performance problems. In this special 90-minute session, we’ll review Extended Events and learn the ins and outs of how to get and analyze detailed information on the errors and events that occur within SQL Server. With a few T-SQL statements, you can research in minutes issues that used to take weeks to investigate.

Anthony Sammartino Anthony Sammartino

SSAS Tabular and Self Service BI - TheDynamDAX Duo

Instructor: Anthony Sammartino

Date/Time: 12/20/2012 11:00 AM

In this session I will cover how SSAS tabular and Self Service BI complement each other and make the slicing and dicing of large amounts of data a breeze for Power Users. I will give a brief explanation and history of each then will walk through how to create a SSAS tabular model, get into how to create data relationships from a database model with a star schema, then hook it up to Excel and expose the elements for users to slice and dice data with ease and create charts. Then will demonstrate a few DAX commands that are very powerful, yet very easy.

Brian Knight Brian Knight

Ninja Data Moves in Office 2013

Instructor: Brian Knight

Date/Time: 12/18/2012 11:00 AM

Office 2013 brings with it some amazing business intelligence and data visualization enhancements. Watch how you can improve data cleansing with Excel 2013 and some of the new features integrated into Excel and the other Office tools to visualize data better than ever before.

Mike Davis Mike Davis

Informatica vs. SSIS: Smack Down #3

Instructor: Mike Davis

Date/Time: 12/13/2012 11:00 AM

In this webinar you will learn how to call a child package from a parent package and how to pass variables between them. You will also learn how to dynamically create file names with a date appended to them. See how to do this in SSIS and Informatica.

Shawn Harrison Shawn Harrison

Rapid Package Development with BI xPress

Instructor: Shawn Harrison

Date/Time: 12/6/2012 11:00 AM

Most ETL developers spend a substantial portion of their lives recreating the same SSIS packages over and over. Over the years, there have been a few tips and tricks to help alleviate that redundancy, but still leave much to be desired. Join Shawn as he demonstrates how to use BI xPress to break the cycle of redundancy and learn how to take back more of your time.

Bradley Ball Bradley Ball

Trimming Indexes, Getting Your Database in Shape

Instructor: Bradley Ball

Date/Time: 12/4/2012 11:00 AM

Indexes are a wonderful thing. We should be using them, and we should be maintaining them. But over time our production databases start to look a little pudgy around the mid-section. Maybe they are a little bloated with Unused Indexes, maybe they have Duplicate Indexes, and possibly even Reverse Indexes. The first step to fixing these problems it so see if you have them, and if you do the second is to set about fixing them. You could be costing yourself CPU cycles, I/Op’s, and space and never even know it.

Murshed Zaman Murshed Zaman

SQL Server Parallel Data Warehouse Appliance Architecture and Internals

Instructor: Murshed Zaman

Date/Time: 11/29/2012 11:00 AM

SQL Server Parallel Data Warehouse (PDW) is the high end MPP Data Warehouse Appliance offering from Microsoft that delivers highest scalability and performance. In this demo rich session, we will discuss the appliance architecture, schema and distributed query processing in PDW. Attendees will learn about the components for end-to-end solution between PDW, Microsoft BI stack and 3rd party BI tools.

Jason Strate Jason Strate

SSIS vs Informatica Smack down 2 - Looping

Instructor: Jason Strate

Date/Time: 11/27/2012 11:00 AM

Come see looping with SSIS compared to Informatica. We will show how to loop through a set of files and load them to a table. You will also see how to loop through all the tables in a database and document information like row counts. See the differences in the two technologies and learn some best practices.

Shawn Harrison Shawn Harrison

SSIS 2012 Deployment Models

Instructor: Shawn Harrison

Date/Time: 11/15/2012 11:00 AM

There have been many changes to SSIS with the release of SQL Server 2012. One of the most important being the way SSIS packages are deployed. In this webinar, Shawn will demonstrate the two different types of deployment and explain how they work.

Matt Henderson Matt Henderson

How Flash is Modernizing the Data Center and Revolutionizing DW Performance and Databases

Instructor: Matt Henderson

Date/Time: 11/14/2012 11:00 AM

CPUs, memory and networking have all grown in speed and size over the last few decades while the mighty hard drive has only grown in size. With a steady decline in pricing, cards, SSDs and all-flash arrays are dominating the modern storage purchase and changing the way architects are building systems. Join a deep dive into how flash works and learn about how it has started a revolution in how data centers are built and how databases are architected.

Chris Schmidt Chris Schmidt

Merge against SSIS

Instructor: Chris Schmidt

Date/Time: 11/13/2012 11:00 AM

If you’ve used the merge statement in SQL 2008, you’ve no doubt encountered the power that this new set based query tool provides. If you haven’t used this tool yet, come spend some time with us and find out why you should add this tool into your data arsenal. Join us as we walk through some of the benefits of the merge statement and when it might make sense to use this over SSIS. When is it better to use SSIS to get the job done? Finally, we’ll leverage the powers of both of these tools to make extremely effective and powerful SSIS packages.

TJ Brown TJ Brown

Dynamic SSIS packages with Configurations, Expressions, and Variables

Instructor: TJ Brown

Date/Time: 11/8/2012 11:00 AM

Take your ETL skills to the next level by learning how to make your packages dynamic. In this webinar, you will learn how to add functionality and save development time by making your ETL packages dynamic using the SSIS expression language, configuration files, and variables.

Troy Gallant Troy Gallant

Creative Backup Strategies For The Modern DBA

Instructor: Troy Gallant

Date/Time: 11/6/2012 11:00 AM

The importance of a thorough, vigorous backup strategy in todays high-paced enterprise is generally not something thats ever up for debate. But what you may not be aware of are the myriad of different options and routines you can easily implement with only a small amount of effort and planning. This webinar will cover the backup options of the last several versions of SQL Server, as well as some extremely handy scripts to help you accomplish your goals.

Matt Horn Matt Horn

Introduction to Management Data Warehouse

Instructor: Matt Horn

Date/Time: 11/1/2012 11:00 AM

The Management Data Warehouse (MDW) was introduced in SQL Server 2008 and is used as a data store to house historical performance data collected on a scheduled basis, This allows analysis of your environments and in many cases can lead directly to a solution for obscure performance problems The information gathered can also assist in capacity planning and disaster avoidance.

In this webinar we will discuss

  • setting up and configuring the MDW
  • The out of the box reports.
  • Tailoring a custom collector set to capture metrics specifically for Analysis Services
  • Building a custom report

Dustin Ryan Dustin Ryan

PowerPivot 101

Instructor: Dustin Ryan

Date/Time: 10/30/2012 11:00 AM

Building an SSAS cube isn't for everyone. PowerPivot is! This session is for anyone who wants to get started in PowerPivot. Join us as we build a PowerPivot model from the ground up and then create some reports, all in just over an hour. Learn how to use data from existing sources, such as SQL Server databases or Analysis Services, as well as how to integrate currently unrelated data from sources such as Excel workbooks and the Azure data market to bring new life to your data – like analyzing sales based on weather conditions.

Devin Knight Devin Knight

Designing Dynamic SSRS Reports using an Analysis Services Data Source

Instructor: Devin Knight

Date/Time: 10/25/2012 11:00 AM

Creating Reporting Services reports that use Analysis Services as a data source can frustrating. You designed a cube so it can be more flexible for users but Reporting Services is static by nature. This session will walk you through building dynamic datasets that will allow users to change the fields represented in a SSRS report. No longer will Reporting Services be a static reporting tool because your users will have the flexibility to change report metadata dynamically using parameters and Dynamic Management Views (DMV).

Kathi Kellenberger Kathi Kellenberger

New T-SQL Features

Instructor: Kathi Kellenberger

Date/Time: 10/23/2012 11:00 AM

The SQL Server 2012 release has something for everyone: Column Store Index, AlwaysOn Availability Groups, Power View and more. I bet you haven’t heard about all the great new T-SQL features! Attend this webinar to learn about the Sequence Object, new functions, THROW, and more!

Mike Davis Mike Davis

Informatica vs. SSIS: Smack Down

Instructor: Mike Davis

Date/Time: 10/18/2012 11:00 AM

In this webinar you will see how to load a type 1 and type 2 dimension with SSIS and Informatica. Learn the pros and cons of each tool and see them in action. Learn how to use the data flow transforms in SSIS to perform delta load and see the equivalent in Informatica. You will also learn some of the best practices applied in both tools.

Adam Jorgensen Adam Jorgensen

Roping the Elephant - Big Data and BI Live

Book Cover

Instructor: Adam Jorgensen

Date/Time: 10/16/2012 11:00 AM

Have you been wondering how you can sit down at work and use Hadoop to make your BI better? Have you thought about what Big Data could mean to your firm? Come watch Adam setup, populate, consume and integrate data from a Big Data Platform into a SQL BI solution Live!

Jeremiah Nazaruk Jeremiah Nazaruk

BI xPress v.4.0 Launch Party

Instructor: Jeremiah Nazaruk

Date/Time: 10/11/2012 11:00 AM

Join our BI xPress Developers as they introduce you to the new features included in the launch of BI xPress v.4.0! Features include Data Space Analyzer: A tool for making capacity judgments in SQL Server, Schema Surf: A live view of SQL Server object dependencies, BI Compare: A tool for performing meaningful comparisons between 2 BI objects and much more!

Sanil Mhatre Sanil Mhatre

Understanding Parameter Sniffing & Making It Work For You

Instructor: Sanil Mhatre

Date/Time: 10/11/2012 11:00 AM

Parameter Sniffing is usually thought of as the bad guy, in association with a performance problem in your database. Contrary to the popular belief, Parameter Sniffing is usually the good guy, continuously working under the hood to help your database applications run faster. However, it can sometimes go wrong, causing severe performance degradation of your queries. In this session we will discuss the workings of Parameter Sniffing and demonstrate how it helps improve the performance of your database applications. We will also explore how Parameter Sniffing can go wrong and its impact. Several ways to fix bad Parameter Sniffing will be demonstrated to help make an appropriate choice for your scenario.

Brad Schacht Brad Schacht

SharePoint for Business Intelligence

Instructor: Brad Schacht

Date/Time: 10/9/2012 11:00 AM

Are you aware of the many features SharePoint has to offer the Business Intelligence world? In this session, you'll get an overview of SharePoint 2010 and how to integrate it with your current or new BI infrastructure.

We'll discuss the general use of SharePoint for BI and basic setup and installation of the farm, then fly over a completed SharePoint site. You'll tour SharePoint Central Administration, learning how to allow your site to take advantage of many BI features such as PowerPivot, Excel Services, and Reporting Services. With the release of SQL Server 2012, you'll also get a sneak peak at some improvements available in SharePoint for those who want to be on the cutting edge of this growing technology. Forget the slides – this tour will be all demo!

Jody Roberts Jody Roberts

SQL Server Distributed Replay

Instructor: Jody Roberts

Date/Time: 10/4/2012 11:00 AM

The Microsoft SQL Server Distributed Replay feature helps you assess the impact of future SQL Server upgrades. You can also use it to help assess the impact of hardware and operating system upgrades, and SQL Server tuning. Similar to SQL Server Profiler, you can use Distributed Replay to replay a captured trace against an upgraded test environment. Unlike SQL Server Profiler, Distributed Replay is not limited to replaying the workload from a single computer .Distributed Replay offers a more scalable solution than SQL Server Profiler. With Distributed Replay, you can replay a workload from multiple computers and better simulate a mission-critical workload. The Microsoft SQL Server Distributed Replay feature can use multiple computers to replay trace data and simulate a mission-critical workload. Use Distributed Replay for application compatibility testing, performance testing, or capacity planning. In this session we will cover the following :

  • What is SQL Server Distributed Replay
  • Distributed Replay Concepts
  • Benefits of Distributed Replay
  • When to Use Distributed Relay

John Welch John Welch

Migrating ETL Processes From Informatica to Integration Services

Instructor: John Welch

Date/Time: 10/2/2012 11:00 AM

Informatica and SSIS offer similar functionality for moving data around your organization, but scratch below the surface and you will find some big differences in how these tools approach common ETL problems. If you are interested in migrating ETL processes to Integration Services, then this webinar will be highly beneficial. We will cover some common patterns found in Informatica, and explain how to get the same results from SSIS. For more advanced Informatica scenarios, we will also cover the use of PragmaticWorks’ Task Factory components to fill in some of the gaps in Integration Services.

Luis Carlos Vargas Herring Luis Carlos Vargas Herring

SQL Server 2012 AlwaysOn Availability Groups

Instructor: Luis Carlos Vargas Herring

Date/Time: 9/27/2012 11:00 AM

In this session we’ll discuss AlwaysOn Availability Groups, the next generation solution for high availability and disaster recovery in SQL Server 2012. We’ll cover the benefits, concepts, architecture, and considerations; and show some demos.

Mike Davis Mike Davis

Complex DAX Expressions In Power Pivot

Instructor: Mike Davis

Date/Time: 9/25/2012 11:00 AM

PowerPivot is a powerful new tool able to slice and dice data in memory very fast. In this session you will learn how to build complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships and learn some string manipulations. Come see these complex DAX functions and leave with some great DAX knowledge.

Chris Price Chris Price

Go-Live with DQS & Master Data Services 2012

Instructor: Chris Price

Date/Time: 9/20/2012 11:00 AM

If you are unsure how MDS and DQS fit into the enterprise, this session is for you. In this session we will look at a real-world implementation as we introduce a new CodePlex project that integrates MDS and DQS with the nopCommerce project to provide an end-to-end data quality and master data management demo. Using the nopCommerce project as the base, we built-out a data warehouse and then integrated MDS and DQS into both seamlessly. This session will introduce you to the project, discuss the design considerations and review the implementation of MDS and DQS into a real-world application and data warehouse.

Chad Churchwell Chad Churchwell

How SQL Server Replication Works

Instructor: Chad Churchwell

Date/Time: 9/18/2012 11:00 AM

This session will dive into the different types and describe how replication works internally for snapshot, transactional, and merge replication. Also I will cover the difference in push vs pull subscriptions. Also there will be some design decisions covered when creating a replication topology.

Sardys Avile-Martinez Sardys Avile-Martinez

Riding The Reporting Roller Coaster: Deploying to the Server

Instructor: Sardys Avile-Martinez

Date/Time: 9/13/2012 11:00 AM

I will show how to deploy a report to the Report Server and then view it using Report Manager. Also, I will explore and play with the report properties and administrative functions from Report Manager.

Steve Wake Steve Wake

SSIS 2012: More Than Just a Pretty UI

Instructor: Steve Wake

Date/Time: 9/11/2012 11:00 AM

SSIS 2012 added rounded corners and Undo/Redo to the designer, but what else was added to make this worth the upgrade? In this webinar there will be as many demos of the new features as can be fit into the time provided. Along with the rounded corners, you will also see the changes to deployment, SSIS catalog database, metadata/XML updates, Parameters, logging updates, Data Taps, ODBC support, script debugging, PowerShell interface and as many others as we can get through. If you haven't seen what has been updated in SSIS 2012, this will be the presentation to cover the most!

Gareth Swanepoel Gareth Swanepoel

Optimising SQL Server 2012- Part 2

Instructor: Gareth Swanepoel

Date/Time: 9/4/2012 11:00 AM

An "accidental DBA" is a SQL Server administrator who has been thrust into the task without having the experience or know how required to keep SQL running at peak performance. This is not their fault and is purely due to the fact that they have not been exposed to it before. This is a follow-on to a previous webinar and I will continue to explore the process of designing and building your SQL Server for optimal performance. I will be exploring topics such as IO considerations, database file placement, partitioning, compression, and many other performance optimisation tricks.

Kevin Farlee Kevin Farlee

Storage Performance for SQL Server Databases

Instructor: Kevin Farlee

Date/Time: 8/30/2012 11:00 AM

For any database system, once you’ve properly designed and tuned the queries, much of your application performance will be governed by the configuration and specifications of your IO system. We’ll go over the building blocks and characteristics of modern storage systems, where potential bottlenecks exist, and what to do about them. We will discuss common pitfalls and best practices for designing storage systems. Finally, we’ll walk through a real-world example putting all of this in practice.

Timothy McAliley Timothy McAliley

Configuring and Maintaining SQL Server 2012 as a Windows Azure Virtual Machine

Instructor: Timothy McAliley

Date/Time: 8/28/2012 11:00 AM

This session will cover an introduction to Windows Azure Virtual Machines and then we will explore the options for planning and configuring SQL Server 2012 as a Windows Azure Virtual Machine. You will see a demonstration of configuring SQL Server 2012 as a Windows Azure Virtual Machine, and then a demonstration of post-configuration tasks such as storage provisions and resource monitoring. You will also learn the basics of what you need to obtain a Windows Azure account and the different subscription options.

Bradley Ball Bradley Ball

Page and Row Compression Internals in SQL 2012

Instructor: Bradley Ball

Date/Time: 8/23/2012 11:00 AM

Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page & Row with SQL 2008 RTM, and Page & Row with Unicode Compression with SQL 2008 R2. In SQL 2012 we add Spatial Data Types. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan pattern’s affect the compression types you should consider. And what you should you take into consideration for additional overhead.

Shawn Harrison Shawn Harrison

Introduction to Parameters in SSIS 2012

Instructor: Shawn Harrison

Date/Time: 8/21/2012 11:00 AM

SSIS 2012 has introduced many changes and new features. Join Shawn as he explores the uses and possibilities of parameters in SSIS 2012. Learn the differences between the different types of parameters and how they are used in the new deployment models (Package deployment and Project deployment).

Chris Rock Chris Rock

Creating your first Control Flow Task in SSIS

Instructor: Chris Rock

Date/Time: 8/16/2012 11:00 AM

In this webinar Chris will show you how to create your first control flow task. You will discover how to create a reusable component that can be used to send html emails within SSIS

Anthony Coleman Anthony Coleman

Intro to SSIS for Newbies and Beginners: Building Your First Package

Instructor: Anthony Coleman

Date/Time: 8/14/2012 11:00 AM

SSIS is a powerful tool and at first glance looks very intimidating. If you are new to BI or on the fence about learning SSIS fear no more. In this session for newbies and beginners Anthony will introduce you to the SSIS development environment as well as common terms and concepts that one needs to know. He will then take it a step further and build an SSIS package using a real world example! Why wouldn’t you want to learn how to use this powerful tool?

Shawn Harrison Shawn Harrison

Using the Change Data Capture in SQL Server 2012

Instructor: Shawn Harrison

Date/Time: 8/9/2012 11:00 AM

Do you have problems keeping data in sync? Do wish there was an easy way to consistently insert, update and delete data between source tables? Well, this webinar is for you. In this session, Shawn will explain the Change Data Capture and demonstrate how it’s used. Come see how little effort you will have to put forth when keeping your data in tune!

Andrew Thornton-Smith Andrew Thornton-Smith

SharePoint 2010 Performance

Instructor: Andrew Thornton-Smith

Date/Time: 8/7/2012 11:00 AM

We will be discussing the various forms of caching available in SharePoint including IIS caching. Also touching on guidelines on server sizing and splitting of the Service Applications.Finally some SQL considerations for the speedy SharePoint farm.

Scott Klein Scott Klein

An Extensive Look at SQL Azure

Instructor: Scott Klein

Date/Time: 8/2/2012 11:00 AM

This demo-filled session will begin by providing an overview of SQL Azure, Microsoft’s cloud-based relational database service. We will then follow that up with detailed discussions and hands-on demonstrations that illustrate many of the rich and powerful SQL Azure features and services including SQL Azure Federations for scalability and performance, and SQL Azure Data Sync Services for data synchronization. Lastly, we’ll discuss migration strategies for moving your on-premise database into SQL Azure and considerations around migrating to SQL Azure.

Brian Knight Brian Knight

Data Cleansing With SSIS 2012

Book Cover

Instructor: Brian Knight

Date/Time: 7/31/2012 11:00 AM

In this session, you’ll learn how to use the Data Profiling Task, Script Transform and Fuzzy logic. Also learn how to use Data Quality Services (DQS) and Master Data Services (MDS) to normalize and cleanse your data.

Jessica Moss Jessica Moss

Upgrading and Overhauling Your SSIS Packages for 2012

Book Cover

Instructor: Jessica Moss

Date/Time: 7/26/2012 11:00 AM

SQL Server 2012 makes great strides in the development, maintainability, and administration features of Integration Services packages. Whether you already have packages from an earlier version or you are starting from scratch, you will learn how to take advantage of these new features. In this session, we will show: an upgrade of Integration Services packages from 2008 R2 to 2012, the modifications needed to run these packages in 2012, and the information produced about package execution.

Joe Salvatore Joe Salvatore

Extending Reporting Services 2012 with Custom Code

Book Cover

Instructor: Joe Salvatore

Date/Time: 7/24/2012 11:00 AM

During this session we will learn how and why we might use custom code with in Reporting Services. Several examples will demonstrate various approaches of using custom code to extending Reporting Services.

Robert Bruckner Robert Bruckner

Visual Analytics with SQL Server Power View

Book Cover

Instructor: Robert Bruckner

Date/Time: 7/19/2012 11:00 AM

Power View, a new feature of SQL Server Reporting Services 2012, provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. Power View is a browser-based application that enables users to present and share insights with others in their organization through interactive presentations. In this session you learn about the architecture of Power View, exploring data interactively and creating compelling presentations with Power View. You will see many of the capabilities for analysis, visualization, and sharing available with Power View.

Chris Rock Chris Rock

Task Factory Launch Party 3.0

Instructor: Chris Rock

Date/Time: 7/19/2012 11:00 AM

Task Factory is a collection of essential, high-performance components and tasks for SSIS that eliminate the need for programming. We have added several tasks based on our newly implemented expression engine that bring 180+ functions with a simplified expression language that bring power to your ssis like never seen before. Join us for a live demo of these exciting new features!

Ross LoForte Ross LoForte

SQL Server 2012 Failover Cluster

Book Cover

Instructor: Ross LoForte

Date/Time: 7/17/2012 11:00 AM

Windows Failover Cluster provides high availability capability and SQL Server 2012 delivered feature enhancements around resiliency, geographic dispersed clustering and troubleshooting to provide high availability (HA) and disaster recovery solution at the SQL instance level using shared storage. In this session, you will learn what are these feature enhancements, benefits, how to use them and what they can do for your company. Additionally, we’ll compare and contrast Windows Failover Cluster and Availability Groups for when to use one or the other and when to use them in combination.

Ross LoForte Ross LoForte

SQL Server 2012 Availability Groups

Book Cover

Instructor: Ross LoForte

Date/Time: 7/12/2012 11:00 AM

SQL Server Availability Groups is a new comprehensive high availability (HA) and disaster recovery solution for SQL Server 2012. Using Availability Groups, businesses can now achieve increased application availability and get better return on their hardware investments through a simplified HA deployment and management experience.

In this session, you will learn the how and when you should use Availability Groups by starting with an overview, benefits, architecture and setup/configuration of Availability Groups and real world experiences. Availability Groups demo will be included.

Chris Albrektson Chris Albrektson

Getting Started with SSRS 2012

Book Cover

Instructor: Chris Albrektson

Date/Time: 7/10/2012 11:00 AM

In this session Chris will give an introduction to reporting with Microsoft SQL Server Reporting Services (SSRS) 2012. You’ll learn everything you will need to know to get started when creating your first reports using the latest release of SSRS. During this session we will also discuss and review the latest features and updates that have been included such as Power View, Data Alerts, Rendering Formats, and SharePoint integration.

Bradley Ball Bradley Ball

SQL 2000 Upgrade Tips and Tricks

Instructor: Bradley Ball

Date/Time: 6/28/2012 11:00 AM

Are you still working on SQL 2000? Do you dream of 64 bit landscapes and a world without WOW and memory as far as the eye can see? Are you planning an upgrade, working on your upgrade strategy, or screaming at your boss about the impending April 2013 deadline when SQL 2000 SP 4 finally goes out of extended support. Well look no further! Today you have the chance to get my Tips & Tricks for SQL 2000 upgrades, importing exporting Logins, Locking old Logins, what’s a rollback strategy and why do I need one, and more!

Chris Price Chris Price

Integrating DQS, MDS and Your Data Warehouse

Book Cover

Instructor: Chris Price

Date/Time: 6/26/2012 11:00 AM

With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse.

Adam Jorgensen Adam Jorgensen

What’s new in SSAS in 2012

Book Cover

Instructor: Adam Jorgensen

Date/Time: 6/21/2012 11:00 AM

Have you heard of BISM, Tabular, Power…Stuff – Come hang out with MVP Adam Jorgensen while he goes through the new features in Analysis Services in 2012 and how best to use them in your environment.

Chris Rock Chris Rock

Creating your first custom SSIS Component

Book Cover

Instructor: Chris Rock

Date/Time: 6/19/2012 11:00 AM

Chris will show you how to create your own custom SSIS data flow transformation. We will cover how to read input data, process the input data and send data to outputs.

Gareth Swanepoel Gareth Swanepoel

Optimizing SQL Server 2012

Book Cover

Instructor: Gareth Swanepoel

Date/Time: 6/14/2012 11:00 AM

An "accidental DBA" is a SQL Server administrator who has been thrust into the task without having the experience or know how required to keep SQL running at peak performance. This is not their fault and is purely due to the fact that they have not been exposed to it before. If you are a DBA and find yourself wondering how hardware changes affect performance or have questions relating to the performance implications of partitioning or compression, then this session is for you. I will be exploring topics such as Memory configuration, CPU options and IO considerations.

Jorge Segarra Jorge Segarra

Tool Time: Overview of SQL Server 2012 Toolset

Book Cover

Instructor: Jorge Segarra

Date/Time: 6/12/2012 11:00 AM

SQL Server 2012 brought a whole slew of really cool features with it. In addition to all the new features, we have new tools and interfaces to take advantage of all this goodness! In this session Jorge Segarra will do an overview of the new SQL Server Management Studio and SQL Server Data Tools (formerly Business Intelligence Developer Studio or BIDS) and show you all the hidden gems these new tools bring developers and administrators alike!

Mike Davis Mike Davis

SSIS 2012 Administration

Book Cover

Instructor: Mike Davis

Date/Time: 6/7/2012 11:00 AM

In this session you will Learn how to deploy, secure, execute and monitor SSIS packages in the new SSIS 2012. Learn how to use the new SSIS catalog and understand the new SSISDB. Afterwards you will have a thorough understanding of SSIS administration in SQL 2012.

Bradley Schacht Bradley Schacht

SSIS ETL for Beginners

Book Cover

Instructor: Bradley Schacht

Date/Time: 6/5/2012 11:00 AM

In this session Brad will show you how to use SSIS to connect to a variety of different data sources and destinations such as Excel, SQL Server, Oracle and Flat Files. He will then discuss some of the DOs and DON’Ts of the SSIS ETL world, including looking at ways to use SSIS to do a simple data dump, keep tables in sync, do incremental loads, deal with very large data sets that you may not be able to handle all in memory, and bring multiple sources into one destination.

Michael Rys Michael Rys

Beyond Relational Performance and Scale in SQL Server 2012

Instructor: Michael Rys

Date/Time: 5/31/2012 11:00 AM

Managing unstructured and non-relational data is becoming an increasingly important capability for database applications. SQL Server has been providing support for such applications for several releases and has continued its investment for SQL Server 2012. In particular, SQL Server 2012 is adding improved integration for unstructured data management and the file system, improved the full-text search capabilities and scalability and continued the investment in supporting Spatial applications. In this presentation, I will focus on how we improved scalability and performance for Filestreams, Fulltext Search and Spatial queries.

Kathi Kellenberger Kathi Kellenberger

SQL Server Data Compression

Instructor: Kathi Kellenberger

Date/Time: 5/29/2012 11:00 AM

SQL Server data compression was introduced with 2008. Of course, compression can save you storage space, but many DBAs do not know that you can get a performance boost from compression as well. By attending this webinar, you will learn about the two levels of compression, how to estimate the benefits of compression, and how to implement it.

Troy Gallant Troy Gallant

Indexing your Data Warehouse

Instructor: Troy Gallant

Date/Time: 5/24/2012 11:00 AM

One of the primary skillsets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. Some scenarios warrant a very similar approach, while others require adaptation to an entirely new paradigm. This webinar will attempt to flush out some of these differences, and hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently.

Bradley Ball Bradley Ball

Transparent Data Encryption Inside and Out In SQL 2012

Instructor: Bradley Ball

Date/Time: 5/22/2012 11:00 AM

Security is a very important part of your job and in how data is utilized. We have many tools to make data more secure, and starting in SQL 2008 we were able to add Transparent Data Encryption to that list. Find out What it does and What it doesn’t do, How it effects Read-Only Filegroups, Performance, Compression (Backup and Row/Page), What the X.509 Encryption Standard is and Why you should be careful of what you store and where, and other Advance Features as well as some tips on how to manage it.

Mark Brown Mark Brown

BI Documenter V4.5 Launch Party!

Instructor: Mark Brown

Date/Time: 5/17/2012 2:00 PM

Join us for a preview of the new features launching in BI Documenter v.4.5 including SQL 2012 Compatibility, the ability to use all of the existing BI Documenter features against the latest version of Microsoft SQL Server 2012 and Word Documentation Output (.docx), allowing you to create an output that is compatible with one of the best known portable documentation types gives you the flexibility to easily document, modify, store, and share your BI Stack information.

Bradley Schacht Bradley Schacht

SharePoint for the DBA

Instructor: Bradley Schacht

Date/Time: 5/17/2012 11:00 AM

In this session Brad will discuss the DBA's role in a SharePoint environment as well as much of the important information about SharePoint that a DBA should know. Topics to be discussed include SharePoint database architecture, service applications creating databases, dos and don'ts of database maintenance, backup and restore and disaster recovery. Brad will also cover some of the blurry lines such as where do the DBA's job responsibilities end and the SharePoint admin's being. This session is a must attend for any DBA that deals with SharePoint in their environment.

Jorge Segarra Jorge Segarra

STOP! Consolidate and Listen!

Instructor: Jorge Segarra

Date/Time: 5/15/2012 11:00 AM

In today's economic times, we are being asked to do more with less-less budget, less hardware-and yet our data needs keep growing! How do we keep our database infrastructure humming along given these restrictions? In this session, we talk about different options of consolidation, including database-level consolidation, instance-level consolidation, and virtualization. We also discuss some of the tools and methods you can use today to help consolidate your SQL Server environment and do more with less.

Chad Churchwell Chad Churchwell

SQL Server 2012 AlwaysOn for High Availability and Disaster Recovery

Instructor: Chad Churchwell

Date/Time: 5/10/2012 11:00 AM

This webinar will explore the new AlwaysOn features of SQL Server 2012 and how this can be used to set up a DR/HA plan. We will discuss the current limitations of database mirroring and clustering as well as cover how these limitations have been accounted for in SQL Server 2012. Topics will be availability groups and failover cluster instances as well as a demo of these features.

Jeremiah Nazaruk Jeremiah Nazaruk

BI xPress Launch Party - May 2012

Instructor: Jeremiah Nazaruk

Date/Time: 5/10/2012 11:00 AM

Join our BI xPress Developer as he walks you through the new features included in the launch of BI xPress v.3.5! Features include SQL Server Integration Services 2012 support and new SQL Server Reporting Services 2012 dashboard and Report Deployment tools!

Alistair Pugin Alistair Pugin

Technical Track: Multi-Tenancy vs Shared Services in SharePoint 2010

Instructor: Alistair Pugin

Date/Time: 5/3/2012 11:00 AM

Many organizations start out by deploying SharePoint using a “Shared Services” model but realise that various divisions, companies and or business units want a more individualized control over their platform; enter the Multi-Tenant. In this session we will cover:

  • The differences between Shared and Tenanted Architecture
  • The pitfalls of both platforms
  • How to effectively deploy multi-tenancy
  • What administrative components are required for either deployment By identifying the capabilities of SharePoint 2010’s tenanted infrastructure upfront, SharePoint Architects will be better equipped to make the correct decisions as to:

    1. What platform to use
    2. What features to use within each platform
    3. Ultimately how to manage SharePoint more efficiently

Gareth Swanepoel Gareth Swanepoel

SQL Server 2012 DMV's & Extended Events: Lightning sand, Flame spurts, & R.O.U.S.'s

Instructor: Gareth Swanepoel

Date/Time: 5/1/2012 11:00 AM

As a lone DBA in the scary world of the SQL Server 2012 Fire Swamp, you may be wary of the multiple threats of Lightning sand, Flame spurts & Rodents of Unusual Size. In this session, come and learn how to map your way through these threats using the new and improved DMV's and Extended Events that are found in SQL Server 2012.

In this session, you will learn about the new DMV's available in SQL 2012. You will also learn about the improved XEvents interfaces and how to use XEvents to monitor your server and track issues.

Thomas Kejser Thomas Kejser

CAT Tales on Large BI Installs

Instructor: Thomas Kejser

Date/Time: 4/26/2012 11:00 AM

Since the great crash in 2008, banks have been busy building risk analytics systems. Several of these are run on SQL Server Analysis Services. In this session, I will present design patterns for large scale, near real time cube. You will learn how to load at millions of rows every second and how to handle hundreds of concurrently executing queries. I will also give you a preview of the cool SQL 2012 features that further improve the scale of Analysis Services cubes.

Brian Knight Brian Knight

Upgrading DTS Packages to SSIS

Instructor: Brian Knight

Date/Time: 4/24/2012 11:00 AM

The Microsoft “End of Life” policy for SQL 2000 has encouraged many organizations to seriously look at migrating their SQL2000 servers to SQL2005 or 2008. One of the biggest obstacles to a rapid migration is the DTS package issue. To gain the performance benefits and a supported path forward for the functionality in DTS, these packages should be converted into native SSIS. As we all know, the conversion is NOT straightforward. SSIS is more powerful and significantly different from DTS. Join Brian as he takes you through the transition!

Jorge Segarra Jorge Segarra

How to manage Big Data, Tips and Tricks

Instructor: Jorge Segarra

Date/Time: 4/19/2012 11:00 AM

In this session join Jorge Segarra as he dives into Big Data: What it means, if you’ve got it and how to handle it. Jorge will Explore how data is growing in the enterprise, review challenges and current best practices for handling large data volumes in BI, look at industry solutions that help enable massively parallel processing, and help you understand how to take your organization’s data to the next level.

Max Trinidad Max Trinidad

Basic Intro to PowerShell for the DBA

Instructor: Max Trinidad

Date/Time: 4/17/2012 11:00 AM

This is an Intro level for the SQL DBA wanting to start and learn how to use PowerShell in their environment. It will be divided in two half hour part be covering PowerShell setup essentials, and using the SQLPS module to build SQL PowerShell scripts.

Mike Davis Mike Davis

Intro to IRS and SSRS

Instructor: Mike Davis

Date/Time: 4/12/2012 11:00 AM

Agreed the IRS needs no introduction. This webinar looks at using Reporting Services to create W2's. It is a "fun" way to "celebrate" tax season. The second part of this webinar will show you how to lower your tax bill, get audited, and possibly be arrested. Why get a CPA? No IRS agents allowed. If management is reading this, it was not my idea.

Aaron Nelson Aaron Nelson

SQL Server PowerShell Extensions

Instructor: Aaron Nelson

Date/Time: 4/10/2012 11:00 AM

Windows PowerShell is an easy way to automate tasks, gather info, and deploy objects to your SQL Servers but how do you get started? Microsoft MVP Aaron Nelson will discuss easy shortcuts the SQLPSX Module provides for managing multiple SQL Servers. Aaron will also walk you through the hierarchy of some of the core functions and provide you with a sequence that enables you reuse your scripts.

Andrew Thornton-Smith Andrew Thornton-Smith

SQL for SharePoint 2010 Farms

Instructor: Andrew Thornton-Smith

Date/Time: 4/5/2012 11:00 AM

In this session, we will cover the need to know for SQL administrators who are now responsible for SharePoint's DBs. In our journey, topics we will cover will be, Farm sizing's & architecture to considerations for Enterprise Search and considerations for crawling the dreaded G:\, H:\ Z:\ drives, To the myriad of SharePoint Databases and which to watch out for. And finally what tasks in SharePoint are the heavy weights in terms of IOPS, CPU & RAM.

Chris Price Chris Price

Data Quality Services 2012

Instructor: Chris Price

Date/Time: 4/3/2012 11:00 AM

We will explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges. We will start from zero, build a knowledge base, profile data to train our knowledge base and then use that knowledge to highlight both the cleansing and matching capabilities of DQS. This session will also cover the DQS SSIS component that’s available in SQL Server 2012.

Mark Brown Mark Brown

Test Driven Development (TDD) in C# using NUnit

Instructor: Mark Brown

Date/Time: 3/29/2012 11:00 AM

We will provide an introduction to the practice of test driven development, how it compares to unit testing, and what it does not cover. We will build an example using test driven development to illustrate its use. We will identify other types of testing and the tools used for them.

Dan Clark Dan Clark

Mastering Date-Time Based Analysis in DAX

Instructor: Dan Clark

Date/Time: 3/27/2012 11:00 AM

A large volume of analysis that a business typically performs on its data involves dates and/or times. For example, you may need to compare sales from one year to the next or aggregate transactions over time. DAX incorporates many built in time intelligence functions to help make date-time based calculations easier. Although the time intelligence functions are very beneficial, they can be misused and give erroneous results. To avoid this, it is imperative that you understand what functions to use and how to use them.

This webinar is designed to guide you through the various time intelligence functions available in DAX and provide practical examples of how to use them. We will also cover time intelligence best practices and how to avoid the many “gotchas” that can occur by misusing these functions.

Nabeel Derhem Nabeel Derhem

Performance Tips and Tricks with SQL Server, real cases with developers

Instructor: Nabeel Derhem

Date/Time: 3/22/2012 11:00 AM

Application developers don't care much about how SQL Server executes their queries as long as they get what they want. This session introduces common real case scenarios where developers end up with troublesome queries and bad performance. Explanation is linked to a discussion of alternative effective ways to handle such scenarios.

Brian Knight Brian Knight

Task Factory Launch 2012

Instructor: Brian Knight

Date/Time: 3/21/2012 11:00 AM

Task Factory is a collection of essential, high-performance components and tasks for SSIS that eliminate the need for programming. Using Task Factory can increase productivity and give you a much higher level of performance. Join Brian as he covers the new and improved features in the latest release of Task Factory.

John Welch John Welch

Advanced SSAS

Instructor: John Welch

Date/Time: 3/20/2012 11:00 AM

Join John for a demo heavy session that will teach you how to build tier 1 Analysis Services solutions that will scale and explain all the internals to help you back up the best practices implemented in these demos.

Gareth Swanepoel Gareth Swanepoel

The Fangorn Forest - ColumnStore Indexes

Instructor: Gareth Swanepoel

Date/Time: 3/15/2012 11:00 AM

In the fantasy world of Middle-earth, deep in the Fangorn forest live the Ents. The Ents are tall tree-people who help the Fellowship by parallelizing the fight against Saruman. Come and learn how the new SQL Server 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations in the same way. I will be doing a deep dive into the inner workings of ColumnStore indexes; how they work, key characteristics, dos and don'ts, restrictions, and more. If you are a production DBA who needs to find out more about some of the additional hot features that have been included with ColumnStore Indexes, like batch mode processing and data segments, then this session is for you. If you are a business intelligence DBA or developer who needs to find out how ColumnStore Indexes can increase the performance of your aggregations and star-joins by up to 40 times, then this session is also for you.

Shawn Harrision Shawn Harrision

SSIS Log Providers Demystified

Instructor: Shawn Harrision

Date/Time: 3/13/2012 11:00 AM

Any SSIS developer that wants to save themselves many headaches should be using logging in their SSIS packages. In this session Shawn will explain all the log providers and the pros and cons of each. So, if you aren’t using logging in your packages, and you hate looking at agent job history, then make sure you attend this webinar. Your DBA’s might stop hating you!

Jorge Segarra Jorge Segarra

Create a Virtual Online Learning Environment for Your Organization (and not get FIRED!)

Instructor: Jorge Segarra

Date/Time: 3/8/2012 11:00 AM

Create and setup a segregated computer lab for your organization in a DMZ (a sexy computer lab). Use virtualization technology to create quick turnover after class completion and maximize uptime (so there is more time for naps in the lab). Create .vhd files to load onto PC’s. Allow employees to utilize online training on campus without compromising security and violating security laws (you get to keep your job). Optimize for Go To Meeting and expand conferencing capabilities. Put the WOW in employee development and online learning.

Brad Schacht Brad Schacht

Introduction to SharePoint BI

Instructor: Brad Schacht

Date/Time: 3/6/2012 11:00 AM

In this session Brad will provide you an overview of SharePoint 2010 and how it can be integrated with your current or new Business Intelligence infrastructure. He will discuss the general use of SharePoint for BI, basic setup and installation of the farm, as well as an overview of a completed SharePoint site. Brad will take you on a tour of SharePoint Central Administration including how to allow your site to be able to take advantage of many of the BI features such as PowerPivot, Excel Services and Reporting Services. With SQL Server 2012 right around the corner Brad will give you a sneak peak at of some of the improvements that are coming to SharePoint for those of you who want to be on the cutting edge of this growing technology. Slides don't teach anything, this tour will be all demo!

Shawn Harrison Shawn Harrison

Performance Tuning SSIS

Instructor: Shawn Harrison

Date/Time: 3/1/2012 11:00 AM

SSIS is a powerful ETL tool, but by nature ETL developers are always looking for better performance. In this hour long presentation Shawn will cover many basic options and features that you can use to performance tune any SSIS package. Who wouldn’t want better package performance?

Brian Knight Brian Knight

Managing SSIS in Denali

Book Cover

Instructor: Brian Knight

Date/Time: 2/28/2012 11:00 AM

In this session, you’ll learn how to manage SSIS in SQL Server Denali. You’ll first see how the logging and auditing of your SSIS packages has changed in Denali. Then, you’ll learn how parameterization of packages has been overhauled in Denali to make a zero-touch deployment of your packages. In this demo-packed session, you’ll walk through the entire lifecycle of a package from deployment to longer-term management of the package.

Lara Rubbelke Lara Rubbelke

Microsoft Big Data and Apache Hadoop

Instructor: Lara Rubbelke

Date/Time: 2/23/2012 11:00 AM

Learn how to unlock the value of data stored in Hadoop using Microsoft’s Big Data solutions. Discussion will include Apache Hadoop on Azure, leveraging Sqoop connectors, and building Microsoft’s Business Intelligence solutions with data stored in Apache Hadoop.

Mark Brown Mark Brown

Beginning Development for Business – Part 4: Running in the Halls