Prakash Heda

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.
  • Interests: Computers, Chess, Reading

Blogs

Step Up Your Data Game: Learn Advanced SQL Techniques for Analysis

By

In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

Read the latest Blogs

Forums

Changetracking disabled in database snapshot, new bug in ms sql 2019 ?

By FHoornaert

Hi, We are using database snapshot together with changetracking to keep a datawarehouse up...

SSIS package Excel source hanging in validation or prepare for execute phase

By Derevon

Hi everyone, For several weeks now we have issues with an SSIS package connected...

The Load of Real Time Data Warehouses

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Load of Real Time...

Visit the forum

Question of the Day

Data Migration Assistant Targets

In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?

See possible answers