Thursday, July 24, 2008

New SharePoint Video Tutorial: Installing SQL Server Management S tudio Express Edition And Connecting To The SharePoint Database

Installing SQL Server Management Studio Express Edition And Connecting To The SharePoint Database - view details
Behind the scenes of Windows SharePoint Services(WSS), is Microsoft SQL Server. If you allow SQL to install the SQL Server 2005 Embedded Edition when you first install WSS, you can then take advantage of SQL management for your database. By visiting www.Microsoft.com/sql you can download the SQL Server Managemnt Studio (SSMS) Express Edition, which we will be installing in this video. In this video tutorial, Grant will walk you through the complete installation of SSMS and demonstrate to you how you can connect to your SharePoint database.

Highlights from this video:
  • Setting up your install
  • Browsing for/connecting to your server when working in SSMS
    • The magic string for connecting to your SharePoint server
  • Navigating the Object Explorer in SSMS
  • What can we do with our information in our database?
  • Browsing through your tables
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: install, ssms, sql server, management studio, connect, database, installing,

posted by Scott Whigham @ 4:35 AM  

New SharePoint Video Tutorial: How Does SharePoint Work : Looking At SharePoint from a SQL Server Administration Point Of View

How Does SharePoint Work : Looking At SharePoint from a SQL Server Administration Point Of View - view details
In this video we will take a look at what makes up a SharePoint site via a behind-the-scenes look. We know that the majority of our SharePoint management is done using a web interface to either a SharePoint site or to the SharePoint configuration management on the server that has SharePoint installed on it. In this video we will go below that surface level to what is operating below with SQL.

Highlights from this video:
  • About the SharePoint structure
  • How SharePoint interacts with SQL Server
    • What happened when I first installed my SharePoint server?
    • What will be installed specifically for SQL Server?
  • Demystifiying the 4 main databases
    • System Database
    • Admin Content
    • WSS Content
    • WSS Search
  • Digging deeper: Exploring the WSS Content 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: sql, management, manage, structure, database, server,

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Part 7 - Miscellaneous For matting Options

Part 7 - Miscellaneous Formatting Options - view details
In our last video in the series we will�� briefly discuss some of the miscellaneous topics that didn't fit anywhere else in this series in regards to formatting our chart.

Highlights from this video:

  • Working with the 3-D effect on your chart
  • Using the format code and point labels
  • Editing the appearance of specific values when working with a color palette
    • Changing bar color
    • Gradients
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: chart, graph, chart control, custom, format, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

Wednesday, July 23, 2008

New SharePoint Video Tutorial: Installing SQL Server Management S tudio Express Edition And Connecting To The SharePoint Database

Installing SQL Server Management Studio Express Edition And Connecting To The SharePoint Database - view details
Behind the scenes of Windows SharePoint Services(WSS), is Microsoft SQL Server. If you allow SQL to install the SQL Server 2005 Embedded Edition when you first install WSS, you can then take advantage of SQL management for your database. By visiting www.Microsoft.com/sql you can download the SQL Server Managemnt Studio (SSMS) Express Edition, which we will be installing in this video. In this video tutorial, Grant will walk you through the complete installation of SSMS and demonstrate to you how you can connect to your SharePoint database.

Highlights from this video:
  • Setting up your install
  • Browsing for/connecting to your server when working in SSMS
    • The magic string for connecting to your SharePoint server
  • Navigating the Object Explorer in SSMS
  • What can we do with our information in our database?
  • Browsing through your tables
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: install, ssms, sql server, management studio, connect, database, installing,

posted by Scott Whigham @ 11:00 AM  

New SharePoint Video Tutorial: How Does SharePoint Work : Looking At SharePoint from a SQL Server Administration Point Of View

How Does SharePoint Work : Looking At SharePoint from a SQL Server Administration Point Of View - view details
In this video we will take a look at what makes up a SharePoint site via a behind-the-scenes look. We know that the majority of our SharePoint management is done using a web interface to either a SharePoint site or to the SharePoint configuration management on the server that has SharePoint installed on it. In this video we will go below that surface level to what is operating below with SQL.

