Multimedia Library - All

Jun 26, 2014
Education

Session 1: Developing Reports  

Running Time: 65 minutes | In this session, you'll learn a variety of report development techniques that take advantage of the rich set of features available in Reporting Services. You'll start by learning how to work with report server projects in SQL Server Data Tools and how to manage report server project files and properties. Then you'll learn all the data source types you can use to display data in your report, how to connect to these data source types by creating data sources, and how to design queries for these data source types to create datasets. Next, you'll learn how to work with each type of report item, how to configure properties to control appearance and behavior of each report item, and how to work with properties specific to the tablix. Last, you'll learn how to enhance reports by adding calculations and using expressions to change properties dynamically....More
Jun 1, 2014
video

Session 1: Managing Active Directory Domains and Forests  

In this session we will look at the basics of the Microsoft Active Directory module and its requirements. We’ll explore how to find, use and modify domains, forests, organizational units, and domain controllers....More
Jun 1, 2014
video

Session 2: Understanding Query Plan Reuse  

Reusing a previously compiled query plan is one of the keys to achieving peak performance with a busy SQL Server instance. As such, understanding the fundamentals of how SQL Server stores and re-uses query plans is essential to scalability and performance. See what affects plan reuse and learn the proper way to submit calls to SQL Server in order to maximize the benefits associated with plan reuse....More
Jun 1, 2014
video

Session 3: How the Cloud and Third-Party Tools Influence Your Recovery Strategy  

Continuing from Part 1, we'll dive deeper into our architectural dissection and discuss recommendations on how to provision, configure, secure and troubleshoot SQL Server Reporting Services and Performance Point Services....More
Jun 1, 2014
video

Session 2: Managing AD Users and Groups  

Managing AD user accounts is probably the most common task for IT pros. The beauty of PowerShell is that if you can do something for one user account you can do it for 10, 100, or 1000. In this session, you will learn how to use the user and group cmdlets and accomplish common tasks, which previously took hours to complete, in minutes....More
Jun 1, 2014
video

Session 3: Essential Monitoring Groups  

We'll demonstrate how to use the built-in DMV’s to query the information you need to monitor the core areas of SQL Server—which can help you to decide how well or poorly these areas may be performing at any given time. By concentrating on these core aspects on a regular basis, you can often keep ahead of the game without being overwhelmed by the otherwise massive amounts of data to collect and analyze....More
Jun 1, 2014
video

Session 3: Managing AD Tips, Tricks, and Scripts  

The possibilities for managing AD with PowerShell are endless; you can do everything from using a template user account to tracing attribute replication. You will leave this session with examples and suggestions on how to best use the Active Directory cmdlets and tips, tricks, and scripts to troubleshoot problems in AD with PowerShell....More
Jun 1, 2014
video

Session 1: SQL Server 2012 R2 and SharePoint 2013: Reporting Nirvana  

In this session, be prepared to be amazed by the power and ease of Power View, Microsoft's latest reporting technology that lets users build rich, dynamic reporting applications right from the browser. You'll then see how PowerPivot lets business analysts use Excel to create and publish powerful reporting and dashboard solutions without any code. Additionally, you'll learn how the next generation of SQL Server Reporting Services (SSRS) integrates as a pure SharePoint service application, simplifying deployment and the architecture of your reporting platform....More
Jun 1, 2014
video

Session 1: Building from a Solid Foundation  

Without a solid foundation, it can be difficult or even impossible to scale a poorly-designed database to meet future demands. We'll cover some of the core fundamentals of the SQL Server instance and database that you need to be aware of to give the best chance of scalability and maintainability over time....More
Master-Level Microsoft Stack Training with John Savill

Get 30 hours of comprehensive training covering the complete Microsoft solution stack. Invest a few hours each week and become the #1 Microsoft expert in your organization.

Past Sessions Available for Instant Access! Access to Recordings through May 20, 2015

Semester 1: October 30th to December 4th
Semester 2: January 22nd to February 19th

John Savill will cover topics including:

* Deploying, Managing, and Maintaining Windows
* Key Features of Active Directory from Windows 2000 to Windows Server 2012
* Key elements of System Center 2012 and System Center 2012 R2
* Deploying, Migrating to and Managing Hyper-V in Your Organization
* Implementing a Private Cloud
* Using PowerShell to Automate Common Tasks
* PLUS a preview of Windows 10

 

Windows Forums

The Windows IT Pro forums are moving to myITforum.com! Get answers to questions, share tips, and engage with the IT professional community.

Sponsored Introduction Continue on to (or wait seconds) ×