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
|