Wednesday, August 22, 2007

New Visual C# Video Tutorial: Pt. 5 - How to Setup and Configure Your First NUnit Project

Pt. 5 - How to Setup and Configure Your First NUnit Project - view details
Pt. 5 - How to Setup and Configure Your First NUnit Project
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 Setup and Configure Your First NUnit Project

posted by Scott Whigham @ 8:35 AM  

New Visual C# Video Tutorial: Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit

Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit - view details
Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit
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 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing

Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing - view details
Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing
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 - More on the Core Principles and Ideas of TDD and Unit Testing

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 5 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

Pt. 5 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server) - view details
Our last step is to delete the rows at the destination that have been previously deleted at the source. That's it - once you have this part complete, then you can write a job to run your SSIS package and schedule it to run as often as you like!
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: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit

Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit - view details
Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit
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 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 1 - What Is Test driven Development (TDD)? What are Unit Tests? How Can I Use Them?

Pt. 1 - What Is Test driven Development (TDD)? What are Unit Tests? How Can I Use Them? - view details
So many 'modern day' programmers do things completely backwards - they write the application code first and then, when things inevitably fail, they find themselves refactoring, rethinking, and just plain frustrated. Why, oh why, haven't more programmers learned the beauty of unit testing and test driven development (TDD)? If more programmers modernized their approaches to thinking about programming, they would find that they would save huge blocks of time and, in the process of saving time, write more efficient code.

Highlights from this video:
  • What is Test Driven Development (TDD)?
  • What are some of the core principles of TDD?
  • What are units? What are tests?
  • Why should I consider unit tests?
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: unit testing, framework, tdd, nunit

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 4 - Best Practices and Guidelines for Successful Unit Testing

Pt. 4 - Best Practices and Guidelines for Successful Unit Testing - view details
Pt. 4 - Best Practices and Guidelines for Successful Unit Testing
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 - Best Practices and Guidelines for Successful Unit Testing

posted by Scott Whigham @ 4:35 AM  

New Visual C# Video Tutorial: Pt. 4 - Best Practices and Guidelines for Successful Unit Testing

Pt. 4 - Best Practices and Guidelines for Successful Unit Testing - view details
Pt. 4 - Best Practices and Guidelines for Successful Unit Testing
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 - Best Practices and Guidelines for Successful Unit Testing

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing

Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing - view details
Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing
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 - More on the Core Principles and Ideas of TDD and Unit Testing

posted by Scott Whigham @ 4:35 AM  

New Visual Basic Video Tutorial: Pt. 1 - What Is Test driven Development (TDD)? What are Unit Tests? How Can I Use Them?

Pt. 1 - What Is Test driven Development (TDD)? What are Unit Tests? How Can I Use Them? - view details
So many 'modern day' programmers do things completely backwards - they write the application code first and then, when things inevitably fail, they find themselves refactoring, rethinking, and just plain frustrated. Why, oh why, haven't more programmers learned the beauty of unit testing and test driven development (TDD)? If more programmers modernized their approaches to thinking about programming, they would find that they would save huge blocks of time and, in the process of saving time, write more efficient code.

Highlights from this video:
  • What is Test Driven Development (TDD)?
  • What are some of the core principles of TDD?
  • What are units? What are tests?
  • Why should I consider unit tests?
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: unit testing, framework, tdd, nunit

posted by Scott Whigham @ 4:35 AM  

Tuesday, August 21, 2007

New Visual Basic Video Tutorial: Pt. 5 - How to Setup and Configure Your First NUnit Project

Pt. 5 - How to Setup and Configure Your First NUnit Project - view details
Pt. 5 - How to Setup and Configure Your First NUnit Project
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 Setup and Configure Your First NUnit Project

posted by Scott Whigham @ 4:19 PM  

New Visual Basic Video Tutorial: Pt. 4 - Best Practices and Guidelines for Successful Unit Testing

Pt. 4 - Best Practices and Guidelines for Successful Unit Testing - view details
Pt. 4 - Best Practices and Guidelines for Successful Unit Testing
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 - Best Practices and Guidelines for Successful Unit Testing

posted by Scott Whigham @ 4:18 PM  

New Visual Basic Video Tutorial: Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit

Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit - view details
Pt. 3 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit
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 - Writing Your First Application Using TDD, Your First Unit Test, and Using NUnit

posted by Scott Whigham @ 4:12 PM  

New Visual Basic Video Tutorial: Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing

Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing - view details
Pt. 2 - More on the Core Principles and Ideas of TDD and Unit Testing
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 - More on the Core Principles and Ideas of TDD and Unit Testing

posted by Scott Whigham @ 4:11 PM  

New Visual Basic Video Tutorial: Pt. 1 - What Is Test driven Development (TDD)? What are Unit Tests? How Can I Use Them?

