Thursday, October 30, 2008

New SQL Server Video Tutorial: Part 4 - Versions, Editions, Licen sing, and Pricing

Part 4 - Versions, Editions, Licensing, and Pricing - view details
This fourth video in the series, a longer video than normal, will discuss the three different versions, various editions, multiple licensing options and pricing ranges for SQL Server.

Highlights from this video:
  • History and functionalities of SQL Versions
    • 2000
      • SSRS
      • Clustering and log shipping
    • 2005
      • SSIS
      • CLR
    • 2008
      • New datatypes
      • XML integration
  • About the SQL Server Editions: Audience annd Highlights
    • Express
    • Workgroup
    • Standard
    • Enterprise and Developer
  • Pricing for the various editions
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, server, edition, license, price, version, technical, overview, intro , introduction, step by step, beginner, beginning, for

posted by Scott Whigham @ 2:34 PM  

New SQL Server Video Tutorial: Part 1 - A Technical Overview of S QL Server: What Is SQL Server?

Part 1 - A Technical Overview of SQL Server: What Is SQL Server? - view details
If you have little to��no prior knowledge about database servers and��are��looking to learn about SQL Server then you've found the right video series! In this first video in the series your instructor, Scott Whigham, will introduce you to the concepts behind��Microsoft SQL Server. You will learn the first of three basic W's of SQL Server: what is it, who uses it, what��it does.��

This video series is great for those of you who are looking for a great intro technical overview of SQL Server.

Highlights from this video:

  • Acronyms to know
    • DBMS
    • SQL
    • MSFT
  • What is SQL Server?
    • Database server
    • Other products that ship with SQL
      • SSAS
      • SSRS
      • SSIS
    • History of SQL Server versions
  • SQL Server = RDBMS
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, server, introduction, intro, overview, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:34 PM  

New SQL Server Video Tutorial: Part 2 - What Can I Do With SQL Se rver, Analysis Services, Reporting Services, and Integration Services?

Part 2 - What Can I Do With SQL Server, Analysis Services, Reporting Services, and Integration Services? - view details
This second video in our technical overview of Microsoft SQL Server will continue by answering the question: What can I do with SQL Server? The instructor will outline the various functions of the SQL Server products (SSRS, SSAS, SSIS) as well as the Database Server itself.

The author's presentation notes��are included with your download!

Highlights from this video:

  • What can I do with the:
    • Database Server
    • Analysis Services
      • About multidimensional data
    • Reporting Services
      • Report generation and viewing
    • Integration Services
      • ETL tool
      • About sources and destinations
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, server, intro, overview, ssas, ssrs, ssis, integration, analysis, reporting, services, introduction, step by step, beginner

posted by Scott Whigham @ 2:34 PM  

New SQL Server Video Tutorial: Part 5 - A Look at the Hardware Re quirements: CPU, Memory and Hard Drives

Part 5 - A Look at the Hardware Requirements: CPU, Memory and Hard Drives - view details
The main topic of this video is the hardware, such as the CPU, memory, and hard drives,��that is typically used in the SQL Server world.

Highlights from this video:
  • CPU needs
    • How many CPUs do I need to use?
  • Sufficient RAM (memory) for SQL
    • Requirements and "hot set"
    • RAID
      • RAID 0
      • RAID 1
      • RAID 5
      • RAID 1+0
and much more��
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: hardware, requirements, cpu, memory, raid, hard drive, ram, sql, overview, , introduction, step by step, beginner, beginning, fo

posted by Scott Whigham @ 2:34 PM  

New SQL Server Video Tutorial: Part 3 - Who Uses SQL Server, Anal ysis Services, Reporting Services and Integration Services?

Part 3 - Who Uses SQL Server, Analysis Services, Reporting Services and Integration Services? - view details
In the third video in our "Technical Overview of SQL Server" series, we will answer the third question: Who uses it? This video tutorial will discuss the typical users of SQL Server as well as SSAS, SSIS, and SSRS.

Highlights from this video:
  • Who uses the database server?
  • Intro to SQL Server cost
  • SSAS typical users
  • Reporting Services: What types of companies need to do reporting?
    • Is it an alternative to Crystal Reports/Business Objects?
  • Sql Integration Services users
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: ssas, ssis, ssrs, integration, analysis, reporting, user, sql, technical, overview, intro,, introduction, step by step, beginner

posted by Scott Whigham @ 2:34 PM  

New SQL Server Integration Services Video Tutorial: Part 12: A To ur of the SSIS Maintenance Tasks

Part 12: A Tour of the SSIS Maintenance Tasks - view details
This video is the final video is this massive series. You will learn all about the DBA-related SQL Server Maintenance Tasks
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: DBA-related SQL Server Maintenance Tasks, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:34 PM  

New SQL Server Video Tutorial: Part 6 - Operating Systems and Oth er Software Requirements

Part 6 - Operating Systems and Other Software Requirements - view details
In our final video tutorial in the series we will discuss the needs operating systems and the other software requirements for running SQL Server.

Highlights from this video:
  • Windows OS' support
    • XP, Vista, 2000, 2003, 2008, 7
    • Most flexible edition ?
    • Most restrictive edition?
  • Chip architecture and compatibility with various SQL editions
    • X64, X86, IA64
  • Software requirements
    • .NET
  • Disk space requirements
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: operating system, os, software, requirement, overview, sql, windows,, introduction, step by step, beginner, beginning, for dummi

posted by Scott Whigham @ 2:15 PM  

New SQL Server Video Tutorial: Part 5 - A Look at the Hardware Re quirements: CPU, Memory and Hard Drives

Part 5 - A Look at the Hardware Requirements: CPU, Memory and Hard Drives - view details
The main topic of this video is the hardware, such as the CPU, memory, and hard drives,��that is typically used in the SQL Server world.

Highlights from this video:
  • CPU needs
    • How many CPUs do I need to use?
  • Sufficient RAM (memory) for SQL
    • Requirements and "hot set"
    • RAID
      • RAID 0
      • RAID 1
      • RAID 5
      • RAID 1+0
and much more��
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: hardware, requirements, cpu, memory, raid, hard drive, ram, sql, overview, , introduction, step by step, beginner, beginning, fo

posted by Scott Whigham @ 2:15 PM  

New SQL Server Video Tutorial: Part 4 - Versions, Editions, Licen sing, and Pricing

Part 4 - Versions, Editions, Licensing, and Pricing - view details
This fourth video in the series, a longer video than normal, will discuss the three different versions, various editions, multiple licensing options and pricing ranges for SQL Server.

Highlights from this video:
  • History and functionalities of SQL Versions
    • 2000
      • SSRS
      • Clustering and log shipping
    • 2005
      • SSIS
      • CLR
    • 2008
      • New datatypes
      • XML integration
  • About the SQL Server Editions: Audience annd Highlights
    • Express
    • Workgroup
    • Standard
    • Enterprise and Developer
  • Pricing for the various editions
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, server, edition, license, price, version, technical, overview, intro , introduction, step by step, beginner, beginning, for

posted by Scott Whigham @ 2:14 PM  

New SQL Server Video Tutorial: Part 3 - Who Uses SQL Server, Anal ysis Services, Reporting Services and Integration Services?

Part 3 - Who Uses SQL Server, Analysis Services, Reporting Services and Integration Services? - view details
In the third video in our "Technical Overview of SQL Server" series, we will answer the third question: Who uses it? This video tutorial will discuss the typical users of SQL Server as well as SSAS, SSIS, and SSRS.

Highlights from this video:
  • Who uses the database server?
  • Intro to SQL Server cost
  • SSAS typical users
  • Reporting Services: What types of companies need to do reporting?
    • Is it an alternative to Crystal Reports/Business Objects?
  • Sql Integration Services users
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: ssas, ssis, ssrs, integration, analysis, reporting, user, sql, technical, overview, intro,, introduction, step by step, beginner

posted by Scott Whigham @ 2:14 PM  

New SQL Server Video Tutorial: Part 2 - What Can I Do With SQL Se rver, Analysis Services, Reporting Services, and Integration Services?

Part 2 - What Can I Do With SQL Server, Analysis Services, Reporting Services, and Integration Services? - view details
This second video in our technical overview of Microsoft SQL Server will continue by answering the question: What can I do with SQL Server? The instructor will outline the various functions of the SQL Server products (SSRS, SSAS, SSIS) as well as the Database Server itself.

The author's presentation notes��are included with your download!

