Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in


Prakash Heda works as Sr. Database Administrator at Advent Software. His expertise includes Performance Tuning/Troubleshooting, high availability, SAN configuration and windows administration. He has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA and MCITP. His background includes administration & development using VB/ASP/SSIS using SQL Server 2000, 2005 and 2008/R2 and SQL server 2012. He is an active member of PASS, SQL Saturday. He’s a frequent presenter at user groups, SQL Saturdays, and other community events. He is also an avid tweeter, blogger and runner.

Detect Worst Performing SQL Queries

This series of Videos will walk through how to detect worst performing sql queries which is slowing down Microsoft SQL Server, after this session you should be able to achieve below objectives… How to use SQL Server DMO’s to gather what resources are the bottlenecks and which queries are causing…

Read more

0 comments, 434 reads

Posted in SQLFeatures on 29 January 2012

Fine Tuning Production SQL Servers

  The Silicon Valley SQL Server User Group – Jan 17 2012 Thanks you everyone for attending session, here is the presentation DAC….

Read more

0 comments, 365 reads

Posted in SQLFeatures on 18 January 2012

Prepare Windows 7 to create Hyper-V Virtual lab to implement SQL Server 2008 R2 SP1 Active/Active Cluster

This series of Videos will walk through how to prepare existing windows 7 machine to test and validate active/active node SQL server cluster configuration prior to production…not only will try how to build a Hyper-V test lab to validate SQL clusters, I will also cover overall knowledge of dependent technologies… Read more

0 comments, 649 reads

Posted in SQLFeatures on 24 August 2011

Prepare one box Virtual lab to evaluate SQL Server Denali Always-ON Features

This series of Videos will walk through on how to prepare one box HyperV lab to understand, evaluate & validate SQL Server Denali Always-ON HADR Features

Part 1: Denali setup & Network Configuration
Part 2: Configure Windows 2008 R2 Domain Controller
Part 3: Preparing nodes for failover cluster
Part 4:… Read more

1 comments, 346 reads

Posted in SQLFeatures on 2 February 2011

Quick SQL Server Sessions Troubleshooting


I get lot of queries from DBA’s asking what is the quickest way to figure out issue on SQL Server. For me almost every SQL Server performance troubleshooting starts with checking how sessions are doing, trying to find out which sessions are problem and needs quick fix…

In this… Read more

0 comments, 462 reads

Posted in SQLFeatures on 5 January 2011

Newer posts