Pt. 1 - What Is Test driven Development (TDD)? What are Unit Tests? How Can I Use Them? - view details
So many 'modern day' programmers do things completely backwards - they write the application code first and then, when things inevitably fail, they find themselves refactoring, rethinking, and just plain frustrated. Why, oh why, haven't more programmers learned the beauty of unit testing and test driven development (TDD)? If more programmers modernized their approaches to thinking about programming, they would find that they would save huge blocks of time and, in the process of saving time, write more efficient code.

Highlights from this video:
  • What is Test Driven Development (TDD)?
  • What are some of the core principles of TDD?
  • What are units? What are tests?
  • Why should I consider unit tests?
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: unit testing, framework, tdd, nunit

posted by Scott Whigham @ 4:10 PM  

New SQL Server Integration Services Video Tutorial: Options Available for Performing Incremental Updates/Deltas with SSIS

Options Available for Performing Incremental Updates/Deltas with SSIS - view details
One very common data movement scenario within SSIS is having a source table that you need to keep in sync with a destination table. For example: you have a table in your mainframe database that is just huge - 200 million rows. Your company does not expose the mainframe database to the web; instead they've built a complex data movement package that copies the data out of the mainframe and into a SQL Server database that the website uses. Previously, they were able to delete the old rows and simply replace the SQL Server data with the mainframe data - but, with 200 million rows to copy over, this has become impossible. How can you help?

You have a few options - and this videos helps you learn what those options are and 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: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 2 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

Pt. 2 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server) - view details
This video, part two in our series on how to do incremental changes in SSIS, talks about how to insert only the new rows added to the source.

Highlights from this video:
  • Writing JOINs and Queries that help identify the new rows (i.e., rows that exist at the source but not at the destination)
  • Using design patterns to simplify query writing
  • Creating an SSIS package to append rows to the target table
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

Pt. 3 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server) - view details
This is the crucial video for this series - it talks about how to update only the changed rows. This is what everyone wants to know - "How can I only update the rows at the destination?" Here you go :)

Highlights from this video:
  • Using the Data Flow task and the OLE-DB Command transformation to update only the changed values
  • Parameter and query syntax and ordering in the OLEDB Command Task
  • Various techniques for identifying which rows at the source have changed
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: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

Pt. 1 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server) - view details
One very common data movement scenario within SSIS is having a source table that you need to keep in sync with a destination table. This video, part 1, talks about the options available to you if you need to append rows from a source table to a target table, update only the changed rows with SSIS, or to delete rows at the destination that have also been deleted at the source.

Highlights from this video:
  • How to know when to use Set-Based incremental deltas or cursor-style (a decision tree)
  • Using the four part object identification to make addressing objects simpler
and much more

NOTE: Please watch the Options Available for Performing Incremental Updates/Deltas with SSIS video before watching this one.
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: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Pt. 4 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

Pt. 4 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server) - view details
This video is really more like Part 3b since it picks right up where Part 3 left off. You'll learn about how to take the queries in the last video and create the OLE-DB Command transformation to actually perform the update.
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: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

posted by Scott Whigham @ 4:35 AM  

New Exchange 2007/2003 Video Tutorial: How to Install and Setup Anti-SPAM on a Hub Transport Server

How to Install and Setup Anti-SPAM on a Hub Transport Server - view details
How to Install and Setup Anti-SPAM on a Hub Transport 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: How to Install and Setup Anti-SPAM on a Hub Transport Server, antispam, anti spam, bulk

posted by Scott Whigham @ 4:35 AM  

Monday, August 20, 2007

New SQL Server Integration Services Video Tutorial: Pt. 5 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

Pt. 5 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server) - view details
Our last step is to delete the rows at the destination that have been previously deleted at the source. That's it - once you have this part complete, then you can write a job to run your SSIS package and schedule it to run as often as you like!
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: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

posted by Scott Whigham @ 12:49 PM  

New SQL Server Integration Services Video Tutorial: Pt. 4 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

Pt. 4 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server) - view details
This video is really more like Part 3b since it picks right up where Part 3 left off. You'll learn about how to take the queries in the last video and create the OLE-DB Command transformation to actually perform the update.
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: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

posted by Scott Whigham @ 12:49 PM  

New SQL Server Integration Services Video Tutorial: Pt. 3 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

Pt. 3 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server) - view details
This is the crucial video for this series - it talks about how to update only the changed rows. This is what everyone wants to know - "How can I only update the rows at the destination?" Here you go :)

Highlights from this video:
  • Using the Data Flow task and the OLE-DB Command transformation to update only the changed values
  • Parameter and query syntax and ordering in the OLEDB Command Task
  • Various techniques for identifying which rows at the source have changed
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: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

posted by Scott Whigham @ 12:49 PM  

New SQL Server Integration Services Video Tutorial: Pt. 2 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

Pt. 2 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server) - view details
This video, part two in our series on how to do incremental changes in SSIS, talks about how to insert only the new rows added to the source.

Highlights from this video:
  • Writing JOINs and Queries that help identify the new rows (i.e., rows that exist at the source but not at the destination)
  • Using design patterns to simplify query writing
  • Creating an SSIS package to append rows to the target table
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

