New Pluralsight course: SQL Server: Using SentryOne Plan Explorer

Jonathan’s latest Pluralsight course has been published: SQL Server: Using SentryOne Plan Explorer. It’s almost 3 hours long, and from the course description:

Query plan analysis is both a science and an art, and the best tool for the job is SentryOne Plan Explorer. In this course, SQL Server: Using SentryOne Plan Explorer, you will learn how to make the most of the tool to make query plan analysis and performance tuning much easier and more intuitive than using SQL Server Management Studio. First, you will gain an understanding of how Plan Explorer compares to Management Studio, demonstrating how Plan Explorer solves the problems and shortcomings that Management Studio has. Next, you will discover how to use the the Plan Explorer user interface, including how the various information displays can help with performance analysis and tuning, and the various methods for getting query plans into the tool. Finally, you will explore how to use the more advanced features of the tool like index and statistics analysis, and profiling query performance using live query statistics. When you are finished with this course, you will have the skills and knowledge to start using the powerful SentryOne Plan Explorer tool to greatly improve your query plan analysis and performance tuning capabilities.

It’s a complete update for his 2013 course, and covers the very latest release of SentryOne’s fantastic (and free!) tool.

The modules are:

  • Introduction
  • Comparing Plan Explorer to SSMS
  • Using the Plan Explorer UI
  • Getting Execution Plans to Plan Explorer
  • Using Index and Statistics Analysis
  • Profiling Query Performance

Check it out here.

We now have more than 180 hours of SQLskills online training available (see all our courses here), all for as little as $29/month through Pluralsight (including more than 6,000 other developer and IT training courses). That’s unbeatable value that you can’t afford to ignore.

Enjoy!

New Pluralsight exam prep course: SQL Server: Understanding Database Fundamentals (98-364)

Tim’s latest Pluralsight course has been published: SQL Server: Understanding Database Fundamentals (98-364). It’s just over 2 hours long, and from the course description:

It is very common for databases to be part of a company’s I.T. infrastructure. In this course, SQL Server: Understanding Database Fundamentals (98-364), you will learn the information and skills necessary to pass the 98-364 exam. First, you will learn core database concepts around database structure and how data is stored, along with statements used to create objects and manipulate data. Next, you will discover database design concepts and relational integrity, plus the impact of primary, foreign, and composite keys. Finally, you will explore how to administer a database, including authentication methods, regular database maintenance, and how to back up and restore databases. When you are finished with this course, you will have the skills and knowledge to start creating and using databases, and to pass the 98-364 Understanding Database Fundamentals exam.

It’s very much a course for absolute beginners in databases, and is geared towards the 98-364 exam.

The modules are:

  • Introduction
  • Understanding Core Database Concepts
  • How to Create Database Objects
  • Manipulating Data
  • Understanding Data Storage
  • How to Administer a Database

Check it out here.

We now have more than 180 hours of SQLskills online training available (see all our courses here), all for as little as $29/month through Pluralsight (including more than 6,000 other developer and IT training courses). That’s unbeatable value that you can’t afford to ignore.

Enjoy!

 

New Pluralsight course: Building Multi-instance Asynchronous Applications

Jonathan’s latest Pluralsight course has been published – SQL Server: Building Multi-instance Asynchronous Applications. It’s 2.5 hours long, and from the course description:

The Service Broker feature of SQL Server is transforming the way developers think about processing requests within the database and open new opportunities for scalable applications. This course builds on the basic concepts introduced in the SQL Server: Building Simple Asynchronous Applications course by introducing single-instance multi-database and multi-instance configurations for Service Broker. In this course, SQL Server: Building Multi-instance Asynchronous Applications, you’ll learn how to configure security for Service Broker operations across databases as well as the networking and routing configurations for secure communications between multiple instances of SQL Server. Next, you’ll explore bidirectional conversations between services to allow for status updates and the appropriate way of ending a conversation between two services. Finally, you’ll see how to maintain and troubleshoot Service Broker configurations using the SSBDiagnose tool to validate that all of the required components have been appropriately configured, using the Dynamic Management Views for checking message statuses, and using the events in SQL Trace and Extended Events for troubleshooting Service Broker problems. When you’ve finished this course, you’ll have the skills and knowledge to start implementing multi-database and multi-instance Service Broker configurations.

The modules are:

  • Introduction
  • Intra-instance Service Broker Configurations
  • Multi-instance Service Broker Configurations
  • Maintaining Service Broker Configurations
  • Troubleshooting Service Broker Configurations

Check it out here.

We now have more than 175 hours of SQLskills online training available (see all our 60 courses here), all for as little as $29/month through Pluralsight (including more than 6,000 other developer and IT training courses). That’s unbeatable value that you can’t afford to ignore.

Enjoy!