Saturday, June 30, 2007

New Visual C# Video Tutorial: Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video continues the discussion of the various differences (and similarities) between Visual Basic and C# namespaces and how the Visual Studio 2005 IDE works with namespaces. You'll learn about hierarchies and even naming clashes in this video.

Highlights from this video:
  • Nesting namespaces in C#
  • Nesting namespaces in VB.NET
  • Deciding between MyNamespace.AnotherNamespace and nesting namespaces declaratively
  • Common ways to refactor namespaces
  • Using surround with C#
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video shows you to build a few assemblies using C# and VB.NET to understand how namespaces work in both languages. You'll learn about default namespaces and root namespaces as well as how to change the default namespaces.

Highlights from this video:
  • Using the Class View to see your namespace heirarchy
  • Understanding the various property, class and namespace icons in the Visual Studio
  • How to make vertically tabbed documents in Visual Studio
  • How to change a Visual Basic root namespace
  • How to change the default namespace of a C# application
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video continues the discussion of the various differences (and similarities) between Visual Basic and C# namespaces and how the Visual Studio 2005 IDE works with namespaces. You'll learn about hierarchies and even naming clashes in this video.

Highlights from this video:
  • Nesting namespaces in C#
  • Nesting namespaces in VB.NET
  • Deciding between MyNamespace.AnotherNamespace and nesting namespaces declaratively
  • Common ways to refactor namespaces
  • Using surround with C#
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 1 - Namespaces: An Introduction to Namespaces in .NET

Pt. 1 - Namespaces: An Introduction to Namespaces in .NET - view details
This video, part one in a five-part series, helps you understand what a namespace is, where they are used, and helps you get a foothold on the concept of how to organize your code using namespaces. After watching this series, you will have a much more solid foundation of how object oriented programs are arranged/built.

Highlights from this video:
  • What is a namespace?
  • Where do you use namespaces?
  • Discussions of the System namespace and how the .NET Framework uses it
  • Why do we use namespaces?
  • Basic differences between C# and Visual Basic namespaces
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools

A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools - view details
This video shows you several websites and free tools that happen to be favorites of one of our authors, Scott Whigham. All of the tools and Visual studio add-in suggestions covered are free and you can also find other freebies on many of the websites. Scott's favorite freebie in included (hint: Moon Unit) as well as a few websites that can help your Visual Studio productivity.
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt 4. - Nesting Namespaces and Organizing Your Classes and Code

Pt 4. - Nesting Namespaces and Organizing Your Classes and Code - view details
��This video shows namespace clashes, more on organizing code, and shows you how to use the C# using statement and the VB Imports statement to reference namespaces. You'll see both VB.NET and C# code for managing namespaces.

Highlights from this video:
  • Imports vs. using for declaring namespace references in .NET
  • Adding references to assemblies from a VS project
  • How Intellisense works with namespaces
  • Icons of the Intellisense
  • Multiple techniques for resolving namespace naming clashes
  • Using aliases such as
    • using as = AssemblyName;
    • Imports as = AssemblyName
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: Pt. 1 - Namespaces: An Introduction to Namespaces in .NET

Pt. 1 - Namespaces: An Introduction to Namespaces in .NET - view details
This video, part one in a five-part series, helps you understand what a namespace is, where they are used, and helps you get a foothold on the concept of how to organize your code using namespaces. After watching this series, you will have a much more solid foundation of how object oriented programs are arranged/built.

Highlights from this video:
  • What is a namespace?
  • Where do you use namespaces?
  • Discussions of the System namespace and how the .NET Framework uses it
  • Why do we use namespaces?
  • Basic differences between C# and Visual Basic namespaces
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video shows you to build a few assemblies using C# and VB.NET to understand how namespaces work in both languages. You'll learn about default namespaces and root namespaces as well as how to change the default namespaces.

Highlights from this video:
  • Using the Class View to see your namespace heirarchy
  • Understanding the various property, class and namespace icons in the Visual Studio
  • How to make vertically tabbed documents in Visual Studio
  • How to change a Visual Basic root namespace
  • How to change the default namespace of a C# application
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 8:35 AM  

New Visual Basic Video Tutorial: A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools

A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools - view details
This video shows you several websites and free tools that happen to be favorites of one of our authors, Scott Whigham. All of the tools and Visual studio add-in suggestions covered are free and you can also find other freebies on many of the websites. Scott's favorite freebie in included (hint: Moon Unit) as well as a few websites that can help your Visual Studio productivity.
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 6 - Finalizing the Script Component as a Source Data Flow and How to Use Script Components as a Destination

Pt. 6 - Finalizing the Script Component as a Source Data Flow and How to Use Script Components as a Destination - view details
Phew! Finally - the Visual Basic code is finished and we are ready to parse the strings and write out the data to the destination. This video finishes our demo of using the Script Component as a Source and, after that his complete, Scott Whigham (our author), talks to you about final thoughts on when to use the Script Component and using the Script Component as a Destination.
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: Transform data Task

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 6 - Configuring the Standby Server for READ ONLY / STANDBY Access

Pt. 6 - Configuring the Standby Server for READ ONLY / STANDBY Access - view details
Part six shows you how you can configure your standby server for data access using what is called STANDBY recovery mode.

Highlights from this video:
  • How to make your standby server a reporting database
  • Best practices for using log shipping and synchronization schedules
  • How often should you synchronize?
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - Log Shipping Concepts, Architecture and Requirements

Pt. 2 - Log Shipping Concepts, Architecture and Requirements - view details
Part two in our SQL Server log shipping tutorial series discusses the concepts and strategies of log shipping including:
  • Requirements for implementing log shipping
  • Basics of log shipping: how synchronizations work
  • The process and architecture of how log shipping works
  • NO RECOVERY mode (sometimes called NORECOVERY) and STANDBY mode
  • How failover works in log shipping9
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 8 - Log Shipping Security: Credentials, Jobs, Proxy Accounts, Login SIDs and More

Pt. 8 - Log Shipping Security: Credentials, Jobs, Proxy Accounts, Login SIDs and More - view details
Disaster recovery is not easy and this video proves it! This video talks about how to assign/change security for your log shipping.

Highlights from this video:
  • Why the SQL Server Agent's service account matters
  • Creating and using credentials for security
  • How proxies work with credentials to give you the ability to run jobs as a specificed Windows account
  • Why directory/folder security is so important
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Why Use Log Shipping? Pros/Cons of Log Shipping and Mirroring/Clustering

Pt. 3 - Why Use Log Shipping? Pros/Cons of Log Shipping and Mirroring/Clustering - view details
Part three focuses on the final lecture bits before we start with the demo and helps you understand the Big Picture of Log Shipping.

Highlights from this video:
  • Why do we need to use Log Shipping?
  • How is log shipping different from clustering and database mirroring?
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - Configuring the Standby Server for NORECOVERY and Using a Monitor Server

Pt. 5 - Configuring the Standby Server for NORECOVERY and Using a Monitor Server - view details
Part five shows you how to configure a SQL Server standby server using the NO RECOVERY mode. Also in this video is a discussion of how to configure the monitor server.

Highlights from this video:
  • NORECOVERY mode and how this can affect applications
  • Configuring synchronization schedules
  • Best Practices for configuring high volume log shipping
  • How to view the staus of log shipping
  • Troubleshooting a log shipping problem
  • Requirements for log shipping
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 7 - How to Failover Your Log Shipped Database to the Standby Server

Pt. 7 - How to Failover Your Log Shipped Database to the Standby Server - view details
Something bad - really bad - has happened and it's now time to fail over to the standby server. How do you do it? What's the process?

Highlights from this video:
  • How to manually failover
  • How to fail back
  • Concepts of failover
  • How to achieve point in time recovery
  • Best practices for Log shipping
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - How to Set Up Log Shipping Using SQL Server Management Studio's Properties Window

Pt. 4 - How to Set Up Log Shipping Using SQL Server Management Studio's Properties Window - view details
Finally - the lecture is finished and it's time to actually get your hands dirty by creating your first log shipping database.

Highlights from this video:
  • Using the SSMS tool to create and manage log shipping
  • Explanations of what tools you will use to manage log shipping
  • Setting up primary (a.k.a. the production) database for log shipping
  • Best practices for remote locations
  • Security concerns regarding proxies, credentials and the SQL Server Agent Service account
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - An Introduction to Log Shipping in SQL Server 2005

Pt. 1 - An Introduction to Log Shipping in SQL Server 2005 - view details
Log shipping has been around as long as disaster recovery has been a topic. Log shipping (sometimes called setting up a warm standby server) is a simple process that can be written by hand (you 'roll your own') using stored procedures and SQL Server jobs.

This video talks about how log shipping works as well as covering the basic terms and concepts of log shipping.

Highlights from this video:
  • How log shipping can be a disaster recovery (DR) technique
  • How log shipping is different from (and similar to) Database Mirroring and SQL clustering
  • Primary servers, Monitor Servers, and Standby Servers
  • The goals of log shipping
  • How does log shipping work in SQL Server 2005?
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: standby servers, warm standby servers, disaster recovery, clusters, witness

posted by Scott Whigham @ 4:35 AM  

Friday, June 29, 2007

New Visual C# Video Tutorial: Pt. 5 - .NET Namespace Best Practices and Do's and Don'ts

Pt. 5 - .NET Namespace Best Practices and Do's and Don'ts - view details
This video is just a collection of tips for using namespaces in your applications: do's and don'ts, assembly best practices, namespace best practices and more.

Highlights from this video:
  • Coding standard suggestions
  • Things not to do when organizing your code
  • Visual Basic tips for changing the root namespace
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 10:47 AM  

New Visual Basic Video Tutorial: Pt. 5 - .NET Namespace Best Practices and Do's and Don'ts

Pt. 5 - .NET Namespace Best Practices and Do's and Don'ts - view details
This video is just a collection of tips for using namespaces in your applications: do's and don'ts, assembly best practices, namespace best practices and more.

Highlights from this video:
  • Coding standard suggestions
  • Things not to do when organizing your code
  • Visual Basic tips for changing the root namespace
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 10:47 AM  

New Visual Basic Video Tutorial: Pt 4. - Nesting Namespaces and Organizing Your Classes and Code

Pt 4. - Nesting Namespaces and Organizing Your Classes and Code - view details
��This video shows namespace clashes, more on organizing code, and shows you how to use the C# using statement and the VB Imports statement to reference namespaces. You'll see both VB.NET and C# code for managing namespaces.

Highlights from this video:
  • Imports vs. using for declaring namespace references in .NET
  • Adding references to assemblies from a VS project
  • How Intellisense works with namespaces
  • Icons of the Intellisense
  • Multiple techniques for resolving namespace naming clashes
  • Using aliases such as
    • using as = AssemblyName;
    • Imports as = AssemblyName
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 10:46 AM  

New Visual C# Video Tutorial: Pt 4. - Nesting Namespaces and Organizing Your Classes and Code

Pt 4. - Nesting Namespaces and Organizing Your Classes and Code - view details
��This video shows namespace clashes, more on organizing code, and shows you how to use the C# using statement and the VB Imports statement to reference namespaces. You'll see both VB.NET and C# code for managing namespaces.

Highlights from this video:
  • Imports vs. using for declaring namespace references in .NET
  • Adding references to assemblies from a VS project
  • How Intellisense works with namespaces
  • Icons of the Intellisense
  • Multiple techniques for resolving namespace naming clashes
  • Using aliases such as
    • using as = AssemblyName;
    • Imports as = AssemblyName
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 10:46 AM  

New Visual Basic Video Tutorial: Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video continues the discussion of the various differences (and similarities) between Visual Basic and C# namespaces and how the Visual Studio 2005 IDE works with namespaces. You'll learn about hierarchies and even naming clashes in this video.

Highlights from this video:
  • Nesting namespaces in C#
  • Nesting namespaces in VB.NET
  • Deciding between MyNamespace.AnotherNamespace and nesting namespaces declaratively
  • Common ways to refactor namespaces
  • Using surround with C#
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 9:26 AM  

New Visual C# Video Tutorial: Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 3 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video continues the discussion of the various differences (and similarities) between Visual Basic and C# namespaces and how the Visual Studio 2005 IDE works with namespaces. You'll learn about hierarchies and even naming clashes in this video.

Highlights from this video:
  • Nesting namespaces in C#
  • Nesting namespaces in VB.NET
  • Deciding between MyNamespace.AnotherNamespace and nesting namespaces declaratively
  • Common ways to refactor namespaces
  • Using surround with C#
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 9:26 AM  