posted by Scott Whigham @ 12:48 PM  

New SQL Server Integration Services Video Tutorial: Pt. 1 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server)

Pt. 1 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server) - view details
One very common data movement scenario within SSIS is having a source table that you need to keep in sync with a destination table. This video, part 1, talks about the options available to you if you need to append rows from a source table to a target table, update only the changed rows with SSIS, or to delete rows at the destination that have also been deleted at the source.

Highlights from this video:
  • How to know when to use Set-Based incremental deltas or cursor-style (a decision tree)
  • Using the four part object identification to make addressing objects simpler
and much more

NOTE: Please watch the Options Available for Performing Incremental Updates/Deltas with SSIS video before watching this one.
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: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

posted by Scott Whigham @ 12:48 PM  

New SQL Server Integration Services Video Tutorial: Options Available for Performing Incremental Updates/Deltas with SSIS

Options Available for Performing Incremental Updates/Deltas with SSIS - view details
One very common data movement scenario within SSIS is having a source table that you need to keep in sync with a destination table. For example: you have a table in your mainframe database that is just huge - 200 million rows. Your company does not expose the mainframe database to the web; instead they've built a complex data movement package that copies the data out of the mainframe and into a SQL Server database that the website uses. Previously, they were able to delete the old rows and simply replace the SQL Server data with the mainframe data - but, with 200 million rows to copy over, this has become impossible. How can you help?

You have a few options - and this videos helps you learn what those options are and 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: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

posted by Scott Whigham @ 12:10 PM  

Sunday, August 19, 2007

New Exchange 2007/2003 Video Tutorial: How to Configure Anti-SPAM On a Hub Transport Server

How to Configure Anti-SPAM On a Hub Transport Server - view details
How to Configure Anti-SPAM On a Hub Transport 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: How to Configure Anti-SPAM On a Hub Transport Server, antispam, anti spam

posted by Scott Whigham @ 4:35 AM  

New Exchange 2007/2003 Video Tutorial: Configure and Allow File Server Access Through Outlook Web Access (OWA)

Configure and Allow File Server Access Through Outlook Web Access (OWA) - view details
Configure and Allow File Server Access Through Outlook Web Access (OWA)
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: Configure and Allow File Server Access Through Outlook Web Access (OWA)

posted by Scott Whigham @ 4:35 AM  

New Exchange 2007/2003 Video Tutorial: How to Build a Custom Address List With Windows Power Shell

How to Build a Custom Address List With Windows Power Shell - view details
How to Build a Custom Address List With Windows Power Shell
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 Build a Custom Address List With Windows Power Shell

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 4 - Best Practices for Maximum SQL Server Reporting Services Performance: Shared Data Sources

Pt. 4 - Best Practices for Maximum SQL Server Reporting Services Performance: Shared Data Sources - view details
Pt. 4 - Best Practices for Maximum SQL Server Reporting Services Performance: Shared Data Sources
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 - Best Practices for Maximum SQL Server Reporting Services Performance: Shared Data Sources

posted by Scott Whigham @ 4:35 AM  

New Exchange 2007/2003 Video Tutorial: How to Configure Outlook Web Access (OWA) for a Specific Domain at Login Prompt

How to Configure Outlook Web Access (OWA) for a Specific Domain at Login Prompt - view details
How to Configure Outlook Web Access (OWA) for a Specific Domain at Login Prompt
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 Configure Outlook Web Access (OWA) for a Specific Domain at Login Prompt

posted by Scott Whigham @ 4:35 AM  

Saturday, August 18, 2007

New Exchange 2007/2003 Video Tutorial: Configure and Allow File Server Access Through Outlook Web Access (OWA)

Configure and Allow File Server Access Through Outlook Web Access (OWA) - view details
Configure and Allow File Server Access Through Outlook Web Access (OWA)
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: Configure and Allow File Server Access Through Outlook Web Access (OWA)

posted by Scott Whigham @ 6:36 PM  

New Exchange 2007/2003 Video Tutorial: How to Configure Outlook Web Access (OWA) for a Specific Domain at Login Prompt

How to Configure Outlook Web Access (OWA) for a Specific Domain at Login Prompt - view details
How to Configure Outlook Web Access (OWA) for a Specific Domain at Login Prompt
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 Configure Outlook Web Access (OWA) for a Specific Domain at Login Prompt

posted by Scott Whigham @ 6:36 PM  

New Exchange 2007/2003 Video Tutorial: How to Build a Custom Address List With Windows Power Shell

How to Build a Custom Address List With Windows Power Shell - view details
How to Build a Custom Address List With Windows Power Shell
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 Build a Custom Address List With Windows Power Shell

posted by Scott Whigham @ 6:36 PM  

New Exchange 2007/2003 Video Tutorial: How to Configure Anti-SPAM On a Hub Transport Server

How to Configure Anti-SPAM On a Hub Transport Server - view details
How to Configure Anti-SPAM On a Hub Transport 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: How to Configure Anti-SPAM On a Hub Transport Server, antispam, anti spam

