Wednesday, June 14, 2006

New Microsoft SQL Server Video Tutorial: Templates in SQL Server Management Studio - What They Are and How to Use Them

Templates in SQL Server Management Studio - What They Are and How to Use Them - view details
Templates were added to SQL Server 2000's Query Anaylzer and were a very handy tool (though mostly unused). SQL Server 2005's Management Studio expands on SQL Server 2000's templates by allowing you to easily add your own templates, write templates in multiple languages (such as T-SQL, XMLA or MDX), and the easy-to-use Template Explorer.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: ODBC, DSNs, and UDLs - Creating Reusable Connection Information

ODBC, DSNs, and UDLs - Creating Reusable Connection Information - view details
This video is an excellent introduction to the terms used when discussing connections to SQL Server. There are many options for connecting an application (such as Microsoft Access, ASP.NET, Java) to SQL Server and this video covers some popular options. If you've heard of ODBC and DSNs before but never really understood how they were used (or what they are) then this is a great video to watch

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: How to Increase a Database - Multiple Techniques for Increasing Data File and Transaction Log File Size

How to Increase a Database - Multiple Techniques for Increasing Data File and Transaction Log File Size - view details
What would happen to your production database(s) right now if the transaction log was 100% full? Would the files automatically grow so that there would be more space available for data or would your users be shut-out until you manually added more space? What if it happened to your data file(s)? This video talks about various ways that you, the DBA, can be proactive in managing your disk files including increasing the data file size, suggestions on using autogrowth, how the files grow and disk space is allocated in SQL Server, and much more.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Network Libraries and Authentication Modes - Choosing What's Right for Your Organization - Part 2

Network Libraries and Authentication Modes - Choosing What's Right for Your Organization - Part 2 - view details
Part 2 in our series on SQL Server Netlibs

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Part 1 - An Overview of the Setup Process Including Installing the Pre-Requisites

Part 1 - An Overview of the Setup Process Including Installing the Pre-Requisites - view details
The setup process for SQL Server 2005 is very involved, may take you over an hour (depending on features you choose and speed of media) and often features cryptic messages and stringent requirements. This video is designed to help you understand the initial setup including installing the Pre-Requisites (such as the .NET 2.0 Framework). You'll also receive a few suggestions and recommendations for ensuring a smooth setup experience.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Model Database - An Overview of How to Use It and When to Use It

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

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Part 6 - Using Aliases with TCP IP Connections

Part 6 - Using Aliases with TCP IP Connections - view details
In our final video on working with the SQL Server Network Libraries, you'll learn how to use client aliases to make your life much easier. Do you currently have to connect to your SQL Server using an IP address? If so, then you'll really get some mileage out of this video.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Part 2 - Common Table Expressions (CTEs) - Recursion and Recursive CTEs

Part 2 - Common Table Expressions (CTEs) - Recursion and Recursive CTEs - view details
This video, the second in our series on using Common Table Expressions (CTEs), walks you through recursion and working with hierarchies with CTEs. This video uses the Northwind database to simplify the learning process and uses some common recursive queries used in Northwind examples to highlight the basic use of the CTE.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: OSQL - What It Is and How to Use It

OSQL - What It Is and How to Use It - view details
OSQL is to the DOS Prompt what Query Analyzer is to Windows; i.e., OSQL is your query writing tool for working in DOS. You can interactively write code and run SQL queries, updates and the like if you want but you can also tell it to execute a script file using the "-i" switch. This video, recorded by SQL guru Scott Whigham, shows you how to use OSQL in your organization to run batch files (.bat files that run SQL scripts) and more.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Install SQL Server - Discussion of Collation Types and Recommendations