Highlights from this video:
  • About the SharePoint structure
  • How SharePoint interacts with SQL Server
    • What happened when I first installed my SharePoint server?
    • What will be installed specifically for SQL Server?
  • Demystifiying the 4 main databases
    • System Database
    • Admin Content
    • WSS Content
    • WSS Search
  • Digging deeper: Exploring the WSS Content 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: sql, management, manage, structure, database, server,

posted by Scott Whigham @ 10:58 AM  

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

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

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

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

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

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

posted by Scott Whigham @ 10:55 AM  

Friday, July 4, 2008

New SQL Server Video Tutorial: Backup and Recovery - An Introduct ion to the Three Main Types of Backups in SQL Server 2000

Backup and Recovery - An Introduction to the Three Main Types of Backups in SQL Server 2000 - view details
Ahhhhh, backup and recovery - the "Bread and Butter" of every SQL Server DBA's life, right? This video is an excellent introduction to the different types of SQL Server backups - the full backup, the differential backup and the transaction log backup. EVERY administrator and developer should have a strong understanding of the types of backups in SQL Server 2000. Do you need to watch this video? Answer this question, "Which of the following backup types clear out the online transaction log (truncate the log) - full, differential, and/or transaction log backup?" Did you get the right answer? Oh - you don't know if you got the right answer? Then you're guessing and you should watch this video!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 backup, sql server backup types, sql server transaction log backup

posted by Scott Whigham @ 4:35 AM  

Thursday, July 3, 2008

New SQL Server Video Tutorial: Backup and Recovery - An Introduct ion to the Three Main Types of Backups in SQL Server 2000

Backup and Recovery - An Introduction to the Three Main Types of Backups in SQL Server 2000 - view details
Ahhhhh, backup and recovery - the "Bread and Butter" of every SQL Server DBA's life, right? This video is an excellent introduction to the different types of SQL Server backups - the full backup, the differential backup and the transaction log backup. EVERY administrator and developer should have a strong understanding of the types of backups in SQL Server 2000. Do you need to watch this video? Answer this question, "Which of the following backup types clear out the online transaction log (truncate the log) - full, differential, and/or transaction log backup?" Did you get the right answer? Oh - you don't know if you got the right answer? Then you're guessing and you should watch this video!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 backup, sql server backup types, sql server transaction log backup

posted by Scott Whigham @ 12:34 PM  

New Reporting Services Video Tutorial: Part 5 - More on Working w ith Series and How to Customize the Legend

Part 5 - More on Working with Series and How to Customize the Legend - view details
In this video, Scott will wrap up his discussion on series and the category groups and then discuss��how to��format and tailor various aspects about your legend/key.

Highlights from this video:
  • Implementing a third level in your hierarchy
  • Positioning the legend
    • How to the chart changes in response
    • Legend layout
    • Displaying the legend in the plot area
  • Customizing the legend style properties
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, chart, chart control, customize, customizing, customization, forma

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Part 4 - Customizing Your Charts Using Series and Formatting

Part 4 - Customizing Your Charts Using Series and Formatting - view details
In this video we will take a look at what a series is when working with our numerous data elements and also begin to format our chart and series.

Highlights from this video:
  • Review of our query
    • Relationships and datalevels
  • What is a series and what does it do to our chart?
    • When to use a series
    • What to put in a series
  • Best practices for working with a series
  • Hierarchies in category groups
    • Assigning parent groups
    • Modifying properties
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: chart, chart control, customize, customizing, custom, series, format, formatting, query, category,, introduction, step by step,

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Part 3 - Customizing Your Charts Using the GUI and Category Groups, Groupings, and How to Manage Hie rarchies

Part 3 - Customizing Your Charts Using the GUI and Category Groups, Groupings, and How to Manage Hierarchies - view details
In this third video in the series, we will continue with further customization of our chart via use of the graphical user inteface (GUI) and the Chart Properties.

