-
Backup Types
In Microsoft SQL Server; you can use the different backup methods provided to back up your databases. In this video; Aaron Sampson discusses the various backup methods available in Microsoft SQL Server 2014.
-
Installing a JDK and Building Spark on Mac OS X Yosemite
After watching this video; you will be able to download and install JDK 8 and build Apache Spark using sbt on Mac OS X Yosemite.
-
Using Reliability and Performance Monitor
After watching this video; you will be able to use Windows Reliability and Performance Monitor to monitor a report server.
-
Adding a Document Map to a Report in Reporting Services
After watching this video; you will be able to add a document map to a report.
-
Adding a DrillDown Action to a Report in Reporting Services
After watching this video; you will be able to add a DrillDown action to a report.
-
Adding a Drillthrough Action to a Report in Reporting Services
After watching this video; you will be able to add a Drillthrough action to a report.
-
Adding Bookmark Links; Hyperlinks; and Embedding HTML in Reporting Services Reports
After watching this video; you will be able to add a bookmark link and hyperlinks to a report.
-
Adding Dimensions to Cubes
Microsoft SQL Server 2014 provides administrators with the Data Source View; which is used to work with dimension tables and identify fact tables. In this video; Aaron Sampson demonstrates how to use Data Source View to add and remove cube dimensions; create hierarchies; and include attributes to any cube within a project.
-
Adding Features to a Prepared Instance
Microsoft SQL Server 2014 allows administrators to create prepared instances of SQL Server; in combination with imaging technologies; to ease the deployment process. In this video; Aaron Sampson demonstrates how to add features to a prepared instance of Microsoft SQL Server 2014.
-
Adding Images; Charts; Gauges; and Indicators in Report Builder
After watching this video; you will be able to add images; maps; charts; and indicators to a report in Report Builder.
-
Adding Images; Maps; Charts; and Indicators to Reports in Reporting Services
After watching this video; you will be able to add images; maps; charts; and indicators to a report.
-
Adding Interactive Features in Report Builder
After watching this video; you will be able to add interactive features to a report in Report Builder.
-
Adding Interactive Sorting to a Report in Reporting Services
After watching this video; you will be able to add interactive sorting to a report.
-
Adding Lists; Text Boxes; and Other Visuals to Reports in Reporting Services
After watching this video; you will be able to add lists; text boxes; and other visuals to a report; including headers and footers.
-
Adding Measures Groups to Cubes
Microsoft SQL Server 2014 provides administrators with the ability to add measure groups to cubes when more than one measure is needed. In this video; Aaron Sampson demonstrates how to group measures together rather than adding a single measure at a time.
-
Adding Measures to Cubes
Microsoft SQL Server 2014 provides administrators with dimensions that can be used to apply context to measures in a cube. In this video; Aaron Sampson demonstrates how to add a new measure based on the fact tables; using functions to calculate countable values.
-
AlwaysOn Availability Group Prerequisites
In SQL Server; you can install the Windows server failover cluster feature on each node. In this video; Aaron Sampson discusses AlwaysOn availability group prerequisites.
-
AlwaysOn Availability Groups - Active Secondary Replicas
In SQL Server; you can implement an AlwaysOn Availability Group to service request from all clients and gives them access to the database. In this video; Aaron Sampson discusses active secondary replicas.
-
AlwaysOn Availability Groups - Availability Modes
In SQL Server; you can implement AlwaysOn Availability Groups to protect copies of the databases and maintain services. In this video; Aaron Sampson discusses availability modes.
-
AlwaysOn Availability Groups - Failover Modes
In Microsoft SQL Server 2014; you can use the failover modes of AlwaysOn Availability Groups to recover the database from data loss. In this video; Aaron Sampson explains AlwaysOn Availability Groups - Failover Modes.
-
AlwaysOn Availability Groups and Clustering
In SQL Server; you can implement high availability groups on its own without relying on Windows clustering. In this video; Aaron Sampson discusses the concepts of AlwaysOn Availability groups in SQL.
-
AlwaysOn Availability Groups Overview
In Microsoft SQL Server 2014; you can use availability groups that allows up to four copies of database to be on a system for performing tasks like querying; generating reports; data analysis; backups; etc. In this video; Aaron Sampson discusses the AlwaysOn Availability Groups.
-
AlwaysOn Failover Cluster Instance
SQL Server has the ability to include all the databases within a particular instance in the cluster. In this video; Aaron Sampson discusses failover cluster instance.
-
Automating Backups Using Scripts
Microsoft SQL Server 2014 allows you to create backup scripts automatically. In this video; Rafiq Wayani demonstrates two different ways to create a backup script.
-
Automating SSAS Objects Processing Using AMO
After watching this video; you will be able to automate the processing of SSAS objects using AMO.
-
Backing Up a Multidimensional Database
After watching this video; you will be able to backup a multidimensional database using the Backup dialog box in SSMS.
-
Backing Up a Multidimensional Database Using PowerShell
After watching this video; you will be able to backup a multidimensional database using PowerShell.
-
Backing Up and Restoring a Tabular Database
After watching this video; you will be able to backup a tabular database.
-
BI Scenarios and SharePoint
In this video; Aaron Sampson describes Business Intelligence (BI) features when combined with SharePoint in Microsoft SQL Server 2014.
-
Browsing and Managing Writeback Data in a Partition
After watching this video; you will be able to browse; delete; disable; and convert writeback data.
-
Building Hierarchies
In this video; Aaron Sampson describes how to build hierarchies for dimensions in Microsoft SQL Server 2014.
-
Checking Cube Data Through the Browser
Microsoft SQL Server 2014 is a relational database management system for building applications and solutions. The Cube Designer in SQL Server Analysis Services is used to edit the properties of a cube; or to browse data contained by the cube. In this video; Aaron Sampson demonstrates how to browse the cube in order to understand the data it contains.
-
Cloud Computing Management
In Microsoft SQL Server 2014; you can manage cloud environment using system center. In this video; Aaron Sampson explains the components of system center and how they deal with managing a larger enterprise and incorporating cloud-based services.
-
Cloud Computing Models
In Microsoft SQL Server 2014; you can use different models to implement cloud-based services. In this video; Aaron Sampson discusses cloud computing models.
-
Cloud Computing Overview
With cloud computing; you have a database environment which offers increased flexibility and service availability without the need of associated hardware management. In this video; Aaron Sampson explains the benefits and advantages of integrating cloud computing into your infrastructure.
-
Common Database Server Topologies
In Microsoft SQL Server 2014; you have database server topologies which are the viable solutions to any company's server requirements. In this video; Aaron Sampson explains the pros and cons of the database server topologies.
-
Completing a Prepared Instance
In Microsoft SQL Server 2014; administrators can complete a detailed configuration once the base installation of a prepared instance has been completed. In this video; Aaron Sampson demonstrates how to complete a prepared instance in Microsoft SQL Server 2014.
-
Configure Log Shipping Using SQL Server Management Studio
The Microsoft SQL Server Management Studio allows you to configure log shipping to maintain a list of all changes and modifications to a source copy. In this video; Aaron Sampson explains how to configure log shipping using SQL Server Management Studio.
-
Configure Log Shipping Using T-SQL
Microsoft SQL Server 2014 allows users to configure log shipping by using the T-SQL code. In this video; Aaron Sampson explains how to access the log shipping feature by using the T-SQL code.
-
Configure Measure Group Properties
After watching this video; you will be able to configure measure group properties.
-
Configure Measure Properties
After watching this video; you will be able to configure measure properties.
-
Configuring a Dimension Structure Using the Designer
In Microsoft SQL Server 2014; many dimensions can be created to assist in gathering and analysing appropriate data. In this video; Aaron Sampson demonstrates how to configure a dimension structure using the Designer.
-
Configuring a Parameterized Connection String in Reporting Services
After watching this video; you will be able to configure a parameterized connection string to connect to a database.
-
Configuring Dimension Attribute Relationships
With Microsoft SQL Server 2014 you can configure attribute relationships; which specify connections within dimensions. It is simply a connection within a table. In this video; Aaron Sampson demonstrates how to configure dimension attribute relationships.
-
Configuring InMemory or DirectQuery Access
After watching this video; you will be able to configure the mode for data access for a tabular model.
-
Configuring Item-Level Security in Reporting Services
After watching this video; you will be able to create item-level roles to grant permissions to users.
-
Configuring Report Server Level Security in Reporting Services
After watching this video; you will be able to create server-level roles and assign users to the roles to allow report server access.
-
Configuring Reporting Services
After watching this video; you will be able to configure Reporting Services.
-
Configuring Roles in a Tabular Model Database
After watching this video; you will be able to configure roles to grant permissions to a tabular model database.
-
Configuring Security for an SSAS Instance
In this video; Aaron Sampson demonstrates how to configure security settings for a SQL Server Analysis Services (SSAS) instance in Microsoft SQL Server 2014.
-
Configuring Security for Windows Azure SQL Database
In Microsoft SQL Server 2014; you can create new users and logins as well as manage their security settings. In this video; Aron Sampson demonstrates how to set up the security settings of new users.
-
Configuring Server and SSAS Database Roles
After watching this video; you will be able to configure server roles and SSAS database roles to implement security.
-
Configuring SharePoint Groups and Permissions for Report Server Items
After watching this video; you will be able to configure SharePoint groups and permissions for access to report server item.
-
Configuring Stored Credentials in Report Server
After watching this video; you will be able to configure stored credentials to allow access to external data for a report.
-
Connection to Azure Marketplace in Reporting Services
After watching this video; you will be able to connect to Microsoft Azure Marketplace in a data source.
-
Consolidation Options
In Microsoft SQL Server 2014; you can perform consolidations at multiple levels. In this video; Aaron Sampson discusses various consolidation options.
-
Consolidation Strategy Planning
In Microsoft SQL Server 2014; you can assess your database environment and plan a strategy before consolidating resources. In this video; Aaron Sampson discusses the consolidation strategies and considerations.
-
Create a Windows Azure Storage Account
With Microsoft SQL Server 2014; you can integrate your data using a cloud storage solution such as Microsoft Windows Azure. In this video; Aaron Sampson demonstrates how to create a Windows Azure storage account to make binary large objects accessible via the public cloud service.
-
Creating a Subscription for a Report in Report Manager
After watching this video; you will be able to create a standard subscription for a report in Report Manager.
-
Creating a Connection to Azure SQL Database in Reporting Services
After watching this video; you will be able to create a shared data source that connects to Microsoft Azure Database.
-
Creating a Cube using a Template
In this video; Aaron Sampson demonstrates how to create a Cube using a Template in Microsoft SQL Server 2014.
-
Creating a Cube Using Existing Tables in the Cube Wizard
After watching this video; you will be able to create a new cube using the Cube Wizard.
-
Creating a Data Source for a Multidimensional Database
In this video; Aaron Sampson demonstrates how to create a Data Source for a Multidimensional Database in Microsoft SQL Server 2014.
-
Creating a Data Source to a Non-Relational Database in Reporting Services
After watching this video; you will be able to create a shared data source that connects to a non-relational database.
-
Creating a Data Source View
In Microsoft SQL Server Analysis Services; a data source view contains the logical model of the schema used by the multidimensional database objects; and it helps to filter and select the appropriate information for a project. In this video; Aaron Sampson demonstrates how to create a data source view.
-
Creating a Data-Driven Subscription in Report Manager
After watching this video; you will be able to create a data-driven subscription in Report Manager.
-
Creating a Dimension Using the Dimension Wizard
After watching this video; you will be able to create a dimension using the Dimension Wizard.
-
Creating a Disaster Recovery Plan
In Microsoft SQL Server 2014; backup and recovery planning are key to any organizations who implement SQL Server; and knowing how to create and maintain a disaster recovery plan is crucial. In this video; Aaron Sampson demonstrates how to create a disaster recovery plan.
-
Creating a Dynamic Report Using Parameters in Reporting Services
After watching this video; you will be able to create a dynamic report using parameters.
-
Creating a Local Partition by Filtering a Fact Table
After watching this video; you will be able to create a local partition by filtering a fact table.
-
Creating a Local Partition Using Tables; Views; or Named Queries
After watching this video; you will be able to create a local partition using a table; view or named query.
-
Creating a Matrix Report in Reporting Services
After watching this video; you will be able to create a basic matrix report.
-
Creating a New Project Using a Template in SSDT
After watching this video; you will be able to create a new project in SSDT using a template.
-
Creating a Prepared Instance
Microsoft SQL Server 2014 has a number of enhancements and features aimed at private cloud deployment and management of SQL databases; including working with prepared instances of SQL Server. In this video; Aaron Sampson demonstrates how to create a Microsoft SQL Server 2014 prepared instance.
-
Creating a Report History for Reporting Services
After watching this video; you will be able to create a report history.
-
Creating a Report in Report Builder
After watching this video; you will be able to create a new report in Report Builder by selecting the appropriate report layout and adding data sources and datasets.
-
Creating a Reporting Services Project in SSDT
After watching this video; you will be able to choose and create a new Reporting Services project in SSDT.
-
Creating a Schedule for a Report in Report Manager
After watching this video; you will be able to create a schedule for a report.
-
Creating a Shared Data Source in Reporting Services
After watching this video; you will be able to create a shared data source.
-
Creating a Shared Report Schedule for Reporting Services in SharePoint Mode
After watching this video; you will be able to create a shared schedule for a report when Reporting Services is in SharePoint Mode.
-
Creating a Shared Schedule for Native Mode in Report Manager
After watching this video; you will be able to create a shared schedule for a report when Reporting Services is in Native Mode.
-
Creating a Tablix Report in Reporting Services
After watching this video; you will be able to create a basic table report.
-
Creating a Tabular Model Using SSDT
After watching this video; you will be able to use a project template to create a new tabular model and describe the Tabular Model Designer Interface.
-
Creating a Time Dimension Using the Dimension Wizard
In Microsoft SQL Server 2014; when analysing data the most common dimension used is time based information such as days; weeks; or years. In this video; Aaron Sampson demonstrates how to create a time dimension using the dimension wizard.
-
Creating a Windows Server Failover Cluster
In Microsoft SQL Server 2014; you need to create the Windows Failover Cluster feature to use the high availability features of the SQL server. In this video; Aaron Sampson demonstrates how to create a Windows Server Failover Cluster.
-
Creating Actions on a Cube
In Microsoft SQL Server 2014; various actions can be created on a cube. In this video; Aaron Sampson demonstrates how to create a new drillthrough action on a cube by choosing cube dimensions and return columns; deploy the cube action into an executable form; and analyze the cube values in Excel.
-
Creating Aligned Indexes on Partitioned Tables
In Microsoft SQL Server 2014; you can easily create partitioned tables. In this video; Rafiq Wayani demonstrates how to create a partitioned table that spreads data across four filegroups.
-
Creating an AlwaysOn Availability Group Using the SSMS Dialog Box
In Microsoft SQL Server 2014; you can create an AlwaysOn High Availability group by using the SSMS wizard. You can also create this Availability group manually by using the dialog box. In this video; Aaron Sampson demonstrates how to create an AlwaysOn Availability group by using the SSMS dialog box.
-
Creating an AlwaysOn Availability Group Using the SSMS Wizard
You can create an AlwaysOn High Availability group by using the SQL Configuration Manager. In this video; Aaron Sampson demonstrates how to create an AlwaysOn Availability Group by using the SSMS wizard.
-
Creating an AlwaysOn Availability Group Using T-SQL
In SQL Server; you can create an Availability Group by using the T-SQL code. In this video; Aaron Sampson demonstrates how to create an AlwaysOn Availability Group by using T-SQL code.
-
Creating an E-mail Subscription for a Report in Report Manager
After watching this video; you will be able to create an e-mail subscription in Report Manager.
-
Creating an Embedded Data Source in Reporting Services
After watching this video; you will be able to create an embedded data source.
-
Creating an Embedded Dataset Using a Table Query Type in Reporting Services
After watching this video; you will be able to create an embedded dataset in a report by using a table query type.
-
Creating an Embedded Dataset Using a Text Query in Reporting Services
After watching this video; you will be able to create an embedded dataset in a report by specifying a text query type.
-
Creating an Empty Cube in the Cube Wizard
In this video; Aaron Sampson describes how to create an empty cube by using the Cube Wizard in Microsoft SQL Server 2014.
-
Creating and Adding Snapshots for Reporting Services
After watching this video; you will be able to create snapshots and add them to report history.
-
Creating Calculated Columns in a Tabular Model
After watching this video; you will be able to create calculated columns to aggregate data; including using DAX expressions.
-
Creating Calculated Columns in Tables
Microsoft SQL Server 2014 makes it easy to create calculated columns. In this video; Rafiq Wayani demonstrates how to create a calculated column that contains the results of multiplying quantity and unit price values.
-
Creating Calculated Members in a Multidimensional Model
After watching this video; you will be able to create calculated members using the Cube Designer.
-
Creating DAX Expressions for Tabular Objects
After watching this video; you will be able to create DAX expressions to implement tabular objects into a tabular model.
-
Creating Embedded Dataset Using a Stored Procedure in Reporting Services
After watching this video; you will be able to create an embedded dataset in a report by specifying a stored procedure in the Query Designer or selecting a predefined one.
-
Creating Hierarchies in a Tabular Model
After watching this video; you will be able to create hierarchies to define relationships between columns in a table.
-
Creating Indexed Views
In Microsoft SQL Server 2014; you can create indexed views of specific data from multiple tables. In this video; Rafiq Wayani demonstrates how to create an indexed view that contains particular columns from two tables.
-
Creating Linked Dimensions
Microsoft SQL Server 2014 allows you to create Linked Dimensions. When you’re defining dimensions in any cube; you might be looking to include a dimension that is actually not part of the current data source. In this video; Aaron Sampson demonstrates how to create Linked Dimensions.
-
Creating Linked Measure Groups
Microsoft SQL Server 2014 allows you to create a New Linked Dimension for a Measure Group. During the definition of that linked dimension; you create or specify any number of other data sources. In this video; Aaron Sampson demonstrates how to create Linked Measure Groups.
-
Development and Production Considerations
In this video; Aaron Sampson describes development and production considerations in Microsoft SQL Server 2014.
-
Creating Measure Groups
Microsoft SQL Server 2014 allows you to create measure groups. If you are more interested in seeing every attribute; you can save a bit of time by defining a new measure group. In this video; Aaron Sampson demonstrates two ways in which you can define a new measure group.
-
Creating Measures
After watching this video; you will be able to create a basic measure.
-
Creating Named Sets in a Multidimensional Model
After watching this video; you will be able to create named sets using the Cube Designer.
-
Creating Partitions in a Tabular Model
After watching this video; you will be able to create partitions using Partitions Manager.
-
Creating Perspectives for a Cube
In Microsoft SQL Server 2014; when defining a Cube structure; it is important to only include information that is relevant to particular users. In this video; Aaron Sampson demonstrates how to create; modify; and delete perspectives to define which fields of information are included in a Cube.
-
Creating Perspectives in a Tabular Model
After watching this video; you will be able to create perspectives to define viewable subsets of a model.
-
Creating Relative Measures
After watching this video; you will be able to create relative measures; including using growth; year over year; same period last year.
-
Creating Remote Partitions
After watching this video; you will be able to create a remote partition.
-
Creating User-Defined Hierarchies
In Microsoft SQL Server 2014; you can create User-Defined Hierarchies. There are no obvious structures as it is up to you how to set up the hierarchy. In this video; Aaron Sampson demonstrates how to create a User-Defined Hierarchy for a product catalogue.
-
Database Server Infrastructure Planning
In Microsoft SQL Server 2014; you can plan the infrastructure of your database server to include configuration; security; application; hardware; and other service requirements. In this video; Aaron Sampson demonstrates the process for planning a SQL Server 2014 database server infrastructure.
-
Defining Cube Attribute Properties
Microsoft SQL Server 2014 provides you with a Property window to view cube attributes. In this video; Aaron Sampson demonstrates how to view cube measures; dimensions; hierarchies; and attributes using the Property window. He also advises using the SQL Server TechNet pages to access more information on each property before setting values.
-
Defining Cube Dimension Properties
After watching this video; you will be able to define cube dimension properties.
-
Defining Cube Hierarchy Properties
In Microsoft SQL Server 2014; the properties of each cube hierarchy can be accessed and defined. In this video; Aaron Sampson demonstrates how to locate a cube's hierarchies; view and edit hierarchy properties by editing cube dimensions; and use the Browser to view a dimension's hierarchy structure.
-
Defining Expressions for Calculated Values in Reporting Services Reports
After watching this video; you will be able to define expressions to retrieve; calculate; display; sort; filter; and parameterize data.
-
Defining Filters Options for Datasets in Reporting Services
After watching this video; you will be able to define the filter options for a dataset.
-
Defining Granularity of Dimension Relationships
In this video; Aaron Sampson describes the granularity of dimension relationships in Microsoft SQL Server 2014.
-
Defining How SSAS Objects are Processed
After watching this video; you will be able to describe how processing and reprocessing affects SSAS objects; specifically partitions; databases; cubes; and dimensions.
-
Defining Parameters for Datasets in Reporting Services
After watching this video; you will be able to define parameters for a dataset.
-
Defining Relationships Between Tables
After watching this video; you will be able to define relationships between tables using the model designer.
-
Defining Semi-Additive Behavior
Microsoft SQL Server 2014 allows you to control how values are displayed when browsing an Analysis Services cube using aggregate functions in a semiadditive manner. In this video; Aaron Sampson demonstrates how functions are defined for semiadditive measures when measures need to be aggregated in different ways for different dimensions.
-
Defining Time Intelligence Calculations
After watching this video; you will be able to define time intelligence calculations using the Business Intelligence Wizard.
-
Defining Translations for Dimension Metadata
In Microsoft SQL Server 2014; you can define translations for dimension metadata. This is specifically for users who speak different languages. In this video; Aaron Sampson demonstrates how to specify a range of languages for use in metadata.
-
Defining Translations in a Cube
Microsoft SQL Server 2014 provides administrators with a translation service for database deployments in non-English-speaking environments. In this video; Aaron Sampson demonstrates how to insert translations of screen elements such as options and menu names using Cube Designer.
-
Deploying Custom Assemblies with Reports
After watching this video; you will be able to deploy custom assemblies with reports.
-
Deploying SQL Server Management Studio
In this video; Aaron Sampson demonstrates how to deploy SQL Server Management Studio (SSMS) for Microsoft SQL Server 2014.
-
Designing a Locking Strategy
In Microsoft SQL Server 2014; when designing a locking strategy it is important to have an understanding of how transactions really work. In this video; Rafiq Wayani demonstrates different transaction types and how to control transaction behaviour for use in a locking strategy.
-
Designing a Partition Strategy in a Multidimensional Model
After watching this video; you will be able to describe partitions in a multidimensional model; including the types local and remote; aggregations; and design strategy.
-
Designing a Schema for a Cube Architecture
A cube schema is the definition or foundation for constructing a cube object. In this video; Aaron Sampson discusses how to design a schema for a cube architecture in Microsoft SQL Server 2014.
-
Designing Aggregations for a Partition Using Aggregation Design Wizard
After watching this video; you will be able to design aggregations for a partition using the Aggregation Design Wizard.
-
Designing and Creating In-Memory OLTP Tables
In Microsoft SQL Server 2014; in-memory OLTP tables allow for faster insertions and deletions than standard disk tables. In this video; Rafiq Wayani demonstrates how to create an in-memory table and compares how long it takes to add and remove rows in a standard disk table to the time it takes using an in-memory table.
-
Designing Database Objects for Concurrency
When working with Microsoft SQL Server 2014; you should know how to deal with data inconsistency issues in a multi-user environment. In this video; Rafiq Wayani demonstrates how to use SQL Server to ensure that your database is optimized for concurrent users.
-
Designing Dimensions to Support Related Measure Groups
In this video; Aaron Sampson highlights the need to design dimensions to support related measure groups in Microsoft SQL Server 2014.
-
Designing Granularity
After watching this video; you will be able to design granularity.
-
Designing Patterns for Business Facts and Dimensions
In this video; Aaron Sampson describes the use of designing patterns for business facts and dimensions in Microsoft SQL Server 2014.
-
Designing Query Paging
Microsoft SQL Server 2014 has improved the way you design query paging. In this video; Rafiq Wayani demonstrates the new features available to you when designing query paging.
-
Designing SET Based Operations
In Microsoft SQL Server 2014; it is important to have an understanding of how to design SET based operations. In this video; Rafiq Wayani demonstrates the features of SET based operations and steps through an example operation.
-
Developing New Custom Attributes on Dimensions
After watching this video; you will be able to develop a custom attribute on a dimension.
-
Editing and Deleting Partitions
After watching this video; you will be able to edit and delete partitions in a multidimensional model.
-
Enabling Writeback in a Partition
After watching this video; you will be able to enable writeback on a partition in Cube Designer and SQL Server Management Studio (SSMS).
-
Exploring Project Folders; File Types; and Templates
In this video; Aaron Sampson describes the project folders; file types; and templates in Microsoft SQL Server 2014.
-
Exploring SQL Server Tools Environment
In this video; Aaron Sampson describes the administrative SQL Server Data Tools that can be used to manage the overall SQL Server environment.
-
Exploring the SQL Server Data Tools – BI Environment
In this video; Aaron Sampson explores the SQL Server Data Tools - Business Intelligence (SSDT-BI) environment in Microsoft SQL Server 2014.
-
Filtering; Grouping; and Sorting Data in Report Builder
After watching this video; you will be able to filter; group; and sort data for a report in Report Builder.
-
Formatting Fields and Column Headers in a Reporting Services Report
After watching this video; you will be able to format field and column headers in a table and matrix report.
-
Grouping Data and Adding Totals to Reports in Reporting Services
After watching this video; you will be able to group data in a report and add line totals and grand totals.
-
Hardware Planning Overview
In Microsoft SQL Server 2014; you have two types of databases: OLTP and DSS. In this video; Aaron Sampson explains the types of databases and the hardware performance using tools.
-
High Availability Options
In Microsoft SQL Server 2014; you can use the high availability features to keep your services running so that failures do not affect the ability of your users to access the databases they need. In this video; Aaron Sampson discusses the high availability options.
-
Identify the Correct Model for Data Analysis
In this video; Aaron Sampson describes how to identify the correct model for data analysis in Microsoft SQL Server 2014.
-
Identifying Attributes for Dimensions
In this video; Aaron Sampson describes the uses of identifying attributes for dimensions in Microsoft SQL Server 2014.
-
Identifying Issues with Aggregations in a Multidimensional Model
After watching this video; you will be able to identify issues with incorrect aggregations.
-
Identifying Issues with Relationships in a Multidimensional Model
After watching this video; you will be able to identify issues with incorrect relationships.
-
Identifying Measures and Aggregation Behavior
In this video; Aaron Sampson describes how to identify the measures and aggregation behavior in Microsoft SQL Server 2014.
-
Identifying Report Components for Reporting Services
After watching this video; you will be able to describe the different report components for planning a report; including crosstab; Tablix; design chart; and data visualization components.
-
Implementing Constraints
In Microsoft SQL Server 2014; you can configure cascading deletes so that when a record from one table is deleted; associated records from another table are automatically deleted too. In this video; Rafiq Wayani demonstrates how to construct a primary foreign key relationship between two tables and then perform a cascading delete.
-
Implementing Context Modification in a Tabular Model
After watching this video; you will be able to implement context modification.
-
Implementing Database Permissions Using Roles
After watching this video; you will be able to create roles to implement SSAS database permissions.
-
Implementing Dynamic Security
After watching this video; you will be able to implement dynamic security for custom security approaches.
-
Implementing Error Handling
When you work with Microsoft SQL Server 2014; it's important for you to understand how to implement error handling. In this video; Rafiq Wayani; demonstrates how to implement try…catch…finally error handling.
-
Implementing Fact Relationships
In Microsoft SQL Server 2014; linking a measures table to your dimensions table when designing your cube can be done thought fact relationships. In this video; Aaron Sampson demonstrates how to create; customize; and implement fact relationships.
-
Implementing Filtering and Parameter Lists in Reporting Services
After watching this video; you will be able to implement filtering and parameter lists to control report data.
-
Implementing Group and Report Variables to Reports in Reporting Services
After watching this video; you will be able to implement group variables and report variables to a report.
-
Implementing KPIs in a Tabular Model
After watching this video; you will be able to create Key Performance Indicators; KPIs.
-
Implementing Many-to-Many Relationships
After watching this video; you will be able to implement many-to-many relationships in a cube.
-
Implementing Measures in a Tabular Model
After watching this video; you will be able to create measures using a table's measure grid; including using DAX to create the formula.
-
Implementing Plan Guides
In Microsoft SQL Server 2014; you are able to define and implement Plan Guides to improve queries on your tables. In this video; Rafiq Wayani demonstrates how to implement an execution plan to minimize the impact of table searches on CPU cost.
-
Implementing Policy-Based Management
In Microsoft SQL Server 2014; you can use the SQL Server Management Studio to create policies. In this demonstration; Aaron Sampson discusses policy-based management.
-
Implementing Remote Processing of SSAS Objects
After watching this video; you will be able to implement remote processing of SSAS objects.
-
Implementing Resource Governor
In Microsoft SQL Server 2014; you can use the Resource Governor to throttle your usage. In this video; Rafiq Wayani demonstrates how to use the Resource Generator to create a resource pool to help you optimize your I/O processing time and maximize the use of your resources.
-
Implementing Role-Playing Relationships
In Microsoft SQL Server 2014; you can implement role-playing relationships; bearing in mind the importance being on the implementation aspect not the relationship itself. In this video; Aaron Sampson discusses how to implement role-playing relationships effectively.
-
Implementing Row-Level Filters
After watching this video; you will be able to implement row-level permissions.
-
Implementing the Show/Hide Property in Reporting Services
After watching this video; you will be able to use the Show/Hide property for a report region; including creating an expression.
-
Implementing Time Intelligence in a Tabular Model
After watching this video; you will be able to implement time intelligence using different functions to support BI analysis; including specifying a Mark Table.
-
Implementing XML Selective Indexes
In Microsoft SQL Server 2014; you can create selective indexes using XQuery expressions. In this video; Rafiq Wayani demonstrates how to create a selective XML index that uses XQuery to retrieve XML data about a book; including its title; author; and ID.
-
Importing Data into a Tabular Model
After watching this video; you will be able to import data into a tabular model using the Table Import Wizard.
-
Installing PowerPivot for SharePoint
After watching this video; you will be able to install PowerPivot for SharePoint.
-
Installing Reporting Services
After watching this video; you will be able to install Reporting Services using different topologies.
-
Installing SQL Server Data Tools – Business Intelligence
In this video; Aaron Sampson demonstrates how to install SQL Server Data Tools - Business Intelligence (SSDT-BI) for Microsoft SQL Server 2014.
-
Installing SSAS in Multidimensional Mode
After watching this video; you will be able to install SSAS in multidimensional mode.
-
Installing SSAS in Tabular Mode
In this video; Aaron Sampson demonstrates how to install the SQL Server Analysis Services (SSAS) in the tabular mode in Microsoft SQL Server 2014.
-
Integrating Performance Monitor Data with SQL Traces
Microsoft SQL Server 2014 allows SQL traces to be saved as files viewed in SQL Server Profiler. In this video; Rafiq Wayani demonstrates how to build; run; and delete a trace; before opening it as a recorded file in SQL Server Profiler.
-
Joining a Secondary Replica to an AlwaysOn Availability Group
In SQL Server; you can join the replica servers and the database to the availability group. In this video; Aaron Sampson demonstrates the configuration of availability groups.
-
Log Shipping Overview
In SQL Server; you can use log shipping process to copy a full backup of the primary server to a secondary server. In this video; Aaron Sampson discusses log shipping.
-
Maintaining a Disaster Recovery Plan
Backup and recovery planning is key when implementing Microsoft SQL Server 2014; and knowing how to create and maintain a disaster recovery plan is crucial. In this video; Aaron Sampson demonstrates how to maintain a disaster recovery plan.
-
Managing a Reporting Services Database
After watching this video; you will be able to manage a reporting services database; including backup and restore; copying; and managing connections.
-
Managing Consolidated Resources for Multiple Instances
Microsoft SQL Server 2014 allows you to consolidate resources and provides tools to manage consolidated resources. In this video; Aaron Sampson demonstrates how to manage SQL Server resources for multiple instances that have been consolidated onto a single server.
-
Managing Consolidated Resources for Single Instances
Microsoft SQL Server 2014 has a number of enhancements and features aimed at private cloud deployment and management of SQL databases. This includes consolidation and management of consolidated resources. In this video; Aaron Sampson demonstrates how to manage consolidated SQL server resources for single instances.
-
Managing Consolidated Virtualized Resources
In SQL Server; every virtual machine needs processors and resources available for those virtual machines. In this video; Aaron Sampson discusses how to manage consolidated virtualized resources.
-
Managing Encryption Keys for Reporting Services
After watching this video; you will be able to manage encryption keys for Reporting Services.
-
Managing Jobs and Logins for an AlwaysOn Availability Group
In SQL Server; you can use AlwaysOn High Availability groups to connect to the databases. In this video; Aaron Sampson demonstrates how to manage the Jobs and Logins objects in the database server.
-
Managing Parent-Child Dimensions
After watching this video; you will be able to manage parent-child dimensions.
-
Managing Partitions in a Tabular Model
After watching this video; you will be able to manage partitions using Partitions Manager.
-
Managing Running Jobs for Reporting Services
After watching this video; you will be able to monitor the status of running jobs on the Report Server.
-
Managing Schedules for Reporting Services
After watching this video; you will be able to manage schedules; including pausing; resuming; and changing settings.
-
Managing the Visibility of Columns
After watching this video; you will be able to hide and freeze columns to manage their visibility.
-
Managing Transactions
Microsoft SQL Server 2014 makes it easier for you work by allowing the use of transactions. In this video; Rafiq Wayani demonstrates how to use SQL Server to create and rollback transactions.
-
MAP Toolkit Discovery and Inventory
In Microsoft SQL Server 2014; you can use the options within the MAP Toolkit to gather information about an environment for assessment. In this video; Aaron Sampson demonstrates the database discovery and inventory features of MAP Toolkit.
-
MAP Toolkit Hardware and Platform
In Microsoft SQL Server 2014; the Microsoft Assessment and Planning Toolkit is a powerful inventory; assessment; and reporting tool that helps you assess your current IT infrastructure to simplify the migration planning process. In this video; Aaron Sampson discusses the MAP Toolkit hardware and platform.
-
MAP Toolkit Overview
In SQL Server; you can use the Microsoft Assessment Planning (MAP) toolkit to determine whether the database is environment-ready to implement a new database. In this video; Aaron Sampson demonstrates the basic overview of MAP toolkit.
-
MAP Toolkit Reports
In Microsoft SQL Server 2014; you can use the options within the MAP Toolkit to generate detailed reports for different licensed editions such as SQL Server; Azure; or Oracle. In this video; Aaron Sampson demonstrates the reporting functionality in MAP Toolkit.
-
Merging Partitions in a Multidimensional Model
After watching this video; you will be able to merge partitions in a multidimensional model.
-
Modifying a Time Dimension Using the Designer
In Microsoft SQL Server 2014; you can modify a time dimension using the designer to give you a preview of what your information looks like. In this video; Aaron Sampson demonstrates how to modify a dimension structure using the designer to edit the data source view.
-
Modifying an Existing Report in Report Builder
After watching this video; you will be able to modify an existing report that was created in SQL Server Data Tools Report Builder.
-
Modifying and Deleting Subscriptions in Report Manager
After watching this video; you will be able to modify settings for subscriptions and delete them.
-
Monitoring and Clearing the SSAS Cache
After watching this video; you will be able to monitor and clear the SSAS cache.
-
Monitoring In-Memory OLTP Resources
In Microsoft SQL Server 2014; you can monitor in-memory OLTP tables in various ways. In this video; Rafiq Wayani demonstrates how to determine the memory required for in-memory tables; as well as how to use dynamic memory views to monitor the resources being used by the tables.
-
Monitoring Reporting Services with SQL Profiler
After watching this video; you will be able to monitor Reporting Services with SQL Profiler.
-
Monitoring SSAS Using Performance Counters
After watching this video; you will be able to monitor SSAS using different performance counters.
-
Normalization
In Microsoft SQL Server 2014; you can follow the concepts of database normalization to design your database. In this video; Aaron Sampson demonstrates the features; usage scenarios; and advantages of database normalization.
-
Optimizing MDX in Calculations
After watching this video; you will be able to optimize MDX queries in the calculations.
-
Optimizing MDX Queries
After watching this video; you will be able to optimize MDX queries using various methods.
-
Optimizing Performance of Cubes and Dimensions
After watching this video; you will be able to optimize performance by changing the design of the cube or dimension.
-
Optimizing Queries
Microsoft SQL Server 2014 has updated query optimization by re-writing the entire critical section of the query component. In this video; Rafiq Wayani demonstrates the changes that were made; and how to optimize your queries using the cardinality estimator in this new process.
-
Overview of BI Features with SharePoint
In this video; Aaron Sampson describes the Business Intelligence (BI) features with SharePoint in Microsoft SQL Server 2014.
-
Overview of SSAS in Multidimensional and Data Mining Mode
After watching this video; you will be able to explain the functionality OLAP and data mining provide for business intelligence.
-
Overview of SSAS in Tabular Mode
In this video; Aaron Sampson describes SQL Server Analysis Services (SSAS) in Tabular Mode in Microsoft SQL Server 2014.
-
Peer-to-Peer Transactional and Merge Replication
In Microsoft SQL Server 2014; you can plan for the backup and recovery of your servers in the event of an unforeseen situation to prevent data loss. In this video; Aaron Sampson demonstrates SQL Server 2014 Peer-to-Peer transactional and Merge Replication.
-
Performing a Backup to Windows Azure Blob Storage
SQL Server 2014 allows users to backup the database files to a Windows Azure storage account. In this video; Aaron Sampson explains how to upload backups to Windows Azure Blob storage.
-
Performing a Point-in-Time Restore
In SQL Server 2014; you can restore your databases to a specific point in time to avoid taking backups of any damage or corruption that may have occurred in the original file. In this video; Aaron Sampson explains how perform a point-in-time restore.
-
Performing an AlwaysOn Availability Group Manual Failover
In Microsoft SQL Server 2014; you can test the functionality of your availability group to ensure its services are available to the clients. In this video; Aaron Sampson demonstrates how to perform a manual failover of an availability group.
-
Planning a Report for Report Services
After watching this video; you will be able to describe what needs to be considered during planning to create a report; including the format; structure; data; calculations; and delivery among others.
-
Planning CPU and Memory
In Microsoft SQL Server 2014; Clock Speed; Cache Size; and Multi-core and Multi-threaded CPUs are the main considerations to gauge any Server's CPU performance. In this video; Aaron Sampson explains the standard values of CPUs to improve performance and allocating right memory to SQL Server.
-
Planning Policy-Based Management
In SQL Server; every policy you create has an associated evaluation mode. In this video; Aaron Sampson discusses how to plan policy-based management.
-
Planning Schemas
In Microsoft SQL Server 2014; you can use schemas to logically group your database objects; such as tables and views to administer them as single entity. In this video; Aaron Sampson demonstrates the function of schemas and best practices for implementing schemas.
-
Planning Storage and Networks
In Microsoft SQL Server 2014; There are multiple databases available for different storage requirements of different users; but assessing the right storage requirements can be challenging. In this video; Aaron Sampson explains how to assess storage requirements and various database types.
-
Planning Tables and Data Types
In Microsoft SQL Server 2014; tables are an important object that contains data. In this video; Aaron Sampson demonstrates tables and data types.
-
Policy-Based Management Overview
In SQL Server; you can perform policy-based management to create consistent server configurations. In this video; Aaron Sampson discusses how to implement policy-based management.
-
Preparing to Back Up a Multidimensional Database
After watching this video; you will be able to prepare to backup a multidimensional database.
-
Primary Key Constraints
While designing databases and tables in Microsoft SQL Server 2014; you need to consider the primary key constraints. In this video; Aaron Sampson explains some of the constraints associated with primary keys.
-
Processing a Partition in a Tabular Model
After watching this video; you will be able to process partitions using different modes.
-
Processing Partitions Using PowerShell
After watching this video; you will be able to use PowerShell to process and manage partitions.
-
Processing SSAS Objects Using XMLA
After watching this video; you will be able to use XMLA to process SSAS objects.
-
Publishing Reports to a Report Server
After watching this video; you will be able to publish reports to a Report Server.
-
Publishing Reports to a SharePoint Library
After watching this video; you will be able to publish reports to a SharePoint library.
-
Recovery Models and Compression
In Microsoft SQL Server 2014; you have recovery models that you can set on a per database level. In this video; Aaron Sampson discusses the recovery models and compression techniques.
-
Removing a Primary and Secondary from an AlwaysOn Availability Group
In Microsoft SQL Server 2014; you can make changes to the configuration of your availability groups. In this video; Aaron Sampson demonstrates how to remove primary or secondary systems or replicas from an availability group.
-
Removing an AlwaysOn Availability Group
In Microsoft SQL Server 2014; you can remove primary and secondary systems of a database. In this video; Aaron Sampson demonstrates how to remove an availability group.
-
Removing Features From a Prepared Instance
In Microsoft SQL Server 2014; you can remove features that have been added to a prepared instance via the uninstall menu in the Control Panel. In this video; Aaron Sampson demonstrates how to remove features from a prepared instance of Microsoft SQL Server 2014.
-
Replication Agents
In a Microsoft SQL Server 2014 environment; backup and recovery planning is essential; as well as knowing how to configure and manage SQL Server Replication. In this video; Aaron Sampson demonstrates the function of agents when configuring SQL Server 2014 for replication.
-
Replication Overview
In Microsoft SQL Server 2014; a backup and recovery plan is key during implementation; and knowing how to configure and manage SQL Server replication is crucial. In this video; Aaron Sampson demonstrates how to implement SQL Server replication.
-
Reporting Services Topologies and Configurations
After watching this video; you will be able to describe how a report server is interacted with depending on the deployment topology and configuration.
-
Restore Process
In Microsoft SQL Server 2014; you can use the restore processes along with the backup strategies. In this video; Aaron Sampson discusses the restore processes.
-
Restore Sequences
In Microsoft SQL Server 2014; you can create and use the restore sequences. In this video; Aaron Sampson discusses how to create restore sequences.
-
Restoring a Multidimensional Database
After watching this video; you will be able to restore a multidimensional database.
-
Restoring and Importing PowerPivot into a SSAS Instance
After watching this video; you will be able to restore and import a PowerPivot model into an SSAS instance.
-
Restoring from Windows Azure Blob Storage
You can restore your databases from the backups stored in the Azure storage account. In this video; Aaron Sampson demonstrates how to restore the databases from the stored backups.
-
Restricting MDX Queries with Query Axis
After watching this video; you will be able to specify the edges of a cellset to restrict the returned data that is visible to the client.
-
Restricting MDX Queries with Slicer Axis
After watching this video; you will be able to use the slicer axis to filter the data returned by an MDX SELECT query.
-
Returning Tuples from an MDX SELECT Statement
After watching this video; you will be able to use Tuple functions in a SELECT statement to return a tuple.
-
Saving Reports Using Report Builder
After watching this video; you will be able to save reports using Report Builder to a report server and SharePoint Library.
-
Securing Replication
In Microsoft SQL Server 2014; you need to ensure that a data backup and recovery solution can always be executed securely. In this video; Aaron Sampson demonstrates security considerations for data replication within a backup and recovery scenario.
-
Securing Reports Using Roles in Reporting Services
After watching this video; you will be able to secure a report using different types of roles.
-
Securing Shared Data Source Items in Reporting Services
After watching this video; you will be able to secure a shared data source.
-
Setting Up for Remote Partition Creation
After watching this video; you will be able to setup the configuration for remote partitions; including specifying valid server names; creating and deploying a secondary database; and enabling features in SQL Server Management Studio (SSMS).
-
Snapshot and Transactional Replication
In Microsoft SQL Server 2014; backup and recovery planning and knowing how to configure and manage SQL Server replication are crucial. In this video; Aaron Sampson demonstrates snapshot and transactional replication in Microsoft SQL Server 2014.
-
Sorting and Filtering Columns
After watching this video; you will be able to sort and filter columns.
-
SQL in the Public Cloud
In Microsoft SQL Server 2014; you can use the Windows Azure SQL Database; which is an open and flexible cloud platform; to quickly build and manage applications. In this video; Aaron Sampson discusses SQL in the public cloud.
-
SQL Private Cloud Elasticity and Self-Service
In Microsoft SQL Server 2014; a private cloud scenario provides an elastic and responsive environment so that you can respond to changes more easily than in a public cloud scenario. In this video; Aaron Sampson explains SQL private cloud elasticity and self-service.
-
SQL Private Cloud Policies and Metering
Microsoft SQL Server 2014 has a number of enhancements and features aimed at private cloud deployment and management of SQL databases including cloud configuration. In this video; Aaron Sampson demonstrates the process for enabling metering and enforcing policies in a SQL Server private cloud environment.
-
SQL Private Cloud Resource Pooling
In Microsoft SQL Server 2014; you need to assess your environment before considering the Private Cloud approach for resource pooling. In this video; Aaron Sampson explains Private Cloud and pooling of resources.
-
Suspending and Resuming an AlwaysOn Availability Database
In Microsoft SQL Server 2014; you can use the Suspend Data Movement feature to turn off the availability group. In this video; Aaron Sampson demonstrates how to pause an availability group.
-
System Center Advisor
In Microsoft SQL server; you can use system center advisor to evaluate the performance and stability of the database implementation. In this video; Aaron Sampson discusses how to use the system center advisor online service.
-
System Center Operations Manager
In Microsoft SQL Server 2014; you can use System Center Operations Manager that maintains and monitors the IT infrastructure of your application. In this video; Aaron Sampson demonstrates how the System Operations Manager can be used for management of SQL Server infrastructure.
-
System Center SQL Server Management Pack
In Microsoft SQL Server 2014; you can obtain the SQL Server Management Pack that monitors all versions of the SQL Server application. In this video; Aaron Sampson explains the uses and limitations of the SQL Server Management Pack.
-
Taking an AlwaysOn Availability Group Offline
In Microsoft SQL Server 2014; you can change the configuration of your availability groups to take it offline. In this video; Aaron Sampson demonstrates how to take an availability group offline.
-
Test Log Shipping
In Microsoft SQL Server 2014; after you enable log shipping between your primary and secondary servers; you can ensure that it is set up correctly and that it is functioning. In this video; Aaron Sampson demonstrates how to test log shipping.
-
Test Log Shipping Failover
In Microsoft SQL Server 2014; when you configure your log shipping environment; you need to simulate a failover and verify that you can use the log-shipped copy. In this video; Aaron Sampson demonstrates how to test log shipping failover.
-
Testing an SSAS Database Deployment
After watching this video; you will be able to test a database deployment.
-
Testing Policy-Based Management Compliance
You can use Microsoft SQL Server 2014 to test and evaluate policies to ensure they adhere to compliance rules. In this video; Aaron Sampson demonstrates how to test a policy-based management implementation for compliance.
-
Troubleshoot Dynamic Security Issues
After watching this video; you will be able to troubleshoot dynamic security issues in SSAS.
-
Troubleshooting and Resolving In-Memory OLTP Issues
In Microsoft SQL Server 2014; it’s important to be able to troubleshoot issues with in-memory OLTP tables. In this video; Rafiq Wayani demonstrates what you should look out for when creating these tables and how to resolve common issues.
-
Troubleshooting Database Size Issues
SQL Server 2014 contains various performance enhancements that help you troubleshoot database size issues. In this video; Rafiq Wayani demonstrates some of the changes from SQL Server 2012; and how they benefit you.
-
Understanding Dimensions in a Multidimensional Model
After watching this video; you will be able to describe a dimension and how it is used in a multidimensional model.
-
Understanding Fact Relationships in SSAS
In this video; Aaron Sampson describes fact relationships in SQL Server Analysis Services (SSAS) in Microsoft SQL Server 2014.
-
Understanding Many-to-Many Relationships in SSAS
In this video; Aaron Sampson describes many-to-many relationships in SQL Server Analysis Services (SSAS) in Microsoft SQL Server 2014.
-
Understanding MDX Queries on Multidimensional Models
After watching this video; you will be able to describe how MDX queries and expressions are used in SSAS.
-
Understanding Measures in a Multidimensional Model
In this video; Aaron Sampson describes the measures in a multidimensional model in Microsoft SQL Server 2014.
-
Understanding Proactive Caching for Partitions
After watching this video; you will be able to describe proactive caching for partitions.
-
Understanding Processing Options for SSAS Objects
After watching this video; you will be able to describe the different processing options available for SSAS objects; specifically full processing and incremental processing.
-
Understanding Referenced Relationships in SSAS
In this video; Aaron Sampson describes referenced relationships in SQL Server Analysis Services (SSAS) in Microsoft SQL Server 2014.
-
Understanding Report Server Security Architecture
After watching this video; you will be able to describe report server security architecture and site-level security.
-
Understanding Subscriptions for Reports in Reporting Services
After watching this video; you will be able to describe what requirements need to be met before a subscription can be created; the different extensions; and their parts.
-
Understanding the Different Data Sources for a Multidimensional Database
In Microsoft SQL Server Analysis Services; you do not store data in a multidimensional model. You define how you want to analyze the data; but the data comes from an external data warehouse; and so you need to analyze the data source. In this video; Aaron Sampson discusses the different data sources for a multidimensional database.
-
Understanding the Logical Architecture for Multidimensional Data
After watching this video; you will be able to describe the logical architecture.
-
Understanding the MDX SELECT Statement Syntax Part 1
After watching this video; you will be able to identify what is required in a SELECT statement to specify a result set and to identify the cube; query axis; and slices axis.
-
Understanding the MDX SELECT Statement Syntax Part 2
After watching this video; you will be able to identify the parts of the SELECT statement syntax.
-
Understanding the Storage Modes for Partitioning
After watching this video; you will be able to describe the storage modes used for partitions; including MOLAP; ROLAP; HOLAP.
-
Understanding the Tools Used to Create Models
After watching this video; you will be able to describe the environments available for building; deploying; and managing Analysis Services.
-
Updating an SSAS Instance
In this video; Aaron Sampson demonstrates how to update a SQL Server Analysis Services (SSAS) instance in Microsoft SQL Server 2014.
-
Upgrading an SSAS Instance
In this video; Aaron Sampson demonstrates how to upgrade a SQL Server Analysis Services (SSAS) instance in Microsoft SQL Server 2014.
-
Using a Additive Measure in a Cube
Microsoft SQL Server 2014 provides built-in aggregate functions that can be applied across each measure in a measure group to calculate data in an Analysis Services cube in an additive manner. In this video; Aaron Sampson demonstrates how additive measures are defined in a measure group with the implementation of Sum and Count aggregation functions.
-
Using a MDX Script to Import a Partial PowerPivot Model
After watching this video; you will be able to define a MDX script to import a partial PowerPivot model.
-
Using a Non-Additive Measure in a Cube
Microsoft SQL Server 2014 provides functions in a nonadditive measure that cannot be aggregated along any dimensions in a measure group in a cube. In this video; Aaron Sampson demonstrates how to set a measure's usage to a nonadditive function; before browsing the cube to demonstrate a nonadditive measure supplying a value without performing any calculations on the measure.
-
Using a Semi-Additive Measure in a Cube
Microsoft SQL Server 2014 allows you to define aggregation methods for individual measures in a cube by setting semiadditive behaviors. In this video; Aaron Sampson demonstrates how to use the Business Intelligence Wizard to define semiadditive behaviour for individual measures and turn off all semiadditive behaviour in a cube.
-
Using a Shared Dataset in a Report
After watching this video; you will be able to specify a shared dataset in a report.
-
Using Activity Monitor to Identify Issues
Microsoft SQL Server 2014's Activity Monitor allows the real-time monitoring of network; processor; and task-related processes. In this video; Rafiq Wayani demonstrates how to use Activity Monitor by running a query on a database and monitoring its resource usage.
-
Using an Existing Database to Create a New Project
In this video; Aaron Sampson describes how to create a new project in SQL Server Data Tools - Business Intelligence (SSDT-BI) environment.
-
Using Azure Storage Table Service
With Microsoft SQL Server 2014; you can use Microsoft Windows Azure's Storage Table Service as a handy storage tool for objects such as tables; Blobs and queues that are accessible from the cloud. In this video; Aaron Sampson demonstrates how to use the Windows Azure Storage Table Service to create cloud hosted table data stores.
-
Using Custom Expressions in a Data Source in Reporting Services
After watching this video; you will be able to use custom expressions in a data source.
-
Using DAX and MDX Queries to Create a Dataset in Reporting Services
After watching this video; you will be able to use a DAX query to create a dataset using the DAX Query Designer.
-
Using DMVs to Monitor SSAS
After watching this video; you will be able to monitor SSAS using different Dynamic Management Views (DMVs).
-
Using Extended Events
In SQL Server 2014; you can access Extended Events and view as much or as little information as you like. This helps you to identify and narrow down performance-related issues. In this video; Rafiq Wayani demonstrates how to view Extended Events using the Object Explorer.
-
Using KPIs in a Multidimensional Model - Part I
After watching this video; you will be able to describe and display KPIs.
-
Using KPIs in a Multidimensional Model - Part II
After watching this video; you will be able to describe and display KPIs.
-
Using MDX Queries to Create a Dataset in Reporting Services
After watching this video; you will be able to use an MDX query to create a dataset using the MDX Query Designer.
-
Using Number Functions in an MDX SELECT Statement
After watching this video; you will be able to identify and use number functions in an MDX SELECT statement to return specific results.
-
Using Ranking; Percentile; and Percentage of Total
After watching this video; you will be able to implement rank; percentile; and percentage of total using MDX.
-
Using Set Functions in an MDX SELECT Statement
After watching this video; you will be able to identify and use set functions in an MDX SELECT statement to return specific results.
-
Using SQL Profiler to Create Trace Files to Troubleshoot SSAS
After watching this video; you will be able to use SQL Profiler to create a trace to troubleshoot SSAS issues.
-
Using the CASE MDX Statement
After watching this video; you will be able to use the CASE statement to return specific results from multiple comparisons.
-
Using the Deployment Wizard to Deploy SSAS Databases
After watching this video; you will be able to use the deployment wizard to deploy an SSAS database.
-
Using the Report Wizard to Create a Report in Reporting Services
After watching this video; you will be able to use the Report Wizard to create a new report.
-
Using the SCOPE MDX Statement
After watching this video; you will be able to use the SCOPE statement to limit the scope of a MDX statement to a specified subcube.
-
Using the Synchronize Database Wizard
After watching this video; you will be able to use the Synchronize Database Wizard to synchronize metadata and data between two SSAS databases.
-
Using the TOPCOUNT Function in an MDX SELECT Statement
After watching this video; you will be able to use the TOPCOUNT function in an MDX SELECT statement.
-
Using Tuples in an MDX SELECT Statement
After watching this video; you will be able to use a tuple to identify a slice of data in a cube for a SELECT statement.
-
Using Windows Azure Blob Storage
In Microsoft SQL Server 2014; you can integrate a cloud storage solution such as Microsoft Windows Azure to provide storage for data objects; including binary large objects; or Blobs. In this video; Aaron Sampson demonstrates how to use the Windows Azure storage feature to upload Blobs to a cloud-hosted data store.
-
Validating Replication
In Microsoft SQL Server 2014; you can verify the replication after setting up the publication and subscription. In this video; Aaron Sampson demonstrates how to validate the replication processes.
-
Verifying a Disaster Recovery Plan
Backup and recovery planning is key when implementing Microsoft SQL Server 2014. Knowing how to create and maintain a disaster recovery plan is crucial. In this video; Aaron Sampson demonstrates the processes for verifying a disaster recovery plan.
-
Viewing Cube Data and Metadata in Cube Designer
SQL Server 2014 is a relational database management system that allows users to build applications and solutions. The Cube Designer in SQL Server Analysis Services is used to edit the properties of a cube; or to browse data contained by the cube. In this video; Aaron Sampson demonstrates how to navigate through the Cube Designer interface; using its various options.
-
Viewing Error and Event Logs to Troubleshoot SSAS
After watching this video; you will be able to view error and events logs to troubleshoot SSAS instances.
-
Viewing Report Services Log Files
After watching this video; you will be able to view Reporting Services log files.
-
Viewing Reports in Report Manager and a Browser
After watching this video; you will be able to find and view reports in Report Manager and a browser.
-
Viewing the Cube Schema in Cube Designer
In this video; Aaron Sampson describes the cube schema in an Analysis Services cube in Microsoft SQL Server 2014.
-
Windows Azure Architecture
In Microsoft SQL Server 2014; the cloud-based service Microsoft Azure offers many services to expand your SQL 2014 infrastructure into the cloud. In this video; Aaron Sampson explains Windows Azure architecture.
-
Windows Azure Services
In Microsoft SQL Server 2014; you can use the Windows Azure services to develop applications easily for all platforms. In this video; Aaron Sampson explains the features and benefits of the Windows Azure Storage services.
-
Windows Azure SQL Database Architecture
In Microsoft SQL Server 2014; the Azure SQL Database provides easy administration; scalability; and data protection. In this video; Aaron Sampson explains the Azure SQL Database architecture.
-
Windows Azure SQL Database Backup and Restore
You can backup and restore the cloud-based databases by using Microsoft SQL Server 2014. In this video; Aaron Sampson demonstrates how to backup and restore Windows Azure SQL databases.
-
Windows Azure SQL Database Management
In Microsoft SQL Server 2014; you can use Microsoft Windows Azure to do some basic administration directly from within Azure. In this video; Aaron Sampson demonstrates how to manage a Windows Azure SQL database using the Windows Azure Management Portal.
-
Windows Azure SQL Database Migration - Generating a T-SQL Script
In Microsoft SQL Server 2014; you can migrate existing on-premise databases into the cloud by using a Transact-SQL Script to assist in automating the process. In this video; Aaron Sampson demonstrates how to generate a T-SQL script.
-
Windows Azure SQL Database Migration - Running a T-SQL Script
In Microsoft SQL Server 2014; you can run the Migration script against your Azure subscription to move the database up into the cloud. In this video; Aaron Sampson demonstrates how to run a T-SQL script.
-
Windows Azure SQL Database Migration Using the Deploy Database Wizard
In Microsoft SQL Server 2014; if the on-premise database is in a good state to migrate to an Azure cloud-based environment without any problems; you can use the Deploy a Database to SQL Azure wizard. In this video; Aaron Sampson demonstrates how to use the Deploy Database wizard.
-
Windows Azure SQL Database Overview
In Microsoft SQL Server 2014; you can use SQL Databases in Azure to expand your database solutions into the cloud. In this video; Aaron Sampson explains the features and benefits of the Windows Azure SQL Database.
-
Windows Azure SQL Database Provisioning
In Microsoft SQL Server 2014; you can integrate a cloud computing solution such as Microsoft Windows Azure to benefit from cloud storage for VMs and applications. Windows Azure SQL Database is the public cloud SQL service. In this video; Aaron Sampson demonstrates how to provision a Windows Azure SQL database.
-
Windows Azure SQL Database Security
In Microsoft SQL Server 2014; databases in the cloud have security requirements because they are accessed via the Internet. In this video; Aaron Sampson discusses the security configuration options for Azure SQL Database.
-
Windows Azure SQL Database Server Provisioning
Suitable for use with Microsoft SQL Server 2014; Windows Azure is a cloud computing option that includes cloud storage; VMs; and applications. Windows Azure SQL Database is the public cloud SQL service. In this video; Aaron Sampson demonstrates how to provision a Windows Azure SQL Database server.
-
Windows Azure Storage Blob Service
In Microsoft SQL Server 2014; you can use the Windows Azure Storage Blob service to store anything that does not require any kind of structure; such as backups; virtual machines; and multimedia files. In this video; Aaron Sampson discusses the Blob service.
-
Windows Azure Storage Overview
In Microsoft SQL Server 2014; you can use the Windows Azure Storage to store and access data easily. In this video; Aaron Sampson explains how the Windows Azure Storage provides a variety of storage options for different types of data.
-
Windows Azure Storage Table Service
In Microsoft SQL Server 2014; you can use the Azure Table storage service to store large amounts of structured; non-relational data. In this video; Aaron Sampson explains the features and benefits of the Windows Azure Storage Table service.
-
Windows Azure VM Connect to SQL Server on VM
You can access the virtual machine running SQL Server either from a remote desktop or via SQL Server Management Studio on a local system. In this video; Aaron Sampson demonstrates how to connect to a VM running SQL Server through the Windows Azure interface.
-
Windows Azure VM Connecting to a VM
In addition to Windows Azure SQL Database; Windows Azure itself allows you to configure and manage a virtual machine (VM) dedicated to running an instance of Microsoft SQL Server 2014. In this video; Aaron Sampson demonstrates how to connect to a VM that you've created on Windows Azure.
-
Windows Azure VM Create a TCP Endpoint
In Microsoft SQL Server 2014; you can use Windows Azure to configure and manage a VM dedicated to running an instance of SQL Server. In this video; Aaron Sampson demonstrates how to create a TCP endpoint on Windows Azure.
-
Windows Azure VM Creating a VM
In Microsoft SQL Server 2014; you can create and configure a virtual machine (VM) and then install SQL. In this video; Aaron Sampson demonstrates how to create a VM on Windows Azure.
-
Windows Azure VM Disks and Images
In SQL Server; you can have more than one additional data disk on any given virtual machine. In this video; Aaron Sampson discusses Windows Azure VM disks and images.
-
Windows Azure VM Overview
Microsoft Azure gives you the option of creating a database and the configuration options of a full server. In this video; Aaron Sampson discusses the Azure Virtual Machine configuration options for supporting your cloud-based SQL implementations.
-
Windows Azure VM Security
In Microsoft SQL Server 2014; you can use Windows Azure to configure and manage a virtual machine (VM) dedicated to running an instance of SQL Server. In this video; Aaron Sampson demonstrates how to configure security for a VM on Windows Azure.
-
Windows Server Failover Clustering Overview
Microsoft SQL Server 2014 offers high-availability solutions in the form of clusters to provide services in the event of a failure of one or more cluster members. In this video; Aaron Sampson discusses the Windows Failover Clustering feature.
-
WSFC Processes
Microsoft SQL Server 2014 provides the cluster failover feature; which helps you to provide services to clients even when one or more cluster members fail. In this video; Aaron Sampson discusses the WSFC processes.
-
WSFC Quorum
In Microsoft SQL Server 2014; when you implement a cluster; the cluster can continue to service client requests based on the quorum; which indicates the consensus that enough servers still left running to carry the load generated by the clients. In this video; Aaron Sampson discusses the WSFC quorum.
-
Designing a Recovery Strategy
After watching this video; you will be able to design a recovery strategy for SSAS and SSRS databases.
-
Aggregation Performance Design
After watching this video; you will be able to determine if aggregation operations should be completed directly in the SSIS pipeline or in the relational database.
-
AlwaysON Availability Groups and Interoperability
After watching this video; you will be able to describe how AlwaysON Availability Groups can be used with SSAS and SSRS.
-
Analytical Data Models and Reporting
After watching this video; you will be able to describe analytical data models and the reporting and analysis element in a BI infrastructure.
-
Authentication Mechanisms
After watching this video; you will be able to describe the different authentication mechanisms supported by SSAS.
-
Backing Up and Restoring the SSIS Catalog
After watching this video; you will be able to backup and restore the SSIS catalog; including moving it.
-
Backing Up SSAS Databases
After watching this video; you will be able to perform a backup of SSAS databases.
-
Backing Up SSRS Databases
After watching this video; you will be able to perform a backup of the SSRS databases.
-
BI Infrastructure Upgrade Considerations
After watching this video; you will be able to describe the considerations and guidelines for updating an existing BI solution.
-
Business Intelligence Semantic Models
After watching this video; you will be able to describe the two types of BISM data models and how they can be used to create a unified Analysis Services platform.
-
Choosing the Appropriate Schema for a Data Model
After watching this video; you will be able to choose between a star and snowflake schema for a multidimensional data model.
-
Common Reporting Scenarios for BI Solutions
After watching this video; you will be able to describe the key characteristics of common reporting scenarios used for BI solutions.
-
Configuring Binding Options for Partitions
After watching this video; you will be able to configure binding options for partitions.
-
Configuring Data Compression on Fact Table Partitions
After watching this video; you will be able to configure data compression options on fact table partitions.
-
Configuring Data Refresh for PowerPivot
After watching this video; you will be able to configure data refresh schedules for PowerPivot published to SharePoint and perform an interactive refresh.
-
Configuring External Access to SSAS (Part 1)
After watching this video; you will be able to describe granting access to external users using HTTP and verify the prerequisites in IIS.
-
Configuring External Access to SSAS (Part 2)
After watching this video; you will be able to configure external access to SSAS using HTTP by creating the application pool; virtual directory in IIS; and configure IIS authentication.
-
Configuring External Access to SSAS (Part 3)
After watching this video; you will be able to configure external access to SSAS using HTTP by granting data access permissions and then testing the configuration.
-
Configuring Logging in an ETL Process
After watching this video; you will be able to configure logging within an ETL package; container; and task to capture run-time information.
-
Configuring Memory Setting for Reporting Services
After watching this video; you will be able to configure memory settings for Reporting Services to ensure optimal performance.
-
Configuring Package and Project Deployment Security
After watching this video; you will be able to configure security on packages requiring different security requirements.
-
Configuring PowerPivot
After watching this video; you will be able to configure PowerPivot using the PowerPivot for SharePoint 2013 Configuration tool.
-
Configuring Relationships Between Tables
After watching this video; you will be able to design and configure relationships between tables.
-
Configuring SSAS for Trusted Delegation
After watching this video; you will be able to configure SSAS for trusted delegation using Kerberos.
-
Configuring SSAS to Allow for Impersonation
After watching this video; you will be able to configure SSAS to allow for impersonation using Kerberos.
-
Create and Publish a Report to SharePoint
After watching this video; you will be able to create and publish a report using Power View to SharePoint.
-
Creating a Cube for a Multidimensional Model
After watching this video; you will be able to use the cube wizard to create a cube for a multidimensional model.
-
Creating a Data Alert
After watching this video; you will be able to create a data alert for a report in a SharePoint library.
-
Creating a Data Source for Analytical Models
After watching this video; you will be able to create data sources and data source views; including relationships; for analytical models.
-
Creating a Package Deployment Utility
After watching this video; you will be able to build the SSIS project to create a package deployment utility with the packages for deployment.
-
Creating a Subscription for SSRS in SharePoint Mode
After watching this video; you will be able to create a subscription for Report Servers in SharePoint mode to deliver a report to a library.
-
Creating and Managing Schedules in Native Mode
After watching this video; you will be able to create and manage a schedule for Reporting Services in native mode using Report Manager.
-
Creating Datasets Using Query Parameters
After watching this video; you will be able to create a data set using query parameters.
-
Creating Indexes and Assess their Performance
After watching this video; you will be able to create indexes and assess their performance.
-
Creating Package Configuration Files
After watching this video; you will be able to use package configuration files to modify the properties of package elements at run time.
-
Creating Partitions for a Cube
After watching this video; you will be able to create partitions for a cube; including specifying the aggregations and storage.
-
Creating Query-Scoped Calculated Members
After watching this video; you will be able to create query-scoped calculated members using the WITH keyword.
-
Creating Roles for Access at Different Levels
After watching this video; you will be able to create roles and define permissions to grant access at different levels for multidimensional models.
-
Creating Session-Scoped Calculated Members
After watching this video; you will be able to create session-scoped calculated members using the CREATE MEMBER statement.
-
Creating Shared and Embedded Data Sources
After watching this video; you will be able to create a shared or embedded data source.
-
Creating Stored Credentials
After watching this video; you will be able to create stored credentials to determine who can access the data in the report.
-
Creating Tables in a Tabular Model Part 1
After watching this video; you will be able to import tables and configure relationships and measures for a tabular model.
-
Creating Tables in a Tabular Model Part 2
After watching this video; you will be able to design and configure attributes and dimensions for a tabular model.
-
Customizing Data Acquisition Using DAX
After watching this video; you will be able to customize data acquisition using DAX with reporting services data sources.
-
Data Warehouse and ETL Solution for a BI Infrastructure
After watching this video; you will be able to describe a data warehouse and ETL for a BI infrastructure.
-
Data Warehouse Database Design
After watching this video; you will be able to describe the key tasks and steps in designing a data warehouse database in a BI project.
-
Defining Measure Groups
After watching this video; you will be able to define measure groups.
-
Defining Measures
After watching this video; you will be able to configure measures; including identifying the aggregation method.
-
Designing a Data Acquisition Strategy
After watching this video; you will be able to design a data movement strategy and profile source data.
-
Designing a Relational Model for a Data Mart
After watching this video; you will be able to identify how to design a relational model for a Data Mart.
-
Designing Aggregations for Partitions
After watching this video; you will be able to design aggregations strategies for separate partitions.
-
Designing AlwaysON Availability Groups
After watching this video; you will be able to describe how AlwaysON Availability Groups can be used for high availability for a SQL Server instance.
-
Designing an AlwaysON Failover Cluster Instance
After watching this video; you will be able to describe how AlwaysON Failover Cluster Instances can be used to ensure high availability for a SQL Server instance.
-
Designing and Configuring Dimensions
After watching this video; you will be able to design and configure dimensions in a multidimensional model.
-
Designing and Configuring Write Back for a Cube
After watching this video; you will be able to design and configure write back for a cube.
-
Designing and Creating a Drill-through Report
After watching this video; you will be able to design and create a drill-through report.
-
Designing and Creating a Report with a Map
After watching this video; you will be able to design map visualization and create a report with a map.
-
Designing and Creating Aggregations
After watching this video; you will be able to design and create aggregations to improve cube performance.
-
Designing and Creating Linked Reports
After watching this video; you will be able to design and create linked reports; including sub-reports.
-
Designing and Creating Report Templates
After watching this video; you will be able to design and create a report template to ensure report consistency.
-
Designing Cubes for Drill-Through
After watching this video; you will be able to design and configure cubes for drill-through.
-
Designing Data Retention
After watching this video; you will be able to design for data retention .
-
Designing Data Sources and Data Sets
After watching this video; you will be able to describe the considerations for designing data source and data sets for a report.
-
Designing Data Sources for Analytical Models
After watching this video; you will be able to design data sources for analytical models; including the types of data source and the considerations.
-
Designing Dimension Keys; Attributes; and Hierarchies
After watching this video; you will be able to design dimension keys; attributes; and hierarchies; given a scenario.
-
Designing Dimension Modeling and Documentation
After watching this video; you will be able to design a dimensional model for the business process using a matrix design and document it.
-
Designing for High Availability
After watching this video; you will be able to plan for high availability for a BI solution.
-
Designing for Specific Types of Reports
After watching this video; you will be able to design for specific report types; including interactive; graphical; and report rendering.
-
Designing Indexes and Index Views for Processing
After watching this video; you will be able to design indexes; index views; and order by statements for SSAS processing.
-
Designing MDX Calculations
After watching this video; you will be able to describe the key concepts in MDX.
-
Designing Multidimensional Cubes
After watching this video; you will be able to describe how to plan for a multidimensional cube.
-
Designing Partition Strategies for a Cube
After watching this video; you will be able to choose the appropriate partitioning strategy for a cube.
-
Designing Proactive Caching within SSAS
After watching this video; you will be able to determine the appropriate Proactive Caching method within SSAS for different scenarios.
-
Designing Scaling for a BI Solution
After watching this video; you will be able to plan for scaling out a BI solution.
-
Designing Self-Referencing Dimension Tables
After watching this video; you will be able to design self-referencing dimension tables based on a scenario.
-
Designing Slowly Changing Data and Unknown Values
After watching this video; you will be able to design slowly changing data and unknown values for a dimension.
-
Designing Time Dimension Tables
After watching this video; you will be able to design time dimension tables based on a scenario.
-
Determining Storage Requirements
After watching this video; you will be able to determine the storage requirements for a data warehouse database.
-
Enabling Logging for Package Execution in SSIS
After watching this video; you will be able to enable logging for package execution on the SSIS server.
-
Enabling Report Server Content Types to a Library
After watching this video; you will be able to enable Report Server content types to a SharePoint library.
-
Estimate MCR; CPU and Memory Requirements
After watching this video; you will be able to determine the MCR; CPU; and RAM requirements for a data warehouse database.
-
ETL Data Flow Architectures
After watching this video; you will be able to describe the common ETL data flow architectures used in a BI Project.
-
Examining the Source Data for the ETL Solution
After watching this video; you will be able to describe the considerations that affect the design of data extraction from the data sources.
-
Handling Errors and Audit Information
After watching this video; you will be able to handle errors through error handling techniques and log audit information.
-
Handling Invalid Rows
After watching this video; you will be able to handle invalid rows by redirecting the rows.
-
Identifying Common MDX Functions
After watching this video; you will be able to describe the common MDX functions.
-
Implementing Change Data Capture
After watching this video; you will be able to design ETL solutions to support change data capture.
-
Implementing Data Compression
After watching this video; you will be able to implement compression.
-
Implementing Dynamic Dimension Security
After watching this video; you will be able to implement Dynamic Dimension Security within a cube.
-
Implementing Slowly Changing Dimensions
After watching this video; you will be able to design the ETL solution to support slowly changing dimensions (SCD).
-
Installing Packages to the File System or Instance
After watching this video; you will be able to copy the deployment folder and run the Package Installation Wizard to install packages to the file system or instance.
-
Installing Reporting Services in SharePoint Mode
After watching this video; you will be able to install Reporting Services in SharePoint mode to enable and use Power View.
-
Installing the PowerPivot for SharePoint Add-in
After watching this video; you will be able to install the PowerPivot for SharePoint add-in to add additional functionality.
-
Installing the Reporting Services Add-in for SharePoint
After watching this video; you will be able to install the Reporting Services add-in for SharePoint.
-
Loading Partitioned Fact Tables
After watching this video; you will be able to load partitioned fact tables using best practices for an optimal load.
-
Managing Data Rights and Security for a Data Set
After watching this video; you will be able to manage data rights and security for a data set.
-
Managing Datasets Using Stored Procedures
After watching this video; you will be able to manage datasets using store procedures.
-
Managing Scope and Context
After watching this video; you will be able to use the CALCULATE and SCOPE statements as well as the THIS function.
-
Managing the SSIS Catalog
After watching this video; you will be able to manage the SSIS catalog; including the modifying the catalog properties.
-
Microsoft Products Roles in the BI Infrastructure
After watching this video; you will be able to describe the role Windows Server; SQL Server; SharePoint; and Office applications play in a BI infrastructure.
-
Monitoring a Data Warehouse Using Performance Monitor
After watching this video; you will be able to use Performance Monitor to troubleshoot data warehouse performance issues.
-
Optimizing SSRS Performance Using Caching and Snapshots
After watching this video; you will be able to configure caching for a report and monitor its affects using SQL Server Profiler.
-
Overview of Building a BI Project
After watching this video; you will be able to describe the key features in a BI project.
-
Overview of SharePoint Integration Mode Features
After watching this video; you will be able to describe the features provided when SharePoint is integrated with a BI Solution.
-
Performing a Searched Case Statement
After watching this video; you will be able to perform a searched case statement to evaluate a set of Boolean expressions to return specific values.
-
Performing a Simple Case Statement
After watching this video; you will be able to perform a simple case statement to compare an expression to a set of simple expressions to return specific values.
-
Planning a Subscription Strategy
After watching this video; you will be able to plan a subscription strategy for report delivery.
-
Planning Data Compression
After watching this video; you will be able to describe data compression and its benefits.
-
Planning Data Refresh for PowerPivot
After watching this video; you will be able to plan for data refresh for PowerPivot in SharePoint; including security.
-
Planning Database File Storage
After watching this video; you will be able to describe causes of data warehouse I/O activity and the considerations for placement of database files.
-
Planning for Data Alerts
After watching this video; you will be able to describe what data alerts are and how to use them.
-
Planning for Incremental Loads and Full Loads
After watching this video; you will be able to determine whether to use an incremental load or a full load on the data.
-
Planning for Report Delivery
After watching this video; you will be able to plan for report delivery; including planning for security.
-
Planning for the Size and Workload
After watching this video; you will be able to plan system sizing and workload for a BI infrastructure.
-
Planning Indexes for Queries
After watching this video; you will be able to describe the considerations for using indexes and the types of indexes.
-
Planning Schedules for Report Processing
After watching this video; you will be able to describe the two types of schedules; what you can accomplish with them; and how they work.
-
Planning Security for Report Processing
After watching this video; you will be able to describe the requirements for security for report processing and scheduling; including credentials for data sources and accounts.
-
Planning Table Partitioning
After watching this video; you will be able to describe table partitioning; including benefits; and create a partitioned table.
-
Planning Views
After watching this video; you will be able to describe the guidelines for planning views and create views based on them.
-
Publishing and Accessing a Workbook Using PowerPivet
After watching this video; you will be able to use a PowerPivot workbook and publish it to SharePoint.
-
Reducing Load Times and Plan Extraction Windows
After watching this video; you will be able to describe how to minimize the load times and hardware resource utilization; and plan the extraction windows.
-
Reporting and Analysis Design in a BI Solution
After watching this video; you will be able to describe how reporting and analysis fit into a BI solution and how data sources are used.
-
Requirements for SSRS Configurations
After watching this video; you will be able to describe the requirements; hardware and software; for the different SSRS configurations.
-
Restoring SSAS Databases
After watching this video; you will be able to perform a restore of a SSAS database.
-
Restoring SSRS Databases
After watching this video; you will be able to perform a restore of the SSRS databases.
-
Setting Processing Options for Reports
After watching this video; you will be able to set different processing options for reports in a SharePoint library; including caching; time-out; history options and limits; and database time-out options.
-
Setting Up a Server Environment for a Project
After watching this video; you will be able to set up a server environment to specify runtime values for packages within a project.
-
SharePoint Infrastructure Design in a BI Solution
After watching this video; you will be able to describe how SharePoint Server can fit into a BI Solution and the supported topologies.
-
SQL Server BI Topologies
After watching this video; you will be able to describe the different types of server topologies for a BI solution.
-
SQL Server High Availability Solutions
After watching this video; you will be able to describe the high availability solutions that can be used by SQL Server.
-
Testing for Impersonated or Delegated Identity
After watching this video; you will be able to use SQL Server Profiler to test for impersonated or delegated identity.
-
The BI Infrastructure Data Sources
After watching this video; you will be able to describe the elements of a BI infrastructure and explain data sources.
-
The Infrastructure and Personnel to Build a BI Project
After watching this video; you will be able to describe the applications; development; and test infrastructure as well as the personnel to build the BI project.
-
The MDX Query Structure
After watching this video; you will be able to describe the basic structure of an MDX query.
-
The Project Deployment Model
After watching this video; you will be able to describe the differences between the package deployment model and the project deployment model; and project deployment model features.
-
The Reporting Requirements for a BI Solution
After watching this video; you will be able to describe the key considerations for reports in a BI solution.
-
The Reporting Services Infrastructure
After watching this video; you will be able to describe the Reporting Services infrastructure.
-
The Reporting Services Modes
After watching this video; you will be able to describe the Reporting Services modes and when to choose a mode; given a scenario.
-
Tools Used for Report Creation and Delivery Part 1
After watching this video; you will be able to describe the tools offered to create and delivery reports.
-
Tools Used for Report Creation and Delivery Part 2
After watching this video; you will be able to describe how SharePoint can be used for reporting and describe the guidelines for choosing the correct reporting tool.
-
Transformations in an ETL Solution
After watching this video; you will be able to identify where transformations should take place and determine which transformation should be used.
-
Types of Columns for a Fact Table
After watching this video; you will be able to describe the types of columns in a fact table and how to determine the level of grain.
-
Types of Measures Stored and Common Fact Tables
After watching this video; you will be able to describe the types of measures in a fact table and the types of fact tables commonly used.
-
Understanding the SharePoint Server Integration Steps
After watching this video; you will be able to describe the steps taken to fully integrate SharePoint Server with a BI solution.
-
Using Catalog Stored Procedure and Views for Logging
After watching this video; you will be able to use catalog stored procedures and views to manage SSIS objects.
-
Using Data Collector to Gather Performance Data
After watching this video; you will be able to use Data Collector to monitor a SQL Server instance by gathering performance-related data.
-
Using DAX Queries in Datasets
After watching this video; you will be able to create appropriate DAX queries for an application.
-
Using MDX Set Functions (Part 1)
After watching this video; you will be able to use MDX set functions.
-
Using MDX Set Functions (Part 2)
After watching this video; you will be able to use MDX set functions.
-
Using MDX to Extract Data
After watching this video; you will be able to extract data from analysis services by using MDX queries.
-
Using MDX Tuple Functions
After watching this video; you will be able to use MDX tuple functions.
-
Using Parameters in Packages
After watching this video; you will be able to use parameters in packages; including sharing them.
-
Using Performance Monitor to Monitor SSRS
After watching this video; you will be able to use Performance Monitor to monitor SSRS performance.
-
Using Performance Monitor to Troubleshoot SSAS
After watching this video; you will be able to use Performance Monitor to troubleshoot SSAS performance.
-
Using Resource Governor to Balance Load Resources
After watching this video; you will be able to use Resource Governor to balance load resources for an ETL load process.
-
Using SQL Server Profiler to Monitor DAX Queries
After watching this video; you will be able to use SQL Server Profiler to analyze and optimize performance of DAX queries.
-
Using SQL Server Profiler to Monitor MDX Queries
After watching this video; you will be able to use SQL Server Profiler to analyze and optimize performance of MDX queries.
-
Using the Balanced Data Distributor Transformation
After watching this video; you will be able to use the Balanced Data Distributor; BDD; transformation to optimize package execution.
-
Using the Integration Service Deployment Wizard
After watching this video; you will be able to use the Integration Service Deployment Wizard to deploy projects to the SSISDB catalog using the project deployment model.
-
Viewing Log Entries in the Log Events Windows
After watching this video; you will be able to view log entries that are written after a package is run in the Log Events Window.
-
Viewing Package Execution Reports
After watching this video; you will be able to view package execution reports provided by the SSIS catalog.
-
Choosing the Appropriate BISM
After watching this video; you will be able to describe the considerations for choosing an analytical data model for an SSAS solution.
-
Creating a Subscription for SSRS in Native Mode
After watching this video; you will be able to create a subscription for Report Servers in native mode.
-
Business Intelligence Overview
In Microsoft SQL Server data warehousing; you have easy access to the right data. In this video; David Dye; uses the business intelligence (BI) stack to define BI and discuss the integration and loading of data into a data warehouse.
-
Connecting SSRS to a Data Source
Microsoft SQL Server offers features; such as Report Builder and Data Tools; which allow you to connect to data sources and create reports. In this video; David Dye demonstrates how to connect Reporting Services to a data source; and then use SQL server Report Builder and Data Tools to create a Reporting Services report.
-
Creating a Columnstore Index
In Microsoft SQL Server; there is more than one way to create your columnstore indexes. In this video; David Dye demonstrates how to use the New Index feature to create a non-clustered columnstore index.
-
Creating a Control Flow
In Microsoft SQL Server; a Control Flow is a system which organises the processing order of tasks. This sequence is customizable. In this video; David Dye demonstrates how to add a Script Control Flow Task within SQL Server integrated services.
-
Creating a Data Flow
In Microsoft SQL Server; creating a Data Flow Task is an area that can often cause confusion. In this video; David Dye demonstrates how to set up an integrated services Data Flow task between a SQL Server source and host instance.
-
Creating a Dimension Table
In Microsoft SQL Server; there's more than one way to create a dimension table. In this video; David Dye demonstrates how to use the Table Designer to create a dimension table.
-
Creating a Fact Table
In Microsoft SQL Server data warehousing; there is more than one way to create a fact table. In this video; David Dye demonstrates how to use the Data Definition Language (DDL) to create a fact table.
-
Creating a Report
Microsoft SQL Server Data Tools allows you to easily create Reporting Services reports; which can vary from simple to in depth; depending on your requirements. In this video; David Dye demonstrates how to use Data Tools to create a simple Reporting Services report.
-
Creating a Report with Calculations
In Microsoft SQL Server; you can easily create a Reporting Services report embedded with operations to extend the functionality of the Reporting Services. In this video; David Dye demonstrates how to create a Reporting Services report which includes an embedded calculation.
-
Creating a Report with End User Interactivity
Using Microsoft SQL Server; you can create reports with various kinds of end user interactivity. In this video; David Dye demonstrates how to create a report that allows the end user to toggle through the data; as well as a report that allows the end user to drill down into the data.
-
Creating a Simple SSIS Package
In Microsoft SQL Server; there are a number of considerations to be aware of when creating a Simple Integration Services (SSIS) Package. In this video; David Dye demonstrates how to create an SSIS package; add control or data flow; and implement mapping.
-
Creating a Transform
The Data Flow within Microsoft SQL Server moves data between sources and destinations allowing for a user to transform data as it is moved. In this video; David Dye demonstrates how to create a Data Flow transformation task within an Integration Services Package.
-
Creating an SSAS Cube
In Microsoft SQL Server; creating Analysis Services Cubes based on data source views allows you to easily analyze data sets of related measures and dimensions. In this video; David Dye demonstrates how to create an Analysis Service Cubes using a previously defined data source view.
-
Creating an SSAS Data Source
After creating a multidimensional Analysis Services project in Microsoft SQL Server 2014; you need to prepare the database by creating data sources and data source views to control the data structures used in the project. In this video; David Dye uses wizards in SQL Server Data Tools to create a data source and data source view within a multidimensional cube.
-
Creating an SSAS Project
When designing business intelligence applications in Microsoft SQL Server 2014; the Analysis Services project templates in SQL Service Data Tools (SSDT) allow you to easily define multidimensional models. In this video; David Dye demonstrates how to create a new multidimensional cube structure using a template from the SSIS Toolbox from within Microsoft Visual Studio.
-
Data Warehouse Schemas
In Microsoft SQL Server data warehousing and business intelligence; your data warehouse can consist of a star or snowflake schema. In this video; David Dye demonstrates how to use the New Database Diagram feature to create these two different types of schemas.
-
Data Warehousing Overview
In Microsoft SQL Server; you can implement and load a data warehouse. In this video; David Dye uses data warehouse architectures to discuss a centralized data warehouse; a department data mart; and the hub and spoke architecture elements.
-
Deploying an SSIS Package
Microsoft SQL Server 2014 allows you to deploy an Integration Services package to either the SSIS catalog or to the msdb database using either the project deployment model or package deployment model. In this video; David Dye demonstrates how to use the Integration Services Deployment Wizard and the Package Installation Wizard to deploy projects and packages from Solution Explorer.
-
Deploying Reports
Once you have created your reports on Microsoft SQL Server you can deploy them out to Report Manager. In this video; David Dye demonstrates how to upload a report and deploy it to Report Manager for use and management.
-
Deploying SSAS
In Microsoft SQL Server; after creating a multidimensional cube you can deploy it to Analysis Services for further utilization. In this video; David Dye demonstrates how to deploy and process a multidimensional cube to Analysis Services.
-
Fact and Dimension Tables
In Microsoft SQL Server data warehousing and business intelligence; you have fact and dimension tables. In this video; David Dye uses a data warehouse to distinguish between a fact and a dimension table.
-
Implementing Table and Index Partitioning
In Microsoft SQL Server; it may become necessary to partition a table within a table or an index to help spread data across multiple different file groups. In this video; David Dye demonstrates how to implement a table or index partition.
-
Normalization and Denormalization
In Microsoft SQL Server data warehousing and business intelligence; you can denormalize a data warehouse. In this video; David Dye uses a data warehouse to explain normalization and denormalization.
-
Querying SSAS
Microsoft SQL Server and Excel allow you to query multidimensional cubes and display the desired data in interactive or two-dimensional reports depending on the requirements of the user. In this video; David Dye demonstrates how to use Excel to query a multidimensional cube from within Analysis Services.
-
Backup Strategies
In Microsoft SQL Server 2014; you can use different methods to back up your databases. In this video; Aaron Sampson discusses about the backup strategies.
-
Implementing Data Compression
In Microsoft SQL Server; in order to conserve space; it may be necessary to compress data on occasion. In this video; David Dye demonstrates how to compress selected data; as well as the options available when implementing compression.
-
Performing a Restore
There are several considerations to restore a database after creating a backup. In this video; Aaron Sampson explains how perform a restore.
-
Creating and Managing Schedules in Native Mode
After watching this video; you will be able to create and manage a schedule for Reporting Services in SharePoint mode using Central Administration.
-
Understanding the Logical Architecture for Multidimensional Data
A cube is a logical representation of a multidimensional structure for analysis purposes. In this video; Aaron Sampson discusses the architecture of a cube in Microsoft SQL Server 2014.
-
Performing a Backup
In Microsoft SQL Server 2014; you can create a database backup either through the use of SQL Server Agent Jobs or through the one-time backup feature. In this video; Aaron Sampson demonstrates how to create a database backup.
-
Private Clouds
In Microsoft SQL Server 2014; you can take advantage of the benefits and features of cloud computing by implementing private cloud solutions. In this video; Aaron Sampson discusses the benefits of private cloud computing solutions.
-
Installing PowerPivot for SharePoint
In this video; Aaron Sampson demonstrates how to install the SQL Server PowerPivot for SharePoint in Microsoft SQL Server 2014.
-
Implementing Replication
In Microsoft SQL Server 2014; you can configure the replication process to ensure that the databases are distributing the correct content to the appropriate recipients. In this video; Aaron Sampson demonstrates how to configure replication in Microsoft SQL Server 2014.
-
WSFC Quorum
In SQL Server; you can use the cluster storage. In this video; Aaron Sampson discusses WSFC cluster storage.In SQL Server; you can use the cluster storage. In this video; Aaron Sampson discusses WSFC cluster storage.
-
SQL Server 2014: Installing Integration Services
After watching this video, you will be able to install integration services using the setup wizard.
-
SQL Server 2014: Integration Services Configuration Options
After watching this video, you will be able to recognize the various SSIS configurations.
-
SQL Server 2014: Development Box and Server
After watching this video, you will be able to describe when and how to use the development box and server.
-
SQL Server 2014: SSIS Designer
After watching this video, you will be able to use the SSIS designer graphical tool.
-
SQL Server 2014: Preparing to Install Integration Services
After watching this video, you will be able to prepare to install integration services.
-
SQL Server 2014: SSIS Components
After watching this video, you will be able to describe SSIS components.
-
SQL Server 2014: Use SSIS Custom Components and SCD
After watching this video, you will be able to use SSIS custom components and SCD.
-
SQL Server 2014: Destination Components
After watching this video, you will be able to decide when it is appropriate to use a script component vs. a built-in destination component.
-
SQL Server 2014: Transformation Components
After watching this video, you will be able to decide when it is appropriate to use a script component vs. a built-in transformation component.
-
SQL Server 2014: Error Messages
After watching this video, you will be able to describe how to resolve potential error messages.
-
SQL Server 2014: Web Service Source and Destination
After watching this video, you will be able to describe use cases such as web service source and destination.
-
SQL Server 2014: Script Components in SSIS
After watching this video, you will be able to describe script components in SSIS.
-
SQL Server 2014: SCD Changes
After watching this video, you will be able to describe types of SCD changes.
-
SQL Server 2014: Source Components
After watching this video, you will be able to decide when it is appropriate to use a script component vs. a built-in source component.
-
SQL Server 2014: Load Partitioned Tables
After watching this video, you will be able to select appropriate load partitioned tables.
-
SQL Server 2014: Load Technique: T-SQL
After watching this video, you will be able to select an appropriate load technique (T-SQL).
-
SQL Server 2014: Load Technique: SSIS Destination
After watching this video, you will be able to select an appropriate load technique (SSIS Destination).
-
SQL Server 2014: Data Mart: Incremental Updates
After watching this video, you will be able to plan for an incremental update of the relational data mart.
-
SQL Server 2014: Data Mart
After watching this video, you will be able to describe data mart.
-
SQL Server 2014: Bulk Load Options
After watching this video, you will be able to configure bulk load options.
-
SQL Server 2014: Indexed Tables
After watching this video, you will be able to plan for loads into indexed tables.
-
SQL Server 2014: Data Loading
After watching this video, you will be able to describe data loading.
-
SQL Server 2014: Full Data Load Strategy
After watching this video, you will be able to perform a full data load strategy.
-
SQL Server 2014: Incremental Data Load Strategy
After watching this video, you will be able to perform an incremental data load strategy.
-
SQL Server 2014: Install Integration Services
After watching this video, you will be able to install integration services using the setup wizard.
-
SQL Server 2014: Catalog Configuration
After watching this video, you will be able to configure a catalog.
-
SQL Server 2014: Provisioning Accounts
After watching this video, you will be able to provision accounts.
-
SQL Server 2014: Creating Object Identifiers
After watching this video, you will be able to describe catalog object identifiers.
-
SQL Server 2014: Creating Catalogs
After watching this video, you will be able to create the catalog.
-
SQL Server 2014: Remote Package Execution
After watching this video, you will be able to install specifics for remote package execution.
-
SQL Server 2014: Upgrading
After watching this video, you will be able to upgrade SSIS components.
-
SQL Server 2014: 32-bit and 64-bit Installations
After watching this video, you will be able to plan for a 32-bit and 64-bit Installations.