Install SQL Server - Discussion of Collation Types and Recommendations - view details
When you install SQL Server, you make perhaps one of the most important decisions you can make: which default collation you will use. Should you choose Windows Locale or a SQL Collation (and what's the difference)? Are SQL Server Authentication passwords case-sensitive (and why are you asking me that here)? Collations are incredibly important to SQL Server and the collation that you choose during setup can save you hours of frustration later on. Watch this video and get an excellent overview of what collations are and how you should go about choosing the right collation for your installation

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Defaults and Rules in SQL Server 2000 - What They Are, How to Use Them and Best Practices

Defaults and Rules in SQL Server 2000 - What They Are, How to Use Them and Best Practices - view details
What is the difference between a SQL Server Default and a Default constraint (or are they the same thing)? Should you use a Check constraint or a Rule (and are they the same thing)? SQL Server Defaults and Rules have been around forever in SQL Server but, if you don't know what they are, then you should watch this video.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

Tuesday, June 13, 2006

New Microsoft SQL Server Video Tutorial: Network Libraries and Authentication Modes - Choosing What's Right for Your Organization - Part 1

Network Libraries and Authentication Modes - Choosing What's Right for Your Organization - Part 1 - view details
Network Libraries in SQL Server are very important to SQL security. What you choose to enable or disable can have a profound impact on potential vulnerabilities. This video, Part 1, walks through the idea of Network Libraries and helps you choose the one(s) for your installation.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Pages, Extents, and Blocksizes - What They Are and How They Work

Pages, Extents, and Blocksizes - What They Are and How They Work - view details
If knowing the architecture of SQL Server is interesting to you, then you'll enjoy this video from Scott Whigham on how things like pages and indexes work in SQL Server. This is more of a theoretical discussion that discusses the sysinternals of SQL Server at a high level. The goal is to give you an understanding of how SQL Server stores data and indexes and how your index and table design decisions can influence SQL Server in multiple ways

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: How to Increase a Database's Size Using the SQL Server Enterprise Manager

How to Increase a Database's Size Using the SQL Server Enterprise Manager - view details
If you don't know the ALTER DATABASE commands for increasing your SQL Server file sizes (or don't want to use it), then this video is a great head-start to learning file manipulation and management for SQL Server 2000. Veteran SQL Server trainer Scott Whigham shows you a few of his tips and tricks for working with the Enterprise Manager as well.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Installing SQL Server 2000 - Basic Overview

Installing SQL Server 2000 - Basic Overview - view details
This video is a quick walk-through of the SQL Server install. It is aimed for those viewers wanting to see a quick install and then, after they have a good overview of how it works, want to delve deeper (by watching the other installation videos). Perfect for newbies and people migrating to SQL Server from other systems

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY

Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY - view details
If your queries and stored procedures use @@IDENTITY (perhaps you have legacy code updated from SQL Server 7.0 or earlier), you'll likely get good value from watching this video on replacing @@IDENTITY calls with the T-SQL function SCOPE_IDENTITY(). This video shows very plainly the negative possiblities of using @@IDENTITY today (triggers are a real problem) and, after you watch this tutorial, you'll never want to use @@IDENTITY again!

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET

Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET - view details
Attack! Attack! You're SQL Server is under attack! You might be quite worried if what Scott Whigham shows you in this video were to happen though on your SQL Server. This is an interesting video. It shows a known exploit against SQL Server - a hack, if you will - and how to prevent it. If you haven't worked with the registry or watched the videos on SQL Server Authentication Modes, then you might have a little bit of homework to do before watching this one. It gets pretty deep but is a very interesting study in SQL Server security and patching

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them

Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them - view details
There are far too many SQL functions to list here but what is important is what they are, what the difference is between them, and how you could/should use them. What's the difference between Niladic and Deterministic? Is GETDATE() Deterministic or Non-Deterministic? Is RAND() guaranteed to return a random number? Is NEWID() allowed as a parameter to other functions? If you haven't heard terms like Niladic or Deterministic before then you'll really appreciate this video. Also, SQL guru Scott Whigham gives an excellent breakdown of some common functions

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Making Reusable Connections

ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Making Reusable Connections - view details
The SQL Native Client, new with SQL Server 2005, is the preferred way to connect to a SQL Server 2005 instance today. This video is an excellent introduction to the terms used when discussing connections to SQL Server. There are many options for connecting an application (such as Microsoft Access, ASP.NET, Java) to SQL Server and this video covers some popular options. If you've heard of ODBC and DSNs before but never really understood how they were used (or what they are) then this is a great video to watch

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: How to Script Out the Indexes With the Table in SQL Server 2005 Management Studio