New Visual Basic Video Tutorial: Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video shows you to build a few assemblies using C# and VB.NET to understand how namespaces work in both languages. You'll learn about default namespaces and root namespaces as well as how to change the default namespaces.

Highlights from this video:
  • Using the Class View to see your namespace heirarchy
  • Understanding the various property, class and namespace icons in the Visual Studio
  • How to make vertically tabbed documents in Visual Studio
  • How to change a Visual Basic root namespace
  • How to change the default namespace of a C# application
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 9:23 AM  

New Visual C# Video Tutorial: Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces

Pt. 2 - Comparing C# and Visual Basic Namespaces: Default and Root namespaces - view details
This video shows you to build a few assemblies using C# and VB.NET to understand how namespaces work in both languages. You'll learn about default namespaces and root namespaces as well as how to change the default namespaces.

Highlights from this video:
  • Using the Class View to see your namespace heirarchy
  • Understanding the various property, class and namespace icons in the Visual Studio
  • How to make vertically tabbed documents in Visual Studio
  • How to change a Visual Basic root namespace
  • How to change the default namespace of a C# application
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 9:22 AM  

New Visual Basic Video Tutorial: Pt. 1 - Namespaces: An Introduction to Namespaces in .NET

Pt. 1 - Namespaces: An Introduction to Namespaces in .NET - view details
This video, part one in a five-part series, helps you understand what a namespace is, where they are used, and helps you get a foothold on the concept of how to organize your code using namespaces. After watching this series, you will have a much more solid foundation of how object oriented programs are arranged/built.

Highlights from this video:
  • What is a namespace?
  • Where do you use namespaces?
  • Discussions of the System namespace and how the .NET Framework uses it
  • Why do we use namespaces?
  • Basic differences between C# and Visual Basic namespaces
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 9:18 AM  

New Visual C# Video Tutorial: Pt. 1 - Namespaces: An Introduction to Namespaces in .NET

Pt. 1 - Namespaces: An Introduction to Namespaces in .NET - view details
This video, part one in a five-part series, helps you understand what a namespace is, where they are used, and helps you get a foothold on the concept of how to organize your code using namespaces. After watching this series, you will have a much more solid foundation of how object oriented programs are arranged/built.

Highlights from this video:
  • What is a namespace?
  • Where do you use namespaces?
  • Discussions of the System namespace and how the .NET Framework uses it
  • Why do we use namespaces?
  • Basic differences between C# and Visual Basic namespaces
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: ooad, object oriented analysis and design

posted by Scott Whigham @ 9:18 AM  

New Visual Basic Video Tutorial: A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools

A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools - view details
This video shows you several websites and free tools that happen to be favorites of one of our authors, Scott Whigham. All of the tools and Visual studio add-in suggestions covered are free and you can also find other freebies on many of the websites. Scott's favorite freebie in included (hint: Moon Unit) as well as a few websites that can help your Visual Studio productivity.
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 9:08 AM  

New Visual C# Video Tutorial: A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools

A Quick Look at a Few Free Visual Studio 2005 Add-Ins and Tools - view details
This video shows you several websites and free tools that happen to be favorites of one of our authors, Scott Whigham. All of the tools and Visual studio add-in suggestions covered are free and you can also find other freebies on many of the websites. Scott's favorite freebie in included (hint: Moon Unit) as well as a few websites that can help your Visual Studio productivity.
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 9:07 AM  

New SQL Server Integration Services Video Tutorial: Pt. 4 - Using a Script Component as a Source Connection

Pt. 4 - Using a Script Component as a Source Connection - view details
This video talks about when you would need to use a Script Component as a Data Source in a Data Flow task. Need to process unusual text files or text files with multiple delimiters with SSIS and use them as a Data Source? The Script Component is perfect!

Highlights from this video:
  • Reading .INI files as relational data
  • Understanding the Connection Manager tab in the Script Component
  • Using Me.Connections to access connections
  • Best Practices for using Output and Input column names
  • Using <Output Name>Buffer.AddRow()
  • Accessing row properties in Visual Basic .NET
  • Writing VB.NET code to add rows to the output
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: Transform data Task

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - An Intro to Using the Script Component In a Transformation

Pt. 1 - An Intro to Using the Script Component In a Transformation - view details
The Script Component is a wonderful addition to SSIS and allows you to do transforms, source and destination components all in .NET - you can't get much more flexible that that! This video helps you understand what the Script Component is and shows you how to begin using the Script Component in a Data Flow Task transformation. The Script Component feature of SSIS is perhaps the most flexible of all the tasks/transformations in SSIS. Drag a Data Flow task onto your SSIS Designer surface and then add a Script Component to your Data Flow container. Notice how it can be either a Source, Destination or Transformation? It is clearly very flexible! But, with all that flexibility comes a price: complexity. Newbies have a particularly tough time understanding when to use the Script Component or another task. Even old-timers (that's folks with lots of DTS experience and who are used to using ActiveX/Active X Script transformations in their Transform Data Tasks) often struggle trying to figure out the best approach to solving a problem with the Script Component!

Highlights from this video:
  • Using the Script Component in your SSIS packages
  • What can you do with a Script Component?
  • When should I use the Script Component?
  • How do I use the Script component in a transformation?
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: Transform data Task

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 5 - Customizing the Script Component to be a Data Source

Pt. 5 - Customizing the Script Component to be a Data Source - view details
This video continues the VB.NET coding for creating our Script Component and making it a data source. You learn how to open the text file, read a line, and make a decision as to whether or not the line's data should be written to the destination.

Highlights from this video:
  • How to read a text file in Visual Basic
  • How Peek() works
  • Using the StreamReader, File and String classes
  • How to access connection manager properties (such as Me.Connections..ConnectionString)
  • How to use a MessageBox in SSIS
  • Using ReadLine() to read a line of text in your text file
  • How to notify SSIS that you are at the end of the Source rowset with EndOfRowSet()
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: EndOfRowSet

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 2 - Using a Script Component in a Data Flow Task Transformation

Pt. 2 - Using a Script Component in a Data Flow Task Transformation - view details
Picking up from the last video, this video shows you how to add the Script Component to your Data Flow Task. You'll learn how to:
  • Add the Script Component
  • Common errors/pitfalls to avoid with Data Flow and the Script Component
  • Input columns and Output columns in the Script Component
  • Understanding the screens of the Script Component: Input and Output, Script
  • A Visual Studio bug is found :)
  • Mapping data types (DT_STR)
  • How the script works: ProcessInputRow and Input0ProcessInputRow + Input0Buffer
  • How to assign the value of your Output columns via Visual Basic .NET
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: Transform data Task

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - Customizing the Script Component Transformation with VB.NET

Pt. 3 - Customizing the Script Component Transformation with VB.NET - view details
This video focuses on editing your Visual Basic script (in the VSA editor) to define your transformations are. You'll use the .NET Framework's string manipulation capabilities to split a single column into two output columns.

Highlights from this video:
  • Using char arrays to store valid delimiters
  • LastIndexOf vs. LastIndexOfAny
  • Using Row.Property and understanding how Row properties are set
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: Transform data Task

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 6 - Report Security and Integrating Reports with ASP.NET, C# and Visual Basic

Pt. 6 - Report Security and Integrating Reports with ASP.NET, C# and Visual Basic - view details
Our final video, part six, is about how security is implemented in SQL Server Reporting Services with a finish on how to integrate Reporting Services reports with the Visual Studio using the Report Viewer Control.

Highlights from this video:
  • Integrating reports with C#, Visual Basic (WinForm/ASP.NET) applications using the Report Viewer Control
  • How roles - system and user-defined - work in Reporting Services
  • How are folders implemented in Reporting Services?
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

Thursday, June 28, 2007

New SQL Server Integration Services Video Tutorial: Pt. 6 - Finalizing the Script Component as a Source Data Flow and How to Use Script Components as a Destination

Pt. 6 - Finalizing the Script Component as a Source Data Flow and How to Use Script Components as a Destination - view details
Phew! Finally - the Visual Basic code is finished and we are ready to parse the strings and write out the data to the destination. This video finishes our demo of using the Script Component as a Source and, after that his complete, Scott Whigham (our author), talks to you about final thoughts on when to use the Script Component and using the Script Component as a Destination.
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: Transform data Task

posted by Scott Whigham @ 9:33 AM  

New SQL Server Integration Services Video Tutorial: Pt. 5 - Customizing the Script Component to be a Data Source

Pt. 5 - Customizing the Script Component to be a Data Source - view details
This video continues the VB.NET coding for creating our Script Component and making it a data source. You learn how to open the text file, read a line, and make a decision as to whether or not the line's data should be written to the destination.

Highlights from this video:
  • How to read a text file in Visual Basic
  • How Peek() works
  • Using the StreamReader, File and String classes
  • How to access connection manager properties (such as Me.Connections..ConnectionString)
  • How to use a MessageBox in SSIS
  • Using ReadLine() to read a line of text in your text file
  • How to notify SSIS that you are at the end of the Source rowset with EndOfRowSet()
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: EndOfRowSet

posted by Scott Whigham @ 9:30 AM  

New SQL Server Integration Services Video Tutorial: Pt. 4 - Using a Script Component as a Source Connection

Pt. 4 - Using a Script Component as a Source Connection - view details
This video talks about when you would need to use a Script Component as a Data Source in a Data Flow task. Need to process unusual text files or text files with multiple delimiters with SSIS and use them as a Data Source? The Script Component is perfect!

Highlights from this video:
  • Reading .INI files as relational data
  • Understanding the Connection Manager tab in the Script Component
  • Using Me.Connections to access connections
  • Best Practices for using Output and Input column names
  • Using <Output Name>Buffer.AddRow()
  • Accessing row properties in Visual Basic .NET
  • Writing VB.NET code to add rows to the output
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: Transform data Task

posted by Scott Whigham @ 9:26 AM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - Customizing the Script Component Transformation with VB.NET

Pt. 3 - Customizing the Script Component Transformation with VB.NET - view details
This video focuses on editing your Visual Basic script (in the VSA editor) to define your transformations are. You'll use the .NET Framework's string manipulation capabilities to split a single column into two output columns.

Highlights from this video:
  • Using char arrays to store valid delimiters
  • LastIndexOf vs. LastIndexOfAny
  • Using Row.Property and understanding how Row properties are set
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: Transform data Task

posted by Scott Whigham @ 9:23 AM  

New SQL Server Integration Services Video Tutorial: Pt. 2 - Using a Script Component in a Data Flow Task Transformation

Pt. 2 - Using a Script Component in a Data Flow Task Transformation - view details
Picking up from the last video, this video shows you how to add the Script Component to your Data Flow Task. You'll learn how to:
  • Add the Script Component
  • Common errors/pitfalls to avoid with Data Flow and the Script Component
  • Input columns and Output columns in the Script Component
  • Understanding the screens of the Script Component: Input and Output, Script
  • A Visual Studio bug is found :)
  • Mapping data types (DT_STR)
  • How the script works: ProcessInputRow and Input0ProcessInputRow + Input0Buffer
  • How to assign the value of your Output columns via Visual Basic .NET
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: Transform data Task

posted by Scott Whigham @ 9:20 AM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - An Intro to Using the Script Component In a Transformation

Pt. 1 - An Intro to Using the Script Component In a Transformation - view details
The Script Component is a wonderful addition to SSIS and allows you to do transforms, source and destination components all in .NET - you can't get much more flexible that that! This video helps you understand what the Script Component is and shows you how to begin using the Script Component in a Data Flow Task transformation. The Script Component feature of SSIS is perhaps the most flexible of all the tasks/transformations in SSIS. Drag a Data Flow task onto your SSIS Designer surface and then add a Script Component to your Data Flow container. Notice how it can be either a Source, Destination or Transformation? It is clearly very flexible! But, with all that flexibility comes a price: complexity. Newbies have a particularly tough time understanding when to use the Script Component or another task. Even old-timers (that's folks with lots of DTS experience and who are used to using ActiveX/Active X Script transformations in their Transform Data Tasks) often struggle trying to figure out the best approach to solving a problem with the Script Component!

Highlights from this video:
  • Using the Script Component in your SSIS packages
  • What can you do with a Script Component?
  • When should I use the Script Component?
  • How do I use the Script component in a transformation?
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: Transform data Task

posted by Scott Whigham @ 9:16 AM  

Wednesday, June 27, 2007

New Reporting Services Video Tutorial: Pt. 5 - How to Author and Deploy Reports

Pt. 5 - How to Author and Deploy Reports - view details
Now that you've seen the basics - the architecture, the terms, the definitions - it's time to create and deploy reports. This video shows you the basics of report authorship (including which tools you can use to create a report) as well as how deployment works.

