Skip to main content
SQL Server
Sign in
United States (English)
Home 2012 2008 R2 2008 Previous Versions Library Forums

SQL Server "How Do I?" Videos

Watch short videos that show you how to complete specific tasks in SQL Server.

 

 

This video presents the fundamental concepts for relational tables and using the normalization design process to minimize structural problems with the tables you design in relational databases. </br> The presentation first covers the fundamental concepts of tables including columns, rows, domains and the categories of table keys (candidate, primary, and foreign keys). The presentation then introduces the normalization design process, and walks you through an exercise showing how the normalization rules are applied for the 1st, 2nd, 3rd, and 4th normal forms.

Introduction to DB Design
(58:44)

In this video, I am going to demonstrate how we can leverege the Microsoft Connector for Oracle by Attunity to increase package performance when bulk loading data from an Oracle source to a Flat File Destination.

Leverage Microsoft Attunity Connector for Oracle to enhance Package Performance
(05:09)

Learn how to use this powerful new task in SQL Server 2008 to become familiar with an unfamiliar database, or to look for problems in existing data. Take a quick look at all eight of the profiles that the task can compute.

How to: Use the Data Profiling Task (SQL Server Video)?
(10:24)

 

This video demonstrates how to use the SQL Server Import and Export Wizard to create a package that exports data from a SQL Server database to a Microsoft Excel spreadsheet.

Exporting SQL Server Data to Excel (SQL Server Video)
(08:13)

This video demonstrates how to configure Snapshot Replication between two instances of SQL Server 2008.

How Do I: Setup Snapshot Replication with SQL Server 2008?
(10:43)

Learn how to call a Web service successfully from an Integration Services package by configuring an HTTP connection manager and the Web Service task. Then, set up an XML task to read the information that you have retrieved, and use that information in the package.

How to: Call a Web Service by Using the Web Service Task (SQL Server Video)?
(11:10)

 

The Create Utility Control Point Wizard will help you to create a UCP on an instance of SQL Server to manage your SQL Server Utility.

How Do I: Create a Utility Control Point (UCP)?
(04:11)

In this video Scott Golightly shows how to install the synchronization framework and then how to use it in conjunction with SQL Server 2008 change tracking to update remote, occasionally connected databases.

Synchronizing Remote SQL Server Databases with the Sync Framework
(18:54)

Database Mail is useful for sending e-mail to administrators and end users. Database mail can contain data from queries or from files or other resources on your network. In this video Scott Golightly shows how to configure Database Mail in SQL Server 2008. After setting up Database Mail we see how to test the mail and view the mail log.

How Do I: Configure Database Mail in SQL Server 2008
(08:35)

 

In this video, Max Adams will present 10 tips toward optimizing Data Warehouses or DataMarts build on Microsoft's SQL Server 2008 platform.

How Do I: Optimize Data Warehousing with Microsoft SQL Server 2008?
(12:27)

Data quality is important to every business. Using the SQL Server 2008 Data Profiling task computes statistics about the data in a database to spot incorrect values. The Data Profiling viewer allows you to view the generated statistics. In this video Scott Golightly shows how to create the data profile and how to review the results.

How Do I: Profile Data with the Data Profiling Task and Viewer?
(14:14)

In this video Scott Golightly shows us how to create database maintenance plans using the Maintenance Plan wizard and SQL Server Integration Services (SSIS). Scott also shows how to customize plans that were created with the wizard.

Setting up a Maintenance Plan to Backup Databases
(14:29)

 

More Videos

  • Analysis Services
  • Data Mining
  • Data Quality Services
  • Integration Services
  • Master Data Services
  • PowerPivot
  • Report Builder
  • Reporting Services

© 2013 Microsoft
  • Manage Your Profile
  • Newsletter
  • Contact Us
  • Privacy Statement
  • Terms of Use
  • Trademarks
  • | Site Feedback
  • TechNet
  • Products
  • IT Resources
  • Downloads
  • Training
  • Support
Products
  • Windows
  • Windows
    Server
  • System
    Center
  • Internet
    Explorer
 
  • Office
  • Office 365
  • Exchange
    Server
 
  • SQL Server
  • SharePoint
    Products
  • Lync
  • See all products »
Resources
  • Evaluation Center
  • Learning Resources
  • Microsoft IT Camps
  • Microsoft Technical Communities
  • Microsoft Virtual Academy
  • Script Center
  • Server and Tools Blogs
  • Solution Accelerators
  • TechNet Blogs
 
  • TechNet Flash Newsletter
  • TechNet Gallery
  • TechNet Library
  • TechNet Magazine
  • TechNet Subscriptions
  • TechNet Video
  • TechNet Wiki
  • Windows Sysinternals
  • Virtual Labs
Solutions
  • Networking
  • Cloud and Datacenter
  • Security
  • Virtualization
Updates
  • Service Packs
  • Security Bulletins
  • Microsoft Update
Trials
  • Windows Server 2012
  • System Center 2012 SP1
  • Microsoft SQL Server 2012 SP1
  • Windows 8 Enterprise
  • See all trials »
Related Sites
  • Microsoft Download Center
  • TechNet Evaluation Center
  • Drivers
  • Compatability & Converters
  • Windows Sysinternals
  • TechNet Gallery
Training
  • Training Catalog
  • Class Locator
  • Microsoft Virtual Academy
  • Free Windows Server 2012 courses
  • Free Windows 8 courses
  • SQL Server training
  • e-Learning overview
Certifications
  • Certification overview
  • MCSA: Windows 8
  • Windows Server Certification (MCSE)
  • Private Cloud Certification (MCSE)
  • SQL Server Certification (MCSE)
Other resources
  • TechNet Events
  • Second shot for certification
  • Born To Learn blog
  • IT Camps
Support by product
  • Exchange Server
  • Forefront Server
  • Forefront Edge Security
  • Forefront Server Security
  • Internet Explorer
  • Office
  • SharePoint
 
  • SQL Server
  • System Center
  • Windows Server
  • Windows XP
  • Windows Vista
  • Windows 7
  • Windows 8
Other support links
  • Microsoft Premier Online
  • Microsoft Fix It Center
  • TechNet Forums
  • MSDN Forums
  • Security Bulletins & Advisories
  • International support solutions
  • Log a support ticket
  • Look up event IDs and error codes
Not an IT pro?
  • Microsoft Customer Support
  • Microsoft Community Forums