共用方式為


SQL Server Video Archive

The most popular videos from the SQL Server TechCenter are available for download in both WMV and MP4 formats. NOTE: This is archived content and, over time, the videos may be retired and no longer available for download. If there is an entry by the video indicating it is no longer available, there are no other options to view or obtain the video.

Integration Services

  • Exporting SQL Server Data to Excel (SQL Server Video)
    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. (8:12)
    Download: WMV | MP4
  • How to: Call a Web Service by Using the Web Service Task (SQL Server Video)? 
    Call a Web service from an Integration Services package by configuring an HTTP connection manager and the Web Service task. Set up an XML task to read the information that you retrieved and use it in the package. (11:09)
    Download: WMV | MP4
  • How to: Automate SSIS Package Execution by Using the SQL Server Agent (SQL Server Video)? 
    Create a proxy account that runs an Integration Services package as a job step in SQL Server Agent; create the job and the job step; schedule the running of the job. (10:21)
    Download: WMV | MP4
  • Creating a Basic Package (SQL Server Video) 
    Create a basic package by using the SSIS Designer in Business Intelligence Development Studio. Learn how to create the project for the package, add a data flow task to the control flow of the package, and add elements to the data flow. (8:06)
    Download: WMV | MP4
  • Troubleshooting: SSIS Package Execution Using SQL Server Agent (SQL Server Video) 
    Troubleshoot an SQL Server Integration Services package that doesn't run when you call the package from a SQL Server Agent job step. (12:24)
    Download: WMV | MP4
  • CDC for Oracle Databases using SQL Server Integration Services 2012 (SQL Server Video) 
    Perform change data capture (CDC) for Oracle databases using the new features introduced in SQL Server 2012 Integration Services (SSIS). Learn how CDC for Oracle works, how to create a CDC service and administer the service, as well as monitor the logs and traces to troubleshoot the service. (16:24)
    Download: WMV | MP4
  • Balanced Data Distributor (SQL Server Video)
    Leverage the Balanced Data Distributor component to reduce the execution time of an SSIS package. Increase the throughput of the package Data Flow transformations by paralleling the Data Flow buffers to multiple outputs. (10:29)
    Download: WMV | MP4 
  • SSIS Log Analyzer (SQL Server Video) 
    Use the SSIS Log Analyzer tool to analyze complex and verbose SSIS logs quickly and easily. (8:30)
    Download: WMV | MP4 
  • Using Data Taps in SSIS
    Add/use data taps in SQL Server 2012 SSISDB catalog that help with debugging packages programmatically and capturing the partial results at the runtime. List/remove these data taps and best practices for using data taps in SSIS packages. (18:29)
    Download: WMV | MP4

Master Data Services

  • SQL 2012 Master Data Services Overview
    Overview of Master Data Services in SQL Server 2012 and presents its capabilities, architecture and key scenarios. (25:34)
    Download: WMV | MP4
  • Managing Data Warehouse Dimensions with MDS (part 1)
    How business users can manage a simple data warehouse hierarchy. (16:45)
    Download: WMV | MP4 
  • Managing Data Warehouse Dimensions with MDS (part 2)
    How business users can leverage MDS to manage complex recursive hierarchies in the data warehouse. (14:07)
    Download: WMV | MP4
  • Using MDS Excel Add-In to Model and Manage your Master Data
    The Master Data Services Excel Add-in in SQL Server 2012 helps you create and manage models. Learn about the MDS Excel Add-in feature set and see how you can use Excel to manage data in an agile and effective manner. (13:29)
    Download: WMV | MP4
  • SQL 2012 Master Data Services - Web User Interface Explorer overview
    Learn about the Explorer and the Hierarchy management user interface and feature set of Master Data Services in SQL Server 2012. (8:02)
    Download: WMV | MP4
  • SQL 2012 Master Data Services - Hierarchies and Collections
    How to use Hierarchies and Collections in Master Data Services SQL Server 2012. (23:38)
    Download: WMV | MP4
  • SQL 2012 Master Data Services Security
    How to use Security in Master Data Services SQL Server 2012. (15:39)
    Download: WMV | MP4
  • SQL 2012 Master Data Services - Entity Based Staging
    Use Entity Based Staging in MDS SQL Server 2012 to load all members and attribute values for an entity at one time. (27:47)
    Download: WMV | MP4