posted by Scott Whigham @ 6:36 PM  

New Exchange 2007/2003 Video Tutorial: How to Install and Setup Anti-SPAM on a Hub Transport Server

How to Install and Setup Anti-SPAM on a Hub Transport Server - view details
How to Install and Setup Anti-SPAM on a Hub Transport 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: How to Install and Setup Anti-SPAM on a Hub Transport Server, antispam, anti spam, bulk

posted by Scott Whigham @ 6:35 PM  

Friday, August 17, 2007

New Reporting Services Video Tutorial: Pt. 3 - Performance Tuning Your Reporting: How to Ensure Connection Pooling in Your Reports

Pt. 3 - Performance Tuning Your Reporting: How to Ensure Connection Pooling in Your Reports - view details
Pt. 3 - Performance Tuning Your Reporting: How to Ensure Connection Pooling in Your Reports
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 - Performance Tuning Your Reporting: How to Ensure Connection Pooling in Your Reports

posted by Scott Whigham @ 8:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - Data Sources in SSRS: An Intro to Shared and Report-Specific Data Sources

Pt. 1 - Data Sources in SSRS: An Intro to Shared and Report-Specific Data Sources - view details
Pt. 1 - Data Sources in SSRS: An Intro to Shared and Report-Specific Data Sources
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 - Data Sources in SSRS: An Intro to Shared and Report-Specific Data Sources

posted by Scott Whigham @ 8:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - How to Share a Shared Data Source Across Multiple Projects and Solutions

Pt. 2 - How to Share a Shared Data Source Across Multiple Projects and Solutions - view details
Pt. 2 - How to Share a Shared Data Source Across Multiple Projects and Solutions
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 Share a Shared Data Source Across Multiple Projects and Solutions

posted by Scott Whigham @ 8:35 AM  

New Reporting Services Video Tutorial: Pt. 3 - How to Configure and Deploy the Sample Reports

Pt. 3 - How to Configure and Deploy the Sample Reports - view details
Pt. 3 - How to Configure and Deploy the Sample Reports
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 - How to Configure and Deploy the Sample Reports, introduction, step by step, beginner, beginning, for dummies, introducti

posted by Scott Whigham @ 8:35 AM  

New Reporting Services Video Tutorial: Pt. 4 - Best Practices for Maximum SQL Server Reporting Services Performance: Shared Data Sources

Pt. 4 - Best Practices for Maximum SQL Server Reporting Services Performance: Shared Data Sources - view details
Pt. 4 - Best Practices for Maximum SQL Server Reporting Services Performance: Shared Data Sources
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 - Best Practices for Maximum SQL Server Reporting Services Performance: Shared Data Sources

posted by Scott Whigham @ 5:52 AM  

New Reporting Services Video Tutorial: Pt. 3 - Performance Tuning Your Reporting: How to Ensure Connection Pooling in Your Reports

Pt. 3 - Performance Tuning Your Reporting: How to Ensure Connection Pooling in Your Reports - view details
Pt. 3 - Performance Tuning Your Reporting: How to Ensure Connection Pooling in Your Reports
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 - Performance Tuning Your Reporting: How to Ensure Connection Pooling in Your Reports

posted by Scott Whigham @ 5:52 AM  

New Reporting Services Video Tutorial: Pt. 2 - How to Share a Shared Data Source Across Multiple Projects and Solutions

Pt. 2 - How to Share a Shared Data Source Across Multiple Projects and Solutions - view details
Pt. 2 - How to Share a Shared Data Source Across Multiple Projects and Solutions
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 Share a Shared Data Source Across Multiple Projects and Solutions

posted by Scott Whigham @ 5:52 AM  

New Reporting Services Video Tutorial: Pt. 1 - Data Sources in SSRS: An Intro to Shared and Report-Specific Data Sources

Pt. 1 - Data Sources in SSRS: An Intro to Shared and Report-Specific Data Sources - view details
Pt. 1 - Data Sources in SSRS: An Intro to Shared and Report-Specific Data Sources
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 - Data Sources in SSRS: An Intro to Shared and Report-Specific Data Sources

posted by Scott Whigham @ 5:52 AM  

Thursday, August 16, 2007

New Transact SQL Video Tutorial: Pt. 2 - Using the INPUT Clause with the OUTPUT Clause

Pt. 2 - Using the INPUT Clause with the OUTPUT Clause - view details
Pt. 2 - Using the INPUT Clause with the OUTPUT Clause
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 - Using the INPUT Clause with the OUTPUT Clause

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: Pt. 1 - Using the OUTPUT Clause with the INSERT, UPDATE and DELETE Statements

Pt. 1 - Using the OUTPUT Clause with the INSERT, UPDATE and DELETE Statements - view details
Pt. 1 - Using the OUTPUT Clause with the INSERT, UPDATE and DELETE Statements
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 - Using the OUTPUT Clause with the INSERT, UPDATE and DELETE Statements

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - How to Install the AdventureWorks Sample Reports