How to Script Out the Indexes With the Table in SQL Server 2005 Management Studio - view details
Curiously enough, Microsoft decided against scripting out the indexes when you script out the table in the SQL Server 2005 Management Studio. This video shows you the default "behavior" of the Management Studio, how you can spot the "problem", and how you "fix" it. It's a strange decision by Microsoft to omit this (an accident, perhaps?) but don't get caught by this "undocumented feature"!

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Result sets, Recordsets, and the Client Server model

Result sets, Recordsets, and the Client Server model - view details
This video is really helpful for you newbies - those of you who want to get up to speed on all the terms, jargon, parlance, and lexicon of SQL Server. Is a field the same as a column? An alias the same as a header? Is Result Set the same as resultset? The answer to all three questions is "Probably yes, depending on who's asking!" This video helps you dissect several (not all) of the confusing terms and tries to help you speak the language fluidly and easily. Is a recordset the same as a resultset? If you don't know, watch this video!

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Part 4 - How to Change the SQL Server 2005 TCP Port Using SQL Server Configuration Manager

Part 4 - How to Change the SQL Server 2005 TCP Port Using SQL Server Configuration Manager - view details
Quick - what is the default port number for SQL Server's TCP IP connections? Anyone who knows SQL Server knows the default port number and, if you were a hacker who wanted to attack a SQL Server, you would start with trying to go after a SQL Server using the default port number (which, by the way, is 1433). This video shows you how to identify the current port number that SQL Server is using and how to change it. This is an excellent video for configuring your SQL Server for secure connections.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use Them

Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use Them - view details
SET commands in T-SQL control the environment in which SQL Server or the client processes that client queries. This view shows you some of the more common SET commands, how they work, scoping (are they scoped to the statement, the batch, the connection?), and how you can use SET commands to increase throughput and help increase your SQL knowledge.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: EXCEPT and INTERSECT - An Introduction to Syntax and Concepts

EXCEPT and INTERSECT - An Introduction to Syntax and Concepts - view details
New in Transact-SQL for SQL Server 2005 are the EXCEPT and INTERSECT operators. These are not new SQL concepts; rather, these are just being added to SQL Server after being supported in other systems. Chances are that you've written your fair share of EXCEPT and INTERSECT-type queries but using a different syntax. NOTE: this video talks extensively about INNER and OUTER JOINs therefore a solid understanding of both is assumed.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?

JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION? - view details
So many newbies to Transact-SQL have difficulties determing when to use a UNION or a JOIN to satisy their query. This video teaches you some guidelines to help you quickly and easily identify whether your query will likely need to become a JOIN or UNION. Disclaimer: these are just guidelines and they will not work in every situation but they are applicable for most SQL developers most of the time.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: How to Upgrade The Documentation of SQL Server 2005 (Books Online)

How to Upgrade The Documentation of SQL Server 2005 (Books Online) - view details
Although the actual release for public sale of SQL Server 2005 in December of 2006, Microsoft felt compelled to release an update (a "refresh") of the documentation only a few weeks later. This video shows you how you can tell which version of Books Online (BOL) that you are running, how to update your BOL, and walks you through the process. It's actually a pretty hefty update too - over 115MB of "refreshed" documentation for a piece of software released for public sale only a few weeks earlier. You'll definitely want to upgrade your Books Online as soon as possible.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

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, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Part 1 - An Overview of the Default SQL Server Installation

Part 1 - An Overview of the Default SQL Server Installation - view details
SQL trainer Scott Whigham walks you through the default installation of SQL Server 2005 in this video, part 1 in a series on installing SQL Server 2005. In this video you'll learn about the instances, folders, services, and options chosen during the default install.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Part 3 - Choosing Your Service Accounts and a Tour of SQL Server 2005's Services

Part 3 - Choosing Your Service Accounts and a Tour of SQL Server 2005's Services - view details
SQL Server 2005 introduces a few new services and a few new choices. This video talks about the services in SQL Server 2005 including the MSSQLServer, SqlServerAgent, SqlBrowser, and more.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

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

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

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: MSDB Database - An Overview of Some of the Common System Tables and Objects

