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
Michael Reed Michael Reed

Big Data- Part 2 of 3- Beyond the Basics

Instructor: Michael Reed

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

In this hour I will build on the exercises in Part 1 of this series. I will cover more advanced data acquisition and transformations, building 'tidy' data sets, plotting and visualizations, and basic data mining using a variety of tools and utilities. This is part two in a three part series which takes you from setting up your environment to basic analytics to applying analytics to business decision making.

Mitchell Pearson Mitchell Pearson

SSIS Performance Tuning Techniques

Instructor: Mitchell Pearson

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

SSIS is an extremely powerful ETL tool, but with great power comes great responsibility. The responsibility to not just create SSIS package, but create SSIS package that perform as efficiently as possible. This session will share best practices for developing packages that perform well from the start. It will also walk you step by step through identifying and fixing performance issues in an existing package. After watching this demo filled session you’ll be able to get your package performing better than ever!

Adam Jorgensen Adam Jorgensen

On-Demand Compute and Analytics with Powershell, Hadoop and Azure

Instructor: Adam Jorgensen

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

This session will take the beginner in big data and show them how to use powershell, HDinsight and Microsoft's Azure platform to enable on demand analytic and compute. These capabilities are critical in the modern data warehouse environment and can only be delivered by technologies working together to create an analytic fabric that the organization can use. From developers the analysts and operations folks, this session will have something for all of you.

Jason Strate Jason Strate

Introduction to Parallel Data Warehouse Distribution Theory

Instructor: Jason Strate

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

Microsoft's Parallel Data Warehouse utilizes a distributed SQL Server environment. In order to properly leverage this environment, developers and query writers must have an understanding of the underlying distribution theory. This distribution theory governs how data is distributed and plays a key role on returning results. In this sessions, we'll review the rules that comprise PDW's distribution theory with demonstrations on how these rules function on PDW. Attendees can expect to learn the rules that comprise distribution with a clear understanding of their impact on data distribution and query execution.

Michael Reed Michael Reed

Big Data- Part 1 of 3- Let’s Get Started

Instructor: Michael Reed

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

In this hour I will show you how to set up a Big Data environment, how to load and transform data, and how to access the data using Hadoop and Microsoft utilities. I will leave you with all of the pieces, parts, instructions, and additional experiments to set up your own environment and get some actual stick time. This is part one in a three part series which will take you from setting up your environment to basic analytics to applying analytics to business decision making.

Kathi Kellenberger Kathi Kellenberger

Kids and Tech: Why You Should Care and What You Can Do

Instructor: Kathi Kellenberger

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

Kids today love technology. They love using it anyway. Love it or hate it, our world is driven by technology, and we will be experiencing huge shortages in technology workers in the near future. What can you do today to make sure the kids in your life know that they can have bright futures with technology careers?

Rowland Gosling Rowland Gosling

Create a Tactical Plan Using Hadoop and Cloud Technologies

Instructor: Rowland Gosling

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

How quickly would you be able to gather data, align resources and using analytics - create a tactical plan? We're going to walk through an emergency scenario where data is pulled from public sources and shared with a team of responders all using the cloud and Hadoop. Once we have out scenario, we will show the next steps as data reduction/analytics using more traditional tools such as SQL Server, Analysis Services and more.

Rowland Gosling Rowland Gosling

Rescue Me! Hadoop and SQL Server

Instructor: Rowland Gosling

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

Ever wonder how Hadoop might work with SQL Server in a supporting role? Curious about how leveraging the power of big data without throwing away large investments? This session is for you! We will explore the integration of SQL Server 2014, Integration Services, HDInsight (Hadoop) and its related services using a data lake model. We’ll walk through how emergency teams might use the power of public data sets such as weather, demographics, and geographical data to set up a response hosted in the cloud.

John Welch John Welch

DOC xPress Server Edition: Making Documentation Easier

Instructor: John Welch

Date/Time: 7/30/2014 1:00 PM

Join us for a live demo of the new DOC xPress Server Edition! DOC xPress Server brings the metadata capabilities of the DOC xPress desktop application to a web application that you host, making it much easier to share documentation, lineage, and data dictionary information in your organization. By supporting a web-based user interface, you can provide access to all of your business and technical users, without requiring them to have a desktop installation. Get a chance to ask our development team any questions you may have during this information session.

