| Title | Date Added | Skill | Length |
An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF)
| 03-16-2006 | 200 |
5
mins. |
Backup and Recovery - An Introduction to the Three Main Types of Backups in SQL Server 2000
| 03-16-2006 | 200 |
13
mins. |
Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server
| 03-16-2006 | 300 |
10
mins. |
Creating Databases with the SQL Server Enterprise Manager
| 03-16-2006 | 200 |
17
mins. |
Creating Our First Database - Three Techniques
| 03-16-2006 | 100 |
12
mins. |
Part 2 - Cross Database Ownership Chaining - What It Is and When to Use It
| 03-16-2006 | 400 |
14
mins. |
Database Diagrams - An Introduction
| 03-16-2006 | 100 |
9
mins. |
Enterprise Manager - Put Table On Filegroup
| 03-16-2006 | 400 |
15
mins. |
Enterprise Manager - Registering a server
| 03-16-2006 | 100 |
14
mins. |
Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency!
| 03-16-2006 | 500 |
18
mins. |
How SQL Server Logs Errors - The SQL Server Error Log and Configuration
| 03-16-2006 | 300 |
7
mins. |
How to Change the SQL Server TCP IP Port Number Using the Server Network Utility
| 03-16-2006 | 500 |
12
mins. |
How to Increase a Database's Size - Multiple Techniques for Increasing Data File and Transaction Log File Size
| 03-16-2006 | 300 |
11
mins. |
How to Upgrade The Documentation of SQL Server 2000 (Books Online)
| 03-16-2006 | 200 |
4
mins. |
Install SQL Server - Discussion of Collation Types and Recommendations
| 03-16-2006 | 300 |
13
mins. |
Installing SQL Server 2000 - Basic Overview
| 03-16-2006 | 100 |
14
mins. |
Multiple Instances - Lecture on When They're Appropriate and Special Considerations
| 03-16-2006 | 200 |
18
mins. |
ODBC, DSNs, and UDLs - Creating Reusable Connection Information
| 03-16-2006 | 200 |
10
mins. |
Pages, Extents, and Blocksizes - What They Are and How They Work
| 03-16-2006 | 300 |
10
mins. |
Result sets, Recordsets, and the Client Server model
| 03-16-2006 | 100 |
9
mins. |
Shrinking Database Files and Removing Space from Your SQL Server Database (Using Enterprise Manager)
| 04-02-2007 | 300 |
15
mins. |
Some Dangerous Stored Procedures - xp_cmdshell, sp_OACreate, and sp_enum_dtspackages
| 03-16-2006 | 400 |
13
mins. |
Aliasing in Queries - What It Is and How to Use It (SQL Server 2000)
| 05-29-2006 | 100 |
5
mins. |
Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work
| 05-12-2006 | 200 |
8
mins. |
Extended Properties in SQL Server 2000 - What They Are and How to Use Them to Generate Your Data Dictionary
| 06-12-2006 | 300 |
10
mins. |
How to Return Identity Value for a Just-Inserted Row
| 06-12-2006 | 200 |
16
mins. |
Linked Servers - How to Query Microsoft Excel Named Ranges and Worksheets (SQL Server 2000)
| 07-12-2006 | 400 |
11
mins. |
Rapid Database Development Using Database Diagrams (SQL Server 2000)
| 06-12-2006 | 100 |
9
mins. |
Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000)
| 05-12-2006 | 300 |
17
mins. |
Using the Create Index Wizard in the Enterprise Manager (SQL Server 2000)
| 07-12-2006 | 200 |
16
mins. |
Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures Using the Create Stored Procedure Wizard
| 07-12-2006 | 100 |
16
mins. |
Views: Introduction, When and Where to Use, and Using the Create View Wizard
| 07-12-2006 | 100 |
17
mins. |
Variables and Scoping - Local Variables and Batch Terminators
| 12-10-2006 | 200 |
8
mins. |
Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY
| 12-10-2006 | 300 |
12
mins. |
Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage
| 12-10-2006 | 200 |
19
mins. |
Pt. 2 - CREATE PROCEDURE Syntax and Execution
| 12-10-2006 | 200 |
13
mins. |
Pt. 3 - Input Parameters and Variables
| 12-10-2006 | 200 |
10
mins. |
Pt. 4 - OUTPUT Parameters and How to Use Them
| 12-10-2006 | 200 |
22
mins. |
Pt. 5 - RETURN Codes and How to Use Them
| 12-10-2006 | 200 |
14
mins. |
Pt. 1 - An Introduction to Using Views in SQL Server
| 09-13-2006 | 100 |
8
mins. |
Pt. 2 - Using Views in the Real World
| 09-13-2006 | 100 |
12
mins. |
Pt. 1 - An Introduction to the Concepts and Terms of SQL Server Replication
| 11-12-2006 | 200 |
11
mins. |
Pt. 1 - Using SQL Profiler - Concepts and Screens
| 11-12-2006 | 300 |
9
mins. |
Pt. 3 - What Do You Do With Your Trace Data? How to Write Queries Against Your Trace
| 11-12-2006 | 400 |
12
mins. |
Database Compatibility Levels and sp_dbcmptlevel
| 12-10-2006 | 300 |
11
mins. |
Pt. 1 - Why Migrate From Microsoft Access to SQL Server?
| 01-11-2007 | 200 |
19
mins. |
Pt. 1 - Using the DTS Wizards to Migrate Tables from Access to SQL Server 2000
| 01-11-2007 | 300 |
11
mins. |