Highlights from this video:
  • What does an .RDL file look like?
  • Understanding the basics of report deployment
  • Previewing reports vs. deploying reports
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 4 - SQL Server Reporting Services Terms and Definitions (Glossary)

Pt. 4 - SQL Server Reporting Services Terms and Definitions (Glossary) - view details
Further examination of SSRS requires a solid understand of the various terms (such as the 'Report Server'). This video takes you through topics like:
  • RDL files
  • Data Sources (shared and private)
  • Authoring
  • Deployment
  • Management (Reporting)
  • Ad Hoc reporting (ad-hoc)
  • Report Models
  • How deployment works
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: shared data sources, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginni

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - An Introduction to SQL Server Reporting Services

Pt. 1 - An Introduction to SQL Server Reporting Services - view details
This video, part one in a six-part series, talks about what SQL Server Reporting Services (SSRS) is and designed for the absolute beginner - someone who wants a high-level overview of Reporting Services. If you want to get a solid Technology Overview of Reporting Services, this is it.

Highlights from this video:
  • Concepts of Server-Based Reporting
  • Where is the report stored?
  • What are .rdl files?
  • Data sources (OLE-DB, ODBC, XML)
  • Licensing options
  • Types of reports available
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 3 - SQL Server Reporting Services Architecture

Pt. 3 - SQL Server Reporting Services Architecture - view details
This video talks about SSRS architecture including Report Servers, Report Manager, SQL Server database, how SQL Server is implemented as an XML web service and more.

Highlights from this video:
  • How SSRS interacts with IIS (Internet Information Services - the Windows web server)
  • Where SSRS stores security, report definitions and cached report data
  • Tools to create reports
  • What can be a data source?
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: , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - SQL Server Reporting Services Licensing and Editions

Pt. 2 - SQL Server Reporting Services Licensing and Editions - view details
This video continues where Part 1 left off: SQL Server Reporting Services licensing. Want to know what editions of SQL Server Reporting Services (SSRS) are available? What about how SSRS is licensed? This video is for you!

Highlights from this video:
  • Enterprise, Standard, Developer, Express, and Workgroup Editions
  • How SQL Server licensing works
  • CPU vs. Client Access Licenses (CALs)
  • Scale-out reporting 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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Using ADSI Editor to Track Down Atrribute Name for Schema Modifications or Scripting

Using ADSI Editor to Track Down Atrribute Name for Schema Modifications or Scripting - view details
If you're making schema changes or you're trying to write a VB Script (or some other automation utility that requires you to know the interfaces of the Active Directory), one of the tools you'll need to use is a tool called ADSI Edit. This video shows you all about using ADSI Edit including:
  • Installing and configuring ADSIEdit
  • Best Practices for using ADSI Edit
  • Using Active Directory Users and Computers to identify templated parameters
  • Using CN= to locate params
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: editing script files

posted by Scott Whigham @ 4:35 AM  

Tuesday, June 26, 2007

New Reporting Services Video Tutorial: Pt. 6 - Report Security and Integrating Reports with ASP.NET, C# and Visual Basic

Pt. 6 - Report Security and Integrating Reports with ASP.NET, C# and Visual Basic - view details
Our final video, part six, is about how security is implemented in SQL Server Reporting Services with a finish on how to integrate Reporting Services reports with the Visual Studio using the Report Viewer Control.

Highlights from this video:
  • Integrating reports with C#, Visual Basic (WinForm/ASP.NET) applications using the Report Viewer Control
  • How roles - system and user-defined - work in Reporting Services
  • How are folders implemented in Reporting Services?
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:10 PM  

New Reporting Services Video Tutorial: Pt. 5 - How to Author and Deploy Reports

Pt. 5 - How to Author and Deploy Reports - view details
Now that you've seen the basics - the architecture, the terms, the definitions - it's time to create and deploy reports. This video shows you the basics of report authorship (including which tools you can use to create a report) as well as how deployment works.

Highlights from this video:
  • What does an .RDL file look like?
  • Understanding the basics of report deployment
  • Previewing reports vs. deploying reports
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:06 PM  

New Reporting Services Video Tutorial: Pt. 4 - SQL Server Reporting Services Terms and Definitions (Glossary)

Pt. 4 - SQL Server Reporting Services Terms and Definitions (Glossary) - view details
Further examination of SSRS requires a solid understand of the various terms (such as the 'Report Server'). This video takes you through topics like:
  • RDL files
  • Data Sources (shared and private)
  • Authoring
  • Deployment
  • Management (Reporting)
  • Ad Hoc reporting (ad-hoc)
  • Report Models
  • How deployment works
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: shared data sources, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginni

posted by Scott Whigham @ 5:04 PM  

New Reporting Services Video Tutorial: Pt. 3 - SQL Server Reporting Services Architecture

Pt. 3 - SQL Server Reporting Services Architecture - view details
This video talks about SSRS architecture including Report Servers, Report Manager, SQL Server database, how SQL Server is implemented as an XML web service and more.

Highlights from this video:
  • How SSRS interacts with IIS (Internet Information Services - the Windows web server)
  • Where SSRS stores security, report definitions and cached report data
  • Tools to create reports
  • What can be a data source?
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: , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:00 PM  

New Reporting Services Video Tutorial: Pt. 2 - SQL Server Reporting Services Licensing and Editions

Pt. 2 - SQL Server Reporting Services Licensing and Editions - view details
This video continues where Part 1 left off: SQL Server Reporting Services licensing. Want to know what editions of SQL Server Reporting Services (SSRS) are available? What about how SSRS is licensed? This video is for you!

Highlights from this video:
  • Enterprise, Standard, Developer, Express, and Workgroup Editions
  • How SQL Server licensing works
  • CPU vs. Client Access Licenses (CALs)
  • Scale-out reporting 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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:57 PM  

New Reporting Services Video Tutorial: Pt.. 1 - An Introduction to SQL Server Reporting Services

Pt.. 1 - An Introduction to SQL Server Reporting Services - view details
This video, part one in a six-part series, talks about what SQL Server Reporting Services (SSRS) is and designed for the absolute beginner - someone who wants a high-level overview of Reporting Services. If you want to get a solid Technology Overview of Reporting Services, this is it.

Highlights from this video:
  • Concepts of Server-Based Reporting
  • Where is the report stored?
  • What are .rdl files?
  • Data sources (OLE-DB, ODBC, XML)
  • Licensing options
  • Types of reports available
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:52 PM  

Monday, June 25, 2007

New SQL Server 2005 Video Tutorial: Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row?

Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row? - view details
This is the fifth video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Reviewing Ghost Records
  • Introduction and definition of m_ghostRecCnt
  • Introduction and explanation of Housekeeping Threads
  • Real life examples of housekeeping threads
  • Limitations when deleting records before housekeeping threads remove GhostRecords
  • Definition and explanation of correct terminology when utilizing fn_dblog() function
Renowned trainer, Scott Whigham, has completed this video series maximizing your knowledge on page splits by utilizing his years of experience and training to teach us about ghost records. 100 percent of this video is dedicated to ghost records. If you have never heard of ghost records or are just looking to freshen your memory, this is the video for you. All skill levels can understand and follow this video and will be better off for having watched it. This is an excellent conclusion to a series of already absolutely fantastic videos.

NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row?

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs

Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs - view details
This is the third video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Introduction to SQL 2000's DBCC SHOWCONTIG() function with and without TABLERESULTS
  • Proper breakdown of the IndexName utilizing the DBCC SHOWCONTIG() function
  • Extensive review of the DBCC SHOWCONTIG() function output
  • Explanation of DBCC deprecation in SQL Server 2005
  • Introduction to SQL 2005''s Dynamic Management Objects (DM''s)
  • Proper syntax for DM''s in SQL Server 2005
  • Basic introduction to DB_ID() and OBJECT_ID() functions
  • Detailed description of the DM results including but not limited to alloc_unit_type_desc,
  • index_level, page_count, record_count
  • Basic introductory definition of how clustered indexes must return data
  • Page Split definition when working with clustered indexes accompanied with real
  • world examples
  • Introduction and explanation of the following DBCC results: bpageno, m_nextPage, m_prevPage
  • Introduction to fragementation when page splits occur
  • Advanced explanation of Page Splitting
Scott Whigham teaches us how to properly utilize different functions in SQL 2000 and 2005 when working with page splits. This video really finalizes the major functions and all of the explanations for page splitting. This is an extremely easy video to following and understand. Beginners should watch this video once now and once after you have had some further experience with SQL Server to get the full aspect of what is being taught here. All who watch this video will benefit from Scott''s excellent training skills.

NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row?

Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row? - view details
This is the fifth video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Reviewing Ghost Records
  • Introduction and definition of m_ghostRecCnt
  • Introduction and explanation of Housekeeping Threads
  • Real life examples of housekeeping threads
  • Limitations when deleting records before housekeeping threads remove GhostRecords
  • Definition and explanation of correct terminology when utilizing fn_dblog() function
Renowned trainer, Scott Whigham, has completed this video series maximizing your knowledge on page splits by utilizing his years of experience and training to teach us about ghost records. 100 percent of this video is dedicated to ghost records. If you have never heard of ghost records or are just looking to freshen your memory, this is the video for you. All skill levels can understand and follow this video and will be better off for having watched it. This is an excellent conclusion to a series of already absolutely fantastic videos.

NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row?

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs

Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs - view details
This is the third video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Introduction to SQL 2000's DBCC SHOWCONTIG() function with and without TABLERESULTS
  • Proper breakdown of the IndexName utilizing the DBCC SHOWCONTIG() function
  • Extensive review of the DBCC SHOWCONTIG() function output
  • Explanation of DBCC deprecation in SQL Server 2005
  • Introduction to SQL 2005''s Dynamic Management Objects (DM''s)
  • Proper syntax for DM''s in SQL Server 2005
  • Basic introduction to DB_ID() and OBJECT_ID() functions
  • Detailed description of the DM results including but not limited to alloc_unit_type_desc,
  • index_level, page_count, record_count
  • Basic introductory definition of how clustered indexes must return data
  • Page Split definition when working with clustered indexes accompanied with real
  • world examples
  • Introduction and explanation of the following DBCC results: bpageno, m_nextPage, m_prevPage
  • Introduction to fragementation when page splits occur
  • Advanced explanation of Page Splitting
Scott Whigham teaches us how to properly utilize different functions in SQL 2000 and 2005 when working with page splits. This video really finalizes the major functions and all of the explanations for page splitting. This is an extremely easy video to following and understand. Beginners should watch this video once now and once after you have had some further experience with SQL Server to get the full aspect of what is being taught here. All who watch this video will benefit from Scott''s excellent training skills.

NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log

Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log - view details
This is the fourth video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Overview of previous videos
  • Introduction and detailed explanation of the undocumented FN_DBLOG() function
  • Introduction to proper syntax for Backing up Log files utilizing TSQL
  • Introduction to proper syntax for Backing up Database utilizing TSQL
  • Introduction to Common real world permission errors
  • Explanation of utilizing LSN''''s when using the fn_dblog() function
  • Properly reading and understanding result sets from the fn_dblog() function
  • Detailed description and explanation of correct terminology when reading the results from the fn_dblog() function
You can expect to learn a ton of information about logs and backing up the database. This video is dedicated to the fn_dblog() function. Everyone watching this video will benefit whether or not you are watching to learn about the undocumented function, you just need a refresher or even just want to compare your knowledge against a professional. Trainer, Scott Whigham does a phenomenal job again by showing us items that we literally would not have any knowledge of due to lack of documentation.

NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc)

Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc) - view details
This is the second video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Introduction and detailed explanation of the DBCC PAGE() function
  • Proper syntax while utilizing the DBCC PAGE() function
  • Explanation of the functionality of the DBCC PAGE() function
  • Basic introduction to DB_NAME() function
  • Introduction to trace flag 3604 (DBCC Page Output)
  • Introduction to DBCC TRACEON() function
  • Detailed descriptions and discussion on DBCC PAGE() function Output
  • Introduction to the use of the OBJECT_NAME() function
  • Introduction to pminlen, m_slotCnt, m_pageID, bstat, MetaDeta, m_objID, m_ghostRecCnt,
  • Page Types, Byte Length, Page Splits, m_freeCnt
  • Properly Adding new records utilizing TSQL
Trainer, Scott Whigham, introduces to us to a variety of functions and other items you will see during page splits. This is an excellent following video to start you in the right direction to show you what happens during a page split. All levels whether you are beginner, intermediate or advanced will be smarter for having watched this video. You can very easily follow this video even if you have had no experience with page splits. Beginner levels should come back and watch the video series again to get the most of out this video.

NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc)

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log

Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log - view details
This is the fourth video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Overview of previous videos
  • Introduction and detailed explanation of the undocumented FN_DBLOG() function
  • Introduction to proper syntax for Backing up Log files utilizing TSQL
  • Introduction to proper syntax for Backing up Database utilizing TSQL
  • Introduction to Common real world permission errors
  • Explanation of utilizing LSN''''s when using the fn_dblog() function
  • Properly reading and understanding result sets from the fn_dblog() function
  • Detailed description and explanation of correct terminology when reading the results from the fn_dblog() function
