Monday, May 22, 2006

Free SQL Server 2005 Video Tutorial: Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports

Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports - download
Another in our series on SQL Server 2005's Network Libraries, this video shows you a rather obscure and not-often-used technique of configuring your SQL Server to listen on multiple TCP/IP ports. TCP/IP is the most common way to connect to SQL Servers (including 7.0 and 2000) so the more you know, the better you are!
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 6:00 AM   0 comments links to this post

Free SQL Server 2005 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 - download
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, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 6:00 AM   0 comments links to this post

Free SQL Server 2005 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 - download
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, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 6:00 AM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: An Overview of the Northwind Database

An Overview of the Northwind Database - download
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, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 5:59 AM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: Creating Database Diagrams in SQL Server Management Studio

Creating Database Diagrams in SQL Server Management Studio - download
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, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 5:59 AM   0 comments links to this post

Wednesday, May 17, 2006

Free Transact SQL Video Tutorial: Creating Your Own System Functions (SQL Server 2000)

Creating Your Own System Functions (SQL Server 2000) - download
Did you know that you are allowed to create your own system functions in SQL Server 2000? It's true, it's true. System functions are, like system stored procedures, callable from any database and are excellent DBA tools for reporting. There are some quirky rules associated with writing your own system functions and, if you don't know the "stricks" it's likely that you'll get stuck trying to figure them out. Check out this video for an interesting approach to writing your own functions in master.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 2:29 PM   0 comments links to this post

Free SQL Server 2000 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 - download
What TCP/IP port has IANA assigned for Microsoft to use for a SQL Server instance &$45; 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, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 2:16 PM   0 comments links to this post

Free Transact SQL Video Tutorial: Using the Create Index Wizard in the Enterprise Manager (SQL Server 2000)

Using the Create Index Wizard in the Enterprise Manager (SQL Server 2000) - download
The Create Index Wizard in SQL Server 2000's Enterprise Manager is a friendly-enough tool that can help you get started building indexes. This video shows you how it works and helps you get started with creating your first index.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 2:16 PM   0 comments links to this post

Free SQL Server 2000 Video Tutorial: Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work

Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work - download
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, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 2:16 PM   0 comments links to this post

Free Transact SQL Video Tutorial: Linked Servers - How to Query Microsoft Excel Named Regions and Worksheets (SQL Server 2000)

Linked Servers - How to Query Microsoft Excel Named Regions and Worksheets (SQL Server 2000) - download
For those of you taking full advantage of Microsoft Excel's ability to expose "tables" to SQL Server, this videos helps you understand how you can query even the most advanced Excel spreadsheets and worksheets. No longer are you tied to querying the worksheet element; now you can query certain "tables" *called "named regions") in the worksheet and make your life much easier.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 2:03 PM   0 comments links to this post

Free Transact SQL Video Tutorial: Part 1 - Identity Columns - When Should I Use an Identity Column?

Part 1 - Identity Columns - When Should I Use an Identity Column? - download
IDENTITY columns are some data modeler's Best Friend yet others avoid them like the plague in favor of "Natural Keys" only and/or GUIDs. This video, part one in a series, walks you through the if, ands, and buts of using IDENTITY columns, points out some suggested use of IDENTITY columns and finished with a few Gotchas of using IDENTITY columns.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 2:03 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: DNS Internet Forward Lookup Zone

DNS Internet Forward Lookup Zone - download
This video teaches how to prepare a server to do basic record resolution on the web. You'll learn how to publish MX (Mail Exchanger) records and prepare a server so that your web server, FTP server, Exchange Server and more will be visible to the outside world. You'll configure aliases (CNAME) for FQDNs (Fully Qualified Domain Names), hosts, and more
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 2:03 PM   0 comments links to this post

Free SQL Server 2000 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 - download
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, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 1:59 PM   0 comments links to this post

Free SQL Server 2000 Video Tutorial: Result sets, Recordsets, and the Client Server model

Result sets, Recordsets, and the Client Server model - download
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, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 1:59 PM   0 comments links to this post

Free SQL Server 2005 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 - download
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, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 1:54 PM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: Creating Database Diagrams in SQL Server Management Studio

Creating Database Diagrams in SQL Server Management Studio - download
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, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 1:54 PM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports

Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports - download
Another in our series on SQL Server 2005's Network Libraries, this video shows you a rather obscure and not-often-used technique of configuring your SQL Server to listen on multiple TCP/IP ports. TCP/IP is the most common way to connect to SQL Servers (including 7.0 and 2000) so the more you know, the better you are!
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 1:49 PM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: TempDb Database - An Overview of How it Works and When to Use It