Pt. 2 - How to Install the AdventureWorks Sample Reports - view details
Pt. 2 - How to Install the AdventureWorks Sample Reports
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 Install the AdventureWorks Sample Reports, introduction, step by step, beginner, beginning, for dummies, introduc

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: An Overview of the Tools Used With SQL Server Reporting Services 2005

An Overview of the Tools Used With SQL Server Reporting Services 2005 - view details
An Overview of the Tools Used With SQL Server Reporting Services 2005
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: An Overview of the Tools Used With SQL Server Reporting Services 2005, introduction, step by step, beginner, beginning, for dumm

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - An Overview of the AdventureWorks Sample Reports

Pt. 1 - An Overview of the AdventureWorks Sample Reports - view details
Pt. 1 - An Overview of the AdventureWorks Sample Reports
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 Transact SQL Video Tutorial: Pt. 5 - How to Use TRUNCATE TABLE and the Differences Between It and the DELETE Statement

Pt. 5 - How to Use TRUNCATE TABLE and the Differences Between It and the DELETE Statement - view details
Pt. 5 - How to Use TRUNCATE TABLE and the Differences Between It and the DELETE Statement
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 Use TRUNCATE TABLE and the Differences Between It and the DELETE Statement

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: How to Change the ReportingServicesService.exe Service Account Password

How to Change the ReportingServicesService.exe Service Account Password - view details
How to Change the ReportingServicesService.exe Service Account Password
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 Change the ReportingServicesService.exe Service Account Password

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: How to Configure Reporting Services to Use a Certificate (SSL) Using SelfSSL

How to Configure Reporting Services to Use a Certificate (SSL) Using SelfSSL - view details
How to Configure Reporting Services to Use a Certificate (SSL) Using SelfSSL
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 Configure Reporting Services to Use a Certificate (SSL) Using SelfSSL

posted by Scott Whigham @ 4:35 AM  

Wednesday, August 15, 2007

New Reporting Services Video Tutorial: Pt. 3 - How to Configure and Deploy the Sample Reports

Pt. 3 - How to Configure and Deploy the Sample Reports - view details
Pt. 3 - How to Configure and Deploy the Sample Reports
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 - How to Configure and Deploy the Sample Reports, introduction, step by step, beginner, beginning, for dummies, introducti

posted by Scott Whigham @ 6:04 PM  

New Reporting Services Video Tutorial: Pt. 2 - How to Install the AdventureWorks Sample Reports

Pt. 2 - How to Install the AdventureWorks Sample Reports - view details
Pt. 2 - How to Install the AdventureWorks Sample Reports
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 Install the AdventureWorks Sample Reports, introduction, step by step, beginner, beginning, for dummies, introduc

posted by Scott Whigham @ 6:03 PM  

New Reporting Services Video Tutorial: Pt. 1 - An Overview of the AdventureWorks Sample Reports

Pt. 1 - An Overview of the AdventureWorks Sample Reports - view details
Pt. 1 - An Overview of the AdventureWorks Sample Reports
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 @ 6:03 PM  

New Transact SQL Video Tutorial: Pt. 2 - Using the INPUT Clause with the OUTPUT Clause

Pt. 2 - Using the INPUT Clause with the OUTPUT Clause - view details
Pt. 2 - Using the INPUT Clause with the OUTPUT Clause
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 - Using the INPUT Clause with the OUTPUT Clause

posted by Scott Whigham @ 5:54 PM  

New Transact SQL Video Tutorial: Pt. 1 - Using the OUTPUT Clause with the INSERT, UPDATE and DELETE Statements

Pt. 1 - Using the OUTPUT Clause with the INSERT, UPDATE and DELETE Statements - view details
Pt. 1 - Using the OUTPUT Clause with the INSERT, UPDATE and DELETE Statements
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 - Using the OUTPUT Clause with the INSERT, UPDATE and DELETE Statements

posted by Scott Whigham @ 5:53 PM  

New Transact SQL Video Tutorial: Pt. 4 - How to Use the FROM Clause in the DELETE Statement

Pt. 4 - How to Use the FROM Clause in the DELETE Statement - view details
Pt. 4 - How to Use the FROM Clause in the DELETE Statement
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 Use the FROM Clause in the DELETE Statement

posted by Scott Whigham @ 8:35 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 @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 3 - How to Use Subqueries in the DELETE Statement

Pt. 3 - How to Use Subqueries in the DELETE Statement - view details
Pt. 3 - How to Use Subqueries in the DELETE Statement
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 - How to Use Subqueries in the DELETE Statement

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 1 - An Intro to the DELETE Statement

Pt. 1 - An Intro to the DELETE Statement - view details
Pt. 1 - An Intro to the DELETE Statement
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 - An Intro to the DELETE Statement

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 2 - How Transactions and Locks Work With the DELETE Statement