Highlights from this video:
  • Exploring general chart properties
    • Chart area style
    • Plot area style
  • Customizing chart properties for data
    • Grouping and sorting
    • Category groups and context
  • Grouping and sorting properties
    • How Label and Fields work together
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: chart, chart control, customize, customizing, customization, gui, properties, , introduction, step by step, beginner, beginning,

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Part 6 - Customizing Your Charts Using Labels, Gridlines, and Markers

Part 6 - Customizing Your Charts Using Labels, Gridlines, and Markers - view details
In this sixth video in the series, we will continue customizing��our graph by modifying the properties of the��labels, gridlines, and markers.

Highlights from this video:
  • Adding markers and point labels to your data elements on the chart
  • Tailoring axis intervals and appearance
  • Plotting specific data as a line in a column/bar chart
  • Formatting the labels and adding gridlines
    • Coloring the gridlines
    • Setting gridline intervals
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: chart, graph, chart control, custom, format, label, gridline, marker,, introduction, step by step, beginner, beginning, for dumm

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Part 2 - Creating Our Firs t Report With the Chart Control

Part 2 - Creating Our First Report With the Chart Control - view details
Now that we have our data, we can begin building and customizing our chart in this second video in our 7-part series.
  • How to begin building a new chart control
    • Where is it exposed?
  • Creating a new dataset
  • Exploring the Chart Control interface
  • Altering the chart layout, chart type, legend position
  • Customizing chart properties
    • Chart name
    • Chart title
    • Chart color palette, etc
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

posted by Scott Whigham @ 4:35 AM  

New Reporting Services Video Tutorial: Part 1 - The Chart Control : Understanding the Query/Database for the Demo

Part 1 - The Chart Control: Understanding the Query/Database for the Demo - view details
In this video series, Scott Whigham will introduce you to the chart control in SQL Server 2005 Reporting Services. Scott will talk about the various types of charts you can create, as there are so many different customization options, and ��walk you through the various customization options.

In this first video in the 7-part series, Scott will walk you through the basics of creating a decent query. Scott works in the AdventureWorks database, so you can play along at home!

Highlights from this video:

  • Building a basic dataset
  • About the master detail relationship
    • Examples form AdventureWorks
    • Identifying the master
    • Identifying the detail
  • Populating our base query

��

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: chart, chart control, build, dataset, query, adventureworks, master, detail,, introduction, step by step, beginner, beginning, f

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part 7 - SSIS Package Configurations: Import a Text File Using a SQL Server Package Con figuration (Pt. B)

Part 7 - SSIS Package Configurations: Import a Text File Using a SQL Server Package Configuration (Pt. B) - view details
In our seventh and final video in the series, we will wrap up our demo of how to import a text file via package configuration by finally adding and implementing the actual package configuration.

Highlights from this video:
  • Adding the Package Configuration
    • 2 various methods
  • Updating your ConfiguredValue
  • What will happen at run-time?
  • Tracking ConfigurationFilter usage
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: package, configure, configuration, import, file, sql, configurationfilter,

posted by Scott Whigham @ 4:35 AM  

Wednesday, July 2, 2008

New Reporting Services Video Tutorial: Part 7 - Miscellaneous For matting Options

Part 7 - Miscellaneous Formatting Options - view details
In our last video in the series we will�� briefly discuss some of the miscellaneous topics that didn't fit anywhere else in this series in regards to formatting our chart.

Highlights from this video:

  • Working with the 3-D effect on your chart
  • Using the format code and point labels
  • Editing the appearance of specific values when working with a color palette
    • Changing bar color
    • Gradients
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: chart, graph, chart control, custom, format, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 12:28 PM  

New Reporting Services Video Tutorial: Part 6 - Customizing Your Charts Using Labels, Gridlines, and Markers

Part 6 - Customizing Your Charts Using Labels, Gridlines, and Markers - view details
In this sixth video in the series, we will continue customizing��our graph by modifying the properties of the��labels, gridlines, and markers.

Highlights from this video:
  • Adding markers and point labels to your data elements on the chart
  • Tailoring axis intervals and appearance
  • Plotting specific data as a line in a column/bar chart
  • Formatting the labels and adding gridlines
    • Coloring the gridlines
    • Setting gridline intervals
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: chart, graph, chart control, custom, format, label, gridline, marker,, introduction, step by step, beginner, beginning, for dumm

