JumpStartTV.com - All channel

Using a Basic Data Flow Task in SSIS

Brian Knight — 8/22/2008

In this video, Brian shows how to use SSIS to make a simple transformation occur of your data. He aggregates and sorts the data before writing the data to a flat file. After you watch this video, you will know how to use the Data Flow task inside of SQL Server 2005 SSIS.

Using Checkpoints in SSIS

Brian Knight — 9/26/2008

SQL Server Integration Services checkpoints enable you to start a package from where it failed. This helps you avoid having to re-run a 6 hour package over again. Learn how to use this valuable feature with this quick how-to video.

Using a Script Transform in SSIS

Brian Knight — 8/25/2008

In SSIS, the data you receive from the source is rarely in the format your end users would like to see. To correct this, you can use the Script Component to transform data. In this demo, Brian shows you how to use the Script transform to make a column proper case in the data flow.

Speak Like a SSIS Developer

Brian Knight — 8/28/2008

In this first video of the series, you'll learn what SQL Server Integration Services does and a little about the environment. After you see this video you should be able to understand much of the terminology and toolset that SSIS developers use.

Creating a Basic SSAS Cube

Brian Knight — 9/22/2008

In this demonstration, you'll quickly learn how to create a basic cube using the Cube Wizard upon a data warehouse. Brian walks through the entire process in this 10 minute video to get you started with creating a browsing a cube.

Using Database DDL Triggers

Brian Knight — 9/19/2008

In this short demonstration, you'll learn how to use DDL database triggers to prevent changes to product and audit changes to comply with Sarbanes-Oxley and other change management requirements.

Introduction to Data Warehousing Part 1

Wes Dumey — 9/9/2008

In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.

Introduction to Data Warehousing Part 2 - DW Tables

Wes Dumey — 8/18/2008

In Part 2 of this series, Wes Dumey talks about some of the key tables in a data warehousing scenario. He covers fact tables, dimensions and some of the other tables you'll see in a data warehouse.

Introduction to Data Warehousing Part 3 - ETL

Wes Dumey — 9/3/2008

In part 3 of this series, Wes provides an overview of some common processes to load data into your data warehouse could be. He also covers some of the common issues with cleansing of your data.

Using the Fuzzy Lookup Transform

Brian Knight — 9/5/2008

In this video, you'll see how to use the SQL Server Integration Services Fuzzy Lookup Transform to match data that may've been mistyped. Use this transform to stop data duplication.

Maintaining SQL Server 2005 Databases - Backups

Brian Knight — 9/1/2008

In this presentation for SQL Server newbies, you'll learn how to maintain your SQL Server databases by backing them up regularly and reindexing them. This topic assumes you know nothing about SQL Server and also covers some of the decisions you'll have to make when you decide you want to backup your database through maintenance plans.

Automating SQL Express Backups

Brian Knight — 8/27/2008

SQL Express has no mechanism to schedule backups and maintenance of your instance. In this video, Brian shows you how to automate and schedule backups of SQL Express with a simple scripted solution.

Windows and SQL Server 2005 Clustering Architecture

Brian Knight — 9/12/2008

Before you start learning how to cluster, this video will show you the basics on how clustering in Windows 2003 and SQL Server 2005 works. Brian shows the basic architecture on clustering as well as the checklist that you would want to follow before starting to cluster.

Clustering Windows 2003 R2

Brian Knight — 9/11/2008

In this presentation, you'll learn step-by-step how to cluster Windows 2003 R2. Brian shows you how to configure and cluster a two node cluster, preparing it for any future services like SQL Server or Exchange.

Clustering SQL Server 2005

Brian Knight — 10/3/2008

With Windows 2003 now clustered, you're ready to begin to clustering SQL Server 2005. In this presentation, you'll see how to cluster SQL Server 2005 and some best practices in how to configure the SQL Server cluster after the fact.

Looping Through and Loading Files with SSIS

Brian Knight — 9/24/2008

In this presentation, you'll learn how to use the ForEach Loop Container to loop through a folder and load each file in the directory. This presentation uses variables to dynamically configure the package so nothing is hard coded.

Using the For Each ADO Enumerator

Brian Knight — 8/15/2008