MSDB Database - An Overview of Some of the Common System Tables and Objects - view details
The MSDB database is one of the heaviest-used system databases. It stores everything from DTS packages to Jobs (and the history of each). This video walks you through the common tables (what are those RTBl_% tables anyway?), the common stored procedures and gives you an excellent insight into how SQL Server works

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Installing Service Pack 4 - Part 1

Installing Service Pack 4 - Part 1 - view details
This video walks you through the first part of installing Service Pack 4

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: How to Change SQL Server Authentication Modes with a Discussion on Differences in Service Pack Levels - Part 1

How to Change SQL Server Authentication Modes with a Discussion on Differences in Service Pack Levels - Part 1 - view details
This video series covers how to change the authentication modes (from Mixed Mode to Windows Authentication Mode and vice-versa) and shows you the differences between Service Pack levels (an RTM install of SQL Server, for example, and an SP4 install in this case)

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Enterprise Manager - Put Table On Filegroup

Enterprise Manager - Put Table On Filegroup - view details
Performance tuning SQL Server often involves tuning how SQL Server stores the data and index data. This video shows you how SQL Server uses "filegroups" to control data placement. This is often a very important performance tweak and optimization for SQL Server databases. Consider this: let's say you know that 50% of your queries run against the "Customers" table, another 25% hit the "Products" table and a whopping 75% run against the "Orders" table (remember JOINs and subqueries mean it doesn't have to add up to 100%). If you could separate the Order table onto a different file (on a different drive) from the Customers and Products table, SQL Server would be able to access all three tables in parallel (depending on hardware) which means faster access to read and write data. Filegroups are the key to understanding both data and index data placement in SQL Server

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Cross Database Ownership Chaining - What It Is and When to Use It - Part 1

Cross Database Ownership Chaining - What It Is and When to Use It - Part 1 - view details
Cross Database Ownership Chaining was introduced as a settable database and server option in SQL Server 2000's Service Pack 3 yet most people do not even know what it is. SQL Server trainer Scott Whigham shows you all the details about Cross Database Ownership Chaining in this video and also shows you how installing Service Pack 3 completely changes how your SQL Server's security model works. Microsoft does not recommend setting Cross Database Ownership Chaining for your server but why not? If you want to know the answer then watch this series of videos

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

Sunday, June 11, 2006

New Microsoft SQL Server Video Tutorial: Install SQL Server - Discussion of File Placement and Suggestions for High Performance

Install SQL Server - Discussion of File Placement and Suggestions for High Performance - view details
Here's a general rule of thumb for most SQL Server installations: the more hard drives that you can put your SQL Server's database files on, the faster your performance. This video talks about file placement and gives you a solid understanding of why SQL Server works better this way. If you really want to know the fundamentals and the architecture of SQL Server, this is an excellent place to start

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Install SQL Server - Discussions of Network Libraries Including Port Suggestions and Security Choices

Install SQL Server - Discussions of Network Libraries Including Port Suggestions and Security Choices - view details
During the installation of SQL Server 2000 you are asked which Network Libraries you would like to choose (if you choose the Custom installation). For each Network Library, you must choose the Network Address. Which are the most common network libraries used? What are the defaults? What about TCP/IP ports - which TCP port should you use for SQL Server? This video helps you make intelligent decisions that will protect your SQL Server from hackers, worms and viruses

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Install Named Instance and View Files and Folders

Install Named Instance and View Files and Folders - view details
This video is a good introduction to installing a SQL Server named instance. It also includes a tour of the changes to the file system - the new files, the new folders, and a comparison between how a default instance works versus how a named instance works.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: How to Update Your SQL Server Documentation Manually

How to Update Your SQL Server Documentation Manually - view details
At the same time that Service Pack 3 for SQL Server 2000 was released, Microsoft "refreshed" the Books Online documentation. How can you tell whether or not you're working with the latest copy? Where do you get it? Is it installed with Service Pack 3 (and what about SP4)? This video shows you the details of Microsoft's Update to Books Online and answers all these questions

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: How SQL Server Logs Errors - The SQL Server Error Log and Configuration