You can expect to learn a ton of information about logs and backing up the database. This video is dedicated to the fn_dblog() function. Everyone watching this video will benefit whether or not you are watching to learn about the undocumented function, you just need a refresher or even just want to compare your knowledge against a professional. Trainer, Scott Whigham does a phenomenal job again by showing us items that we literally would not have any knowledge of due to lack of documentation.

NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction Log

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc)

Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc) - view details
This is the second video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Introduction and detailed explanation of the DBCC PAGE() function
  • Proper syntax while utilizing the DBCC PAGE() function
  • Explanation of the functionality of the DBCC PAGE() function
  • Basic introduction to DB_NAME() function
  • Introduction to trace flag 3604 (DBCC Page Output)
  • Introduction to DBCC TRACEON() function
  • Detailed descriptions and discussion on DBCC PAGE() function Output
  • Introduction to the use of the OBJECT_NAME() function
  • Introduction to pminlen, m_slotCnt, m_pageID, bstat, MetaDeta, m_objID, m_ghostRecCnt,
  • Page Types, Byte Length, Page Splits, m_freeCnt
  • Properly Adding new records utilizing TSQL
Trainer, Scott Whigham, introduces to us to a variety of functions and other items you will see during page splits. This is an excellent following video to start you in the right direction to show you what happens during a page split. All levels whether you are beginner, intermediate or advanced will be smarter for having watched this video. You can very easily follow this video even if you have had no experience with page splits. Beginner levels should come back and watch the video series again to get the most of out this video.

NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc)

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure

Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure - view details
This is the first video of a series of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Basic Launching of SQL Server Management Studio
  • Identifying Service Pack 2
  • Proper TSQL Database Creation
  • Index Page Limitations
  • Proper TSQL Table Creation
  • Building a Clustered Index in TSQL Overview
  • Database Console Command (DBCC) function definition and functionality
  • Introduction and explanation of the DBCC IND() function
  • Proper syntax while utilizing the DBCC IND() function
  • Explanation of the functionality of the DBCC IND() function
  • Properly utilizing the INSERT statement in TSQL
  • Discussion about Page Types
  • SQL Script accompanies the video
Trainer, Scott Whigham, gives us an excellent start to a fantastic video series that will put you in the right direction for learning about page splits. This video will provide more information that you knew existed about the different types of functions and how, why and what happens when a page splits. This video is extremely informative and is definitely for everyone that wishes to learn at any level; beginner, intermediate and advanced users of SQL Server alike. Beginner users will want to watch the video and come back and watch it again to get the most of out it.

NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log

Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log - view details
This is the 3rd of five very excellent advanced videos detailing out specific information towards Service Brokers SQL Server.�� This video starts out with the necessary resolutions to common real life errors to previously written store procedure as well as the following
  • Basic overview of event and xml logs
  • Basic introductory overview for error 18456 Login Failed
  • Properly reading the SQL related events in the event log within the Windows Operating System
  • Introduction to proper utilization of the COUNT() statement
  • Possible Filter Addons for the previously written stored procedure
The final video in the series of three adds a phenomenal closure and addons to the stored procedures.�� Scott provides us with written and useful code that is sure to make your life easier whether you are trying to learn about writing TSQL or just would like to utilize the code for your own purposes.�� This video series is for the advanced SQL Server users. ��

NOTE: This video's description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure

Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure - view details
This is the first video of a series of 5 highly advanced and extensive videos about page splits.�� This incredible video houses a variety of some phenomenal information.�� There is some SQL Server advanced knowledge required to get the most out of this video.�� You can expect to see the following items within this video:
  • Basic Launching of SQL Server Management Studio
  • Identifying Service Pack 2
  • Proper TSQL Database Creation
  • Index Page Limitations
  • Proper TSQL Table Creation
  • Building a Clustered Index in TSQL Overview
  • Database Console Command (DBCC) function definition and functionality
  • Introduction and explanation of the DBCC IND() function
  • Proper syntax while utilizing the DBCC IND() function
  • Explanation of the functionality of the DBCC IND() function
  • Properly utilizing the INSERT statement in TSQL
  • Discussion about Page Types
  • SQL Script accompanies the video
Trainer, Scott Whigham, gives us an excellent start to a fantastic video series that will put you in the right direction for learning about page splits.�� This video will provide more information that you knew existed about the different types of functions and how, why and what happens when a page splits.�� This video is extremely informative and is definitely for everyone that wishes to learn at any level; beginner, intermediate and advanced users of SQL Server alike.�� Beginner users will want to watch the video and come back and watch it again to get the most of out it. ��

NOTE: This description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log

Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log - view details
This is the 3rd of five very excellent advanced videos detailing out specific information towards Service Brokers SQL Server.�� This video starts out with the necessary resolutions to common real life errors to previously written store procedure as well as the following
  • Basic overview of event and xml logs
  • Basic introductory overview for error 18456 Login Failed
  • Properly reading the SQL related events in the event log within the Windows Operating System
  • Introduction to proper utilization of the COUNT() statement
  • Possible Filter Addons for the previously written stored procedure
The final video in the series of three adds a phenomenal closure and addons to the stored procedures.�� Scott provides us with written and useful code that is sure to make your life easier whether you are trying to learn about writing TSQL or just would like to utilize the code for your own purposes.�� This video series is for the advanced SQL Server users. ��

NOTE: This video's description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works

Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works - view details
This excellent step-by-step walk-thru of Scott Whighams pre-written Stored Procedure video is the second video in a series of 3.�� This is an excellent addition to this series that teaches us about an extremely complex stored procedure in non-technical explained terminology.�� A few of the highlights but definitely not limited to are as follows:
  • Introduction to properly declared variables
  • TSQL IF and ELSE statements
  • TIMEOUT Statement
  • WAITFOR Statement
  • Basic introduction to xpath and xquery
This whole video is dedicated to the masterfully written stored procedure.�� This is an advanced video therefore is perfect for the intermediate to advanced SQL SERVER users.�� You will need to know about TSQL in order to follow a lot of this video.�� If you do not know about TSQL, you can learn TSQL at TSQL Training.

NOTE: This video's description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins

Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins - view details
This is the first of three very excellent advanced videos detailing out specific information towards Service Brokers in SQL Server.�� This video starts out with an introduction to Event Notification, Service Broker, Routes, Queues and Services and proceeds on with the following:
  • Advanced creation of a logon, trapping type of a table
  • Complex script automatically provided with this video
  • Starts out with the end result prior to training
  • Proper Utilization of the Windows Event Viewer
  • Review of types of information logged in with event logging
  • HOW TO Filter Events
  • Common Error resolution when working with event logging
  • Introduction to Database Creation utilizing TSQL
  • Minor Review of SSRS ServiceAccount
  • Basic overview of table creation utilizing TSQL
  • Introduction and proper use of ENABLE_BROKER
  • ENABLE_BROKER definition and explanation
  • Basic explanation to QUEUE creation
  • Basic explanation to ROUTE and SERVICE creation
  • Intro to AUDIT_LOGIN, AUDIT_LOGIN_FAILED
  • Intro to Event Notification Creation
  • Intermediate to Advanced Explanation of the Event Notification
  • Explanation of the importance of ANSI_NULLS, QUOTED_IDENTIFIER and NOCOUNT
Trainer extraordanaire, Scott Whigham, starts another excellent series of videos to help teach us step by step exactly what we should know in order to work with Service Brokers.�� This is an advanced video and you should have some intermediate to advanced knowledge about SQL Server in order to understand and follow this video. ��

NOTE: This video's description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports

Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports - view details
This fifth video of a five video series about the newest features in Service Pack 2 (SP2) trains us on how to properly download and install the performance dashboard.�� Scott Whigham unleashes his years of knowledge and training skills when he teaches about the performance dashboard and what it can and will do for us in our SQL endeavors.�� You can expect to learn about the following in this astounding video:
  • Searching for the performance dashboard correctly
  • highlights on installation location
  • Step by step installation
  • Feature update on SQL Server SP2
  • Basic explanation of the SETUP.SQL file for the performance dashboard
  • Proper shortcut creation
  • Common frustratingn real world error preventing the performance dashboard reports from running properly
  • Proper troubleshooting of a very common and frustrating error
  • There is no resolution to this error provided in the video however the resolution to the error is to run the
  • performance_dashboard_main.rdl before you run any of the other RDL files.
This video takes you step by step through the download and installation of the performance dashboards.�� This video does have an error within it and will teach you the proper troubleshooting techniques in an attempt to rectify that error.�� You will learn everything you need to know about downloading, installing, and using the performance dashboard from this video.�� This will help and train the beginner, intermediate or any user that wishes to learn more about the performance dashboard in general. ��

NOTE: This video's description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works

Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works - view details
This excellent step-by-step walk-thru of Scott Whighams pre-written Stored Procedure video is the second video in a series of 3.�� This is an excellent addition to this series that teaches us about an extremely complex stored procedure in non-technical explained terminology.�� A few of the highlights but definitely not limited to are as follows:
  • Introduction to properly declared variables
  • TSQL IF and ELSE statements
  • TIMEOUT Statement
  • WAITFOR Statement
  • Basic introduction to xpath and xquery
This whole video is dedicated to the masterfully written stored procedure.�� This is an advanced video therefore is perfect for the intermediate to advanced SQL SERVER users.�� You will need to know about TSQL in order to follow a lot of this video.�� If you do not know about TSQL, you can learn TSQL at TSQL Training.

NOTE: This video's description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 2 - Understanding Queues, Routes, Services, and How Our Logon Stored Proc Works

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports

Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports - view details
This fifth video of a five video series about the newest features in Service Pack 2 (SP2) trains us on how to properly download and install the performance dashboard.�� Scott Whigham unleashes his years of knowledge and training skills when he teaches about the performance dashboard and what it can and will do for us in our SQL endeavors.�� You can expect to learn about the following in this astounding video:
  • Searching for the performance dashboard correctly
  • highlights on installation location
  • Step by step installation
  • Feature update on SQL Server SP2
  • Basic explanation of the SETUP.SQL file for the performance dashboard
  • Proper shortcut creation
  • Common frustratingn real world error preventing the performance dashboard reports from running properly
  • Proper troubleshooting of a very common and frustrating error
  • There is no resolution to this error provided in the video however the resolution to the error is to run the
  • performance_dashboard_main.rdl before you run any of the other RDL files.
This video takes you step by step through the download and installation of the performance dashboards.�� This video does have an error within it and will teach you the proper troubleshooting techniques in an attempt to rectify that error.�� You will learn everything you need to know about downloading, installing, and using the performance dashboard from this video.�� This will help and train the beginner, intermediate or any user that wishes to learn more about the performance dashboard in general. ��

NOTE: This video's description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports

posted by Scott Whigham @ 4:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins

Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins - view details
This is the first of three very excellent advanced videos detailing out specific information towards Service Brokers in SQL Server.�� This video starts out with an introduction to Event Notification, Service Broker, Routes, Queues and Services and proceeds on with the following:
  • Advanced creation of a logon, trapping type of a table
  • Complex script automatically provided with this video
  • Starts out with the end result prior to training
  • Proper Utilization of the Windows Event Viewer
  • Review of types of information logged in with event logging
  • HOW TO Filter Events
  • Common Error resolution when working with event logging
  • Introduction to Database Creation utilizing TSQL
  • Minor Review of SSRS ServiceAccount
  • Basic overview of table creation utilizing TSQL
  • Introduction and proper use of ENABLE_BROKER
  • ENABLE_BROKER definition and explanation
  • Basic explanation to QUEUE creation
  • Basic explanation to ROUTE and SERVICE creation
  • Intro to AUDIT_LOGIN, AUDIT_LOGIN_FAILED
  • Intro to Event Notification Creation
  • Intermediate to Advanced Explanation of the Event Notification
  • Explanation of the importance of ANSI_NULLS, QUOTED_IDENTIFIER and NOCOUNT
