Free Exchange 2007/2003 Video Tutorial: DHCP Server: Assign Reserved IP Addresses

DHCP Server: Assign Reserved IP Addresses - download

This video shows you how you can use both DHCP and static IP addresses easily with Windows Server 2003. You'll also get great explanations of DHCP address leases and expirations, the address pool and reservations. You'll assign reservations to particular machines and get an understanding of the benefits/trade-offs of using static vs dynamic IPs

---

• Source: http://www.learnexchange.com
• Category: Exchange Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 8:34 (7.6MB)
• Source Videobook Entry (Subscriber-only version)

---

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

---

Keywords Associated with this video: DHCP reserved IP addresses

Free Exchange 2007/2003 Video Tutorial: Installing an FTP Server on Your Windows 2003 Server

Installing an FTP Server on Your Windows 2003 Server - download

This video helps you install an FTP (File Transfer Protocol) server onto your Windows 2003 Server. You will set up account logging, throttling (the number of users), and set up the IUSER account(s).

---

• Source: http://www.learnexchange.com
• Category: Exchange Server Videobooks
• Skill Level: 100 (Beginner)
• Length: 15:14 (9.7MB)
• Source Videobook Entry (Subscriber-only version)

---

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

---

Keywords Associated with this video: FTP Server Windows 2003, beginner, beginning, for beginners, introduction, step by step

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

Creating Database Diagrams in SQL Server Management Studio - download

Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.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.

---

• Source: http://www.LearnTransactSQL.com
• Category: SQL Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 18:23 (11.5MB)
• Source Videobook Entry (Subscriber-only version)

---

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

---

Keywords Associated with this video: erd, sql server entity relationship diagram

Free Transact SQL Video Tutorial: Part 1 - An Overview of the AdventureWorks Database

Part 1 - An Overview of the AdventureWorks Database - download

AdventureWorks - the "new standard" for sample databases out of Redmond. Scott Whigham, author of LearnSqlServer.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.

---

• Source: http://www.LearnTransactSQL.com
• Category: SQL Server Videobooks
• Skill Level: 100 (Beginner)
• Length: 17:24 (12.4MB)
• Source Videobook Entry (Subscriber-only version)

---

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

---

Keywords Associated with this video: adventureworks install, sample database, sql server sample database, sql server adventure works, oltp, beginner, beginning, for

Free SQL Server 2005 Video Tutorial: Windows Services: Explanations and Best Practices

Windows Services: Explanations and Best Practices - download

If you've ever looked in the Services applet and wondered 'What does that service do?' then this video is for you! Grant Moyle, veteran Windows trainer and consultant, explains the details of some of the most common services you'll see in Windows. All Windows admins should view this video - it is essential knowledge for any sysadmin

---

• Source: http://www.learnsqlserver.com
• Category: SQL Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 12:38 (7.4MB)
• Source Videobook Entry (Subscriber-only version)

---

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

---

Keywords Associated with this video: windows 2003 services

Free SQL Server 2005 Video Tutorial: Assign a Static IP Address to Your Windows 2003 Server

Assign a Static IP Address to Your Windows 2003 Server - download

This video discusses on of the most basic concepts for Windows: IP addressing. You'll configure a server for static IP address (as opposed to using DHCP) and you'll see a few new features in Windows 2003 regarding IP addressing. All sysadmins must have a thorough understanding of TCP/IP Addressing including static IPs and DHCP. This video is meant to be watched in tandem with the 'Setup Your Windows 2003 Server for DHCP' video

---

• Source: http://www.learnsqlserver.com
• Category: SQL Server Videobooks
• Skill Level: 100 (Beginner)
• Length: 3:23 (2.6MB)
• Source Videobook Entry (Subscriber-only version)

---

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

---

Keywords Associated with this video: Static IP assignment Windows 2003, beginner, beginning, for beginners, introduction, step by step