In this video, you'll learn how to use the For Each ADO enumerator to loop through a table and reconfigure the package based on the rows in the table. You can use this type of example to store meta data about your client and reconfigure the package for each client dynamically.

Using Transactions in SSIS

Brian Knight — 9/4/2008

In SSIS demonstration, you can wrap a package or container in a MS DTC transaction. This type of transaction ensures that if a problem occurs in a package, your data can roll back to a prior state.

Using SQL Server 2005 Database Snapshots

Brian Knight — 8/19/2008

In this presentation, Brian shows you how you can use database snapshots for data protection. He shows you how to create a snapshot, read from it and lastly how to do a database recovery from the snapshot.

BI MetaData Toolkit Quickstart

Brian Knight — 8/21/2008

As you grow the amount of SSIS packages and cubes in your environment, you will need to track how the data arrived into the cubes and what the impact of you changing a column will be. The BI Metadata Toolkit is a free toolkit from Microsoft that helps you manage your metadata and helps you generate impact and lineage reports quickly and easily.

Running and Scheduling SSIS Packages

Brian Knight — 10/8/2008

In this presentation, Brian shows you how to run a SSIS package outside the designer environment using DTExec.exe and DTExecUI.exe. He also shows you how to schedule an SSIS package using SQL Server Agent.

Using Excel 2007 with Analysis Services

Brian Knight — 10/10/2008

In this presentation, you'll see how you can use Excel 2007 to view data and create quick reports against data in Analysis Services. Then, you'll see how to conditionally format the data and apply rules to the data.

Introduction to the SQL Server 2005 Tools

Brian Knight — 10/13/2008

In this video, Brian shows you a high-level introduction for SQL Server newbies to the SQL Server tools. He explains what the purpose of each tool is before going into more details in the next videos.

Introduction to SQL Server Management Studio

Brian Knight — 8/20/2008

SQL Server Management Studio is used to manage, query and design SQL Server solutions. In this video you're shown the basics of how to use Management Studio.

Using SQL Server 2005 Profiler

Brian Knight — 9/8/2008

In this presentation, Brian introduces SQL Server 2005 Profiler. He shows you to integrate System Monitor logs (also called perfmon) to find what queries were running against your machine during key performance failures. He also shows you how to output the query plan into an XML file.

Spotlight: Overview of SQL Sentry

Steve Wright — 8/14/2008

Get an overview of SQL Sentry, the tool that makes it easy to watch and schedule jobs inside SQL Server. SQL Sentry gives you an "Outlook-style" job panel for SQL Server and allows you to views your entire SQL Server job environment in one centralized panel.

Introduction to SQL Sentry Notifications

Steve Wright — 9/10/2008

In this video, you'll learn how job notifications are handled with SQL Sentry and how to set up job alerts. SQL Sentry offers a comprehensive way to send out alerts and chaining of jobs.

Managing the SSIS Service

Brian Knight — 8/26/2008

In this video, Brian discusses the role of the SSIS service and how it is configured. He also talks about how to create a central ETL server to handle all of your SSIS ETL.

Overview and Installing SQL Server 2005 SP2

Brian Knight — 8/29/2008

In this presentation Brian shows you some of the new features in SQL Server 2005 SP2. Then, he demos briefly how to install SP2 and some of the small quirks around the installation.

Change Data Capture with SSIS

Brian Knight — 9/29/2008

In this presentation, Brian Knight shows you how to use canned SSIS components to detect data changes in a source table and only load new or conditionally update changed records. He shows you two methods: one using the OLE DB command and another using a set based operation and demostrates you the performance differences between the two.

Applied Fuzzy Lookup

Ira Whiteside — 9/15/2008

In this session, Ira shows you how to use the Fuzzy Lookup transform in Integration Services to help create a hierarchy in SSAS. In this detailed example with code, he shows you how to comb through bad data using the Fuzzy Lookup and find vague matches to your data no matter what the application for the data.

Hacking SQL Server

Brian Knight — 8/8/2008

In this presentation at the Jacksonville SQL Server Users Group, Bayer White playS the part of a developer protecting his application and Brian Knight attempts to hack his application using SQL Injection and cross-site scripting. Then, Bayer will show you how to protect yourself from the hacker and then Brian tries again. Back and forth the chess match goes until someone wins!

Adding a Signature to Outlook 2007 Emails