Trainer extraordanaire, Scott Whigham, starts another excellent series of videos to help teach us step by step exactly what we should know in order to work with Service Brokers.�� This is an advanced video and you should have some intermediate to advanced knowledge about SQL Server in order to understand and follow this video. ��

NOTE: This video's description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins

posted by Scott Whigham @ 4:35 AM  

Sunday, June 24, 2007

New ISA Server Video Tutorial: How to Install ISA Server 2006 Standard Edition

How to Install ISA Server 2006 Standard Edition - view details
This video walks you through how to setup ISA Server 2006 Standard Edition. This ISA Server tutorial walks you through setting up the Core Components as well as gives you a solid understanding of all of the options in the setup.

Highlights from this video:
  • The difference between the Typical and Custom setup options
  • The details of the Custom setup choice
  • What's the difference between ISA Server and ISA Server Management?
  • What is Advanced Logging for ISA Server?
  • Determining internal network settings
  • Suggestions for configuring Firewall Client Connections
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: firewalls, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for du

posted by Scott Whigham @ 4:35 AM  

New ISA Server Video Tutorial: Installation and Explanation of ISA Server 2006 Enterprise Edition

Installation and Explanation of ISA Server 2006 Enterprise Edition - view details
There are two different versions of ISA Server 2006: (1) Standard Edition and, (2) Enterprise Edition. This video walks you through the installation of ISA Server 2006 Enterprise Edition as well as helps you understand exactly why you should consider using the Enterprise Edition.

Highlights from this video:
  • Understanding the options asked during setup of ISA Server 2006
  • Configuring your internal network IP address ranges
  • Configuring network adapters with ISA Server
  • Encryption settings and Firewall client settings
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: installation, installing, set up, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, begi

posted by Scott Whigham @ 4:35 AM  

New ISA Server Video Tutorial: A Pre-Installation of ISA Server 2006 Discussion: Requirements and Lecture

A Pre-Installation of ISA Server 2006 Discussion: Requirements and Lecture - view details
Microsoft Internet Security and Acceleration Server (or ISA for short) 2006 requires a few things before you try to install it. This video walks you through the requirements as well as providing Best Practices for ISA Server 2006 installations.

Highlights from this video:
  • Service Pack and Operating System requirements
  • Suggested system configurations
  • How to determine system settings prior to installation
  • Configuring IP addresses and network cards (NICs) with ISA Server
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: isa 2006, firewall, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginnin

posted by Scott Whigham @ 4:35 AM  

Wednesday, June 20, 2007

New Windows 2003 Video Tutorial: TaskList, TaskKill, and Shutdown.exe - Utilities for Admins

TaskList, TaskKill, and Shutdown.exe - Utilities for Admins - view details
This video takes a look at some of the command line utilities available for returning information and/or managing remote machines: tasklist.exe, taskkill.exe and shutdown.exe in particular.

Highlights from this video:
  • How to use the shutdown utility remotely
  • TaskList.exe switches and best practices
  • Shutdown.exe switches and best practices
  • TaskKill.exe switches and best practices
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: administrative, utils, tools, software

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Create a Template User and Modify Schema to Control Copied Attributes

Create a Template User and Modify Schema to Control Copied Attributes - view details
If you're an Active Directory administrator, you often need to create new user accounts. There are two ways to do this: (1) you can just run the wizard and create the user, and (2) you can just copy an existing user account. This video shows you how to create a template user account that you can use to make life easier for yourself!

Highlights from this video:
  • Create an Active Directory template user
  • Best Practices for creating new 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: advanced administration

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Lecture on Screen Resolution

Lecture on Screen Resolution - view details
This video is really a user-level video that is meant for users - your end users on your network. This video explains what the Display Settings mean: what is video resoution? How do I determine my settings? What does everyone use? This is a great video for you to share with your end users!

Highlights from this video:
  • Howmany pixels are on the screen? How is this calculated?
  • Discussions of various settings: 1024x768, 800x600, etc
  • Why is a higher resolution better? worse?
  • DPI explained (Dots per inch)
  • Font scaling (or, Why do fonts get larger/smaller/different when I change the resolution?)
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: display settings, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning,

posted by Scott Whigham @ 4:35 AM  

Tuesday, June 19, 2007

New Windows 2003 Video Tutorial: Using ADSI Editor to Track Down Atrribute Name for Schema Modifications or Scripting

Using ADSI Editor to Track Down Atrribute Name for Schema Modifications or Scripting - view details
If you're making schema changes or you're trying to write a VB Script (or some other automation utility that requires you to know the interfaces of the Active Directory), one of the tools you'll need to use is a tool called ADSI Edit. This video shows you all about using ADSI Edit including:
  • Installing and configuring ADSIEdit
  • Best Practices for using ADSI Edit
  • Using Active Directory Users and Computers to identify templated parameters
  • Using CN= to locate params
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: editing script files

posted by Scott Whigham @ 11:25 AM  

New Windows 2003 Video Tutorial: TaskList, TaskKill, and Shutdown.exe - Utilities for Admins

TaskList, TaskKill, and Shutdown.exe - Utilities for Admins - view details
This video takes a look at some of the command line utilities available for returning information and/or managing remote machines: tasklist.exe, taskkill.exe and shutdown.exe in particular.

Highlights from this video:
  • How to use the shutdown utility remotely
  • TaskList.exe switches and best practices
  • Shutdown.exe switches and best practices
  • TaskKill.exe switches and best practices
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: administrative, utils, tools, software

posted by Scott Whigham @ 11:08 AM  

New Windows 2003 Video Tutorial: Lecture on Screen Resolution

Lecture on Screen Resolution - view details
This video is really a user-level video that is meant for users - your end users on your network. This video explains what the Display Settings mean: what is video resoution? How do I determine my settings? What does everyone use? This is a great video for you to share with your end users!

Highlights from this video:
  • Howmany pixels are on the screen? How is this calculated?
  • Discussions of various settings: 1024x768, 800x600, etc
  • Why is a higher resolution better? worse?
  • DPI explained (Dots per inch)
  • Font scaling (or, Why do fonts get larger/smaller/different when I change the resolution?)
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: display settings, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning,

posted by Scott Whigham @ 11:02 AM  

New Windows 2003 Video Tutorial: Active Directory Password Management: Creating Complex Password Policies

Active Directory Password Management: Creating Complex Password Policies - view details
Many administrators who are working on Windows 2003/2000 domains often wonder if there are Best Practices for managing passwords and/or tools that are available to enhance the Windows domain model's password management. This video shows you multiple techniques for managing password complexity and setting Best Practices.

Highlights from this video:
  • Password policies
  • Password compliance and SOX (Sarbanes Oxley)-type compliance
  • Tools for password management in Windows domains
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: passfilt pro

posted by Scott Whigham @ 8:35 AM  

New Exchange 2007/2003 Video Tutorial: Performance Tools for Exchange 2007

Performance Tools for Exchange 2007 - view details
This video talks about the performance tools found in the Exchange Toolbox (inside the Exchange Management Studio).

Highlights from this video:
  • Using System Monitor to monitor Exchange
  • Using the built-in performance monitoring tools
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: exchange management

posted by Scott Whigham @ 8:35 AM  

New Windows 2003 Video Tutorial: Control the Time/Clock Placement on the Desktop

Control the Time/Clock Placement on the Desktop - view details
A user calls you up and says, 'I can't find the clock on my desktop - where is it?' Well? Where is it? Why isn't it in the System Tray?

Did you know that you can hide the clock from the user?

Or that you can prevent the user from changing the date/time on the computer?

This video shows you exactly how to change the settings through policies that allow the user to be able to (or not) change/show the clock.
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:35 AM  

New Windows 2003 Video Tutorial: Create a Template User and Modify Schema to Control Copied Attributes

Create a Template User and Modify Schema to Control Copied Attributes - view details
If you're an Active Directory administrator, you often need to create new user accounts. There are two ways to do this: (1) you can just run the wizard and create the user, and (2) you can just copy an existing user account. This video shows you how to create a template user account that you can use to make life easier for yourself!

Highlights from this video:
  • Create an Active Directory template user
  • Best Practices for creating new 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: advanced administration

posted by Scott Whigham @ 7:22 AM  

New Windows 2003 Video Tutorial: Control the Time/Clock Placement on the Desktop

Control the Time/Clock Placement on the Desktop - view details
A user calls you up and says, 'I can't find the clock on my desktop - where is it?' Well? Where is it? Why isn't it in the System Tray?

Did you know that you can hide the clock from the user?

Or that you can prevent the user from changing the date/time on the computer?

This video shows you exactly how to change the settings through policies that allow the user to be able to (or not) change/show the clock.
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: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 7:11 AM  

Thursday, June 14, 2007

New Transact SQL Video Tutorial: Model Database - An Overview of How to Use It and When to Use It (SQL Server 2005)

Model Database - An Overview of How to Use It and When to Use It (SQL Server 2005) - view details
Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, loves to use (and talk about using) the Model database. In this video, Scott walks you through what Model is, what the "possibilities" are for using Model, and gives you a few scenarios in which you can use the Model database to solve interesting problems. As a DBA or developer you'll certainly want to know your system databases. This video helps you understand perhaps the least used of all the system databases.
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 model, system database, system db, create database

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: TempDb Database - An Overview of How it Works and When to Use It

TempDb Database - An Overview of How it Works and When to Use It - view details
Yet another excellent video in our series on SQL Server 2005's system databases, this video teaches you the ins and outs of tempdb. SQL Server guru Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through the layout of the main tables, how things have changed, working with temporary tables and table variables and more. A good video to help learn more about the SQL Server architecture.
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: system database, table variable, temp table, temp db

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Part 2 - An Overview of the AdventureWorks Database - Database Diagrams and DDL Triggers

Part 2 - An Overview of the AdventureWorks Database - Database Diagrams and DDL Triggers - view details
Continuing our series on the AdventureWorks database, Scott Whigham walks you through how to create database diagrams using AdventureWorks as well as using the DDL triggers for database-level events. A very interesting video with some exciting new SQL Server 2005 features.
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: database events, database event trigger

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: An Overview of the Northwind Database

An Overview of the Northwind Database - view details
Scott Whigham walks you through the layout of the Northwind database in this video. Northwind is used for many demos and videos throughout the site due to how easy it is to work with. This is not a long video but will serve to familiarize you with the sample database used in many of the T-SQL-based videos.

NOTE: You can download the Northwind (and Pubs) sample databases from the microsoft.com website here
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: sample database, sample db, install sample, oltp database, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Part 1 - An Overview of the AdventureWorks Database

Part 1 - An Overview of the AdventureWorks Database - view details
AdventureWorks - the "new standard" for sample databases out of Redmond. Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, is certainly a fan of this new database for certain things but also feels reservations about the complexity of AdventureWorks when it comes to using it as your primary training database. Nevertheless, this video (part 1), walks you through the layout of AdventureWorks, how the schemas are used, and shows some of the "primary" relationships between the important tables and views. This video provides a good starting point for working with AdventureWorks and understanding how the tables are related.
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: adventureworks install, sample database, sql server sample database, sql server adventure works, oltp, beginner, beginning, for

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: An Overview of the AdventureWorksDW Database

An Overview of the AdventureWorksDW Database - view details
AdventureWorksDW, Microsoft's sample data warehouse for SQL Server 2005 and Analysis Services 2005, is a robust data warehouse design. While it is robust, if you've never worked with a data warehouse, it can be quite intimidating. This video is an overview for those of you new to data warehousing, possibly new to SQL Server and/or Analysis Services, and even for users of Reporting Services. This is a loooooong video - long so that it can cover many of the important dimension tables, measures, and other information about Adventure Works Data Warehouse.
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: adventureworksdw install, sample database, sql server sample database, sql server adventure works, data warehouse, olap

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Database Diagrams - An Introduction

Database Diagrams - An Introduction - view details
All experienced SQL developers and administrators recognize that being able to "see" your database gives you great confidence in the queries you write. It helps speed up development, ensure correct queries, and remove guesswork from the development cycle (well, as much as possible). This video shows you how you can create your own visual diagrams for your SQL Server database. These diagrams can be generated and viewed in the Enterprise Manager and can even be printed over multiple pages (which you will tape together and hang on your wall) for easier visualization. If you struggle with JOINs, subqueries, or foreign keys and relationships, then you'll enjoy this video on creating ERDs (Entity Relationship Diagrams) in SQL Server
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 erd, sql database diagram, sql diagram, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 4:35 AM  

Wednesday, June 13, 2007

New Transact SQL Video Tutorial: TempDb Database - An Overview of How it Works and When to Use It

