Tuesday, March 27, 2007

New Microsoft SQL Server Video Tutorial: An Overview of the Northwind Database

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

NOTE: You can download the Northwind (and Pubs) sample databases from the microsoft.com website here
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sample database, sample db, install sample, oltp database, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 3:52 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Using Aliases and the Client Network Utility

Using Aliases and the Client Network Utility - view details
Scott Whigham, our resident SQL Guru, says that creating aliases for his SQL Servers is one of his favorite "little things" to do on his servers. It isn't a big thing - aliases are very simple actually - but they sure does make life easier. This video shows you how you can create aliases, what the benefits of aliases are, and when you would likely use them. A great video for all skill levels
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 alias, client alias sql server

posted by Scott Whigham @ 3:52 AM   0 comments  

New Microsoft SQL Server Video Tutorial: SQL Server's Services - MSSQLSERVER, SQLAGENT, MSDTC and more

SQL Server's Services - MSSQLSERVER, SQLAGENT, MSDTC and more - view details
More and more we need to know the internals of the heavy software - the architecture of the beast, if you will. This video's goal is to teach you the services that SQL Server uses - the SQL Server service (MSSQLServer for the default instance and MSSQL$InstanceName for other instances), the SQL Agent service, and the ancillary services like Full-Text's Microsoft Search Service and the MSDTC - the Microsoft Distributed Transaction Coordinator Service. This video provides an excellent overview of how SQL Server works within the operating system and how the services work with each other
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 service account, sql account

posted by Scott Whigham @ 3:52 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Multiple Instances - Lecture on When They're Appropriate and Special Considerations

Multiple Instances - Lecture on When They're Appropriate and Special Considerations - view details
You probably already know that SQL Server 2000 allows you to install multiple named instances but do you know the details? When should you use named instances? How could you use them? Scott Whigham, SQL trainer, gives you his takes on working with multiple instances in this video and includes some excellent examples of when to use named instances to save yourself development and testing time
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: multiple sql instances, sql named instance, second instance

posted by Scott Whigham @ 3:52 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency!

Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency! - view details
Real-World Scenario - your boss (or client) calls you at 4:54PM on Friday afternoon and says, "All of my people are getting an error working with Application X. Can you check what's going on?" You take a look and, sure enough, your transaction log has taken up the entire disk! Your data file is regular size but your transaction log is HUGE. What do you do? If you answered, "Take a transaction log backup" then you need to watch this video (because the log is full, it will not allow you to take a "traditional" transaction log backup). This video, recorded by resident SQL guru Scott Whigham, presents you with the What-If's, the Why's, and How To's of solving this very problem.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: truncate log, sql truncate, sql log filled up

posted by Scott Whigham @ 3:52 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Backup Devices, Backup Sets, Database Dumps and Media Sets