PowerPivot for Excel

  • Install PowerPivot for Excel 
    Instructions for installing the PowerPivot Add-in for Excel. (3:50)
    Download: WMV | MP4
  • How Do I Integrate a Map with SQL Server Reporting Services 
    Use SQL Server 2008 R2 Reporting Services to insert a map that uses spatial data within a SQL Server database into a report. How to create a report using Business Intelligence Design Studio, add a map to the report, define spatial to visual within the report and the various maps available by default plus where to find additional maps. (12:25)
    Download: WMV | MP4
  • Import Access Data into a PowerPivot Workbook
    Use the PowerPivot Add-in for Excel to import data from Microsoft SQL Server relational databases. (3:32)
    Download: WMV | MP4
  • Using Slicers with PowerPivot PivotTables
    Add slicers to a PivotTable in a PowerPivot workbook. Slicers can be used to interactively filter and analyze data by controlling what data appears in your PivotChart. (4:53)
    Download: WMV | MP4
  • Introduction to PowerPivot Relationships
    Relationships in PowerPivot are created either by manually joining tables in the PowerPivot workspace, or by automatically detecting existing relationships when loading data into a PowerPivot workbook. (2:57)
    Download: WMV | MP4
  • Using PowerPivot Workbooks as a Data Source
    The security context for using PowerPivot workbooks as a data source. (7:52)
    Download: WMV | MP4
  • Import Access Data into a PowerPivot Workbook
    Use the PowerPivot Add-in for Excel to import data from Microsoft Access. (3:54)
    Download: WMV | MP4
  • Import Excel Data Into a PowerPivot Workbook
    Add data from an Excel spreadsheet to your PowerPivot workbook. (1:56)
    Download: WMV | MP4
  • Sparklines, Bar Charts, and Indicators in Report Builder 3.0
    Reporting Services Program Manager Sean Boon demonstrates new data visualizations in Report Builder 3.0 that help communicate trends and status: sparklines, data bars, and indicators. (4:00)
    Download: WMV | MP4

Data Quality Services

  • Data Quality Basics and Introducing DQS
    First video in series: Introduces the concept of data quality and its importance to any business. Also introduces Data Quality Services (DQS), new feature in SQL Server 2012, which provides a knowledge-driven solution to easily improve data quality through profiling, cleansing, and matching of data. (37:32)
    Download: WMV | MP4
  • Knowledge Management and Data Cleaning in Data Quality Services (DQS)
    Second video in series: Introduces the knowledge base in DQS, concepts around knowledge base creation and management, how to cleanse data using the knowledge base, and provides information about composite domain parsing. (1:08:46)
    Download: WMV | MP4
  • Data Matching in Data Quality Services (DQS)
    Third video in series: Provides information on how duplicate data adversely affects your business and introduces the concept of data matching, which is a process to eliminate duplicate records in your data. It also provides information on data matching principles in DQS and how data matching is done in DQS to discover and eliminate duplicate records. (1:11:57)
    Download: WMV | MP4
  • DQS Integration with SSIS: Data Cleansing Using SSIS
    Fourth video in series: Provides information on how to use the knowledge in a DQS knowledge base to cleanse data within the Integration Services packaging process. Introduces the DQS Cleansing transformation in Integration Services, and demonstrates how to use the transformation in an Integration Services package to leverage the DQS knowledge and cleanse the data. (27:16)
    Download: WMV | MP4
  • DQS Integration with MDS: Data Matching using MDS
    Fifth video in series: Provides information on how to enable DQS integration in Master Data Services to use the DQS matching functionality. You can leverage knowledge in a DQS knowledge base to perform data matching by using the Master Data Services Add-in for Excel. (12:44)
    Download: WMV | MP4
  • How Do I: Install and Configure DQS
    Learn about the prerequisites to install SQL Server Data Quality Services (DQS), how to install DQS, and how to perform post-installation tasks to configure DQS. (9:42)
    Download: WMV | MP4
  • Using MDS Excel Add-In for Matching with DQS
    The integration of MDS and DQS offers the ability to match and optionally de-duplicate data in an entity, using DQS within the MDS Excel Add-In interface. (6:20)
    Download: WMV | MP4

