IT Training Videos From LearnItFirst.com

SQL Server 2008 Analysis Services Training Video: Overview of SQL Server Data Types: CLOBs and BLOBs

Overview of SQL Server Data Types: CLOBs and BLOBs - view details
CLOBs and BLOBs have been around for a while, and as fun as they are to say, the "up-to-date" way to refer to them is Large Value Types. What are CLOBs and BLOBs? How would you store textual, image, or mp3 files? Trainer Scott Whigham will take you through some demonstrations, pointing out relevant differences between SQL 2000 and SQL 2005 (and newer) along the way. Playing around with the AdventureWorks database, Scott will show you how to find out what columns use which data types, how to import and export files in SSIS, and much more in this example-packed demo video.

Highlights from this video:NVARCHAR(MAX), VARBINARY(MAX), and VARCHAR(MAX)
What are the storage limitations when using Large Value Types?
What changes when you add "(MAX)"?
The REPLICATE functionWhere to get AdventureWorks samplesHow to import/export files in SSISSSIS Connection Manager

and much more Source: http://www.learnitfirst.com/Course/161/Video/2886/Overview-CLOBs-BLOBs.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 16:15 (46.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server 2008, ssas, ssis, ssms, 2005, t-sql, conversion, if, table, permanent, objects, function, data, transaction, locking, ddl, dml, trigger, action, xml, clr, program, geospatial, encryption, clob, blob, go, batch, print, collation, unicode

This video comes from the SQL Server 2008 Analysis Services online training course, Transact-SQL Programming: SQL Server 2008/R2. And be sure to check out even more SQL Server Analysis Services training videos.

SQL Server 2008 DBA Training Video: How to Restore a SQL Server D atabase Using SSMS, Part 2

How to Restore a SQL Server Database Using SSMS, Part 2 - view details
In this video we will continue where we left off in "How to Restore a SQL Server Database Using SSMS, Part 1" by discussing the error message we received when doing a point-of-last-backup restore.

Highlights from this video:

Why can't we go through with our restore?
Backing up the tail of the log
About point-of-failure recovery
Restore options in SSMS
How to kill processes to complete your restore
and much more Source: http://www.learnitfirst.com/Course/157/Video/1843/Pt2-Restore-Database-Using-SSMS.aspx Course: http://www.learnitfirst.com/Course/157/SQL-Server-2008-DBA.aspx Skill Level: 300 (Intermediate) Length: 12:00 (37.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: restore,restoring,backup, backing up,database,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.

SQL Server Programming and Queries Training Video: Part 1 - Commo n Table Expressions (CTEs) - What They Are and When to Use Them

Part 1 - Common Table Expressions (CTEs) - What They Are and When to Use Them - view details
Common Table Expressions (CTEs) are an interesting addition to SQL Server 2005's Transact-SQL language. Author Scott Whigham walks you through the basics of what CTEs are, the syntax and concepts of using CTE and gives you a few examples in this video. This video is part 1 in our section on CTEs and is designed to be an introduction to the syntax and the concepts of using CTEs. Source: http://www.learnitfirst.com/Course/150/Video/371/Intro-to-Common-Table-Expressions-CTE.aspx Course: http://www.learnitfirst.com/Course/150/SQL-2005-Programming.aspx Skill Level: 300 (Intermediate) Length: 12:12 (8.14MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql recursion, sql hierarchy, hierarchical query

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.