Skip to main content
SQL Server Developer Center
Sign in
United States (English)
Home Library Learn Downloads Troubleshooting Community 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. All rights reserved. Terms of Use |  Trademarks |  Privacy Statement | Site Feedback