Brian Knight — 10/17/2008

In this quick tip video, Brian Knight shows you how to add email signatures to Outlook 2007. Email signatures will save you time from having to type the same signature over and over again.

Creating a Proxy Account

Brian Knight — 8/11/2008

In this session by Brian Knight, he shows you how to create a proxy account for SQL Server Agent to use. Proxy accounts and SQL Server 2005 credentials help you impersonate another Windows account in Agent.

SSIS Control Flow Basics

Brian Knight — 8/12/2008

In this session, Brian shows you the basics of the SQL Server Integration Services Control Flow. He shows you how to orchestrate a package in the control flow with precedence constraints and how they relate tasks together in the control flow and how to tasks are executed and in what order. He also shows some of the advanced properties of the control flow that help with parallelism.

SSIS Configurations

Brian Knight — 9/2/2008

In this session, Brian shows you how to use configuration files or a configuration file to dynamically configure your packages. With configuration files, you can seamlessly migrate an SSIS package from QA to production without worry and without having to reconfigure the package.

Ignoring a SSIS Checkpoint

Jamie Thomson — 8/13/2008

One thing that people typically want to do is always execute a particular task regardless of whether a checkpoint file exists or not. In this video, Jamie shows you how to create a package that can conditionally skip a checkpoint if it's in place.

SSIS Stumpers V1 - Unpivot Example

Brian Knight — 8/6/2008

In this series, Brian Knight shows you an actual difficult business problem to solve, gives you hints about how to solve it and then lastly shows you step-by-step instructions how to solve it if you want the help. You can download the sample code for this at http://www.endtoendtraining.com/private/misc/downloads.aspx. In this video of the series, Brian shows you how to unpivot data that may arrive from the mainframe and load a many to many table with SSIS.

SSIS Stumpers V1 - Unpivot Example

Brian Knight — 8/6/2008

SSIS Stumpers V1 - Unpivot Example

Brian Knight — 10/1/2008

Tictac

Sean Richardson — 8/6/2008

This drink is similar to a Jagerbomb. Watch Sean mix this drink to perfection.

Modifying Data in T-SQL

Kathi Kellenberger — 1/14/2008

In this video, Kathi continues her beginner series on T-SQL where she now shows you how to modify data in SQL Server using the DELETE, UPDATE or INSERT statement. If you're new to T-SQl, this video is perfect for you to quickly ramp up your skills.

Object Dependencies in SQL Server

Randy Dyess — 1/14/2008

In this video, Randy Dyess shows you how important SQL Server dependencies are and some of the faults with SQL Server 2005 with these. For example, SQL Server will allow you to create a stored procedure that points to a table that doesn't exist. He also shows you how this problem has been corrected in SQL Server 2008.

XML Execution Plans

Grant Fitchey — 10/6/2008

In this video you will learn what XML Execution Plans are and why they are useful.

Text Query Plans

Grant Fitchey — 9/16/2008

In this video you will learn how to get a text version of an execution plan.

SQL Server Table Scans

Grant Fitchey — 9/23/2008

This video explain what a table scan is in your query plan

Saving a query plan

Grant Fitchey — 9/30/2008

In this video you will learn how to save an execution plan.

What is a Merge Join Operator?

Grant Fitchey — 10/16/2008

This this video you will learn what a merge join operator is when you see one in an execution plan.

What is an index scan?

Grant Fitchey — 10/7/2008

This video explains what an index scan is when looking at a query plan.

Generating an execution plan

Grant Fitchey — 10/27/2008

This video explains how to generate an execution plan when working with SQL Server.

What is a Hash Match Join Operator?

Grant Fitchey — 11/12/2008

This video explains what a hash match join is when looking at a query plan.

What is a clustered index scan?

Grant Fitchey — 10/21/2008

This video explains what a clustered index scan is when looking at a query plan.

What is a clustered index seek?

Grant Fitchey — 10/30/2008

This video explains what a clustered index seek is when looking at a query plan.

Uploading an execution plan to sqlservercentral.com

Grant Fitchey — 11/20/2008

Sometimes you'll need more help than you have available at your place of employment. This is where the experts on the SQLServerCentral.com forums can help. Sometimes they will ask to upload the execution plan of a problem query. This video explain how to save an execution plan and upload it to sqlservercentral.com to get some help from other DBA's.