TempDb Database - An Overview of How it Works and When to Use It - view details
Yet another excellent video in our series on SQL Server 2005's system databases, this video teaches you the ins and outs of tempdb. SQL Server guru Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through the layout of the main tables, how things have changed, working with temporary tables and table variables and more. A good video to help learn more about the SQL Server architecture.
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: system database, table variable, temp table, temp db

posted by Scott Whigham @ 2:17 PM  

New Transact SQL Video Tutorial: Model Database - An Overview of How to Use It and When to Use It (SQL Server 2005)

Model Database - An Overview of How to Use It and When to Use It (SQL Server 2005) - view details
Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, loves to use (and talk about using) the Model database. In this video, Scott walks you through what Model is, what the "possibilities" are for using Model, and gives you a few scenarios in which you can use the Model database to solve interesting problems. As a DBA or developer you'll certainly want to know your system databases. This video helps you understand perhaps the least used of all the system databases.
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 model, system database, system db, create database

posted by Scott Whigham @ 2:17 PM  

New Transact SQL Video Tutorial: An Overview of the Northwind Database

An Overview of the Northwind Database - view details
Scott Whigham walks you through the layout of the Northwind database in this video. Northwind is used for many demos and videos throughout the site due to how easy it is to work with. This is not a long video but will serve to familiarize you with the sample database used in many of the T-SQL-based videos.

NOTE: You can download the Northwind (and Pubs) sample databases from the microsoft.com website here
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: sample database, sample db, install sample, oltp database, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 2:17 PM  

New Transact SQL Video Tutorial: An Overview of the AdventureWorksDW Database

An Overview of the AdventureWorksDW Database - view details
AdventureWorksDW, Microsoft's sample data warehouse for SQL Server 2005 and Analysis Services 2005, is a robust data warehouse design. While it is robust, if you've never worked with a data warehouse, it can be quite intimidating. This video is an overview for those of you new to data warehousing, possibly new to SQL Server and/or Analysis Services, and even for users of Reporting Services. This is a loooooong video - long so that it can cover many of the important dimension tables, measures, and other information about Adventure Works Data Warehouse.
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: adventureworksdw install, sample database, sql server sample database, sql server adventure works, data warehouse, olap

posted by Scott Whigham @ 2:17 PM  

New Transact SQL Video Tutorial: Database Diagrams - An Introduction

Database Diagrams - An Introduction - view details
All experienced SQL developers and administrators recognize that being able to "see" your database gives you great confidence in the queries you write. It helps speed up development, ensure correct queries, and remove guesswork from the development cycle (well, as much as possible). This video shows you how you can create your own visual diagrams for your SQL Server database. These diagrams can be generated and viewed in the Enterprise Manager and can even be printed over multiple pages (which you will tape together and hang on your wall) for easier visualization. If you struggle with JOINs, subqueries, or foreign keys and relationships, then you'll enjoy this video on creating ERDs (Entity Relationship Diagrams) in SQL Server
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 erd, sql database diagram, sql diagram, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 2:16 PM  

New Exchange 2007/2003 Video Tutorial: How to Move a Mailbox to a New Database

How to Move a Mailbox to a New Database - view details
As you build more databases on your Exchange Server, you may need to move a mailbox from time to time. This video talks about:
  • When you should or would need to move a mailbox
  • Using the Exchange Management Console to move mailboxes to a new database
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: exchange management

posted by Scott Whigham @ 4:35 AM  

New Exchange 2007/2003 Video Tutorial: How to Create a New Storage Group and a New Database

How to Create a New Storage Group and a New Database - view details
Microsoft's current recommendation (Exchange 2007) for your database and storage group model is to create one storage group for each database that you build. This differs from Exchage 2003 and Exchange 2000 - so why the new recommendation and, more importantly, how can you implement this Best Practice?

Highlights from this video:
  • Adding new databases to Exchange 2007
  • Adding new Storage Groups
  • Moving to new databases
  • Assigning Storage Groups to databases
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: exchange 2007

posted by Scott Whigham @ 4:35 AM  

New Exchange 2007/2003 Video Tutorial: Enable and Test Exchange Journaling in Exchange 2007

Enable and Test Exchange Journaling in Exchange 2007 - view details
Many organizations require the ability to 'journal' messages - in other words, they want to be able to keep track of messages as they come in or go out (i.e., an audit). Some organizations even spend millions on message auditing in Exchange 2007.

Highlights from this video:
  • Setting up Journal rules
  • How journaling works in Exchange 2007
  • Best Practices for journaling and auditing in Exchange 2007
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: audits, C@, common criteria, compliance

posted by Scott Whigham @ 4:35 AM  

New Exchange 2007/2003 Video Tutorial: How to Move Your Exchange 2007 Database to a New Drive

How to Move Your Exchange 2007 Database to a New Drive - view details
As your Exchange database grows in size (or because of server configuration changes), you may need to add some new disks to your Exchange Server and then move your databases to these new drives.

Highlights from this video:
  • How to move Exchange 2007 databases
  • Initializing disks
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: exchange management, raid, raid arrays

posted by Scott Whigham @ 4:35 AM  

New ISA Server Video Tutorial: How to Configure ISA Server to Send Scheduled Reports

How to Configure ISA Server to Send Scheduled Reports - view details
You can configure ISA Server reports to be automatically generated on a daily, weekly, or monthly basis. Why would want to do this? You'll often want to review usage patterns, look for problems, and even give reports to upper-level executives and management (and we know how they love charts and graphs). This video shows you how to customize the reports, manage the schedules, and handle delivery options.

Highlights from this video:
  • Setting up Report Job Schedules
  • Determining what each of the Report Content settings means
  • How to email reports
  • Array Reports
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: reporting, monitoring, analysis

posted by Scott Whigham @ 4:35 AM  

New Exchange 2007/2003 Video Tutorial: Create and Test a Transport Rule

Create and Test a Transport Rule - view details
One of the new capabilities in Exchange 2007 is the ability to create what is called a 'Transport Rule'. In the past, users might have done this in their mail clients - have you ever created a 'rule' in Outlook to move messages to a certain folder? Well, in Exchange 2007, you can create server-based rules!

Highlights from this video:
  • Creating your first transport rules
  • How transport rules are similar to and different from Outlook rules
  • Defining rule conditions
  • Actions, exceptions, and more
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: outlook 2000, outlook 2003, outlook 2007 rules, rule-based wizard

posted by Scott Whigham @ 4:35 AM  

Tuesday, June 12, 2007

New Exchange 2007/2003 Video Tutorial: Performance Tools for Exchange 2007

Performance Tools for Exchange 2007 - view details
This video talks about the performance tools found in the Exchange Toolbox (inside the Exchange Management Studio).

Highlights from this video:
  • Using System Monitor to monitor Exchange
  • Using the built-in performance monitoring tools
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: exchange management

posted by Scott Whigham @ 11:17 AM  

New Exchange 2007/2003 Video Tutorial: How to Move a Mailbox to a New Database

How to Move a Mailbox to a New Database - view details
As you build more databases on your Exchange Server, you may need to move a mailbox from time to time. This video talks about:
  • When you should or would need to move a mailbox
  • Using the Exchange Management Console to move mailboxes to a new database
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: exchange management

posted by Scott Whigham @ 11:15 AM  

New Exchange 2007/2003 Video Tutorial: How to Move Your Exchange 2007 Database to a New Drive

How to Move Your Exchange 2007 Database to a New Drive - view details
As your Exchange database grows in size (or because of server configuration changes), you may need to add some new disks to your Exchange Server and then move your databases to these new drives.

Highlights from this video:
  • How to move Exchange 2007 databases
  • Initializing disks
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: exchange management, raid, raid arrays

posted by Scott Whigham @ 11:13 AM  

New Exchange 2007/2003 Video Tutorial: Enable and Test Exchange Journaling in Exchange 2007

Enable and Test Exchange Journaling in Exchange 2007 - view details
Many organizations require the ability to 'journal' messages - in other words, they want to be able to keep track of messages as they come in or go out (i.e., an audit). Some organizations even spend millions on message auditing in Exchange 2007.

Highlights from this video:
  • Setting up Journal rules
  • How journaling works in Exchange 2007
  • Best Practices for journaling and auditing in Exchange 2007
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: audits, C@, common criteria, compliance

posted by Scott Whigham @ 11:11 AM  

New Exchange 2007/2003 Video Tutorial: How to Create a New Storage Group and a New Database

How to Create a New Storage Group and a New Database - view details
Microsoft's current recommendation (Exchange 2007) for your database and storage group model is to create one storage group for each database that you build. This differs from Exchage 2003 and Exchange 2000 - so why the new recommendation and, more importantly, how can you implement this Best Practice?

Highlights from this video:
  • Adding new databases to Exchange 2007
  • Adding new Storage Groups
  • Moving to new databases
  • Assigning Storage Groups to databases
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: exchange 2007

posted by Scott Whigham @ 11:07 AM  

New Exchange 2007/2003 Video Tutorial: Create and Test a Transport Rule

Create and Test a Transport Rule - view details
One of the new capabilities in Exchange 2007 is the ability to create what is called a 'Transport Rule'. In the past, users might have done this in their mail clients - have you ever created a 'rule' in Outlook to move messages to a certain folder? Well, in Exchange 2007, you can create server-based rules!

Highlights from this video:
  • Creating your first transport rules
  • How transport rules are similar to and different from Outlook rules
  • Defining rule conditions
  • Actions, exceptions, and more
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: outlook 2000, outlook 2003, outlook 2007 rules, rule-based wizard

posted by Scott Whigham @ 11:04 AM  

New Reporting Services Video Tutorial: Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, and SSIS

Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, and SSIS - view details
This video (part one in this series) helps you install and, most importantly, configure the sample applications. It provides an overview of some of the common/best samples as well as discussions on when to use each.
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 sample applications, sample databases, integrated samples

posted by Scott Whigham @ 10:56 AM  

New Transact SQL Video Tutorial: Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, and SSIS

Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, and SSIS - view details
This video (part one in this series) helps you install and, most importantly, configure the sample applications. It provides an overview of some of the common/best samples as well as discussions on when to use each.
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 sample applications, sample databases, integrated samples

posted by Scott Whigham @ 10:56 AM  

New Visual Basic Video Tutorial: Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, and SSIS

Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, and SSIS - view details
This video (part one in this series) helps you install and, most importantly, configure the sample applications. It provides an overview of some of the common/best samples as well as discussions on when to use each.
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 sample applications, sample databases, integrated samples

posted by Scott Whigham @ 10:56 AM  

New Transact SQL Video Tutorial: Pt. 2 - More Samples and How to Get the Sample Applications to Compile Using an .snk File

Pt. 2 - More Samples and How to Get the Sample Applications to Compile Using an .snk File - view details
The sample apps include great documentation - but sometimes it's quite easy to overlook one little instruction that causes your entire sample app to fail. This video shows you the most common problems you'll experience with the sample applications and shows you how to create a strong name key (.snk) file (such as keypair.snk and sample.snk, both SNK files that are used with the samples).
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: pvk, .pvk, private key

posted by Scott Whigham @ 10:56 AM  

New Visual C# Video Tutorial: Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, and SSIS

Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, and SSIS - view details
This video (part one in this series) helps you install and, most importantly, configure the sample applications. It provides an overview of some of the common/best samples as well as discussions on when to use each.
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 sample applications, sample databases, integrated samples

posted by Scott Whigham @ 10:56 AM  

Sunday, June 10, 2007

New Transact SQL Video Tutorial: How to Get the Most Out of SSMS: Understanding the Tabbed Environment

How to Get the Most Out of SSMS: Understanding the Tabbed Environment - view details
The following video shows us how to properly utilize the tabbed environment within SQL Server Management Studio (SSMS).�� Aside from the simple tips on utilizing SSMS Tabbed Environment you
can expect this video to help you with the following items:
  • Introduction to starting Management Studio via Windows Start Menu.
  • SSMS startup options and location of these options
  • Introduction and explanation to autohide
  • Basic introduction to Hotkeys within SSMS
  • Limitations within the SSMS tabbed environment and how to rectify issues that arise from these
  • limitations.
  • Introduction to properties window
  • Proper utilization of the drag and drop features within SSMS
  • Stacking, tabbed, floating and dockable windows
  • Introduction to vertical and horizontal tab groups
This is an excellent video for the novice.�� Learning the tabbed environment makes life a lot easier when working with the SQL Server Management Studio.�� This is definitely a suggested video
for anyone wishing to further their education about the navigation and functions within SSMS.

