Suresh Raavi is a database professional, with a zest for SQL Server specializing in Administration and performance tuning. Presently, he is a Sr. SQL Server DBA at the Microsoft Products and Services IT SQL team, taking part in various challenging projects, focusing mainly on performance tuning, database development, high availability and database design. He is passionate about database technologies and "data" in general. He has earned the MCITP Database Administrator 2008, and holds a Master of Science degree in Engineering. He provides insights from the field on his blog at http://SqlServerZest.com. His hobbies includes Running and Travelling.
You can follow him on Twitter @SqlServerZest

Blogs

Truncating very large transaction log in full recovery mode

By

While I always configure transaction log backups for every database in non-simple recovery model,...

Autonomous Driving Around London

By

There’s a video of Bill Gates taking a drive in an autonomous car around...

Best way to monitor high worker thread on SQL Server

By

It is common to see high worker count issue on the production server and...

Read the latest Blogs

Forums

Is TemporalTable SysStartTime available before performing an insert/Update?

By Dwaine Wright

I want to align a Date column (datetime2(7)) with the same full resolution date...

multiple PAGELATCH_UP waits on data file

By bobrooney.81

Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...

dynamic update to SP

By Bruin

Looking for suggestions\examples of how to update a SP that the table used changes...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers