Abstract: This chapter is a great introduction to SQL Server. Whether you are a complete 'know-nothing' for SQL Server or you've had extensive experience with other RDBMS' and just want to learn about SQL Server, this is a great place to start.
Number of Videos: 6
Total Run Time: 1 hour and 13 minutes
|
Abstract: This chapter is designed to help you install and configure your SQL Server 2005 and 2000 installations including keeping your server up-to-date with the latest updates, security patches and hotfixes. You'll learn about configuring all the options during the graphical setup as well as using the automated setup, learn about upgrading SQL Server 2000 to SQL Server 2005, upgrading SQL 7.0 to SQL 2005, running the SQL Server 2005 Upgrade Advisor and more. Also included are best practices and performance tips for installing SQL Server.
Number of Videos: 18
Total Run Time: 3 hours and 10 minutes
|
Abstract: Are you just getting starting with Visual Studio and Visual Basic and trying to get VB to work with SQL Server? The chances are high that, if you're working with the Express Edition of Visual Basic, then you'll also be working with the Express Edition of SQL Server 2005. This chapter focuses on getting you started with the SQL Server 2005 Express Edition(s) and helps you understand how to use SQL Server in your VB applications.
Number of Videos: 11
Total Run Time: 2 hours and 20 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 ports - 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: 8
Total Run Time: 1 hour and 40 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 SQL Server Management Studio, Profiler, the Configuration Tools (such as the Surface Area Configuration tool and the SQL Server Configuration Manager) 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 (sqlcmd, osql, bcp), batch-file writing, and scripting topics. For those of you with SQL Server 2000, This chapter also features videos on 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).
Number of Videos: 6
Total Run Time: 1 hour and 4 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. You'll learn all about CREATE DATABASE, the intricacies of ALTER DATABASE as well as how to manipulate (and understand) database properties. You'll work with many of the common admin procedures and functions such as sp_helpdb, sp_helpfile, and DATABASEPROPERTYEX.
Number of Videos: 16
Total Run Time: 3 hours and 3 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. You'll learn the details about the master database, the msdb database, how the resource database is used by SQL Server, and how to take advantage of the model database for fun and profit. This video includes detailed walk throughs of the objects in each database complete with descriptions and suggestions for use for many of the most commonly used objects (system tables, system views, system procs and more).
Number of Videos: 13
Total Run Time: 2 hours and 6 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. This chapter of videos is designed to teach you all about principals, credentials, proxies and proxy accounts as well as Best Practices for SQL Server security. Also in This chapter are discussions on SQL Injection and how hackers can attempt to attack your server.
Number of Videos: 6
Total Run Time: 1 hour and 6 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.This set of videos teaches you about how to backup and restore SQL Server databases, complex restore/backup scenarios, backup concepts and architecture, and scripting backups and restores. We will also discuss recovery models, log shipping for disaster recovery, clustering SQL Server 2000/2005 and building Active/Passive and Active/Active clusters (Single Instance and Multiple Instance clusters)
Number of Videos: 22
Total Run Time: 4 hours and 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. This set of videos teaches you about scheduling backups and SQL Server jobs, database Mail, SQLMail, and operators. We will also discuss alerts for proactive administration and SQL Server agent internals
Number of Videos: 17
Total Run Time: 3 hours and 15 minutes
|
Abstract: This SQL Server chapter is all about performance tuning your SQL Server and queries. 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.
Number of Videos: 11
Total Run Time: 2 hours and 15 minutes
|
Abstract: SQL Server replication is a very popular choice for everything from synchronizing small, hand held devices with SQL Server CE/Mobile Edition/Compact Edition/Everywhere 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 19 minutes
|
Abstract: These videos are basically homeless. They have therefore been placed into the chapter until we find a better home for them!
Number of Videos: 18
Total Run Time: 3 hours and 11 minutes
|