-
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.
-
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 Consolidation Overview
In SQL Server; you can restructure an existing database. In this video; Aaron Sampson discusses how to consolidate database servers.
-
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.
-
Denormalization
In Microsoft SQL Server 2014; you can perform denormalization process for a database to undo the normalization process performed earlier. In this video; Aaron Sampson demonstrates the features; usage scenarios; and advantages of database denormalization.
-
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 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 Configure SQL Server on VM
You can set up Microsoft SQL Server 2014 on a virtual machine through RDP connection. In this video; Aaron Sampson demonstrates how to configure SQL Server on a virtual machine.
-
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.
-
Windows Azure SQL Database Migration Using Export and Import
In SQL Server; you can migrate on-premise databases into Microsoft Azure. In this video; Aaron Sampson demonstrates how to import and export the database.
-
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.
-
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.
-
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.
