February Free Training Schedule

SSIS Performance Tuning Tips & Tricks

Tuesday, February 3rd at 11 a.m.

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.

Using BI Techniques for Database Statistics

Thursday, February 5th at 11 a.m.

In this session, we'll look at using BI techniques to track and report on Database metrics for the DBA. Using real work stats like database growth, stored procedure cache stats, and server wait stats, we'll look at how to store this data for analysis and consume it using PowerPivot. 

An Introduction to Data Quality Services (Part 1)

Tuesday February 10th at 11 a.m.

Data Quality Services (DQS) is a powerful feature new to SQL Server 2012 that will allow you to clean and standardized your data.  This webinar will cover the overview and installation of DQS along with some real-world examples utilizing the basic features of DQS.

Indexing Internals for Developers & DBAs

Thursday, Febraury 12th at 11 a.m.

What are the secrets to making your queries run faster?  Why does SQL Server use an index for some queries and not for others?  What makes a good index?  How many indexes should I have?  Have you ever asked these questions? Together we will discuss how the application architecture of SQL Server works.

PowerShell for the DBA

Tuesday, February 17th at 11 a.m.

One goal of a DBA is to automate gathering information such as the specifications of all of your SQL Servers. In this session we will show you how you can use PowerShell to go through a list of servers and grab information like the processor specs, check if the machine is a virtual image, memory size, SQL version, etc.

Using the Power BI Designer Preview

Thursday, February 19th at 11 a.m.

Building an Effective Data Warehouse Architecture with Hadoop, Cloud & MPP

Tuesday, February 24th at 11 a.m.

As a follow-on to the presentation “Building an Effective Data Warehouse Architecture”, this presentation will discuss how Hadoop, the cloud and massively parallel processing (MPP) is changing the way data warehouses are being built. 

Intro to SSIS: Building Your First Package

Thursday, February 26th at 11 a.m.

For those who have never worked with SSIS it can look quite daunting at first but in this webinar we are going to take the time to break down some of the basics. SSIS is a very robust tool for your ETL development and eventually with enough practice and experience you can take advantage of the more advanced items.