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

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

Using Data Taps in SSISAdd/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

Using MDS Excel Add-In to Model and Manage your Master DataThe 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

PowerPivot for Excel

How Do I Integrate a Map with SQL Server Reporting ServicesUse 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

Using Slicers with PowerPivot PivotTablesAdd 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 RelationshipsRelationships 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 SourceThe security context for using PowerPivot workbooks as a data source. (7:52)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 SSISFourth 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 MDSFifth 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 DQSLearn 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 DQSThe 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 |
MP4

Data Intelligence Using Data Mining TechniquesHow 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:
WMV |
MP4

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 iPadHow 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 DesignFundamental 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: 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

Viewing Reporting Services Reports on a Microsoft Surface RT DeviceHow to view a Reporting Services report on a Microsoft Surface RT device. Learn how to access the report in Windows Azure, SharePoint, and Report Manager. How to navigate the report, interact with data using features such as parameters and sort, export the report, upload a report file to Report Manager, and view data alerts for the report. (11:04)Download:
WMV |
MP4

Setup a VM Test Server for Power Viewer and PowerPivot: Part 1 - Prepare Your Virtual MachineSet 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 PerformanceHow 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 ControllerDave 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

Index AnalysisOverview 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

StatisticsOverview 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:
WMV |
MP4