Highlights from this video:

  • What can I do with the:
    • Database Server
    • Analysis Services
      • About multidimensional data
    • Reporting Services
      • Report generation and viewing
    • Integration Services
      • ETL tool
      • About sources and destinations
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, server, intro, overview, ssas, ssrs, ssis, integration, analysis, reporting, services, introduction, step by step, beginner

posted by Scott Whigham @ 2:14 PM  

New SQL Server Video Tutorial: Part 1 - A Technical Overview of S QL Server: What Is SQL Server?

Part 1 - A Technical Overview of SQL Server: What Is SQL Server? - view details
If you have little to��no prior knowledge about database servers and��are��looking to learn about SQL Server then you've found the right video series! In this first video in the series your instructor, Scott Whigham, will introduce you to the concepts behind��Microsoft SQL Server. You will learn the first of three basic W's of SQL Server: what is it, who uses it, what��it does.��

This video series is great for those of you who are looking for a great intro technical overview of SQL Server.

Highlights from this video:

  • Acronyms to know
    • DBMS
    • SQL
    • MSFT
  • What is SQL Server?
    • Database server
    • Other products that ship with SQL
      • SSAS
      • SSRS
      • SSIS
    • History of SQL Server versions
  • SQL Server = RDBMS
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, server, introduction, intro, overview, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:14 PM  

Friday, October 24, 2008

New SQL Server Integration Services Video Tutorial: Part 1 - The Start of a Long Series: Understanding the Toolbox

Part 1 - The Start of a Long Series: Understanding the Toolbox - view details
In this video series we will take a look at the SSIS toolbox; the part of the Integration Services development environment on the left hand side (for most of you) where you choose the things like the control flow items and maintenance plan tasks. We'll be taking a tour of��all the items on the toolbox while covering three main topics: what it is, who uses it, and what does it do. By the end of this intro series, you will be well positioned to begin working and playing with Integration Services.

In this first video in the series, you will begin by covering essential terminology and wrap up by opening your toolbox in IS.

Highlights from this video:

  • About the Business Intelligence Development Studio
  • Important terminology
    • BIDS
    • BI Studio
    • SSIS
    • IDE
  • BIDS in SQL 2005 and SQL 2008
  • What happens when I create my first project?
    • Designer surface functionality
  • Opening and navigating your Toolbox
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer,, introduction, step by step, beginner, beginning, for dummi

posted by Scott Whigham @ 5:34 AM  

Thursday, October 23, 2008

New SQL Server Integration Services Video Tutorial: Part 11 - The Final Four! Web Service Task, WMI Data Reader Task, WMI Event Watcher Tas k, XML Task

Part 11 - The Final Four! Web Service Task, WMI Data Reader Task, WMI Event Watcher Task, XML Task - view details
This is the last four tasks in the Control Flow items collection. This video is a 'What it is, What it does, and Who Uses It' type of video.

Highlights from this video:
  • SSIS Web Service Task
  • WMI Data Reader Task
  • WMI Event Watcher Task
  • and the XML Task

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: SSIS Web Service Task, WMI Data Reader Task, WMI Event Watcher Task, XML Task, introduction, step by step, beginner, beginning,

posted by Scott Whigham @ 8:34 PM  

New SQL Server Integration Services Video Tutorial: Part 9- Tasks : File System, FTP, Message Queue, and Script

Part 9- Tasks: File System, FTP, Message Queue, and Script - view details
We'll be continuing our tour of the Toolbox in the video tutorial by discussing the File System Task, the FTP Task, the Message Queue Task, and the Script Task.

Highlights from this video:
  • The File System Task
    • Integrating with the file system
  • FTP Task
    • FTP or UNC paths
    • Example scenario
  • Message Queue Task (MSMQ)
  • The Script Task
    • .NET code as standalone task
    • Example usage
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, file system, ftp, message queue, msmq, script, task,, intro

posted by Scott Whigham @ 8:34 PM  

New SQL Server Integration Services Video Tutorial: Part 10 - The DBA Tasks

Part 10 - The DBA Tasks - view details
Continuing our discussion on Control Flow Items in the Toolbar, your instructor will talk about the seven "DBA Tasks" in this video tutorial.

Highlights from this video:
  • The Send Mail Task
    • What it is, what it does, who uses it
  • Transfer Database Task
    • Allows for...?
  • Transfer Error Messages Task
  • Transfer Jobs Task
  • Transfer Logins Task
  • Transfer Master Stored Procedures Task
  • Transfer SQL Server Objects Task
    • DDL objects
    • The most used task

��

and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, dba, database, transfer,, introduction, step by step, begin

posted by Scott Whigham @ 8:34 PM  

New SQL Server Integration Services Video Tutorial: Part 2 - The Various Tabs in the Toolbox; How to Customize the SSIS Toolbox

Part 2 - The Various Tabs in the Toolbox; How to Customize the SSIS Toolbox - view details
In this second video in the series, we will begin our actual tour of the toolbox in BIDS. We will cover the three main expandable sections on the toolbox by answering the questions: Who uses it? What is it? What does it do?

Highlights from this video:
  • Three expandable sections
    • Control Flow Items
    • Maintenance Plan Tasks
    • General
  • Adding new controls to the Toolbox
  • Removing/Resetting controls on the Toolbox
  • Containers��vs Tasks
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer,

posted by Scott Whigham @ 5:34 PM  

New SQL Server Integration Services Video Tutorial: Part 6 - Task s: The Data Flow Task

Part 6 - Tasks: The Data Flow Task - view details
In this video, we will be taking a look at a task that you will more than likely spend a LOT of time working with, the Data Flow Task.

Highlights from this video:
  • The idea of the Data Flow Task
    • Primary ETL task for SSIS
  • Data Flow sources and destinations
  • Common Data Flow Transformations
    • Copy Column
    • Data Conversion
    • Derived Column
    • Union All
  • Bulk Insert Task vs Data Flow Task
    • Which should I use and when?
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, data flow, task, studio, project, designer, , introduction, step by step, beginner, be

posted by Scott Whigham @ 5:34 PM  

New SQL Server Integration Services Video Tutorial: Part 3 - The SSIS Containers: Containers and the Task Host Container

Part 3 - The SSIS Containers: Containers and the Task Host Container - view details
In this video, we will talk about the containers by taking��a quick look at the three containers built into SSIS��as well as detail one that is kind of hidden. But what exactly is a container? The answer to this question and many more will be covered in this video tutorial

Highlights from this video:
  • Container functionality
    • Container logic flow
  • Event-handlers and variables
  • The concept of Scoping
  • Container object: Task host container
    • What it is
    • Who uses it
    • What it does
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, container, development, introduction, step by step, beginne

posted by Scott Whigham @ 5:34 PM  

New SQL Server Integration Services Video Tutorial: Part 7 - Task s: Data Mining Query, Data Profiling, and Execute DTS Package

Part 7 - Tasks: Data Mining Query, Data Profiling, and Execute DTS Package - view details
The Data Mining Query Task, the Data Profiling Task, and the Execute DTS Package Task are the three tasks that will be discussed in this video tutorial.

Highlights from this video:
  • What is the Data Mining Query Task?
  • Data Profiling Task in SQL Server 2008
    • What does it allow me to do?
    • Example usage
    • Demo of working with task
  • Execute DTS 2000 Task
    • Backwards-compatibilty
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, data mining, data profiling, dts, package, task, introducti

posted by Scott Whigham @ 5:34 PM  

New SQL Server Integration Services Video Tutorial: Part 1 - The Start of a Long Series: Understanding the Toolbox

Part 1 - The Start of a Long Series: Understanding the Toolbox - view details
In this video series we will take a look at the SSIS toolbox; the part of the Integration Services development environment on the left hand side (for most of you) where you choose the things like the control flow items and maintenance plan tasks. We'll be taking a tour of��all the items on the toolbox while covering three main topics: what it is, who uses it, and what does it do. By the end of this intro series, you will be well positioned to begin working and playing with Integration Services.

In this first video in the series, you will begin by covering essential terminology and wrap up by opening your toolbox in IS.

Highlights from this video:

  • About the Business Intelligence Development Studio
  • Important terminology
    • BIDS
    • BI Studio
    • SSIS
    • IDE
  • BIDS in SQL 2005 and SQL 2008
  • What happens when I create my first project?
    • Designer surface functionality
  • Opening and navigating your Toolbox
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer,, introduction, step by step, beginner, beginning, for dummi

posted by Scott Whigham @ 5:34 PM  

New SQL Server Integration Services Video Tutorial: Part 5 - Task s: The ActiveX Script Task, Analysis Services Tasks, and the Bulk Insert T asks

