Thursday, October 30, 2008

New SQL Server Video Tutorial: Part 4 - Versions, Editions, Licen sing, and Pricing

Part 4 - Versions, Editions, Licensing, and Pricing - view details
This fourth video in the series, a longer video than normal, will discuss the three different versions, various editions, multiple licensing options and pricing ranges for SQL Server.

Highlights from this video:
  • History and functionalities of SQL Versions
    • 2000
      • SSRS
      • Clustering and log shipping
    • 2005
      • SSIS
      • CLR
    • 2008
      • New datatypes
      • XML integration
  • About the SQL Server Editions: Audience annd Highlights
    • Express
    • Workgroup
    • Standard
    • Enterprise and Developer
  • Pricing for the various editions
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, server, edition, license, price, version, technical, overview, intro , introduction, step by step, beginner, beginning, for

posted by Scott Whigham @ 2:34 PM  

New SQL Server Video Tutorial: Part 1 - A Technical Overview of S QL Server: What Is SQL Server?

Part 1 - A Technical Overview of SQL Server: What Is SQL Server? - view details
If you have little to??no prior knowledge about database servers and??are??looking to learn about SQL Server then you've found the right video series! In this first video in the series your instructor, Scott Whigham, will introduce you to the concepts behind??Microsoft SQL Server. You will learn the first of three basic W's of SQL Server: what is it, who uses it, what??it does.??

This video series is great for those of you who are looking for a great intro technical overview of SQL Server.

Highlights from this video:

  • Acronyms to know
    • DBMS
    • SQL
    • MSFT
  • What is SQL Server?
    • Database server
    • Other products that ship with SQL
      • SSAS
      • SSRS
      • SSIS
    • History of SQL Server versions
  • SQL Server = RDBMS
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, server, introduction, intro, overview, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:34 PM  

New SQL Server Video Tutorial: Part 2 - What Can I Do With SQL Se rver, Analysis Services, Reporting Services, and Integration Services?

Part 2 - What Can I Do With SQL Server, Analysis Services, Reporting Services, and Integration Services? - view details
This second video in our technical overview of Microsoft SQL Server will continue by answering the question: What can I do with SQL Server? The instructor will outline the various functions of the SQL Server products (SSRS, SSAS, SSIS) as well as the Database Server itself.

The author's presentation notes??are included with your download!

Highlights from this video:

  • What can I do with the:
    • Database Server
    • Analysis Services
      • About multidimensional data
    • Reporting Services
      • Report generation and viewing
    • Integration Services
      • ETL tool
      • About sources and destinations
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, server, intro, overview, ssas, ssrs, ssis, integration, analysis, reporting, services, introduction, step by step, beginner

posted by Scott Whigham @ 2:34 PM  

New SQL Server Video Tutorial: Part 5 - A Look at the Hardware Re quirements: CPU, Memory and Hard Drives

Part 5 - A Look at the Hardware Requirements: CPU, Memory and Hard Drives - view details
The main topic of this video is the hardware, such as the CPU, memory, and hard drives,??that is typically used in the SQL Server world.

Highlights from this video:
  • CPU needs
    • How many CPUs do I need to use?
  • Sufficient RAM (memory) for SQL
    • Requirements and "hot set"
    • RAID
      • RAID 0
      • RAID 1
      • RAID 5
      • RAID 1+0
and much more??
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: hardware, requirements, cpu, memory, raid, hard drive, ram, sql, overview, , introduction, step by step, beginner, beginning, fo

posted by Scott Whigham @ 2:34 PM  

New SQL Server Video Tutorial: Part 3 - Who Uses SQL Server, Anal ysis Services, Reporting Services and Integration Services?

Part 3 - Who Uses SQL Server, Analysis Services, Reporting Services and Integration Services? - view details
In the third video in our "Technical Overview of SQL Server" series, we will answer the third question: Who uses it? This video tutorial will discuss the typical users of SQL Server as well as SSAS, SSIS, and SSRS.

Highlights from this video:
  • Who uses the database server?
  • Intro to SQL Server cost
  • SSAS typical users
  • Reporting Services: What types of companies need to do reporting?
    • Is it an alternative to Crystal Reports/Business Objects?
  • Sql Integration Services users
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: ssas, ssis, ssrs, integration, analysis, reporting, user, sql, technical, overview, intro,, introduction, step by step, beginner

posted by Scott Whigham @ 2:34 PM  

New SQL Server Integration Services Video Tutorial: Part 12: A To ur of the SSIS Maintenance Tasks

Part 12: A Tour of the SSIS Maintenance Tasks - view details
This video is the final video is this massive series. You will learn all about the DBA-related SQL Server Maintenance Tasks
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: DBA-related SQL Server Maintenance Tasks, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:34 PM  

New SQL Server Video Tutorial: Part 6 - Operating Systems and Oth er Software Requirements

Part 6 - Operating Systems and Other Software Requirements - view details
In our final video tutorial in the series we will discuss the needs operating systems and the other software requirements for running SQL Server.

Highlights from this video:
  • Windows OS' support
    • XP, Vista, 2000, 2003, 2008, 7
    • Most flexible edition ?
    • Most restrictive edition?
  • Chip architecture and compatibility with various SQL editions
    • X64, X86, IA64
  • Software requirements
    • .NET
  • Disk space requirements
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: operating system, os, software, requirement, overview, sql, windows,, introduction, step by step, beginner, beginning, for dummi

posted by Scott Whigham @ 2:15 PM