Angel Abundez Angel Abundez

Data Warehouse Project Manager Tools

Instructor: Angel Abundez

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

Do you need to write a specification for a data warehouse project coming up? Do you have to write User Stories or Use Cases and don’t know where to start? How about UAT, do you have a Test Plan put together? Never heard of a bus matrix before? Data warehouse projects are hard to manage because they change at a fast pace from the inception of a project. Hence, the need for an Agile Development life cycle. Given the right tools, you can absolutely manage any data warehouse project you’ve got in-house. Come learn about Project manager tools from an experienced Project Server admin. No, we won’t use Project Server, but for this session, we’ll just pick apart some tools and go over some great resources that will help you make sense of the chaos that transpires throughout the lifecycle of Data Warehouse project. Mr. Kimball has already done a lot of thinking for us, but keep in mind this session is not looking at the Dimensions and Facts themselves, but how the project overall can be managed, tracked, and broken down in a way that makes sense to PM’s regardless of industry.

Bradley Schacht Bradley Schacht

Getting Started with Change Data Capture

Instructor: Bradley Schacht

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

Insert, update or delete. It seems simple enough. Syncing data between systems can be a massive undertaking. Wouldn't it be easier if you knew exactly what to do on the destination before the record even left the source? Do you wish there was an easy way to consistently insert, update and delete data between tables without building complex looks and SSIS packages? Well, this webinar is for you. In this session, Brad 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!

Don Gabor Don Gabor

Networking to Build Your Business Contacts and Boost Your Revenue

Instructor: Don Gabor

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

In this fast-paced and interactive webinar, Don Gabor, networking expert and best-selling author of How to Start a Conversation and Make Friends will show you how to increase your odds of connecting with colleagues, clients and prospects at company events, industry conferences, and other business meetings. Topics include: • Establishing Networking Goals and Preparing for Networking Events • Breaking the Ice and Remembering Names • Changing Topics and Turning Small Talk into Conversations • Ending Conversations to Encourage Future Business Contacts • Working the Room and Approaching Other Groups • Following Up and Transitioning into Profitable Business Relationships • Avoiding common networking mistakes and toxic networkers

David Siska David Siska

Dynamic SSRS Reports Using T-SQL and MDX

Instructor: David Siska

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

This session will focus on dynamic SSRS reporting using parameters and user input. We will look at cascading parameters and pre-emptive troubleshooting designs. Some of the reporting will be sourced from SSRS and SSAS DMVs/logs as an added bonus. Bring your thinking caps!

Jason Strate Jason Strate

Understanding Data Movement in Parallel Data Warehouse

Instructor: Jason Strate

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

To fully leverage the power of the Parallel Data Warehouse (PDW), data is distributed across all of the nodes within the appliance. Ideally, the data that each node requires will be located on that node. Unfortunately, there are a number of situations where this isn't the case. To solve this, PDW sometimes moves data between nodes within the appliance. At times this movement is desired and at other times, it is not, resulting in possible performance issues. In this session, we'll review the different types of data movement within the PDW, explaining the need and benefit of each type of movement. At the end of the session, you'll understand each type of data movement and understand how to identify when the data movement isn't desirable with options on how it can be mitigated.

Angel Abundez Angel Abundez

Power BI tips for the Data Analyst

Instructor: Angel Abundez

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

Power View alone is a wonderful tool for analyzing data in both visual and written form. However, it is good to know how to harness all of its power by using all of its functionality with best practices in mind. PowerPivot too, is very powerful, but now add on Power Query, and you have so much freedom to analyze any type of data, that its important to know all these capabilities exist so you can be ready to answer your business’ questions when the time comes. In this session, we’ll take typical business cases that you may originally thought required the help of a SQL person or IT developer, but in reality, you can handle all by yourself in Excel. Whether your scraping data off the web, loading flat files, or connecting to databases, this session will have something for you.

Gareth Swanepoel Gareth Swanepoel

What’s in SQL Server 2014 for the DBA?

Instructor: Gareth Swanepoel

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