Part 5 - Tasks: The ActiveX Script Task, Analysis Services Tasks, and the Bulk Insert Tasks - view details
In this fifth video in our series, we will be taking a tour of the control flow items, more specifically the ActiveX script task, Analysis Services tasks, and the Bulk Insert task.

Highlights from this video:
  • What is it? What does it do? Who uses it?
    • ActiveX Script Task
    • Analysis Services Execute DDL Task
      • Example usage
    • Analysis Services Processing Task
      • Example usage
    • Bulk Insert Task
      • Example usage in Visual Studio
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, task, control flow, bulk insert, activeX, introduction, ste

posted by Scott Whigham @ 5:34 PM  

New SQL Server Integration Services Video Tutorial: Part 8 - Task s: The "Execute" Tasks

Part 8 - Tasks: The "Execute" Tasks - view details
We're going to talk about three tasks in this video tutorial that all fall under one header - the "Execute Tasks". More specifically, the tasks your instructor will discuss are the Execute Package Task, the Execute Process Task, and the Execute SQL Task.

Highlights from this video:
  • The Execute Package Task
    • What is it and why use it?
    • Common usage scenario
  • Execute Process Task
    • Extending SSIS
    • Example usage
  • Execute SQL Task
    • Connection host language
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, execute, package, task, sql, introduction, step by step, be

posted by Scott Whigham @ 5:34 PM  

New SQL Server Integration Services Video Tutorial: Part 4 - The SSIS Containers: For Loop, Foreach Loop, and the Sequence Container

Part 4 - The SSIS Containers: For Loop, Foreach Loop, and the Sequence Container - view details
Continued in this video tutorial is the discussion and overview of the SSIS containers, specifically the For Loop, Foreach Loop, and the Sequence Containers.

Highlights from this video:
  • What is a For Loop Container?
    • Who uses it?
    • What does it allow me to do?
      • Example usage
  • Foreach Loop Container
    • Iterating in a collection
    • Example usage
  • Why use a Sequence Container?
    • Example usuage
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, container, foreach, for , loop, sequence, introduction, ste

posted by Scott Whigham @ 5:34 PM  

New Visual Basic Video Tutorial: Part 8 - Using Regular Expressio ns in Everyday Applications

Part 8 - Using Regular Expressions in Everyday Applications - view details
In this final video in our series, your instructor will demonstrate how to use a text editor to do regular expressions searches. Also in this video, your instructor will expose the uses of regular expressions in everyday applications like Sql Server Management Studio and Visual Studio.

Highlights from this video:
  • Can I use a generic text editor?
  • Regex searches in text editors with "^"
  • Navigating with regular expresssions in SSMS
  • Using the Find feature in VS
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, application,

posted by Scott Whigham @ 5:34 PM  

New SQL Server Integration Services Video Tutorial: Part 12: A To ur of the SSIS Maintenance Tasks

Part 12: A Tour of the SSIS Maintenance Tasks - view details
This video is the final video is this massive series. You will learn all about the DBA-related SQL Server Maintenance Tasks
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: DBA-related SQL Server Maintenance Tasks, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:51 PM  

New SQL Server Integration Services Video Tutorial: Part 10 - The DBA Tasks

Part 10 - The DBA Tasks - view details
Continuing our discussion on Control Flow Items in the Toolbar, your instructor will talk about the seven "DBA Tasks" in this video tutorial.

Highlights from this video:
  • The Send Mail Task
    • What it is, what it does, who uses it
  • Transfer Database Task
    • Allows for...?
  • Transfer Error Messages Task
  • Transfer Jobs Task
  • Transfer Logins Task
  • Transfer Master Stored Procedures Task
  • Transfer SQL Server Objects Task
    • DDL objects
    • The most used task

��

and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, dba, database, transfer,, introduction, step by step, begin

posted by Scott Whigham @ 2:50 PM  

New SQL Server Integration Services Video Tutorial: Part 9- Tasks : File System, FTP, Message Queue, and Script

Part 9- Tasks: File System, FTP, Message Queue, and Script - view details
We'll be continuing our tour of the Toolbox in the video tutorial by discussing the File System Task, the FTP Task, the Message Queue Task, and the Script Task.

Highlights from this video:
  • The File System Task
    • Integrating with the file system
  • FTP Task
    • FTP or UNC paths
    • Example scenario
  • Message Queue Task (MSMQ)
  • The Script Task
    • .NET code as standalone task
    • Example usage
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, file system, ftp, message queue, msmq, script, task,, intro

posted by Scott Whigham @ 2:50 PM  

New SQL Server Integration Services Video Tutorial: Part 7 - Task s: Data Mining Query, Data Profiling, and Execute DTS Package

Part 7 - Tasks: Data Mining Query, Data Profiling, and Execute DTS Package - view details
The Data Mining Query Task, the Data Profiling Task, and the Execute DTS Package Task are the three tasks that will be discussed in this video tutorial.

Highlights from this video:
  • What is the Data Mining Query Task?
  • Data Profiling Task in SQL Server 2008
    • What does it allow me to do?
    • Example usage
    • Demo of working with task
  • Execute DTS 2000 Task
    • Backwards-compatibilty
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, data mining, data profiling, dts, package, task, introducti

posted by Scott Whigham @ 2:50 PM  

New SQL Server Integration Services Video Tutorial: Part 6 - Task s: The Data Flow Task

Part 6 - Tasks: The Data Flow Task - view details
In this video, we will be taking a look at a task that you will more than likely spend a LOT of time working with, the Data Flow Task.

Highlights from this video:
  • The idea of the Data Flow Task
    • Primary ETL task for SSIS
  • Data Flow sources and destinations
  • Common Data Flow Transformations
    • Copy Column
    • Data Conversion
    • Derived Column
    • Union All
  • Bulk Insert Task vs Data Flow Task
    • Which should I use and when?
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, data flow, task, studio, project, designer, , introduction, step by step, beginner, be

posted by Scott Whigham @ 2:50 PM  

New SQL Server Integration Services Video Tutorial: Part 5 - Task s: The ActiveX Script Task, Analysis Services Tasks, and the Bulk Insert T asks

Part 5 - Tasks: The ActiveX Script Task, Analysis Services Tasks, and the Bulk Insert Tasks - view details
In this fifth video in our series, we will be taking a tour of the control flow items, more specifically the ActiveX script task, Analysis Services tasks, and the Bulk Insert task.

Highlights from this video:
  • What is it? What does it do? Who uses it?
    • ActiveX Script Task
    • Analysis Services Execute DDL Task
      • Example usage
    • Analysis Services Processing Task
      • Example usage
    • Bulk Insert Task
      • Example usage in Visual Studio
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, task, control flow, bulk insert, activeX, introduction, ste

posted by Scott Whigham @ 2:50 PM  

New SQL Server Integration Services Video Tutorial: Part 4 - The SSIS Containers: For Loop, Foreach Loop, and the Sequence Container

Part 4 - The SSIS Containers: For Loop, Foreach Loop, and the Sequence Container - view details
Continued in this video tutorial is the discussion and overview of the SSIS containers, specifically the For Loop, Foreach Loop, and the Sequence Containers.

Highlights from this video:
  • What is a For Loop Container?
    • Who uses it?
    • What does it allow me to do?
      • Example usage
  • Foreach Loop Container
    • Iterating in a collection
    • Example usage
  • Why use a Sequence Container?
    • Example usuage
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, container, foreach, for , loop, sequence, introduction, ste

posted by Scott Whigham @ 2:50 PM  

New SQL Server Integration Services Video Tutorial: Part 3 - The SSIS Containers: Containers and the Task Host Container

Part 3 - The SSIS Containers: Containers and the Task Host Container - view details
In this video, we will talk about the containers by taking��a quick look at the three containers built into SSIS��as well as detail one that is kind of hidden. But what exactly is a container? The answer to this question and many more will be covered in this video tutorial

Highlights from this video:
  • Container functionality
    • Container logic flow
  • Event-handlers and variables
  • The concept of Scoping
  • Container object: Task host container
    • What it is
    • Who uses it
    • What it does
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer, container, development, introduction, step by step, beginne

posted by Scott Whigham @ 2:50 PM  

New SQL Server Integration Services Video Tutorial: Part 2 - The Various Tabs in the Toolbox; How to Customize the SSIS Toolbox

Part 2 - The Various Tabs in the Toolbox; How to Customize the SSIS Toolbox - view details
In this second video in the series, we will begin our actual tour of the toolbox in BIDS. We will cover the three main expandable sections on the toolbox by answering the questions: Who uses it? What is it? What does it do?

