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

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

by Prakash Heda

SQLFeatures

The San Francisco SQL Server User Group – Oct 10 2012 Thanks you everyone for attending session, here is the presentation...

2012-10-13

992 reads

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

by Prakash Heda

SQLFeatures

The San Francisco SQL Server User Group – Oct 10 2012 Thanks you everyone for attending session, here is the presentation...

2012-10-13

321 reads

Presenting “PowerShell: Automating SQL Stats Collection”

by Prakash Heda

SQLFeatures

On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco...

2012-10-05

357 reads

Presenting “PowerShell: Automating SQL Stats Collection”

by Prakash Heda

SQLFeatures

On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco...

2012-10-05

957 reads

Presenting PowerShell: Automating SQL Stats Collection

by Prakash Heda

SQLFeatures

2012-10-05

Presenting PowerShell: Automating SQL Stats Collection

by Prakash Heda

SQLFeatures

2012-10-05

Presenting PowerShell: Automating SQL Stats Collection

by Prakash Heda

SQLFeatures

2012-10-05

SQL Server 2012 Unattended Installation on Windows Server 8

by Prakash Heda

SQLFeatures

2012-03-22

1 reads

SQL Server 2012 Unattended Installation on Windows Server 8

by Prakash Heda

SQLFeatures

2012-03-22

SQL Server 2012 Unattended Installation on Windows Server 8

by Prakash Heda

SQLFeatures

2012-03-22

1 reads

Blogs

Using Cron in Postgres Flex

By hellosqlkitty

pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...

Can I Change a Primary Key Value? #SQLNewBlogger

I heard someone say recently that you can’t change a primary key value in...

SQL Server Index Primer

Indexes 101: What, Why, and When? “What Is an Index?” I get this question...

Read the latest Blogs

Forums

How do you keep track of the purpose for SQL Logins?

Wondering how others keep track of the purpose for SQL Logins? I'm not talking...

Just a rant about the SQL Server 2022 upgrade

Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...

Report Server Configuration Manager - The target principal name is incorrect SSL

SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...

Visit the forum

Question of the Day

Getting the TEXTSIZE

How can I check what value I used for TEXTSIZE? I ran this code:

SET TEXTSIZE 8096

But then deleted the code and couldn't remember. Is there a way to check this?

See possible answers