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)
Using the Windows Event Log and Text File Log Providers - view details
This video will cover the application event log and the text log providers to log events that occur in SSIS packages.
Highlights from this video:What is the Windows Event log?
How to view logged events
Different options for logging
What is the Text File log provider?
Creating the text file
and much more Source: http://www.learnitfirst.com/Course/158/Video/2022/Using-Windows-Event-Log-and-Text-File-Log-Providers.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 300 (Intermediate) Length: 14:45 (26.3MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: SSIS, windows event log, text file log, logging
This video comes from the SSIS 2008 online training course, SQL Server 2008 Integration Services. And be sure to check out even more SQL 2008 Integration Services training videos.
Posted at 08:16 AM | Permalink | TrackBack (0)
The Editions of SQL Server, Part 2 - view details
We will finish up our discussion of the editions of SQL Server 2008 by discussing the Specialized Editions. Included with your video download is the .PDF of the author's presentation.
Highlights from this video:
About the Specialized Editions
Developer Edition
Similarity to Enterprise EditionWorkgroup Edition
Who would use this edition?Web Edition
Low TCO (Total Cost of Ownership)Three versions of Express EditionSQL Server Express, SQL Server Express with Tools, SQL Server Express with Advanced ServicesComparison of Specialized Editionsand much more Source: http://www.learnitfirst.com/Course/157/Video/1589/NULLSQL-2008-Editions-Part-2.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 100 (Beginner) Length: 07:15 (11.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: edition, specialized, developer, workgroup, web, express, editions, sql, 2008, , introduction, step by step, beginner, beginning, for dummies
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)
Suggested Changes After an Upgrade - Part 2: Patching and Compatibility Levels - view details
This video will be a demonstration of the concepts discussed in the previous video on patching and compatibility changes for your SQL Server 2008 installation.
Highlights from this video:
How do I know which databases have been upgraded from a prior version?
Viewing compatibility levels
Why wouldn't I upgrade all my databases to SQL 2008 compatibility level?About the different compatibility levels
Changing compatibility levels in the GUI
How to view all compatibility levels for every database and much more Source: http://www.learnitfirst.com/Course/157/Video/1672/Post-Upgrade-Patching-and-Compatibility-Levels-Pt3.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 300 (Intermediate) Length: 13:45 (22.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: compatibility level, compatible, patching, sql, server ,2008, upgrade
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)
Pt. 4 - SQL Server Reporting Services Terms and Definitions (Glossary) - view details
Further examination of SSRS requires a solid understand of the various terms (such as the 'Report Server'). This video takes you through topics like:RDL filesData Sources (shared and private)AuthoringDeploymentManagement (Reporting)Ad Hoc reporting (ad-hoc)Report ModelsHow deployment works and much more Source: http://www.learnitfirst.com/Course/189/Video/1172/SQL-Server-Reporting-Services-SSRS-Terms-and-Definitions.aspx Course: http://www.learnitfirst.com/Course/189/C-Sharp-2005.aspx Skill Level: 100 (Beginner) Length: 12: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: shared data sources, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies
This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.
Posted at 08:16 AM | Permalink | TrackBack (0)
How to Configure a SQL Server Database - Part 4 - view details
Recovery, Service Broker, and State are the configuration categories that we will cover in this video.
Highlights from this video:
About settings in Recovery
Page Verify
Checksum
TornPageDetection
NoneSettings in Service Broker
Settings in the State category��and much more Source: http://www.learnitfirst.com/Course/157/Video/1643/Configure-SQL-Server-2008-Databases-Pt4.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 200 (Beginner - Intermediate) Length: 07:00 (12.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: configure, configuring, configuration, sql, server, database, db, data base, recovery, service broker, state, category
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)
Pt. 1 - Installing SQL Server 2005 Express Edition on Windows Vista - view details
This is the first of four very informative and enterprising videos about installing SQL Server 2005 Express Edition on a Windows Vista Operating System (OS). Scott Whigham takes us to the next level, providing us with his knowledge and expertise when training us in a non-technical fashion about the different intricacies when downloading and installing SQL Server 2005 Express Edition on a Windows Vista OS.
In this video you can also expect to learn about the following highlights:Current MSN SQL Server 2005 Express Edition download pageSQL Server 2005 Express Edition vs SQL Server 2005 Express Edition with Advanced ServicesSuggested Downloads when downloading SQL Server 2005 Express EditionBasic Books Online DiscussionAdministrative Privileges in VistaThis video is an excellent start to the section. Whether you are a beginner, intermediate or even an advanced user you will find extremely useful information contained within this video section. This is a must watch for all of the people looking to benefit and make their lives easier when working with SQL SERVER and WINDOWS VISTA.
NOTE: This video's description was written by one of our members, Wayne Leiser. Thanks, Wayne! Source: http://www.learnitfirst.com/Course/199/Video/804/Installing-SQL-Server-2005-Expresson-Windows-Vista-Pt1.aspx Course: http://www.learnitfirst.com/Course/199/VB-2005.aspx Skill Level: 200 (Beginner - Intermediate) Length: 8:30 (8.90MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: install, installing, express edition, windows vista, vista,
This video comes from the Visual Basic .NET online training course, Visual Basic Programming with Visual Studio 2005. And be sure to check out even more Visual Basic Programming training videos.
Posted at 08:16 AM | Permalink | TrackBack (0)
Pt. 3 - Installing and Configuring Additional Domain Controllers - view details
This video, part three in our section on installing private namespace domains, covers the installation and configuration of DNS on the second domain controller. Configuring DNS is not a trivial task for an administrator, especially when you have multiple DNS servers on your network therefore this is an excellent video to help you understand the architecture of domains and forests.
Related Videos: We also have a video section on how to install Exchange Server on a private namespace domain Source: http://www.learnitfirst.com/Course/232/Video/708/Installing-and-Configuring-Additional-Domain-Controllers.aspx Course: http://www.learnitfirst.com/Course/232/Windows-2003.aspx Skill Level: 300 (Intermediate) Length: 13:30 (7.8MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: active directory, .local, local namespace domains
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 Dreaded Blue Screen of Death: Every Administrators Nightmare! - view details
While recording a video on how to add USB/Firewire drives into your Windows 2003 server, expert trainer Grant Moyle encountered a blue screen of death (BSOD). Unable to later reproduce the error, Grant decided to release this video showing you how you can experience these at the worst possible times (getting a BSOD while recording a 'How-To' video is not a good time!) and Grant talks about what the error text can mean and how to recover. Good job, Grant - way to recover gracefully! BE AWARE that Grant does not experience the BSOD until around 6:38. Feel free to fast forward if you like! Source: http://www.learnitfirst.com/Course/232/Video/175/Blue-Screen-of-Death-Every-Administrators-Nightmare-and-Disaster-Recovery.aspx Course: http://www.learnitfirst.com/Course/232/Windows-2003.aspx Skill Level: 300 (Intermediate) Length: 15:49 (9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: bsod windows 2003 how to recover
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)
Pt. 4 - Configuring Active Directory Sites - view details
This video covers how to configure your Active Directory Sites. Even if you only have one location, taking the time to configure Sites can increase your Active Directory performance, and reduce those pesky event logs entries about not having a site defined.
Related Videos: We also have a video section on how to install Exchange Server on a private namespace domain Source: http://www.learnitfirst.com/Course/232/Video/709/Configuring-Active-Directory-Sites.aspx Course: http://www.learnitfirst.com/Course/232/Windows-2003.aspx Skill Level: 300 (Intermediate) Length: 11:30 (6.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: active directory, .local, local namespace domains
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)
Pt. 4 - Using Gridviews, SQL Server 2005, and Hacking Your Textboxes - view details
This 4th video tutorial in the section will show you how to efficiently use gridviews, how to incorporate SQL server 2005 databases and connections, as well as discuss textbox hacking.Highlights:Adding a table from SQL server databaseHow to make a custom SELECT statementWhat is Pagination? Source: http://www.learnitfirst.com/Course/199/Video/822/Using-Gridviews-SQL-Server-2005-and-Hacking-Your-Textboxes.aspx Course: http://www.learnitfirst.com/Course/199/VB-2005.aspx Skill Level: 300 (Intermediate) Length: 16:30 (11.2MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: sql injection
This video comes from the Visual Basic .NET online training course, Visual Basic Programming with Visual Studio 2005. And be sure to check out even more Visual Basic Programming training videos.
Posted at 08:16 AM | Permalink | TrackBack (0)