Highlights from this video:
  • Three expandable sections
    • Control Flow Items
    • Maintenance Plan Tasks
    • General
  • Adding new controls to the Toolbox
  • Removing/Resetting controls on the Toolbox
  • Containers��vs Tasks
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer,

posted by Scott Whigham @ 2:49 PM  

New SQL Server Integration Services Video Tutorial: Part 1 - The Start of a Long Series: Understanding the Toolbox

Part 1 - The Start of a Long Series: Understanding the Toolbox - view details
In this video series we will take a look at the SSIS toolbox; the part of the Integration Services development environment on the left hand side (for most of you) where you choose the things like the control flow items and maintenance plan tasks. We'll be taking a tour of��all the items on the toolbox while covering three main topics: what it is, who uses it, and what does it do. By the end of this intro series, you will be well positioned to begin working and playing with Integration Services.

In this first video in the series, you will begin by covering essential terminology and wrap up by opening your toolbox in IS.

Highlights from this video:

  • About the Business Intelligence Development Studio
  • Important terminology
    • BIDS
    • BI Studio
    • SSIS
    • IDE
  • BIDS in SQL 2005 and SQL 2008
  • What happens when I create my first project?
    • Designer surface functionality
  • Opening and navigating your Toolbox
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: toolbox, bids, bi, business intelligence, studio, project, designer,, introduction, step by step, beginner, beginning, for dummi

posted by Scott Whigham @ 2:49 PM  

Wednesday, October 22, 2008

New SQL Server 2005 Video Tutorial: Part 8 - Using Regular Expres sions in Everyday Applications

Part 8 - Using Regular Expressions in Everyday Applications - view details
In this final video in our series, your instructor will demonstrate how to use a text editor to do regular expressions searches. Also in this video, your instructor will expose the uses of regular expressions in everyday applications like Sql Server Management Studio and Visual Studio.

Highlights from this video:
  • Can I use a generic text editor?
  • Regex searches in text editors with "^"
  • Navigating with regular expresssions in SSMS
  • Using the Find feature in VS
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, application,

posted by Scott Whigham @ 8:34 AM  

New Transact SQL Video Tutorial: Part 8 - Using Regular Expressio ns in Everyday Applications

Part 8 - Using Regular Expressions in Everyday Applications - view details
In this final video in our series, your instructor will demonstrate how to use a text editor to do regular expressions searches. Also in this video, your instructor will expose the uses of regular expressions in everyday applications like Sql Server Management Studio and Visual Studio.

Highlights from this video:
  • Can I use a generic text editor?
  • Regex searches in text editors with "^"
  • Navigating with regular expresssions in SSMS
  • Using the Find feature in VS
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, application,

posted by Scott Whigham @ 8:34 AM  

New Transact SQL Video Tutorial: Part 5 - Email Address Validatio n Regular Expression

Part 5 - Email Address Validation Regular Expression - view details
In this fifth video in the series, your instructor will detail about validating email addresses, another way to match patterns. This is a perfect time to consider using regular expressions as it's a method that will build upon the regex syntax you've previously learned.

Highlights from this video:
  • Defining new syntax elements
    • " [ ] " - brackets characters
    • " + " - plus character
    • " @ " - AT character
    • " { } " -curly brackets characters
    • " $ " -dollar sign character
  • Working with and defining quantifiers
  • Terminating your regex strings
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2005 Video Tutorial: Part 7 - More Regular Express ions Syntax and Case Sensitivity

Part 7 - More Regular Expressions Syntax and Case Sensitivity - view details
The seventh video will talk now about a few new pieces of regular expressions along with the concepts of case sensesitivty in the regular expressions as well as PowerShell. Scott will also be giving you some techniques that will make you more efficient and productive when working in PowerShell and regular expressions altogether

Highlights from this video:
  • Productivity tips for testing your variables against a particular expression
  • Functionality of caret character "^"
  • Case sensitivity and insensitivity
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, syntax, sensitivitiy, case

posted by Scott Whigham @ 8:34 AM  

New Transact SQL Video Tutorial: Part 6- Using Windows PowerShell to Test Regular Expressions

Part 6- Using Windows PowerShell to Test Regular Expressions - view details
Tired of all the regular expression theory? In this sixth video in the eight-part series on regular expressions, we'll finally begin writing and practicing our regular expressions via tools built into the OS and third-party applications.

Highlights from this video:
  • Introduction to PowerShell
    • Accessing/downloading PowerShell
    • Use of variables
    • PowerShell proper syntax
  • Testing regular expressions in PS
  • Defining our regular expressions in another variable
  • Using IF, ELSE statements
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, powershell

posted by Scott Whigham @ 8:34 AM  

New Transact SQL Video Tutorial: Part 7 - More Regular Expression s Syntax and Case Sensitivity

Part 7 - More Regular Expressions Syntax and Case Sensitivity - view details
The seventh video will talk now about a few new pieces of regular expressions along with the concepts of case sensesitivty in the regular expressions as well as PowerShell. Scott will also be giving you some techniques that will make you more efficient and productive when working in PowerShell and regular expressions altogether

Highlights from this video:
  • Productivity tips for testing your variables against a particular expression
  • Functionality of caret character "^"
  • Case sensitivity and insensitivity
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, syntax, sensitivitiy, case

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2005 Video Tutorial: Part 6- Using Windows PowerSh ell to Test Regular Expressions

Part 6- Using Windows PowerShell to Test Regular Expressions - view details
Tired of all the regular expression theory? In this sixth video in the eight-part series on regular expressions, we'll finally begin writing and practicing our regular expressions via tools built into the OS and third-party applications.

Highlights from this video:
  • Introduction to PowerShell
    • Accessing/downloading PowerShell
    • Use of variables
    • PowerShell proper syntax
  • Testing regular expressions in PS
  • Defining our regular expressions in another variable
  • Using IF, ELSE statements
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, powershell

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2005 Video Tutorial: Part 1 - An Introduction to R egular Expressions

Part 1 - An Introduction to Regular Expressions - view details
In this video series, we will be talking about regular expressions, a topic that many find to be semi-confusing. In the first video, you will be provided with an in-depth introduction to the concept of Regular Expressions, one of the most efficient and easiest ways to work with text data or strings. Also in this video, Scott will demonstrate where regular expressions can help.

Highlights from this video:
  • How are Regular Expressions useful?
  • Languages that support RegEx
  • Simplifying tasks via regular exressions
    • Real-life scenario
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 5:34 AM  

New Transact SQL Video Tutorial: Part 2 - A Continued Introductio n to Regular Expressions

Part 2 - A Continued Introduction to Regular Expressions - view details
Continuing in this second video in the eight-part series on regular expressions, Scott will pickup at the regex scenario that was presented in the previous video as well as detail the advantages of regular expressions. Your instructor Scott will also begin working with and exploring an actual regular expression

Highlights from this video:
  • Different approaches and methods for solving the scenario
    • .NET Developer
    • SQL Server Developer
    • System Administrator
    • Quality Assurance Tester
  • Language advantage of regular expressions
  • Beginning to Work with the "intimidating" regular expression pattern
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, intro

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2005 Video Tutorial: Part 3 - Looking at a Filenam e Pattern Regular Expression

Part 3 - Looking at a Filename Pattern Regular Expression - view details
This third video will continue by finding patterns in regular expressions. Your instructor will guide you to reaching and understanding filename patterns, as well as take regular expressions item by item and divulge on why each part works.

Highlights from this video:
  • Literal and alternation of characters
  • Matching digits
    • " \d "
  • Working with underscores in your expressions
  • Other optional elements
    • " ? "
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, string, pattern, language, text, script

posted by Scott Whigham @ 5:34 AM  

New Transact SQL Video Tutorial: Part 4 - Looking at a Filename Pattern Regular Expression

Part 4 - Looking at a Filename Pattern Regular Expression - view details
In this fourth video, we will wrap up our example of filename patterns by defining the various elements found in regular expressions and demonstrate how to match and group the characters.

Highlights from this video:
  • Defining important elements in your expressions
    • " ( ) " - parentheses characters
    • " | " - pipe character
    • " . " - period metacharacter
    • " \ " - backslash character
  • Validating against our regex
  • Using patterns to match more sample regular expressions

Authors notes included with download

and much more

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 5:34 AM  

New Transact SQL Video Tutorial: Part 3 - Looking at a Filename P attern Regular Expression

Part 3 - Looking at a Filename Pattern Regular Expression - view details
This third video will continue by finding patterns in regular expressions. Your instructor will guide you to reaching and understanding filename patterns, as well as take regular expressions item by item and divulge on why each part works.

