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)

13,225 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,950 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,334 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,948 reads

All authors

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

Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable

Impactful Sessions I’ve Seen: T-SQL Tuesday #196

Changing the Cardinality of a FK in Redgate Data Modeler

Forums

Removing TDE

Poor Names

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Question of the Day

Removing TDE