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.

Universal SQL Installations Framework (Script review and Demo)

Prakash Heda will show you how to do multiple versions of SQL Server installations using single scripts with all best practices baked in, This session will first discuss process framework, prerequisites and then followed up with script review and live demo of installing diff version of SQL servers with diff OS using single line command.

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.