Highlights from this video:
  • Literal and alternation of characters
  • Matching digits
    • " \d "
  • Working with underscores in your expressions
  • Other optional elements
    • " ? "
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, string, pattern, language, text, script

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2005 Video Tutorial: Part 5 - Email Address Valida tion Regular Expression

Part 5 - Email Address Validation Regular Expression - view details
In this fifth video in the series, your instructor will detail about validating email addresses, another way to match patterns. This is a perfect time to consider using regular expressions as it's a method that will build upon the regex syntax you've previously learned.

Highlights from this video:
  • Defining new syntax elements
    • " [ ] " - brackets characters
    • " + " - plus character
    • " @ " - AT character
    • " { } " -curly brackets characters
    • " $ " -dollar sign character
  • Working with and defining quantifiers
  • Terminating your regex strings
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2005 Video Tutorial: Part 2 - A Continued Introduc tion to Regular Expressions

Part 2 - A Continued Introduction to Regular Expressions - view details
Continuing in this second video in the eight-part series on regular expressions, Scott will pickup at the regex scenario that was presented in the previous video as well as detail the advantages of regular expressions. Your instructor Scott will also begin working with and exploring an actual regular expression

Highlights from this video:
  • Different approaches and methods for solving the scenario
    • .NET Developer
    • SQL Server Developer
    • System Administrator
    • Quality Assurance Tester
  • Language advantage of regular expressions
  • Beginning to Work with the "intimidating" regular expression pattern
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, intro

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2005 Video Tutorial: Part 4 - Looking at a Filena me Pattern Regular Expression

Part 4 - Looking at a Filename Pattern Regular Expression - view details
In this fourth video, we will wrap up our example of filename patterns by defining the various elements found in regular expressions and demonstrate how to match and group the characters.

Highlights from this video:
  • Defining important elements in your expressions
    • " ( ) " - parentheses characters
    • " | " - pipe character
    • " . " - period metacharacter
    • " \ " - backslash character
  • Validating against our regex
  • Using patterns to match more sample regular expressions

Authors notes included with download

and much more

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 5:34 AM  

New Transact SQL Video Tutorial: Part 1 - An Introduction to Regu lar Expressions

Part 1 - An Introduction to Regular Expressions - view details
In this video series, we will be talking about regular expressions, a topic that many find to be semi-confusing. In the first video, you will be provided with an in-depth introduction to the concept of Regular Expressions, one of the most efficient and easiest ways to work with text data or strings. Also in this video, Scott will demonstrate where regular expressions can help.

Highlights from this video:
  • How are Regular Expressions useful?
  • Languages that support RegEx
  • Simplifying tasks via regular exressions
    • Real-life scenario
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 5:34 AM  

Monday, October 20, 2008

New SQL Server Integration Services Video Tutorial: Part 1 - An I ntroduction to Regular Expressions

Part 1 - An Introduction to Regular Expressions - view details
In this video series, we will be talking about regular expressions, a topic that many find to be semi-confusing. In the first video, you will be provided with an in-depth introduction to the concept of Regular Expressions, one of the most efficient and easiest ways to work with text data or strings. Also in this video, Scott will demonstrate where regular expressions can help.

Highlights from this video:
  • How are Regular Expressions useful?
  • Languages that support RegEx
  • Simplifying tasks via regular exressions
    • Real-life scenario
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 2:34 PM  

New SQL Server Integration Services Video Tutorial: Part 5 - Emai l Address Validation Regular Expression

Part 5 - Email Address Validation Regular Expression - view details
In this fifth video in the series, your instructor will detail about validating email addresses, another way to match patterns. This is a perfect time to consider using regular expressions as it's a method that will build upon the regex syntax you've previously learned.

Highlights from this video:
  • Defining new syntax elements
    • " [ ] " - brackets characters
    • " + " - plus character
    • " @ " - AT character
    • " { } " -curly brackets characters
    • " $ " -dollar sign character
  • Working with and defining quantifiers
  • Terminating your regex strings
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 2:34 PM  

New SQL Server Integration Services Video Tutorial: Part 4 - Loo king at a Filename Pattern Regular Expression

Part 4 - Looking at a Filename Pattern Regular Expression - view details
In this fourth video, we will wrap up our example of filename patterns by defining the various elements found in regular expressions and demonstrate how to match and group the characters.

Highlights from this video:
  • Defining important elements in your expressions
    • " ( ) " - parentheses characters
    • " | " - pipe character
    • " . " - period metacharacter
    • " \ " - backslash character
  • Validating against our regex
  • Using patterns to match more sample regular expressions

Authors notes included with download

and much more

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 2:34 PM  

New SQL Server Integration Services Video Tutorial: Part 8 - Usin g Regular Expressions in Everyday Applications

Part 8 - Using Regular Expressions in Everyday Applications - view details
In this final video in our series, your instructor will demonstrate how to use a text editor to do regular expressions searches. Also in this video, your instructor will expose the uses of regular expressions in everyday applications like Sql Server Management Studio and Visual Studio.

Highlights from this video:
  • Can I use a generic text editor?
  • Regex searches in text editors with "^"
  • Navigating with regular expresssions in SSMS
  • Using the Find feature in VS
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, application,

posted by Scott Whigham @ 2:34 PM  

New SQL Server Integration Services Video Tutorial: Part 7 - More Regular Expressions Syntax and Case Sensitivity

Part 7 - More Regular Expressions Syntax and Case Sensitivity - view details
The seventh video will talk now about a few new pieces of regular expressions along with the concepts of case sensesitivty in the regular expressions as well as PowerShell. Scott will also be giving you some techniques that will make you more efficient and productive when working in PowerShell and regular expressions altogether

Highlights from this video:
  • Productivity tips for testing your variables against a particular expression
  • Functionality of caret character "^"
  • Case sensitivity and insensitivity
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, syntax, sensitivitiy, case

posted by Scott Whigham @ 2:34 PM  

New SQL Server Integration Services Video Tutorial: Part 6- Using Windows PowerShell to Test Regular Expressions

Part 6- Using Windows PowerShell to Test Regular Expressions - view details
Tired of all the regular expression theory? In this sixth video in the eight-part series on regular expressions, we'll finally begin writing and practicing our regular expressions via tools built into the OS and third-party applications.

Highlights from this video:
  • Introduction to PowerShell
    • Accessing/downloading PowerShell
    • Use of variables
    • PowerShell proper syntax
  • Testing regular expressions in PS
  • Defining our regular expressions in another variable
  • Using IF, ELSE statements
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, powershell

posted by Scott Whigham @ 2:34 PM  

New SQL Server Integration Services Video Tutorial: Part 3 - Look ing at a Filename Pattern Regular Expression

Part 3 - Looking at a Filename Pattern Regular Expression - view details
This third video will continue by finding patterns in regular expressions. Your instructor will guide you to reaching and understanding filename patterns, as well as take regular expressions item by item and divulge on why each part works.

Highlights from this video:
  • Literal and alternation of characters
  • Matching digits
    • " \d "
  • Working with underscores in your expressions
  • Other optional elements
    • " ? "
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, string, pattern, language, text, script

posted by Scott Whigham @ 2:34 PM  

New SQL Server Integration Services Video Tutorial: Part 2 - A Co ntinued Introduction to Regular Expressions

Part 2 - A Continued Introduction to Regular Expressions - view details
Continuing in this second video in the eight-part series on regular expressions, Scott will pickup at the regex scenario that was presented in the previous video as well as detail the advantages of regular expressions. Your instructor Scott will also begin working with and exploring an actual regular expression

Highlights from this video:
  • Different approaches and methods for solving the scenario
    • .NET Developer
    • SQL Server Developer
    • System Administrator
    • Quality Assurance Tester
  • Language advantage of regular expressions
  • Beginning to Work with the "intimidating" regular expression pattern
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, intro

posted by Scott Whigham @ 2:34 PM  

Friday, October 17, 2008

New C# Video Tutorial: Part 8 - Using Regular Expressions in Ever yday Applications

Part 8 - Using Regular Expressions in Everyday Applications - view details
In this final video in our series, your instructor will demonstrate how to use a text editor to do regular expressions searches. Also in this video, your instructor will expose the uses of regular expressions in everyday applications like Sql Server Management Studio and Visual Studio.

Highlights from this video:
  • Can I use a generic text editor?
  • Regex searches in text editors with "^"
  • Navigating with regular expresssions in SSMS
  • Using the Find feature in VS
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, application,

posted by Scott Whigham @ 11:34 PM  

New SQL Server Video Tutorial: Part 7 - More Regular Expressions Syntax and Case Sensitivity

