Jugal Shah
Biography
Jugal Shah is the founder of SQLDBPool.com, where he is writes articles on SQL Server Administration and Development. Jugal has 8+ years of extensive experience in SQL Server Database administration and development. Jugal has worked on SQL Server 2000, 2005, 2008 and 2008 R2. In his current assignment, Jugal is managing large critical databases. His expertise is in database security, performance tuning and implementing high availability solutions. He can be contacted at [email protected]. He has been recognized as a SQL Server MVP since 2010.
Community Activity
Jugal contributes technical articles on SQLDBPool.com and MSSQLTips.com. He also
provides support to the community on email, chat and in the
http://sqldbpool.forumotion.in/
forum. Jugal has been recognized as a SQL Server MVP since April 2010.
Publications
Jugal has contributed more than 24+ articles on MSSQLTips.com and 300+ articles on SQLDBPool.com.
Social Media
Contact Information
Jugal can be reached at[email protected]
2013 Awards

- SQL Server Central Management Servers System Tables (last update: 5/23/2011)
- Using PowerShell to Register All SQL Instances Into Central Management Server (last update: 3/29/2012)
- Restoring a SQL Server database that uses Change Data Capture (last update: 6/24/2011)
- Steps to Check the Host Name for a Clustered SQL Server Instance (last update: 10/26/2012)
- Different ways to make a table read only in a SQL Server database (last update: 6/15/2012)
- Remote Desktop Error terminal server has exceeded the maximum number of allowed connections (last update: 4/9/2010)
- Remotely Shutdown, Restart or Log Off the local or network computers (last update: 5/17/2010)
- Script to Get Available and Free Disk Space for SQL Server (last update: 7/27/2011)
- SQL Server restart validation checklist (last update: 7/30/2010)
- Start, Stop, Pause and Query Windows SQL Server Services Remotely (last update: 8/26/2010)
- New DMF for SQL Server 2008 sys.dm_fts_parser to parse a string (last update: 12/3/2010)
- Standardize SQL Server Installations with Configuration Files (last update: 10/24/2011)
- Different ways to monitor Log Shipping for SQL Server databases (last update: 12/21/2011)
- Step By Step SQL Server Log Shipping (last update: 3/1/2017)
- Steps to add Log Shipping monitor into an existing SQL Server (last update: 11/16/2012)
- Steps to Move SQL Server Log Shipping Secondary Database Files (last update: 12/28/2012)
- Monitor, Start and Stop SQL Server services using xp_servicecontrol (last update: 6/11/2010)
- PowerShell script to find files that are consuming the most disk space (last update: 9/24/2012)
- Setting the PowerShell Execution Policy (last update: 5/22/2012)
- Using a PowerShell Script to delete old files for SQL Server (last update: 6/26/2012)
- Different ways to secure the SQL Server SA Login (last update: 1/17/2011)
- How to check SQL Server Authentication Mode using T SQL and SSMS (last update: 12/24/2010)
- SQL Server Login Failure Error 18456, Severity 14, State 10 (last update: 4/27/2012)
- SQL Server Login Issue With Default Database (last update: 10/7/2010)
- Steps to Drop an Orphan SQL Server User when it owns a Schema or Role (last update: 2/29/2012)
- Configuring SQL Server to Use Multiple Ports (last update: 9/13/2011)
- Create a 32-bit DSN on 64-bit machine for SQL Server (last update: 9/22/2011)
- Resolving could not open a connection to SQL Server errors (last update: 5/29/2019)
- Steps to change the server name for a SQL Server machine (last update: 11/25/2011)
- Steps to monitor the SQL Server Services (last update: 1/28/2013)
- Change Setting for Recently Used Files in SQL Server Management Studio SSMS (last update: 4/8/2011)
- Customize SSMS Query Window for Standard Comment Block and Frequently Used Commands (last update: 5/4/2011)
- Enabling IntelliSense and Refreshing IntelliSense Data in SSMS 2008 (last update: 2/1/2011)
- How to Turn Off SQL Server Management Studio SSMS Auto Recovery Feature (last update: 4/15/2011)
- How to use RunAs command for SSMS if option does not exist (last update: 3/7/2012)
- Issues with Run As to Start SQL Server Management Studio with a Different Login (last update: 11/12/2010)
- Prevent Truncation of Dynamically Generated Results in SQL Server Management Studio (last update: 11/8/2012)
- SQL Server Management Studio Error 916 (last update: 9/10/2012)
- Steps to clear the server list in SQL Server Management Studio (last update: 3/7/2011)
- Insert Extended Characters into a SQL Server Table Using OSQL and TSQL (last update: 3/2/2010)
- SQL Server Database Migration Checklist (last update: 2/5/2010)