How SQL Server Logs Errors - The SQL Server Error Log and Configuration - view details
The SQL Server Error Log Viewer in SQL Server 2000 left quite a bit to be desired but the Error Log Viewer in SQL Server 2005 is far better and easier to work with. This video shows you a few alternatives to viewing your SQL Server configuration and errors as well as tips on configuring the SQL Server error logs so that the important logs will be there when you need them. You'll also learn about the architecture of how SQL Server logs errors so that you can manage your SQL Server most effectively.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Creating Database Diagrams in SQL Server Management Studio

Creating Database Diagrams in SQL Server Management Studio - view details
Scott Whigham, author of LearnSqlServer2005.com and LearnSqlServer2000.com, loves to show people how to create diagrams because he feels that they are essential tools for all developers and DBAs of any skill level. Database diagrams (often called Entity Relationship Diagrams or ERDs) are a visual tool that allows you to see your table layouts, relationships, datatypes and much more. This video is for those people wanting to learn how to visualize SQL problems thus helping you be able to write JOINs, subqueries, and make decisions quickly and easily in SQL Server.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: How to Change SQL Server Authentication Modes with a Discussion on Differences in Service Pack Levels - Part 2

How to Change SQL Server Authentication Modes with a Discussion on Differences in Service Pack Levels - Part 2 - view details
Part 2 in our series on changing authentication modes for SQL Server

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

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, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Discussions on Decisions Such as What to Install, Optional Components, and Infrequently Used Terms

Discussions on Decisions Such as What to Install, Optional Components, and Infrequently Used Terms - view details
SQL Server trainer and consultant Scott Whigham talks about what each of the options mean during the install regarding what tools to install (and which are his favorites) and some of the terms you might hear or use when discussing an install of SQL Server 2000.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Enterprise Manager - Registering a server

Enterprise Manager - Registering a server - view details
If you are just getting started with SQL Server and want to know how to use the Enterprise Manager, this video is for you. Before you start working with a SQL Server in the Enterprise Manager, you must "register" that server (which writes information into the Registry). This video, by SQL Server guru Scott Whigham, contains lots of tips and tricks, some well-hidden techniques and features, and a lot of good, solid information to get you started

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

Blogger post failed

Blogger could not process your message at this time.

Error code: 6.2FFFCC

Original message:
From: bigtoga.sqlnewvids@blogger.com
Date: Sun, 11 Jun 2006 09:01:59 -0500
Subject: New Microsoft SQL Server Video Tutorial: Design Patterns and SQL Programming - How You Can Use Patterns to Simplify Your Life
<b style="font-size: 18px; color: black;">Design Patterns and SQL Programming - How You Can Use Patterns to Simplify Your Life</b> - <a href="http://www.learnsqlserver.com/VideoTutorials/TechnicalTrainingVideo409.aspx">view details</a><br /><blockquote style="border: 1px dotted black; padding: 10px;">Think of this video as the introduction to Design Patters and SQL. This video, recored by Scott Whigham, walks you through the idea of using patterns to simplify your SQL programming. Design Patterns are in nearly every modern language yet they are not often seen in SQL. This video shows you the basics of design patterns and how to use some common patterns. It is suggested that you watch this video before continuing on to the other Design Pattern videos.</blockquote><ul> <li>Category: <a href="http://www.learnsqlserver.com/VideoTutorials/videoCategoryDetail.aspx?videoCategoryId=96">Transact-SQL Basics: Queries, Stored Procedures, Functions and more</a></li><li>Skill Level: 200 (Beginner - Intermediate)</li><li>Length: 7:04 (5.4MB)</li><li>Applies to Versions: SQL Server - All Versions</li><li><a href="http://www.learnsqlserver.com/VideoTutorials/TechnicalTrainingVideo409.aspx">Full Details</a></li></ul><hr />To download this video, <a href="http://www.learnsqlserver.com/Login.aspx">Login</a>, then visit the video's <a href="http://www.learnsqlserver.com/VideoTutorials/TechnicalTrainingVideo409.aspx">detail page</a> and click "download". This is a subscriber-only video so a <a href="http://www.learnsqlserver.com/SubscriptionOptions.aspx">subscription</a> is required<br /><br /><p>Note: You must have the <a href="http://www.learnsqlserver.com/Faqs/TSCCCodec.aspx">TSCC codec</a> installed to view this video</p>

