Harsh Mishra

I have been working as a SQL Administrator for more than 5 years and it has been an enriching and exciting experience. I want to contribute back to the community which has given me a lot over the years.

All authors

Forcing Execution Plan

by Harsh Mishra

SQL Toast

Very rarely there is a need to force an execution plan and even more rarely we should be doing it....

2018-07-30 (first published: 2018-07-20)

12,246 reads

Send SMS from SQL Server

by Harsh Mishra

SQL Toast

We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production...

2014-03-31

1,805 reads

Merge outputs of perfmon and profiler to get a great view

by Harsh Mishra

SQL Toast

There is a way by which we can merge the .trc and .blg files to get a great view as...

2013-10-17 (first published: 2013-10-09)

6,223 reads

SQL Server Statistics

by Harsh Mishra

SQL Toast

INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....

2013-09-29

3,748 reads

All authors

Blogs

Check your regions people

By Koen Verbeeck

Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...

Using Git Prune–#SQLNewBlogger

By Steve Jones

As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...

Read the latest Blogs

Harsh Mishra

Forcing Execution Plan

Send SMS from SQL Server

Merge outputs of perfmon and profiler to get a great view

SQL Server Statistics

Blogs

Check your regions people

Using Git Prune–#SQLNewBlogger

Microsoft Purview new data governance features

Forums

Do I need a recursive query for this? bill of materials (sort of)

Do I need a recursive query for this? bill of materials (sort of)

Create Copy of DB in same server.

Question of the Day

Restoring the Resource Database