Over at LearnItFirst.com, the web's best training video site (in our opinion), we've just released a whole slew of companion PDFs for our SQL Server 2005 training courses:
These new SQL Server training PDFs feature a listing of every SQL Server 2005 video tutorial in each course along with a checkbox that helps you track which videos you have watched.Posted at 04:56 PM in SQL Server, Training, Training Videos, Tutorials, Video | Permalink | TrackBack (0)
Part 3-A Deeper Look at Pages and Extents Using SQL Internals Viewer - view details
In this third and final video, Scott will wrap up his overview of the SQL Internals Viewer by further discussing clustered indexes and working with tables.
Highlights from this video:Effects of clustered indexes vs heapAbout deleting/removing tablesRebuilding tablesand more! Source: http://www.learnitfirst.com/Course/152/Video/1327/Pages-and-Extents-Using-SQL-Internals-Viewer-P3.aspx Course: http://www.learnitfirst.com/Course/152/SQL-Server-2005-DBA.aspx Skill Level: 500 (Advanced) Length: 08:30 (9.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: clustered index, heap, SQL internals viewer, internals viewer,
This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check out even more MSSQL Server 2005 training videos.
Posted at 08:16 AM | Permalink | TrackBack (0)
Part 1 - Windows Server Update Services 3.0 Installation - view details
WSUS, or Windows Server Update Services, is an essential component you can download from Microsoft to run on one of the servers on your network. The idea behind WSUS is that WSUS will go to the Windows web site and download the updates for your various Microsoft products you run on your newtwork and deploy those updates when ready. In this first video in this 10-part section, Grant Moyle will walk you through the beginning of the installation of WSUS 3.0 and help you set it up!
Highlights from this video:System requirements for WSUS 3.0 installationInstalling other required components, IIS and .NET FrameworkFrom where can I download the WSUS setup?Kicking off the Full WSUS 3.0 Service installationWorking through the WSUS 3.0 Setup Wizardand much more! Source: http://www.learnitfirst.com/Course/232/Video/1410/Windows-Server-Update-Services-3-Installation.aspx Course: http://www.learnitfirst.com/Course/232/Windows-2003.aspx Skill Level: 200 (Beginner - Intermediate) Length: 11:30 (9.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: wsus, windows server update services 3.0, wsus 3.0, windows server update service, install wsus
This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.
Posted at 08:16 AM | Permalink | TrackBack (0)
The Types of SQL Server Backups; Recovery Models - view details
In this video we will begin talking about the types of SQL backups and recovery models. We will use these terms and concepts throughout the rest of the course, not just the rest of this chapter.
Highlights from this video:What can we backup?What type of backups are available to us?
Dispelling backup myths
Overview of recovery models and various types
and much more Source: http://www.learnitfirst.com/Course/157/Video/1813/Types-of-SQL-Backups.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 200 (Beginner - Intermediate) Length: 11:15 (17.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: backup,recovery model,sql server,2008
This video comes from the SQL Server 2008 DBA online training course, SQL Server 2008 Database Administration. And be sure to check out even more MSSQL Server 2008 training videos.
Posted at 08:16 AM | Permalink | TrackBack (0)
Backing Up System Databases and Encryption Keys - view details
In this video tutorial we will walkthrough the process of backing up the other bits and pieces, other than users' databases, something which will be criticial to know should you have to rebuild your server or system. We will also discuss the crucial information you will need to know and documentation you will need to keep in order to do this backup.
Highlights from this video:
What you need to have in your documentation plan
What else do I need to backup besides my user's database?
Disucssing why you need to backup: the master,model,msdb,tempdb databases
Backing up your service master key
and much more Source: http://www.learnitfirst.com/Course/157/Video/1837/Backup-Sys-Db-and-Keys.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 200 (Beginner - Intermediate) Length: 11:00 (16.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: backup, backing up, database,encryption keys,sql server,2008
This video comes from the SQL Server 2008 DBA online training course, SQL Server 2008 Database Administration. And be sure to check out even more MSSQL Server 2008 training videos.
Posted at 08:16 AM | Permalink | TrackBack (0)
Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands - view details
There are lots and lots of DBCC commands related to performance tuning but did you know that several SET commands can help you out with your query tuning? This video, recorded by SQL consultant Scott Whigham, teaches you several of the most commonly used DBCC and SET commands for performance tuning and provides some tips and tricks for their use. Note: you'll want to likely have a solid foundation in query writing before viewing this video. An understanding of execution plans would also be helpful. Source: http://www.learnitfirst.com/Course/152/Video/428/Performance-Tuning-DBCC-SET-Commands.aspx Course: http://www.learnitfirst.com/Course/152/SQL-Server-2005-DBA.aspx Skill Level: 300 (Intermediate) Length: 21:10 (15.1MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: dbcc, statistics, io, statistics_io, statistics_time, showplan, showplan_all, showplan_text, performance,
This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check out even more MSSQL Server 2005 training videos.
Posted at 08:16 AM | Permalink | TrackBack (0)
Pt. 1 - An Overview of Package Logging and Auditing Options in SSIS - view details
This first video in the section will introduce you to the idea of package logging and discuss the options for how to audit the package logging in SQL Server Integration Services. Highlights from this video:Viewing logged events and default settingWhere can package logging be done?Adding/writing package event logsand much more! Source: http://www.learnitfirst.com/Course/153/Video/924/Overview-of-Package-Logging-and-Auditing-Options-in-SSIS.aspx Course: http://www.learnitfirst.com/Course/153/SSIS-2005.aspx Skill Level: 300 (Intermediate) Length: 11:30 (8.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: package, package logging,
This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.
Posted at 08:16 AM | Permalink | TrackBack (0)
Pt. 4 - OUTPUT Parameters and How to Use Them - view details
One of the more confusing aspects of the stored procedure is the syntax and usage of OUTPUT parameters. This video tutorial will help you understand what OUTPUT params are, where they are used (in a Singleton pattern, for example), and how to access/assign the values to local variables. Don't miss this video!
Posted at 08:15 AM | Permalink | TrackBack (0)
How to Create Mailboxes for Your Users - view details
This video covers the all-important 'Give people access to Exchange and email!' concept - core knowledge for any Exchange administrator!
Highlights from this video:
- Discussions of User Mailboxes, Room Mailboxes, Equipment Mailboxes, and Linked Mailboxes
- Choosing Between New User or Existing User
- Choosing Organizational Units and logon names for New Users
- Determining Storage Groups for your new mailbox
- Walk through of the new mailbox properties dialog box
- Configuring to work with OWA (Outlook Web Access)
- and much more
Posted at 08:15 AM | Permalink | TrackBack (0)
Part 3 - Install Exchange 2003 on Windows 2003 Server - view details
After you've done the prep work in Parts 1 and 2 of this section, you're ready to install Exchange Server 2003
Posted at 08:15 AM | Permalink | TrackBack (0)
Building a Customized Microsoft Management Console (MMC) for Use with SQL Server - view details
Scott Whigham says that this is one of the very first things that he does whenever he builds or works on a new server - it's one of his favorite little tweaks for working with SQL Server. This video shows you how you can create your own "version" of the Enterprise Manager inside a custom MMC (Microsoft Management Console). Not only is this an easier to way to work with SQL Server but it shows that you know what you're doing when you sit down at a new SQL Server!
Posted at 08:15 AM | Permalink | TrackBack (0)
