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

Bradley Schacht Bradley Schacht

Monitoring Performance of the BI Stack

Instructor: Bradley Schacht

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

Performance tuning the Microsoft BI stack is a daunting task. It’s even more difficult when you don’t know where to look. Without being able to properly monitor performance metrics of your SSIS package and SSAS cubes it’s impossible to be able to determine where to start tuning. There are a few great tools at our disposal for diagnosing a problem’s source including Performance Monitor (Perf Mon) and running traces (or extended events). In this session Bradley will walk you through how to use these tools to monitor the performance of SSIS and SSAS to determine whether things like memory or disk are the problem or if the server is fine and you just need to redesign!

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.

James Phillips James Phillips

SSIS Performance Tuning Tips and Tricks

Instructor: James Phillips

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

So you have developed SSIS packages and your now banging your head against the wall on how to get the performance increased. Stop by this session and I will share some of my tips and tricks on how to properly set the Buffer size and engine threads, as well as go over how threading in SSIS works. I will also share with you some common mistakes that are made when picking the wrong source or destination driver and some helpful components you can use to reduce the number of operations and get your packages on the right track.

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.

Jason Strate Jason Strate

Introduction to Parallel Data Warehouse Distribution Theory

Instructor: Jason Strate

Date/Time: 10/30/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. * Outline each of the rules for PDW's distribution theory * Provide an understanding of the rules and how they affect query execution * Demonstrate how the rules effect data distribution

Copyright 2014 by Pragmatic Works