Pt. 2 - How Transactions and Locks Work With the DELETE Statement - view details
Pt. 2 - How Transactions and Locks Work With the DELETE Statement
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 Transactions and Locks Work With the DELETE Statement

posted by Scott Whigham @ 8:35 AM  

New Transact SQL Video Tutorial: Pt. 5 - How to Use TRUNCATE TABLE and the Differences Between It and the DELETE Statement

Pt. 5 - How to Use TRUNCATE TABLE and the Differences Between It and the DELETE Statement - view details
Pt. 5 - How to Use TRUNCATE TABLE and the Differences Between It and the DELETE Statement
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 Use TRUNCATE TABLE and the Differences Between It and the DELETE Statement

posted by Scott Whigham @ 7:12 AM  

New Transact SQL Video Tutorial: Pt. 4 - How to Use the FROM Clause in the DELETE Statement

Pt. 4 - How to Use the FROM Clause in the DELETE Statement - view details
Pt. 4 - How to Use the FROM Clause in the DELETE Statement
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 Use the FROM Clause in the DELETE Statement

posted by Scott Whigham @ 7:12 AM  

New Transact SQL Video Tutorial: Pt. 3 - How to Use Subqueries in the DELETE Statement

Pt. 3 - How to Use Subqueries in the DELETE Statement - view details
Pt. 3 - How to Use Subqueries in the DELETE Statement
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 - How to Use Subqueries in the DELETE Statement

posted by Scott Whigham @ 7:12 AM  

New Transact SQL Video Tutorial: Pt. 2 - How Transactions and Locks Work With the DELETE Statement

Pt. 2 - How Transactions and Locks Work With the DELETE Statement - view details
Pt. 2 - How Transactions and Locks Work With the DELETE Statement
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 Transactions and Locks Work With the DELETE Statement

posted by Scott Whigham @ 7:12 AM  

New Transact SQL Video Tutorial: Pt. 1 - An Intro to the DELETE Statement

Pt. 1 - An Intro to the DELETE Statement - view details
Pt. 1 - An Intro to the DELETE Statement
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 - An Intro to the DELETE Statement

posted by Scott Whigham @ 7:12 AM  

Saturday, August 4, 2007

New SharePoint 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 @ 8:35 AM  

New SharePoint 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 @ 8:35 AM  

New SharePoint 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 @ 8:35 AM  

New SharePoint 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 SQL Server Integration Services 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 @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: How to Move a Database Using The Transfer Database Task in SSIS

How to Move a Database Using The Transfer Database Task in SSIS - view details
Here's yet another option for how to move a database from one server to another (or, 'how to copy a database from one instance to another'): the Transfer Database Task in SQL Server Integration Services (SSIS). The Transfer Database Task can be quite tricky to work with and isn't always the best option so you'll want to watch this video for a good overview before making it a part of your mission-critical operations.
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: backups, restores, disaster recovery

posted by Scott Whigham @ 4:35 AM  

New SharePoint 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 SQL Server Integration Services 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 @ 4:35 AM  

New SQL Server Integration Services 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 @ 4:35 AM  

New SharePoint 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 SQL Server Integration Services 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 @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: How to Move a Database Using Detach and Attach

How to Move a Database Using Detach and Attach - view details
Yet another way to move a database from one instance/server to another is to detach the database from the source and then attach the database to the destination (or to both the source and destination if you want to just copy the database).

Highlights from this video:
  • When should I use detach/attach instead of backup/restore to copy/move my database to a new server?
  • Best practices using detach/attach
  • Detaching using SSMS and T-SQL
  • Attaching using SSMS and T-SQL
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: move drive, new servers

posted by Scott Whigham @ 4:35 AM  

Friday, August 3, 2007

New SQL Server 2005 Video Tutorial: Pt. 3 - Using the SSIS to Migrate Tables from Access to SQL Server 2005

Pt. 3 - Using the SSIS to Migrate Tables from Access to SQL Server 2005 - view details
This video walks you through how to migrate tables from Access 2007/2003/2000 to SQL Server 2005 using SQL Server Integration Services (SSIS).

Highlights from this video:
  • Using the Import/Export Wizard in SSIS
  • Using BIDS (SQL Server Business Intelligence Development Studio) to create and manage SSIS packages
  • Creating custom packages for migrating Access to SQL Server
  • Common problems when migrating from Access to SQL Server 2005
  • Customizing the transformations to avoid datatype mismatch errors (i.e., Unicode to non-unicode string transformation errors)
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: transformations, DT_R4, DT_I4

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: How to Copy a Database to a Web Host Using the SQL Server Database Publishing Wizard

