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

All authors

All authors

Blogs

Dynamically Unpivot columns in SQL

By

Picture this, your data ingestion team has created a table that has the sales...

Friday Basics: RPO and RTO

By

I did a post last month titled RTO and RPO are myths unless you've...

A New Word: ioia

By

ioia – n.the wish that you could see statistics overlaid on every person you...

Read the latest Blogs

Forums

SQL Server Encrypt data into a file, send it and then decrypt

By GBeezy

First off, my apologies for what could potentially be a bad title! I am...

Table partitioning best practice

By JasonO

I've inherited a couple of rather large databases from my ex-colleague when I join...

Identifying Customer Buying Pattern in Power BI - Part 2

By Farooq Aziz

Comments posted to this topic are about the item Identifying Customer Buying Pattern in...

Visit the forum

Question of the Day

Finding Marks

I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?

See possible answers