Blogger post failed

Blogger could not process your message at this time.

Error code: 6.1CCD513

Original message:
From: bigtoga.sqlnewvids@blogger.com
Date: Sun, 11 Jun 2006 09:01:57 -0500
Subject: New Microsoft SQL Server Video Tutorial: Customizing SQL Server with International Error Messages and How SQL Server 2000 Uses the Default Language
<b style="font-size: 18px; color: black;">Customizing SQL Server with International Error Messages and How SQL Server 2000 Uses the Default Language</b> - <a href="http://www.learnsqlserver.com/VideoTutorials/TechnicalTrainingVideo405.aspx">view details</a><br /><blockquote style="border: 1px dotted black; padding: 10px;">If you work with international or multi-national applications, SQL Server's custom error messages can really help make your error handling and user experience much better by using localized error messages. This video shows you how to create multiple &quot;multiple versions&quot; of the same error message with the only difference being that each message is in a different language. Have you used SQL Server's error messages before? If not, you'll want to watch this video to get an idea of how they work!</blockquote><ul> <li>Category: <a href="http://www.learnsqlserver.com/VideoTutorials/videoCategoryDetail.aspx?videoCategoryId=96">Transact-SQL Basics: Queries, Stored Procedures, Functions and more</a></li><li>Skill Level: 400 (Intermediate - Advanced)</li><li>Length: 8:07 (5.47MB)</li><li>Applies to Versions: SQL Server 2000</li><li><a href="http://www.learnsqlserver.com/VideoTutorials/TechnicalTrainingVideo405.aspx">Full Details</a></li></ul><hr />To download this video, <a href="http://www.learnsqlserver.com/Login.aspx">Login</a>, then visit the video's <a href="http://www.learnsqlserver.com/VideoTutorials/TechnicalTrainingVideo405.aspx">detail page</a> and click "download". This is a subscriber-only video so a <a href="http://www.learnsqlserver.com/SubscriptionOptions.aspx">subscription</a> is required<br /><br /><p>Note: You must have the <a href="http://www.learnsqlserver.com/Faqs/TSCCCodec.aspx">TSCC codec</a> installed to view this video</p>

New Microsoft SQL Server Video Tutorial: Creating SQL Server Authentication Logins in the Enterprise Manager

Creating SQL Server Authentication Logins in the Enterprise Manager - view details
SQL Server expert and trainer Scott Whigham shows you how to create SQL Server Authentication Logins in this video. You will get an excellent idea of how SQL Server Authentication works, Best Practices for using SQL Server Logins, a discussion of the builtin Logins (the "sa" account, for example), and much more on working with sysadmins and SQL Logins.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

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

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Cross Database Ownership Chaining - What It Is and When to Use It - Part 2

Cross Database Ownership Chaining - What It Is and When to Use It - Part 2 - view details
This video is part 2 in our series on Cross Database Ownership Chaining

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Creating Windows Authentication Logins in the Enterprise Manager

Creating Windows Authentication Logins in the Enterprise Manager - view details
Almost every SQL Server installation has at least one Windows Authentication Loginallowed making this a very popular authentication choice. Do you know what security privileges the "BUILTIN\Admins" has (is it dangerous)? Should you allow Windows Groups to Loginto your SQL Server and, if so, what type of architecture should you choose? Experienced SQL Server consultant Scott Whigham shows you all the details about SQL Server's Windows Authentication model in this excellent video. This should be considered "required viewing" for all new SQL sysadmins

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Creating Our First Database - Three Techniques

Creating Our First Database - Three Techniques - view details
Can you name three ways to create a SQL Server database? Depending on how comfortable you are with Transact-SQL, you might prefer the CREATE DATABASE statement. If T-SQL isn't your specialty, then you likely prefer the Enterprise Manager (which provides two options for creating a database). This video will show you all three techniques and give you the pros and cons of each. By the way, can you name a fourth way to create databases in SQL Server 2000 that doesn't involve writing T-SQL or using Enterprise Manager? In fact, you don't need to use any of the SQL Server tools to create a database. Give up? Check our forums at http://forums.learnsqlserver2000.com/ for the answer!

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server

Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server - view details
Do you know what a collation is in SQL Server? What's the difference between CI and CS collations? How about CP1 versus CP1252 - what's the difference (nothing)? If these questions baffle you, then you might enjoy watching Scott Whigham explain how string (character) data works in SQL Server. If you are trying to understand how SQL Server works with case-sensitive data (or case-insensitive data), then you'll get a lot out of this video. Learn the difference between SQL Collations, Windows Locale, Code Pages, and whether or not a lower-case "a" sorts before or after an upper-case "A"

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: An Overview of the Fixed Server Roles for SQL Server 2000