Part 7 - More Regular Expressions Syntax and Case Sensitivity - view details
The seventh video will talk now about a few new pieces of regular expressions along with the concepts of case sensesitivty in the regular expressions as well as PowerShell. Scott will also be giving you some techniques that will make you more efficient and productive when working in PowerShell and regular expressions altogether

Highlights from this video:
  • Productivity tips for testing your variables against a particular expression
  • Functionality of caret character "^"
  • Case sensitivity and insensitivity
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, syntax, sensitivitiy, case

posted by Scott Whigham @ 11:34 PM  

New Visual Basic Video Tutorial: Part 7 - More Regular Expression s Syntax and Case Sensitivity

Part 7 - More Regular Expressions Syntax and Case Sensitivity - view details
The seventh video will talk now about a few new pieces of regular expressions along with the concepts of case sensesitivty in the regular expressions as well as PowerShell. Scott will also be giving you some techniques that will make you more efficient and productive when working in PowerShell and regular expressions altogether

Highlights from this video:
  • Productivity tips for testing your variables against a particular expression
  • Functionality of caret character "^"
  • Case sensitivity and insensitivity
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, syntax, sensitivitiy, case

posted by Scott Whigham @ 11:34 PM  

New C# Video Tutorial: Part 7 - More Regular Expressions Syntax a nd Case Sensitivity

Part 7 - More Regular Expressions Syntax and Case Sensitivity - view details
The seventh video will talk now about a few new pieces of regular expressions along with the concepts of case sensesitivty in the regular expressions as well as PowerShell. Scott will also be giving you some techniques that will make you more efficient and productive when working in PowerShell and regular expressions altogether

Highlights from this video:
  • Productivity tips for testing your variables against a particular expression
  • Functionality of caret character "^"
  • Case sensitivity and insensitivity
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, syntax, sensitivitiy, case

posted by Scott Whigham @ 11:34 PM  

New SQL Server Video Tutorial: Part 8 - Using Regular Expressions in Everyday Applications

Part 8 - Using Regular Expressions in Everyday Applications - view details
In this final video in our series, your instructor will demonstrate how to use a text editor to do regular expressions searches. Also in this video, your instructor will expose the uses of regular expressions in everyday applications like Sql Server Management Studio and Visual Studio.

Highlights from this video:
  • Can I use a generic text editor?
  • Regex searches in text editors with "^"
  • Navigating with regular expresssions in SSMS
  • Using the Find feature in VS
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, application,

posted by Scott Whigham @ 11:34 PM  

New Visual Basic Video Tutorial: Part 6- Using Windows PowerShell to Test Regular Expressions

Part 6- Using Windows PowerShell to Test Regular Expressions - view details
Tired of all the regular expression theory? In this sixth video in the eight-part series on regular expressions, we'll finally begin writing and practicing our regular expressions via tools built into the OS and third-party applications.

Highlights from this video:
  • Introduction to PowerShell
    • Accessing/downloading PowerShell
    • Use of variables
    • PowerShell proper syntax
  • Testing regular expressions in PS
  • Defining our regular expressions in another variable
  • Using IF, ELSE statements
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, powershell

posted by Scott Whigham @ 11:34 PM  

New SQL Server Video Tutorial: Part 4 - Looking at a Filename Pa ttern Regular Expression

Part 4 - Looking at a Filename Pattern Regular Expression - view details
In this fourth video, we will wrap up our example of filename patterns by defining the various elements found in regular expressions and demonstrate how to match and group the characters.

Highlights from this video:
  • Defining important elements in your expressions
    • " ( ) " - parentheses characters
    • " | " - pipe character
    • " . " - period metacharacter
    • " \ " - backslash character
  • Validating against our regex
  • Using patterns to match more sample regular expressions

Authors notes included with download

and much more

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 8:34 PM  

New Visual Basic Video Tutorial: Part 4 - Looking at a Filename Pattern Regular Expression

Part 4 - Looking at a Filename Pattern Regular Expression - view details
In this fourth video, we will wrap up our example of filename patterns by defining the various elements found in regular expressions and demonstrate how to match and group the characters.

Highlights from this video:
  • Defining important elements in your expressions
    • " ( ) " - parentheses characters
    • " | " - pipe character
    • " . " - period metacharacter
    • " \ " - backslash character
  • Validating against our regex
  • Using patterns to match more sample regular expressions

Authors notes included with download

and much more

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 8:34 PM  

New C# Video Tutorial: Part 6- Using Windows PowerShell to Test R egular Expressions

Part 6- Using Windows PowerShell to Test Regular Expressions - view details
Tired of all the regular expression theory? In this sixth video in the eight-part series on regular expressions, we'll finally begin writing and practicing our regular expressions via tools built into the OS and third-party applications.

Highlights from this video:
  • Introduction to PowerShell
    • Accessing/downloading PowerShell
    • Use of variables
    • PowerShell proper syntax
  • Testing regular expressions in PS
  • Defining our regular expressions in another variable
  • Using IF, ELSE statements
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, powershell

posted by Scott Whigham @ 8:34 PM  

New SQL Server Video Tutorial: Part 5 - Email Address Validation Regular Expression

Part 5 - Email Address Validation Regular Expression - view details
In this fifth video in the series, your instructor will detail about validating email addresses, another way to match patterns. This is a perfect time to consider using regular expressions as it's a method that will build upon the regex syntax you've previously learned.

Highlights from this video:
  • Defining new syntax elements
    • " [ ] " - brackets characters
    • " + " - plus character
    • " @ " - AT character
    • " { } " -curly brackets characters
    • " $ " -dollar sign character
  • Working with and defining quantifiers
  • Terminating your regex strings
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 8:34 PM  

New Visual Basic Video Tutorial: Part 5 - Email Address Validatio n Regular Expression

Part 5 - Email Address Validation Regular Expression - view details
In this fifth video in the series, your instructor will detail about validating email addresses, another way to match patterns. This is a perfect time to consider using regular expressions as it's a method that will build upon the regex syntax you've previously learned.

Highlights from this video:
  • Defining new syntax elements
    • " [ ] " - brackets characters
    • " + " - plus character
    • " @ " - AT character
    • " { } " -curly brackets characters
    • " $ " -dollar sign character
  • Working with and defining quantifiers
  • Terminating your regex strings
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 8:34 PM  

New Visual Basic Video Tutorial: Part 3 - Looking at a Filename P attern Regular Expression

Part 3 - Looking at a Filename Pattern Regular Expression - view details
This third video will continue by finding patterns in regular expressions. Your instructor will guide you to reaching and understanding filename patterns, as well as take regular expressions item by item and divulge on why each part works.

Highlights from this video:
  • Literal and alternation of characters
  • Matching digits
    • " \d "
  • Working with underscores in your expressions
  • Other optional elements
    • " ? "
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, string, pattern, language, text, script

posted by Scott Whigham @ 8:34 PM  

New SQL Server Video Tutorial: Part 6- Using Windows PowerShell t o Test Regular Expressions

Part 6- Using Windows PowerShell to Test Regular Expressions - view details
Tired of all the regular expression theory? In this sixth video in the eight-part series on regular expressions, we'll finally begin writing and practicing our regular expressions via tools built into the OS and third-party applications.

Highlights from this video:
  • Introduction to PowerShell
    • Accessing/downloading PowerShell
    • Use of variables
    • PowerShell proper syntax
  • Testing regular expressions in PS
  • Defining our regular expressions in another variable
  • Using IF, ELSE statements
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, powershell

posted by Scott Whigham @ 8:34 PM  

New C# Video Tutorial: Part 5 - Email Address Validation Regular Expression

Part 5 - Email Address Validation Regular Expression - view details
In this fifth video in the series, your instructor will detail about validating email addresses, another way to match patterns. This is a perfect time to consider using regular expressions as it's a method that will build upon the regex syntax you've previously learned.

Highlights from this video:
  • Defining new syntax elements
    • " [ ] " - brackets characters
    • " + " - plus character
    • " @ " - AT character
    • " { } " -curly brackets characters
    • " $ " -dollar sign character
  • Working with and defining quantifiers
  • Terminating your regex strings
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 8:34 PM  

New C# Video Tutorial: Part 4 - Looking at a Filename Pattern Re gular Expression

Part 4 - Looking at a Filename Pattern Regular Expression - view details
In this fourth video, we will wrap up our example of filename patterns by defining the various elements found in regular expressions and demonstrate how to match and group the characters.

Highlights from this video:
  • Defining important elements in your expressions
    • " ( ) " - parentheses characters
    • " | " - pipe character
    • " . " - period metacharacter
    • " \ " - backslash character
  • Validating against our regex
  • Using patterns to match more sample regular expressions