SQL Server 2014 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s and architects to some of the exciting features available in that version. Topics covered in this session include AlwaysOn enhancements, Clustered ColumnStore indexes, Memory-optimised tables (In-Memory OLTP, code-named Hekaton), the new cardinality estimator and Extended Events enhancements. If you are a SQL Server DBA, an architect or an IT professional who is excited about the new SQL Server 2014 features and are looking forward to learn more about them, this session is for you.

Michael Reed Michael Reed

SSAS–Back to the Basics

Instructor: Michael Reed

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

In this demo heavy session we will cover the fundamentals for developing your Multidimensional Cube. You’ll learn best practices, common pitfalls to look out for, and the expert’s must have tips and tricks for troubleshooting and improving your cube’s performance.

Devin Knight Devin Knight

Using SQL Server 2014 to Build Analysis Services Tabular Models

Instructor: Devin Knight

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

Have you pushed the limits of what Power Pivot can do? Do you feel like your users aren’t tech savvy enough to build their own Power Pivot models? This session will show you how to use SQL Server 2014 to build Tabular Models to scale beyond the capabilities of Power Pivot and be completely managed by IT. Give your users the single version of the truth while still having the ability to discover and explore your data.

Robert Cain Robert Cain

Everything You Ever Knew About SSIS Is Null and Void

Instructor: Robert Cain

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

With the release SQL Server Integration Services 2012, Microsoft did a massive overhaul to the deployment platform for SSIS. Gone is the old file based deployment system and MSDB. New to SSIS is the Integration Services Catalog. Along with the catalog came many new improvements, such as package and project parameters. No longer do you have to mess around with ugly configuration files, or the mess of passing data between packages. Also included are new reports which you can use to examine your packages as they run, or see the status of past runs. In this session we'll look at how the new project based deployment model simplifies your SSIS coding. We'll also take a dive into the catalog, uncovering the wealth of information it can provide.

Chris Albrektson Chris Albrektson

Advanced SSRS Expressions

Instructor: Chris Albrektson

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

In this session, join Chris as he will walk you through some intermediate and advanced SSRS expressions that you may not be familiar with. This will be an all demo session were we cover an array of examples in a short amount of time. This session is designed for someone who already has some experience with the SSRS expression language.

Kathi Kellenberger Kathi Kellenberger

What's New in SSIS 2012 and 2014

Instructor: Kathi Kellenberger

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

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

Steve Wake Steve Wake

Building a Better Workstation

Instructor: Steve Wake

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

Doesn't matter if you are a SQL Developer, BI Developer, DBA or a combination of those, we all need to have the right tools to get our jobs done. Now that many of the tools for SQL Server are no longer being included with the installer we will all have to do more work to get everything setup and ready. What are BIDS and SSDT? What version(s) of SSDT do I need? Can I install multiple different versions of these on the same workstation? Can I do .NET development and SQL Server development in the same tools? These are just the start of the questions you may be asking when getting a workstation setup. There are lots of other tools out there that you might find useful and tips/tricks in the tools you are already used to. Sometime will also be spent on the advantages/disadvantages to using VMs for your development workstation. By the end of this session you will be able to build the best development workstation and be able to keep it up-to-date into the future.

Shawn Harrison Shawn Harrison

Introduction to DQS

Instructor: Shawn Harrison

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

Data Quality Services in SQL Server 2012 is a great tool for the cleansing of data. It uses knowledge bases to perform a number of data cleansing tasks. In this session, Shawn will cover all the basics of using DQS, and using the DQS component in SSIS for data cleansing.

Chris Price Chris Price

Beyond Relational: Architecting Apps with NoSQL Mashups

Instructor: Chris Price

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

In this session theory meets practice as we explore architecture patterns for incorporating NoSQL database into your applications. We start by reviewing the four primary types (key/value, document, columnar and graph) of NoSQL databases to understand each implementation’s strengths and weaknesses. We will then explore features common to each that make them great candidates for high performance business applications. Finally, we will explore application scenarios and architect a mash-up that extends beyond a traditional SQL database to include these NoSQL databases.

John Welch John Welch

Introducing DOC xPress Server Edition

Instructor: John Welch

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

Join us for a live demo of the new DOC xPress Server Edition! DOC xPress Server brings the metadata capabilities of the DOC xPress desktop application to a web application that you host, making it much easier to share documentation, lineage, and data dictionary information in your organization. By supporting a web-based user interface, you can provide access to all of your business and technical users, without requiring them to have a desktop installation. Get a chance to ask our development team any questions you may have during this information session.

