SQL Server Video Tutorials

SQL Server Video Tutorials

SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected performance issues on a well running system. This session will empower you to quickly and accurately detect real culprits without causing any additional load on system.

Prakash heda

2-Minute Read

On 24th Oct 02.15 PM PST, I will be speaking on “Detect Worst Performing SQL Queries During Peak Hour” @ SQLSaturday, Portland!!, If you are in the area I hope to see you!!

Re-Indexing - The quest of ultimate automation

In this session, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a dynamic re-indexing script , created based on his real-life experience from managing high performing database systems.

Prakash heda

1-Minute Read

On 27th Sep 03.15 PM EST, I will be speaking on “Re-Indexing - The quest of ultimate automation”@ SQLSaturday, Orlando, If you are in the area I hope to see you!!

Recent Posts

categories

About

SQL Server Video Tutorials shared by Prakash Heda