Data Mining

  • How Do I: Getting Started with the Table Analysis Tools for Excel?
    How to open the tools, use the sample Excel data, and connect to an Analysis Services server. (6:14)
    Download: WMV
  • Data Intelligence Using Data Mining Techniques
    How the presenter used sequence clustering in SQL Server Data Mining to predict potential fraud in a call center application. The business reasons for using data mining and the idea that data mining can be embedded into a CRM application to improve customer service and security. (6:01)
    Download: (No longer available)

SQL Server "How do I"?

  • How to: Use the Data Profiling Task (SQL Server Video)?
    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. (10:24)
    Download: WMV | MP4
  • Viewing Reporting Services Reports on an iPad
    How to view a Reporting Services report on an Apple iPad that has Apple iOS 6 and Apple Safari. Learn how to access and navigate the report, interact with the data using features like parameters and sort, and export the report to a file. (7:21)
    Download: WMV | MP4
  • Introduction to Database Design
    Fundamental concepts for relational tables and using the normalization design process to minimize structural problems with the tables you design in relational databases. Covers the fundamental concepts of tables including columns, rows, domains and the categories of table keys (candidate, primary, and foreign keys). Introduces the normalization design process. (58:44)
    Download: WMV | MP4
  • Create a Utility Control Port (UCP)
    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. (4:11)
    Download: WMV | MP4
  • How Do I: Setup Snapshot Replication with SQL Server 2008
    This video demonstrates how to configure Snapshot Replication between two instances of SQL Server 2008. This video demonstrates creating a Publisher database, creating Subscriber database, selecting replicable SQL Server database objects, and configuring security for the replication processes. (10:42)
    Download: WMV | MP4
  • How Do I: Create a gallery of reusable report parts?
    How use create a gallery of reports parts in SQL Server Reporting Services 2008. Demonstrates how to create a report part gallery, how to publish report parts from existing reports, how to specify settings while publishing report parts, how to use the published report parts within reports.
    Download: WMV | MP4
  • How Do I: Optimize Data Warehousing with Microsoft SQL Server 2008?
    Max Adams will present 10 tips toward optimizing Data Warehouses or DataMarts build on Microsoft's SQL Server 2008 platform. (12:25)
    Download: WMV | MP4
  • Setup a VM Test Server for Power Viewer and PowerPivot: Part 1 - Prepare Your Virtual Machine
    Set up a test machine on a VM that can be used to host SharePoint with Power View and PowerPivot enabled, and a client machine for building models and creating reports. Learn how to configure a domain controller in a VM, add a client machine, add the services, and prepare the software that must be installed on all machines. (18:54)
    Download: WMV | MP4
  • Leverage Microsoft Attunity Connector for Oracle to enhance Package Performance
    How to leverage the Microsoft Connector for Oracle by Attunity to increase package performance when bulk loading data from an Oracle source to a Flat File Destination. (5:09)
    Download: WMV | MP4

SQL Server Analysis Services (SSAS) "How Do I?"

  • How Do I: Defining and Deploying a Cube?
    How to define and deploy an OLAP cube using Analysis Services. (8:08)
    Download: WMV | MP4
  • How Do I: Creating an Analysis Services Project?
    How to create an Analysis Services project, define a data source, and define a data source view. Also, how to change the value of the FriendlyName property for objects in the data source view to increase the user-friendliness of their names. (4:53)
    Download: WMV | MP4
  • How Do I: Installing PowerPivot for SharePoint on a Domain Controller
    Dave Wickert shows you how to install a domain controller. This video is part 1 of "Installing PowerPivot for SharePoint on a Domain Controller." (5:51)
    Download: WMV | MP4