Anthony Martin Anthony Martin

SSIS Tales From The Road

Instructor: Anthony Martin

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

SQL Server Integration Services is a versatile tool that makes it easy to move and transform data. Sometimes unusual situations present themselves that leave developers scratching their heads. In this webinar, Anthony will demonstrate how to handle some of these oddball challenges.

Devin Knight Devin Knight

Using SQL Server 2014 to Build Analysis Services Multidimensional Cubes

Instructor: Devin Knight

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

Your users are begging to see your data in an easy to consume tool but they’re not tech savvy enough to understand how to build their own Power Pivot models. This session will show you how to use SQL Server 2014 to build Analysis Services Multidimensional Cubes, which has the most power to consume even the most complex data warehouse designs. Empower your users to discover and explore your data through an IT vetted data source.

Robert Cain Robert Cain

Using PowerShell to Automate SQL Server Data Warehouse Development

Instructor: Robert Cain

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

For some time now DBAs have harnessed the power of PowerShell to automate the management of their SQL Server environment. But PowerShell can be just as powerful a tool for automating data warehouse development. A common practice in most data warehouses is the creation of a staging area, similar in structure to the source system. Using PowerShell a developer can automate much of that process. PowerShell can take the task even further, applying data quality rules to the process, generating select statements (including HashBytes values) for use in SSIS packages, and more. In this fast paced session attendees will see a real world example where a PowerShell framework was able to save months of development time by automating the generation of literally thousands of tables and select statements.

Jason Strate Jason Strate

PDW and Cloud Scale – Unlimited Performance

Instructor: Jason Strate

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

Yesterday's common theme in data platforms was the constraint on performance from available resources and the capacity to scale up with data growth. With today's, modern data platform, you have opportunities to design and build platforms that grow with your needs. In this session, we'll explore Microsoft's Parallel Data Warehouse (PDW); which brings at scale performance to the modern data warehouse. Alongside, PDW we'll look at cloud offerings that bring additional scale to data warehouses and how to build, with minimal, data platforms that deliver unlimited performance.

Jason Strate Jason Strate

The Modern DBA – Infrastructure, SQL and Performance in the Cloud

Instructor: Jason Strate

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

Today's data platform extends beyond the limitations of brick and mortar data centers. With cloud offerings, you have the ability to grow past your current hardware limitations and deliver data solutions that grow and move with your data needs. In this session, we'll explore cloud offerings for your data platforms and how the support the needs of DBA to provide the infrastructure and performance that data platforms demand.

Bradley Ball Bradley Ball

Managing Today’s Cloud Integrated Data Platforms

Instructor: Bradley Ball

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

As a DBA you’ve been inundated by people telling you why you “need” the cloud. Need is great, but HOW do you integrate your Network with Azure? What are Virtual Networks in Azure? How does this differ from On-prem? How can you use PowerShell to provision and Manage Azure VM’s? You can create Networks, set up SQL Servers, spin-up and shut down infrastructure so you are not charged for anything other than storage? In this session we’ll stop talking about why you “need” the cloud and start talking about HOW you leverage it!

James Serra James Serra

Modern Data Warehousing

Instructor: James Serra

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

The traditional data warehouse has served us well for many years, but new trends are causing it to break in four different ways: data growth, fast query expectations from users, non-relational/unstructured data, and cloud-born data. How can you prevent this from happening? Enter the modern data warehouse, which is able to handle and excel with these new trends. It handles all types of data (Hadoop), provides a way to easily interface with all these types of data (PolyBase), and can handle “big data” and provide fast queries. Is there one appliance that can support this modern data warehouse? Yes! It is the Parallel Data Warehouse (PDW) from Microsoft, which is a Massively Parallel Processing (MPP) appliance that has been recently updated (v2 AU1). In this session I will dig into the details of the modern data warehouse and PDW. I will give an overview of the PDW hardware and software architecture, identify what makes PDW different, and demonstrate the increased performance. In addition I will discuss how Hadoop, HDInsight, and PolyBase fit into this new modern data warehouse

Julie Koesmarno Julie Koesmarno

Building Your Myth Busting Lab With Power BI

Instructor: Julie Koesmarno

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

