Pluralsight – SQL Server – Analyzing Query Performance for Developers

Pluralsight – SQL Server – Analyzing Query Performance for Developers
English | Size: 785.49 MB
Category: Tutorial

This course will teach you everything you need to know as a developer to start making sense of query plans and improving query performance. Apart from developers, this course is also applicable to anyone who is responsible for SQL Server performance.

Developers are sometimes charged with fixing performance issues, and they have no idea where to start. They’ve never seen a query plan, or when they look at one they’re not sure what it *really* means. The developers know how long it takes for a query to execute, but they don’t know how to see how much IO, CPU, or memory it uses. And sometimes they just create an index and that seems to fix the problem (even though they have no idea why!). [Read more…]

The Great Courses – The Psychology of Performance How to Be Your Best in Life (Unabridged)

The Great Courses – The Psychology of Performance: How to Be Your Best in Life (Unabridged)
English | Size: 398.12 MB
Category: Tutorial

"How do you get to Carnegie Hall?" "Practice. Practice. Practice." Today, the relatively new science of performance psychology tells us that old answer is incomplete at best. In The Psychology of Performance: How to Be Your Best in Life, clinical sport psychologist Eddie O’Connor, PhD, shares the best ways for you to reach your personal Carnegie Hall based on the latest scientific research – whether your performance environment is music, dance, business, or sport. These often surprising research results will make you rethink your own performance strategies, offering approaches you might never have considered and busting myths you might have taken as truth. [Read more…]

Pluralsight – SQL Server Indexing for Performance

Pluralsight – SQL Server: Indexing for Performance
English | Size: 1.35 GB
Category: Tutorial

The most important feature in SQL Server when it comes to getting the required workload performance is probably indexing. But the indexing possibilities you have can be bewildering, and it’s easy to make the wrong choice, leading to wasted resources and maybe even worse performance! In this course, SQL Server: Indexing for Performance, you’ll learn how to correctly choose indexes for your environment. First, you’ll discover how clustered and nonclustered indexes work and how they are used by SQL Server, both of which are crucial when choosing the correct indexes to create. Next you’ll explore the tipping point – when an index can be used or not, the benefits of covering queries, and how to use the INCLUDE option to more effectively cover queries. Finally, you’ll learn how to use filtered indexes and get an introduction to index consolidation for effective server tuning. When you’ve finished this course, you’ll have the skills and knowledge to start adding and changing indexes in your environment for better performance! [Read more…]

Lynda – Measuring Team Performance

Lynda – Measuring Team Performance
English | Size: 492.28 MB
Category: Tutorial

Focusing on metrics is key to achieving your desired business results-but it can be difficult to determine which metrics actually matter. In this course, learn how team measurement works, why measuring performance is beneficial, how to measure, and how to apply it to specific functions across the value chain. Mike Figliuolo shares an approach for thinking about and conducting measurement, and discusses various types of reporting. Plus, he provides examples of key metrics you can use to gauge the performance of the vast majority of business functions including sales, operations, finance, and all major support functions.
[Read more…]

O’Reilly – Using Linux Performance Tools

O’Reilly – Using Linux Performance Tools
English | Size: 571.51 MB
Category: Tutorial

Move from basic Linux administration to advanced in this course that details how to monitor, profile, and trace Linux systems and applications. Linux expert Sasha Goldshtein shows you how to run basic performance checklists to get a reading of high-level system performance. You’ll discover ways to diagnose specific issues such as high CPU load, excessive I/O, and slow network requests; as well as gain a solid understanding of the Linux system infrastructure that makes tracing and profiling possible. The course is designed for application developers, system administrators, and SREs with some Linux system administration experience and a basic understanding of OS concepts like threads, I/O operations, and memory. [Read more…]

Pluralsight – Project Procurements, Performance, and Change Management

Pluralsight – Project Procurements, Performance, and Change Management
English | Size: 303.92 MB
Category: CBTS

Learn to lead projects with confidence, develop and meet requirements, and come in on time and within your budget. This fifth and final course in the CompTIA Project+ explores how relationships with vendors and procurement sources are managed.
An effective Project Manager needs to learn to lead projects with confidence, develop and meet requirements, and come in on time and within budget. In this course, Project Procurements, Performance, and Change Management, you will learn how to manage relationships with vendors and procurement sources. [Read more…]

Pluralsight – Monitoring MySQL with Performance Schema

Pluralsight – Monitoring MySQL with Performance Schema
English | Size: 369.99 MB
Category: Tutorial

Performance schema is an extremely powerful instrument to collect various performance related data on MySQL, and presents upon executing queries on performance schema. In this course, you’ll develop an understanding and use of performance schema.
The latest version of MySQL has introduced a new feature of MySQL Performance Schema, which monitors MySQL server execution at a low level. The performance schema provides internal execution details of MySQL queries at run time, and it’s minimum impact on the performance of MySQL resources. In this course, Monitoring MySQL with Performance Schema, you’ll learn how to maximize your data-based performance with the use of performance schema. [Read more…]

Lynda – Windows Performance Toolkit – Malware Analysis

Lynda – Windows Performance Toolkit – Malware Analysis
English | Size: 774.92 MB
Category: Tutorial

Each time you go online, you face the threat of malware. In this course, learn how to find and analyze malware that’s undetected by most antivirus programs. Follow Thomas Pantels as he shows how to work with the Windows Performance Recorder-which is used to record system events-and the Windows Performance Analyzer, which is used to inspect those events. He explains how to find and analyze key logger patterns and then shows how to analyze screen recordings, webcam recordings, and microphone recordings.
[Read more…]

Lynda – Windows Performance Toolkit – Spyware Audio Detection

Lynda – Windows Performance Toolkit – Spyware Audio Detection
English | Size: 223.86 MB
Category: Tutorial

In this course, Thomas Pantels examines a keylogger that’s undetected by antivirus and antimalware programs. This spyware can record an entire room conversation inside your home and extract information from private calls. Follow Thomas as he shows how to use two powerful performance monitoring tools included in the Windows Performance Toolkit-the Windows Performance Recorder and Windows Performance Analyzer-to find spyware that could be lurking on your computer because it’s undetected by antivirus software. He examines the source code for a keylogger to see how this malicious spyware ticks, and how to detect odd behavior in your system at a very low level. He shows how to determine if your private conversations are actually being recorded by inspecting the processes using the Windows audio stream. [Read more…]

Pluralsight – Overcoming Common Android Performance Barriers

Pluralsight – Overcoming Common Android Performance Barriers
English | Size: 464.41 MB
Category: Programming

At the core of any Android application is hidden performance glitches that cause the user experience of your application to be poor. In this course, Overcoming Common Android Performance Barriers, you will learn how to monitor, detect, and optimize performance hazards that will significantly improve the experience of your users. First, you will learn about memory hazards and memory leaks. Next you’ll explore poor network and power consumption, as well as poor UI implementation. Finally, you’ll learn how to lift all of them using the latest Android profiling tools.
[Read more…]