posted by Scott Whigham @ 12:27 PM  

New Reporting Services Video Tutorial: Part 5 - More on Working w ith Series and How to Customize the Legend

Part 5 - More on Working with Series and How to Customize the Legend - view details
In this video, Scott will wrap up his discussion on series and the category groups and then discuss��how to��format and tailor various aspects about your legend/key.

Highlights from this video:
  • Implementing a third level in your hierarchy
  • Positioning the legend
    • How to the chart changes in response
    • Legend layout
    • Displaying the legend in the plot area
  • Customizing the legend style properties
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, chart, chart control, customize, customizing, customization, forma

posted by Scott Whigham @ 12:27 PM  

New Reporting Services Video Tutorial: Part 4 - Customizing Your Charts Using Series and Formatting

Part 4 - Customizing Your Charts Using Series and Formatting - view details
In this video we will take a look at what a series is when working with our numerous data elements and also begin to format our chart and series.

Highlights from this video:
  • Review of our query
    • Relationships and datalevels
  • What is a series and what does it do to our chart?
    • When to use a series
    • What to put in a series
  • Best practices for working with a series
  • Hierarchies in category groups
    • Assigning parent groups
    • Modifying properties
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: chart, chart control, customize, customizing, custom, series, format, formatting, query, category,, introduction, step by step,

posted by Scott Whigham @ 12:26 PM  

New Reporting Services Video Tutorial: Part 3 - Customizing Your Charts Using the GUI and Category Groups, Groupings, and How to Manage Hie rarchies

Part 3 - Customizing Your Charts Using the GUI and Category Groups, Groupings, and How to Manage Hierarchies - view details
In this third video in the series, we will continue with further customization of our chart via use of the graphical user inteface (GUI) and the Chart Properties.

Highlights from this video:
  • Exploring general chart properties
    • Chart area style
    • Plot area style
  • Customizing chart properties for data
    • Grouping and sorting
    • Category groups and context
  • Grouping and sorting properties
    • How Label and Fields work together
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: chart, chart control, customize, customizing, customization, gui, properties, , introduction, step by step, beginner, beginning,

posted by Scott Whigham @ 12:26 PM  

New Reporting Services Video Tutorial: Part 2 - Creating Our Firs t Report With the Chart Control

Part 2 - Creating Our First Report With the Chart Control - view details
Now that we have our data, we can begin building and customizing our chart in this second video in our 7-part series.
  • How to begin building a new chart control
    • Where is it exposed?
  • Creating a new dataset
  • Exploring the Chart Control interface
  • Altering the chart layout, chart type, legend position
  • Customizing chart properties
    • Chart name
    • Chart title
    • Chart color palette, etc
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

posted by Scott Whigham @ 12:25 PM  

New Reporting Services Video Tutorial: Part 1 - The Chart Control : Understanding the Query/Database for the Demo

Part 1 - The Chart Control: Understanding the Query/Database for the Demo - view details
In this video series, Scott Whigham will introduce you to the chart control in SQL Server 2005 Reporting Services. Scott will talk about the various types of charts you can create, as there are so many different customization options, and ��walk you through the various customization options.

In this first video in the 7-part series, Scott will walk you through the basics of creating a decent query. Scott works in the AdventureWorks database, so you can play along at home!

Highlights from this video:

  • Building a basic dataset
  • About the master detail relationship
    • Examples form AdventureWorks
    • Identifying the master
    • Identifying the detail
  • Populating our base query

��

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: chart, chart control, build, dataset, query, adventureworks, master, detail,, introduction, step by step, beginner, beginning, f

posted by Scott Whigham @ 12:24 PM  

Tuesday, July 1, 2008

New SQL Server Integration Services Video Tutorial: Part 4 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server ( Pt. B)

Part 4 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server (Pt. B) - view details
In this fourth video in the series, Scott will really delve into the best practices on the package configurations table and discuss why those settings are optimal.

