Tuesday, December 30, 2008

New SQL Server 2005 Database Administration Video Tutorial: Part 6 - Operating Systems and Other 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 @ 11:34 AM  

New SQL Server 2005 Database Administration Video Tutorial: Part 1 - A Technical Overview of SQL 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 @ 8:34 AM  

New SQL Server 2005 Database Administration Video Tutorial: Part 3 - Who Uses SQL Server, Analysis Services, Reporting Services and Integra tion 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 @ 8:34 AM  

New SQL Server 2005 Database Administration Video Tutorial: Part 2 - What Can I Do With SQL Server, 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 @ 8:34 AM  

New SQL Server 2005 Database Administration Video Tutorial: Part3 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions

Part3 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions - view details
In this third video, you will learn about the dm_exec and relationships among the sql handle, which will show you how to view the code someone is issuing and past calls and metrics. Scott will do so by walking you through several custom scripts, which are included with this video download!

Highlights from this video:
  • Scripts for:
    • Viewing definitions of system objects
    • Getting the most often run queries
    • Viewing cached query plan SQL text
    • Getting top 200 executed SP's ordered by calls/minute
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

Ke ywords Associated with this video: dmv, dynamic management view, monitor user, block,lock, script,dm_exec

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2005 Database Administration Video Tutorial: Part 5 - A Look at the Hardware Requirements: 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 @ 8:34 AM  

New SQL Server 2005 Database Administration Video Tutorial: Part 4 - Versions, Editions, Licensing, 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 functionality of SQL Versions
    • 2000 - SSRS, Clustering and log shipping
    • 2005 - SSIS and CLR
    • 2008 - New data types and XML integration
  • About the SQL Server Editions: Audience and 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 @ 8:34 AM  

New SQL Server 2005 Database Administration Video Tutorial: Part4 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions

Part4 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions - view details
In this fourth and final video in the series, you will finish up the dicussion of Dynamic Management Views by learning more about the dm_tran series of DMVs and how they can be beneficial to you.

Highlights from this video:
  • About the sys.dm_tran category
  • Viewing transaction locks on the system
  • Active transactions, transaction types, database transactions
and 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: dynamic management view, DMV, lock, block, transaction,

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2005 Database Administration Video Tutorial: Part1 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions

Part1 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions - view details
In this first video of the series you will be working with multiple connections, troubleshooting locks and blocks in your server, as well as learn who is doing what with your system by going beyond the Activity Monitor and taking advantage of the Dynamic Management Views, DMVs.

Highlights from this video:
  • Problems with the Activity Monitor
  • Using Filter setting in the Activity Monitor
  • About the DMV categories
and 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: dynamic management view, DMV, lock, block, activity monitor,

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2005 Database Administration Video Tutorial: Part2 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions

Part2 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions - view details
In this second video, you will learn more about the columns and how to get more info from them. Scott will also dicuss with you some of the more useful Dynamic Management View categories and what they can do for you.

Highlights from this video:
  • More about the Exec DMV category
  • About the Server Process i.d.(SPID), and Session i.d.
  • Shared Memory, LPC, TCP, NC,
  • SQL Handle, plan Handle
and 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: dmv, dynamic management view, monitor user, block,lock,

posted by Scott Whigham @ 8:34 AM  

Thursday, December 11, 2008

New Exchange Server Video Tutorial: Part 6 - Testing Creation of a New Mailbox on the Cluster and Moving a Mailbox to the Cluster

Part 6 - Testing Creation of a New Mailbox on the Cluster and Moving a Mailbox to the Cluster - view details
Once you have an Exchange cluster up and running, you will want to begin putting some mailboxes on it. In this video, your instructor will present you with two scenarios for putting a new mailbox on the cluster: creating a new mailbox and/or moving a mailbox.

Highlights from this video:
  • Creating a new user mailbox
    • Proving the mailbox exists on the cluster
  • Cluster administration and about front-end interaction
  • How to move a users mailbox from the standalone server to the cluster
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: cluster, mailbox, create, move, moving, creating, mail box,

posted by Scott Whigham @ 2:34 PM  

Monday, December 8, 2008

New SQL Server 2008 Database Administration Video Tutorial: Creat ing SQL Server Databases - Part 1

Creating SQL Server Databases - Part 1 - view details
We will begin talking ��more in-depth about actually creating databases in this video. The author will cover where databases can be created, as well as detail what makes up a database.

Highlights from this video:
  • About where can��you can��create databases
    • SSMS (GUI), T-SQL Scripts, SMO
  • Databases are just files
    • Data files
      • Primary data file (.mdf), Secondary data file (.ndf)
    • Transaction log file (.ldf)
  • Why should I use multiple files?
    • Space and file management, Performance
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: database, create, creating, sql server, 2008

posted by Scott Whigham @ 11:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: How t o Configure SQL Server: Security Settings and Connection Options

How to Configure SQL Server: Security Settings and Connection Options - view details
In this video, we will take a look at the security settings and connection options that you can configure for SQL Server 2008.

Highlights from this video:
  • About the security settings that can be changed
    • Authentication mode, Logon auditing, Server Proxy account
    • Common Criteria Compliance, C2 audit tracing
  • Configuring connection options
    • Concurrent connections ,Query Governor
  • Common connection options
    • ANSI nulls, no count, quoted identifier
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 subscrip tion is required.

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

Keywords Associated with this video: connection, security, configure, configuration, authentication, audit, sql, server, 2008

posted by Scott Whigham @ 11:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: How t o Configure a SQL Server Database - Part 5

How to Configure a SQL Server Database - Part 5 - view details
In this last video in the section, we will walk through��the process of��changing the��configurations using SQL Server Management Server using the��GUI and Transact-SQL methods.

Highlights from this video:
  • Two methods for viewing the properties of databases
    • GUI or sp_dboption
  • How to change the default settings
    • GUI or Transact SQL
  • What happens after I change my configuration settings?
    • Connections
    • Read-only
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 hav e the TSCC codec installed to view this video

Keywords Associated with this video: configuration, configure, configuring, database, db, data base, sql, server

posted by Scott Whigham @ 11:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: An Ov erview of the Tools Installed in SQL Server 2008

An Overview of the Tools Installed in SQL Server 2008 - view details
In our previous chapter we took a look at installing and upgrading to SQL Server 2008. In this chapter, we will take a look at what was installed, an overview of the tools, and an overview of configuring the server. In this video, we will begin by examining the tools that were installed with SQL Server 2008

Highlights from this video:
  • Tools are available for:
    • Administrators, Developers, Command line only
    • GUI (Graphical User Interface), API (Application Programming Interface)
  • Command line tools that target DBAs
    • Tools and descriptions
  • About the GUI tools
    • SSMS,BIDS, Visual Studio 2008, SQL Server Configuration Manager
  • APIs for developers
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: install, sql ,server, 2008, overview, tools, features,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 11:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: An In troduction to SQL Server Configuration Manager, Visual Studio and Books On line

An Introduction to SQL Server Configuration Manager, Visual Studio and Books Online - view details
In this video, the author will introduce you to the Configuration Manager, Visual Studio and Books Online