An Overview of the Fixed Server Roles for SQL Server 2000 - view details
Scott Whigham walks you through an overview of the fixed server roles in SQL Server with this excellent video. Quick - what is the one server role that you should probably never use? Which server role allows its members to add other members to it? Can you add your own server roles? Can you modify the server role permissions? If you don't know the answers to all of these questions, then you should probably watch this video!

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

Friday, June 09, 2006

New Microsoft SQL Server Video Tutorial: Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys

Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys - view details
This video focuses on common SQL developer/DBA terms regarding indexes and constraints and helps you get comfortable with the SQL lexicon. The work "key" is used over and over in SQL - Primary Key, Foreign Key, Alternate key, and more - yet many developers rarely go beyond the primary key and foreign key. This makes it difficult to develop robust systems. For more on the types of keys available and their usage, watch this video from SQL consultant Scott Whigham.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Creating Databases with the SQL Server Enterprise Manager

Creating Databases with the SQL Server Enterprise Manager - view details
The Enterprise Manager is probably the easiest tool for creating new databases and, in this video, Scott Whigham shows you all the details of creating databases with EM. This video talks about the options you are presented in the Enterprise Manager including the Logical Filename, physical filename, file growth options, and how collations can influence the database. This video is primarily aimed at those new to creating databases in SQL Server

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server 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, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Attach and Detach a SQL Server Database Using Enterprise Manager

Attach and Detach a SQL Server Database Using Enterprise Manager - view details
Scott Whigham recorded this video after fielding a question in a live class from a student who ask, "How do I move a SQL Server data file?" One easy way to move files in SQL Server is to detach the database, transfer the file(s), and then re-attach the database. There are a few tips and tricks to doing this and, in this video, Scott Whigham walks you through the detach and attach procedures to help you move and copy your SQL Server databases

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF)

An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF) - view details
All SQL Server developers and administrators should have an excellent understanding of the file architecture for SQL databases. This video helps you learn about the different file types, their usage in SQL Server, and when and where to use the .NDF files (additional data files)

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Database Diagrams - An Introduction

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

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Building a Customized Microsoft Management Console (MMC) for Use with SQL Server

Building a Customized Microsoft Management Console (MMC) for Use with SQL Server - view details
Scott Whigham says that this is one of the very first things that he does whenever he builds or works on a new server - it's one of his favorite little tweaks for working with SQL Server. This video shows you how you can create your own "version" of the Enterprise Manager inside a custom MMC (Microsoft Management Console). Not only is this an easier to way to work with SQL Server but it shows that you know what you're doing when you sit down at a new SQL Server!

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

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.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

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, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: An Overview of the Enterprise Manager for SQL Server 2000 - Part 1

An Overview of the Enterprise Manager for SQL Server 2000 - Part 1 - view details
The Enterprise Manager is an essential tool for SQL developers and admins alike. This video is designed to be your first introduction to working with this critical tool. It shows you the basics of registering servers, logging in, and is designed to give you a good feel for how the Enterprise Manager helps you manage your SQL Server

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Aliasing in Queries - What It Is and How to Use It (SQL Server 2000)

Aliasing in Queries - What It Is and How to Use It (SQL Server 2000) - view details
Table aliases, column aliases, column headers, resultset headers, range variables, correlation names - whew! That's a lot of terms to describe a simple concept! In this video, you'll learn the proper use of SQL aliases including when and where you can/cannot use them. Most queries can benefit from using aliases so understanding their use and Best Practices will certainly help you in your quest for SQL greatness.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

Wednesday, June 07, 2006

