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
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.

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.

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.

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?

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.

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.

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.

Bradley Schacht Bradley Schacht

SSIS Performance Tuning Techniques

Instructor: Bradley Schacht

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!

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.

Devin Knight Devin Knight

Tips and Tricks for Planning a Data Warehouse

Instructor: Devin Knight

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

You’re about to begin a Data Warehouse project but you don’t know where to start. Planning the design of a Data Warehouse can be a daunting task and overall these projects have a low success rate. Join Devin to learn tips and tricks for planning the design of a data warehouse as well as walk through the actual implementation of dimensional model.

Michael Reed Michael Reed

Big Data- Part 3 of 3- Applying Big Data Analytics to Business Decisions

Instructor: Michael Reed

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

In this hour I will discuss scenarios for applying analytics to business decision making with a focus on determining the questions to ask of your data, the problems it can solve, and the value it can bring to your enterprise. This is part three in a three part series which has taken you from setting up your environment to basic analytics to applying analytics to business decision making.

Devin Knight Devin Knight

Power BI Q&A Phrasing and Synonyms

Instructor: Devin Knight

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

Power BI Q&A is one of the hottest new BI features that allow users the ability to interrogate data. Users can now interact with their data just like they would with a typical search engine (Bing, Google, etc…). This new functionality is amazing but it gets better. You can now enhance the way Q&A returns results based on the way your users really ask questions. This can be done through the features called Phrasing and Synonyms, which this session is devoted to helping you understand.

Mark Vaillancourt Mark Vaillancourt

Analysis Services Terms and Concepts for the DBA

Instructor: Mark Vaillancourt

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

Despite some overlapping concepts, the worlds of the Relational engine and Analysis Services really are quite different. With more and more organizations realizing the power of Analytics, there is a good chance a BI initiative will come your way at some point. This session is intended for the DBA that wants/needs to learn more about SQL Server Analysis Services. The goal is to provide a meaningful base of knowledge that will allow you to effectively participate in discussions of Analysis Services in your organization.

Brian Knight Brian Knight

Creating Actionable Intelligence with Power Query

Instructor: Brian Knight

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

Learn how to make BI really work for you with Power Query in Excel. In this session, you’ll see how to make business intelligence truly actionable for your end users by mashing data together that might seem unrelated at first. You’ll find out how to use the Power Query platform to take data from tables in websites and mash it with data in proper relational databases. Then, see how to present the data to end users with Power BI.

Tyrone Brown Tyrone Brown

SSIS Tips to Improve Performance Part 2

Instructor: Tyrone Brown

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

In my previous SSIS performance webinar I covered some of the basic SSIS performance tuning topics (Source and destination settings, blocking and non-blocking transformations and buffer sizes). In this session I will cover some of the more advanced performance tuning topics that often get over looked or ignored. This session is intended for intermediate or advanced users of SSIS.

Josh Luedeman Josh Luedeman

Big Data Tools

Instructor: Josh Luedeman

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

Congratulations. You've setup your Big Data environment with all the fun toys. You have Pig, Sqoop, and Hive all on your Hadoop cluster. You even got your data flowing in there properly. Now what? In this session we're gonna go over Data Mining tools to help you gain some insight from your data. Then, to bring it all together, we'll go over some easy ways to use common tools to show off all of this Big Data of yours, using tools that most have access to.

Dustin Ryan Dustin Ryan

Navigating Hierarchies With MDX

Instructor: Dustin Ryan

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

One of the great strengths of SQL Server Analysis Services is the ability to create hierarchies by defining relationships between attribute fields. In this webinar, we’ll take a look at how we can fully leverage our SSAS hierarchies in our MDX queries and calculated measures using navigational functions such as PARENT, DESCENDANTS, PARALLELPERIOD, and many more!

Bradley Schacht Bradley Schacht

SSRS Subscriptions and Data Alerts

Instructor: Bradley Schacht

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

SQL Server Reporting Services is a powerful and highly customizable tools in the Microsoft BI stack but users don’t have to visit a web page to view reports. Subscriptions are an amazing feature often overlooked and under-utilized in SSRS. In this session Bradley will guide you through setting up subscriptions, data-driven subscriptions and the new data alerts available starting in SQL Server 2012. In addition to demonstrating how to automate delivery of SSRS reports you will learn how to use a subscription to pre-cache reports so performance is at its best when your users log on first thing in the morning! This is a session you can take back and use immediately in your environment!

Ginger Grant Ginger Grant

Introduction to Hadoop

Instructor: Ginger Grant

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

Everywhere you turn in the technological literature people are talking and writing about Big Data. In this presentation you will learn about the origins of Hadoop, and how it is implemented today. In addition to the most infamous way of retrieving data from Hadoop, Map Reduce, other tools for accessing the data will be discussed.

Robert Cain Robert Cain

Installing and Configuring SQL Server Reporting Services

Instructor: Robert Cain

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

Reporting Services has become the backbone of information distribution for many businesses. It's vital then you have a good understanding of the configuration manager, as the choices you make here can affect your entire reporting infrastructure. Topics such as Scale-Out deployments, encryption keys, and service accounts will be covered. In addition we'll take a deep dive into the Report Manager. You'll see how security affects the management of reports, how to schedule reports to run automatically, and how to use data driven subscriptions to effectively meet the needs of multiple users without the overhead of multiple reports. Finally, you'll see how to use both report snapshots and the report cache to minimize the impact on your data servers, return reports faster, and create an audit trail when needed.

Ronald Dameron Ronald Dameron

SQL Server Security Easy Button

Instructor: Ronald Dameron

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

If you work in an organization that is finding it increasingly difficult to allow SQL Server DBAs 24x7x365 sysadmin access to your Production servers, then I think you will find this session very interesting. Attendees will learn how to define a permission set with a single script that allows database administrators to do routine work without sysadmin permission and how to elevate permissions quickly to respond to production emergencies. Attendees will leave this session with a complete script that provides the minimum necessary access database administrators require to maintain the database server without granting access to business data. In addition, I’ll talk about our real world experience with reduced permissions.

Wendy Pastrick Wendy Pastrick

Isolation Levels and Concurrency

Instructor: Wendy Pastrick

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

Issue a "SELECT {data} FROM {myTable}" statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time by reviewing locking and lock escalation.

Anthony Martin Anthony Martin

Scaling Self-Service BI Solutions

Instructor: Anthony Martin

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

Building BI solutions with Power Pivot is an excellent option for technical resources to quickly build out proof of concept solutions or for business users to self-serve their analytical needs without waiting for technical resources for assistance. This session will review options to scale Power Pivot solutions that have become critical to the organization and need to scale to increasing amounts of data and users. Power Pivot for SharePoint, Analysis Services Tabular, and O365 Power BI will be reviewed and demoed to understand what they can bring to the table to increase scalability.

Gareth Swanepoel Gareth Swanepoel

A Practical Guide to Windows Azure SQL Database for the DBA

Instructor: Gareth Swanepoel

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

If you are a production DBA and have contemplated what Windows Azure SQL Database is, then this session is for you! I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure.

Alan Faulkner Alan Faulkner

SSAS Best Practices

Instructor: Alan Faulkner

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

A journey through best practices in relation to scalable SQL Server Analysis Services cube design. From dimension design to SSAS engine internals we will explore SSAS multidimensional design patterns that will take you through steps to assist in getting your SSAS cubes better optimized to better match the needs of your organization. After this session you will be able to take these performance design patterns and apply them to new and existing cubes to tune your SSAS cube environment.

Copyright 2014 by Pragmatic Works