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

SQL Server – Script to Configure TempDB Files per Number of Logical Processors

by VS-Raavi

SqlServerZest.com - SQL in simple style

In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the...

2014-06-24

1,235 reads

SQL Server – How To Find SQL Virtual Name From Host Name in SQL Failover Clustering Using PowerShell

by VS-Raavi

SqlServerZest.com - SQL in simple style

Often times it is required to find out the SQL name from the host names in a clustered environment so you...

2014-04-14

1,170 reads

SQL Server – Using Tools to Analyze Query Performance

by VS-Raavi

SqlServerZest.com - SQL in simple style

Here is the session I gave for the techies at Microsoft about in-built tools available in SQL Server to analyze...

2014-02-11

958 reads

SQL Server – Deploying Multiple SSIS Packages into SQL Server Using Command Prompt Utility – DTUTIL

by VS-Raavi

SqlServerZest.com - SQL in simple style

Though there are several ways for importing SSIS packages into SQL Server either by creating a stored procedure or using...

2013-11-04

762 reads

SQL Server – Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data

by VS-Raavi

SqlServerZest.com - SQL in simple style

Before we get started on this topic, here is a quick fact..in SQL Server 2000, there used to be hard...

2013-10-14

1,131 reads

SQL Server – Restoring a TDE Encrypted Database to a Different Server

by VS-Raavi

SqlServerZest.com - SQL in simple style

In this article I will show you how to restore a database that is encrypted with Transparent Data Encryption (TDE)...

2013-10-03

979 reads

SQL Server –Encrypting and Securing Native Backups Using Transparent Data Encryption (TDE)

by VS-Raavi

SqlServerZest.com - SQL in simple style

Being part of the database engineering team, we were given a task to setup disaster recovery program for some of...

2013-10-03

754 reads

SQL Server – How to Copy or Export an SSIS Package Using Command Prompt Utility – DTUTIL

by VS-Raavi

SqlServerZest.com - SQL in simple style

The command prompt utility dtutil can be very handy when we want to quickly export an SSIS package from either file system...

2013-10-02

1,477 reads

SQL Server – How to Add More Than One Column as a Primary Key

by VS-Raavi

SqlServerZest.com - SQL in simple style

Sometimes you might want to add more than one column as primary key. For example, if you have three columns...

2013-09-17

595 reads

SQL Server – How to Create Registered Servers to Easily Manage and Query Multiple Instances at a Time

by VS-Raavi

SqlServerZest.com - SQL in simple style

Registered servers is a great way to manage, categorize and access the SQL servers through SSMS and also one of...

2013-09-16

487 reads

All authors

SQL Server – Script to Configure TempDB Files per Number of Logical Processors

SQL Server – How To Find SQL Virtual Name From Host Name in SQL Failover Clustering Using PowerShell

SQL Server – Using Tools to Analyze Query Performance

SQL Server – Deploying Multiple SSIS Packages into SQL Server Using Command Prompt Utility – DTUTIL

SQL Server – Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data

SQL Server – Restoring a TDE Encrypted Database to a Different Server

SQL Server –Encrypting and Securing Native Backups Using Transparent Data Encryption (TDE)

SQL Server – How to Copy or Export an SSIS Package Using Command Prompt Utility – DTUTIL

SQL Server – How to Add More Than One Column as a Primary Key

SQL Server – How to Create Registered Servers to Easily Manage and Query Multiple Instances at a Time

Blogs

Monday Monitor Tips: Searching Permission Changes

SQL Bits 2025 Wrap

Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed

Forums

Abobus

SQL Server 2008 to SQL Server 2022

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

Question of the Day

Using Heaps