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.

• Category: SQL Server Videobooks
• Skill Level: 500 (Advanced)
• Length: 9:04 (5.02MB)
• 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

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.

• Category: SQL Server Videobooks
• Skill Level: 400 (Intermediate - Advanced)
• Length: 10:59 (7.32MB)
• 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

Free Transact SQL Video Tutorial: Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000)

Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000) - download

Linked servers can really help you get "out of a jam" with SQL. If you'd like to be able towrite SQL queries against Microsoft Access and JOIN the data to a SQL Server table, for example, then you'll love the flexibility that linked servers offer you. This video is just an overview of how linked servers work and how you can use them in your queries to simplify your life.

• Category: SQL Server Videobooks
• Skill Level: 300 (Intermediate)
• Length: 16:34 (9.01MB)
• 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

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.

• Category: SQL Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 15:42 (7.87MB)
• 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

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 designers Best Friends it seems while 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.

• Category: SQL Server Videobooks
• Skill Level: 100 (Beginner)
• Length: 19:05 (14.1MB)
• 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