Highlights from this video:
  • Problems with using the ConfigurationFilter defaults
    • Table logic
    • How to effectively run commands
    • Specifying PackagePath correctly
  • Modifying the configuration table
    • Primary key
    • Indexes
      • Where to place an index
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: package, configure, package configuration, best practice, table, configuration, sql, ssis.

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Part 5 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server ( Pt. C)

Part 5 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server (Pt. C) - view details
In this fifth video in the series, Scott will implement the best practices and walk you through the creation of��a table based off of��that approach.

Highlights from this video:
  • Creating the table based of template
  • Creating another configuration filter
  • Shortcut syntax
  • Should ConfigurationFilter and PackagePath be unique?
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: package, configure, configuration, ssis, sql, best practices, filter,

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Part 6 - SSIS Package Configurations: Import a Text File Using a SQL Server Package Con figuration (Pt. A)

Part 6 - SSIS Package Configurations: Import a Text File Using a SQL Server Package Configuration (Pt. A) - view details
In this sixth video in the series, Scott will give you a great real-world demonstration of using a package configuration to import a text file. This first part of the import will focus on setting up your variable, database, and package.

Highlights from this video:
  • Creating your package and working with the Flat File Source Editor
  • Working around the defaults in the Flat File Connection Manager Editor
  • Delaying file validation
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: package, configure, configuration, import, text, ssis,

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Part 3 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server ( Pt. A)

Part 3 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server (Pt. A) - view details
After looking through the basics of the table, Scott will now begin working around the defaults and show you the best practices for how to begin using and managing the SQL Server Package Configurations.

Highlights from this video:

  • What happens when I remove my Package Configuration?
  • Reusing or overwriting existing configuration filters
  • Exporting the values of the configurations via Package Configuration Wizard��
  • Updating the table to use the configuration values you want
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: package, configure, package configuration, configurations, wizard, filter, table

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: Part 2 - Usin g SQL Server Package Configurations in SSIS

Part 2 - Using SQL Server Package Configurations in SSIS - view details
This second video in the series will continue where the first video left off by further discussing and demonstrating the use of SQL Server Package Configurations. By the end of this video, you will have successfully created a new Package Configuration.

Highlights from this video:
  • Choosing the appropriate database for your package configurations
    • Creating and working with a database specifically for utilities, such as package configurations
  • Walking through the Package Configuration Wizard
    • Connecting to a database
    • Creating a table
    • Selecting properties to export (objects that will be changed at run-time)
  • Defining Configurations table columns and finishing a Package Configuration
    • ConfigurationFilter
    • ConfiguredValue
    • PackagePath
    • ConfiguredValueType
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: package, configure, package configuration, ssis, wizard, sql,

posted by Scott Whigham @ 7:35 AM  

New SQL Server Video Tutorial: Part 6 - Finalizing the Automation with a SQL Job and Windows Task

Part 6 - Finalizing the Automation with a SQL Job and Windows Task - view details
In this final video in our series, Scott will cover how to schedule the automation as a either a job or a Windows task, the final piece you need to know in working with these essential stored procedures.

Highlights from this video:
  • Recap of our stored procedures
  • Practicing scheduling a nightly backup via SQL Job
    • Step-by-step procedure
  • Practicing scheduling a weekly copy via Windows Scheduler
    • Walking through the process
    • Various techniques
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: automation, stored, procedure, windows, task, job, sql, schedule, scheduler,

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: Part 4 - Install Exchange 200 7 onto First Node

Part 4 - Install Exchange 2007 onto First Node - view details
With our Windows 2003 cluster running and setup to work with the Majority Node Set, we'll begin our Exchange 2007 installation on our first cluster node in this fourth video in the series.

Highlights from this video:

  • Pre-installation check
  • Configuration of Custom Exchange Server Installation
    • Installing Active Clustered Mailbo and cluster IP address
  • Adding Windows components for your install
  • Finalizing the install and rebooting your 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: cluster, continuous, replication, ccr, node, install,server, majority node set,

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: Part 1 - Discussion on Cluste r Continuous Replication