Left Join Operators

Grant Fitchey — 11/6/2008

This video explains what a left join operator is when looking at a query plan.

What is an Identity Gap?

Grant Fitchey — 10/23/2008

This video explains what an Identity Gap is.

Backing up your database with SMO

Tim Mitchell — 10/2/2008

This video shows you how to backup your database using SMO.

Capture schema changes with SMO

Tim Mitchell — 9/17/2008

This video show you how to collect schema changes made to your database using SMO

Connecting to a SQL Server Database with SMO

Tim Mitchell — 9/25/2008

This video shows you how to use SMO to connect to a sql server database.

Creating a database with SMO

Tim Mitchell — 9/18/2008

This video shows you how to create a new database using SMO

Create database objects with SMO

Tim Mitchell — 10/20/2008

This video shows you how to create database objects (tables, stored procedures, etc) using SMO.

Create SQL Server Logins with SMO

Tim Mitchell — 10/31/2008

This video show you how to create SQL Server logins with SMO

Generating SQL Server scripts using SMO

Tim Mitchell — 11/14/2008

This video show you how to generate SQL Server scripts using SMO

Viewing SQL Server Indexes using SMO

Tim Mitchell — 10/28/2008

In this video you will learn how to view the indexes in a sql server database using SMO

Executing SQL Server Scripts using SMO

Tim Mitchell — 10/9/2008

This video shows you how to execute sql server scripts using SMO.

Reading the SQL Server Error Log with SMO

Tim Mitchell — 11/3/2008

This video shows you how to read the SQL Server error log using SMO

Shrinking the transaction log with SMO

Tim Mitchell — 10/22/2008

This videos shows you how to shrink the transaction log of a database using SMO.

Creating a new trace with SQL Server 2005 Profiler

Jack Corbett — 10/29/2008

This video will take you through creating a new trace in sql server 2005 profiler.

Extracting T-SQL events from SQL Server Profiler

Jack Corbett — 11/7/2008

This video shows you how to extract the T-SQL events that occurs during in a trace using sql server 2005 profiler

Saving a SQL Server Profiler Trace

Jack Corbett — 11/5/2008

This video shows you how to save a sql server profiler trace and reuse it at a later time.

Reusing a saved SQL Server Profiler trace

Jack Corbett — 11/17/2008

This video shows you what options are available when reusing a saved trace in SQL Server Profiler

Integrating Performance Monitors with SQL Server Profiler

Jack Corbett — 10/15/2008

This video show you how to integrate windows performance monitors with sql server 2005 profiler. Be sure to see Jack's video on how to create windows performance monitors.

SQL Server 2005 / 2008 XML Data Type

Kendal Van Dyke — 10/14/2008

This video explains the XML data type in SQL Server 2005 / 2008

Using FOR XML with SQL Server

Kendal Van Dyke — 10/24/2008

This video shows you how to use the FOR XML clause to format the results of a SQL Server query in several XML formats

Quickly creating XML Schemas in SQL Server 2005 / 2008

Kendal Van Dyke — 11/18/2008

Creating XML schemas in SQl Server 2005 / 2008 can be a tedious process. This video shows you how to quickly create an XML schema in SQL Server 2005 / 2008

Creating Primary Indexes on XML Data Types in SQL Server

Kendal Van Dyke — 11/4/2008

This video show you how to create primary indexes on xml data types in SQL Server 2005 / 2008

Row Concatenation Using FOR XML PATH

Plamen Ratchev — 11/10/2008

One of the most requested T-SQL statements is the ability to combine a number of records in one line concatenated together. This video shows you how to accomplish this with FOR XML PATH

Shredding XML elements with the XQuery Query function

Plamen Ratchev — 11/13/2008

Parsing XML inside SQL Server scripts is becoming more popular. This video shows you how to shred element based XML with the Query function.

Installing SQL Server Full Text Search

Robert Cain — 11/11/2008

Full text search provides the ability to search documents and text within SQL Server. This video shows you how to install full text search and some of the caveats that go along with installation.

Querying full text indexes using the FreeText method

Robert Cain — 11/19/2008

Full text search provides the ability to search documents and text within SQL Server. There are several ways to query full text indexes. This video shows you how to use the FreeText method to query your full text indexes.