NOTE: This video was reviewed and this description was written by one of our members, Wayne Leiser. Thanks,Wayne!
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: How to Get the Most Out of SSMS: Understanding the Tabbed Environment, introduction, step by step, beginner, beginning, for dumm

posted by Scott Whigham @ 8:36 AM  

New Transact SQL Video Tutorial: Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log

Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log - view details
This video is the part 4 of a series of 4 videos detailing information about SQL SERVER MANAGEMENT STUDIO (SSMS).�� This is an excellent conclusion to the video series introducing you
to your error logs within SSMS.�� This video will introduce you to working with Error logs within SQL Server Management Studio (SSMS) as well as some of the following items:
  • Error log viewer
  • Windows Event Log viewable within the Error Log
  • Agents log within the viewer as well
  • Introduction and explanation of the unified log viewer
  • Introduction to integration of reports in management studio
  • Introduction to graphic reports with SSMS
  • Introduction to writing custom reports
This is a perfect conclusion to a very informative video series.�� After the reviewing the video series in all you should have a very good understanding of SQL Server Management Studio.�� The
whole video series is a must see and is perfect for the newbie and a great reference to the experienced SQL programmer.

NOTE: This video was reviewed and this description was written by one of our members, Wayne Leiser. Thanks,Wayne!
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: Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS

Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS - view details
This wonderfully designed video hosts part 3 of the 4 part series of videos about SQL SERVER MANAGEMENT STUDIO (SSMS).�� This video will amaze you with extensive amount of informative material
enclosed within its binds and is no exception to the wonderful and easy teaching style.�� Not only does this video detail out the pros and cons of working with the SSMS
when designing or working with tables, writing queries within the AdventureWorks database but also contains information on the following items:
  • Launching SSMS from the Windows Start Menu
  • Intro Pinning Windows in SSMS
  • Intro to Tabbed Environment
  • Common Errors in SSMS and rectifying those errors
  • Object Explorer Right Click Options
  • Intro Properties window
  • Explanation of SAVE ME Asterisks
  • Detailed Explanation of column properties
  • Intro to Identity Columns in column properties
  • Generate Change Script Option
  • Intro to SQL SERVER AGENT
  • Creating and scheduling a SQL SERVER AGENT TASK
  • Common Real World Errors within SQL SERVER AGENT TASKS
  • Rectifying Common Errors within SQL SERVER AGENT TASKS
  • Benefits of the Change Scripts
  • Schema Change Definition
  • Inserting Values into TABLES via the Query Designer Graphic User Interface (GUI) in SSMS
  • Dangers of Inserting Values into TABLES via the Query Designer Graphic User Interface (GUI) in SSMS
  • TSQL INSERT STATEMENT vs. OPEN TABLE Query Designer Graphic User Interface (GUI) in SSMS Comparison
  • Intro to Transactions, Rollback and Commit
The trainer in this video does a wonderful job of continuing the introduction to to SSMS.�� This video does a fantastic job of combining real world environments, common error probabilities and
realistic tasks together in an easy to follow training course. ��

NOTE: This video was reviewed and this description was written by one of our members, Wayne Leiser. Thanks,Wayne!
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: Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS

posted by Scott Whigham @ 8:35 AM  

New ISA Server Video Tutorial: An Overview of ISA Server 2006 Monitoring and Analysis

An Overview of ISA Server 2006 Monitoring and Analysis - view details
Once your ISA Server 2006 server has been installed and configured, do you just sit back and let it run? Of course not - there are lots of 'fun' tools that help you monitor your server. This video gives you a high-level overview of the goals of monitoring your ISA Server as well as what tools to use and what to expect from ISAServer monitoring.

Highlights from this video:
  • How to determine how clients are connecting
  • System Performance tools
  • What are alerts and why should you use them?
  • Sessions, services, and reports
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: intro to monitoring, analysis, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginne

posted by Scott Whigham @ 6:46 AM  

New ISA Server Video Tutorial: How to View and Manage Sessions

How to View and Manage Sessions - view details
Once your ISA Server is up and running, chances are that you're going to be using it for much more than just protectingyour network; you might like to receive reports and feedback about who's using resources on your network. This video is a great place to start because it shows you how you can view the active sessions including how to determine what type of session each user is using.

Highlights from this video:
  • Monitoring your ISA Server
  • Undersatnding the Sessions display information
  • Understanding Session Types
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: overview, monitoring, best practices

posted by Scott Whigham @ 6:46 AM  

New ISA Server Video Tutorial: How to Create and Configure On-Demand Reporting in ISA Server

How to Create and Configure On-Demand Reporting in ISA Server - view details
Once your ISA Server is up and running you'll want to view reports about what it's doing. This video shows you how to monitor and analyze the different types of activity that is occuring on your ISA Server-enabled network.

Highlights from this video:
  • Generating a new report for ISA Server
  • How many ways are there to create reports for ISA Server?
  • How to email reports to administrations
  • Filtering report information
  • Understanding Your ISA Server Array Reports
  • Getting detailed user information
  • Viewing which websites your users are visiting
  • Summary info about browsing habits
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: monitoring, browsing history, internet explorer history

posted by Scott Whigham @ 6:46 AM  

New ISA Server Video Tutorial: How to Configure and Manage Logging in ISA Server 2006

How to Configure and Manage Logging in ISA Server 2006 - view details
Once your ISA Server is up and running, you can utilitize it to view what's happening in real time or historically on your server. This video shows you how to view the default log in ISA Server 2006 and much more.

Highlights from this video:
  • Viewing the default log
  • Writing logging queries
  • Creating and editing filters
  • Importing and exporting filter definitions
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: logging, monitoring

posted by Scott Whigham @ 6:46 AM  

New ISA Server Video Tutorial: How to Configure and Manage Alerts in ISA Server 2006

How to Configure and Manage Alerts in ISA Server 2006 - view details
What are ISA Alerts? They are about what you'd expect: they give you the option to receive notifications when x, y, or z occurs on your ISA Server. This video shows you how to create and manage ISA server alerts.

Highlights from this video:
  • Best Practices for using Alerts in ISA Server 2006
  • Understanding the Alerts tab in the ISA Server Management tool
  • Status=Acknowledge vs. Status=New
  • Resetting alerts
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: alerts, event log, logging

posted by Scott Whigham @ 6:45 AM  

New ISA Server Video Tutorial: An Overview of the Configuration of ISA Server 2006

An Overview of the Configuration of ISA Server 2006 - view details
During the installation of ISA Server 2006 you were given relatively few options for configuring ISA Server therefore it is important to understand how to use the ISA Server Management tool. This video helps you understand the 'big picture' of ISA Server management.

Highlights from this video:
  • Using the ISA Server Management tool to manage your firewall and more
  • How you configure your firewalls, networks, sets and rules
  • Monitoring ISA Server
  • Best Practices for monitoring ISA Server
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: overview, monitoring, best practices

posted by Scott Whigham @ 6:44 AM  

New Transact SQL Video Tutorial: Pt. 2 - SQL Server Management Studio (SSMS) Functionality and Available Options (Including Writing Queries)

Pt. 2 - SQL Server Management Studio (SSMS) Functionality and Available Options (Including Writing Queries) - view details
Another great introduction video to SQL SERVER MANAGEMENT STUDIO (SSMS) by Scott Whigham. This video leaps us onto the next stepping stone for SSMS. Scott not only continues his teachings about Generating Scripts within SSMS, he also gives is the another basic introduction to SSMS and explains why SSMS is the sole tool to utilize when writing TSQL. Included in this video are the following excellent features:
  • SQL SERVER Connection Requirements in 7.0 or 2000
  • SQL SERVER 2005 Color Coded Syntax
  • Disconnect and Switch Connection options
  • Basic Introduction to SAVE ME Asterisks
  • Basic Introduction to MDX and DMX Queries inside SSMS
  • Lack of Intellisense within SSMS
  • History of Intellisense
  • Third party Intellisense software is available
  • SSMS available options
  • Hot keys within SSMS and where to set them
  • SQL SERVER 2005 Chords - ie. Commenting out blocks of code (CTRL+K, CTRL+C)
  • How to comment and uncomment blocks of code with a couple pushes of keys
  • Funny SSMS non malicious bug in SSMS
This video is a must see, even if only for the bug within SSMS SP2. It is funny once you know about it and can be confusing if you see it before you know it is a BUG. Scott does a fantastic job of bringing us up to speed on the newest software used in developing TSQL (SSMS). This video is extremely easy to follow and is very well done.

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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 MANAGEMENT STUDIO, SSMS, Object Explorer, SQL SERVER 2005, SSMS Terminology, SSMS Options, SSMS BUG, COLOR CODED SYNT

posted by Scott Whigham @ 6:41 AM  

New Transact SQL Video Tutorial: Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)

Pt. 1 - An Introduction to SQL Server Management Studio (SSMS) - view details
Scott Whigham does a phenomenal job of introducing you to the new SQL SERVER MANAGEMENT STUDIO (SSMS).This solid introduction begins with the most common uses of SSMS.�� This lesson does utilize the SP2 version of SQL 2005 however does not require the student to have this installed.�� This video is filled with a wealth of knowledge and information waiting to be absorbed.�� This is a fantastic video for the new and old programmers alike.�� If you are unfamiliar with any of the following than this video is for you:
  • SQL SERVER 2005 terminology.
  • Just in Time terminology and explanation (JIT)
  • JIT Compiling explanation of usage within SQL Server Management Studio
  • SSMS Terminology
  • Pertinent and important options available within SSMS
  • Introduction to working with PINUPS within the WINDOWS Start menu.
  • OBJECT Explorer in SSMS (Closest replacement for Enterprise Manager/Object Browser)
  • Proper usage of the OBJECT Explorer
  • SQL SERVER 2005 Version Number (Version 9)
  • Introduction to beginning troubleshooting with SQL SERVER CONFIGURATION MANAGER
  • Connecting to Reporting Services, Integration Services and Database Engines.
  • Introduction to scripting within SSMS.
  • Non MODAL Windows in SSMS 2005 vs. MODAL Windows in SQL 2000
This video is a must see for all beginners and anyone looking to further their basic knowledge about SSMS. If you are not familiar with SSMS you will be very pleased with how easy this video is to follow & absorb and how quickly Scott makes use of your valuable time in properly teaching the correct way to enter the world of SQL SERVER MANAGEMENT STUDIO.

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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 MANAGEMENT STUDIO, SSMS, Object Explorer, SQL SERVER 2005, JIT Compiling, JIT, SSMS Terminology, SSMS Options, NON MO

posted by Scott Whigham @ 6:41 AM  

New Transact SQL Video Tutorial: Pt. 4 - Writing UPDATE Statements That Reference Multiple Tables (FROM Clause)

Pt. 4 - Writing UPDATE Statements That Reference Multiple Tables (FROM Clause) - view details
This video is part 4 of a 4 part series of videos on the Data Manipulation Language (DML) UPDATE STATEMENT.�� This video takes the UPDATE STATEMENT to the next level.�� Just when you thought you could not learn anything else about the UPDATE STATEMENT, Scott Whigham has even more to share with you.The following video includes information and training on the following:
  • T-SQL Proprietary Code
  • FROM Clause and the UPDATE Statement
  • Origin of the FROM Clause
  • Explanations to Why you should and Why you should NOT utilize the FROM clause
  • Real world examples of how and why to utilize the FROM clause
  • Common Errors in real world uses of SELECT and FROM statements and how to rectify those errors
  • Introduction to JOINS and UPDATES
  • PROPER JOIN Syntax
  • Explanations to why you should NOT utilize a JOIN and UPDATE statement where you can use a
  • subquery instead.
  • Examples show on what is ANSI compliant syntax and what is T-SQL proprietary syntax
  • Proper UPDATE Statement and SET Command syntax
  • Real World examples of proper syntax and bad syntax when writing UPDATES and JOINS
Scott does a wonderful job of showing us how to utilize the UPDATE statement with a JOIN syntax.This video however does require an extensive amount of knowledge towards JOIN statements to followthis.�� This is a very good video for the more advanced SQL Server programmer wanting to increasetheir knowledge about the UPDATE Statement.

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: UPDATE STATEMENT, SUBQUERY, Subqueries, SET COMMAND, Simple subquery, Correlated Subquery ANSI and ISO, FROM clause, JOIN, JOINS

posted by Scott Whigham @ 6:41 AM  

New Transact SQL Video Tutorial: Pt. 3 - Writing UPDATE Statements That Reference Multiple Tables (Subqueries)