Myth busting involves gathering facts, modelling data for repeatable usage and/or testing, exploring data captured, proofing a few theories, coming up with "what-ifs" and making a well informed conclusion. This session will demonstrate how to create an ideal Myth Busting lab for all these aspects and for team collaboration in one suite. You will learn best practices on delivering self service and mobile Business Intelligence solutions with Power BI for Office 365 for enterprises, its limitations and winning features.

Jason Strate Jason Strate

5 SQL Server Indexing Myths

Instructor: Jason Strate

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

There are many "best practices" around that help people decide how to index databases. Having these practices can help alleviate the time that it takes to design an indexing strategy for a database. These practices can be of great use, except when they are wrong. Join us in this session, as we discuss some common myths associated with indexes and then dive into the myths to demonstrate how they can be debunked. At the end of the session, you'll know a few more things about indexes and leave armed with scripts that can help you debunk these myths on your own.

Chris Price Chris Price

SQL Server Data Mining & Application Integration

Instructor: Chris Price

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

While there has been a renewed emphasis on data mining and machine learning, the data mining capabilities within SQL Server Analysis Services remains one of the most overlooked and underutilized parts of the platform. In this session we will introduce data mining and the algorithms that are available out of the box with SQL Server Analysis Services 2012. We will explore a generic data mining methodology while learning how these models are developed, evaluated and ultimately implemented to deliver enhanced capabilities and data understanding. This session includes end-to-end demos as well as real-world integration scenarios.

Bradley Schacht Bradley Schacht

Parameters and Variables in SSIS

Instructor: Bradley Schacht

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

SQL Server Integration Services (SSIS) went through a major transformation in the 2012 release. It’s been well over a year since the 2012 release and SQL Server 2014 is right around the corner which means organizations will be adopting the new project deployment at a much faster rate. We will discuss the difference between the former package deployment and new project deployment models, variables vs. parameters, deployment to the new SSIS catalog and how to configure environments. After this session you will have all the information necessary to move to the latest version of SSIS or even upgrade your existing environment.

Bradley Ball Bradley Ball

SQL Server 2014: Top New Features!

Instructor: Bradley Ball

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

Microsoft has announced SQL Server 2014. It should be RTM very soon. When will it be? What are the features that you need to know about? In this presentation we will cover the Top NEW Features. It’s never too early to think about Migrating? What are the things that you will need to consider? How they will this impact your life as a DBA, your Data Warehouse, Your Virtual Environment, and how you use the Cloud!

Robert Cain Robert Cain

What's New in PowerShell v3... and 4!

Instructor: Robert Cain

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

PowerShell v3 was a massive new release. With literally thousands of new cmdlets and a new ISE, where do you start? In this session we'll begin with an overview of the feature sets included with v3, plus the new ISE. Then we'll look at some of the new language features, such as the simplified Where-Object, append capabilities for Export-CSV, dynamically updatable help, default parameters, and more. Then we'll take a deeper look at the feature everyone is drooling over, Workflows. You'll see how to implement a workflow and how to use it to run tasks in parallel.

Shawn Harrison Shawn Harrison

SSIS: Covering all the Basics

Instructor: Shawn Harrison

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

SSIS is a powerful ETL tool for moving and manipulating data. In this one hour session, Shawn will provide an in-depth introduction to SSIS, covering all the basics you will need in order to get started. This session is great for those that have not yet familiarized themselves with SSIS.

Jason Strate Jason Strate

Leveraging Cloud for the Modern SQL Developer

Instructor: Jason Strate

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

In the past, developing a database was a simple affair where you built and deployed the database for a server down the hall in your datacenter, or in some cases to a server under someone's desk. While those good ole days were a much more simple time, they were quite limiting in how a database could be deployed and there were much fewer options for ensuring stability and performance. Today, SQL Developers have many more options for deployment including the services provided through Windows Azure. In this session, we'll dive into what you need to know to start developing databases with Windows Azure and discuss the value that cloud delivery can provide to your database development.

Mike Davis Mike Davis

BI Scale on Demand – Implementing BI in the cloud

Instructor: Mike Davis

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

In this session you will learn how to gallery images for running Business Intelligence in Windows Azure Virtual Machines. How to use SQL Server Analysis Services and Reporting Services in your own Azure BI environment is covered and deployment to Azure.

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