On Demand Training

ImageNamePricesort iconAdd to cart
Mastering SQL Server Reporting Services Expressions - On Demand

Presented by Paul Turley

SQL Server Reporting Services (SSRS) is a very capable and mature reporting tool that has been part of the SQL Server suite for more than 10 years. It’s fairly easy to create basic reports with no programming and only fundamental technical skills if you keep things simple, but if you have to build highly-functional reports, you need to know how to write and use expressions. With some essential expression skills, you can take your report designs to the next level and give your business powerful reporting and analytic capabilities.

$199.00
Deep Dive into Business Intelligence in Excel 2013's PowerPivot and Power View - On Demand

Presented by Stacia Misner

Excel 2013 includes built-in self-service business intelligence functionality that allows you to delve deeper into your data. You can use Excel to start analyzing data as a simple data model, and then progressively add more data from a variety of data sources to enrich your analysis. Using the PowerPivot add-in, you can fine-tune the structure of the model to better support exploration and enrich the model with calculations and key performance indicators.

$199.00
Truth, Art, and the Zen of SQL Server Performance Tuning - On Demand

Presented by Ben DeBow

Some say performance tuning SQL Server is an art; others say it’s a science. It’s a bit of both of those, but also more. Many factors determine how well (or poor) SQL Server will perform, and it starts well before any application database is installed into an instance.

$199.00
Unstructured Data in SQL Server - On Demand

Presented by Steve Jones

More and more of your data doesn’t fit neatly into a structured, relational model of rows and columns of data. In this session you’ll learn how SQL Server stores unstructured data, with a special emphasis on how to use Filestream, which integrates SQL Server with the NTFS file system by storing varbinary(max) binary large object data as files stored within the file system.

$199.00
How to Think Like an Engine in SQL Server - On Demand

Presented by Brent Ozar

How does SQL Server decide how to execute a query? Microsoft Certified Master Brent Ozar will break things down from the start by explaining indexes, joins, sorting, statistics, and execution plans. He'll start by giving you a set of spreadsheets, and by the end of the session, you'll be building your own execution plans. You'll understand how to build your tables and make queries go faster.

$199.00
The What, Why, and How of Filegroups in SQL Server - On Demand

Presented by Jes Schultz Borland

More and more of your data doesn’t fit neatly into a structured, relational model of rows and columns of data. In this session you’ll learn how SQL Server stores unstructured data, with a special emphasis on how to use Filestream, which integrates SQL Server with the NTFS file system by storing varbinary(max) binary large object data as files stored within the file system.

$199.00
Conquering SQL Server Replication - On Demand

Presented by Robert Davis

Are you new to replication or do you consider replication to be a challenging beast? Even highly experienced DBAs try to steer away from replication. However, if you work in an enterprise-level environment, replication is hard to avoid. It fills several needs in the areas of scalability and availability is often the right tool for the job—yet many are still hesitant to implement it. After this class, you’ll be ready and able to implement any form of replication with confidence that you are in control.

$199.00
SQL Server High Availability Foundations - On Demand

Presented by Allan Hirt

While performance is usually the first thing people think about when it comes to their SQL Server implementations, there’s no point in having the most optimized system in the world if your databases or instances are not up and running. Are you currently achieving your uptime goals? Do you understand the different options available to you when it comes to SQL Server high availability? Are you curious to see what it really takes to achieve uptime? If so, these three sessions are designed for you.

$199.00
Getting Started with SQL Server’s Data Visualization Tools - On Demand

Presented by Stacia Misner and Tyler Chessman

Business intelligence experts Stacia Misner and Tyler Chessman walk you through how to get started with SQL Server’s data visualization tools, including Power Query (formerly known as Data Explorer), Power View, PowerPivot, and Report Builder to find, compile, and graphically display data for analysis by business users.

$199.00
Data Integrity and Corruption: A Hard Road to Recovery - On Demand

Presented by Robert Davis

Data integrity and corruption can be a complex and scary topic. At some point in your career as a DBA, you will be faced with a potential data loss scenario due to deletion (accidental or not) or corruption. You can’t avoid it. You can only prepare for it and be ready to handle it when it occurs.

$199.00
Your Shopping Cart

Sponsored Introduction Continue on to (or wait seconds) ×