Highlights from this video:
  • Visual Studio 2008 and SQL Server (Business Intelligence Development Studio (BIDS)
    • Demo of how a developer would use this tool to create reports
  • About Books Online
    • Navigating
    • Updating
  • Introduction to the SQL Server Configuration Manager
    • Functionality of Configuration Manager
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 requ ired.

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

Keywords Associated with this video: sql server, configuration manager, visual studio, books online,introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 11:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: An In troduction to Using SQL Server Management Studio - Part 1

An Introduction to Using SQL Server Management Studio - Part 1 - view details
In this video will begin our tour of the SQL Server Management Studio, something that you'll be using often and has many new improvements in SQL Server 2008.

Highlights from this video:
  • Launching SSMS
  • Exploring SSMS
    • How to browse for and connect to a server
      • Connection properties
  • About the SSMS interface
    • Object Explorer
    • Query pane
    • Object Explorer Details
    • Registered Servers
    • Properties Window
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: SSMS, sql server, management studio, intro, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 11:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: How t o Configure SQL Server: Configuring SQL Server Memory Usage

How to Configure SQL Server: Configuring SQL Server Memory Usage - view details
We will now take a look at memory usage in SQL Server 2008, one of the most obvious places you'll want to tweak when configuring your SQL Server.

Highlights from this video:
  • Where is memory primarily used?
    • Buffer cache
    • Procedure cache
  • Sizing the buffer cache and procedure cache
  • Memory options you can change
    • Maximum server memory
    • Minimum server memory
    • Address Windowing Extensions (AWE)
    • Minimum memory per query
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 re quired.

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

Keywords Associated with this video: sql, server, memory, buffer cache, procedure cache,

posted by Scott Whigham @ 11:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Servi ce Packs, Hotfixes, and More: Keeping Your SQL Server 2008 Up to Date

Service Packs, Hotfixes, and More: Keeping Your SQL Server 2008 Up to Date - view details
Like all software, your SQL Server needs to be updated. In this video tutorial, your author will discuss service packs, hotfixes and more methods to keep SQL Server 2008 up-to-date.

Highlights from this video:
  • What features will need updating?
  • SQL Incremental Service Model (ISM)
    • Critical-on-Demand hotfixes (COD), On-Demand hotfixes (OD), Cumulative Update (CU), General Distribution Release (GDR)
  • Identifying what service pack or hotfix you have installed
    • Product level
    • Build number
      • Determining your build number
    • File version
  • How do I get the service pack/hotfix?
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: service pack, update, hotfix, sql, server, updating, service, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Under standing What Happens When You Install Multiple Instances

Understanding What Happens When You Install Multiple Instances - view details
After the installation of the second instance of SQL Server 2008 has completed, we will begin by viewing the services that are installed and compare the different instances of SQL Server 2008. The author will also divulge some of the reasoning behind installing multiple instances.

Highlights from this video:

  • Viewing instances installed at the service level
    • Default and Named
  • Instance dependent and instance independent services
  • Comparing default instance and named instance
  • Why would I want to use multiple instances?
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, 2008, install, installation, instance, named,introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: What To Do After Your Upgrade Is Complete

What To Do After Your Upgrade Is Complete - view details
Life is good, right? You've completed the upgrade to SQL Server 2008, but you're unfortunately not done yet. Once you've done the upgrade, there's a few things you'll want to check and make sure are correct. In this video, your author will cover the obvious and not-so-obvious things you'll need to do.

Highlights from this video:
  • Obvious things to test
    • DTS packages
    • SQL jobs
    • Applications
  • Things the Upgrade Advisor didn't warn you about
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: upgrade, sql, 2008, install, installation, upgrading, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Upgra ding to SQL Server 2008: What Can Be Upgraded?

Upgrading to SQL Server 2008: What Can Be Upgraded? - view details
Are you looking to upgrade to SQL Server 2008 from a SQL Server 2005 or 2000 instance? In this video tutorial, your author will discuss what you need to do before you upgrade to SQL Server 2008.

Highlights from this video:
  • Upgrade support
    • 64-bit, 32-bit
  • What can I upgrade from?
    • Prior versions, Lower editions
  • Difficult upgrades and simple upgrades
  • Things that will prevent your upgrade
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: upgrade, sql, 2008, 2000, 2005, edition, version, upgrading, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Upgra de SQL Server 2000 DTS Packages

Upgrade SQL Server 2000 DTS Packages - view details
One thing you need to be very aware of is the difficulty of migrating your SQL Server 2000 DTS packages to SQL Server 2008. In this section, the author will discuss the processes of upgrading your SQL Server 2000 DTS packages from a DBA's standpoint.

Highlights from this video:
  • The shift to SSIS and from DTS
    • Comparison and analogy
    • Rewriting and re-architecturing for SSIS
  • In-place upgrade components for 2008
    • Microsoft SQL Server Backward Compatibility
    • SQL Server 2000 DTS Designer
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: upgrade, upgrading, sql, server, 2000, dts, ssis, migrate, migrating,, introduction, step by step, beginner, beginning, for dumm

posted by Scott Whigham @ 8:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Runni ng the SQL Server 2008 Upgrade Advisor

Running the SQL Server 2008 Upgrade Advisor - view details
This video will be a cross between demos and lecture focused on working with the SQL Server Upgrade Advisor.

Highlights from this video:
  • About the SQL Server Upgrade Advisor
  • How to install the upgrade advisor
  • Working with the Upgrade Advisor Analysis Wizard
    • Launching the Upgrade Advisor Report Viewer
  • Working in the Upgrade Advisor
    • Choosing components to analyze
    • Entering parameters for analysis
      • Profiler and trace files
    • SSIS Parameters
  • Navigating your analysis report
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: upgrade, advisor, sql server, 2008, report, analysis wizard, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: An Ov erview of What's Installed: Tools

An Overview of What's Installed: Tools - view details
In this video tutorial, Scott Whigham will give you a brief tour of some of the tools that have been installed with SQL Server 2008.

Highlights from this video:
  • About Windows PowerShell
  • What will Microsoft Visual Studio do for my server?
  • Performance tools: SQL Server Profiler
  • Integration Services
  • Configuration Tools: SQL Server Configuration Manager
  • About SQL Server Management Studio (SSMS)
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 ,2008, install, walkthrough, demo, tour, tools, tool, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Lectu re on What Are Instances and When Are They Appropriate

Lecture on What Are Instances and When Are They Appropriate - view details
This video will take a formal look at SQL Server instances. In this video the author will discuss when to use instances, what purpose they serve, and clear up some licensing questions about them. The author's presentation is included with your download.

Highlights from this video:
  • What is an instance?
    • Default instance, Named instances
  • Common instance setup
  • What are single instances appropriate for?
  • When to use multiple instances
    • Mixed versions, Mixed editions, Mixed releases
  • Named instance rules
  • Instance licensing in 2008 compared to 2005
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: instance, install, named, default, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Insta lling a Named Instance

Installing a Named Instance - view details
Have you ever wondered what people are referring to when they talk about various instances of SQL? What is an instance? An instance is simply an installation of SQL Server. This video will begin by picking up after your installation of SQL Server 2008 has successfully completed and will discuss instances and demonstrate how to install a named instance.

Highlights from this video:
  • Determining your instance
  • What is a default instance?
  • Working with the Management Studio
  • How to install a named instance for SQL Server
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: install, installing, installation, sql, 2008, instance, named, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 8:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Thing s You Have to Know Before You Install SQL Server - Part 3

Things You Have to Know Before You Install SQL Server - Part 3 - view details
We will continue our discussion on what you need to know before you install SQL Server 2008 by covering the topic of security models, account provisioning, and we'll wrap up with a brief discussion on��some of the best practices for SQL security.

Highlights from this video:
  • Two security model choices:Windows Authentication or Mixed Mode
    • Examples of when to use, Pros and cons
  • Account provisioning
    • What domain accounts do you want them to run under?
  • Best practices and suggestions for security at the service level
    • Principle of least privilege
    • Separate accounts and instancing
  • About the SQL Server Database Engine
    • Domain account
    • Assigning additional permissions
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: install, sql, 2008, prereq, security, windows authentication, mixed mode, account provisioning, database engine, introduction, s

posted by Scott Whigham @ 5:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: What' s New in SQL Server 2008 - Part 3

What's New in SQL Server 2008 - Part 3 - view details
In this video we will discuss some of the new features and enhancements for Developers in SQL Server 2008.

Highlights from this video:
  • T-SQL Developments
    • Intellisense, Table-valued parameters, Compound operators
    • Declaration and assignment in a single statement, XML enhancements, FILESTREAM
  • New datatypes and accuracy
    • DATE, TIME, DATETIME2, and DATETIMEOFFSET
    • HierarchyId
  • Geospatial datatypes and when to use:
    • GEOMETRY, GEOGRAPHY
  • Debugging
    • T-SQL Debugging in SSMS
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: tsql, datatype, geospatial, debug, geometry, geography, intellisense, filestream, introduction, step by step, beginner, beginnin

posted by Scott Whigham @ 5:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Insta lling SQL Server 2008 Default Instance - Part 2

Installing SQL Server 2008 Default Instance - Part 2 - view details
In this second video, we will finish working through the��setup of SQL Server 2008 by discussing the server configuration and database engine configuration and end by running the installation.

Highlights from this video:
  • Creating new service accounts
  • Customizing the SQL Server Database Engine collation
    • Account provisioning and authentication modes
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 r equired.

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

Keywords Associated with this video: install, sql, server, 2008, installing, installation, prereq, instance,, introduction, step by step, beginner, beginning, for du

posted by Scott Whigham @ 5:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Insta lling SQL Server 2008 Default Instance - Part 1

Installing SQL Server 2008 Default Instance - Part 1 - view details
After covering and discussing all of the prep work, we're finally ready to begin installing SQL Server 2008. This first video tutorial will begin by running the setup program from the disk and work all the way up to the selection of features to install for SQL and briefly covering the instance configuration.

Highlights from this video:
  • Before we begin:
    • Installing .NET Framework 3.5
  • Navigating the SQL Server Installation Center
    • Creating a new SQL Server Stand-alone
  • Installing setup support files
  • SQL Server 2008 Feature Selection
    • Common features to install
    • Basic management features vs complete management features
  • Choosing your instance configuration
    • What is the Instance ID?
  • 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 subscripti on is required.

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

Keywords Associated with this video: install, sql, 2008, default, installation, installing, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Thing s You Have to Know Before You Install SQL Server - Part 4

Things You Have to Know Before You Install SQL Server - Part 4 - view details
In our last lecture video on the things you need to know before we begin the install of SQL Server 2008, we will cover typical locations for your essential SQL Server files as well as discuss what type of server collation will work for you.

Highlights from this video:
  • Where to put the files and default locations
    • Program files
    • Database and log files
    • Backups
  • What server collation should you use?
    • Default server collation
    • What does collation define?
    • Two types of collations
      • Windows Collation
      • SQL Server Collation

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, install, 2008, prereqs, server collation, windows collation, sql collation, location, introduction, step by step, beginner,

posted by Scott Whigham @ 5:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Thing s You Have to Know Before You Install SQL Server - Part 2

Things You Have to Know Before You Install SQL Server - Part 2 - view details
In this second video tutorial, you will begin��by exploring the various hardware and software��requirements for your install of SQL Server 2008. Your instructor will discuss the software/hardware needs for a small-medium sized database in comparison to the hardware/software needs of the larger databases. Included with your download is the instructor's presentation as a .PDF file.

Highlights from this video:
  • Defining a small, medium, and large database
    • Sizes in GB
  • RAID sets and SANs for small through large databases
    • Common RAID placements on small databases
  • 32-bit or 64-bit?
    • Advantages of 64-bit : Linear scalability, TCO
  • Determining which machine(s) need to run the install program
    • Server and/or workstation?
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: install, sql, 2008, prereq, database, db, RAID, 32 bit , 64 bit,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Thing s You Have to Know Before You Install SQL Server - Part 1

Things You Have to Know Before You Install SQL Server - Part 1 - view details
In this video, your instructor will go over a lot of different decisions you need to make as well as things you need to know before you install SQL Server 2008. There's a lot of prep work that is needed before the actual install, and in this video tutorial your instructor will cover just that. This video begins by discussing two questions that will help you determine what to do for your install of SQL Server 2008: "What type of server?" and "What is the role of the server?".

Highlights from this video:
  • What type of server are you installing?
    • How to determine what server you're working with
  • What is the main role of your particular server?
    • SSRS?
    • Domain controller?
    • SharePoint? etc
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: install, sql, server, 2008, role, db,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: What' s New in SQL Server 2008 - Part 4

What's New in SQL Server 2008 - Part 4 - view details
We will finish our discussion on the new features and enhancements to SQL Server 2008 by discussing what's new in the Business Intelligence side (SSIS, SSRS, SSAS)��

Highlights from this video:
  • SSIS Enhancements
    • C#, VSTA (Visual Studio Tools for Applications)
    • Improved threading and pipeline scalability, less limitations on lookups
  • Reporting Services Improvements
    • IIS requirements, better caching and memory management
    • Tablix data regions, Reports in Microsoft Word
  • Analysis Services
    • Star JOINs, MERGE statement, and various enhancements
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: ssis, ssrs, ssas, enhancement, improvement, sql 2008, feature, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: What' s New in SQL Server 2008 - Part 2

What's New in SQL Server 2008 - Part 2 - view details
This video will begin by covering many of the new features and enhancements��in SQL Server 2008 in the performance, security, management, and availability areas for DBAs.

Highlights from this video:
  • Performance Improvements:
    • Compression enhancements
      • Backup compression, Log Stream compression, Data compression
    • Database enhancements
      • Improved "Plan Guide" support, Resource Governor, Performance Data Collection
      • Partitioned Table Parallelism and Partion-aligned Index Views (larger databases)
  • Security Improvements
    • Transparent Data Encryption, Extensible Key Management (EKM)
    • New database roles and renaming
  • Management Improvements
    • Policy-based Management, SQL Server Audit, Change Data Capture (CDC),Data Profiling Task
    • Extended Events (xEvents), Enhancements to Central Management Servers and Server Groups
  • Availability Improvements
    • Enhanced database mirroring, Suspect page recovery, Peer-to-peer replication, Hot pluggable CPUs
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: dba, enhancement, improvement, upgrade, new, feature, sql, 2008, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: The E ditions of SQL Server, Part 2

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 Edition
    • Workgroup Edition
      • Who would use this edition?
    • Web Edition
      • Low TCO (Total Cost of Ownership)
    • Three versions of Express Edition
      • SQL Server Express, SQL Server Express with Tools, SQL Server Express with Advanced Services
  • Comparison of Specialized 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: edition, specialized, developer, workgroup, web, express, editions, sql, 2008, , introduction, step by step, beginner, beginning

posted by Scott Whigham @ 2:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: The H istory of SQL Server

The History of SQL Server - view details
This video will provide an in-depth background��of Microsoft's database server, SQL Server. The discussion starts with the original licensing deal and marketing strategies in 1989 and will follow all the way through what Microsoft might be doing for their future releases of SQL Server.

Highlights from this video:
  • The 1980's- the beginning of SQL Server
  • The 1990's
    • Microsoft SQL Server 1.1 release and 4.2 release
    • SQL95 and SQL Server 6.5
    • SQL Server 7.0
      • Microsoft rewrites code
      • Feature debuts
  • The Millennium
    • SQL Server 2000
    • SQL Server 2005
      • Works with Windows Server 2003 and many new features
    • SQL Server 2008
      • Windows Server 2008 and enhancements
    • SQL Server .NEXT?
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: history, overview, sql server,, 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:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: What' s New in SQL Server 2008 - Part 1

What's New in SQL Server 2008 - Part 1 - view details
We will be taking a look at some of the new features and enhancements in SQL Server 2008, as handpicked by the author. The detailed features in this video series are not comprehensive. Keep in mind that some of the new features may only target 5% of users, but many are simply "better ways" . In this introductory��discussion of the features, the author will discuss how they relate to your job as a SQL Server DBA. This video won't introduce any new features, but rather discuss how SQL Server 2008 has changed the DBA workforce.

Highlights from this video:
  • Why upgrade to SQL 2008?
    • Customer support
    • Scalability
    • New features
  • SQL Server DBA's : specialization on components
    • Segmenting the "talent"
    • SQL 2008 = hard to be a specialist?

��

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, 2008, dba, database administrator, job, role, upgrade, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Prici ng and How Licensing Works in SQL Server 2008 - Part 1

Pricing and How Licensing Works in SQL Server 2008 - Part 1 - view details
This video tutorial will walk you through the two different methods to license your version of SQL Server: CPU or CAL.The author will detail several scenarios that can be used in comparing what license to use. Also, included with the download of the video is the author's presentation in .PDF format.

Highlights from this video:
  • CAL Licensing Model
    • Two Client Access Licenses:
      • CAL for a user and CAL for a device
    • User model or Device model?
      • Situational explanations and scenarios
  • CPU Licensing Model
  • How MSFT determines license usage
    • Scenarios and possible answers
  • CPU or CAL?
    • What is the switching point?
    • Cost effectiveness
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: license, CAL, CPU, client access license, user CAL, device CAL, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Prici ng and How Licensing Works in SQL Server 2008 - Part 2

Pricing and How Licensing Works in SQL Server 2008 - Part 2 - view details
This second video will continue by starting off our discussion by covering the licensing process of a virtual environment and finish by covering the respective costs of the various licenses.

Highlights from this video:
  • Licensing and VMware
  • Retail costs of CPU and CAL licenses for:
    • Enterprise license
    • Workgroup license
    • Web license
    • Standard license
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: license, price, cost, cpu, cal, enterprise, workgroup, web, standard, introduction, step by step, beginner, beginning, for dummi

posted by Scott Whigham @ 2:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: The E ditions of SQL Server, Part 1

The Editions of SQL Server, Part 1 - view details
This video tutorial will break down the two Server Editions of SQL Server 2008: the Enterprise Edition and the Standard Edition. Your instructor will provide you with an overview of the characteristics of the two versions as well as give you an idea of who would typically use them. Also included with your download is a .PDF file of the author's presentation.

Highlights from this video:
  • What is a Server edition? Specialized edition?
  • Processor architecture
    • x86, x64, IA64
  • Brief overview of the SQL Server 2008 Compact Edition
    • Previous names
    • What kind of devices to run it on
  • Server editions
    • Who uses them?
    • Enterprise Edition and Standard Edition
    • Comparing the Server 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 subscriptio n is required.

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

Keywords Associated with this video: edition, sql, server, standard, enterprise, 2008, editions, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:34 PM  

New SQL Server 2008 Database Administration Video Tutorial: Depre cated and Discontinued Items in SQL Server 2008

Deprecated and Discontinued Items in SQL Server 2008 - view details
In this essential video tutorial, Scott Whigham will provide you with an overview of some of the items that have been deprecated and discontinued��in SQL Server 2008. The most widely used and most popular deprecated and discontinued items are listed and discussed. Also,��a .PDF file of Scott Whigham's presentation is included with your download!

Highlights from this video:

  • Defining "deprecated"
    • Items that may not work in the future
  • Defining "discontinued"
    • Items that won't work right now
  • Most popular discontinued items and their replacements
  • Widely used deprecated items and their replacements
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: deprecated, discontinued, sql 2008, out of service,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 2:34 PM  

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 functionality of SQL Versions
    • 2000 - SSRS, Clustering and log shipping
    • 2005 - SSIS and CLR
    • 2008 - New data types and XML integration
  • About the SQL Server Editions: Audience and 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 sub scription 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 2008 Database Administration Video Tutorial: Quick Demo: How to Create Windows Group Logins and Prevent Certain Users

Quick Demo: How to Create Windows Group Logins and Prevent Certain Users - view details
We will deomstrate in this video how to create a Windows group and a user account at the Windows level.

Highlights from this video:
  • Creating a new Windows group at the Windows level
  • How to make a user a��member of Windows groups
  • Creating a new Windows groups login in SSMS
  • Changing permission and access settings for 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 require d.

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

Keywords Associated with this video: permission, security, sql, server, 2008, user, group, login,

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Chapt er Introduction and The Five Levels of SQL Server Security

Chapter Introduction and The Five Levels of SQL Server Security - view details
Welcome to our chapter on SQL Server 2008 Security. SQL Server Security is a pretty easy concept to understand once you understand the basics. In this first video we will introduce all of the topics that this chapter will cover as well as begin the discussion on the five levels of SQL Server Security.

Highlights from this video:
  • Chapter overview
  • Recommendations for reducing the attack surface area
  • Levels of security in SQL
    • Physical machine
    • Operating System
    • Network
    • Instance-level
    • Database-level
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: Yo u must have the TSCC codec installed to view this video

Keywords Associated with this video: sql, server, 2008, security, security level, attack surface area, introduction,

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: What All SQL Server Logins Must Have, Part 1

What All SQL Server Logins Must Have, Part 1 - view details
We will detail the elements that all SQL Server logins must have in this video. The author's presentation is included with your download.

Highlights from this video:
  • About what the logins must have:
    • Default database
    • Default language
    • Server-role membership
      • sysadmin
      • dbcreator
      • Warnings and suggestions for working with server roles
    • User mapping
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, 2008, security, server role, user mapping, database, language

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Creat ing SQL Server Authentication Logins and Working with Policies

Creating SQL Server Authentication Logins and Working with Policies - view details
Continuing in this video is our discussion on logins and authentication. We will specifically cover the SQL Server Authentication logins and demonstrate how to change your authentication mode as well as explore security for login passwords.

Highlights from this video:
  • What are SQL Server Authentication logins and how do they differ from Windows Authentication?
  • About SQL Server logins and password policies
  • Logins for specific situations
      • Logins mapped to asymmetric key
      • Logins mapped to credential
  • How to change your authentication mode
  • Local Security Policy: Password policies
    • Complexity 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: login, password, security, sql, server, 2008, sql authentication, authentication mode,

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Creat ing Windows User and Windows Group Logins

Creating Windows User and Windows Group Logins - view details
We will continue in this video by talking about logins and permissions, as we've had a little bit of prior background.

Highlights from this video:
  • Logins can be created from...
  • Example scenario of logins and access permissions
    • Pros and Cons of solutions
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: login, sql, server, 2008, security, permission,

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Quick Demo: How to Create a SQL Server Login

Quick Demo: How to Create a SQL Server Login - view details
In this short video we will take a look at a demonstration of how to create a SQL Server login and what it looks like in the SQL Server Management Studio.

Highlights from this video:
  • How to create a new login
    • Logging in with your newly created login
  • Diagram of logins
  • Using code to change databases
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.

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

Keywords Associated with this video: sql, server, 2008, login, create login, user, database, how to

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: An Ov erview of the SQL Server Security Model

An Overview of the SQL Server Security Model - view details
In this video we will go through an overview of the SQL Server security model by discussing some essential terms you need to know. We'll��start with the idea of permissions and work all the way through abstraction layers.

Highlights from this video:
  • Permissions
    • GRANT
    • DENY
    • REVOKE
  • Basic terms to know
    • Login
    • User
    • Role
    • Principal
      • Abstraction layer
  • From where can logins be created?
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, 2008, security, model, permission, login, user, role, principal,

posted by Scott Whigham @ 8:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Manag ing Database Files - Part 2: Removing Databases and Using SQL Scripts

Managing Database Files - Part 2: Removing Databases and Using SQL Scripts - view details
In this video we will demonstrate the process of removing a database by way of SQL scripts and discuss various ways to script out your database data.

Highlights from this video:
  • Can I undo a database drop?
  • Deleting a database in the GUI
  • How to restore a deleted database via scripts
    • Generate Scripts Wizard
  • Using inputfile in cmd prompt to execute script
  • Methods of scripting out data
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, 2008, script, remove, drop, database, generate scripts,

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: An Ov erview of Partitioning - Part 2: How to Partition Tables and Indexes

An Overview of Partitioning - Part 2: How to Partition Tables and Indexes - view details
We'll continue our overview of partitioning by now discussing the requirements for creating partitions in SQL Server 2008.

Highlights from this video:
  • About the requirements for creating partitions
    • Partitioning function
      • Example
    • Partition scheme
      • Example
    • Table/index
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.

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

Keywords Associated with this video: partition, partitioning function, partitioning scheme, table, index, sql ,server, 2008

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Sugge sted Changes After an Upgrade - Part 3: Configuration Changes

Suggested Changes After an Upgrade - Part 3: Configuration Changes - view details
This final video in the "Suggested Changes After an Upgrade" section will cover the remaining 4 crucial steps you need to take after you upgrade to SQL Server 2008.

Highlights from this video:
  • Configuration changes: Significant default changes from SQL 2000 to SQL 2008
    • SQL script included with download
  • Testing: What should you test?
    • Known trouble areas
  • Acceptance/sign off: What do the other departments need to check?
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: upgrade, changes, sql, server, 2008, testing, upgrading, suggestions,

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Sugge sted Changes After an Upgrade - Part 2: Patching and Compatibility Levels

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
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.
< br />

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

Keywords Associated with this video: compatibility level, compatible, patching, sql, server ,2008, upgrade

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Sugge sted Changes After an Upgrade - Part 1: Patching and Compatibility Levels

Suggested Changes After an Upgrade - Part 1: Patching and Compatibility Levels - view details
After you've successfully upgraded to SQL Server 2008, there are six key changes you should make. This video will cover two of these essential steps.

Highlights from this video:

  • Patching the SQL Server installation
    • Varying forms of updates, patches, service packs
  • Verifying/changing the configuration change: compatibility level
    • What does compatibility level allow?
    • Advantages of compatibility levels
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: compatibility level, patching, patch, updating, update, sql, server, 2008

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Manag ing Database Files - Part 4: How to Shrink a Database and Files

Managing Database Files - Part 4: How to Shrink a Database and Files - view details
In this video, we will demonstrate all the database shrink concepts that were detailed in the previous video via several scenarios. The SQL script is included with the video download.

Highlights from this video:
  • Using the Disk Usage Report
  • Shrinking your database using default options
  • Removing unused space by shrinking files
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: Y ou must have the TSCC codec installed to view this video

Keywords Associated with this video: shrink, database, shrink file, disk usage, sql, server, 2008

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Manag ing Database Files - Part 3: How to Shrink a Database and Files

Managing Database Files - Part 3: How to Shrink a Database and Files - view details
In this third video in our section on managing database files, we will begin by talking about how to shrink your database, which is sometimes vital for data storage.

Highlights from this video:

  • When/what should I shrink?
  • Two options for shrinking an entire database
    • NOTRUNCATE
    • TRUNCATEONLY
  • Flexibility of shrinking individual files
    • EMPTYFILE
    • target_size
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: shrink, database, shrinking, notruncate, truncateonly, truncate, emptyfile, data storage

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Manag ing Database Files - Part 1: Removing Databases and Using SQL Scripts

Managing Database Files - Part 1: Removing Databases and Using SQL Scripts - view details
We will jump right in to this section on managing database files��by talking about the ways to remove databases using SQL Scripts. The authpr's presentation is included with your download.

Highlights from this video:
  • Removing a database
    • What am I removing?
  • Methods for deleting a database:
    • Deleting a database in GUI
    • Deleting a database in TSQL
  • Using SQL scripts to protect us from dropping databases
    • About��SQL scripts
        • Where can scripts be executed

��

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 requir ed.

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

Keywords Associated with this video: manage, database, remove, delete, removing, deleting, sql, server, 2008

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: An Ov erview of Partitioning - Part 3: How to Partition Tables and Indexes

An Overview of Partitioning - Part 3: How to Partition Tables and Indexes - view details
Are you ready to see some of the partitioning code in action? In this video, your author will demonstrate how to partition tables and indexes in a step-by-step format.

Highlights from this video:
  • How to create the partition function
  • Creating the partition scheme and table/index
  • How to determine which partitions the rows are in via querying
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.< br />

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

Keywords Associated with this video: table, index, Partition, Partitioning function, Partitioning scheme, query

posted by Scott Whigham @ 5:34 AM  

Sunday, December 7, 2008

New SQL Server 2008 Database Administration Video Tutorial: How t o Make Changes to the Configuration Using SSMS and Transact SQL

How to Make Changes to the Configuration Using SSMS and Transact SQL - view details
In this video, the author will lecture on how to change the configuration settings via SSMS and TSQL. The next video will provide you with the actual demonstration of making configuration changes.

Highlights from this video:
  • Why use the GUI to make changes? Why use scripts?
  • Tips for your configurations
  • Running values vs Configured values
  • How to change configurations in the GUI
  • Using Transact-SQL to modify server configurations
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 subscr iption is required.

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

Keywords Associated with this video: change, configuration, configure, sql, server, ssms, tsql, transact sql,

posted by Scott Whigham @ 5:53 AM  

New SQL Server 2008 Database Administration Video Tutorial: How t o Configure SQL Server: Defaults for All Databases

How to Configure SQL Server: Defaults for All Databases - view details
Continuing with the theme of configuration for SQL Server 2008, this video will wrap up the discussion by detailing the various defaults for databases.

Highlights from this video:
  • About the defaults for databases
    • Index fill factor
    • Backup compression
    • Database default locations
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, 2008, database, default, configure, configuration,

posted by Scott Whigham @ 5:53 AM  

New SQL Server 2008 Database Administration Video Tutorial: How t o Configure SQL Server: Security Settings and Connection Options

How to Configure SQL Server: Security Settings and Connection Options - view details
In this video, we will take a look at the security settings and connection options that you can configure for SQL Server 2008.

Highlights from this video:
  • About the security settings that can be changed
    • Authentication mode
    • Logon auditing
    • Server Proxy account
    • Common Criteria Compliance
    • C2 audit tracing
  • Configuring connection options
    • Concurrent connections
    • Query Governor
  • Common connection options
    • ansi nulls
    • no count
    • quoted identifier
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: connection, security, configure, configuration, authentication, audit, sql, server, 2008

posted by Scott Whigham @ 5:53 AM  

New SQL Server 2008 Database Administration Video Tutorial: How t o Configure SQL Server: Configuring SQL Server CPU Usage

How to Configure SQL Server: Configuring SQL Server CPU Usage - view details
In this video tutorial we will continue by taking a basic look at the CPU usage configurations for SQL Server 2008.

Highlights from this video:
  • About the CPU settings that can be changed
    • Enable/disable processors
    • Affinity mask options
    • Maximum worker threads
    • Boost SQL Server priority
  • "Cost" as a metric of time
  • Configuring how SQL Server handles parallel queries
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 subsc ription is required.

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

Keywords Associated with this video: cpu, sql, server, configuration, configuring, processor,

posted by Scott Whigham @ 5:53 AM  

New SQL Server 2008 Database Administration Video Tutorial: How t o Configure SQL Server: Configuring SQL Server Memory Usage

How to Configure SQL Server: Configuring SQL Server Memory Usage - view details
We will now take a look at memory usage in SQL Server 2008, one of the most obivious places you'll want to tweak when configuring your SQL Server.

Highlights from this video:
  • Where is memory primarily used?
    • Buffer cache
    • Procedure cache
  • Sizing the buffer cache and procedure cache
  • Memory options you can change
    • Maximum server memory
    • Minimum server memory
    • Address Windowing Extensions (AWE)
    • Minimum memory per query
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 re quired.

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

Keywords Associated with this video: sql, server, memory, buffer cache, procedure cache,

posted by Scott Whigham @ 5:52 AM  

New SQL Server 2008 Database Administration Video Tutorial: How t o Configure SQL Server: More on Network Protocols and Aliases

How to Configure SQL Server: More on Network Protocols and Aliases - view details
This video will provide you with a great demo of the Sql Server Configuration Manager, as well as things you may not have figured out on your own about the Configuration Manager��or may not have seen in regards to network protocols and aliases.

Highlights from this video:
  • About the��SQL Native Client
    • Shared memory
    • TCP/IP
    • Named pipes
  • What is an Alias?
    • Creating a new alias
  • Changing TCP/IP Ports
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: configuration manager, configure, alias, network protocol, tcp, port

posted by Scott Whigham @ 5:52 AM  

New SQL Server 2008 Database Administration Video Tutorial: How t o Configure SQL Server: Service Accounts and Network Protocols

How to Configure SQL Server: Service Accounts and Network Protocols - view details
We will talk now about configuring your SQL Server 2008 server, but specifically about service accounts and network protocols.

Highlights from this video:
  • About instance-level configurations
  • Service accounts and making changes to service accounts
  • About network protocols
    • Shared memory
    • Enabling remote connections
    • TCP/IP
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: service accounts, network protocols, configure, configuration, sql, server,, introduction, step by step, beginner, beginning, fo

posted by Scott Whigham @ 5:52 AM  

New SQL Server 2008 Database Administration Video Tutorial: An In troduction to SQL Server Configuration Manager, Visual Studio and Books On line

An Introduction to SQL Server Configuration Manager, Visual Studio and Books Online - view details
In this video, the author will introduce you to the Configuration Manager, Visual Studio and Books Online

Highlights from this video:
  • Visual Studio 2008 and SQL Server (Business Intelligence Development Studio (BIDS)
    • Demo of how a developer would use this tool to create reports
  • About Books Online
    • Navigating
    • Updating
  • Introduction to the SQL Server Configuration Manager
    • Functionalities of Configuration Manager
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 re quired.

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

Keywords Associated with this video: sql server, configuration manager, visual studio, books online, i, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:52 AM  

New SQL Server 2008 Database Administration Video Tutorial: An In troduction to Using SQL Server Management Studio - Part 3

An Introduction to Using SQL Server Management Studio - Part 3 - view details
Continuing the demonstration of the tools in SSMS, this video will present you with some of the new tips and tricks in SQL Server 2008 Management Studio.

Highlights from this video:
  • Writing queries via:
    • ��Drag and drop
    • Intellisense
  • Designing Views
  • Scripting Views syntax
  • Additional features
    • Line commenting
    • Executing specific lines
    • Chords
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 m ust have the TSCC codec installed to view this video

Keywords Associated with this video: sql server, management studio, ssms, tools, features, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:51 AM  

New SQL Server 2008 Database Administration Video Tutorial: An In troduction to Using SQL Server Management Studio - Part 2

An Introduction to Using SQL Server Management Studio - Part 2 - view details
In this video, we will continue our introductory tour of the SQL Server Management Studio (SSMS) tools by discussing some of the various customization options that are available to you.

Highlights from this video:
  • Customizing the SSMS environment
    • General
    • Fonts and colors
    • Keyboard shortcuts
  • Configuring your Text Editor
    • Statement completion (Intellisense)
  • Customizing your Query Results
    • Results to grid
    • Results to text
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.

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

Keywords Associated with this video: ssms, sql server ,management studio, customize, customizing, option, introduction, step by step, beginner, beginning, for dummie

posted by Scott Whigham @ 5:51 AM  

New SQL Server 2008 Database Administration Video Tutorial: An In troduction to Using SQL Server Management Studio - Part 1

An Introduction to Using SQL Server Management Studio - Part 1 - view details
In this video will begin our tour of the SQL Server Management Studio, something that you'll be using often and has many new improvements in SQL Server 2008.

Highlights from this video:
  • Launching SSMS
  • Exploring SSMS
    • How to browse for and connect to a server
      • Conenction properties
  • About the SSMS interface
    • Object Explorer
    • Query pane
    • Object Explorer Details
    • Registered Servers
    • Properties Window
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: SSMS, sql server, management studio, intro, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:51 AM  

New SQL Server 2008 Database Administration Video Tutorial: An Ov erview of the Tools Installed in SQL Server 2008

An Overview of the Tools Installed in SQL Server 2008 - view details
In our previous chapter we took a look at installing and upgrading to SQL Server 2008. In this chapter, we will take a look at what was installed, an overview of the tools, and an overview of configuring the server. In this video, we will begin by examining the tools that were installed with SQL Server 2008

Highlights from this video:
  • Tools are available for:
    • Administrators
    • Developers
    • Command line only
    • GUI (Graphical User Interface)
    • API (Application Programming Interface)
  • Command line tools that target DBAs
    • Tools and descriptions
  • About the GUI tools
    • SSMS
    • BIDS
    • Visual Studio 2008
    • SQL Server Configuration Manager
  • APIs for developers
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 s ubscription is required.

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

Keywords Associated with this video: install, sql ,server, 2008, overview, tools, features,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:50 AM  

New SQL Server 2008 Database Administration Video Tutorial: Under standing What Happens When You Install Multiple Instances

Understanding What Happens When You Install Multiple Instances - view details
After the installation of the second instance of SQL Server 2008 has completed, we will begin by viewing the services that are installed and compare the different instances of SQL Server 2008. The author will also divulge some of the reasoning behind installing multiple instances.

Highlights from this video:

  • Viewing instances installed at the service level
    • Default and Named
  • Instance dependent and instance independent services
  • Comparing default instance and named instance
  • Why would I want to use multiple instances?
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, 2008, install, installation, instance, named,introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:42 AM  

New SQL Server 2008 Database Administration Video Tutorial: Insta lling a Named Instance

Installing a Named Instance - view details
Have you ever wondered what people are referring to when they talk about various instances of SQL? What is an instance? An instance is simply an installation of SQL Server. This video will begin by picking up after your installation of SQL Server 2008 has successfully completed and will discuss instances and demonstrate how to install a named instance.

Highlights from this video:
  • Determining your instance
  • What is a default instance?
  • Working with the Management Studio
  • How to install a named instance for SQL Server
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.< br />

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

Keywords Associated with this video: install, installing, installation, sql, 2008, instance, named, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:42 AM  

New SQL Server 2008 Database Administration Video Tutorial: Prici ng and How Licensing Works in SQL Server 2008 - Part 1

Pricing and How Licensing Works in SQL Server 2008 - Part 1 - view details
This video tutorial will walk you through the two different methods to license your version of SQL Server: CPU or CAL.The author will detail several scenarios that can be used in comparing what license to use. Also, included with the download of the video is the author's presentation in .PDF format.

Highlights from this video:
  • CAL Licensing Model
    • Two Client Access Licenses:
      • CAL for a user
      • CAL for a device
    • User model or Device model?
      • Situational explantions and scenarios
  • CPU Licensing Model
    • Physcial CPU license
  • How MSFT determines license usage
    • Scenarios and possible answers
  • CPU or CAL?
    • What is the switching point?
    • Cost effectiveness
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 i s required.

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

Keywords Associated with this video: license, CAL, CPU, client access license, user CAL, device CAL, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: What' s New in SQL Server 2008 - Part 1

What's New in SQL Server 2008 - Part 1 - view details
We will be taking a look at some of the new features and enhancements in SQL Server 2008, as handpicked by the author. The detailed features in this video series are not comprehensive. Keep in mind that some of the new features may only target 5% of users, but many are simply "better ways" . In this introductory��discussion of the features, the author will discuss how they relate to your job as a SQL Server DBA. This video won't introduce any new features, but rather discuss how SQL Server 2008 has changed the DBA workforce.

Highlights from this video:
  • Why upgrade to SQL 2008?
    • Customer support
    • Scalability
    • New features
  • SQL Server DBA's : specialization on components
    • Segmenting the "talent"
    • SQL 2008 = hard to be a specialist?

��

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, 2008, dba, database administrator, job, role, upgrade, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: What' s New in SQL Server 2008 - Part 2

What's New in SQL Server 2008 - Part 2 - view details
This video will begin by covering many of the new features and enhancements��in SQL Server 2008 in the performance, security, management, and availability areas for DBAs.

Highlights from this video:
  • Performance Improvements:
    • Compression enhancements
      • Backup compression
      • Log Stream compression
      • Data compression
    • Database enhancements
      • Improved "Plan Guide" support
      • Resource Governor
      • Performance Data Collection
      • Partitioned Table Parallelism and Partion-aligned Index Views (larger databases)
  • Security Improvements
    • Transparent Data Encryption
    • Extensible Key Management (EKM)
    • New database roles and renaming
  • Management Improvements
    • Policy-based Management
    • SQL Server Audit
    • Change Data Capture (CDC)
    • Data Profiling Task
    • Extended Events (xEvents)
    • Enhancements to Central Management Servers and Server Groups
  • Availability Improvements
    • Enhanced database mirroring
    • Suspect page recovery
    • Peer-to-peer replication
    • Hot pluggable CPUs
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: dba, enhancement, improvement, upgrade, new, feature, sql, 2008, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Prici ng and How Licensing Works in SQL Server 2008 - Part 2

Pricing and How Licensing Works in SQL Server 2008 - Part 2 - view details
This second video will continue by starting off our discussion by covering the licensing process of a virutal environment and finish by covering the respective costs of the various licenses.

Highlights from this video:
  • Licensing and VMware
  • Retail costs of CPU and CAL licenses for:
    • Enterprise license
    • Workgroup license
    • Web licence
    • Standard license
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: license, price, cost, cpu, cal, enterprise, workgroup, web, standard, introduction, step by step, beginner, beginning, for dummi

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: The E ditions of SQL Server, Part 2

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 Edition
    • Workgroup Edition
      • Who would use this edition?
    • Web Edition
      • Low TCO (Total Cost of Ownership)
    • Express Edition
      • Three versions:
        • SQL Server Express
        • SQL Server Express with Tools
        • SQL Server Express with Advanced Services
  • Comparison of Specialized 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: edition, specialized, developer, workgroup, web, express, editions, sql, 2008, , introduction, step by step, beginner, beginning

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: The H istory of SQL Server

The History of SQL Server - view details
This video will provide an in-depth background��of Microsoft's database server, SQL Server. The discussion starts with the original licensing deal and marketing strategies in 1989 and will follow all the way through what Microsoft might be doing for their future releases of SQL Server.

Highlights from this video:
  • The 1980's
    • Microsoft, Sybase, and Ashton-Tate
      • Ashton-Tate/Microsoft SQL Server 1.0
      • What was it based off of?
  • The 1990's
    • Microsoft SQL Server 1.1 release and 4.2 release
    • SQL95 and SQL Server 6.5
    • SQL Server 7.0
      • Microsoft rewrites code
      • Feature debuts
  • The Millenium
    • SQL Server 2000
    • SQL Server 2005
      • Works with Windows Server 2003
      • Many new features
    • SQL Server 2008
      • Windows Server 2008
      • Enhancements
    • SQL Server .NEXT?
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: history, overview, sql server,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: The E ditions of SQL Server, Part 1

The Editions of SQL Server, Part 1 - view details
This video tutorial will break down the two Server Editions of SQL Server 2008: the Enterprise Edition and the Standard Edition. Your instructor will provide you with an overview of the characteristics of the two versions as well as give you an idea of who would typically use them. Also included with your download is a .PDF file of the author's presentation.

Highlights from this video:
  • What is a Server edition? Specialized edition?
  • Processor architecture
    • x86
    • x64
    • IA64
  • Brief overview of the SQL Server 2008 Compact Edition
    • Previous names
    • What kind of devices to run it on
  • Server editions
    • Who uses them?
    • Enterprise Edition
    • Standard Edition
    • Comparing the Server 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: edition, sql, server, standard, enterprise, 2008, editions, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Depre cated and Discontinued Items in SQL Server 2008

Deprecated and Discontinued Items in SQL Server 2008 - view details
In this essential video tutorial, Scott Whigham will provide you with an overview of some of the items that have been deprecated and discontinued��in SQL Server 2008. The most widely used and most popular deprecated and discontined items are listed and discussed. Also,��a .PDF file of Scott Whigham's presentation is included with your download!

Highlights from this video:

  • Defining "deprecated"
    • Items that may not work in the future
  • Defining "discontinued"
    • Items that won't work right now
  • Most popular discontinued items and thier replacements
  • Widely used deprecated items and thier replacements
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: deprecated, discontinued, sql 2008, out of service,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 AM  

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 @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Servi ce Packs, Hotfixes, and More: Keeping Your SQL Server 2008 Up to Date

Service Packs, Hotfixes, and More: Keeping Your SQL Server 2008 Up to Date - view details
Like all software, your SQL Server needs to be updated. In this video tutorial, your author will discuss service packs, hotfixes and more methods to keep SQL Server 2008 up-to-date.

Highlights from this video:
  • What features will need updating?
  • SQL Incremental Service Model (ISM)
    • Critical-on-Demand hotfixes (COD)
    • On-Demand hotfixes (OD)
    • Cumulative Update (CU)
    • General Distribution Release (GDR)
  • Identifying what service pack or hotfix you have installed
    • Product level
    • Build number
      • Determing your build number
    • File version
  • How do I get the service pack/hotfix?
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: service pack, update, hotfix, sql, server, updating, service, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:34 AM  

New SQL Server 2008 Database Administration Video Tutorial: Upgra de SQL Server 2000 DTS Packages

Upgrade SQL Server 2000 DTS Packages - view details
One thing you need to be very aware of is the difficulty of migrating your SQL Server 2000 DTS packages to SQL Server 2008. In this section, the author will discuss the processes of upgrading your SQL Server 2000 DTS packages from a DBA's standpoint.

Highlights from this video:
  • The shift to SSIS and from DTS
    • Comparison and analogy
    • Rewriting and rearchitecturing for SSIS
  • In-place upgrade components for 2008
    • Microsoft SQL Server Backward Compatibility
    • SQL Server 2000 DTS Designer
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: upgrade, upgrading, sql, server, 2000, dts, ssis, migrate, migrating,, introduction, step by step, beginner, beginning, for dumm

posted by Scott Whigham @ 5:32 AM  

New SQL Server 2008 Database Administration Video Tutorial: How t o Upgrade from SQL Server 2000 or 2005 to SQL Server 2008

How to Upgrade from SQL Server 2000 or 2005 to SQL Server 2008 - view details
This video tutorial will be a comprehensive demonstration of an actual of upgrade to SQL Server 2008 from an earlier version of SQL Server.
������
Highlights from this video:
  • Installing the prerequisites
  • Navigating the SQL Server Installation Center
    • Upgrading
  • Choosing the instance to upgrade
  • Full-text upgrade options
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: upgrade, 2000, 2005, 2008, sql, server, upgrading,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:32 AM  

New SQL Server 2008 Database Administration Video Tutorial: What To Do After Your Upgrade Is Complete

What To Do After Your Upgrade Is Complete - view details
Life is good, right? You've completed the upgrade to SQL Server 2008, but you're ubfortunately not done yet. Once you've done the uprgade, there's a few things you'll want to check and make sure are correct. In this video, your author will cover the obvious and not-so-obvious things you'll need to do.

Highlights from this video:
  • Obvious things to test
    • DTS packages
    • SQL jobs
    • Applications
  • Things the Upgrade Advisor didn't warn you about
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: upgrade, sql, 2008, install, installation, upgrading, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:32 AM  

New SQL Server 2008 Database Administration Video Tutorial: Runni ng the SQL Server 2008 Upgrade Advisor

Running the SQL Server 2008 Upgrade Advisor - view details
This video will be a cross between demos and lecture focused on working with the SQL Server Upgrade Advisor.

Highlights from this video:
  • About the SQL Server Upgrade Advisor
  • How to install the upgrade advisor
  • Working with the Upgrade Advisor Analysis Wizard
    • Launching the Upgrade Advisor Report Viewer
  • Working in the Upgrade Advisor
    • Choosing components to analyze
    • Entering parameters for analysis
      • Profiler and trace files
    • SSIS Parameters
  • Navigating your analysis report
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: upgrade, advisor, sql server, 2008, report, analysis wizard, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:31 AM  

New SQL Server 2008 Database Administration Video Tutorial: Upgra ding to SQL Server 2008: What Can Be Upgraded?

Upgrading to SQL Server 2008: What Can Be Upgraded? - view details
Are you looking to upgrade to SQL Server 2008 from a SQL Server 2005 or 2000 instance? In this video tutorial, your author will discuss what you need to do before you upgrade to SQL Server 2008.

Highlights from this video:
  • Upgrade support
    • 64-bit
    • 32-bit
  • What can I upgrade from?
    • Prior versions
    • Lower editions
  • Difficult upgrades and simple upgrades
  • Things that will prevent your upgrade
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: upgrade, sql, 2008, 2000, 2005, edition, version, upgrading, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:31 AM  

New SQL Server 2008 Database Administration Video Tutorial: An Ov erview of What's Installed: Tools

An Overview of What's Installed: Tools - view details
In this video tutorial, Scott Whigham will give you a brief tour of some of the tools that have been installed with SQL Server 2008.

Highlights from this video:
  • About Windows PowerShell
  • What will Microsoft Visual Studio do for my server?
  • Performance tools: SQL Server Profiler
  • Integration Services
  • Configuration Tools: SQL Server Configuration Manager
  • About SQL Server Management Studio (SSMS)
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 ,2008, install, walkthrough, demo, tour, tools, tool, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:31 AM  

New SQL Server 2008 Database Administration Video Tutorial: An Ov erview of What's Installed: Tools

An Overview of What's Installed: Tools - view details
In this video tutorial, Scott Whigham will give you a brief tour of some of the tools that have been installed with SQL Server 2008.

Highlights from this video:
  • About Windows PowerShell
  • What will Microsoft Visual Studio do for my server?
  • Performance tools: SQL Server Profiler
  • Integration Services
  • Configuration Tools: SQL Server Configuration Manager
  • About SQL Server Management Studio (SSMS)
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 ,2008, install, walkthrough, demo, tour, tools, tool, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:31 AM  

New SQL Server 2008 Database Administration Video Tutorial: Lectu re on What Are Instances and When Are They Appropriate

Lecture on What Are Instances and When Are They Appropriate - view details
This video will take a formal look at SQL Server instances. In this video the author will discuss when to use instances, what purpose they serve, and clear up some licensing questions about them. The author's presentation is included with your download.

Highlights from this video:
  • What is an instance?
    • Default instance
    • Named instances
  • Common instance setup
  • What are single instances appropriate for?
  • When to use multiple instances
    • Mixed versions
    • Mixed editions
    • Mixed releases
  • Named instance rules
  • Instance licensing in 2008 compared to 2005
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: instance, install, named, default, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:30 AM  

New SQL Server 2008 Database Administration Video Tutorial: Under standing What Happens When You Install Multiple Instances

Understanding What Happens When You Install Multiple Instances - view details
Now that we have two instances of SQL Server 2008 running on our machine, we can discuss how things are laid out on the system and how you can quickly identifiy how many instances of SQL Server are running on a machine.

Highlights from this video:
  • Determining your instance based off the featurse
  • Comparing default instances with named instances
  • Why would I want to use multiple instance?
  • Services Features
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: install, installing, installation, sql, 2008, instance, single, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:30 AM  

New SQL Server 2008 Database Administration Video Tutorial: Lectu re on What Are Instances and When Are They Appropriate

Lecture on What Are Instances and When Are They Appropriate - view details
This video will take a formal look at SQL Server instances. In this video the author will discuss when to use instances, what purpose they serve, and clear up some licensing questions about them. The author's presentation is included with your download.

Highlights from this video:
  • What is an instance?
    • Default instance
    • Named instances
  • Common instance setup
  • What are single instances appropriate for?
  • When to use multiple instances
    • Mixed versions
    • Mixed editions
    • Mixed releases
  • Named instance rules
  • Instance licensing in 2008 compared to 2005
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: instance, install, named, default, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:27 AM  

New SQL Server 2008 Database Administration Video Tutorial: Insta lling SQL Server 2008 Default Instance - Part 2

Installing SQL Server 2008 Default Instance - Part 2 - view details
In this second video, we will finish working through the��setup of SQL Server 2008 by discussing the server configuration and database engine configuration and end by running the installation.

Highlights from this video:
  • Creating new service accounts
  • Customizing the SQL Server Database Engine collation
    • Account provisioning and authentication modes
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 re quired.

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

Keywords Associated with this video: install, sql, server, 2008, installing, installation, prereq, instance,, introduction, step by step, beginner, beginning, for du

posted by Scott Whigham @ 5:25 AM  

New SQL Server 2008 Database Administration Video Tutorial: Insta lling SQL Server 2008 Default Instance - Part 1

Installing SQL Server 2008 Default Instance - Part 1 - view details
After covering and discussing all of the prep work, we're finally ready to begin installing SQL Server 2008. This first video tutorial will begin by running the setup program from the disk and work all the way up to the selection of features to install for SQL and briefly covering the instance configuration.

Highlights from this video:
  • Before we begin:
    • Installing .NET Framework 3.5
  • Navigating the SQL Server Installation Center
    • Creating a new SQL Server Stand-alone
  • Installing setup support files
  • SQL Server 2008 Feature Selection
    • Common features to install
    • Basic management features vs complete management features
  • Choosing your instance configuration
    • What is the Instance ID?
  • 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 subscriptio n is required.

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

Keywords Associated with this video: install, sql, 2008, default, installation, installing, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:24 AM  

New SQL Server 2008 Database Administration Video Tutorial: Thing s You Have to Know Before You Install SQL Server - Part 4

Things You Have to Know Before You Install SQL Server - Part 4 - view details
In our last lecture video on the things you need to know before we begin the install of SQL Server 2008, we will cover typical locations for your essential SQL Server files as well as discuss what type of server collation will work for you.

Highlights from this video:
  • Where to put the files and default locations
    • Program files
    • Database and log files
    • Backups
  • What server collation should you use?
    • Default server collation
    • What does collation define?
    • Two types of collations
      • Windows Collation
      • SQL Server Collation

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, install, 2008, prereqs, server collation, windows collation, sql collation, location, introduction, step by step, beginner,

posted by Scott Whigham @ 5:24 AM  

New SQL Server 2008 Database Administration Video Tutorial: Thing s You Have to Know Before You Install SQL Server - Part 3

Things You Have to Know Before You Install SQL Server - Part 3 - view details
We will continue our discussion on what you need to know before you install SQL Server 2008 by covering the topic of security models, account provisioning, and we'll wrap up with a brief discussion on��some of the best practices for SQL security.

Highlights from this video:
  • Two security model choices:
    • Windows Authentication
      • Example of when to use
      • Pros and cons
    • Mixed mode
      • Example of when to use
      • Pros and cons
  • Account provisioning
    • What domain accounts do you want them to run under?
  • Best practices and suggestions for security at the service level
    • Principle of least privilege
    • Seperate accounts and instancing
  • About the SQL Server Database Engine
    • Domain account
    • Assigning additional permissions
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: install, sql, 2008, prereq, security, windows authentication, mixed mode, account provisioning, database engine, introduction, s

posted by Scott Whigham @ 5:24 AM  

New SQL Server 2008 Database Administration Video Tutorial: Thing s You Have to Know Before You Install SQL Server - Part 2

Things You Have to Know Before You Install SQL Server - Part 2 - view details
In this second video tutorial, you will begin��by exploring the various hardware and software��requirements for your install of SQL Server 2008. Your instructor will disucss the software/hardware needs for a small-medium sized database in comparison to the hardware/software needs of the larger databases. Included with your download is the instructor's presentation as a .PDF file.

Highlights from this video:
  • Defining a small, medium, and large database
    • Sizes in GB
  • RAID sets and SANs for small through large databases
    • Common RAID placements on small databases
  • 32-bit or 64-bit?
    • Advantages of 64-bit
      • Linear scalability
      • TCO
  • Determining which machine(s) need to run the install program
    • Server and/or workstation?
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: install, sql, 2008, prereq, database, db, RAID, 32 bit , 64 bit,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:24 AM  

New SQL Server 2008 Database Administration Video Tutorial: Thing s You Have to Know Before You Install SQL Server - Part 1

Things You Have to Know Before You Install SQL Server - Part 1 - view details
In this video, your instructor will go over a lot of different decisions you need to make as well as things you need to know before you install SQL Server 2008. There's a lot of prep work that is needed before the actual install, and in this video tutorial your instructor will cover just that. This video begins by discussing two questions that will help you determine what to do for your install of SQL Server 2008: "What type of server?" and "What is the role of the server?".

Highlights from this video:
  • What type of server are you installing?
    • How to determine what server you're working with
  • What is the main role of your particular server?
    • SSRS?
    • Domain controller?
    • SharePoint? etc
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: Y ou must have the TSCC codec installed to view this video

Keywords Associated with this video: install, sql, server, 2008, role, db,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 5:24 AM  

New SQL Server 2008 Database Administration Video Tutorial: 10 - Deprecated and Discontinued Items in SQL Server 2008

10 - Deprecated and Discontinued Items in SQL Server 2008 - view details
In this essential video tutorial, Scott Whigham will provide you with an overview of some of the items that have been deprecated and discontinued��in SQL Server 2008. The most widely used and most popular deprecated and discontined items are listed and discussed. Also,��a .PDF file of Scott Whigham's presentation is included with your download!

Highlights from this video:

  • Defining "deprecated"
    • Items that may not work in the future
  • Defining "discontinued"
    • Items that won't work right now
  • Most popular discontinued items and thier replacements
  • Widely used deprecated items and thier replacements
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: deprecated, discontinued, sql 2008, out of service,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:45 AM  

New SQL Server 2008 Database Administration Video Tutorial: 9 - W hat's New in SQL Server 2008, Part 4

9 - What's New in SQL Server 2008, Part 4 - view details
We will finish our discussion on the new features and enhancements to SQL Server 2008 by discussing what's new in the Business Intelligence side (SSIS, SSRS, SSAS)��

Highlights from this video:
  • SSIS Enhancements
    • C#
    • VSTA (Visual Studio Tools for Applications)
    • Improved threading and pipeline scalability
    • Less limitations on lookups
  • Reporting Services Improvements
    • IIS requirements
    • Better caching and memory management
    • Tablix data regions
    • Reports in Microsoft Word
  • Analysis Services
    • Star JOINs
    • MERGE statement
    • Various enhancements
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: ssis, ssrs, ssas, enhancement, improvement, sql 2008, feature, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:44 AM  

New SQL Server 2008 Database Administration Video Tutorial: 8 - W hat's New in SQL Server 2008, Part 3

8 - What's New in SQL Server 2008, Part 3 - view details
In this video we will discuss some of the new features and enhancements for Developers in SQL Server 2008.

Highlights from this video:
  • T-SQL Developments
    • Intellisense
    • Table-valued parameters
    • Compound operators
    • Declaration and assignment in a single statement
    • XML enhancements
    • FILESTREAM
  • New datatypes and accuracy
    • DATE, TIME, DATETIME2, and DATETIMEOFFSET
    • HierarchyId
  • Geospatial datatypes and when to use:
    • GEOMETRY
    • GEOGRAPHY
  • Debugging
    • T-SQL Debugging in SSMS
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: tsql, datatype, geospatial, debug, geometry, geography, intellisense, filestream, introduction, step by step, beginner, beginnin

posted by Scott Whigham @ 4:44 AM  

New SQL Server 2008 Database Administration Video Tutorial: 7 - W hat's New in SQL Server 2008, Part 2

7 - What's New in SQL Server 2008, Part 2 - view details
This video will begin by covering many of the new features and enhancements��in SQL Server 2008 in the performance, security, management, and availability areas for DBAs.

Highlights from this video:
  • Performance Improvements:
    • Compression enhancements
      • Backup compression
      • Log Stream compression
      • Data compression
    • Database enhancements
      • Improved "Plan Guide" support
      • Resource Governor
      • Performance Data Collection
      • Partitioned Table Parallelism and Partion-aligned Index Views (larger databases)
  • Security Improvements
    • Transparent Data Encryption
    • Extensible Key Management (EKM)
    • New database roles and renaming
  • Management Improvements
    • Policy-based Management
    • SQL Server Audit
    • Change Data Capture (CDC)
    • Data Profiling Task
    • Extended Events (xEvents)
    • Enhancements to Central Management Servers and Server Groups
  • Availability Improvements
    • Enhanced database mirroring
    • Suspect page recovery
    • Peer-to-peer replication
    • Hot pluggable CPUs
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: dba, enhancement, improvement, upgrade, new, feature, sql, 2008, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:44 AM  

New SQL Server 2008 Database Administration Video Tutorial: 6 - W hat's New in SQL Server 2008, Part 1

6 - What's New in SQL Server 2008, Part 1 - view details
We will be taking a look at some of the new features and enhancements in SQL Server 2008, as handpicked by the author. The detailed features in this video series are not comprehensive. Keep in mind that some of the new features may only target 5% of users, but many are simply "better ways" . In this introductory��discussion of the features, the author will discuss how they relate to your job as a SQL Server DBA. This video won't introduce any new features, but rather discuss how SQL Server 2008 has changed the DBA workforce.

Highlights from this video:
  • Why upgrade to SQL 2008?
    • Customer support
    • Scalability
    • New features
  • SQL Server DBA's : specialization on components
    • Segmenting the "talent"
    • SQL 2008 = hard to be a specialist?

��

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, 2008, dba, database administrator, job, role, upgrade, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:43 AM  

New SQL Server 2008 Database Administration Video Tutorial: 5 - P ricing and How Licensing Works in SQL Server 2008, Pt. 2

5 - Pricing and How Licensing Works in SQL Server 2008, Pt. 2 - view details
This second video will continue by starting off our discussion by covering the licensing process of a virutal environment and finish by covering the respective costs of the various licenses.

Highlights from this video:
  • Licensing and VMware
  • Retail costs of CPU and CAL licenses for:
    • Enterprise license
    • Workgroup license
    • Web licence
    • Standard license
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: license, price, cost, cpu, cal, enterprise, workgroup, web, standard, introduction, step by step, beginner, beginning, for dummi

posted by Scott Whigham @ 4:43 AM  

New SQL Server 2008 Database Administration Video Tutorial: 4 - P ricing and How Licensing Works in SQL Server 2008, Pt. 1

4 - Pricing and How Licensing Works in SQL Server 2008, Pt. 1 - view details
This video tutorial will walk you through the two different methods to license your version of SQL Server: CPU or CAL.The author will detail several scenarios that can be used in comparing what license to use. Also, included with the download of the video is the author's presentation in .PDF format.

Highlights from this video:
  • CAL Licensing Model
    • Two Client Access Licenses:
      • CAL for a user
      • CAL for a device
    • User model or Device model?
      • Situational explantions and scenarios
  • CPU Licensing Model
    • Physcial CPU license
  • How MSFT determines license usage
    • Scenarios and possible answers
  • CPU or CAL?
    • What is the switching point?
    • Cost effectiveness
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 i s required.

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

Keywords Associated with this video: license, CAL, CPU, client access license, user CAL, device CAL, , introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:43 AM  

New SQL Server 2008 Database Administration Video Tutorial: 3 - T he Editions of SQL Server, Part 2

3 - 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 Edition
    • Workgroup Edition
      • Who would use this edition?
    • Web Edition
      • Low TCO (Total Cost of Ownership)
    • Express Edition
      • Three versions:
        • SQL Server Express
        • SQL Server Express with Tools
        • SQL Server Express with Advanced Services
  • Comparison of Specialized 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: edition, specialized, developer, workgroup, web, express, editions, sql, 2008, , introduction, step by step, beginner, beginning

posted by Scott Whigham @ 4:42 AM  

New SQL Server 2008 Database Administration Video Tutorial: 2 - T he Editions of SQL Server, Part 1

2 - The Editions of SQL Server, Part 1 - view details
This video tutorial will break down the two Server Editions of SQL Server 2008: the Enterprise Edition and the Standard Edition. Your instructor will provide you with an overview of the characteristics of the two versions as well as give you an idea of who would typically use them. Also included with your download is a .PDF file of the author's presentation.

Highlights from this video:
  • What is a Server edition? Specialized edition?
  • Processor architecture
    • x86
    • x64
    • IA64
  • Brief overview of the SQL Server 2008 Compact Edition
    • Previous names
    • What kind of devices to run it on
  • Server editions
    • Who uses them?
    • Enterprise Edition
    • Standard Edition
    • Comparing the Server 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: edition, sql, server, standard, enterprise, 2008, editions, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:42 AM  

New SQL Server 2008 Database Administration Video Tutorial: 1 - T he History of SQL Server

1 - The History of SQL Server - view details
This video will provide an in-depth background��of Microsoft's database server, SQL Server. The discussion starts with the original licensing deal and marketing strategies in 1989 and will follow all the way through what Microsoft might be doing for their future releases of SQL Server.

Highlights from this video:
  • The 1980's
    • Microsoft, Sybase, and Ashton-Tate
      • Ashton-Tate/Microsoft SQL Server 1.0
      • What was it based off of?
  • The 1990's
    • Microsoft SQL Server 1.1 release and 4.2 release
    • SQL95 and SQL Server 6.5
    • SQL Server 7.0
      • Microsoft rewrites code
      • Feature debuts
  • The Millenium
    • SQL Server 2000
    • SQL Server 2005
      • Works with Windows Server 2003
      • Many new features
    • SQL Server 2008
      • Windows Server 2008
      • Enhancements
    • SQL Server .NEXT?
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: history, overview, sql server,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:42 AM