New Microsoft SQL Server Video Tutorial: Creating Database Diagrams in SQL Server Management Studio

Creating Database Diagrams in SQL Server Management Studio - view details
Scott Whigham, author of LearnSqlServer2005.com and LearnSqlServer2000.com, loves to show people how to create diagrams because he feels that they are essential tools for all developers and DBAs of any skill level. Database diagrams (often called Entity Relationship Diagrams or ERDs) are a visual tool that allows you to see your table layouts, relationships, datatypes and much more. This video is for those people wanting to learn how to visualize SQL problems thus helping you be able to write JOINs, subqueries, and make decisions quickly and easily in SQL Server.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

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, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: An Overview of the Enterprise Manager for SQL Server 2000 - Part 1

An Overview of the Enterprise Manager for SQL Server 2000 - Part 1 - view details
The Enterprise Manager is an essential tool for SQL developers and admins alike. This video is designed to be your first introduction to working with this critical tool. It shows you the basics of registering servers, logging in, and is designed to give you a good feel for how the Enterprise Manager helps you manage your SQL Server

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

Tuesday, June 06, 2006

New Microsoft SQL Server Video Tutorial: Installing Service Pack 4 - Part 2

Installing Service Pack 4 - Part 2 - view details
Part 2 in our series on installing Service Pack

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

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, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Creating SQL Server Authentication Logins in the Enterprise Manager

Creating SQL Server Authentication Logins in the Enterprise Manager - view details
SQL Server expert and trainer Scott Whigham shows you how to create SQL Server Authentication Logins in this video. You will get an excellent idea of how SQL Server Authentication works, Best Practices for using SQL Server Logins, a discussion of the builtin Logins (the "sa" account, for example), and much more on working with sysadmins and SQL Logins.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

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

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF)

An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF) - view details
All SQL Server developers and administrators should have an excellent understanding of the file architecture for SQL databases. This video helps you learn about the different file types, their usage in SQL Server, and when and where to use the .NDF files (additional data files)

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server

Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server - view details
Do you know what a collation is in SQL Server? What's the difference between CI and CS collations? How about CP1 versus CP1252 - what's the difference (nothing)? If these questions baffle you, then you might enjoy watching Scott Whigham explain how string (character) data works in SQL Server. If you are trying to understand how SQL Server works with case-sensitive data (or case-insensitive data), then you'll get a lot out of this video. Learn the difference between SQL Collations, Windows Locale, Code Pages, and whether or not a lower-case "a" sorts before or after an upper-case "A"

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

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.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Aliasing in Queries - What It Is and How to Use It (SQL Server 2000)

Aliasing in Queries - What It Is and How to Use It (SQL Server 2000) - view details
Table aliases, column aliases, column headers, resultset headers, range variables, correlation names - whew! That's a lot of terms to describe a simple concept! In this video, you'll learn the proper use of SQL aliases including when and where you can/cannot use them. Most queries can benefit from using aliases so understanding their use and Best Practices will certainly help you in your quest for SQL greatness.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

Monday, June 05, 2006

New Microsoft SQL Server Video Tutorial: Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work

Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work - view details
This video is mainly an architecture/sysinternals type of video designed to show you how things work "behind the scenes" with IDENTITY columns. You'll learn how SQL Server chooses the values, how you can influence those values as well as tips and tricks for using IDENTITY columns and Best Practices. IDENTITY columns (and all surrogate keys) are often easy to use but not completely understand by new users. If you use IDENTITY columns in your databases then you'll appreicate this thorough treatment of how IDENTITY columns work in SQL Server.

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

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

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

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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

New Microsoft SQL Server Video Tutorial: Alerts in SQL Server 2000 - What They Are, How to Use Them and Best Practices

Alerts in SQL Server 2000 - What They Are, How to Use Them and Best Practices - view details
Alerts are probably one of the most under-utilized management features in SQL Server. Whether it's because most administrators do not understand what alerts are or because DBAs are too busy focusing on other aspects of the system, SQL Server's alert system is often completely overlooked. SQL guru Scott Whigham shows you the basics of alerts in this video and helps you get the "Big Picture". You'll learn about event alerts and performance condition alerts and, as the title suggests, what they are and how to use them

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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