Pt. 3 - Writing UPDATE Statements That Reference Multiple Tables (Subqueries) - view details
This video is part 3 of a 4 part series of videos on the Data Manipulation Language (DML) UPDATE STATEMENT. This video takes the UPDATE STATEMENT to the next level.�� Just when you thought you could not learn anything else about the UPDATE STATEMENT, Scott Whigham pulls it off again.The topics and information learned from this video include:
  • Assigning a value for the update statement based upon data in a table or a subquery.
  • Basic use of AdventureWorks database
  • Real world examples utilizing transactions with the AdventureWorks database.
  • Proper utilization and syntax with the UPDATE STATEMENT and SET COMMAND.
  • Introduction to Simple Subqueries and proper syntax for that type of subquery.
  • Explanation of the processing sequence and logic behind subqueries.SET COMMAND and subquery triple one rule (scalar value return).
  • Common real world errors when utilizing subqueries and SET COMMANDS
  • Real world examples on proper utilization of setup, writing T-SQL and execution of the UPDATE STATEMENT, SET COMMAND, and the WHERE clause.Introduction to Simple and Correlated Subqueries
  • Examples on Correlated Subqueries
  • Introduction to ANSI/ISO FROM Proprietary Extension��
Although Scott does a brilliant job of showing us how to properly write the syntax for a subquery when working with the UPDATE STATEMENT, this video does require a working knowledge of subqueries and the AdventureWorks Database prior to watching.��

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: UPDATE STATEMENT, SUBQUERY, Subqueries, SET COMMAND, Simple subquery, Correlated Subquery ANSI and ISO FROM Extension, Transacti

posted by Scott Whigham @ 6:41 AM  

Saturday, June 9, 2007

New Transact SQL Video Tutorial: Pt. 2 - How Transactions and Locks Affect UPDATE and SELECT Statements

Pt. 2 - How Transactions and Locks Affect UPDATE and SELECT Statements - view details
This video hosts the part 2 video on the opening and closing transaction statements when working with the UPDATE STATEMENT for the 4 part video series on the Data Manipulation Language (DML) UPDATE STATEMENT.The video starts off with the introduction to how transactions work and affect the UPDATE STATEMENT in SQL SERVER. Scott Whigham teaches us proper utilization of the combination of SELECT and UPDATE STATEMENTS.

Included within this video are common real world error examples and how to prevent these errors. Scott does a brilliant job of showing exactly why transactions in SQL SERVER are a must and proper ROLLBACK and COMMIT syntax. As we all have come to expect in Scott's teachings, this video does not just stop at simply teaching you about the UPDATE STATEMENT but also continues teaching you about the following:
  • DEFAULT DML STATEMENT
  • Open and Completed Transaction Statements
  • Introduction to IF and ELSE statements within Transactions.
  • Properly beginning and Committing Transaction Statements
  • Introduction to the @@TRANCOUNT statement
  • Real world examples with and without transactions.Introduction to Locking in SQL SERVER 2005.
  • Real world examples utilizing different users when working with transactions and locking.
This video is a great video to add to anyone's collection.�� You can utilize this video if you are beginner or if you are an experienced programmer just looking for reference material.

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: UPDATE STATEMENT, UPDATE syntax, @@TRANCOUNT, Transaction locking, Locking, IF and ELSE, Data Manipulation Language, DML, TSQL,

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact SQL

Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact SQL - view details
Scott Whigham masterfully surprises us once again with this brilliant part 1 video on the proper syntax for the 4 part video series on the Data Manipulation Language (DML) UPDATE STATEMENT. This video is a must have. This video not only demonstrates exactly how to utilize proper syntax and rules when working with the UPDATE statement but is filled with vast amounts of other data and knowledge such as the following:
  • Working with Literal values and the updating based upon another table.
  • What syntax is available whether this is standard or proprietary.
  • Introduction to creating a database with SQL Server Management Studio
  • Simplistic table creation (CREATE TABLE)
  • Introduction to database backup
  • Explaining errors with security privileges when backing up a database.
  • Default database backup syntax and location on a local hard drive.
  • Introduction and explanation of the SET NOCOUNT ON option.
  • Creation and termination of an infinite WHILE LOOP
  • Introduction and Explanation of the three SQL Language Classifications:
    • Data Manipulation Language (DML): SELECT, INSERT, UPDATE, DELETE
    • Data Definition Language (DDL): CREATE, ALTER, DROP (Manipulating Objects in the database)
    • Permissions Based Data Control Language (DCL) GRANT, DENY, REVOKE
  • Real world common error examples and how to properly prevent these errors.
  • Proper syntax for the update statement.
  • Proper formatting of your T-SQL Code and common mistakes when improperly formatting and executing your T-SQL Code.
  • Introduction of the TOP statement, variable declarations and more.
This video is filled with the proper ways to perform a variety of actions within T-SQL.

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
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: UPDATE STATEMENT, UPDATE syntax, Data Manipulation Langauge, Data Definition Language, Data Control Langauge, DML, DDL, DCL, CRE

posted by Scott Whigham @ 4:35 AM  

Tuesday, June 5, 2007

New ISA Server Video Tutorial: Discussion of Enterprise and Array Configuration of ISA Server 2006

Discussion of Enterprise and Array Configuration of ISA Server 2006 - view details
After you've completed your ISA Server 2006 Enterprise Edition installation, you'll want to configure your server. When you launch the ISA Server Management tool, you see the same tool that you use to manage the Standard Edition except your have options for Enterprise Management and Arrays Management - what are those?

Highlights from this video:
  • What Enterprise Policies are and how to use them
  • What Enterprise Networks and Add-Ins are and how to use them
  • Using Array Firewall policies
  • When should you use ISA Server Enterprise Edition instead of Standard Edition?
  • Best Practices for using ISA Server
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: security, best practices

posted by Scott Whigham @ 8:35 AM  

New ISA Server Video Tutorial: Installation and Explanation of ISA Server 2006 Enterprise Edition

Installation and Explanation of ISA Server 2006 Enterprise Edition - view details
There are two different versions of ISA Server 2006: (1) Standard Edition and, (2) Enterprise Edition. This video walks you through the installation of ISA Server 2006 Enterprise Edition as well as helps you understand exactly why you should consider using the Enterprise Edition.

Highlights from this video:
  • Understanding the options asked during setup of ISA Server 2006
  • Configuring your internal network IP address ranges
  • Configuring network adapters with ISA Server
  • Encryption settings and Firewall client settings
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: installation, installing, set up, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, begi

posted by Scott Whigham @ 8:35 AM  

New ISA Server Video Tutorial: How to Set Up Client Connectivity Using the Proxy Client

How to Set Up Client Connectivity Using the Proxy Client - view details
There are three ways that the ISA Server can be utilized by your client PCs to control and manage their web access. This video covers one of those ways: how to set up the client to directly talk to the ISA Server via a Web Proxy.

Highlights from this video:
  • Viewing connected sessions and setting up Filter Definitions
  • Configuring LAN Settings (Local Area Network) for proxy servers
  • How netstat can help you diagnose issues
  • Viewing logging preferences
  • Setting up the client to use ISA Server as the web proxy
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: firewalls, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:35 AM  

New ISA Server Video Tutorial: How to Configure the Web Cache in ISA Server 2006

How to Configure the Web Cache in ISA Server 2006 - view details
When you are using ISA Server on your network to help protect your network (by acting as a proxy server), you have a lot of options and, the one that this video talks about is how to configure caching on your ISA Server.

Highlights from this video:
  • Best practices for caching with ISA Server
  • Setting up the cache
  • When should I use caching?
  • How to set up cache rules
  • ISA Server web cache disk management
  • Time-to-live (TTL) options
  • Setting up FTP and HTTP caching
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: caches, web cache, cache store and retrieval, cache rules, default rules

posted by Scott Whigham @ 8:35 AM  

New ISA Server Video Tutorial: How to Set Up Client Connectivity Using Secure NAT

How to Set Up Client Connectivity Using Secure NAT - view details
Network Address Translation, or NAT, is an oft-used technique on the internet to protect internal network IPs. This video helps you understand NAT and shows you how to use Secure NAT with ISA Server 2006.

Highlights from this video:
  • Why would you use NAT?
  • Best Practices for using NAT with ISA Server
  • Using ISA Server as a proxy server
  • netstat and ipconfig to verify IPs
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: configuration, security, secure server

posted by Scott Whigham @ 8:35 AM  

New ISA Server Video Tutorial: Enable Intrusion Detection and DNS Attack Detection in ISA Server 2006

Enable Intrusion Detection and DNS Attack Detection in ISA Server 2006 - view details
One of the powerful things that an ISA Server can do that many hardware firewalls cannot do is to look deep inside the TCP packets as the packets come in to the ISA Server. This allows the ISA Server to open the packets and look inside for virii (viruses), trojans, worms, DDOS attacks, and more.

This video walks you through configuring Intrusion Detection in ISA Server 2006 as well as much more.

Highlights from this video:
  • Best practices for securing your networks with ISA Server
  • Preventing port scans
  • Ping of Death - what is that?!
  • EliminatingWinNuke attacks
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: security, best practices

posted by Scott Whigham @ 8:35 AM  

New ISA Server Video Tutorial: How to Configure the Connectivity Verifier in ISA Server 2006

How to Configure the Connectivity Verifier in ISA Server 2006 - view details
An ISA Server Connectivity Verifier is used to basically create a monitor between two places: your ISA Server and an internal host. This video shows you how to set up your first Connectivity Monitor as well as explaining what each screen means.

Highlights from this video:
  • Connectivity Verification
  • running the New Connectivity Verifier Wizard
  • Setting connection details
  • Determine what ISA Server should monitor
  • Understanding ISA Server 2006's services (such as the Microsoft ISA Server Job Scheduler)
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: isa server control,

posted by Scott Whigham @ 8:35 AM  

New ISA Server Video Tutorial: Protect Your Network against Flood Attacks Using Mitigation Settings in ISA Server 2006

Protect Your Network against Flood Attacks Using Mitigation Settings in ISA Server 2006 - view details
One of the most common attacks on a web server is when someone (bots?) try to flood it with requests. When you have an ISA Server for your organization, you need to ensure that your connection is available to your users. This video shows you how to protect your connection against such flood attacks.

Highlights from this video:
  • Configuring Flood Mitigation Settings and Options
  • Understanding flood attacks and worm propagation
  • Setting the flood limits
  • Protecting your internal network against infected hosts
  • Configuring the number of connections a host can have
  • Configure how many connections per second a client can request
  • Best Practices for protecting your network with ISA Server
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: security, best practices

posted by Scott Whigham @ 8:35 AM  

New ISA Server Video Tutorial: How to Set Up a Scheduled Job to Cache Websites

How to Set Up a Scheduled Job to Cache Websites - view details
ISA Server can be configured to download specific website on a regular basis (or a one-time cache) if you know that your organization will be using those websites. This is especially useful for sites with slow or intermittent connectivity.

Highlights from this video:
  • Creating Content Download Tasks and Jobs
  • Determining the best Download Frequency
  • Best Practices for determining the Content Caching settings
    • Cache Content settings
    • Time-to-Live (TTL) Settings
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: caching, cache all content

posted by Scott Whigham @ 8:35 AM  

New ISA Server Video Tutorial: How to Configure ISA Server to Send Scheduled Reports

How to Configure ISA Server to Send Scheduled Reports - view details
You can configure ISA Server reports to be automatically generated on a daily, weekly, or monthly basis. Why would want to do this? You'll often want to review usage patterns, look for problems, and even give reports to upper-level executives and management (and we know how they love charts and graphs). This video shows you how to customize the reports, manage the schedules, and handle delivery options.

Highlights from this video:
  • Setting up Report Job Schedules
  • Determining what each of the Report Content settings means
  • How to email reports
  • Array Reports
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: reporting, monitoring, analysis

posted by Scott Whigham @ 8:23 AM  

New ISA Server Video Tutorial: ISA Server Monitoring: Monitoring and Understanding the ISA Server Services

ISA Server Monitoring: Monitoring and Understanding the ISA Server Services - view details
Monitoring is a very important part of managing an ISA Server and one of the most important parts to monitor are the ISA Server services. The core piece of ISA Server is the Microsoft Firewall and you want to monitor this service to ensure it is running.

Highlights from this video:
  • What does each service do?
  • How ISA uses SQL Server
  • What tools you use for monitoring ISA services
  • Best practices for managing the ISA Server services and service accounts
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: intro to isa server, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:19 AM  

New ISA Server Video Tutorial: Network Firewall Configuration Templates

Network Firewall Configuration Templates - view details
In ISA Server 2006, Microsoft has included a number of templates to basically allow you to visuali