How to Copy a Database to a Web Host Using the SQL Server Database Publishing Wizard - view details
The SQL Server Database Publishing Wizard (SSDPW) is yet another technique for moving databases from one server/instance to another (along with using backup/restore, detach/attach, and SSIS' Transfer Database Task).

Highlights from this video:
  • Using the SQL Server 2005 Database Publishing Wizard to deploy locally developed databases to a hosted environment (i.e., a web host)
  • Who should use the SSDPW
  • How to deploy SQL databases in APP_DATA folder to a web host using the SSDPW
  • Scripting options in the SSDPW
  • Differences between the scripting options in SSMS (SP2) and the SSDPW
and much more

Link to the SSDPW (previously called the SQL Server Hosting Toolkit): download 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: webhost.

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 4 - Viewing the Results and Doing Repairs

Pt. 4 - Viewing the Results and Doing Repairs - view details
Although the Access Upsizing Wizard isn't perfect, it is a tremendous timesaver. You will need to do a few repairs after it has finished such as rwriting views/functions/stored procedures and verifying and modifying datatypes.

Highlights from this video:
  • Common pitfalls of the Upsizing Wizard
  • Suggestions for datatypes
  • How to rewrite Access queries to become SQL Server objects
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: unicode, nvarchar, real

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - Using the DTS Designer to Migrate Tables from Access to SQL Server 2000

Pt. 2 - Using the DTS Designer to Migrate Tables from Access to SQL Server 2000 - view details
In the first video in this series we used the DTS Import/Export Wizard to move Access tables to SQL Server 2000. In this video, we go one step further and create a DTS package in the DTS Designer (inside of the Enterprise Manager).

Highlights from this video:
  • Using connections in DTS
  • Using the Transform Data Task
  • Changing the tranformations and auto-generated schema
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: data transformation services designer, transform data task, oledb provider

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 5 - Working with the .ADP File

Pt. 5 - Working with the .ADP File - view details
Your migration is nearly complete and now you want to verify (and understand) the newly generated Access Client/Server Application (the .adp file).
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: access data project

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: How to Move a Database Using Backup and Restore

How to Move a Database Using Backup and Restore - view details
This video tutorial shows you one technique for moving/copying a database from one server/instance to another using backup and recovery. There are many techniques for moving and copying databases and, if you haven't moved databases from server to server before, you'll want to be familiar with all techniques.

Highlights from this video:
  • Taking and restoring backups
  • Understanding the RESTORE DATABASE dialog box
  • Resolving issues with restoring databases on other servers
  • Discussion of orphaned logins
  • Discussion of database compatibility and using sp_dbcmptlevel to view/change compatibility level
  • How to view the SQL Server version in T-SQL
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: backups, restores, disaster recovery

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: Options Available for Moving Databases From One Instance/Server to Another

Options Available for Moving Databases From One Instance/Server to Another - view details
One of the most common questions that Scott Whigham (author of this site) gets is, 'How do I move/copy a database from ServerA to ServerB?' and this series is meant to help you understand the options available and how to do the copy/move.

This video is just an overview of the options for moving databases around your environment are; it is not a demo/tutorial, per se. You'll definitely want to watch the other videos in this series to view the demo/tutorials.

Highlights from this video:
  • Options for migrating SQL 2000 to SQL 2005 and SQL 2005 to SQL 2005
  • Differences between an upgrade and a migration
  • Backup/Restore
  • Detach/Attach
  • SQL Server Integration Services (SSIS) Tasks
  • Scripting with the SQL Server 2005 Database Publishing Wizard
and much more. NOTE: During the lecture, Scott makes a typo in the discussion of database compatibility levels. The correct stored procedure should be sp_dbcmptlevel
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: migrate, upgrade, upgrading, migration, backup and restore, restoring, detaching, how to

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - Using the DTS Wizards to Migrate Tables from Access to SQL Server 2000

Pt. 1 - Using the DTS Wizards to Migrate Tables from Access to SQL Server 2000 - view details
Do you just need to migrate the data from Access to SQL Server? Maybe just one or two tables? Then this video (and this series) is for you.

Highlights from this video:
  • How to migrate tables in Access 2007/2003/2000 to SQL Server 2000 using Data Transformation Services (DTS)
  • Using the Import/Export Wizard in DTS
  • Potential problems faced when using DTS to migrate Access tables and queries
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: data transformation services wizard

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 3 - Using the Access Upsizing Wizard

Pt. 3 - Using the Access Upsizing Wizard - view details
The Access Upsizing Wizard is the preferred way to migrate from Access to SQL Server when you only want to move the data but you want the reports/forms/modules/etc to still exist in Access.

Highlights from this video:
  • How to install the Upsizing Wizard
  • Overcoming limitations of the Upsizing Wizard
  • Understanding the options in the wizard
  • Best Practices for migrating from Access to SQL Server
  • Understanding the .ADP file (the Access Client/Server 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: upgrade, upgrading, migrate, migrating, migration,

posted by Scott Whigham @ 8:35 AM  

Wednesday, August 1, 2007

New Reporting Services Video Tutorial: Pt. 3a - An Overview of Using SSIS for Newbies and Beginners - Using BIDS

Pt. 3a - An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
Our video tutorials in using the Business Intelligence Development Studio (BIDS) spans multiple videos simply due to the complexities of BIDS. This video introduces you to what BIDS is and does and what Projects and Solutions are.
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: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 2 - Migration and Upgrade Options for Moving From Access to SQL Server

Pt. 2 - Migration and Upgrade Options for Moving From Access to SQL Server - view details
This video covers the basic tools that you use to migrate from Access to SQL Server including discussions of differences in migrating the various versions of Access and SQL Server.

Highlights from this video:
  • Discussions on moving from Access 2007, 2003, 2000, XP, and even 97
  • Techniques for migrating one table at a time
  • Techniques for migrating all tables
  • Using DTS (Data Transformation Services) to upgrade to SQL Server 2000
  • Using SSIS (SQL Server Integration Services) for upgrades to SQL Server 2005
  • Text files as an upgrading option
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: migration, migrating, upgrades, upgrading

posted by Scott Whigham @ 8:35 AM  

New Reporting Services Video Tutorial: Pt. 3c - An Overview of Using SSIS for Newbies and Beginners - Using BIDS

Pt. 3c - An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
Even more on BIDS
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: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

posted by Scott Whigham @ 8:35 AM  

New Reporting Services Video Tutorial: Pt. 2 - An Overview of Using SSIS - Using SQL Server Management Studio

Pt. 2 - An Overview of Using SSIS - Using SQL Server Management Studio - view details
What do you use SSMS for (with respect to SSIS) - do you know? Is it possible that you can edit DTS packages? (that's a trick question, by the way). This video helps you understand when and where to use SSMS with Integration Services.
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: ssms, schedule job, scheduling job, how to schedule job, security, roles, package roles

posted by Scott Whigham @ 8:35 AM  

New Reporting Services Video Tutorial: Pt. 3d- An Overview of Using SSIS for Newbies and Beginners - Using BIDS

Pt. 3d- An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
Finally! Our last video on using BIDS for Beginners
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: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

posted by Scott Whigham @ 8:35 AM  

New SQL Server 2005 Video Tutorial: Pt. 1 - Why Migrate From Microsoft Access to SQL Server?

Pt. 1 - Why Migrate From Microsoft Access to SQL Server? - view details
So it's time to move away from using that friendly, rapid-application-development tool Microsoft Access and start using a full-blown relational database management system such as SQL Server, eh? There are many reasons to move from Access to SQL Server and this video gives you the primary reasons why people move from Access to SQL.

Highlights from this video:
  • Differences between Access and SQL Server
  • Definitions of the ACID test and how it applies to SQL Server but not to Access
  • Memory and CPU support in SQL Server
  • How transactions are handled differently between the two systems
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: upgrade access, upgrade Access 2003, upgrade Access 2007, upgrade Access XP, upgrade Access 2000

posted by Scott Whigham @ 8:35 AM  

New Reporting Services Video Tutorial: Pt. 3b - An Overview of Using SSIS for Newbies and Beginners - Using BIDS

Pt. 3b - An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
More on working inside the Business Intelligence Development Studio (BIDS)
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: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

posted by Scott Whigham @ 8:35 AM  

New Reporting Services Video Tutorial: Pt. 1 - An Overview of Using SSIS for Newbies and Beginners

Pt. 1 - An Overview of Using SSIS for Newbies and Beginners - view details
If you are just getting started with Integration Services, then you need to START HERE. This video, part one of a whole series on SSIS for beginners, starts you out with an introduction of what SSIS will be used for and the different tools that you'll be using. This video is more of an overview and is designed to give you the view of SSIS from 50,000 feet, if you will. The remaining videos in this series will dig down in to the topics posed in this video and help you get started with SSIS the right way.

Highlights from this video:
  • Which tools do you use to schedule and execute SSIS packages?
  • What tool(s) do you use to edit and develop SSIS packages?
  • What can you do within SSMS (SQL Server Management Studio)?
  • What can you do within BIDS (Business Intelligence Development Studio)?
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: intro, introduction, beginning, newbs, newbies, starters, first time, overview, technology overview

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data

COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data - view details
If you have to work with multi-national and international data, then you'll often find yourself working with Unicode Datatypes (such as nchar and nvarchar) and even needing to use particular collations. In fact, some of you may need to work with (gasp) a case-sensitive server, database, table or column. If you are wanting to know more information about how case sensitive data, regional data, global data and basically get a handle on how string data works in SQL Server, this is a good video for helping you understand how SQL Server works.
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: unicode, nchar, nvarchar, collate, collation, globalization

posted by Scott Whigham @ 8:35 AM  

New SQL Server Integration Services Video Tutorial: COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data

COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data - view details
If you have to work with multi-national and international data, then you'll often find yourself working with Unicode Datatypes (such as nchar and nvarchar) and even needing to use particular collations. In fact, some of you may need to work with (gasp) a case-sensitive server, database, table or column. If you are wanting to know more information about how case sensitive data, regional data, global data and basically get a handle on how string data works in SQL Server, this is a good video for helping you understand how SQL Server works.
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: unicode, nchar, nvarchar, collate, collation, globalization

posted by Scott Whigham @ 7:10 AM