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

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.

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.

Steve Goranson Steve Goranson

Billionaire in Training - The 5 Levels of an Entrepreneur

Instructor: Steve Goranson

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

There are so many different ways to make it in business – so many different ways through which you can reap the rewards of entrepreneurial success. Yet very few people learn what it takes, and for some strange reason, fewer still will ever use what they've learned. This workshop will take a look at the nuances that it takes to become a successful entrepreneur.

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.

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.

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.

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.

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!

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.

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.

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.

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.

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

Rowland Gosling Rowland Gosling

Create a Tactical Plan Using Hadoop and Cloud Technologies

Instructor: Rowland Gosling

Date/Time: 5/27/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.

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!

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.

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.

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.

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.

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.

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.

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.

Copyright 2014 by Pragmatic Works