Abstract: This chapter is designed to help you install and configure your SQL Server 2000 installation including applying service packs and keeping your server up-to-date with the latest security patches and hotfixes. You'll learn about configuring all the options during the graphical setup as well as using the automated setup, the Service Pack Installations and more. Also included are best practices and performance tips for installing SQL Server 2000
Number of Videos: 10
Total Run Time: 1 hour and 40 minutes
|
Abstract: SQL Server administrators need to know the innermost workings of SQL Server and this set of videos teaches just that. The videos in this series will teach you about the network libraries that SQL Server uses, configuring the SQL Server system including memory and CPU settings, and even how to change SQL Server's TCP/IP port - all of which are essential to understanding SQL Server. You'll also get great insight into the services that make up SQL Server and how things work "under the covers"
Number of Videos: 4
Total Run Time: 51 minutes
|
Abstract: This is an essential set of videos for all administrators. In this set of videos you'll learn all about the most common tools and how to perform common tasks. This chapter discusses the Enterprise Manager, Query Analyzer, Profiler, tools in the SQL Server 2000 Resource Kit and many other helpful tools such as snap-ins for the Microsoft Management Console (MMC). This set of videos also features DOS commands and utilities, batch-file writing, and scripting topics.
Number of Videos: 16
Total Run Time: 3 hours and 22 minutes
|
Abstract: This chapter discusses the various ways to create databases, how to manage your database files by expanding or shrinking SQL Server's database files, how filegroups work, and Best Practices for SQL Server databases
Number of Videos: 9
Total Run Time: 1 hour and 49 minutes
|
Abstract: Learn everything about authentication modes, server roles, what the term "fixed" means when discussing fixed server and fixed database roles, how users and schemas work and much more in this excellent set of videos on SQL Server security
Number of Videos: 13
Total Run Time: 2 hours and 31 minutes
|
Abstract: The more you know about how things work in SQL Server, the better prepared you are to make intelligent design and management choices. Watch this chapter for information on how the internals of Microsoft SQL Server 2000 influence your design making
Number of Videos: 3
Total Run Time: 40 minutes
|
Abstract: This chapter covers many internal storage and retrieval techniques including collations, how datatypes are stored and compared, and working with the internal datatypes
Number of Videos: 22
Total Run Time: 4 hours and 6 minutes
|
Abstract: This chapter is all about stored procedure programming, Error Handling, and passing resultsets to the client by various means as well as writing triggers (AFTER/INSTEAD OF), functions (scalar and table-valued UDFs), and TSQL variables.
Number of Videos: 7
Total Run Time: 1 hour and 38 minutes
|
Abstract: This SQL Server 2000 chapter is all about performance tuning your SQL Server. The more you know about how SQL Server does what it does, the better prepared you are to make smart design decisions. Watch these videos for a solid foundation of the how and why in SQL Server
Number of Videos: 3
Total Run Time: 40 minutes
|
Abstract: This SQL Server chapter is all about performance tuning your SQL Server. The more you know about how SQL Server does what it does, the better prepared you are to make smart design decisions. Watch these videos for a solid foundation of the "how and why" things work the way they do in SQL Server. This set of videos teaches you about using SQL Profiler, tracing your SQL Server for performance, and using the Performance Monitor.
Number of Videos: 4
Total Run Time: 40 minutes
|
Abstract: This is a chapter on taking backups, applying backups (restoring backups), working with standby servers and all the in-between things that need to happen in a real-life situation. There's lots of good, solid info packed into these videos
Number of Videos: 3
Total Run Time: 42 minutes
|
Abstract: SQL Servers around the world run jobs at scheduled times - it's just the way of the world. This chapter will teach you how to create jobs, how to manage alerts, and how the SQL Server Agent works. This is an important set of videos for any SQL Server DBA
Number of Videos: 2
Total Run Time: 27 minutes
|
Abstract: When you need to copy or move a database in SQL Server, you have many choices. This chapter talks about all the options, when to use each one, and some best practices for backup and recovery as well as attaching and detaching databases
Number of Videos: 1
Total Run Time: 6 minutes
|
Abstract: SQL Server replication is a very popular choice for everything from synchronizing small, handheld devices with SQL Server CE installed to doing complete disaster recovery solutions. This chapter of videos will help you understand SQL replication and will walk you through setting it up, creating distributors, managing publications and subscribing.
Number of Videos: 6
Total Run Time: 1 hour and 22 minutes
|