Authors notes included with download

and much more

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 8:34 PM  

New Visual Basic Video Tutorial: Part 2 - A Continued Introductio n to Regular Expressions

Part 2 - A Continued Introduction to Regular Expressions - view details
Continuing in this second video in the eight-part series on regular expressions, Scott will pickup at the regex scenario that was presented in the previous video as well as detail the advantages of regular expressions. Your instructor Scott will also begin working with and exploring an actual regular expression

Highlights from this video:
  • Different approaches and methods for solving the scenario
    • .NET Developer
    • SQL Server Developer
    • System Administrator
    • Quality Assurance Tester
  • Language advantage of regular expressions
  • Beginning to Work with the "intimidating" regular expression pattern
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, intro

posted by Scott Whigham @ 5:34 PM  

New Visual Basic Video Tutorial: Part 1 - An Introduction to Regu lar Expressions

Part 1 - An Introduction to Regular Expressions - view details
In this video series, we will be talking about regular expressions, a topic that many find to be semi-confusing. In the first video, you will be provided with an in-depth introduction to the concept of Regular Expressions, one of the most efficient and easiest ways to work with text data or strings. Also in this video, Scott will demonstrate where regular expressions can help.

Highlights from this video:
  • How are Regular Expressions useful?
  • Languages that support RegEx
  • Simplifying tasks via regular exressions
    • Real-life scenario
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 5:34 PM  

New Transact SQL Video Tutorial: Part 3 - Using Aliases for Deriv ed Tables

Part 3 - Using Aliases for Derived Tables - view details
In this third and final video, Scott will divulge explicitly on the derived table aliases, or query aliases.

Highlights from this video:
  • What is a derived table and what is its purpose?
  • Working with the FROM clause and syntax of query aliases
  • Execution of a derived table
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: table, derived, query, alias, 2008,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 PM  

New C# Video Tutorial: Part 3 - Looking at a Filename Pattern Reg ular Expression

Part 3 - Looking at a Filename Pattern Regular Expression - view details
This third video will continue by finding patterns in regular expressions. Your instructor will guide you to reaching and understanding filename patterns, as well as take regular expressions item by item and divulge on why each part works.

Highlights from this video:
  • Literal and alternation of characters
  • Matching digits
    • " \d "
  • Working with underscores in your expressions
  • Other optional elements
    • " ? "
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, string, pattern, language, text, script

posted by Scott Whigham @ 5:34 PM  

New SQL Server Video Tutorial: Part 3 - Looking at a Filename Pat tern Regular Expression

Part 3 - Looking at a Filename Pattern Regular Expression - view details
This third video will continue by finding patterns in regular expressions. Your instructor will guide you to reaching and understanding filename patterns, as well as take regular expressions item by item and divulge on why each part works.

Highlights from this video:
  • Literal and alternation of characters
  • Matching digits
    • " \d "
  • Working with underscores in your expressions
  • Other optional elements
    • " ? "
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, string, pattern, language, text, script

posted by Scott Whigham @ 5:34 PM  

New SQL Server Video Tutorial: Part 2 - A Continued Introduction to Regular Expressions

Part 2 - A Continued Introduction to Regular Expressions - view details
Continuing in this second video in the eight-part series on regular expressions, Scott will pickup at the regex scenario that was presented in the previous video as well as detail the advantages of regular expressions. Your instructor Scott will also begin working with and exploring an actual regular expression

Highlights from this video:
  • Different approaches and methods for solving the scenario
    • .NET Developer
    • SQL Server Developer
    • System Administrator
    • Quality Assurance Tester
  • Language advantage of regular expressions
  • Beginning to Work with the "intimidating" regular expression pattern
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, intro

posted by Scott Whigham @ 5:34 PM  

New C# Video Tutorial: Part 2 - A Continued Introduction to Regul ar Expressions

Part 2 - A Continued Introduction to Regular Expressions - view details
Continuing in this second video in the eight-part series on regular expressions, Scott will pickup at the regex scenario that was presented in the previous video as well as detail the advantages of regular expressions. Your instructor Scott will also begin working with and exploring an actual regular expression

Highlights from this video:
  • Different approaches and methods for solving the scenario
    • .NET Developer
    • SQL Server Developer
    • System Administrator
    • Quality Assurance Tester
  • Language advantage of regular expressions
  • Beginning to Work with the "intimidating" regular expression pattern
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, intro

posted by Scott Whigham @ 5:34 PM  

New SQL Server Video Tutorial: Part 1 - An Introduction to Regula r Expressions

Part 1 - An Introduction to Regular Expressions - view details
In this video series, we will be talking about regular expressions, a topic that many find to be semi-confusing. In the first video, you will be provided with an in-depth introduction to the concept of Regular Expressions, one of the most efficient and easiest ways to work with text data or strings. Also in this video, Scott will demonstrate where regular expressions can help.

Highlights from this video:
  • How are Regular Expressions useful?
  • Languages that support RegEx
  • Simplifying tasks via regular exressions
    • Real-life scenario
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 5:34 PM  

New C# Video Tutorial: Part 1 - An Introduction to Regular Expressions

Part 1 - An Introduction to Regular Expressions - view details
In this video series, we will be talking about regular expressions, a topic that many find to be semi-confusing. In the first video, you will be provided with an in-depth introduction to the concept of Regular Expressions, one of the most efficient and easiest ways to work with text data or strings. Also in this video, Scott will demonstrate where regular expressions can help.

Highlights from this video:
  • How are Regular Expressions useful?
  • Languages that support RegEx
  • Simplifying tasks via regular exressions
    • Real-life scenario
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 5:34 PM  

New SQL Server Video Tutorial: Part 1 - An Introduction to Regula r Expressions

Part 1 - An Introduction to Regular Expressions - view details
In this video series, we will be talking about regular expressions, a topic that many find to be semi-confusing. In the first video, you will be provided with an in-depth introduction to the concept of Regular Expressions, one of the most efficient and easiest ways to work with text data or strings. Also in this video, Scott will demonstrate where regular expressions can help.

Highlights from this video:
  • How are Regular Expressions useful?
  • Languages that support RegEx
  • Simplifying tasks via regular exressions
    • Real-life scenario
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 2:52 PM  

New SQL Server Video Tutorial: Part 2 - A Continued Introduction to Regular Expressions

Part 2 - A Continued Introduction to Regular Expressions - view details
Continuing in this second video in the eight-part series on regular expressions, Scott will pickup at the regex scenario that was presented in the previous video as well as detail the advantages of regular expressions. Your instructor Scott will also begin working with and exploring an actual regular expression

Highlights from this video:
  • Different approaches and methods for solving the scenario
    • .NET Developer
    • SQL Server Developer
    • System Administrator
    • Quality Assurance Tester
  • Language advantage of regular expressions
  • Beginning to Work with the "intimidating" regular expression pattern
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, intro

posted by Scott Whigham @ 2:51 PM  

New SQL Server Video Tutorial: Part 3 - Looking at a Filename Pat tern Regular Expression

Part 3 - Looking at a Filename Pattern Regular Expression - view details
This third video will continue by finding patterns in regular expressions. Your instructor will guide you to reaching and understanding filename patterns, as well as take regular expressions item by item and divulge on why each part works.

Highlights from this video:
  • Literal and alternation of characters
  • Matching digits
    • " \d "
  • Working with underscores in your expressions
  • Other optional elements
    • " ? "
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, string, pattern, language, text, script

posted by Scott Whigham @ 2:51 PM  

New SQL Server Video Tutorial: Part 4 - Looking at a Filename Pa ttern Regular Expression

Part 4 - Looking at a Filename Pattern Regular Expression - view details
In this fourth video, we will wrap up our example of filename patterns by defining the various elements found in regular expressions and demonstrate how to match and group the characters.

Highlights from this video:
  • Defining important elements in your expressions
    • " ( ) " - parentheses characters
    • " | " - pipe character
    • " . " - period metacharacter
    • " \ " - backslash character
  • Validating against our regex
  • Using patterns to match more sample regular expressions

Authors notes included with download

and much more

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 2:50 PM  

New SQL Server Video Tutorial: Part 4 - Looking at a Filename Pa ttern Regular Expression

Part 4 - Looking at a Filename Pattern Regular Expression - view details
In this fourth video, we will wrap up our example of filename patterns by defining the various elements found in regular expressions and demonstrate how to match and group the characters.

Highlights from this video:
  • Defining important elements in your expressions
    • " ( ) " - parentheses characters
    • " | " - pipe character
    • " . " - period metacharacter
    • " \ " - backslash character
  • Validating against our regex
  • Using patterns to match more sample regular expressions