Part 1 - Discussion on Cluster Continuous Replication - view details
Offering server high availability and an automated failover process, Cluster Continuous Replication (CCR) is great for those of you who have numerous Exchange 2007 servers. With CCR we can eliminate the need for the storage array in the Storage Area Network, saving you a whole lot of money, by using a local disk. In this video series, your instructor Grant Moyle will walk you through the long process of installing Exchange 2007 in CCR configuration as well as��go over how the cluster actually works and the basic recipe needed to build the cluster. The subsequent videos in this series��will build on this info and install the two cluster nodes, the Windows components of clustering, the Exchange components of clustering, and we'll end the series with a completed Exchange 2007 CCR configuration.

Highlights from this video:

  • About working with��Cluster Continour Replication
  • Prep-work and prerequisites for the cluster setup
  • Examine existing network configuration
    • Configuring a new local area connection
  • Configuring Local Disk and Heartbeat Network
  • Ideal configuration for your servers
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: ccr, cluster, continuous, replication, failover, server, node,

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: Part 6 - Testing Creation of a New Mailbox on the Cluster and Moving a Mailbox to the Cluster

Part 6 - Testing Creation of a New Mailbox on the Cluster and Moving a Mailbox to the Cluster - view details
Once you have an Exchange cluster up and running, you will want to begin putting some mailboxes on it. In this video, your instructor will present you with two scenarios for putting a new mailbox on the cluster: creating a new mailbox and/or moving a mailbox.

Highlights from this video:
  • Creating a new user mailbox
    • Proving the mailbox exists on the cluster
  • Cluster administration and about front-end interaction
  • How to move a users mailbox from the standalone server to the cluster
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: cluster, mailbox, create, move, moving, creating, mail box,

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: Part 3 - Majority Node Config uration, Second Cluster Node Install and Testing

Part 3 - Majority Node Configuration, Second Cluster Node Install and Testing - view details
Now that we have our cluster up and running, we'll need to configure it so the majority node set is pointing to our File Witness Share that we created, and we'll also need to add our Exchange Server B to it. In this third video in the series, Grant will walk you through those setup processes.

Highlights from this video:
  • Where does my Majority Node Set currently point?
    • Setting the correct path
    • Configuring the cluster to use Majority Node Set
  • Adding a second cluster node to cluster
  • Test cluster failover
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: cluster, continuous, replication, ccr, node, majority, failover,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part 1 - What Are Package Configurations and How Do You Use Them?

Part 1 - What Are Package Configurations and How Do You Use Them? - view details
A common problem that many people encounter in DTS is moving packages between their development, test, and production environments. In DTS this would require a handful of edits to make sure the connection objects were pointing to the correct servers. Integration Services, SSIS, has fortunately provided us with a solution to this problem - package configurations! Package configurations allow your package to be dynamically updated at run-time, thus saving you time by eliminating those pesky manual edits.

In this video series, we will talk more about package configurations in SSIS and see a little bit more of storing the package configurations inside SQL Server. We will also go over some best practices as well as take our demos beyond what the defaults are. In this first video in the series, Scott will go over the concept of package configurations and demonstrate to you how to use them

Highlights from this video:

  • Basics of Package Configurations via Variables
    • Creating a package
    • Accessing the variable
  • Working with SQL Server 2008 and SQL Server 2005
  • Enabling and Adding configurations for your package
  • Working in the Package Configuration Wizard
    • Getting started
    • Specifying configuration 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: package, package configuration, configure, variable, dts, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: Part 5 - Install Exchange 200 7 onto Second Node

Part 5 - Install Exchange 2007 onto Second Node - view details
After Server A is running as an active node and��you've restarted the Exchange resource group, we'll install Exchange 2007 as the passive node in CCR��on Server B, which works kind of like the last one we did with a few exceptions.��

Highlights from this video:
  • Installing Windows components
  • Custom Exchange Server installation
    • Passive Clustered Mailbox Role��
  • What are we going to get out of our Exchange cluster?
  • Testing Exchange cluster failover
and much more