Backup Devices, Backup Sets, Database Dumps and Media Sets - view details
This video is designed to help you speak the language of SQL Server (so that you at least sound like you know what you're talking about!). This video is really intended for those somewhat new to taking backups in SQL Server 2000. It covers basic topics like the terms used when discussing backups, old terms, uncommon terms that you might hear or see used for backups, and the use of the "Backup Device" in SQL Server. You'll also learn about the concepts of backup sets and media sets and how SQL Server uses each.

This video was recorded using SQL Server 2000 but the concepts and even the screens are almost identical in SQL Server 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: sql backup device, sql media set, sql server backup set

posted by Scott Whigham @ 3:52 AM   0 comments  

New Microsoft SQL Server Video Tutorial: SQL Server 2005 Transaction Log Is Full - log_reuse_wait_desc and sys.databases Error

SQL Server 2005 Transaction Log Is Full - log_reuse_wait_desc and sys.databases Error - view details
What do you do when your transaction log is full - how do you fix it? This video walks about just that as well as highlights some gotchas along the way. This video talks architecture as well as providing practical examples or truncating the log and backing up the log as options.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: transaction log filled disk, disk full, tran log full, truncate log

posted by Scott Whigham @ 3:52 AM   0 comments  

New Microsoft SQL Server Video Tutorial: SQL Server 2005 Services and Service Accounts - What They Do and What's New

SQL Server 2005 Services and Service Accounts - What They Do and What's New - view details
This video walks you through the SQL Browser service (SqlBrowser) and talks about some of the new SQL Server service accounts with a heavy focus on what's new and what's changed in SQL 2005. The service account names have changed, there are a few new services, and some new wrinkles in the still-the-same services as well.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 service accounts, mssql, mssqlserver, mssql$, sql agent, full-text, sql browser

posted by Scott Whigham @ 3:52 AM   0 comments  

New Microsoft SQL Server Video Tutorial: How to Change the SQL Server TCP IP Port Number Using the Server Network Utility

How to Change the SQL Server TCP IP Port Number Using the Server Network Utility - view details
What TCP/IP port has IANA assigned for Microsoft to use for a SQL Server instance - do you know? So does everyone else! One of the first things that a DBA does (if he/she wants to setup a secure SQL Server) if to change the default SQL Server port number from 1433 to something else. This video shows you the how, the how it works, and also gives recommendations for network libraries and more. This should be considered required viewing for all SQL Server DBAs.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: change sql tcp ip port number

posted by Scott Whigham @ 3:52 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Backup and Recovery - An Introduction 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 @ 3:52 AM   0 comments  

Tuesday, March 06, 2007

New Microsoft SQL Server Video Tutorial: Pt. 2 - Installing SQL Server 2005 Express Edition on Windows Vista

Pt. 2 - Installing SQL Server 2005 Express Edition on Windows Vista - view details
Pt. 2 - Installing SQL Server 2005 Express Edition on Windows Vista
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 - Installing SQL Server 2005 Express Edition on Windows Vista

posted by Scott Whigham @ 4:05 AM   0 comments  

New Microsoft SQL Server Video Tutorial: SQL Server 2005 Transaction Log Is Full - log_reuse_wait_desc and sys.databases Error

SQL Server 2005 Transaction Log Is Full - log_reuse_wait_desc and sys.databases Error - view details
What do you do when your transaction log is full - how do you fix it? This video walks about just that as well as highlights some gotchas along the way. This video talks architecture as well as providing practical examples or truncating the log and backing up the log as options.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: transaction log filled disk, disk full, tran log full, truncate log

posted by Scott Whigham @ 4:05 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - Installing SQL Server 2005 Express Edition on Windows Vista

Pt. 1 - Installing SQL Server 2005 Express Edition on Windows Vista - view details
Pt. 1 - Installing SQL Server 2005 Express Edition on Windows Vista
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 - Installing SQL Server 2005 Express Edition on Windows Vista

posted by Scott Whigham @ 4:05 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 3 - Working with the Documentation and Books Online

Pt. 3 - Working with the Documentation and Books Online - view details
Pt. 3 - Working with the Documentation and Books Online
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 - Working with the Documentation and Books Online

posted by Scott Whigham @ 4:05 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 4 - Working With SQL Server 2005 Management Studio Express Edition

Pt. 4 - Working With SQL Server 2005 Management Studio Express Edition - view details
Pt. 4 - Working With SQL Server 2005 Management Studio Express Edition
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 - Working With SQL Server 2005 Management Studio Express Edition

posted by Scott Whigham @ 4:05 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 4 - Using the SQL Server Configuration Manager

Pt. 4 - Using the SQL Server Configuration Manager - view details
Pt. 4 - Using the SQL Server Configuration Manager
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 port number, server network utility, client network utility, services

posted by Scott Whigham @ 4:05 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 3 - Post-Install: Examining an Installation of SQL Server 2005 Express Edition

Pt. 3 - Post-Install: Examining an Installation of SQL Server 2005 Express Edition - view details
Pt. 3 - Post-Install: Examining an Installation of SQL Server 2005 Express Edition
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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 2005, msde

posted by Scott Whigham @ 4:05 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 5 - Using SQL Server Management Studio (SSMS) Express

Pt. 5 - Using SQL Server Management Studio (SSMS) Express - view details
Pt. 5 - Using SQL Server Management Studio (SSMS) Express
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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, enterprise manager, query analyzer

posted by Scott Whigham @ 4:05 AM   0 comments  

New Microsoft SQL Server Video Tutorial: An Overview of the Northwind Database

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

NOTE: You can download the Northwind (and Pubs) sample databases from the microsoft.com website here
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sample database, sample db, install sample, oltp database, beginner, beginning, for beginne rs, introduction, step by step

posted by Scott Whigham @ 4:04 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - An Overview of SQL Server Clustering

Pt. 2 - An Overview of SQL Server Clustering - view details
Part two continues our discussion of clustering SQL Server with a discussion of the different types of clusters and how each works.

Highlights from this video:
  • Active/Passive clustering concepts (a.k.a. Single Instance clustering)
  • Active/Active clustering (a.k.a. Multiple Instance clusters)
  • Best Practices for clustering
  • Groups, resources, nodes, and more terms
  • Service pack installation discussion
  • Silent installs of passive nodes
  • Disk management and SANs
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, clustering , disaster recovery, san, lun, logical unit

posted by Scott Whigham @ 4:04 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Backup and Recovery - An Introduction 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:04 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 4 - Installing the Client Tools and Managing the Cluster

Pt. 4 - Installing the Client Tools and Managing the Cluster - view details
The last video in this series talks about how to install the client tools (such as SSMS - SQL Server Management Studio) on a remote machine (i.e., your desktop) and how to manage the cluster remotely.��
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: installing Sql server 2005 clustering, clustered sql server, ssms, BIDS, business intelligence development studio

posted by Scott Whigham @ 4:04 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Backup Devices, Backup Sets, Database Dumps and Media Sets

Backup Devices, Backup Sets, Database Dumps and Media Sets - view details
This video is designed to help you speak the language of SQL Server (so that you at least sound like you know what you're talking about!). This video is really intended for those somewhat new to taking backups in SQL Server 2000. It covers basic topics like the terms used when discussing backups, old terms, uncommon terms that you might hear or see used for backups, and the use of the "Backup Device" in SQL Server. You'll also learn about the concepts of backup sets and media sets and how SQL Server uses each.

This video was recorded using SQL Server 2000 but the concepts and even the screens are almost identical in SQL Server 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 T SCC codec installed to view this video

Keywords Associated with this video: sql backup device, sql media set, sql server backup set

posted by Scott Whigham @ 4:04 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 3 - Reviewing the Cluster Installation

Pt. 3 - Reviewing the Cluster Installation - view details
Now that the cluster is installed, we'll want to review what has been installed and where it has been installed (i.e., is it on the local C drive or on the SAN?).
To down load this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: installing Sql server 2005 clustering, clustered sql server

posted by Scott Whigham @ 4:04 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - An Overview of SQL Server Clustering

Pt. 1 - An Overview of SQL Server Clustering - view details
This video, part one in our series, discusses the clustering model of Windows 2003 and how SQL Server clustering works. This video (the whole series actually) should be considering a pre-requisite for the cluster installation/management/failover/failback videos.

Highlights from this video:
  • Discussions of Clustering and Clusters
  • Requirements for clustering SQL Server 2005/2000
  • Best Practices for configuring the cluster
  • Working with the utilities such as comclust.exe (the Cluster Administrator)
  • Service accounts and suggestions
  • How private namespace domains (.local domains) can be used with SQL clusters
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, clustering, disaster recovery

posted by Scott Whigham @ 4:04 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency!

Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency! - view details
Real-World Scenario - your boss (or client) calls you at 4:54PM on Friday afternoon and says, "All of my people are getting an error working with Application X. Can you check what's going on?" You take a look and, sure enough, your transaction log has taken up the entire disk! Your data file is regular size but your transaction log is HUGE. What do you do? If you answered, "Take a transaction log backup" then you need to watch this video (because the log is full, it will not allow you to take a "traditional" transaction log backup). This video, recorded by resident SQL guru Scott Whigham, presents you with the What-If's, the Why's, and How To's of solving this very problem.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: truncate log, sql truncate, sql log filled up

posted by Scott Whigham @ 4:04 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - Setting Up an Active/Passive (Single Instance) Cluster

Pt. 2 - Setting Up an Active/Passive (Single Instance) Cluster - view details
Now that we've installed the .NET Framework, let's continue our installation by going through the SQL Server setup program.

Highlights from this video:
  • Installation of the cluster
  • Virtual servers
  • Public IP address and Private IP addresses
  • Adding resources and groups to the cluster
  • Service accounts and domain groups (and using net domain)
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, clustering, disaster recovery, install, create, setup, installation, installing, building

posted by Scott Whigham @ 4:04 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - An Overview of the Active/Passive (Single Instance) Cluster

Pt. 1 - An Overview of the Active/Passive (Single Instance) Cluster - view details
Part one in our series on installing a SQL Server cluster covers the concepts of using Single Instance clusters (Active/Passive).

Highlights from this video:
  • Detailed breakdown of failover concepts and how clusters work
  • Discussions of virtual servers and virtual server names
  • Best Practices for installation
  • Installation of the first steps for your 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, clustering, disaster recovery, install, create, setup, installation, installing, building

posted by Scott Whigham @ 4:04 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - Verifying the Service Pack Installation

Pt. 2 - Verifying the Service Pack Installation - view details
After you install the service pack, you'll want to verify the service pack was successful. This video helps you view several ways to view the logs and file versions.
To do wnload this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sp2, sp1, clustered service packs, SPS, installing, installation, setup.bat

posted by Scott Whigham @ 4:03 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - Installing Service Pack 2 on Your SQL Server Cluster

Pt. 1 - Installing Service Pack 2 on Your SQL Server Cluster - view details
SP2 is the latest service pack from Microsoft and this video helps you view a service pack installation on a cluster. You'll walk through the entire installation as well as the verification of the installation.

Highlights from this video:
  • Installing SQL Server 2005 Service Pack 2 CTP (a.k.a. the Beta version)
  • Best Practices for installing service packs
  • Managing the cluster and verifying the Active/Passive nodes
  • Tips and techniques for a smooth upgrade
  • Viewing the new setup bootstrapping program in SP2
  • Suggestions for disaster recovery/rollback
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 vi ew this video

Keywords Associated with this video: sp2, sp1, clustered service packs, SPS, installing, installation, setup.bat

posted by Scott Whigham @ 4:03 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - Transactions and Failover

Pt. 2 - Transactions and Failover - view details
This video continues our discussion of failover and failback with discussions of what happens after Node1 crashes (blue screens, power outage, etc). Also a detailed discussion of the recovery process and visualizations of how the cluster handles failover/failback.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-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, clustering, disaster recovery, install, create, setup, installation, installing, building

posted by Scott Whigham @ 4:03 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - Transactions and Failover

Pt. 1 - Transactions and Failover - view details
Now that you have installed your cluster, you'll want to test the failover - right? You do want to make sure it works in the event of a disaster, don't you?

Scared?

Just a bit?

Well, there's no need - clusters are no longer incredibly difficult to manage and certainly SQL Server's integration within the cluster makes this a much less painful process than in years past.

Highlights from this video:
  • What happens to running queries/transactions when a failover event (i.e., a failure) occurs?
  • How to manually failover and failback
  • Identifying your service pack level
  • Using the Cluster Administrator (comclust.exe) to manage your groups and resources
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 th e TSCC codec installed to view this video

Keywords Associated with this video: fail over, failback, fail back, active, passive, node, virtual server

posted by Scott Whigham @ 4:03 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 2 - Installing SQL Server 2005 Express Editions

Pt. 2 - Installing SQL Server 2005 Express Editions - view details
Once you have a solid understanding of the various Express Editions available from Microsoft, now it's time to get started with the installation of SQL Server 2005.

Highlights from this video:
  • Suggestions for installing SQL Server 2005
  • Understanding the setup options
  • Optional components
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: setup, install, installing, installation

posted by Scott Whigham @ 4:03 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Pt. 1 - Introduction to the Express Editions of Visual Studio and SQL Server

Pt. 1 - Introduction to the Express Editions of Visual Studio and SQL Server - view details
This introductory video talks to you about the Visual Studio and SQL Server Express Editions - the FREE editions of SQL Server and C#/Visual Basic (among others).

Highlights from this video:
  • Compare and contrast various Express Editions
  • Limitations of certain Express Editions
  • Updating the Express Editions
and much more.

If you are new to C#/SQL Server, THIS IS A GREAT FIRST VIDEO TO WATCH!

NOTE: This video is nearly identical to the 'What Are the Express Editions?' 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 cod ec installed to view this video

Keywords Associated with this video: beginner, beginning, intro, introduction, msde, starter

posted by Scott Whigham @ 4:03 AM   0 comments  

New Microsoft SQL Server Video Tutorial: Migrating From Express Edition to SQL Server Enterprise/Standard/et al

Migrating From Express Edition to SQL Server Enterprise/Standard/et al - view details
Are you about to move from the free version of SQL Server 2005 (SQL Server 2005 Express Edition) to a paid-for version such as Standard Edition or Developer Edition? Then you''ll want to watch this video!

Highlights from this video:
  • How to move databases from one server instance to another
  • What restrictions are there on migrating?
  • Migration 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: upgrade, migration, migrating, install, installing

posted by Scott Whigham @ 4:03 AM   0 comments  

New Microsoft SQL Server Video Tutorial: What Are the Express Editions?

What Are the Express Editions? - view details
This introductory video talks to you about the Visual Studio and SQL Server Express Editions - the FREE editions of SQL Server and C#/Visual Basic (among others).

Highlights from this video:
  • Compare and contrast various Express Editions
  • Limitations of certain Express Editions
  • Updating the Express Editions
and much more.

If you are new to C#/SQL Server, THIS IS A GREAT FIRST VIDEO TO WATCH!

NOTE: This video is nearly identical to the 'Pt. 1 - Introduction to the Express Editions of Visual Studio and SQL Server' 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: beginner, beginning, intro, introduction, msde, starter

posted by Scott Whigham @ 4:03 AM   0 comments