SQL Server 2008 Microsoft Certified Master (MCM) Readiness

  • Backup Internals
    Overview of different backup types (full, transaction log, differential), strategy concerns, backup integrity and backup compression. (36:17)
    Download: WMV | MP4
  • Backup Internals Demo
    Demonstration video for the "Backup Internals" lecture. (10:28)
    Download: WMV | MP4
  • Baselining and Benchmarkings
    Overview of reactive vs. proactive monitoring, Performance Monitor, Profiler, and benchmarking. (39:06)
    Download: WMV | MP4
  • Clustering Introduction
    Introduction of Failover Clustering concepts. (29:29)
    Download: WMV (No longer available) | MP4 (No longer available)
  • Clustering Setup and Troubleshooting
    Overview of cluster setup, administration and troubleshooting. (42:56)
    Download: WMV | MP4
  • DAN vs SAN Architecture
    Overview of DAS vs. SAN storage architecture. (20:49)
    Download: WMV (No longer available) | MP4 (No longer available)
  • Data File Internals and Maintenance
    Overview of data file internals and maintenance, including coverage of physical layout, auto-grow, instant file initialization, shrink considerations and Tempdb. (22:44)
    Download: WMV (No longer available) | MP4 (No longer available)
  • Data File Internals and Maintenance - Demo Video
    Demonstration video for the "Data File Internals and Maintenance" module. (7:40)
    Download: WMV (No longer available) | MP4 (No longer available)
  • Database Mirroring
    Overview of mirroring configuration, failure types and speed, failure scenarios, and client redirection. (52:40)
    Download: WMV (No longer available) | MP4 (No longer available)
  • Database Structures 
    Overview of database structure internals, including records, pages, extents, allocation bitmaps, IAM chains and allocation units. (42:15)
    Download: WMV | MP4
  • Database Structures - Demo Video
    Demonstration video for the "Database Structures" module. (15:43)
    Download: WMV | MP4
  • Designing an Availability Strategy
    Overview of what high availability concepts and planning an availability strategy and technology evaluation. (11:21)
    Download: WMV | MP4
  • Extended Events
    Overview of Extended Events concepts and capabilities. (15:58)
    Download: WMV | MP4
  • Extended Events Demo
    Demonstration video for the "Extended Events" lecture. (14:50)
    Download: WMV | MP4
  • Index Analysis
    Overview of index analysis techniques, validating if your indexes are using the right combination of keys, if your indexes are being used and how, if there are missing indexes and if your indexes are still healthy and most optimal. (50:12)
    Download: WMV | MP4
  • Index Fragmentation
    Overview of data access methods, fragmentation, page splits, FILLFACTOR and detecting/removing fragmentation. (47:37)
    Download: WMV | MP4
  • Index Fragmentation Demo
    Demonstration video for the "Index Fragmentation" lecture. (12:10)
    Download: WMV | MP4
  • Index Internals 
    Overview of physical index levels, clustered and nonclustered index structures (leaf-level, B-tree). (31:53)
    Download: WMV | MP4
  • Index Internals Demo
    Demonstration video for the "Index Internals" lecture. (28:13)
    Download: WMV | MP4
  • Index Strategies
    Overview of indexing for performance, strategies for design, pitfalls and optimizing aggregates. (29:37)
    Download: WMV | MP4
  • Index Strategies Demonstration
    Demonstration video for the "Indexing Strategies" lecture. (31:28)
    Download: WMV | MP4
  • Locking
    Overview of basics, locking and blocking, granularity, escalation, duration, and troubleshooting locking behavior. (28:23)
    Download: WMV (No longer available) | MP4 (No longer available)
  • Locking Demo
    Demonstration video for the "Locking Demo" lecture. (13:19)
    Download: WMV (No longer available) | MP4 (No longer available)
  • Log File Internals and Maintenance
    Overview of log file internals and maintenance, including an anatomy of a data modification, checkpoints and recovery, transaction log internals, recovery models, and log file maintenance. (47:20)
    Download: WMV (No longer available) | MP4 (No longer available)
  • Log File Internals and Maintenance - Demo Video
    Demonstration video for the "Log File Internals and Maintenance" module. (13:37)
    Download: WMV (No longer available) | MP4 (No longer available)
  • New Database Structures in SQL Server 2008
    Overview of new database structures, including data compression, sparse columns and FILESTREAM. (23:24)
    Download: WMV | MP4
  • Optimizing Procedural Code
    Overview of procedure code optimization, including plan reuse and recompilation concepts and behaviors. (1:00:03)
    Download: WMV | MP4
  • Partial Database Availability & Online Piecemeal Restore
    Overview of partial database availability and online piecemeal restore functionality. (49:53)
    Download: WMV | MP4
  • Partitioning
    Overview of partitioning functionality. (1:15:32)
    Download: WMV | MP4
  • Replication
    Overview of replication types and usage scenarios. (23:25)
    Download: WMV | MP4
  • Replication Demo
    Demonstration video for the "Replication" lecture. (12:20)
    Download: WMV | MP4
  • Security EXECUTE AS and SQL Injection
    Overview of EXECUTE AS, ownership chains, cross database impersonation, SQL injection, common patterns, character filtering and privileges. (41:41)
    Download: Download: Download: WMV (No longer available) | MP4 (No longer available)
  • Security Introduction and Server Setup
    Overview of securing the machine, the OS, services, the network and security configuration with policies. (53:10)
    Download: Download: Download: WMV (No longer available) | MP4 (No longer available)
  • Security Keys and Encryption
    Overview of encryption and types of keys, the key hierarchy, key management, encrypting data, encrypting a database (TDE) and Extensible Key Management (EKM). (1:16:12)
    Download: Download: Download: WMV (No longer available) | MP4 (No longer available)
  • Service Broker
    Overview of Service Broker, database objects, database properties, activation programs, inter-database and inter-server considerations, and a deep dive on an end-to-end Service Broker application. (1:08:22)
    Download: Download: Download: WMV (No longer available) | MP4 (No longer available)
  • Snapshot Isolation
    Overview of isolation levels, controlling isolation levels, statement-level read consistency, transaction-level read consistency, overhead and monitoring. (47:34)
    Download: WMV | MP4
  • SQL Azure Database
    Come to this session to learn about the latest investments in the Azure relational database service, SQL Database. We demonstrate the value proposition of SQL Database with Basic, Standard, and Premium service tiers and walk through enhancements in performance, scale out, business continuity, security, and data developer and management experiences. (1:10:24)
    Download: WMV (No longer available) | MP4
  • SQL Server Spatial
    Overview of SQL Server Spatial functionality including the Geometry and Geography, CLR-based architecture, spatial indexes and performance, and importing spatial data. (1:02:31)
    Download: WMV (No longer available) | MP4 (No longer available)
  • SQLCLR
    Overview of SQLCLR objects, internals, security, reliability, troubleshooting, coding considerations and best practices. (1:00:20)
    Download: Download: WMV (No longer available) | MP4 (No longer available)
  • SQLOS
    Overview of the SQL Server Operating System (SQLOS). (24:53)
    Download: Download: WMV (No longer available) | MP4 (No longer available)
  • Statistics
    Overview of querying specific index usage, what do statistics look like, what do statistics tell us, how do we use statistics, how\when statistics get created and how\when statistics get updated. (1:00:43)
    Download: Download: Download: WMV (No longer available) | MP4 (No longer available)
  • Storage Core Concepts
    Overview of drive types, attachment methods and what we store. (45:51)
    Download: Download: Download: WMV (No longer available) | MP4 (No longer available)
  • Storage Testing and Monitoring
    Overview of the challenges of SAN monitoring, recommendations for getting started, Perfmon storage counters, testing before installation and ongoing health monitoring. (31:26)
    Download: Download: Download: WMV (No longer available) | MP4 (No longer available)
  • The Clustered Index Debate
    Overview of table structures, clustered index structures, nonclustered indexes and "bookmark lookups", understanding the efficiency of the "lookup" value, cumulative effect of inefficient clustering keys, key constraint create indexes and choices for a good clustering key. (36:57)
    Download: Download: Download: WMV (No longer available) | MP4 (No longer available)
  • Virtualization
    Overview of how virtualization changes CPU, Memory, Storage and Monitoring. (45:17)
    Download: Download: Download: WMV (No longer available) | MP4 (No longer available)
  • Waits and Queues
    Overview of waits and queues, thread execution and examining waits. (20:30)
    Download: Download: Download: WMV (No longer available) | MP4 (No longer available)
  • Waits and Queues Demo
    Demonstration video for the "Waits and Queues" lecture. (16:03)
    Download: Download: Download: WMV (No longer available) | MP4 (No longer available)
  • XML
    Overview of SQL XML functionality, the XML data type, using XML and relational types, XML Schema support, XQuery, and performance considerations. (1:00:21)
    Download: Download: Download: WMV (No longer available) | MP4 (No longer available)

Browse by video series

  • Integration Services
  • Master Data Services
  • PowerPivot for Excel
  • Data Quality Services
  • Data Mining
  • SQL Server "How do I"?
  • SQL Server Analysis Services (SSAS)
    "How Do I?"
  • SQL Server 2008 Microsoft Certified Master (MCM) Readiness

More SQL Server videos