-
Paging
Paging in SQL Server 2012 allows you to customize how specific query results are returned to help you access relevant results quickly and accurately. In this video; Rafiq Wayani uses paging to limit the number of query results displayed at any given time so that they're displayed in pages that can be viewed more quickly.
-
Understanding Relationships
After watching this video; you will be able to define relationships in a database such as one-to-many; one-to-one; and many-to-many; outlining the role of primary; composite; and foreign keys in the context of SQL Server examples.
-
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.
-
Creating and Using Stored Functions
After watching this video; you will be able to compare stored functions with stored procedures and create and use a stored function within a SQL Server database.
-
Using Inner Joins
After watching this video; you will be able to use INNER JOINS to retrieve data from multiple SQL Server tables.
-
Using Outer Joins
After watching this video; you will be able to use OUTER JOINS to retrieve data from multiple SQL Server tables.
-
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.
-
Data Integrity
In data warehousing; data integrity is what ensures the accuracy and consistency of your data. In this video; Charles Robinson discusses how to ensure data integrity; where to apply it; and its importance.
-
Fact
In data warehousing; a fact table contains the measurable items of a particular business process. In this video; Amanda Jones discusses and examines the sales amount fact of the AdventureWorks Data Warehouse.
-
Factless Fact
In data warehousing; a factless fact is a fact table that does not contain a measure. In this video; Amanda Jones explains the meaning and purpose of a factless fact.
-
Granularity
In data warehousing; granularity is the level of depth of your data; or the level of detail in a particular fact or dimension. In this video; Charles Robinson demonstrates a few examples of granularity using the AdventureWorks Data Warehouse.
-
Joins
In data warehousing; a join is how you create the rules of how data is going to need to match in our tables in order to be included in our output. In this video; Charles Robinson demonstrates the different types of joins and their syntax; using SQL Management Studio.
-
Normalization vs. Denormalization
In data warehousing; data stored in tables can be either normalized or denormalized. In this video; Charles Robinson explains the difference between normalization and denormalization.
-
Schemas
In data warehousing; schemas are the outline or model for database design. The two main schemas used in dimensional modelling are the star and snowflake schemas. In this video; Amanda Jones discusses the star and snowflake schemas.
-
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.
-
Collation Functions
The collation functions in Microsoft SQL Server 2012 provide sorting rules; cases; and accent-sensitive properties for the data. In this video; Jonathan Summers provides a description of collation in SQL Server before demonstrating how to use the COLLATIONPROPERTY and TERTIARY_WEIGHTS collation functions; as well as sp_helpsort procedure and the SERVERPROPERTY function.
-
Columnstore Indexes
Columnstore Indexes in Microsoft SQL Server 2012 can significantly speed-up the processing time of queries by grouping and storing data for each column and then joining the columns to complete the whole index. In this video; Jonathan Summers uses the Object Explorer component of SQL Server Management Studio to create a columnstore index.
-
Comments
In Microsoft SQL Server 2012; you can add comments to your SQL Server Integration Services (SSIS) packages so you can convey information to help make the source code easier to understand at a later date. In this video; David Dye demonstrates how to add and configure comments and annotations within a Data Flow and Script task.
-
Concatenate Function
In Microsoft SQL Server 2012; you can use the concat function inside of TSQL to join multiple strings together. In this video; Rafiq Wayani demonstrates how the concat function allows you to join two or more values.
-
Configure File Tables
Microsoft SQL Server 2012 allows you to create a SQL Server cluster by installing the Failover Clustering feature on your servers. In this video; Rafiq Wayani uses Server Manager to install Failover Clustering on both his servers before explaining the need for network cards for internal communications between the two failover clusters and for external communication.
-
Configure Firewall for FILESTREAM Access
Microsoft SQL Server 2012 requires that firewalls be configured on the server side and client side when FILESTREAM data is to be accessed from remote clients in a firewall protected environment. In this video; Jonathan Summers demonstrates how to configure Windows firewalls for FILESTREAM access.
-
Connection Managers
In Microsoft SQL Server 2012; SQL Server Integration Services (SSIS) includes a variety of connection managers for connecting data sources that you can create and configure at the package or project level. In this video; David Dye demonstrates how connection managers are defined at the project level; before creating and configuring connection managers for packages and within specific tasks.
-
Contained Database Access
In Microsoft SQL Server 2012; you can use the new contained databases (CDBs) and partially contained databases (PCDBs) features to limit access for certain users. In this video; Rafiq Wayani demonstrates how to create and access CDBs and PCDBs from Management Studio.
-
Contained Databases
Microsoft SQL Server 2012 has a new feature called partially contained databases; or partial-CDBs. In this video; Rafiq Wayani demonstrates how partial-CDBs are used and enabled.
-
Control Flow
Control flow in Microsoft SQL Server 2012 allows you to extract; transform; and load data. In this video; David Dye demonstrates the concept of control flow within an integration services package; the different tasks available within control flow; and the difference between data flow and control flow.
-
Create a Directory
Windows Azure Active Directory is a new Windows Azure service that you can use to create directories for Windows Azure SQL Database administration. In this video; Jonathan Summers leads you through the process of creating a new directory from within the Windows Azure Management Portal.
-
Create a Federation in Azure Database
Windows Azure SQL Database allows you to deliver scale; performance; and additional capacity in SQL Databases through horizontal partitioning when creating a federation. In this video; Jonathan Summers demonstrates how to add a federation to a database using the Windows Azure Platform Management Portal.
-
Create a Microsoft Support Ticket
Windows Azure SQL Database offers multiple support options and enables administrators; depending on their subscription types; to resolve issues beyond their control by submitting support tickets directly to Microsoft. In this video; Jonathan Summers demonstrates how to configure a support ticket; and introduces other forms of support for the Windows Azure SQL Database administrator.
-
Create a New Mobile Service
Windows Azure SQL Database enables administrators to create mobile services for use in the production environment; subject to local and Windows Azure firewalls being configured to allow mobile service connectivity. In this video; Jonathan Summers creates a new mobile service; providing a distinct URL for the back-end service and other required options.
-
Create a New Sync Agent
Windows Azure SQL Database enables you to create a Sync Agent to synchronize on-premise and Cloud-based databases. In this video; Jonathan Summers uses the Add Sync feature to create and configure a new Sync Agent as well as generate an access key; enabling the Sync Agent's registration with online databases.
-
Create a SQL Data Sync Group
Windows Azure SQL Database enables you to synchronize on-premise and Cloud databases by adding them to a Data Sync Group; to which you assign a Sync Agent. In this video; Jonathan Summers uses the Add Sync feature to create a data sync group and then configure the group's sync direction and writable database.
-
Create a Table for Storing FILESTREAM Data
In Microsoft SQL Server 2012; once you have created or modified a database to contain a FILESTREAM filegroup; you can then create a table to store FILESTREAM data. In this video; Jonathan Summers uses the Query Editor in SQL Server Management Studio to create a FILESTREAM-enabled table.
-
Create a Virtual Machine
Windows Azure SQL Database allows you to quickly and easily create a virtual machine; which is a server in the cloud that you can access and manage just like any other server. In this video; Jonathan Summers uses the Quick Create method to create a virtual machine in the Windows Azure Management Portal.
-
Create Access Control Namespaces
Windows Azure SQL Database allows you to create; configure; and activate an Access Control Namespace from your Management Portal. This allows you to manage Access Control Service features; such as the integration of identity federation and single sign-on into your web applications. In this video; Jonathan Summers creates an Access Control Namespace and introduces various Access Control Services.
-
Create and Alter FileTables
Microsoft SQL Server 2012 allows you to create and alter FileTables – a new feature that provides compatibility between Windows applications and the file data stored in SQL Server. In this video; Jonathan Summers demonstrates how to create a FileTable using two different methods; as well as how to change the FileTable directory using the ALTER TABLE statement.
-
Create Data Storage
Windows Azure SQL Database allows you to create a data storage account and the encrypted online storage you need to import and export databases. In this video; Jonathan Summers creates data storage as well as the primary and secondary access keys; allowing access from outside of the Windows Azure subscription.
-
Create Share Drive for Cluster
Microsoft SQL Server 2012 allows you to create a shared drive which; when failover services have been installed on your Windows environment; lets you create a SQL Server cluster. In this video; Rafiq Wayani demonstrates how to configure your machines to communicate with an iSCSI disk; enable Failover Clustering on both machines; and install SQL Server.
-
Creating a FILESTREAM Database
In Microsoft SQL Server 2012; you can create a FILESTREAM enabled database to help store and manage unstructured data. In this video; Jonathan Summers uses the query editor in SQL Server Management Studio to create a FILESTREAM database.
-
Creating a SQL Database Server in Azure
Windows Azure SQL Database enables you to provision new SQL database servers for your platform subscription from the Windows Azure Management Portal. In this video; Jonathan Summers demonstrates how to create and configure a Web edition database and new SQL database servers.
-
Creating a Virtual Network
Windows Azure SQL Database enables you to build and configure a virtual network comprising multiple virtual servers from the Windows Azure Management Portal. In this video; Jonathan Summers demonstrates how to create and configure a virtual network by specifying DNS servers; configuring VPN connectivity; and defining virtual network address spaces.
-
Creating a Website
Windows Azure SQL Database offers Quick; Custom; and Gallery web site options you can connect to your Azure web database server. The Gallery's predefined site templates are categorized and cover a range of site types. In this video; Jonathan Summers explores site options from the Windows Azure Management Portal and assign a URL to a template.
-
Creating a Windows Azure Profile
Windows Azure SQL Database allows you to use Internet Explorer to quickly and easily set up an account and user profile; thereby enabling you to access the Windows Azure portal where you are presented with several subscription options. In this video; Jonathan Summers leads you through the process of creating a Windows Azure user account.
-
Creating SSIS Catalog
Microsoft SQL Server 2012 allows users to create a SQL Server Integration Services (SSIS) Catalog to deploy projects or packages to the Integration Services server. In this video; David Dye demonstrates how to create an SSIS Catalog in the SSISDB; and discusses the project-based deployment method.
-
Credentials and Server Roles
New to Microsoft SQL Server 2012 is the ability to easily and quickly create new user-defined server roles and credentials using Transact-SQL. In this video; Rafiq Wayani demonstrates how to create and configure a server role and credential; and assigns members to the server role through the Properties interface.
-
Cryptographic Functions
In Microsoft SQL Server 2012; there are two cryptographic hash functions you can use to provide data security when sending or receiving information. In this video; Jonathan Summers demonstrates how encryption hashing can be used to generate hash values on different types of algorithms.
-
CTE Functions
Microsoft SQL Server 2012's Common Table Expressions (CTEs) are named expressions or temporary result sets – not stored as objects – defined in and confined to the scope and lifespans of single queries. In this video; Jonathan Summers details the syntax; role; and uses of CTEs; creating a query wherein the WITH and AS clauses define the CTEs.
-
Custom Logging
Microsoft SQL Server 2012 Integration Services provides a custom logging feature that users can specify to deal with logging information that falls outside the built-in log providers and event handlers. In this video; David Dye demonstrates how to implement custom logging within a package.
-
Data Compression
Microsoft SQL Server 2012 supports row and page compression for tables and indexes allowing you to reduce the size of data inside a database. In this video; Rafiq Wayani introduces Unicode and page-level data compression; explains that data compression saves storage space but drains CPU resources; and implements row-level compression on a database table.
-
Data Conversion
Microsoft SQL Server 2012 Integration Services' Data Conversion transformations allow you to convert the data in an input table to a different data type and copy it to a new output table. In this video; David Dye uses a Data Conversion transformation to copy data from a flat file ASCII Source to a Unicode Destination.
-
Data Flow
The data flow task in Microsoft SQL Server 2012 is an integral component of data management. In this video; David Dye demonstrates the data flow task within integration services; highlighting the difference between data flow and how the data flow invokes different components within a control flow task.
-
Data Flow Redirection
In Microsoft SQL Server 2012; instead of letting failures stop package execution; you can redirect the failed row to an alternate destination where the error can be examined and processed at a later time. In this video; David Dye demonstrates how to redirect a row containing an error within a Data Flow task to a flat file destination.
-
Data Profiling
In Microsoft SQL Server 2012; you can use the Data Profiling Control Flow Task to analyse data from tables to verify specified information. In this video; David Dye demonstrates how to define different types of data profiling requests before analysing the results.
-
DATETIMEOFFSETFROMPARTS
The new DATETIMEOFFSETFROMPARTS function in Microsoft SQL Server 2012 returns a datetimeoffset value – wherein OFFSET accounts for time-zone difference in hours and minutes - for a specified date and time with the specified precision. In this video; Jonathan Summers details the function's parameters and values before compiling an executable query.
-
DBCC CHECKALLOC
Microsoft SQL Server 2012's DBCC CHECKALLOC command checks disk-space allocation structures and page usage in a database; including indexed views. In this video; Jonathan Summers clarifies the role of the NOINDEX and REPAIR options; details CHECKALLOC syntax; and runs DBCC CHECKALLOC on multiple databases as well as a single database.
-
DBCC CHECKCATALOG
Microsoft SQL Server 2012 uses Data Definition Language (DDL) triggers that fire in response to various DDL events. In this video; Jonathan Summers creates DDL event triggers to prevent users from creating; altering; or dropping tables.
-
DBCC CHECKTABLE
Microsoft SQL Server 2012's DBCC CHECKTABLE command checks and reports on the integrity of all pages making up a table or indexed view. Errors require a database restore rather than running a REPAIR; which might result in data loss. In this video; Jonathan Summers runs a regular and low-overhead DBCC CHECKTABLE command on a database table and a table index.
-
DBCC INDEXDEFRAG
Microsoft SQL Server 2012's DBCC INDEXDEFRAG defragments the leaf level of an index so that the physical order of the pages matches the left-to-right logical order of the leaf nodes; therefore improving index-scanning performance. In this video; Jonathan Summers explains how DBCC INDEXDEFRAG operates on an index; reviews an index's fragmentation; and runs INDEXDEFRAG.
-
DBCC SHOW_STATISTICS
Microsoft SQL Server 2012's DBCC SHOW_STATISTICS command displays current query optimization statistics for a table or index view. The query optimizer uses these statistics to estimate the number of resulting rows; which enables it to create a high-quality query plan. In this video; Jonathan Summers runs DBCC SHOW_STATISTICS on the index of a table and explains the HISTOGRAM option.
-
DDL Triggers and EVENTDATA
Microsoft SQL Server 2012 uses Data Definition Language (DDL) triggers that fire in response to various DDL events. In this video; Jonathan Summers creates DDL event triggers to prevent users from creating; altering; or dropping tables.
-
Debugging
Microsoft SQL Server 2012 allows users to debug Integration Services packages by setting breakpoints within the packages; enabling them to evaluate system and user-defined variables at those points in time. In this video; David Dye demonstrates how to set breakpoints; add variables and statements to a watch list; and stop execution at specific points based on event handlers.
-
Define AlwaysOn
In Microsoft SQL Server 2012; you can use the AlwaysOn feature to ensure your server access is running at maximum efficiency; even if a failure occurs. In this video; Rafiq Wayani demonstrates the principle of nines; and how the AlwaysOn feature can be used to maintain high availability of your servers or datacenter.
-
Delay Validation
In Microsoft SQL Server 2012; DelayValidation is a property of a SQL Server Integration Services (SSIS) package and all of its components that you can use to delay validation until runtime. In this video; David Dye demonstrates the differences between DelayValidation set to True and False; before discussing the use of DelayValidation when a table only gets created on execution.
-
Deploy AlwaysOn
AlwaysOn Availability Groups is a new high-availability feature in Microsoft SQL Server 2012 you can deploy as a way of providing an enterprise-level alternative to database mirroring. In this video; Rafiq Wayani demonstrates how to enable AlwaysOn in SQL Server Configuration Manager before using the New Availability Group Wizard to configure a new availability group.
-
Derived Column
Microsoft SQL Server 2012 allows you to use the Derived Column transformation to add an entirely new column based upon an Integration Services expression. In this video; David Dye demonstrates how to derive a column called FullName from the FirstName; MiddleName; and LastName columns; using Integration Services rather than a T-SQL statement.
-
Detect Running Package
In Microsoft SQL Server 2012; you can implement a script task to detect if a package is already running to prevent conflicts caused by the package running multiple times. In this video; David Dye demonstrates how to configure a script task to assign a global unique identifier to a package to prevent it from executing again if it's already running.
-
Discontinue Feature WITH APPEND
Microsoft SQL Server 2012's discontinuance of support for the WITH APPEND clause affects scripts migrated from earlier versions of SQL Server. In this video; Jonathan Summers explains the implications of the discontinuation; searches for and deletes the clause from a script on SQL Server 2012; and executes it successfully.
-
Dynamic Connections
Microsoft SQL Server 2012 Integration Services allow you to manage data flows using dynamically-generated connection managers based on either variables or parameters. In this video; David Dye uses a connection manager in conjunction with a FOREACH Loop Container and a variable mapping to the fully-qualified names of a specific file type; to iterate through the files in a database collection.
-
Dynamic Management Function
Microsoft SQL Server 2012's Dynamic Management Views and Functions return SQL Server runtime-state information that is used to monitor SQL Server health during runtime; troubleshoot the performance of bottleneck issues; and proactively work to minimize downtime. In this video; Jonathan Summers runs a query containing one of SQL Server 2012's new dynamic management functions.
-
Dynamic SQL Statement
Microsoft SQL Server 2012 allows users to replace Dynamic SQL statements with expressions and Integration Services variables. In this video; David Dye demonstrates the steps to replace statements with expressions and variables; as well as how to use the variables within a data flow or Execute SQL task.
-
Efficient Index
In Microsoft SQL Server 2012; poorly designed indexes have a negative impact on your overall database performance. Designing efficient indexes will help speed the retrieval of rows from tables and help you to improve the effectiveness of your application. In this video; Rafiq Wayani demonstrates the efficiencies of a clustered index scan compared to a table scan.
-
Enable FILESTREAM
Microsoft SQL Server 2012's FILESTREAM feature ensures that your applications can leverage the rich streaming APIs and performance of the file system while maintaining transactional consistency between unstructured data; stored in the NT File System; and structured data; stored in the table. In this video; Jonathan Summers prepares a database to accommodate FILESTREAM.
-
Enable or Disable Change Tracking
Microsoft SQL Server 2012's Change tracking is a lightweight solution and efficient change-tracking mechanism for applications that records INSERT; UPDATE; and DELETE activity applied to track tables - supplying the details in easily-consumed rational format. In this video; Jonathan Summers demonstrates how to enable and disable Change tracking at the database and table levels.
-
Execute Jobs Using Agent
In Microsoft SQL Server 2012; SQL Server Agent allows you to create and execute jobs that automate database administration. In this video; Rafiq Wayani uses SQL Server Management Studio's New Job dialog box to create a job before scheduling the new job and confirming its status in Event Viewer.
-
Execute Package
In Microsoft SQL Server 2012; you can execute a package from within another package to help maintain logic consistency. In this video; David Dye demonstrates how to enable and configure the parent variable configuration using the Execute Package Control Flow task so you can pass a variable from a parent package to a child package.
-
Execute Package Procedure
In Microsoft SQL Server 2012; the SSIS catalog provides various packages that can be executed using system stored procedures. In this video; David Dye demonstrates how to execute a package using a system stored procedure available within the SSIS database; and discusses the requirements and configuration steps necessary to execute a package using the stored procedure.
-
Execute Process
Microsoft SQL Server 2012's Execute Process Task allows you to execute executables; batch files; or command files as long as the appropriate arguments are passed in its configuration. In this video; David Dye uses Microsoft Visual Studio to show you how to configure and provide arguments allowing the Execute Process Task to call and execute a package's dtexec utility.
-
Execute SQL Task
In Microsoft SQL Server 2012; the Execute SQL task allows you to run T-SQL statements or stored procedures from a SQL Server Integration Services (SSIS) package in a control flow. In this video; David Dye demonstrates how to configure an Execute SQL task with a T-SQL statement in conjunction with a Data Flow task to create and populate a table.
-
Executing a Package
In Microsoft SQL Server 2012; you can execute a package using a number of different methods. In this video; David Dye demonstrates how to execute a package from the command line; from Visual Studio or SQL Server Data Tools; from Management Studio; and from the Execute Package Utility.
-
Export Column
In Microsoft SQL Server 2012; you can configure the Export Column Transformation and use the task in various situations. In this video; David Dye uses the Export Column Transformation task to convert a large amount of data into a text stream and export it from the database to an external file.
-
Export SQL Database
Windows Azure SQL Database enables you to export a database; given a BACPAC extension and accessible from your local SQL Server instance; to a container in your storage account location. In this video; Jonathan Summers uses Windows Azure SQL Database’s Export feature to export a database to a BLOB storage account container.
-
Expression Size
Microsoft SQL Server 2012 Integration Services (SSIS) allows users to increase variable sizes to overcome limited expression size. In this video; David Dye demonstrates how to overcome the 4000-character limitation on expression size by creating large variables and concatenating the expressions.
-
Fail Parent
In Microsoft SQL Server 2012; you can determine whether or not a parent container fails when a child container fails by configuring the FailParentOnFailure property and Propagate variable. In this video; David Dye demonstrates how to configure the FailParentOnFailure property; and how to suppress errors at the parent by configuring the Propagate system variable.
-
Failover Mode
In Microsoft SQL Server 2012; there are a number of modes the failover cluster can exist in depending on the type of failover event that occurs. In this video; Rafiq Wayani demonstrates conceptually how automatic synchronous; automatic asynchronous; and forced manual asynchronous failover modes can be implemented.
-
Failover Multi-Subnet
Microsoft SQL Server 2012 allows you to use the cluster validation process to validate the computers on the network on which you wish to install your SQL Server cluster. In this video; Rafiq Wayani uses the Failover Cluster Manager's Validate a Configuration Wizard to name and validate his machines' hardware.
-
File System
Microsoft SQL Server 2012 Integration Services' File System Task enables you to create; move; delete and/or set the standard attributes of directories and files. In this video; David Dye highlights the File System Task's inability to access extended file or directory properties from within the file system; before using it to copy a directory.
-
Filestream
In Microsoft SQL Server 2012; you can utilise FileStream to store unstructured data from a database inside the directory structure in a file system. In this video; Rafiq Wayani demonstrates how to enable and get the most out of using FileStream.
-
For Each
Microsoft SQL Server 2012 Integration Services allow you to use a Foreach Loop Container and variable to iterate through; and enumerate; a defined collection. In this video; David Dye uses a File Loop Container to iterate a file collection of defined file types; the fully qualified filenames of which are assigned to a variable and enumerated before deletion.
-
For Loop
In Microsoft SQL Server 2012; you can use a For Loop container to continue executing an expression based on a defined collection until a specific condition is met. In this video; David Dye demonstrates how to initialize an expression in a For Loop container and define the evaluation and assignment conditions.
-
Format and Convert
In Microsoft SQL Server 2012; you can easily format and convert data settings and formats. In this video Rafiq Wayani demonstrates how you can format date and time settings using locale aware formatting; and convert data using type conversions.
-
FSIS If Expression
Microsoft SQL Server 2012 Integration Services allow you to implement an IF expression as a CASE expression; which is not otherwise supported. In this video; David Dye demonstrates how to create a package comprising a Case string variable based on an expression; containing two integer data type variables; and details the expression's syntax before executing the package.
-
Full Text Index
In Microsoft SQL Server 2012; you can create full-text indices to store and retrieve information. In this video Rafiq Wayani demonstrates a number of different ways in which to create full-text indices for data storage to make it easier to locate information.
-
How to Configure Logical Server Firewall Settings
After a logical server has been created on Windows Azure SQL Database; you will need to configure the firewall for the server to allow inbound connections from your IP address when communicating with the SQL Database in the cloud. In this video; Jonathan Summers uses settings in the Windows Azure Management Portal to specify firewall rules for a logical server.
-
How to Reset SQL Server Database Password
Windows Azure SQL Database enables administrators to reset their server account credentials from the Server dashboard. In this video; Jonathan Summers launches the relevant Server dashboard and resets the password.
-
How to Scale a SQL Database Solution
In Windows Azure SQL Database; large databases sometimes require a scale out strategy when addressing issues related to capacity or performance that can be achieved through federation. However; increasing the size of the database is sometimes the best approach. In this video; Jonathan Summers outlines some of the ways to scale a Windows Azure SQL Database.
-
How to View Import and Export Status of a Database
In Windows Azure SQL Database; you can monitor the amount of processes and resources used when you import or export a database. In this video; Jonathan Summers demonstrates how to query the performance and view the properties of an imported or exported database.
-
Iif and Choose
In Microsoft SQL Server 2012; you can use the Inline IF (iif) and choose logical functions to create multiple statements within statements. In this video; Rafiq Wayani demonstrates some of the applications for the Inline IF and choose functions; and how to create statements within statements.
-
Implement Index
In Microsoft SQL Server 2012; you can speed up the querying process by creating indexes on columns in tables that; when implemented; provide swift access to rows in the data tables. In this video; Rafiq Wayani demonstrates how to index a column in a data table and highlights the advantage of implementing an index while performing a table scan.
-
Import a SQL Database
Windows Azure SQL Database enables you to import a database; given a BACPAC URL and exported from your local SQL Server instance; into your Windows Azure virtual server. In this video; Jonathan Summers uses the Windows Azure Import feature to import a database into a Cloud storage container and specify its edition and size.
-
Index Type and Structures
Microsoft SQL Server 2012 supports clustered; non-clustered; and composite indexes; the different structures of which allow you to access data at different speeds. In this video; Rafiq Wayani demonstrates the structural and data-access speed differences separating the different types of index; and creates an example of each using Microsoft SQL Server Management Studio.
-
Install SQL on Cluster
Microsoft SQL Server 2012 provides configuration options for installing SQL Server on a cluster. In this video; Rafiq Wayani demonstrates how to install SQL Server on a Windows cluster that has already been created and validated.
-
Is Stored Procedure
Microsoft SQL Server 2012 Integration Services apply different parameter marker rules for stored procedures on different connections. In this video; David Dye explains that ADO or ADO.NET connections need only declare their stored procedures when their properties are set to True; but must use OLE DB syntax when set to False.
-
Join Hints
Microsoft SQL Server 2012's Join hints; used with LOOP; HASH; MERGE; and REMOTE arguments; specify that the query optimizer; which typically selects the best execution plan for a query; enforces a join strategy between two tables. In this video; Jonathan Summers compiles and executes a JOIN to extract desired data from two tables.
-
Locating Unused Indexes
Microsoft SQL Server 2012 index maintenance consumes significant resources; degrading performance in a write-intensive system. You can identify and remove indexes not being used with the sys.dm_db_index_usage_stats Dynamic Management View (DMV). In this video; Jonathan Summers searches for unused indexes by running the sys.dm_db_index_usage_stats DMV.
-
Logging
Microsoft SQL Server 2012 Integration Services allow you to configure performance and error logs at the package level and support log providers that write to text; SQL Server; and other log files. In this video; David Dye demonstrates how to configure logging at the package level; executes the package; and reviews the sysssislog table.
-
Lookup
In Microsoft Visual Studio 2012; you use the Lookup Transformation to join data in input columns with columns in a reference dataset. In this video; David Dye demonstrates how to use Lookup Transformation to configure a source that connects the Lookup to the database.
-
Maintenance Plans
In Microsoft SQL Server 2012; you can create Database Maintenance Plans in either SQL Server Management Studio or within SQL Server Data Tools. In this video; David Dye demonstrates how database maintenance plans are actually integration services packages that can be configured in Management Studio or within SQL Server Data Tools.
-
Manage Alerts
In Microsoft SQL Server 2012; you can define and manage alerts that specify how you want SQL Server Agent to respond to event occurrences. In this video; Rafiq Wayani demonstrates how to configure an alert using the SQL Server Management Studio Alert Properties dialog box before using Windows PowerShell to script a new event and an event log.
-
Manage File Tables
Microsoft SQL Server 2012 allows you to easily store and manage unstructured data. In this video; Jonathan Summers demonstrates how to manage filetables using SQL Server Management Studio.
-
Manage Settings in SQL Database
In Windows Azure SQL Database; each database has its own logins and specifically delegated administrators; which can be managed using the Settings feature. In this video; Jonathan Summers demonstrates how to add an administrator to a database subscription; specify filters for event logs; and create an affinity group.
-
Managing Errors
Microsoft SQL Server 2012 has traditionally used the @@ERROR automatic variable to implement error handling. In this video; Rafiq Wayani explains that @@ERROR always contains a value greater than zero; is reset immediately on the next statement executing successfully; and uses RAISEERROR to capture the error number to a variable.
-
Managing SQL Databases from Outside Management Portal
With Microsoft Windows Azure SQL Databases; you have two options to connect to and manage your databases outside the management portal. In this video; Jonathan Summers demonstrates how to connect to your database directly through the Internet; or using SQL Server Management Studio.
-
Manual Failover
Microsoft SQL Server 2012 allows you to implement a manual failover to a failover cluster in order to patch the server on which you host SQL Server. In this video; Rafiq Wayani uses the Failover Cluster Manager to introduce the node services and applications; storage devices; and Microsoft iSCSI Software Target configuration required to implement and test a manual failover.
-
Media Services and SQL Database
Windows Azure SQL Database provides a number of tools and options that allow the database to stream media using media services. In this video; Jonathan Summers demonstrates how to create a new media for your Azure SQL Database.
-
Merge Data
In Microsoft SQL Server 2012; the Transact-SQL MERGE statement allows you to insert; update; or delete data in a target table based on data in a source table; all in one easy statement. In this video; Rafiq Wayani demonstrates how to create and populate a target and source table; and merge data into the target table.
-
Merge Join
In Microsoft Visual Studio 2012; you can use Merge Join Transformation to join data from a table and data from a flat file based on matching criteria. In this video; David Dye demonstrates how to join data and configure the Merge Join Transformation task in integration services.
-
Migrate Data
Microsoft SQL Server 2012 provides configuration options for migrating data between server instances and also between different servers. In this video; Rafiq Wayani explains how to migrate data from one environment over to another.
-
Migrate Logins
Microsoft SQL Server 2012 allows you to migrate Logins from one database to another when switching servers or creating new databases or database instances. In this video; Rafiq Wayani uses Microsoft SQL Server Management Studio to migrate a group of users and a group of logins from one database to another.
-
Virtualizing SQL Server
You can quickly and easily allocate a range of resources to Microsoft SQL Server 2012 virtual machines depending on your requirements. In this video; Rafiq Wayani demonstrates how to add more RAM to a virtual machine based in a Datacenter.
-
Web Service Task
Microsoft SQL Server 2012 Integration Services' Web Service Task allows you to execute a Web service method; which has its returned values contained in an XML file. In this video; David Dye configures his HTTP connection manager to point to a WSDL file which he downloads before configuring and executing the Web Service Task so it returns an XML file.
-
Where Packages are Stored
In Microsoft SQL Server 2012; you can use different models to deploy packages and store them within the file system or in the database. In this video; David Dye demonstrates a couple of ways the package deployment model stores packages in the package store and in the database; and discusses where the project deployment model stores its deployed packages.
-
Windows Azure Add-On Store
In Windows Azure SQL Database; you can access a wide range of additional tools from the Windows Azure Add-On Store. In this video; Jonathan Summers demonstrates how to install a third-party add-on for use in your database.
-
Windows Azure SQL Database Backup
Backing up your Windows Azure SQL Database is a necessary process when protecting against data loss; and it requires a different strategy than when performing an on-premises SQL Database backup. In this video; Jonathan Summers demonstrates how to automate the process of backing up a Windows Azure SQL Database by executing a query in the Management Portal.
-
Windows Azure SQL Database Reporting
In Windows Azure SQL Database; you have access to a range of reporting features similar to those in on-premise SQL installations. In this video; Jonathan Summers demonstrates how to configure and customize SQL reporting options using Windows Azure Data Services and the dashboard.
-
WMI Data Reader
The Windows Management Instrumentation (WMI) Data Reader in Microsoft SQL Server 2012 allows you to return information on an actual physical system. In this video; David Dye demonstrates the ability of the WMI Data Reader task to query and provide information on underlying systems.
-
XML Control Flow
Microsoft SQL Server 2012 Integration Services allows you to pass an XPath query against an XML Control Flow Task. In this video; David Dye uses an XML Control Flow Task; its File connection; and Source; to pass an XPath query against an element in an XML file; and assigns the returned value to a variable.
-
XML Source
Microsoft SQL Server 2012 provides various configuration options for utilizing an XML source within a data flow; as well as the ability to create a schema based upon an input XML file. In this video; David Dye demonstrates how to use the XML source to create a schema.
-
Migrated to New Instance
Microsoft SQL Server 2012 allows you to migrate databases to new instances; whether by detaching and attaching them; or by backing up your database; dropping it; and restoring it to the new instance. In this video; Rafiq Wayani uses Microsoft SQL Server Management Studio's menu-driven Object Explorer and its resulting dialog boxes to demonstrate both methods and their procedures.
-
Mirror
Microsoft SQL Server 2012 databases can be mirrored in a virtual environment for fault tolerance and backup. In this video; Rafiq Wayani demonstrates how to use VMWare to create a read-only copy of a virtual machine running SQL Server 2012 on a secondary virtual machine.
-
Mirror and Certificate Authentication
Microsoft SQL Server 2012 allows you to implement mirroring utilizing Certificate-based Authentication rather than Windows Authentication. In this video; Rafiq Wayani demonstrates the benefits of using Certificate-based Authentication; explains the need for a secondary server on which the mirror can be implemented; configures his database to use the full recovery model; and launches the Configure Database Mirroring Security Wizard.
-
Mirror Setup
Microsoft SQL Server 2012 allows users to use replication; as well as mirroring; to ensure fault tolerance across a database environment. In this video; Rafiq Wayani discusses various methods of implementing mirroring; either through SQL Server 2012 or outside it.
-
Mirror with Windows Authentication
Microsoft SQL Server 2012 allows you to create a mirror utilizing Windows Authentication which you can integrate with Active Directory. In this video; Rafiq Wayani uses Microsoft SQL Server Management Studio to introduce the database properties and mirroring components needed to enable mirroring; the Database Mirroring Monitor; and Windows Authentication.
-
Monitor
Monitoring Microsoft SQL Server 2012 allows you to keep track of your databases and provides you with valuable information when fine tuning performance; or troubleshooting performance issues. In this video; Rafiq Wayani demonstrates the monitoring features of the Windows Resource Monitor; and how to monitor log files in the Log File Viewer.
-
More on Advanced Sequences
In Microsoft SQL Server 2012; you can use the same sequence to supply data across multiple tables. In this video; Rafiq Wayani demonstrates how to link multiple tables to a sequence using the union operator to display the sequence audit results across these tables.
-
More on Mirror Setup
Microsoft SQL Server 2012 and Windows Server 2008 R2 allow users to mirror databases for backup purposes and redundancy. In this video; Rafiq Wayani demonstrates the important differences between replication and mirroring; pointing out that performance issues preclude mirroring as a viable failover option.
-
More on Replication Setup
Microsoft SQL Server 2012 allows users to use replication to create a fully current secondary server for redundancy. In this video; Rafiq Wayani demonstrates how to set up the replication process and two methods of implementing redundancy by using an active; online secondary server or by bringing an offline secondary server online.
-
More on Sequences
Microsoft SQL Server 2012 allows you to use the NEXT VALUE FOR statement to create an integer sequence number that increments by one. In this video; Rafiq Wayani demonstrates the use of the NEXT VALUE FOR statement; and explains that sequences allow you to perform checking or implement advanced batch routines as part of a single transaction.
-
More on SQL Backup
In Microsoft SQL Server 2012; there are different ways of implementing backups that will protect you from data loss and assist when performing routine administrative tasks; such as copying a database from one server to another. In this video; Rafiq Wayani demonstrates some of the different options available to you when using SQL Management Studio to back up a database.
-
More on Using SQL Agent
In Microsoft SQL Server 2012; the SQL Server Agent is a Windows Service that allows you to automate and schedule a specified series of actions called jobs. In this video; Rafiq Wayani uses the New Job dialog box in SQL Server Management Studio to create and configure a new SQL Server Agent job.
-
Move a File Stream Enabled Database
For maintenance purposes; in Microsoft SQL Server 2012; it may be necessary to move a database from one hard disk location to another. In this video; Jonathan Summers demonstrates how to move an active database to a new hardware location.
-
Move Encrypted Data
Microsoft SQL Server 2012 allows users to move secure data from one location to another. In this video; Rafiq Wayani demonstrates how to create a database; populate it; encrypt the data; create a backup to disk; and drop the original database.
-
Moved On Another Instance
In Microsoft SQL Server 2012; you can move or copy databases between clusters or database instances. In this video; Rafiq Wayani demonstrates how you can move and copy multiple database instances in order to have redundancy.
-
Multicast
Microsoft SQL Server 2012 Integration Services' Multicast transformation allows you to create logical copies of input data and distribute them to one or more outputs. In this video; David Dye uses a Multicast transformation to copy a table from an OLE DB source to multiple types of destination.
-
Multi-Statement Table Valued Function
Microsoft SQL Server 2012's multi-statement table-valued functions force a query to return a table structure as its value. In this video; Rafiq Wayani demonstrates how to create a multi-statement table-valued function wherein he employs user-defined functions to specify the construction of the returned table.
-
New Features
Microsoft SQL Server 2012 provides sequences that can be used instead of identity columns because they are not table-bound structures. In this video; Rafiq Wayani demonstrates how to create a sequence that generates a sequence of numeric values which can be used for database-wide sequential numbers.
-
Object Permissions
Microsoft SQL Server 2012 allows you to easily grant and manage permissions for individual database objects; such as user-defined server roles; using Transact-SQL. In this video; Rafiq Wayani demonstrates how to grant insert permissions to an object; and highlights how to manage the permissions through the object's Properties options.
-
OLEDB Connection in Script
Microsoft SQL Server 2012 Integration Services allow you to create an OLE DB connection manager in a Script task to implement a connection. In this video; David Dye demonstrates how to program an OLE DB connection manager by parsing out an ADO.NET ConnectionString to assign the appropriate components to his script; thereby instantiating an OLE DB database connection.
-
On Error Event Handler
In Microsoft SQL Server 2012; the Integration Services (SSIS) OnError event handler provides a means of proactively handling of OnError events that are raised by an event when errors occur. In this video; David Dye demonstrates how to use OnError event handlers to capture package errors and pass them on to other tasks to provide in-depth information on package failures.
-
Operating Modes
Microsoft SQL Server 2012 allows you to implement mirroring in multiple operating modes; including High performance; High safety; Transaction safety; and Witness (used in conjunction with High safety). In this video; Rafiq Wayani demonstrates the roles and properties of the different SQL Server mirroring operating modes and how they complement or interact with each other.
-
Output Action Merge Data
Microsoft SQL Server 2012 allows you to retrieve and view the values of rows affected by a MERGE statement. In this video; Rafiq Wayani modifies a source table before using the Transact-SQL OUTPUT clause and the $action argument in a MERGE statement to return INSERT and UPDATE values.
-
Package Deployment
Microsoft SQL Server 2012 provides a choice of package deployment models: either as single packages or project-wide deployment. In this video; David Dye demonstrates the difference between package and project deployment; and how to configure the steps for package deployment.
-
Percentage Sampling
In Microsoft SQL Server 2012; the SQL Server Integration Services (SSIS) Percentage Sampling transformation allows you to create a sample data set by selecting a percentage of rows from a source data set. In this video; David Dye uses the Percentage Sampling Transformation Editor dialog box to configure a sample output using a percentage to specify the sample size.
-
Pivot
In Microsoft SQL Server 2012; you can use the Pivot transformation task within Integration Services to pivot table data for less system overhead than using the pivot operator. In this video; David Dye demonstrates how to implement and configure a Pivot transformation on a table in the Production database.
-
Precedence Constraints
Precedence constraints in Microsoft SQL Server 2012 help you manage control flow based on the outcome of specific tasks. In this video; David Dye demonstrates how precedence constraints provide the ability to control the flow of a package based upon task outcome.
-
Precedence Constraints Variables
In Microsoft SQL Server 2012; precedence constraints allow you to link executables; containers; and tasks in SSIS packages within a control flow and determine whether an executable runs by specifying variables. In this video; David Dye demonstrates how to use variables in an expression while defining the control flow of SSIS packages and utilizing precedence constraints.
-
Process Cube
Microsoft SQL Server 2012 Integration Services' Analysis Services Processing Task allows you to process a multi-dimensional Analysis Services cube. In this video; David Dye uses the Analysis Services Processing Task to process a cube's dimensions before performing a full process on the cube; and configures and schedules an Integration Services Task to process the cube for him.
-
Project Deployment
Microsoft SQL Server 2012 provides project deployment to deploy all packages; parameters; and configurations in a project; rather than just single packages. In this video; David Dye demonstrates how to implement project deployment using a Wizard; and how to verify deployment and view inherent logging.
-
Propagation
Microsoft SQL Server 2012 Integration Services allow you to stop events propagating or bubbling up to the container or package level. In this video; David Dye demonstrates how propagation bubbles up exponentially through every event and task to the package level; and stops it by defining Propagate as False at each level.
-
Query Hints
In Microsoft SQL Server 2012; hints are options or strategies specified for enforcement by the SQL Server query processor. In this video; Jonathan Summers demonstrates the MERGE UNION operation to override the query optimizer's execution plan.
-
Querying SSIS Catalog
In Microsoft SQL Server 2012; you can query the Integration Services Catalog to access a range of information. In this video; David Dye uses stored procedures to execute a package from within the Integration Services Catalog and automatically log the information to the SSIS database.
-
Raw File
Microsoft SQL Server 2012 Integration Services' raw file binary data format needs no translation and minimal parsing; is native to its source and destination; traverses the server's memory; and eliminates the need for temporary tables or table variables. In this video; David Dye configures a Data Flow Task with a Raw File Source and Destination; and views the file data.
-
Readable Secondary Replicas
In Microsoft SQL Server 2012; AlwaysOn Availability Groups include support for readable secondary replicas that allow read-only access to all its secondary databases in near real-time. In this video; Rafiq Wayani demonstrates the properties of a readable secondary replica and the benefits associated with directing read-only connections to readable secondary replicas.
-
Rebuild and Reorganize Indexes
Microsoft SQL Server 2012 allows you to rebuild and reorganize indexes. In this video; Jonathan Summers demonstrates how to remedy index fragmentation by reorganizing or rebuilding an index using both Object Explorer in SQL Server Management Studio; and TSQL code.
-
Record Set
Microsoft SQL Server 2012 Integration Services' Recordset Destination allows you to create and populate an in-memory ADO recordset written to an Object variable at runtime. In this video; David Dye populates a recordset written to an Object variable and enumerates it with a Foreach Loop Container that writes its values to defined variables.
-
Replicate
Microsoft SQL Server 2012 allows users to specify a range of options once replication has been set up. In this video; Rafiq Wayani demonstrates replication settings; such as components and scheduling; for both near-time and real-time replication.
-
Replication Setup
Microsoft SQL Server 2012 allows users to set up replication to copy databases across multiple environments in real time. In this video; Rafiq Wayani demonstrates how replication creates redundancy and allows a fully current secondary server to take over from a primary server in real time.
-
Restore Database
Once your database is backed up; Microsoft SQL Server 2012 allows you to easily restore the database helping you avoid potentially catastrophic data loss caused by a variety of failures. In this video; Rafiq Wayani uses the SQL Server Management Studio Restore Dialog box to restore an existing database backup file.
-
Result Set
Microsoft SQL Server 2012 Integration Services provides the ability to use an Execute SQL statement to capture a result set. In this video; David Dye demonstrates how to do this in two different ways: using the result set or an output parameter.
-
Review of the Previous Management Portal
Because the new Windows Azure Management Portal is still under development; you may need to access the previous management portal to perform certain tasks. In this video; Jonathan Summers demonstrates how to access the older management portal and runs through which tasks you would still use it for.
-
Review Unused Indexes
Microsoft SQL Server 2012 provides configuration options for reviewing unused indexes. In this video; Rafiq Wayani explains how to review unused indexes if you have too many indexes associated with a table.
-
Role Switching
In Microsoft SQL Server 2012; you can switch servers between their designated roles. In this video; Rafiq Wayani demonstrates conceptually how one server can take the place of another server in the event of a system failure.
-
Row Count
Microsoft SQL Server 2012 Integration Services' Row Count transformation allows you to count rows passed through a data flow and then store the count in a variable. In this video; David Dye uses a Row Count transformation to count the rows passed to it by an OLE DB data source; and stores the row count in a flat file variable.
-
Row Sampling
In Microsoft SQL Server 2012; the SQL Server Integration Services (SSIS) Row Sampling transformation allows you to randomly select a fixed number of rows from a source data set. In this video; David Dye uses the Row Sampling Transformation Editor dialog box to configure a random sampling of rows from a data source.
-
Script Error Handling
Microsoft SQL Server 2012 allows you to use DTS fire advanced methods to assist with error handling in Integration Services scripts. In this video; David Dye demonstrates how to specify a warning; rather than an error; to debug scripts and better handle queries and information.
-
Script Task
Microsoft SQL Server 2012 provides a Script Task feature that can be used to perform functions that are not provided by Integration Services. In this video; David Dye demonstrates how to use a Script Task within Integration Services as a debugging tool; and discusses various configuration properties.
-
Secure Server 2012
Microsoft SQL Server 2012 allows users to secure SQL Server from within SQL Server 2012 itself or secure the SQL Server 2012 platform. In this video; Rafiq Wayani demonstrates a range of security settings; including secure login; backup; authentication; auditing; permissions; and database encryption.
-
Secure Stored Procedures
Microsoft SQL Server 2012 allows you to enhance the security of stored procedures by obfuscating data through its encryption mechanism. In this video; Rafiq Wayani highlights the differences between creating a stored procedure without encryption and using the WITH ENCRYPTION T-SQL keyword to secure stored procedures in a database.
-
Send Mail
Microsoft SQL Server 2012 Integration Services' Send Mail Task allows you to receive e-mail notifications of errors within your packages. In this video; David Dye configures the Send Mail Task on the Event Handler of an Execute SQL Task; utilizing expressions; as well as user and system-defined variables; to define the message body; subject; and recipients.
-
Sequence
Microsoft SQL Server 2012 Integration Services allow you to use Sequence containers to define control flows forming subsets of your package's overall control flow. In this video; David Dye demonstrates how to disable propagation and the FailParentOnFailure property on a task to ensure the successful execution of a sequence to maintain control flow.
-
Set Up SQL Cluster
Microsoft SQL Server 2012 allows you to create a SQL Server cluster by installing the Failover Clustering feature on your servers. In this video; Rafiq Wayani uses Server Manager to install Failover Clustering on both his servers before explaining the need for network cards for internal communications between the two failover clusters and for external communication.
-
Sort
The Sort transformation in Microsoft SQL Server 2012 sorts input data and copies the sorted data to the transformation output; although it can be costly in terms of resources. In this video; David Dye demonstrates the Sort transformation and explains when you would use it.
-
Spatial Data
Microsoft SQL Server 2012 allows users to work with spatial data in a spatial database. In this video; Rafiq Wayani explains what spatial data is; its relation to geographical information systems (GIS); and why it cannot be stored in standard database tables.
-
Split Transformation
Microsoft SQL Server 2012 allows you to use a conditional Split transformation to dynamically route the data through a data flow. In this video; David Dye demonstrates how to split a list of employees into managers and non-managers using a Split transformation on two different tables.
-
SQL Backup
Microsoft SQL Server 2012 allows you to easily create database backups using SQL Server Management Studio so you can safeguard critical data. In this video; Rafiq Wayani uses the Back Up Database dialog box in Management Studio to create a full database backup; and demonstrates how to drop the database using the Detach Database dialog box.
-
SQL Cluster
In Microsoft SQL Server 2012; creating a Windows Server Failover Cluster (WSFC) provides high database availability and is necessary when installing SQL Server in a clustered environment. In this video; Rafiq Wayani demonstrates how to download and use the Microsoft iSCSI Initiator; create iSCSI virtual disks; and establish iSCSI targets while creating a WSFC.
-
SQL Database Connection Security
Windows Azure SQL Database enables you; by way of certificates issued by a Certification Authority; to ensure secure connections between your local computers and your hosted SQL databases. In this video; Jonathan Summers uses the Microsoft Management Console to import a self-signed certificate into a Personal certificate store; and then into Windows Azure SQL Database.
-
SQL Database Connectivity Troubleshooting
Windows Azure SQL Database is hosted in a cloud environment and you may experience connectivity issues from time to time that you will be required to locate and troubleshoot as efficiently as possible. In this video; Jonathan Summers highlights some of the common connectivity issues that you may encounter in Windows Azure and explains how they can be resolved.
-
SQL Errors
Microsoft SQL Server 2012 allows T-SQL errors to be handled in two phases; firstly to check syntax; and secondly; object reference names. In this video; Rafiq Wayani demonstrates how an invalid T-SQL statement can bypass the first phase because it's syntactically correct; but is caught in the second phase; and details different T-SQL error severity levels.
-
SQL on Server Core
Microsoft SQL Server 2012 provides configuration options for installing SQL Server on a Server Core operating system platform. In this video; Rafiq Wayani explains how to install SQL Server 2012 on Server Core.
-
SQL Second Instance
In Microsoft SQL Server 2012; you can create a second instance of SQL server and have it run on the same machine. In this video; Rafiq Wayani discusses how to access a second instance of SQL server and if it will affect the cluster in some way.
-
SQL Server Agent
Microsoft SQL Server 2012 provides SQL Server Agent which can be used to automate tasks; such as monitoring performance. In this video; David Dye demonstrates how to configure SQL Server Agent to schedule Integration Services packages.
-
SQL Server and PowerShell
Microsoft SQL Server 2012 provides direct access to PowerShell; allowing users to run DOS-like commands on the current database. In this video; Rafiq Wayani demonstrates how to access PowerShell from within SQL Server 2012; and how to work with a database by selecting and exporting specific data.
-
SQL Virtualization Concept
In Microsoft SQL Server 2012; you can install SQL Server on a virtual platform. In this video; Rafiq Wayani demonstrates the SQL Virtualization Concept within the VMware virtual environment and explains how the VMware Datacenter organizes virtual machines within a physical machine.
-
SSDT
In Microsoft SQL Server 2012; SQL Server Data Tools (SSDT) are used to create and configure SQL Server Integration (SSIS) packages. In this video; David Dye demonstrates the main components of the SSDT development environment; how they can be customized; and how to access package information during design and at runtime using the different tabs.
-
SSIS Reports
Microsoft SQL Server 2012 Integration Services Catalog provides a range of precompiled reports; as well as the ability to create custom drill-through reports. In this video; David Dye demonstrates how to access a failure report and view the relationship between logging configurations and the level of detail in the report.
-
SSIS Transactions
In Microsoft SQL Server 2012; you can configure the transactions that SQL Server Integration Services (SSIS) packages use to bind the actions that perform tasks. In this video; David Dye demonstrates how to configure the TransactionOption property and start the Distributed Transaction Coordinated service in order to roll back the data flow in a Sequence container when a task fails.
-
Stored Functions
Microsoft SQL Server 2012's stored functions force a query to return a value. Scalar functions wrapped in a BEGIN...END block return a single data value in the RETURNS clause. In this video; Rafiq Wayani demonstrates how to create a function and queries its protocol to show that the result depends on the defined protocol.
-
Stored Procedures Passing Parameters
Microsoft SQL Server 2012 allows you to declare input and output parameters so values can be passed to and from a stored parameter used for a variety of purposes during procedure execution. In this video; Rafiq Wayani demonstrates how to create a stored procedure which includes syntax to declare and execute an OUTPUT parameter.
-
Test Mirror
Microsoft SQL Server 2012; when implemented in a virtual environment; allows users to implement fault tolerance by mirroring databases. In this video; Rafiq Wayani demonstrates how to test a mirror to ensure that it's able to take over from the primary server without impacting user productivity.
-
Test Replicate
Microsoft SQL Server 2012 allows users to test that replication functions as it should. In this video; Rafiq Wayani demonstrates how to test that replication works and that the replication data is accurate.
-
Test SQL Cluster
Microsoft SQL Server 2012 provides configuration options for testing SQL Server on a cluster. In this video; Rafiq Wayani explains how to test a SQL Server on a Windows database cluster.
-
The Windows Azure Platform Management Portal Overview
Windows Azure SQL Database's platform management portal enables centralized management and administration; allowing you to initiate and complete subscription and production tasks from intuitive navigation bars and menus. In this video; Jonathan Summers introduces the key navigation bars and menus in the management portal.
-
Throw Exceptions
Error throwing in SQL Server 2012 allows you to better understand exceptions that have been raised and caught. In this video; Rafiq Wayani uses a throw statement to display the specific error message generated when an exception is raised.
-
Track Missing Indexes
Microsoft SQL Server 2012 provides configuration options for tracking missing indexes. In this video; Rafiq Wayani explains how to create an index seek to track missing indexes on a non-clustered index.
-
Transactions Native
In Microsoft SQL Server 2012; you can avoid the extra overhead incurred when utilizing Integration Services transactions to roll back tasks by implementing Transact-SQL native transactions instead. In this video; David Dye uses Transact-SQL statements to implement native transactions and provide the ability to roll back multiple tasks in an SSIS package.
-
Transfer Database
In Microsoft SQL Server 2012; you can use the Transfer Database Task in SQL Server Management Studio and SQL Server Data Tools to copy or move a database from one instance to another. In this video; David Dye demonstrates the different configuration options available when you copy or move a database.
-
Transfer Objects
In Microsoft SQL Server 2012; you can use the Transfer Objects Control Flow Task to transfer objects from one database to another. In this video; David Dye demonstrates how the Transfer Objects Control Flow Task can be used for a number of different transfer tasks.
-
Troubleshoot Clusters
Microsoft SQL Server 2012 provides configuration options for installing SQL Server on a cluster. In this video; Rafiq Wayani demonstrates how to install SQL Server on a Windows cluster that has already been created and validated.
-
Try Convert Function
Microsoft SQL Server 2012 introduces the TRY_CONVERT function; which returns a null value if any errors are encountered while converting an expression to another data type. In this video; Jonathan Summers demonstrates how the TRY_CONVERT function works to ensure that your application will not be impacted if there is an error when converting.
-
TSQL Parameters
Microsoft SQL Server 2012 Integration Services allow you to assign and implement parameter values in T-SQL statements. In this video; David Dye uses the Execute SQL Task Editor to map input and output parameters to variables in a stored procedure.
-
Understand Stats
In Microsoft SQL Server 2012; understanding query optimization statistics is an important part of improving query performance and modifying a query for the best results. In this video; Rafiq Wayani uses the New Statistics on Table dialog box in Management Studio to create statistics; and highlights some of the statistical information used by the query optimizer.
-
Unions All
In Microsoft Visual Studio 2012; you can use Union All to combine the result-set of two or more select statements into a single result-set that retains all duplicate entries. In this video; David Dye demonstrates how to join two sources together using the Union All set operator.
-
Unsecured Access
Microsoft SQL Server 2012 allows you to secure data in a database using encryption to avoid unauthorized access to unencrypted data. In this video; Rafiq Wayani demonstrates how to create a database and back up the data to a secure .bak file.
-
Using SQL Agent
Microsoft SQL Server 2012 allows users to schedule and submit jobs using the SQL Server Agent. In this video; Rafiq Wayani demonstrates how to create and submit a new job; and then monitor its activity.
-
Using Try Catch
Microsoft SQL Server 2012's T-SQL structured TRY...CATCH construct and THROW statement allows you to raise errors in the TRY block and pass control of them to the CATCH block. In this video; Rafiq Wayani contrasts the capabilities of the TRY...CATCH construct with the @@ERROR type; and demonstrates how the THROW statement identifies the source of the error.
-
Validate Cluster
Microsoft SQL Server 2012 allows you to use the cluster validation process to validate the computers on the network on which you wish to install your SQL Server cluster. In this video; Rafiq Wayani uses the Failover Cluster Manager's Validate a Configuration Wizard to name and validate his machines' hardware.
-
View History of Logical Server
In Microsoft SQL Server 2012; you can use the server history to keep track of the activity taking place on your database. In this video; Jonathan Summers demonstrates how to access and view the history for import and export operations carried out on a server.
-
Character Map
In Microsoft SQL Server 2012; you can configure the Character Map Transformation Task to modify how information is displayed. In this video; David Dye uses the Character Map Transformation Task on information in a database to transform people's middle names into uppercase.
-
Access FILESTREAM Data
FILESTREAM in Microsoft SQL Server 2012 integrates the SQL Server Database Engine with an NTFS file system and is completely transparent to Transact-SQL code; allowing you to access data in FILESTREAM columns just as you would any conventional columns. In this video; Jonathan Summers uses T-SQL statements to insert; update; and delete rows in a table that supports FILESTREAM data.
-
Access Secured
Microsoft SQL Server 2012 provides the capability to secure data in a database using encryption. In this video; Rafiq Wayani demonstrates how to access data in the unencrypted database; how to encrypt the data; and shows that; once it has been encrypted; the data cannot be accessed.
-
Adding Custom Error Messages
Microsoft SQL Server 2012 allows system administrators to use the sp_addmessage stored procedure to add custom error messages which are then issued as native errors. In this video; Rafiq Wayani uses the sp_addmessage stored procedure to define and execute a custom error; and explains the WITH LOG option available to system administrators.
-
Advanced Cycled Sequences
In Microsoft SQL Server 2012; you can alter a sequence to produce a different result when you run it again. In this video; Rafiq Wayani demonstrates how to change the sequence statement to begin the sequence at a different value when the sequence is restarted.
-
Advanced Move Encrypted Data
Microsoft SQL Server 2012 provides the capability of moving secure data from one location to another. In this video; Rafiq Wayani demonstrates how to delete the certificate and the master key; and then restore the database from the backup on a disk.
-
Advanced Sequences
In Microsoft SQL Server 2012 you can go beyond the basic uses of sequences by using a number of advanced features. In this video; Rafiq Wayani demonstrates how to create a sequence to supply audit information from tables.
-
Advanced Sequences in Multiple Tables
One advantage of using sequences in Microsoft SQL Server 2012 is that they can be used with multiple tables. In this video; Rafiq Wayani demonstrates how to generate recurring number sequences and use the same sequence object across multiple tables to produce a result set.
-
Audit
Microsoft SQL Server 2012 provides various configuration options for utilizing an Audit Transformation within a data flow; as well as the ability to capture information at the time of packages executed. In this video; David Dye demonstrates how to use the Audit Transformation tool within a data flow task.
-
Availability Modes
In Microsoft SQL Server 2012; AlwaysOn Availability Groups support two modes that are properties used to regulate whether the primary replica waits to commit transactions on a database until a secondary replica has hardened the log. In this video; Rafiq Wayani demonstrates how AlwaysOn Availability Groups support the asynchronous-commit availability mode and the synchronous-commit availability mode.
-
Basic Sequence
Microsoft SQL Server 2012 allows users to create sequences as database objects which can be used on any table in the database. In this video; Rafiq Wayani demonstrates how to create and call a sequence.
-
BCP Utility
In Microsoft SQL Server 2012; you can easily export and import bulk data from a database; file; or table. In this video; Rafiq Wayani demonstrates how to use the bulk copy utility; also called the bcp utility; to export and import data.
-
Built-In Aggregate Functions
The built-in aggregate functions in Microsoft SQL Server 2012 can be applied to a set of records where they perform calculations on column values in order to summarize the data and return a single value. In this video; Jonathan Summers demonstrates how to use the COUNT grouped aggregate function to perform a calculation.
-
Built-In Functions
Microsoft SQL Server 2012 provides a number of new features; one of which is the ability to do efficient paging. In this video; Rafiq Wayani demonstrates how to do paging using the offset; fetch; next rows; and only keywords.
-
Built-In Functions Enhancements
Microsoft SQL Server 2012 provides various enhancements to built-in functions. In this video; Rafiq Wayani demonstrates how to use the choose logical function; the inline if (iif) function; the concat function to concatenate values; and the format function to specify value formats such as date.
-
Built-In Security Functions
The built-in security functions in Microsoft SQL Server 2012 provide a useful way of managing security by allowing you to return information about users and roles. In this video; Jonathan Summers demonstrates how to return a database username from a specified user ID using the USER_NAME security function.
-
Built-In Test and Image Functions
The built-in test and image scalar functions in Microsoft SQL Server 2012 allow you to perform an operation on a text or image input value or column and return information about the value. In this video; Jonathan Summers discusses the three test and image functions and demonstrates how to use the PATINDEX function.
-
Built-In Windows Functions
Windows functions have been enhanced in Microsoft SQL Server 2012 and additional functions have been provided that can be applied to a result sets partitioned rows in order to compute aggregate values. In this video; Jonathan Summers uses the RANK function to return the rank of each row within the partition of a result set.
-
Bulk Insert
In Microsoft SQL Server 2012; you can configure and use the Bulk Insert Task to bulk insert data. In this video; David Dye demonstrates how to use a Bulk Insert Task and discusses the differences between a Data Flow Task and the Bulk Insert Task.
-
Bypass Prepare
Microsoft SQL Server 2012 Integration Services allow tasks to use the BypassPrepare property so they can bypass the prepare command which doesn't support certain T-SQL keywords. In this video; David Dye demonstrates how a task is able to successfully prepare on execution when BypassPrepare is set to True.
-
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.
-
Always Encrypted
After watching this video; you will be able to use the Always Encrypted feature of SQL Server 2016.
-
AlwaysOn
After watching this video; you will be able to use the enhanced AlwaysOn high availability in SQL Server 2016.
-
In-Memory OLTP
After watching this video; you will be able to use the updated in-memory OLTP for SQL Server 2016.
-
Installing CTP2
After watching this video; you will be able to install the second community technical preview of SQL Server 2016.
-
Native JSON
After watching this video; you will be able to use native JSON in SQL Server 2016 databases.
-
PolyBase
After watching this video; you will be able to use PolyBase to access data stored in Hadoop or Azure Blob Storage from SQL Server 2016.
-
Real-time Operational Analytics
After watching this video; you will be able to use real-time operational analytics in SQL Server 2016.
-
Row Level Security
After watching this video; you will be able to enforce row level security in SQL Server 2016.
-
SQL 2016 and Azure SQL Data Warehouse
After watching this video; you will be able to connect SQL Server 2016 and Azure SQL Data Warehouse.
-
SQL Server 2016 Interface
After watching this video; you will be able to navigate the interface of SQL Server 2016.
-
Stretch Database
After watching this video; you will be able to use Stretch Database to extend your SQL Server 2016 database to Azure SQL Database.
-
Temporal Tables
After watching this video; you will be able to use the new Temporal Tables feature in SQL Server 2016.
-
Using the Query Store
After watching this video; you will be able to use the new SQL Server 2016 Query Store.
-
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.
-
Altering and Dropping Databases
After watching this video; you will be able to using SMSS and DDL; use; alter; and drop SQL Server databases.
-
Altering and Dropping Tables
After watching this video; you will be able to using SMSS and DDL; alter and drop SQL Server tables.
-
Backing up Databases with SSMS
After watching this video; you will be able to use SQL Server to back up databases.
-
Bulk Inserts
After watching this video; you will be able to use BULK INSERT to insert data into a SQL Server database.
-
Column Design
After watching this video; you will be able to define the standards used in column design and its properties such as auto increment columns; default and null values; and modifying size and format in the context of SQL Server examples.
-
Combining Result Sets
After watching this video; you will be able to use the UNION statement to combine the results from multiple SELECT statements executed on a SQL Server database.
-
Creating and Assigning Permissions
After watching this video; you will be able to create; assign; and manage permissions to a SQL Server login .
-
Creating and Using Stored Procedures
After watching this video; you will be able to create and use stored procedures in SQL Server databases.
-
Creating Databases
After watching this video; you will be able to using SMSS and DDL; create a new SQL Server database with its specific syntax and parameters and review its schema.
-
Creating Indexes
After watching this video; you will be able to create clustered and nonclustered indexes in SQL Server databases.
-
Creating Views
After watching this video; you will be able to describe the purpose and performance impact of views and create a view in a SQL Server database by using SMSS graphical designer or by using T-SQL.
-
Data Integrity and Constraints
After watching this video; you will be able to describe the importance of data integrity to related database tables and list the methods for enforcement.
-
Data Types
After watching this video; you will be able to describe the data types supported by SQL Server.
-
DBMS and RDBMS
After watching this video; you will be able to define database management systems (DBMS) and relational database management systems (RDBMS).
-
Exercise: Creating and Normalizing Tables
After watching this video; you will be able to use the appropriate commands to create and normalize tables in a SQL Server database.
-
Exploring Server and User-defined Roles
After watching this video; you will be able to using SMSS; identify and describe SQL Server fixed and user-defined server and database roles; the guest account and how to revoke it.
-
Filtering Results
After watching this video; you will be able to use SELECT statements with WHERE; AND; NOT; BETWEEN to filter results.
-
Indexes
After watching this video; you will be able to describe clustered and nonclustered indexes in the context of their use in a SQL Server database.
-
Inserting Data
After watching this video; you will be able to describe how data is inserted into a database and use INSERT statements to insert one or more rows into a SQL Server database.
-
Introducing Databases
After watching this video; you will be able to define a database; describe how data is stored in tables containing records and fields; and describe flat; hierarchal; and relational databases.
-
Introducing SQL Server Management Studio (SSMS)
After watching this video; you will be able to describe the purpose of and navigate SQL Server Management Studio (SSMS); a SQL Server instance; and its objects .
-
Manipulating Result Sets
After watching this video; you will be able to use INTERSECT and EXCEPT to compare and extract data from result sets returned from SQL Server data.
-
Normalization Guidelines - 1NF
After watching this video; you will be able to describe the normalization guidelines for relational databases and define the first normal form (1NF).
-
Normalization Guidelines - 2NF
After watching this video; you will be able to describe the normalization guidelines for relational databases and define the second normal form (2NF).
-
Normalization Guidelines - 3NF
After watching this video; you will be able to describe the normalization guidelines for relational databases and define the third normal form (3NF).
-
Ordering Result Sets
After watching this video; you will be able to use the ORDER By clause to order result sets returned from a SELECT statement.
-
Overview of Database Backup and Restore
After watching this video; you will be able to list the options available in SQL Server for database backups and restores.
-
Overview of Database Security
After watching this video; you will be able to describe the main considerations for relational database security.
-
Restoring Databases with SSMS
After watching this video; you will be able to use SQL Server to restore databases.
-
SQL; DDL; and DML
After watching this video; you will be able to describe the purpose of SQL; DDL; and DML statements in the context of SQL Server.
-
Table and Column Properties
After watching this video; you will be able to define the table and column properties such as collation; data type; size; and field properties in the context of SQL Server examples.
-
Table Design
After watching this video; you will be able to define the standards used in tables for data storage such as removing duplicates; breaking down fields; and the use of primary keys in the context of SQL Server examples.
-
Transactions
After watching this video; you will be able to use transactions with SQL server to ensure data and referential integrity.
-
Truncating Tables
After watching this video; you will be able to compare TRUNCATE to DELETE and use the TRUNCATE command to remove data from a SQL Server table.
-
Using Aggregate Functions
After watching this video; you will be able to use SQL Server aggregate functions; COUNT; AVG; MIN; MAX to return specific result sets.
-
Using Cross Joins
After watching this video; you will be able to use CROSS JOINS to retrieve data from multiple SQL Server tables.
-
Using DML Statements
After watching this video; you will be able to use DML statements to query; update; and delete data in a SQL Server database.
-
Using SELECT statements
After watching this video; you will be able to use SELECT statements to query tables and columns.
-
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.
-
Overview of Normalization
After watching this video; you will be able to describe the purpose of normalizing relational databases.
-
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.
-
Authentication
In Microsoft SQL Server 2012; you can authenticate user credentials and logins. In this video; Rafiq Wayani demonstrates how to use the asymmetric key algorithm to authenticate SQL logins.
-
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.
-
Expressions
In Microsoft SQL Server 2012; you can use an integration services expression to assign or change variable values within the expression task. In this video; David Dye demonstrates how you can use the Expressions Control Flow Task to assign and utilize integration services expressions language.
-
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.
-
Stored Procedures
Microsoft SQL Server 2012 allows you to create precompiled sets of one or more statements as Transact-SQL stored procedures that are stored in the database; enabling an efficient reuse of SQL code. In this video; Rafiq Wayani demonstrates how to create; execute; modify; locate; and remove a stored procedure.
-
Creating Tables
After watching this video; you will be able to using SMSS and DDL; create SQL Server tables and define their properties.
-
Variables
Microsoft SQL Server 2012 allows users to set scopes; data types; and expressions within variables. In this video; David Dye demonstrates how to work with the scope of a variable and retrieve information during package execution.
-
Updating Data
After watching this video; you will be able to describe how data is updated to a SQL Server database and use appropriate UPDATE statements.
-
Deleting Data
After watching this video; you will be able to use DELETE to delete data from single or multiple SQL Server tables.
-
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.
-
Microsoft SQL Server 2016: Multiple Instances of SQL Server
After watching this video, you will be able to describe the three approaches you can use to manage memory when running multiple instances of the database engine.
-
Microsoft SQL Server 2016: SQL Server Management Studio Memory Management
After watching this video, you will be able to demonstrate how to configure memory options including min server memory and max server memory.
-
Microsoft SQL Server 2016: Configuring and Viewing Memory Using T-SQL
After watching this video, you will be able to demonstrate how to configure and view memory options using T-SQL.
-
Microsoft SQL Server 2016: SQL Server Operators
After watching this video, you will be able to describe the role of operators in SQL Server 2016.
-
Microsoft SQL Server 2016: Creating an Operator in SQL Server 2016
After watching this video, you will be able to demonstrate how to create an operator in SQL Server 2016.
-
Microsoft SQL Server 2016: Deleting an Operator in SQL Server 2016
After watching this video, you will be able to perform the necessary steps to delete an operator in SQL Server 2016.
-
Microsoft SQL Server 2016: Viewing Operator Information
After watching this video, you will be able to access and view operator information in SQL Server 2016.
-
Microsoft SQL Server 2016: Designating a Fail-safe Operator
After watching this video, you will be able to demonstrate how to designate a fail-safe operator in SQL Server 2016.
-
Microsoft SQL Server 2016: Configuring Operator Availability
After watching this video, you will be able to demonstrate how to configure operator availability in SQL Server 2016.
-
Microsoft SQL Server 2016: Editing an Existing Operator
After watching this video, you will be able to edit an existing operator in SQL Server 2016.
-
Microsoft SQL Server 2016:: Configure Encryption in Azure SQL
After watching this video, you will be able to configure encryption for Azure SQL Databases.
-
Microsoft SQL Server 2016: Elastic Database Pools
After watching this video, you will be able to configure elastic database pools to scale resources automatically.
-
Microsoft SQL Server 2016: Configuring the Database Scope
After watching this video, you will be able to configure the database scope in SQL Server 2016.
-
Microsoft SQL Server 2016: Evaluate Database Performance
After watching this video, you will be able to describe how to evaluate and tune database performance.
-
Microsoft SQL Server 2016: Changing Service Tiers
After watching this video, you will be able to demonstrate how to improve performance by changing service tiers.
-
Microsoft SQL Server 2016: Configuring Availability Sets for Redundancy
After watching this video, you will be able to demonstrate how to configure multiple VMs in an availability set for redundancy.
-
Microsoft SQL Server 2016: Configuring Application Tiers
After watching this video, you will be able to configure each application tier into separate availability sets for redundancy.
-
Microsoft SQL Server 2016: Data Compression
After watching this video, you will be able to explain how using data compression reduces overall I/O.
-
Microsoft SQL Server 2016: Microsoft Azure Platform Events
After watching this video, you will be able to describe the different types of platform events that can affect the availability of VMs.
-
Microsoft SQL Server 2016: Microsoft Azure VM Wizard
After watching this video, you will be able to migrate data using the Microsoft Azure VM wizard.
-
Microsoft SQL Server 2016: Connection Strings
After watching this video, you will be able to explain the role of connection strings.
-
Microsoft SQL Server 2016: Azure Load Balancer
After watching this video, you will be able to describe the benefits of combining Azure load balancer with availability sets.
-
Microsoft SQL Server 2016: Multiple Storage Accounts
After watching this video, you will be able to configure multiple storage accounts for each availability set.
-
Microsoft SQL Server 2016: VM Disk Options
After watching this video, you will be able to explain how to effectively tune data disks in Azure.
-
Microsoft SQL Server 2016: VM Disk Caching
After watching this video, you will be able to describe how VM disk caching works.
-
Microsoft SQL Server 2016: Creating and Starting the Pipeline
After watching this video, you will be able to demonstrate how to define, create, and start the pipeline.
-
Microsoft SQL Server 2016: Manage Data using Azure Data Factory
After watching this video, you will be able to manage data using the Azure Data Factory.
-
Microsoft SQL Server 2016: Microsoft Azure Import/Export Service
After watching this video, you will be able to explain the Microsoft Azure import/export service.
-
Microsoft SQL Server 2016: Benchmarking Overview
After watching this video, you will be able to describe the benefits of generating benchmark data.
-
Microsoft SQL Server 2016: Backing Up to a File and URL
After watching this video, you will be able to describe alternative deployment options such as backing up to a file and URL.
-
Microsoft SQL Server 2016: AZCopy Command-line Utility
After watching this video, you will be able to demonstrate how to detach and copy to URL and attach from URL using the AZCopy command-line utility.
-
Microsoft SQL Server 2016: Running IOMeter Tests
After watching this video, you will be able to demonstrate how to use the IOMeter tool to gather benchmark data.
-
Microsoft SQL Server 2016: FIO Tool
After watching this video, you will be able to explain how the FIO tool can be used to gather benchmark data on Azure VMs.
-
Microsoft SQL Server 2016: Cache Warming
After watching this video, you will be able to explain why it is important to perform cache warming prior to gathering benchmark data.
-
Microsoft SQL Server 2016: IOMeter Tool
After watching this video, you will be able to describe the Iometer tool and how it can be used to gather benchmark data.
-
Microsoft SQL Server 2016: Azure VM Deployment Wizard
After watching this video, you will be able to demonstrate how to use the Azure VM deployment wizard.
-
Microsoft SQL Server 2016: Microsoft Azure Database Wizard
After watching this video, you will be able to demonstrate how to migrate a SQL Server database using the Microsoft Azure database wizard.
-
Microsoft SQL Server 2016: Compatibility Testing
After watching this video, you will be able to recognize the tools available to test for SQL Database compatibility.
-
Microsoft SQL Server 2016: Migrating Non-SQL Server Databases
After watching this video, you will be able to describe how to migrate a non-SQL Server database.
-
Microsoft SQL Server 2016: Azure Data Factory
After watching this video, you will be able to explain the Azure data factory.
-
Microsoft SQL Server 2016: Comparing Migration Methods
After watching this video, you will be able to describe tools used to fix issues detected during a database migration.
-
Microsoft SQL Server 2016: Creating a BACPAC File
After watching this video, you will be able to demonstrate how to create a BACPAC file to use in a database migration.
-
Microsoft SQL Server 2016: Creating Linked Services
After watching this video, you will be able to create linked services that connect to data sources in Azure data factory.
-
Microsoft SQL Server 2016: Creating Tables to Access Datasets
After watching this video, you will be able to define and create tables to specify how to access datasets.
-
Microsoft SQL Server 2016: Data Transformation Activities
After watching this video, you will be able to describe the data transformation activities supported by Azure data factory.
-
Microsoft SQL Server 2016: Installing the Data Management Gateway
After watching this video, you will be able to demonstrate how to install the data management gateway.
-
Microsoft SQL Server 2016: Assigning Alerts to an Operator in SQL Server 2016
After watching this video, you will be able to assign alerts to an operator in SQL Server 2016.
-
Microsoft SQL Server 2016: Managing Alerts in SQL Server 2016
After watching this video, you will be able to manage alerts in SQL Server 2016.
-
Microsoft SQL Server 2016: Monitoring Metrics
After watching this video, you will be able to configure alerts based on monitoring metrics in SQL Server 2016.
-
Microsoft SQL Server 2016: Creating an Alert Rule on a Metric
After watching this video, you will be able to create an alert rule on a metric within the Azure portal.
-
Microsoft SQL Server 2016: Architectural Considerations
After watching this video, you will be able to recognize the architectural considerations that influence choosing between a single vs multi tenant.
-
Microsoft SQL Server 2016: Multiple Tenant Considerations
After watching this video, you will be able to explain considerations, such as economic, security, tenant, relating to multiple tenants.
-
Microsoft SQL Server 2016: Single Tenant vs Multi Tenant
After watching this video, you will be able to explain the difference between single tenant and multi tenant data architectures.
-
Microsoft SQL Server 2016: Deploying Applications to Azure SQL Database
After watching this video, you will be able to demonstrate how to manage deployments that support multiple tenants.
-
Microsoft SQL Server 2016: Migrating a Database Overview
After watching this video, you will be able to recognize the various steps and considerations involved with migrating on-premise SQL Server databases to Azure.
-
Microsoft SQL Server 2016: Managing Multi-tenant Data
After watching this video, you will be able to describe how to manage multi-tenant data in SQL Server 2016.
-
Microsoft SQL Server 2016: Isolating Tenant Data
After watching this video, you will be able to describe the benefits of partitioning and isolating tenant data.
-
Microsoft SQL Server 2016: Migration Methods
After watching this video, you will be able to describe the primary migration methods available when migrating to Azure VMs.
-
Microsoft SQL Server 2016: Azure VMs and Cloud Services
After watching this video, you will be able to describe the 2-tier and 3-tier using the Azure VMs and Cloud services application pattern.
-
Microsoft SQL Server 2016: N-Tier Hybrid
After watching this video, you will be able to explain the N-Tier hybrid application pattern.
-
Microsoft SQL Server 2016: Business Tier Scale Out
After watching this video, you will be able to describe the business tier scale out application pattern.
-
Microsoft SQL Server 2016: High Availability and Disaster Recovery
After watching this video, you will be able to describe the 2-tier and 3-tier presentation and business tiers scale out and HADR application pattern.
-
Microsoft SQL Server 2016: Create a Traffic Manager Profile
After watching this video, you will be able to demonstrate how to create a traffic manager profile.
-
Microsoft SQL Server 2016: Optimize Performance in SQL Server 2016
After watching this video, you will be able to optimize SQL Server 2016 database performance.
-
Microsoft SQL Server 2016: 3-Tier: Multiple Virtual Machine
After watching this video, you will be able to explain the 3-tier application pattern.
-
Microsoft SQL Server 2016: Presentation Tier Scale Out
After watching this video, you will be able to explain the presentation tier scale out application pattern.
-
Microsoft SQL Server 2016: Performance Traffic Routing
After watching this video, you will be able to explain the performance traffic routing method.
-
Microsoft SQL Server 2016: 1-Tier: Single Virtual Machine
After watching this video, you will be able to describe the 1-tier application pattern.
-
Microsoft SQL Server 2016: Retry Logic
After watching this video, you will be able to develop application retry connection logic.
-
Microsoft SQL Server 2016: Load Balancer
After watching this video, you will be able to describe the different options for distributing network traffic using Azure.
-
Microsoft SQL Server 2016: Explicit Storage Endpoint
After watching this video, you will be able to create a connection string to an explicit storage endpoint.
-
Microsoft SQL Server 2016: Parsing Connection Strings
After watching this video, you will be able to parse a connection string from a configuration file.
-
Microsoft SQL Server 2016: Weighted Traffic Routing
After watching this video, you will be able to explain the weighted traffic routing method.
-
Microsoft SQL Server 2016: Traffic Manager Overview
After watching this video, you will be able to describe the traffic manager feature found in Azure.
-
Microsoft SQL Server 2016: Priority Traffic Routing
After watching this video, you will be able to explain the priority traffic routing method.
-
Microsoft SQL Server 2016: Connection Strings for Azure Storage Accounts
After watching this video, you will be able to demonstrate how to create connection strings for Azure storage accounts.
-
Microsoft SQL Server 2016: Shared Access Signatures
After watching this video, you will be able to create a connection string using a shared access signature.
-
Microsoft SQL Server 2016: Storing Connection Strings
After watching this video, you will be able to describe the use of connection strings in Azure.
-
Microsoft SQL Server 2016: Transparent Data Encryption
After watching this video, you will be able to describe Transparent Data Encryption and the keys used for encrypting and decrypting data.
-
Microsoft SQL Server 2016: Using Transparent Data Encryption
After watching this video, you will be able to use Transparent Data Encryption.
-
Microsoft SQL Server 2016: Configure Connection Encryption
After watching this video, you will be able to enable encrypted connections to a database.
-
Microsoft SQL Server 2016: Troubleshooting Encryption
After watching this video, you will be able to troubleshoot encryption.
-
Microsoft SQL Server 2016: Using Encryption in SQL Server 2016
After watching this video, you will be able to configure encryption in SQL Server 2016.
-
Microsoft SQL Server 2016: Encryption with Azure SQL Database
After watching this video, you will be able to describe support and limitations for encryption with Azure SQL Database.
-
Microsoft SQL Server 2016: Backup Encryption
After watching this video, you will be able to describe the benefits, requirements, restrictions, methods, and recommended practices for backup encryption.
-
Microsoft SQL Server 2016: Creating an Encrypted Backup
After watching this video, you will be able to create an encrypted backup.
-
Microsoft SQL Server 2016: Cell-level Encryption
After watching this video, you will be able to recognize the purpose of cell-level encryption and how to use Transact-SQL and symmetric encryption to configure it.
-
Microsoft SQL Server 2016: Always Encrypted
After watching this video, you will be able to describe the features and limitations of Always Encrypted.
-
Microsoft SQL Server 2016: Using the Always Encrypted Wizard
After watching this video, you will be able to use the Always Encrypted Wizard.
-
Microsoft SQL Server 2016: Configuring Always Encrypted Using SSMS
After watching this video, you will be able to configure Always Encrypted using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Configuring Always Encrypted Using PowerShell
After watching this video, you will be able to configure Always Encrypted using PowerShell.
-
Microsoft SQL Server 2016: Encryption Features
After watching this video, you will be able to describe the encryption features supported in SQL Server 2016.
-
Microsoft SQL Server 2016: Managing SQL Server 2016 High Availability
After watching this video, you will be able to manage high availability in SQL Server 2016.
-
Microsoft SQL Server 2016: Configuring Read-Only Routing Using T-SQL
After watching this video, you will be able to configure read-only routing for an availability group using Transact-SQL.
-
Microsoft SQL Server 2016: Distributed Availability Groups
After watching this video, you will be able to describe the purpose of distributed availability groups.
-
Microsoft SQL Server 2016: Creating a Distributed Availability Group
After watching this video, you will be able to create a distributed availability group with Transact-SQL.
-
Microsoft SQL Server 2016: Configuring Cluster Shared Volumes
After watching this video, you will be able to configure cluster shared volumes.
-
Microsoft SQL Server 2016: Auto Update Statistics
After watching this video, you will be able to describe the purpose and characteristics of the auto_update_statistics option.
-
Microsoft SQL Server 2016: Implementing Auto Update Statistics
After watching this video, you will be able to implement Auto Update Statistics.
-
Microsoft SQL Server 2016: Implementing Statistics for Large Tables
After watching this video, you will be able to implement statistics for large tables.
-
Microsoft SQL Server 2016: Managing Indexes in SQL Server 2016
After watching this video, you will be able to manage indexes in SQL Server 2016.
-
Microsoft SQL Server 2016: Identifying Outdated Statistics
After watching this video, you will be able to identify and correct outdated statistics.
-
Microsoft SQL Server 2016: Improving Columnstore Index Performance
After watching this video, you will be able to improve columnstore index performance.
-
Microsoft SQL Server 2016: Defragmenting Columnstore Indexes
After watching this video, you will be able to defragment columnstore indexes.
-
Microsoft SQL Server 2016: Repairing Index Fragmentation Using T-SQL
After watching this video, you will be able to repair index fragmentation using Transact-SQL.
-
Microsoft SQL Server 2016: Identifying and Creating Missing Indexes
After watching this video, you will be able to use the Missing Indexes feature to identify missing indexes and to create them, if needed.
-
Microsoft SQL Server 2016: Finding and Removing Underutilized Indexes
After watching this video, you will be able to find and remove underutilized indexes.
-
Microsoft SQL Server 2016: Columnstore Indexes
After watching this video, you will be able to describe the purpose of columnstore indexes, as well as why and when to use them.
-
Microsoft SQL Server 2016: Windows Server Failover Clustering
After watching this video, you will be able to describe the capabilities provided by Windows Server Failover Clustering and its relationship to AlwaysOn components.
-
Microsoft SQL Server 2016: Health Monitoring
After watching this video, you will be able to describe how high availability is accomplished by monitoring cluster resources.
-
Microsoft SQL Server 2016: Creating an Availability Group
After watching this video, you will be able to create a new availability group.
-
Microsoft SQL Server 2016: Changing the Failover Mode
After watching this video, you will be able to change the failover mode in an AlwaysOn availability group.
-
Microsoft SQL Server 2016: AlwaysOn Availability Groups
After watching this video, you will be able to describe the features and benefits of AlwaysOn Availability Groups.
-
Microsoft SQL Server 2016: Failover
After watching this video, you will be able to describe the purpose of the failover process and the available failover modes.
-
Microsoft SQL Server 2016: Monitoring Log Shipping
After watching this video, you will be able to recognize the tables and stored procedures used for monitoring log shipping.
-
Microsoft SQL Server 2016: Log Shipping
After watching this video, you will be able to recognize the purpose and benefits of log shipping.
-
Microsoft SQL Server 2016: Configuring Log Shipping with SSMS
After watching this video, you will be able to configure log shipping with SQL Server Management Studio.
-
Microsoft SQL Server 2016: Configuring Log Shipping with T-SQL
After watching this video, you will be able to configure log shipping with Transact-SQL.
-
Microsoft SQL Server 2016: Log Shipping Management
After watching this video, you will be able to describe log shipping management tasks such as adding databases, removing log shipping, failing over, and changing roles.
-
Microsoft SQL Server 2016: Restoring a Database from an Azure URL
After watching this video, you will be able to perform a restore from an Azure storage account to an Azure VM.
-
Microsoft SQL Server 2016: Configuring Automatic SQL Server Updates in Azure VM
After watching this video, you will be able to configure automatic patching and updating of an Azure VM running SQL Server.
-
Microsoft SQL Server 2016: Create a Sysadmin Account
After watching this video, you will be able to demonstrate how to create a sysadmin account.
-
Microsoft SQL Server 2016: Elastic Database Pools
After watching this video, you will be able to explain elastic database pools.
-
Microsoft SQL Server 2016: Service Tiers
After watching this video, you will be able to explain service tiers in SQL Server 2016.
-
Microsoft SQL Server 2016: Common Service Tier Use Cases
After watching this video, you will be able to describe common service tier use cases.
-
Microsoft SQL Server 2016: Provision an Azure SQL Database
After watching this video, you will be able to describe how to provision an Azure SQL Server 2016 database.
-
Microsoft SQL Server 2016: Create an Azure SQL Database
After watching this video, you will be able to demonstrate how to create an Azure SQL Server 2016 database.
-
Microsoft SQL Server 2016: Selecting the Appropriate Service Tier
After watching this video, you will be able to describe when to use the appropriate service tier.
-
Microsoft SQL Server 2016: Database Transaction Units
After watching this video, you will be able to explain SQL Server 2016 database transaction units.
-
Microsoft SQL Server 2016: Customer Experience Improvement Program (CEIP)
After watching this video, you will be able to describe the customer experience improvement program (CEIP).
-
Microsoft SQL Server 2016: Upgrade Advisor
After watching this video, you will be able to demonstrate how to use the upgrade advisor in SQL Server 2016.
-
Microsoft SQL Server 2016: SQL Server Distributed Replay
After watching this video, you will be able to describe the SQL Server distributed replay feature.
-
Microsoft SQL Server 2016: Usage Scenarios
After watching this video, you will be able to recognize SQL Server Azure VM usage scenarios.
-
Microsoft SQL Server 2016: Licensing Considerations
After watching this video, you will be able to explain per-minute licensing.
-
Microsoft SQL Server 2016: Choose Server 2016 Installation Options
After watching this video, you will be able to determine the appropriate installation options and features for a given scenario.
-
Microsoft SQL Server 2016: SQL Server on Azure VM Overview
After watching this video, you will be able to explain SQL Server on Azure virtual machines.
-
Microsoft SQL Server 2016: Migrate a Database to a SQL Server Azure VM
After watching this video, you will be able to demonstrate how to migrate a database to a SQL Server Azure VM.
-
Microsoft SQL Server 2016: Backing up a Database to an Azure URL
After watching this video, you will be able to perform a backup of a database to an Azure storage account.
-
Microsoft SQL Server 2016: IaaS vs On-premises Deployment Options
After watching this video, you will be able to recognize the differences between IaaS and on-premises deployments.
-
Microsoft SQL Server 2016: Connecting to the SQL Server Azure VM
After watching this video, you will be able to demonstrate how to connect to a SQL Server Azure VM.
-
Microsoft SQL Server 2016: Unattended Installation Options
After watching this video, you will be able to recognize unattended installation options.
-
Microsoft SQL Server 2016: Performing an Unattended Installation
After watching this video, you will be able to perform an unattended SQL Server 2016 installation.
-
Microsoft SQL Server 2016: Post-installation Best Practices
After watching this video, you will be able to recognize post-installation best practices.
-
Microsoft SQL Server 2016: SQL Server Servicing Installation
After watching this video, you will be able to demonstrate SQL Server servicing installation.
-
Microsoft SQL Server 2016: Supported Upgrades
After watching this video, you will be able to recognize the supported upgrade paths for SQL Server 2016.
-
Microsoft SQL Server 2016: Data Migration Assistant
After watching this video, you will be able to use the data migration assistance in SQL Server 2016.
-
Microsoft SQL Server 2016: Creating an Upgrade Strategy
After watching this video, you will be able to create an upgrade strategy for SQL Server 2016.
-
Microsoft SQL Server 2016: Side-by-side Upgrade
After watching this video, you will be able to explain how and when to use the side-by-side upgrade option.
-
Microsoft SQL Server 2016: Hybrid and Rolling Upgrade Options
After watching this video, you will be able to describe hybrid and rolling upgrade options in SQL Server 2016.
-
Microsoft SQL Server 2016: Upgrading from SQL Server 2005
After watching this video, you will be able to explain how to upgrade from SQL Server 2005.
-
Microsoft SQL Server 2016: In-place Upgrade
After watching this video, you will be able to explain how and when to use the in-place upgrade option.
-
Microsoft SQL Server 2016: SQL Server 2016 Installation Requirements
After watching this video, you will be able to determine the requirements for a successful SQL Server deployment.
-
Microsoft SQL Server 2016: Tempdb Files
After watching this video, you will be able to explain SQL Server 2016 tempdb files.
-
Microsoft SQL Server 2016: SQL Installation Options
After watching this video, you will be able to describe SQL installation options.
-
Microsoft SQL Server 2016: Installing SQL Server 2016
After watching this video, you will be able to demonstrate how to install SQL Server 2016.
-
Microsoft SQL Server 2016: Tempdb Attributes
After watching this video, you will be able to describe tempdb attributes.
-
Microsoft SQL Server 2016: Tempdb Sizing
After watching this video, you will be able to understand tempdb sizing.
-
Microsoft SQL Server 2016: Creating a Dynamic Data Mask
After watching this video, you will be able to demonstrate how to create a dynamic data mask.
-
Microsoft SQL Server 2016: Configure Dynamic Data Masking in the Azure Portal
After watching this video, you will be able to demonstrate how to configure dynamic data masking using the Azure portal.
-
Microsoft SQL Server 2016: Querying for Masked Columns
After watching this video, you will be able to demonstrate how to query masked columns in SQL Server 2016.
-
Microsoft SQL Server 2016: Dynamic Data Masking Limitations and Restrictions
After watching this video, you will be able to explain the limitations and restrictions of dynamic data masking.
-
Microsoft SQL Server 2016: Configure Dynamic Data Masking Using PowerShell
After watching this video, you will be able to demonstrate how to configure dynamic data masking using PowerShell.
-
Microsoft SQL Server 2016: SQL Server Authorization
After watching this video, you will be able to explain how authorization can be used when securing SQL Server databases.
-
Microsoft SQL Server 2016: Dynamic Data Masking Polices and Permissions
After watching this video, you will be able to explain how to implement dynamic data masking policies and permissions.
-
Microsoft SQL Server 2016: Dynamic Data Masking Overview
After watching this video, you will be able to describe dynamic data masking.
-
Microsoft SQL Server 2016: Defining a Dynamic Data Mask
After watching this video, you will be able to describe the four types of dynamic data masks.
-
Microsoft SQL Server 2016: Authentication
After watching this video, you will be able to describe how to implement authentication in SQL Server 2016.
-
Microsoft SQL Server 2016: Contained Database Users
After watching this video, you will be able to describe considerations involving the implementation of contained database users.
-
Microsoft SQL Server 2016: Connection Security
After watching this video, you will be able to explain how to restrict and secure a connection to a SQL Server database.
-
Microsoft SQL Server 2016: TCP Ports
After watching this video, you will be able to explain how the connection process redirects machines to a different IP address and port.
-
Microsoft SQL Server 2016: Managing Logins and Users
After watching this video, you will be able to explain the restrictions involving managing logins and users.
-
Microsoft SQL Server 2016: SQL Database Auditing
After watching this video, you will be able to describe how to implement SQL database auditing.
-
Microsoft SQL Server 2016: Configuring SQL Server Firewall Rules
After watching this video, you will be able to demonstrate how to configure SQL Server 2016 firewall rules.
-
Microsoft SQL Server 2016: Managing Existing Firewall Rules in Azure
After watching this video, you will be able to demonstrate how to manage existing firewall rules in the Azure portal.
-
Microsoft SQL Server 2016: Determining Storage Configuration
After watching this video, you will be able to determine effective disk or storage configuration for a given scenario.
-
Microsoft SQL Server 2016: SQL Server Firewall
After watching this video, you will be able to describe the benefits of enabling a SQL Server firewall.
-
Microsoft SQL Server 2016: Buffer Pool Extension
After watching this video, you will be able to describe how SQL Server uses the buffer pool extension.
-
Microsoft SQL Server 2016: Configuring the Buffer Pool Extension
After watching this video, you will be able to demonstrate how to configure the storage buffer pool extension.
-
Microsoft SQL Server 2016: Creating User Databases
After watching this video, you will be able to demonstrate how to create user databases in SQL Server 2016.
-
Microsoft SQL Server 2016: Filegroups
After watching this video, you will be able to explain the use of filegroups in SQL Server 2016.
-
Microsoft SQL Server 2016: Other Storage Options
After watching this video, you will be able to describe other possible storage solutions, including NAS, DAS, and SAN.
-
Microsoft SQL Server 2016: Storage Spaces
After watching this video, you will be able to explain how storage spaces can be used in SQL Server 2016.
-
Microsoft SQL Server 2016: Storage Layouts for a SQL Server Virtual Machine
After watching this video, you will be able to describe storage layout considerations when using virtual machines.
-
Microsoft SQL Server 2016: Implementing RAID Levels
After watching this video, you will be able to explain the different types of RAID configurations.
-
Microsoft SQL Server 2016: SQL Server System Databases
After watching this video, you will be able to differentiate between the five SQL Server system databases.
-
Microsoft SQL Server 2016: Storage Considerations
After watching this video, you will be able to discuss considerations when planning disk storage devices.
-
Microsoft SQL Server 2016: Connect to an Azure SQL Database
After watching this video, you will be able to demonstrate how to connect to an Azure SQL Server 2016 database.
-
Microsoft SQL Server 2016: Hosting a SQL Server Instance Using Azure VMs
After watching this video, you will be able to explain how to host a SQL Server instance using Azure VMs.
-
Microsoft SQL Server 2016: Deploying SQL Server by Using Templates
After watching this video, you will be able to demonstrate how to deploy SQL Server using templates.
-
Microsoft SQL Server 2016: Data Storage Overview
After watching this video, you will be able to provide an introduction to data storage with SQL Server.
-
Microsoft SQL Server 2016: Azure Automation
After watching this video, you will be able to recognize the benefits of using Azure automation.
-
Microsoft SQL Server 2016: Azure Resource Manager
After watching this video, you will be able to explain how and when to use Azure resource manager.
-
Microsoft SQL Server 2016:: Determine Azure Deployment Options
After watching this video, you will be able to determine when to deploy SQL to Azure VMs and databases.
-
Microsoft SQL Server 2016: SQL Server Instances Overview
After watching this video, you will be able to describe SQL Server instances.
-
Microsoft SQL Server 2016: Use Cases for Cell-level Encryption
After watching this video, you will be able to recognize when to use cell-level encryption.
-
Microsoft SQL Server 2016: Security Permissions
After watching this video, you will be able to describe the security permissions required for cell-level encryption.
-
Microsoft SQL Server 2016: Configuring Cell-level Encryption
After watching this video, you will be able to demonstrate how to encrypt data using simple symmetric encryption.
-
Microsoft SQL Server 2016: Moving a TDE Protected Database
After watching this video, you will be able to discuss how to move a TDE protected database.
-
Microsoft SQL Server 2016: Always Encrypted (Database Engine)
After watching this video, you will be able to describe the Always Encrypted database engine feature.
-
Microsoft SQL Server 2016: Disable TDE Using the Azure Portal
After watching this video, you will be able to demonstrate how to disable TDE using the Azure portal.
-
Microsoft SQL Server 2016: Database Permissions
After watching this video, you will be able to describe the available database permissions in SQL Server 2016.
-
Microsoft SQL Server 2016: Use Cases for Cell-level Encryption
After watching this video, you will be able to recognize when to use cell-level encryption.
-
Microsoft SQL Server 2016: Common Use Cases
After watching this video, you will be able to recognize when to use the Always Encrypted feature in SQL Server 2016.
-
Microsoft SQL Server 2016: Configuring Always Encrypted
After watching this video, you will be able to configure Always Encrypted in SQL Server 2016.
-
Microsoft SQL Server 2016: Enable TDE Using PowerShell
After watching this video, you will be able to demonstrate how to enable and disable TDE using PowerShell.
-
Microsoft SQL Server 2016: TDE Considerations
After watching this video, you will be able to describe considerations when implementing TDE.
-
Microsoft SQL Server 2016: Enable TDE Using the Azure Portal
After watching this video, you will be able to demonstrate how to enable TDE using the Azure portal.
-
Microsoft SQL Server 2016: Configure Azure SQL Database Firewall Rules
After watching this video, you will be able to configure firewall rules in Azure SQL database.
-
Microsoft SQL Server 2016: Transparent Data Encryption Overview
After watching this video, you will be able to provide a general overview of transparent data encryption.
-
Microsoft SQL Server 2016: TDE Catalog Views
After watching this video, you will be able to describe the TDE catalog views in SQL Server 2016.
-
Microsoft SQL Server 2016: TDE Dynamic Management Views
After watching this video, you will be able to describe the TDE dynamic management views in SQL Server 2016.
-
Microsoft SQL Server 2016: Implementing Transparent Data Encryption
After watching this video, you will be able to demonstrate how to use transparent data encryption.
-
Microsoft SQL Server 2016: TDE Commands and Functions
After watching this video, you will be able to demonstrate how to use transparent data encryption commands and functions.
-
Microsoft SQL Server 2016: Creating SQL Server Agent Alerts
After watching this video, you will be able to create SQL Server Agent alerts and configure their actions using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Creating Alerts for User-Defined Events
After watching this video, you will be able to create alerts that respond to user-defined events.
-
Microsoft SQL Server 2016: Defining Failure Actions
After watching this video, you will be able to define actions a SQL Server Agent should take in the event of job failure.
-
Microsoft SQL Server 2016: SQL Server Agent Operators
After watching this video, you will be able to describe the purpose of SQL Server Agent operators, the types of contact methods, and notifications.
-
Microsoft SQL Server 2016: Creating a SQL Server Agent Operator Using SSMS
After watching this video, you will be able to create a SQL Server Agent operator using SQL Server Management Studio.
-
Microsoft SQL Server 2016: SQL Server Agent Alerts
After watching this video, you will be able to describe the purpose of SQL Server Agent alerts, how they are triggered, and what they can do.
-
Microsoft SQL Server 2016: Troubleshoot SQL Server Agent Alerts
After watching this video, you will be able to recognize the troubleshooting process for SQL Server Agent alerts and notifications.
-
Microsoft SQL Server 2016: Database Mail
After watching this video, you will be able to describe Database Mail, mail profiles, and the importance of security.
-
Microsoft SQL Server 2016: Logs and Retention in Database Mail
After watching this video, you will be able to describe the logging levels and the need for a retention policy in Database Mail.
-
Microsoft SQL Server 2016: Configuring Database Mail
After watching this video, you will be able to configure Database Mail.
-
Microsoft SQL Server 2016: SQL Server Agent
After watching this video, you will be able to recognize the features, benefits, and components of SQL Server Agent.
-
Microsoft SQL Server 2016: Monitoring Instances in SQL Server 2016
After watching this video, you will be able to monitor instances in SQL Server 2016.
-
Microsoft SQL Server 2016: Indexes
After watching this video, you will be able to describe the types of indexes available in SQL Server and the importance of managing them properly.
-
Microsoft SQL Server 2016: Detecting Index Fragmentation
After watching this video, you will be able to detect fragmented indexes and determine the degree of fragmentation.
-
Microsoft SQL Server 2016: Repairing Index Fragmentation Using SSMS
After watching this video, you will be able to repair index fragmentation using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Identifying Available Space on Data Volumes
After watching this video, you will be able to identify used and available space on data volumes.
-
Microsoft SQL Server 2016: Performance Baselines
After watching this video, you will be able to recognize what affects the performance of a server and when to use baseline measurements.
-
Microsoft SQL Server 2016: Isolating Performance and Bottleneck Issues
After watching this video, you will be able to recognize performance issues that may affect SQL Server.
-
Microsoft SQL Server 2016: Policy-Based Management
After watching this video, you will be able to describe the purpose and components of Policy-Based Management.
-
Microsoft SQL Server 2016: Configuring Policy-Based Management Properties
After watching this video, you will be able to configure Policy-Based Management properties and failure notification alerts.
-
Microsoft SQL Server 2016: Creating a Policy-Based Management Policy
After watching this video, you will be able to create a Policy-Based Management policy using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Policy Management
After watching this video, you will be able to recognize how to manage an existing Policy-Based Management policy.
-
Microsoft SQL Server 2016: Utility Control Points
After watching this video, you will be able to describe the purpose of Utility Control Point and the requirements for its use.
-
Microsoft SQL Server 2016: Identifying Execution Plan Issues
After watching this video, you will be able to identify issues with execution plans.
-
Microsoft SQL Server 2016: Monitoring Activity in SQL Server 2016
After watching this video, you will be able to monitor database activity in SQL Server 2016.
-
Microsoft SQL Server 2016: Using SQL Trace
After watching this video, you will be able to describe the uses of SQL Trace.
-
Microsoft SQL Server 2016: Monitoring Performance Using Extended Events
After watching this video, you will be able to describe the features, benefits, and architecture of performance monitoring with Extended Events.
-
Microsoft SQL Server 2016: Creating an Extended Events Session
After watching this video, you will be able to create an Extended Events session.
-
Microsoft SQL Server 2016: Troubleshooting with Extended Events
After watching this video, you will be able to recognize how Extended Events can be used to troubleshoot performance issues.
-
Microsoft SQL Server 2016: SQL Trace
After watching this video, you will be able to describe the features, benefits, and architecture of SQL Trace.
-
Microsoft SQL Server 2016: Creating a Utility Control Point Part 1
After watching this video, you will be able to use the Create UCP Wizard to create a SQL Server Utility Control Point.
-
Microsoft SQL Server 2016: Creating a Utility Control Point Part 2
After watching this video, you will be able to complete the creation of a SQL Server Utility Control Point.
-
Microsoft SQL Server 2016: The Query Store
After watching this video, you will be able to describe the purpose of the Query Store, its features, and configuration options.
-
Microsoft SQL Server 2016: Query Store Usage
After watching this video, you will be able to describe scenarios for using the Query Store.
-
Microsoft SQL Server 2016: Creating Database Audit Specifications
After watching this video, you will be able to create database audit specifications.
-
Microsoft SQL Server 2016: Auditing Views
After watching this video, you will be able to use dynamic management and system views to manage an audit.
-
Microsoft SQL Server 2016: Azure SQL Database Auditing
After watching this video, you will be able to compare auditing in Azure SQL Database with SQL Server auditing and describe its purpose.
-
Microsoft SQL Server 2016: Configuring Auditing for Azure SQL Database
After watching this video, you will be able to configure auditing for Azure SQL Database.
-
Microsoft SQL Server 2016: Audit Actions and Groups
After watching this video, you will be able to describe the purpose of actions and actions groups.
-
Microsoft SQL Server 2016: Creating Server Audit Specifications
After watching this video, you will be able to create server audit specifications.
-
Microsoft SQL Server 2016: Defining an Audit
After watching this video, you will be able to define an audit using SQL Server Audit.
-
Microsoft SQL Server 2016: Viewing the Audit Log
After watching this video, you will be able to view the audit log using SQL Server Management Studio or sys.fn_get_audit_file.
-
Microsoft SQL Server 2016: Extended Events
After watching this video, you will be able to describe the purpose of Extended Events.
-
Microsoft SQL Server 2016: SQL Server Audit
After watching this video, you will be able to describe the purpose of SQL Server Audit, auditing levels, and components.
-
Microsoft SQL Server 2016: Creating Backups using SSMS
After watching this video, you will be able to create a backup using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Creating Backups using T-SQL
After watching this video, you will be able to create a backup using Transact-SQL.
-
Microsoft SQL Server 2016: Transaction Logs and Backups
After watching this video, you will be able to describe how transaction log backup works.
-
Microsoft SQL Server 2016: Automating Backup
After watching this video, you will be able to create an automated backup job in SQL Server Management Studio.
-
Microsoft SQL Server 2016: Backup Strategies
After watching this video, you will be able to determine the appropriate strategy for backing up a database.
-
Microsoft SQL Server 2016: Backup Media
After watching this video, you will be able to determine the appropriate media for backing up a database.
-
Microsoft SQL Server 2016: Backup Retention Policies
After watching this video, you will be able to recognize how to plan a retention policy for backing up databases.
-
Microsoft SQL Server 2016: Audit Logs and Reports
After watching this video, you will be able to describe the purpose of audit logs and reports when auditing in Azure SQL Database.
-
Microsoft SQL Server 2016: Analyzing Audit Logs and Reports
After watching this video, you will be able to analyze audit logs and reports when auditing in Azure SQL Database.
-
Microsoft SQL Server 2016: Configuring Auditing in SQL Server 2016
After watching this video, you will be able to configure auditing in SQL Server 2016.
-
Microsoft SQL Server 2016: Database Backups
After watching this video, you will be able to describe the reasons for backing up a database and supported backup types.
-
Microsoft SQL Server 2016: Database-level Roles
After watching this video, you will be able to describe database-level roles and their purpose.
-
Microsoft SQL Server 2016: Server-level Roles
After watching this video, you will be able to describe server-level roles and their purpose.
-
Microsoft SQL Server 2016: Application Roles
After watching this video, you will be able to describe the purpose of application roles.
-
Microsoft SQL Server 2016: Custom Roles
After watching this video, you will be able to recognize why you would use and how to create a custom role.
-
Microsoft SQL Server 2016: User Access
After watching this video, you will be able to recognize the steps involved in granting a user access to a database and its objects.
-
Microsoft SQL Server 2016: Granting Database Object Access
After watching this video, you will be able to grant access to database objects.
-
Microsoft SQL Server 2016: Revoking Database Object Access
After watching this video, you will be able to revoke access to database objects.
-
Microsoft SQL Server 2016: Database Users
After watching this video, you will be able to describe the types of database users and their purpose.
-
Microsoft SQL Server 2016: Creating a Database User with SSMS
After watching this video, you will be able to create a database user using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Creating a Database User with T-SQL
After watching this video, you will be able to create a database user using Transact-SQL.
-
Microsoft SQL Server 2016: Permissions
After watching this video, you will be able to describe available server permissions.
-
Microsoft SQL Server 2016: Configuring Data Access and Permissions
After watching this video, you will be able to configure data access and permissions in SQL Server 2016.
-
Microsoft SQL Server 2016: Auditing
After watching this video, you will be able to describe why auditing is required and auditing methods.
-
Microsoft SQL Server 2016: Auditing with Triggers
After watching this video, you will be able to use triggers for auditing.
-
Microsoft SQL Server 2016: Auditing with Temporal Tables Part 1
After watching this video, you will be able to use temporal tables for auditing.
-
Microsoft SQL Server 2016: Connecting to an Azure SQL Database using SSMS
After watching this video, you will be able to connect to and manage an Azure SQL Database using a local instance of SSMS.
-
Microsoft SQL Server 2016: Azure SQL Database Overview
After watching this video, you will be able to describe the benefits and features of using Azure SQL Database.
-
Microsoft SQL Server 2016: Configuring an Azure SQL Database
After watching this video, you will be able to create and configure a new Azure SQL Database.
-
Microsoft SQL Server 2016: Row-level Security
After watching this video, you will be able to describe the purpose of row-level security and how to implement it.
-
Microsoft SQL Server 2016: Implementing Row-level Security Part 1
After watching this video, you will be able to implement row-level security using T-SQ: and predicates.
-
Microsoft SQL Server 2016: Dynamic Data Masking
After watching this video, you will be able to describe the purpose of dynamic data masking.
-
Microsoft SQL Server 2016: Defining a Dynamic Data Mask
After watching this video, you will be able to define dynamic data masking.
-
Microsoft SQL Server 2016: Performing Checks on Databases
After watching this video, you will be able to describe the types of consistency checks appropriate for tabular databases.
-
Microsoft SQL Server 2016: Performing Checks on Tables and Indexes
After watching this video, you will be able to perform consistency checks on indexes.
-
Microsoft SQL Server 2016: Consistency Check Errors
After watching this video, you will be able to recognize common consistency check errors and their resolutions.
-
Microsoft SQL Server 2016: Database Corruption
After watching this video, you will be able to recognize possible causes of database corruption.
-
Microsoft SQL Server 2016: Restoring a Database in SQL Server 2016
After watching this video, you will be able to restore a database in SQL Server 2016.
-
Microsoft SQL Server 2016: Database Consistency Checker
After watching this video, you will be able to describe the purpose of the Database Consistency Checker.
-
Microsoft SQL Server 2016: Using Database Consistency Checker in SSMS
After watching this video, you will be able to use the Database Consistency Checker in SQL Server Management Studio.
-
Microsoft SQL Server 2016: Viewing Progress Reports for DBCC Commands
After watching this video, you will be able to describe the types of consistency checks appropriate for multidimensional databases.
-
Microsoft SQL Server 2016: Piecemeal Restore with the Simple Recovery Model
After watching this video, you will be able to describe the purpose and requirements of piecemeal restore in the simple recovery model.
-
Microsoft SQL Server 2016: Piecemeal Restore with the Full Recovery Model
After watching this video, you will be able to describe the purpose and requirements of piecemeal restore in the full recovery model.
-
Microsoft SQL Server 2016: Piecemeal Restores
After watching this video, you will be able to describe the purpose and process of piecemeal restore.
-
Microsoft SQL Server 2016: Data Collection Design
After watching this video, you will be able to describe the components that make up the data collection system.
-
Microsoft SQL Server 2016: Configuring the Data Collector
After watching this video, you will be able to configure the Data Collector.
-
Microsoft SQL Server 2016: Monitoring Resource Usage
After watching this video, you will be able to use System Monitor to monitor resource usage.
-
Microsoft SQL Server 2016: Activity Monitor
After watching this video, you will be able to recognize the types of activities that can be monitored using Activity Monitor.
-
Microsoft SQL Server 2016: Using Activity Monitor in SSMS
After watching this video, you will be able to use Activity Monitor in SQL Server Management Studio to monitor database activity.
-
Microsoft SQL Server 2016: Identifying Blocks
After watching this video, you will be able to identify blocks using Activity Monitor and stored procedures.
-
Microsoft SQL Server 2016: The Data Collector
After watching this video, you will be able to describe the role of the Data Collector.
-
Microsoft SQL Server 2016: Identifying Database Corruption
After watching this video, you will be able to detect corruption in a SQL Server database.
-
Microsoft SQL Server 2016: Recovering from Database Corruption
After watching this video, you will be able to recover from database corruption.
-
Microsoft SQL Server 2016: Ensuring Database Consistency
After watching this video, you will be able to use SQL Server 2016 tools to ensure database consistency.
-
Microsoft SQL Server 2016: Managing Backup In SQL Server 2016
After watching this video, you will be able to manage and implement a backup strategy in SQL Server 2016.
-
Microsoft SQL Server 2016: Database Restore
After watching this video, you will be able to recognize what is involved in restoring a database, what can be restored, and restore scenario models.
-
Microsoft SQL Server 2016: Complete Database Restores with the Simple Model
After watching this video, you will be able to describe the purpose and prerequisites of restoring a database backup under the simple recovery model.
-
Microsoft SQL Server 2016: Restoring a Database with the Simple Model
After watching this video, you will be able to restore a database under the simple recovery model.
-
Microsoft SQL Server 2016: Recovery Models
After watching this video, you will be able to describe the purpose of the three recovery models.
-
Microsoft SQL Server 2016: Managing Recovery Models with SSMS
After watching this video, you will be able to view and change recovery models using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Managing Recovery Models with T-SQL
After watching this video, you will be able to recognize how to view and change recovery models using Transact-SQL.
-
Microsoft SQL Server 2016: Recovery Model Recommendations
After watching this video, you will be able to describe tasks that should be completed after changing the recovery model.
-
Microsoft SQL Server 2016: Backups to Azure Blob Storage Service
After watching this video, you will be able to describe the features and benefits of backing up a database to the Azure Blob Storage Service.
-
Microsoft SQL Server 2016: Azure Blog Storage Service Backup Considerations
After watching this video, you will be able to describe best practice and troubleshooting tips for backing up to the Azure Blob Storage Service.
-
Microsoft SQL Server 2016: Backing Up a Database to Azure Blob Storage Service
After watching this video, you will be able to backup a database to Azure.
-
Microsoft SQL Server 2016: Restoring Files to a New Location
After watching this video, you will be able to restore files to a new location.
-
Microsoft SQL Server 2016: Restoring File and Filegroups over Existing Files
After watching this video, you will be able to restore files and filegroups over existing files.
-
Microsoft SQL Server 2016: Page Restores
After watching this video, you will be able to recognize when a page restore is useful, as well as its limitations and restrictions.
-
Microsoft SQL Server 2016: Restoring Pages Using SSMS
After watching this video, you will be able to restore pages using SQL Server Management Studio and Transact-SQL.
-
Microsoft SQL Server 2016: Performing Point-in-time Recovery with SSMS
After watching this video, you will be able to describe point-in-time recovery and perform point-in-time recovery using SQL Server Management Studio.
-
Microsoft SQL Server 2016: Performing Point-in-time Recovery with T-SQL
After watching this video, you will be able to perform point-in-time recovery using Transact-SQL.
-
Microsoft SQL Server 2016: File Restores
After watching this video, you will be able to describe the goal of file restore and how it differs in the simple recovery model versus the full recovery model.
-
Microsoft SQL Server 2016: Restoring File and Filegroups
After watching this video, you will be able to restore files and filegroups.
-
Microsoft SQL Server 2016: Automating and Testing Restores
After watching this video, you will be able to automate and test restores.
-
Microsoft SQL Server 2016: Complete Database Restores with the Full Model
After watching this video, you will be able to describe the purpose of and considerations for restoring a database under the full recovery model.
-
Microsoft SQL Server 2016: Restoring a Database with the Full Model Part 1
After watching this video, you will be able to restore a database under the full recovery model.
-
Microsoft SQL Server 2016: SQLIOSim Tool
After watching this video, you will be able to demonstrate how to use the SQLIOSim tool in SQL Server 2016.
-
Microsoft SQL Server 2016: Diskspd Tool
After watching this video, you will be able to demonstrate how to use the Diskspd tool in SQL Server 2016.
-
Microsoft SQL Server 2016: SQL Server Services
After watching this video, you will be able to describe the various services used by SQL Server 2016.
-
Microsoft SQL Server 2016: Account Types
After watching this video, you will be able to describe the various account types available in SQL Server 2016.
-
Microsoft SQL Server 2016: Parallelism
After watching this video, you will be able to describe parallelism in SQL Server 2016.
-
Microsoft SQL Server 2016: I/O Operations
After watching this video, you will be able to explain I/O operations in SQL Server 2016.
-
Microsoft SQL Server 2016: SQL Server Software Requirements
After watching this video, you will be able to understand the various software requirements for SQL Server 2016.
-
Microsoft SQL Server 2016: I/O Subsystems for SQL Server
After watching this video, you will be able to describe considerations when implementing I/O subsystems for SQL Server 2016.
-
Microsoft SQL Server 2016: Network Protocols
After watching this video, you will be able to explain the different network protocols supported by SQL Server 2016.
-
Microsoft SQL Server 2016: SQL Server Hardware Requirements
After watching this video, you will be able to understand the various hardware requirements for SQL Server 2016.
-
Microsoft SQL Server 2016: SQL Server Memory Management
After watching this video, you will be able to explain SQL Server 2016 Server memory management.
-
Microsoft SQL Server 2016: Architecture Layers
After watching this video, you will be able to recognize the different SQL Server 2016 architecture layers.
-
Microsoft SQL Server 2016: SQL Server CPU Usage
After watching this video, you will be able to explain SQL Server 2016 CPU usage.
-
Microsoft SQL Server 2016: SQL Server Components
After watching this video, you will be able to recognize the SQL Server 2016 components.
-
Microsoft SQL Server 2016: SQL Server Instances
After watching this video, you will be able to describe SQL Server 2016 instances.
-
Microsoft SQL Server 2016: 32-bit Systems
After watching this video, you will be able to explain SQL Server 2016 32-bit systems.
-
Microsoft SQL Server 2016: 64-bit Systems
After watching this video, you will be able to explain SQL Server 2016 64-bit systems.
-
Microsoft SQL Server 2016: SQL Server Editions
After watching this video, you will be able to describe SQL Server 2016 editions.
-
Microsoft SQL Server 2016: SQL Server Versions
After watching this video, you will be able to describe SQL Server 2016 versions.
-
Transact-SQL: Subqueries Overview
After watching this video, you will be able to recognize when and where to use subqueries in SQL Server 2016.
-
Transact-SQL: Scalar Subqueries
After watching this video, you will be able to describe the benefits of using scalar subqueries.
-
Transact-SQL: Aggregate Functions Overview
After watching this video, you will be able to recognize the aggregate functions available using Transact-SQL.
-
Transact-SQL: Using Aggregate Functions in SQL
After watching this video, you will be able to use aggregate functions in SQL Server 2016.
-
Transact-SQL: Outputting XML Data
After watching this video, you will be able to demonstrate how to query and output XML data in SQL Server 2016.
-
Transact-SQL: Using Database Programmability Objects
After watching this video, you will be able to use database programmability objects in SQL Server 2016.
-
Transact-SQL: Temporal Data Types
After watching this video, you will be able to describe temporal data types in SQL Server 2016.
-
Transact-SQL: Temporal Tables
After watching this video, you will be able to work with temporal tables in SQL Server 2016.
-
Transact-SQL: TRY…CATCH error handling
After watching this video, you will be able to demonstrate TRY...CATCH error handling.
-
Transact-SQL: RAISERROR Statements
After watching this video, you will be able to demonstrate how to use RAISERROR in SQL 2016.
-
Transact-SQL: Table-valued Functions
After watching this video, you will be able to recognize table-valued functions in SQL Server 2016.
-
Transact-SQL: Scalar-valued User-defined Functions
After watching this video, you will be able to describe scalar-valued user-defined functions in SQL Server 2016.
-
Transact-SQL: Input parameters
After watching this video, you will be able to demonstrate how to input parameters in SQL Server 2016.
-
Transact-SQL: Output parameters
After watching this video, you will be able to demonstrate how to output parameters in SQL Server 2016.
-
Transact-SQL: XML Data
After watching this video, you will be able to describe XML data.
-
Transact-SQL: JSON Data
After watching this video, you will be able to describe JSON data.
-
Transact-SQL: Output JSON Data
After watching this video, you will be able to demonstrate how to query and output JSON data in SQL Server 2016.
-
Transact-SQL: GROUP BY Clause and Aggregate Functions
After watching this video, you will be able to describe how to use GROUP BY with aggregate functions in SQL Server 2016.
-
Transact-SQL: GROUP BY clauses using GROUPING Sets
After watching this video, you will be able to demonstrate using complex GROUP BY clauses using GROUPING sets.
-
Transact-SQL: HAVING Clause
After watching this video, you will be able to recognize how to filter groups using the HAVING clause.
-
Transact-SQL: Pivot and Unpivot Overview
After watching this video, you will be able to recognize how to use PIVOT and UNPIVOT relational operators in SQL Server 2016.
-
Transact-SQL: Logical Order of Operations
After watching this video, you will be able to describe how to process queries using the logical order of operations.
-
Transact-SQL: GROUP BY Workflow
After watching this video, you will be able to describe the GROUP BY workflow process.
-
Transact-SQL: Group and Rank Results
After watching this video, you will be able to demonstrate how to group and rank the results of a query using the windowing functions in SQL Server 2016.
-
Transact-SQL: COUNT Aggregate Function
After watching this video, you will be able to list the built-in aggregate function COUNT in SQL Server 2016.
-
Transact-SQL: Aggregating Distinct Values
After watching this video, you will be able to describe how to aggregate distinct values using DISTINCT.
-
Transact-SQL: NULL and Aggregate Functions
After watching this video, you will be able to demonstrate how to use aggregate functions with NULL.
-
Transact-SQL: GROUP BY Overview
After watching this video, you will be able to recognize when and where to use the GROUP BY clause.
-
Transact-SQL: Multi-valued Subqueries
After watching this video, you will be able to recognize how to write multi-valued subqueries in SQL Server 2016.
-
Transact-SQL: Correlated Subqueries Overview
After watching this video, you will be able to work with correlated subqueries in SQL Server 2016.
-
Transact-SQL: Writing Correlated Subqueries
After watching this video, you will be able to describe how to write correlated subqueries.
-
Transact-SQL: Correlated Subqueries with Aliases
After watching this video, you will be able to recognize how to write correlated subqueries with aliases.
-
Transact-SQL: Writing Effective Scalar Subqueries
After watching this video, you will be able to demonstrate how to write scalar subqueries in SQL Server 2016.
-
Transact-SQL: Using PIVOT
After watching this video, you will be able to demonstrate how to use PIVOT in SQL Server 2016.
-
Transact-SQL: Using UNPIVOT
After watching this video, you will be able to demonstrate how to use UNPIVOT in SQL Server 2016.
-
Transact-SQL: NULL Values in PIVOT and UNPIVOT Queries
After watching this video, you will be able to describe how to determine the impact on NULL values in PIVOT and UNPIVOT queries.
-
Transact-SQL: Implicit and Explicit Conversations
After watching this video, you will be able to work with implicit and explicit data type conversions in SQL Server 2016.
-
Transact-SQL: Scalar Functions
After watching this video, you will be able to work with scalar functions in SQL Server 2016.
-
Transact-SQL: Aggregate Functions
After watching this video, you will be able to describe aggregate functions in SQL Server 2016.
-
Transact-SQL: Windows Functions
After watching this video, you will be able to list Windows functions in SQL Server 2016.
-
Transact-SQL: Rowset Functions
After watching this video, you will be able to describe rowset functions in SQL Server 2016.
-
Transact-SQL: SUM Aggregate Function
After watching this video, you will be able to describe the built-in aggregate function SUM in SQL Server 2016.
-
Transact-SQL: AVG Aggregate Function
After watching this video, you will be able to describe the built-in aggregate function AVG in SQL Server 2016.
-
Transact-SQL: MIN Aggregate Function
After watching this video, you will be able to list the built-in aggregate function in MIN Server 2016.
-
Transact-SQL: MAX Aggregate Function
After watching this video, you will be able to list the built-in aggregate function MAX in SQL Server 2016.
-
Transact-SQL: Using Functions in SQL Server 2016
After watching this video, you will be able to use functions in SQL Server 2016.
-
Transact-SQL: NULL Value Overview
After watching this video, you will be able to describe the NULL value in SQL Server 2016.
-
Transact-SQL: Using Operators in SQL Server 2016
After watching this video, you will be able to use operators in SQL Server 2016.
-
Transact-SQL: Understanding Stored Procedures
After watching this video, you will be able to describe stored procedures in SQL Server 2016.
-
Transact-SQL: Using Stored Procedures
After watching this video, you will be able to use and create stored procedures in SQL Server 2016.
-
Transact-SQL: CROSS APPLY Operator
After watching this video, you will be able to use CROSS APPLY operators in SQL Server 2016.
-
Microsoft SQL Server 2016: User-defined Functions Components
After watching this video, you will be able to recognize the various components of user-defined functions.
-
Transact-SQL: APPLY Operator Overview
After watching this video, you will be able to recognize when to use the APPLY operator in SQL Server 2016.
-
Microsoft SQL Server 2016: INSTEAD Trigger
After watching this video, you will be able to demonstrate how to use the INSTEAD trigger.
-
Transact-SQL: Writing APPLY Statements
After watching this video, you will be able to use APPLY statements that return given data based on supplied data in SQL Server 2016.
-
Microsoft SQL Server 2016: User-defined Functions Overview
After watching this video, you will be able to describe user-defined functions.
-
Microsoft SQL Server 2016: Built-in Functions
After watching this video, you will be able to use built-in functions.
-
Microsoft SQL Server 2016: Deterministic Functions
After watching this video, you will be able to use deterministic functions.
-
Microsoft SQL Server 2016: Scalar-valued Functions
After watching this video, you will be able to use scalar-valued functions.
-
Microsoft SQL Server 2016: Table-valued Functions
After watching this video, you will be able to use table-valued functions.
-
Microsoft SQL Server 2016: Transactions
After watching this video, you will be able to recognize when to use transactions.
-
Microsoft SQL Server 2016: BEGIN TRANSACTION
After watching this video, you will be able to demonstrate how to use the BEGIN TRANSACTION statement.
-
Microsoft SQL Server 2016: Nondeterministic Functions
After watching this video, you will be able to use nondeterministic functions.
-
Microsoft SQL Server 2016: Configure Triggers
After watching this video, you will be able to configure triggers in SQL Server 2016.
-
Transact-SQL: NULL Values with the INTERSECT Operator
After watching this video, you will be able to determine the effect of NULL values on the INTERSECT operator.
-
Microsoft SQL Server 2016: DML Trigger Security
After watching this video, you will be able to recognize best practices regarding DML trigger security.
-
Microsoft SQL Server 2016: Implementing DDL Triggers
After watching this video, you will be able to implement DDL triggers.
-
Microsoft SQL Server 2016: Creating DML Triggers
After watching this video, you will be able to create DML triggers.
-
Microsoft SQL Server 2016: Creating CLR Triggers
After watching this video, you will be able to create CLR triggers.
-
Microsoft SQL Server 2016: DDL Events and Event Groups
After watching this video, you will be able to describe DDL events and event groups.
-
Microsoft SQL Server 2016: Implementing Triggers
After watching this video, you will be able to recognize when to use the various types of triggers.
-
Microsoft SQL Server 2016: Gathering DDL Trigger Information
After watching this video, you will be able to gather information regarding DDL triggers.
-
Microsoft SQL Server 2016: Disabling Logon Triggers
After watching this video, you will be able to disable logon triggers.
-
Microsoft SQL Server 2016: AFTER Trigger
After watching this video, you will be able to demonstrate how to use the AFTER trigger.
-
Microsoft SQL Server 2016: Specifying First and Last Trigger
After watching this video, you will be able to implement first and last triggers.
-
Microsoft SQL Server 2016: Managing Transactions in Logon Triggers
After watching this video, you will be able to manage transactions within a logon trigger.
-
Transact-SQL: NOT EXISTS and OUTER JOINs
After watching this video, you will be able to demonstrate how to use NOT EXISTS with OUTER JOINs.
-
Transact-SQL: Writing Queries That Use EXISTS with Subqueries
After watching this video, you will be able to describe how to write queries using EXISTS with subqueries.
-
Transact-SQL: EXISTS and NULLs
After watching this video, you will be able to demonstrate how to use EXISTS and NULLs in SQL Server 2016.
-
Transact-SQL: EXISTS and INNER JOINs
After watching this video, you will be able to describe how to use EXISTS and INNER JOINs in SQL Server 2016.
-
Microsoft SQL Server 2016: Return Codes
After watching this video, you will be able to implement return codes.
-
Microsoft SQL Server 2016: Stored Procedure Logic
After watching this video, you will be able to streamline existing stored procedure logic.
-
Microsoft SQL Server 2016: Obfuscating Stored Procedures
After watching this video, you will be able to obfuscate stored procedures using the WITH ENCRYPTIONS clause.
-
Microsoft SQL Server 2016: Configure Constraints
After watching this video, you will be able to configure constraints in SQL Server 2016.
-
Microsoft SQL Server 2016: Error Handling and Transaction Control Logic
After watching this video, you will be able to implement error handling and transaction control logic within stored procedures.
-
Microsoft SQL Server 2016: Error Handling and Transaction Control Logic
After watching this video, you will be able to alter a stored procedure using the Transact-SQL ALTER PROCEDURE statement.
-
Transact-SQL: Correlated Subqueries with Comparison Operators
After watching this video, you will be able to describe how to write correlated subqueries with aliases.
-
Transact-SQL: Correlated Subqueries within a HAVING Clause
After watching this video, you will be able to describe how to write correlated subqueries in a HAVING clause.
-
Transact-SQL: EXISTS Predicate Overview
After watching this video, you will be able to describe how the EXISTS predicate evaluates data in SQL Server 2016.
-
Transact-SQL: EXCEPT and INTERSECT Operators
After watching this video, you will be able to recognize when to use the EXCEPT operator in SQL Server 2016.
-
Transact-SQL: Using EXCEPT and INTERSECT Operators
After watching this video, you will be able to demonstrate how to use the EXCEPT and INTERSECT operators in SQL Server 2016.
-
Transact-SQL: Order of Input Using the EXCEPT Operator
After watching this video, you will be able to determine the results of reversing the order of input with the EXCEPT operator.
-
Transact-SQL: Writing Queries That Use the UNION Operator
After watching this video, you will be able to demonstrate how to write SQL Server 2016 queries that use the UNION operator.
-
Transact-SQL: Writing Queries That Use the UNION ALL Operator
After watching this video, you will be able to demonstrate how to write SQL Server 2016 queries that use the UNION ALL operator.
-
Transact-SQL: Mixed UNION and UNION ALL Operators
After watching this video, you will be able to demonstrate how to use the UNION and UNION ALL operators together.
-
Transact-SQL: UNION vs. UNION ALL Operator s
After watching this video, you will be able to distinguish when to use the UNION and UNION All operators in SQL Server 2016.
-
Transact-SQL: NOT EXISTS and OUTER JOINs
After watching this video, you will be able to use subqueries in SQL Server 2016.
-
Microsoft SQL Server 2016: Creating Statistics
After watching this video, you will be able to create statistics and determine accuracy of results.
-
Microsoft SQL Server 2016: Modifying Statistics
After watching this video, you will be able to modify existing statistics.
-
Microsoft SQL Server 2016: Best Practices
After watching this video, you will be able to describe the best practices for calling natively compiled stored procedures.
-
Microsoft SQL Server 2016: Troubleshoot Deadlocks
After watching this video, you will be able to demonstrate how to troubleshoot deadlocks.
-
Microsoft SQL Server 2016: Viewing Statistics Properties
After watching this video, you will be able to view statistic properties.
-
Microsoft SQL Server 2016: Updating Statistics
After watching this video, you will be able to update query optimization statistics.
-
Microsoft SQL Server 2016: Creating Natively Compiled Stored Procedures
After watching this video, you will be able to demonstrate how to create a natively compiled stored procedure.
-
Microsoft SQL Server 2016: Monitoring Performance
After watching this video, you will be able to demonstrate how to monitor performance for natively compiled stored procedures.
-
Microsoft SQL Server 2016: Use Cases for Natively Compiled Stored Procedures
After watching this video, you will be able to recognize best-case usage scenarios for natively compiled stored procedures.
-
Microsoft SQL Server 2016: Atomic Blocks
After watching this video, you will be able to describe atomic blocks in natively compiled stored procedures.
-
Microsoft SQL Server 2016: Creating Memory-optimized tables
After watching this video, you will be able to create memory-optimized tables.
-
Microsoft SQL Server 2016: Durability Settings
After watching this video, you will be able to optimize performance by adjusting durability settings.
-
Microsoft SQL Server 2016: Lock Escalation Behavior
After watching this video, you will be able to describe lock escalation behaviors.
-
Microsoft SQL Server 2016: Memory-optimized Tables Overview
After watching this video, you will be able to provide an overview of memory-optimized tables and discuss use cases for memory-optimized tables vs. traditional disk-based tables.
-
Microsoft SQL Server 2016: Natively Compiled Stored Procedures
After watching this video, you will be able to describe the characteristics of natively compiled stored procedures.
-
Microsoft SQL Server 2016: Statistics for Memory-optimized tables
After watching this video, you will be able to describe considerations for statistics on memory-optimized tables.
-
Microsoft SQL Server 2016: Querying Memory-optimized tables
After watching this video, you will be able to describe the methods used to query memory-optimized tables.
-
Microsoft SQL Server 2016: Remediating Deadlocks
After watching this video, you will be able to demonstrate how to remediate, detect, and end deadlocks.
-
Microsoft SQL Server 2016: Troubleshooting Locking Issues
After watching this video, you will be able to demonstrate how to troubleshoot locking issues.
-
Microsoft SQL Server 2016: Handling Deadlocks
After watching this video, you will be able to demonstrate how to handle deadlocks.
-
Microsoft SQL Server 2016: READ COMMITTED
After watching this video, you will be able to use the READ COMMITTED isolation level.
-
Microsoft SQL Server 2016: Isolation Levels: Performance Impact
After watching this video, you will be able to describe performance impact considerations of given isolation levels.
-
Microsoft SQL Server 2016: Manage Transactions
After watching this video, you will be able to demonstrate how to administer transactions.
-
Microsoft SQL Server 2016: SNAPSHOT Isolation
After watching this video, you will be able to use the SNAPSHOT isolation level.
-
Microsoft SQL Server 2016: Isolation Levels: Concurrent Queries
After watching this video, you will be able to define the results of concurrent queries based on isolation levels.
-
Microsoft SQL Server 2016: Understanding Deadlocks
After watching this video, you will be able to describe deadlock behavior.
-
Microsoft SQL Server 2016: Minimizing Deadlocks
After watching this video, you will be able to minimize deadlocks.
-
Microsoft SQL Server 2016: Locking Basics
After watching this video, you will be able to provide an overview of locking.
-
Microsoft SQL Server 2016: Concurrency Effects
After watching this video, you will be able to discuss the types of concurrency and their effects.
-
Microsoft SQL Server 2016: REPEATABLE READ
After watching this video, you will be able to use the REPEATABLE READ isolation level.
-
Microsoft SQL Server 2016: SERIALIZED
After watching this video, you will be able to use the SERIALIZED isolation level.
-
Microsoft SQL Server 2016: COMMIT TRANSACTION
After watching this video, you will be able to use the COMMIT TRANSACTION to mark the end of a successful implicit or explicit transaction.
-
Microsoft SQL Server 2016: COMMIT WORK
After watching this video, you will be able to use the COMMIT WORK statement to mark the end of a transaction.
-
Microsoft SQL Server 2016: DML Statements and Transactions
After watching this video, you will be able to identify DML statement results based on transaction behavior.
-
Microsoft SQL Server 2016: Transactions in High-concurrency Databases
After watching this video, you will be able to determine the role of transactions in high-concurrency SQL Server 2016 databases.
-
Microsoft SQL Server 2016: ROLLBACK WORK
After watching this video, you will be able to use the ROLLBACK WORK statement to roll back a user-specified transaction.
-
Microsoft SQL Server 2016: SAVE TRANSACTION
After watching this video, you will be able to use the SAVE TRANSACTION statement to set a savepoint within a transaction.
-
Microsoft SQL Server 2016: Snapshot Isolation and Row Versioning
After watching this video, you will be able to describe snapshot isolation and row versioning.
-
Microsoft SQL Server 2016: READ UNCOMMITTED
After watching this video, you will be able to use the READ UNCOMMITTED isolation level.
-
Microsoft SQL Server 2016: Transactions in High-concurrency Databases
After watching this video, you will be able to describe explicit transactions.
-
Microsoft SQL Server 2016: Implicit Transactions
After watching this video, you will be able to describe implicit transactions.
-
Microsoft SQL Server 2016: ROLLBACK TRANSACTION
After watching this video, you will be able to use the ROLLBACK TRANSACTION to roll back an explicit or implicit transaction.
-
Microsoft SQL Server 2016: Creating an Azure SQL Database
After watching this video, you will be able to demonstrate how to create an Azure SQL Server 2016 database
-
Microsoft SQL Server 2016: Elastic Scale
After watching this video, you will be able to describe elastic scaling
-
Microsoft SQL Server 2016: Tempdb Files
After watching this video, you will be able to optimize tempdb configuration files
-
Microsoft SQL Server 2016: Creating a Workload Group
After watching this video, you will be able to create a workload group.
-
Microsoft SQL Server 2016: Disabling Resource Governor
After watching this video, you will be able to disable resource governor.
-
Microsoft SQL Server 2016: Creating a Resource Pool
After watching this video, you will be able to create a resource pool.
-
Microsoft SQL Server 2016: Common Service Tier Use Cases
After watching this video, you will be able to describe common service tier use cases.
-
Microsoft SQL Server 2016: Memory Configuration
After watching this video, you will be able to optimize memory configuration.
-
Microsoft SQL Server 2016: Service Tiers
After watching this video, you will be able to describe service tiers.
-
Microsoft SQL Server 2016: Enabling Resource Governor
After watching this video, you will be able to enable resource governor.
-
Microsoft SQL Server 2016: Configuring Resource Governor
After watching this video, you will be able to configure resource governor properties.
-
Microsoft SQL Server 2016: Workloads
After watching this video, you will be able to describe workloads.
-
Microsoft SQL Server 2016: Resource Governor
After watching this video, you will be able to manage workloads and system resource consumption using resource governor.
-
Microsoft SQL Server 2016: Query Store Usage Scenarios
After watching this video, you will be able to describe when and where to use the Query Store.
-
Microsoft SQL Server 2016: Query Performance Troubleshooting
After watching this video, you will be able to determine how to start query performance troubleshooting.
-
Microsoft SQL Server 2016: Azure SQL Database Performance Insight
After watching this video, you will be able to configure the Azure SQL Database Performance Insight.
-
Microsoft SQL Server 2016: Work with Statistics and Optimize Indexes
After watching this video, you will be able to use statistics objects and index optimization methods.
-
Microsoft SQL Server 2016: Query Plan Operator Performance
After watching this video, you will be able to identify underperforming query plan operators.
-
Microsoft SQL Server 2016: Reviewing Query Results
After watching this video, you will be able to compare query plans and related metadata.
-
Microsoft SQL Server 2016: Logical Operators
After watching this video, you will be able to describe logical operators and how they are used.
-
Microsoft SQL Server 2016: Physical Operators
After watching this video, you will be able to describe physical operators and how they are used.
-
Microsoft SQL Server 2016: Overlapping Indexes
After watching this video, you will be able to identify and consolidate overlapping indexes.
-
Microsoft SQL Server 2016: Capturing Query Plans
After watching this video, you will be able to capture query plans using extended events and traces.
-
Microsoft SQL Server 2016: Query Store Best Practices
After watching this video, you will be able to recognize best practices to follow with the Query Store.
-
Microsoft SQL Server 2016: Maintenance Tasks
After watching this video, you will be able to describe available maintenance tasks to perform.
-
Microsoft SQL Server 2016: Defragmenting Indexes
After watching this video, you will be able to perform index defragmentation.
-
Microsoft SQL Server 2016: Reviewing Dynamic Management Objects
After watching this video, you will be able to review current index usage and identify missing indexes.
-
Microsoft SQL Server 2016: Database Engine Tuning Advisor
After watching this video, you will be able to perform database tuning using the database engine tuning advisor.
-
Microsoft SQL Server 2016: Creating a Maintenance Plan
After watching this video, you will be able to demonstrate how to create a maintenance plan.
-
Microsoft SQL Server 2016: Input and Output Parameters
After watching this video, you will be able to describe how to use the input and output parameters.
-
Microsoft SQL Server 2016: Table-valued Parameters
After watching this video, you will be able to demonstrate how to use table-valued parameters.
-
Microsoft SQL Server 2016: IDENTITY Constraints
After watching this video, you will be able to describe the IDENTITY constraint.
-
Microsoft SQL Server 2016: Constraint Checking
After watching this video, you will be able to recognize the common considerations to be aware of when working with constraints.
-
Microsoft SQL Server 2016: FOREIGN KEY Constraints
After watching this video, you will be able to use the FOREIGN KEY constraint.
-
Microsoft SQL Server 2016: UNIQUE Constraints
After watching this video, you will be able to describe the UNIQUE constraint I.
-
Microsoft SQL Server 2016: Stored Procedures Overview
After watching this video, you will be able to describe stored procedures and their benefits.
-
Microsoft SQL Server 2016: Designing Stored Procedures
After watching this video, you will be able to design stored procedures components and structure based on business requirements.
-
Microsoft SQL Server 2016: Adding Constraints to Tables
After watching this video, you will be able to demonstrate how to write Transact-SQL statements to add constraints to tables.
-
Microsoft SQL Server 2016: Identifying Results Given Existing Constraints
After watching this video, you will be able to demonstrate how to identify results of DML statements given exiting tables and constraints.
-
Transact-SQL: SQL Server 2016 Data Types Overview
After watching this video, you will be able to describe how SQL Server 2016 uses data types.
-
Transact-SQL: Data Type Conversions
After watching this video, you will be able to recognize when data type conversions occur in SQL Server 2016.
-
Transact-SQL: Testing for NULL
After watching this video, you will be able to describe how to test for NULL in SQL Server 2016.
-
Transact-SQL: WHERE clause
After watching this video, you will be able to demonstrate how to filter data in SQL Server 2016 using the WHERE clause.
-
Transact-SQL: Predicates and Operators
After watching this video, you will be able to describe how to use predicates and operators in SQL Server 2016.
-
Transact-SQL: Three-valued Logic
After watching this video, you will be able to describe three-valued logic in SQL Server 2016.
-
Transact-SQL: NULL in Queries
After watching this video, you will be able to work with NULL in Queries in SQL Server 2016.
-
Transact-SQL: Manipulating Data in SQL Server 2016
After watching this video, you will be able to demonstrate how to query and manipulate data in SQL Server 2016.
-
Transact-SQL: ORDER BY Clause
After watching this video, you will be able to describe the ORDER BY clause in SQL Server 2016.
-
Transact-SQL: Sorting Data
After watching this video, you will be able to demonstrate how to sort data in SQL Server 2016 using the ORDER BY clause.
-
Transact-SQL: Filtering Data
After watching this video, you will be able to recognize how to filter data in SQL Server 2016.
-
Transact-SQL: OUTPUT Clause
After watching this video, you will be able to demonstrate how to use the OUTPUT clause to monitor data in SQL Server 2016.
-
Transact-SQL: Modifying Data in SQL Server 2016
After watching this video, you will be able to demonstrate how to filter and modify data in SQL Server 2016.
-
Transact-SQL: SQL Server Built-in Function Types
After watching this video, you will be able to list the built-in function types used in SQL Server 2016.
-
Transact-SQL: Populating Tables Using SELECT INTO
After watching this video, you will be able to describe how to populate tables in SQL Server 2016 using the SELECT INTO statement.
-
Transact-SQL: Add Data Using INSERT
After watching this video, you will be able to demonstrate how to add data using INSERT statement.
-
Transact-SQL: Modify Data Using UPDATE and MERGE
After watching this video, you will be able to describe how to use UPDATE and MERGE statements to modify data.
-
Transact-SQL: Remove Data Using DELETE and TRUNCATE
After watching this video, you will be able to describe how to use DELETE and TRUNCATE statements to remove data.
-
Transact-SQL: Implicit and Explicit Conversions
After watching this video, you will be able to demonstrate implicit and explicit conversions.
-
Transact-SQL: Character Data
After watching this video, you will be able to describe different types of character data in SQL Server 2016.
-
Transact-SQL: Manipulating Character Data
After watching this video, you will be able to demonstrate how to manipulate character data in SQL Server 2016.
-
Transact-SQL: Data Manipulation Language Overview
After watching this video, you will be able to list the benefits of using data manipulation language (DML) in SQL Server 2016.
-
Transact-SQL: NULL Values and Joins
After watching this video, you will be able to demonstrate how to write queries with NULLs on joins.
-
Transact-SQL: Set Operators
After watching this video, you will be able to describe the characteristics of sets in SQL Server 2016.
-
Transact-SQL: Set Theory
After watching this video, you will be able to describe the set theory and how it relates to SQL Server 2015.
-
Transact-SQL: Set Theory and SQL Server 2016 Queries
After watching this video, you will be able to describe applying set theory to SQL server queries.
-
Transact-SQL: Predicate Logic Overview
After watching this video, you will be able to define predicate logic in SQL Server 2016.
-
Transact-SQL: T-SQL Expressions
After watching this video, you will be able to demonstrate how to implement T-SQL expressions in SQL Server 2016.
-
Transact-SQL: T-SQL Control of Flow, Errors, and Transactions
After watching this video, you will be able to work with T-SQL control of flow, errors, and transactions in SQL Server 2016.
-
Transact-SQL: T-SQL Comments
After watching this video, you will be able to use T-SQL comments in SQL Server 2016.
-
Transact-SQL: T-SQL Batch Separators
After watching this video, you will be able to work with T-SQL batch separators.
-
Transact-SQL: T-SQL Variables
After watching this video, you will be able to create T-SQL Variables in SQL Server 2016.
-
Transact-SQL: T-SQL Statements
After watching this video, you will be able to configure T-SQL statements in SQL Server 2016.
-
Transact-SQL: T-SQL Functions
After watching this video, you will be able to work with T-SQL Language functions in SQL Server 2016.
-
Transact-SQL: Calculated Expressions
After watching this video, you will be able to demonstrate how to use calculations in the SELECT clause.
-
Transact-SQL: Understanding DISTINCT Statements in SQL Server 2016
After watching this video, you will be able to describe the purpose of DISTINCT in SQL Server 2016.
-
Transact-SQL: SELECT DISTINCT Syntax
After watching this video, you will be able to describe how to execute a SELECT DISTINCT.
-
Transact-SQL: Eliminating Duplicates Using DISTINCT
After watching this video, you will be able to demonstrate how to eliminate duplicates using DISTINCT.
-
Transact-SQL: Querying Data with Transact-SQL
After watching this video, you will be able to demonstrate querying data in SQL Server 2016.
-
Transact-SQL: SELECT Statements Overview
After watching this video, you will be able to recognize elements of simple SQL Server 2016 SELECT queries.
-
Transact-SQL: Writing SELECT Statements in SQL Server 2016
After watching this video, you will be able to demonstrate how to write simple SELECT statements in SQL Server 2016.
-
Transact-SQL: Logical Order of Operations
After watching this video, you will be able to define the logical order of operations.
-
Transact-SQL: Applying Logical Order of Operations
After watching this video, you will be able to demonstrate the logical order of operations when writing SELECT statements.
-
Transact-SQL: Elements of a SELECT Statement
After watching this video, you will be able to recognize the elements of a SELECT statement in SQL Server 2016.
-
Transact-SQL: SQL Server 2016 Architecture Overview
After watching this video, you will be able to recognize features of SQL Server 2016.
-
Transact-SQL: SQL Server 2016 Editions and Components
After watching this video, you will be able to list SQL Server 2016 editions and components.
-
Transact-SQL: SQL Server 2016 Functions and Capabilities
After watching this video, you will be able to identify SQL Server 2016 functions and capabilities.
-
Transact-SQL: SQL Server Management Studio
After watching this video, you will be able to list features of SQL Server Management Studio.
-
Microsoft SQL Server 2016: Create a SQL Table
After watching this video, you will be able to demonstrate how to create a SQL Table.
-
Microsoft SQL Server 2016: Index Design Basics
After watching this video, you will be able to recognize the basic guidelines to follow when designing and implementing indexes.
-
Microsoft SQL Server 2016: Third Normal Form
After watching this video, you will be able to describe the third normal form level of normalization.
-
Microsoft SQL Server 2016: Database Denormalization
After watching this video, you will be able to demonstrate how to denormalize a database.
-
Microsoft SQL Server 2016: Creating Clustered Indexes
After watching this video, you will be able to create clustered indexes.
-
Microsoft SQL Server 2016: Tables Without Clustered Indexes
After watching this video, you will be able to describe when to use tables without clustered indexes.
-
Microsoft SQL Server 2016: Clustered vs. Nonclustered Indexes
After watching this video, you will be able to recognize the basic guidelines to follow when designing and implementing indexes.
-
Microsoft SQL Server 2016: First Normal Form
After watching this video, you will be able to describe the first normal form level of normalization.
-
Microsoft SQL Server 2016: Second Normal Form
After watching this video, you will be able to describe the second normal form level of normalization.
-
Microsoft SQL Server 2016: Normalization
After watching this video, you will be able to recognize the process of normalization in SQL Server 2016.
-
Microsoft SQL Server 2016: Altering Tables
After watching this video, you will be able to use the ALTER TABLE statement to modify a table.
-
Microsoft SQL Server 2016: Naming Conventions
After watching this video, you will be able to describe the best practices to follow when selecting a naming convention.
-
Microsoft SQL Server 2016: Numerics
After watching this video, you will be able to describe the numeric data type category in SQL Server 2016.
-
Microsoft SQL Server 2016: Renaming Tables
After watching this video, you will be able to rename a table.
-
Microsoft SQL Server 2016: Constraints
After watching this video, you will be able to use constraints to ensure integrity of data.
-
Microsoft SQL Server 2016: Binary Strings
After watching this video, you will be able to describe the binary strings data type category in SQL Server 2016.
-
Microsoft SQL Server 2016: Special Data Types
After watching this video, you will be able to describe the special data types category in SQL Server 2016.
-
Microsoft SQL Server 2016: Date and Time
After watching this video, you will be able to describe the date and time data type category in SQL Server 2016.
-
Microsoft SQL Server 2016: Character and Unicode
After watching this video, you will be able to describe the character and unicode data type category in SQL Server 2016.
-
Microsoft SQL Server 2016: Adding and Removing Columns
After watching this video, you will be able to add and removing columns from a table.
-
Microsoft SQL Server 2016: Duplicating Tables
After watching this video, you will be able to duplicate a table.
-
Transact-SQL: Querying with Right Outer Joins
After watching this video, you will be able to demonstrate the proper usages of outer joins in SQL Server 2016.
-
Transact-SQL: Querying Cross Joins and Self Joins
After watching this video, you will be able to demonstrate the proper usages of cross and self joins.
-
Transact-SQL: Multiple Join Operators
After watching this video, you will be able to demonstrate the use of multiple join operators.
-
Transact-SQL: Using Simple CASE Expressions
After watching this video, you will be able to demonstrate how to use simple CASE expressions.
-
Transact-SQL: Joins Overview
After watching this video, you will be able to recognize how and when to use joins in SQL Server 2016.
-
Transact-SQL: Querying with Inner Joins
After watching this video, you will be able to demonstrate the proper usage of inner joins in SQL Server 2016.
-
Transact-SQL: Querying with Left Outer Joins
After watching this video, you will be able to demonstrate the proper usages of outer joins in SQL Server 2016.
-
Transact-SQL: Referring to Columns Using Aliases
After watching this video, you will be able to describe how to refer to columns using aliases.
-
Transact-SQL: Referring to Tables Using Aliases
After watching this video, you will be able to specify how to refer to tables using aliases.
-
Transact-SQL: SQL Server 2016 CASE Expressions
After watching this video, you will be able to describe SQL Server 2016 CASE expressions.
-
Microsoft SQL Server 2016: Creating Tables
After watching this video, you will be able to create tables in SQL Server 2016.
-
Microsoft SQL Server 2016: Dropping Tables
After watching this video, you will be able to use the DROP TABLE statement to drop a table from a database.
-
Microsoft SQL Server 2016: PRIMARY KEY Constraints
After watching this video, you will be able to describe the use of the PRIMARY Key constraint.
-
Microsoft SQL Server 2016: Enforcing Data Integrity
After watching this video, you will be able to use the various mechanisms used to enforce data integrity.
-
Microsoft SQL Server 2016: Entity and Referential Integrity
After watching this video, you will be able to describe entity and referential integrity.
-
Microsoft SQL Server 2016: In-Memory Index Performance Considerations
After watching this video, you will be able to describe in-memory index performance considerations.
-
Microsoft SQL Server 2016: XML Indexes
After watching this video, you will be able to describe XML indexes.
-
Microsoft SQL Server 2016: Creating Tables with Nonclustered Hash Indexes
After watching this video, you will be able to create tables with nonclustered hash indexes.
-
Microsoft SQL Server 2016: Configure Columnstore Indexes
After watching this video, you will be able to implement and configure columnstore indexes.
-
Microsoft SQL Server 2016: Types of Data Integrity
After watching this video, you will be able to recognize the three basic forms of data integrity: domain, entity, referential.
-
Microsoft SQL Server 2016: Secondary XML Indexes
After watching this video, you will be able to describe secondary XML indexes.
-
Microsoft SQL Server 2016: XML Index Performance Considerations
After watching this video, you will be able to describe XML index performance considerations.
-
Microsoft SQL Server 2016: Changing Data in a Nonclustered Columnstore Index
After watching this video, you will be able to change data in a nonclustered columnstore index.
-
Microsoft SQL Server 2016: In-memory Nonclustered Hash Indexes
After watching this video, you will be able to describe in-memory nonclustered hash indexes.
-
Microsoft SQL Server 2016: Clustered vs. Nonclustered Columnstore Indexes
After watching this video, you will be able to differentiate between clustered and nonclustered columnstore indexes in SQL Server 2016.
-
Microsoft SQL Server 2016: Creating a Nonclustered Columnstore Index
After watching this video, you will be able to create a nonclustered columnstore index.
-
Microsoft SQL Server 2016: Columnstore Versioned Feature Summary
After watching this video, you will be able to describe columnstore versioned feature summary.
-
Microsoft SQL Server 2016: Columnstore Indexes Query Performance
After watching this video, you will be able to improve columnstore index query performance.
-
Microsoft SQL Server 2016: Columnstore Indexes Defragmentation
After watching this video, you will be able to implement columnstore index defragmentation.
-
Microsoft SQL Server 2016: Columnstore for Real-time Operational Analytics
After watching this video, you will be able to implement real-time operational analytics.
-
Microsoft SQL Server 2016: Columnstore Indexes for Data Warehousing
After watching this video, you will be able to describe columnstore index data warehousing.
-
Microsoft SQL Server 2016: When to Implement a Columnstore Index
After watching this video, you will be able to determine when to implement a columnstore index.
-
Microsoft SQL Server 2016: Creating a Clustered Columnstore Index
After watching this video, you will be able to create a clustered columnstore index.
-
Microsoft SQL Server 2016: Create Indexes with Included Columns
After watching this video, you will be able to create an index with included columns.
-
Microsoft SQL Server 2016: Columnstore Index Overview
After watching this video, you will be able to recognize when to use columnstore indexes.
-
Microsoft SQL Server 2016: Columnstore Indexes Data Loading
After watching this video, you will be able to describe columnstore index data loading.
-
Microsoft SQL Server 2016: Creating Indexed Views
After watching this video, you will be able to create an indexed view.
-
Microsoft SQL Server 2016: Using Partitioned Views
After watching this video, you will be able to create partitioned views.
-
Microsoft SQL Server 2016: Renaming and Deleting a View
After watching this video, you will be able to rename and delete a view.
-
Microsoft SQL Server 2016: Modifying Views
After watching this video, you will be able to modify views.
-
Microsoft SQL Server 2016: Modifying Data Using a View
After watching this video, you will be able to modify data using a view.
-
Microsoft SQL Server 2016: Views
After watching this video, you will be able to describe the use of views.
-
Microsoft SQL Server 2016: Designing a View Structure
After watching this video, you will be able to recognize how to design and implement views.
-
Microsoft SQL Server 2016: Deleting Indexes
After watching this video, you will be able to delete indexes.
-
Microsoft SQL Server 2016: Modifying Indexes
After watching this video, you will be able to modify indexes.
-
Microsoft SQL Server 2016: Types of Views
After watching this video, you will be able to describe the various types of views.
-
Microsoft SQL Server 2016: Creating Views
After watching this video, you will be able to create views.
-
Microsoft SQL Server 2016: Creating Filtered Indexes
After watching this video, you will be able to create filtered indexes.
-
Microsoft SQL Server 2016: Creating Indexes with Included Columns
After watching this video, you will be able to create indexes with included columns.
-
Microsoft SQL Server 2016: Creating Nonclustered Indexes
After watching this video, you will be able to create nonclustered indexes.
-
Microsoft SQL Server 2016: Creating Unique Indexes
After watching this video, you will be able to create unique indexes.
-
Microsoft SQL Server 2016: Connecting to an Azure SQL Database
After watching this video, you will be able to demonstrate how to connect to an Azure SQL Server 2016 database
-
Microsoft SQL Server 2016: Troubleshooting Storage, IO, and Cache Issues
After watching this video, you will be able to troubleshoot storage, IO, and cache issues
-
Microsoft SQL Server 2016: Monitor Azure SQL Databases
After watching this video, you will be able to demonstrate how to monitor Azure SQL Database query plans
-
Microsoft SQL Server 2016: Data Collector
After watching this video, you will be able to describe the data collector service for monitoring SQL Server 2016 databases
-
Microsoft SQL Server 2016: Scheduling and Wait Statistics
After watching this video, you will be able to monitor and diagnose scheduling and wait statistics using dynamic management objects
-
Microsoft SQL Server 2016: Elastic Database Pools
After watching this video, you will be able to describe elastic database pools.
-
Microsoft SQL Server 2016: Extended Events Tasks
After watching this video, you will be able to describe extended events tasks.
-
Microsoft SQL Server 2016: Packages, Targets, Actions, and Sessions
After watching this video, you will be able to differentiate between extended events packages, targets, and sessions.
-
Microsoft SQL Server 2016: System Stored Procedures
After watching this video, you will be able to use system stored procedures for monitoring tasks.
-
Microsoft SQL Server 2016: SQL Server Extended Events
After watching this video, you will be able to describe the benefits of using extended events.
-
Microsoft SQL Server 2016: SQL Trace Architecture
After watching this video, you will be able to describe the SQL trace architecture.
-
Microsoft SQL Server 2016: Create a Trace
After watching this video, you will be able to create a trace using transact-sql.
-
Microsoft SQL Server 2016: Extended Events Targets
After watching this video, you will be able to distinguish between extended events targets.
-
Microsoft SQL Server 2016: Monitor Performance Using Monitoring Tools
After watching this video, you will be able to use various tools to monitor performance.
-
Microsoft SQL Server 2016: Optimize SQL Trace
After watching this video, you will be able to optimize SQL trace to minimize performance costs.
-
Microsoft SQL Server 2016: Schedule Traces
After watching this video, you will be able to demonstrate how to schedule tracing in SQL Server.
-
Microsoft SQL Server 2016: Performance Baseline
After watching this video, you will be able to establish a server performance baseline.
-
Microsoft SQL Server 2016: Performance Monitor
After watching this video, you will be able to demonstrate how to use perfmon.
-
Microsoft SQL Server 2016: Monitor Databases Using SQL Server Monitor
After watching this video, you will be able to demonstrate how to use the SQL Server Monitor
-
Microsoft SQL Server 2016: Performance Metrics
After watching this video, you will be able to describe performance metrics.
-
Microsoft SQL Server 2016: Dynamic Management Objects
After watching this video, you will be able to demonstrate how to use dynamic management objects.
-
Microsoft SQL Server 2016: Troubleshooting Performance Issues
After watching this video, you will be able to compare baseline metrics to observed metrics in order to troubleshoot performance issues.
-
Microsoft SQL Server 2016: Azure SQL Database Performance
After watching this video, you will be able to monitor Azure SQL Database performance.
-
Microsoft SQL Server 2016: Task Manager
After watching this video, you will be able to demonstrate how to use the task manager windows monitoring tool.
-
Microsoft SQL Server 2016: DBCC Commands
After watching this video, you will be able to demonstrate how execute database consistency checker commands.
-
Microsoft SQL Server 2016: Live Query Statistics
After watching this video, you will be able to demonstrate how to enable and view live query statistics.
-
Microsoft SQL Server 2016: Activity Monitor
After watching this video, you will be able to use the activity monitor in SQL Server 2016.
-
Microsoft SQL Server 2016: Performing a Piecemeal Restore
After watching this video, you will be able to restore a database using a piecemeal restore.
-
Microsoft SQL Server 2016: Restoring a Database with the Full Model Part 2
After watching this video, you will be able to restore a database under the full recovery model.
-
Microsoft SQL Server 2016: Auditing with Temporal Tables Part 2
After watching this video, you will be able to use temporal tables for auditing.
-
Microsoft SQL Server 2016: Implementing Row-level Security Part 2
After watching this video, you will be able to implement row-level security using T-SQ: and predicates.
-
Microsoft SQL Server 2016: Configuring the Management Data Warehouse
After watching this video, you will be able to enable and configure a management data warehouse for the data collector service
-
Microsoft SQL Server 2016: Enabling a Data Collector
After watching this video, you will be able to configure a data collection
-
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.