TempDb Database - An Overview of How it Works and When to Use It - download
Yet another excellent video in our series on SQL Server 2005's system databases, this video teaches you the ins and outs of tempdb. SQL Server guru Scott Whigham, author of LearnSqlServer2005.com and LearnSqlServer2000.com, walks you through the layout of the main tables, how things have changed, working with temporary tables and table variables and more. A good video to help learn more about the SQL Server architecture.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 1:49 PM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: Part 1 - An Overview of the Default SQL Server Installation

Part 1 - An Overview of the Default SQL Server Installation - download
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, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 1:46 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: Group Policy Basics

Group Policy Basics - download
Policies make it far easier for the sysadmin to proactively manage the network users/objects. In this video you will be assigning user permissions and changing Group Policy in order to fully explain the concept of Group Policy (using gpedit.msc). Most administrators would consider this required knowledge for managing any Windows network today. This video could also be titled 'Group Policy: How To Use Policies to Police Your Network'
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 1:45 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: How to Perform Metadata Cleanup When a Domain Controller Is Removed Using a Method Other Than DCPromo

How to Perform Metadata Cleanup When a Domain Controller Is Removed Using a Method Other Than DCPromo - download
Metadata cleanup involves removing the data from Active Directory that identify a domain controller to the replication system. If you remove a DC without using DCPromo (using ntdsutil.exe, for example, because you were unable to demote your DC using DCPromo) you will want to cleanup after the job by removing the metadata. This video helps you understand what the metadata is, why you want to remove it, and how to go about this auspicious task.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 1:45 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: The Dreaded Blue Screen of Death: Every Administrators Nightmare!

The Dreaded Blue Screen of Death: Every Administrators Nightmare! - download
While recording a video on how to add USB/Firewire drives into your Windows 2003 server, expert trainer Grant Moyle encountered a blue screen of death (BSOD). Unable to later reproduce the error, Grant decided to release this video showing you how you can experience these at the worst possible times (getting a BSOD while recording a 'How-To' video is not a good time!) and Grant talks about what the error text can mean and how to recover. Good job, Grant - way to recover gracefully! BE AWARE that Grant does not experience the BSOD until around 6:38. Feel free to fast forward if you like!
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 1:45 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: Create a User Account in the Active Directory

Create a User Account in the Active Directory - download
A must-see video for all new Windows administrators. Expert Grant Moyle tells you how user security works in Windows 2003 and shows you how to add new user accounts to the Active Directory. You'll learn the basics as well as a few intermediate tips (what does ".local" mean?)
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 1:45 PM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Using the Recovery Storage Group (RSG)

Using the Recovery Storage Group (RSG) - download
A must-see video for Exchange administrators of all skill levels. Exchange guru Grant Moyle shows you how to work with the Recovery Storage Group (the RSG) for recovering mailbox data
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:03 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Transfer Mailbox from One User to Another

Transfer Mailbox from One User to Another - download
Do you have employees who have sensitive material in their mailbox and you need to transfer that material into a new (or another) user's mailbox? This video goes through the two techniques for migrating the mailboxes between users
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:03 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: How to Move Mailboxes from Exchange 2000 to Exchange 2003 and Outlook Profile Reconfiguration

How to Move Mailboxes from Exchange 2000 to Exchange 2003 and Outlook Profile Reconfiguration - download
More in our series on upgrading Exchange 2000 to Exchange 2003, this video teaches you how to move mailboxes from Exchange 2000 to Exchange 2003 and reconfigure Outlook profiles
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:03 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Pt 4 - Creating a Custom XML file to Modify SCL Scores Based on Keyword or Phrase

Pt 4 - Creating a Custom XML file to Modify SCL Scores Based on Keyword or Phrase - download
In Part 4 of our series on Configuring the Intelligent Message Filter, you'll learn how to customize IMF by working with modifying the XML file to tweak the SCL scores for keywords and phrases.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:03 AM   0 comments links to this post

Free DTS Video Tutorial: DTS Architecture - A Look at the MSDB System Stored Procedures

DTS Architecture - A Look at the MSDB System Stored Procedures - download
DTS Architecture - A Look at the MSDB System Stored Procedures
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:02 AM   0 comments links to this post

Free DTS Video Tutorial: A Walk-Through of the Various Tabs, Screens and Choices in the DTS Designer

A Walk-Through of the Various Tabs, Screens and Choices in the DTS Designer - download
A Walk-Through of the Various Tabs, Screens and Choices in the DTS Designer
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:02 AM   0 comments links to this post