Authors notes included with download

and much more

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 2:49 PM  

New SQL Server Video Tutorial: Part 5 - Email Address Validation Regular Expression

Part 5 - Email Address Validation Regular Expression - view details
In this fifth video in the series, your instructor will detail about validating email addresses, another way to match patterns. This is a perfect time to consider using regular expressions as it's a method that will build upon the regex syntax you've previously learned.

Highlights from this video:
  • Defining new syntax elements
    • " [ ] " - brackets characters
    • " + " - plus character
    • " @ " - AT character
    • " { } " -curly brackets characters
    • " $ " -dollar sign character
  • Working with and defining quantifiers
  • Terminating your regex strings
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string,

posted by Scott Whigham @ 2:49 PM  

New SQL Server Video Tutorial: Part 6- Using Windows PowerShell t o Test Regular Expressions

Part 6- Using Windows PowerShell to Test Regular Expressions - view details
Tired of all the regular expression theory? In this sixth video in the eight-part series on regular expressions, we'll finally begin writing and practicing our regular expressions via tools built into the OS and third-party applications.

Highlights from this video:
  • Introduction to PowerShell
    • Accessing/downloading PowerShell
    • Use of variables
    • PowerShell proper syntax
  • Testing regular expressions in PS
  • Defining our regular expressions in another variable
  • Using IF, ELSE statements
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, powershell

posted by Scott Whigham @ 2:48 PM  

New SQL Server Video Tutorial: Part 7 - More Regular Expressions Syntax and Case Sensitivity

Part 7 - More Regular Expressions Syntax and Case Sensitivity - view details
The seventh video will talk now about a few new pieces of regular expressions along with the concepts of case sensesitivty in the regular expressions as well as PowerShell. Scott will also be giving you some techniques that will make you more efficient and productive when working in PowerShell and regular expressions altogether

Highlights from this video:
  • Productivity tips for testing your variables against a particular expression
  • Functionality of caret character "^"
  • Case sensitivity and insensitivity
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, syntax, sensitivitiy, case

posted by Scott Whigham @ 2:47 PM  

New SQL Server Video Tutorial: Part 8 - Using Regular Expressions in Everyday Applications

Part 8 - Using Regular Expressions in Everyday Applications - view details
In this final video in our series, your instructor will demonstrate how to use a text editor to do regular expressions searches. Also in this video, your instructor will expose the uses of regular expressions in everyday applications like Sql Server Management Studio and Visual Studio.

Highlights from this video:
  • Can I use a generic text editor?
  • Regex searches in text editors with "^"
  • Navigating with regular expresssions in SSMS
  • Using the Find feature in VS
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: regular expressions, regex, expression, language, text, script, string, application,

posted by Scott Whigham @ 2:46 PM  

New Transact SQL Video Tutorial: Part 2 - Column and Table Aliases

Part 2 - Column and Table Aliases - view details
Continuing where the first video left off, Scott will wrap up the discussion on table aliases and also detail the idea of ambiguity in column names.

Highlights from this video:
  • How to prevent "ambiguous references" with table aliases
  • Syntax "sugar" and table aliases
  • Making a query more readable
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: query, alias, aliases, table, column, ambiguity, readable, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:35 PM  

New Transact SQL Video Tutorial: Part 1 - An Overview of the Thre e Types of Aliases You Can Use in a SQL Query

Part 1 - An Overview of the Three Types of Aliases You Can Use in a SQL Query - view details
In this video series we will cover the fundamental idea for any SQL Server person at any skill level, query aliases.In this particular video in the series Scott will show you how to effectively work with three different aliases in queries.

Highlights from this video:
  • Three different types of aliases in a query
    • Column alias
    • Table alias
    • Query alias
  • About column aliases and how they can affect your queries
  • Table aliases:How to define
    • Making references
    • Working with JOINs
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: query, alias, column, table, queries, join, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:35 PM  

New SharePoint Video Tutorial: Moving a SharePoint Content Databa se To A Different Disk on the Same System

Moving a SharePoint Content Database To A Different Disk on the Same System - view details
When you install Windows SharePoint Services 3.0 on to Windows 2003 server, by default it will install a SQL Server Embedded edition to host to the database. The database, by default, will be built on the C:/ drive. In this video we're going to take a look at how you can you the SQL Server Express tools to move the database to a different drive letter, because perhaps you're running out of room on the C:/ drive or your database design is needing you to move the database. This is a fairly quick and easy thing to do, provided you have the right tools.

Highlights from this video:
  • Downloading/opening the SSMS tools
  • Connecting to your SQL Server
  • Where is all of my SharePoint content located?
    • Information about the content databases
  • Detatching databases from the server
    • Suggestions for pre-detatchment
    • Why did my "Detatch Database" fail?
  • Adding databases to a new disk drive

and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: move, moving, database, sql, ssms, management studio, disk, drive,

posted by Scott Whigham @ 2:35 PM  

New Transact SQL Video Tutorial: Part 2 - Column and Table Aliases

Part 2 - Column and Table Aliases - view details
Continuing where the first video left off, Scott will wrap up the discussion on table aliases and also detail the idea of ambiguity in column names.

Highlights from this video:
  • How to prevent "ambiguous references" with table aliases
  • Syntax "sugar" and table aliases
  • Making a query more readable
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: query, alias, aliases, table, column, ambiguity, readable, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Part 1 - An Overview of the Thre e Types of Aliases You Can Use in a SQL Query

Part 1 - An Overview of the Three Types of Aliases You Can Use in a SQL Query - view details
In this video series we will cover the fundamental idea for any SQL Server person at any skill level, query aliases.In this particular video in the series Scott will show you how to effectively work with three different aliases in queries.

Highlights from this video:
  • Three different types of aliases in a query
    • Column alias
    • Table alias
    • Query alias
  • About column aliases and how they can affect your queries
  • Table aliases:How to define
    • Making references
    • Working with JOINs
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: query, alias, column, table, queries, join, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New SharePoint Video Tutorial: Moving a SharePoint Content Databa se To A Different Disk on the Same System

Moving a SharePoint Content Database To A Different Disk on the Same System - view details
When you install Windows SharePoint Services 3.0 on to Windows 2003 server, by default it will install a SQL Server Embedded edition to host to the database. The database, by default, will be built on the C:/ drive. In this video we're going to take a look at how you can you the SQL Server Express tools to move the database to a different drive letter, because perhaps you're running out of room on the C:/ drive or your database design is needing you to move the database. This is a fairly quick and easy thing to do, provided you have the right tools.

Highlights from this video:
  • Downloading/opening the SSMS tools
  • Connecting to your SQL Server
  • Where is all of my SharePoint content located?
    • Information about the content databases
  • Detatching databases from the server
    • Suggestions for pre-detatchment
    • Why did my "Detatch Database" fail?
  • Adding databases to a new disk drive

and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: move, moving, database, sql, ssms, management studio, disk, drive,

posted by Scott Whigham @ 4:35 AM  

Thursday, October 16, 2008

New Transact SQL Video Tutorial: Part 3 - Using Aliases for Deriv ed Tables

Part 3 - Using Aliases for Derived Tables - view details
In this third and final video, Scott will divulge explicitly on the derived table aliases, or query aliases.

Highlights from this video:
  • What is a derived table and what is its purpose?
  • Working with the FROM clause and syntax of query aliases
  • Execution of a derived table
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: table, derived, query, alias, 2008,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 3:40 PM  

New Transact SQL Video Tutorial: Part 2 - Column and Table Aliases

Part 2 - Column and Table Aliases - view details
Continuing where the first video left off, Scott will wrap up the discussion on table aliases and also detail the idea of ambiguity in column names.

Highlights from this video:
  • How to prevent "ambiguous references" with table aliases
  • Syntax "sugar" and table aliases
  • Making a query more readable
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: query, alias, aliases, table, column, ambiguity, readable, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 3:39 PM  

New Transact SQL Video Tutorial: Part 1 - An Overview of the Thre e Types of Aliases You Can Use in a SQL Query

Part 1 - An Overview of the Three Types of Aliases You Can Use in a SQL Query - view details
In this video series we will cover the fundamental idea for any SQL Server person at any skill level, query aliases.In this particular video in the series Scott will show you how to effectively work with three different aliases in queries.

Highlights from this video:
  • Three different types of aliases in a query
    • Column alias
    • Table alias
    • Query alias
  • About column aliases and how they can affect your queries
  • Table aliases:How to define
    • Making references
    • Working with JOINs
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: query, alias, column, table, queries, join, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 3:39 PM