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.
Connect me onFacebook | Twitter | Google + | LinkedIn | Blog | Photography
The San Francisco SQL Server User Group – Oct 10 2012 Thanks you everyone for attending session, here is the presentation DAC…. Check how to use DMO sys.dm_exec_query_stats and sys.dm_io_virtual_file_stats for finding top CPU/Memory/IO queries with scripts… Detect Worst Performing SQL Queries – Part 3 […]
On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco SQL Server User Group, If you are in the area I hope to see you… Location:Microsoft 835 Market Street, San Francisco, CA Register Here Session Detail:Use PowerShell to collect stats from all SQL Servers in […]
In part 5 will install SQL Server 2012 on 3 Windows Server 8 VM’s using GUI and unattended installation to complete SQL Server 2012 Next Gen HADR labs prequisites Installing new instance of SQL Server at the command prompt enables you to stadardized SQL Server installation, selective features to install and how they should be […]