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 jugal.shah@sqldbpool.com. He has been recognized as a SQL Server MVP since 2010.
  • MSSQLTips Awards: Trendsetter (25+ tips) - 2013
Title Category Date
Resolving could not open a connection to SQL Server errors SQL Server Configurations2026-05-06
Step By Step SQL Server Log Shipping Log Shipping2025-01-08
Steps to monitor the SQL Server Services SQL Server Configurations2013-01-28
Steps to Move SQL Server Log Shipping Secondary Database Files Log Shipping2012-12-28
Steps to add Log Shipping monitor into an existing SQL Server Log Shipping2012-11-16
Prevent Truncation of SQL Server Management Studio Results SQL Server Management Studio Configuration2012-11-08
Steps to Check the Host Name for a Clustered SQL Server Instance Clustering2012-10-26
PowerShell script to find files that are consuming the most disk space PowerShell2012-09-24
SQL Server Management Studio Error 916 SQL Server Management Studio2012-09-10
Using a PowerShell Script to delete old files for SQL Server PowerShell2012-06-26
Different ways to make a table read only in a SQL Server database Database Administration2012-06-15
Setting the PowerShell Execution Policy PowerShell2012-05-22
SQL Server Login Failure Error 18456, Severity 14, State 10 Security2012-04-27
PowerShell to Register All SQL Instances to Central Management Server Central Management Servers2012-03-29
How to use RunAs command for SSMS if option does not exist SQL Server Management Studio2012-03-07
Steps to Drop an Orphan SQL Server User when it owns a Schema or Role Security2012-02-29
Different ways to monitor Log Shipping for SQL Server databases Log Shipping2011-12-21
Steps to change the server name for a SQL Server machine SQL Server Configurations2011-11-25
Standardize SQL Server Installations with Configuration Files Install and Uninstall2011-10-24
Create a 32-bit DSN on 64-bit machine for SQL Server SQL Server Configurations2011-09-22
Configuring SQL Server to Use Multiple Ports SQL Server Configurations2011-09-13
Script to Get Available and Free Disk Space for SQL Server Database Administration2011-07-27
Restoring a SQL Server database that uses Change Data Capture Change Data Capture2011-06-24
SQL Server Central Management Servers System Tables Central Management Servers2011-05-23
Customize SQL Server Management Studio Query Window SQL Server Management Studio Configuration2011-05-04
Turn Off SQL Server Management Studio Auto Recovery Feature SQL Server Management Studio Configuration2011-04-15
Setting for Recently Used Files in SQL Server Management Studio SQL Server Management Studio Configuration2011-04-08
Steps to clear the server list in SQL Server Management Studio SQL Server Management Studio Configuration2011-03-07
Enabling IntelliSense and Refreshing IntelliSense Data in SSMS 2008 SQL Server Management Studio2011-02-01
Different ways to secure the SQL Server SA Login Security2011-01-17
How to check SQL Server Authentication Mode using T SQL and SSMS Security2010-12-24
New DMF for SQL Server 2008 sys.dm_fts_parser to parse a string Dynamic Management Views and Functions2010-12-03
Issues with Run As to Start SQL Server Management Studio with a Different Login SQL Server Management Studio2010-11-12
SQL Server Login Issue With Default Database Security2010-10-07
Start, Stop, Pause and Query Windows SQL Server Services Remotely Database Administration2010-08-26
SQL Server restart validation checklist Database Administration2010-07-30
Monitor, Start and Stop SQL Server services using xp_servicecontrol Monitoring2010-06-11
Remotely Shutdown, Restart or Log Off the local or network computers Database Administration2010-05-17
Terminal Server has Exceeded Maximum Number of Allowed Connections Database Administration2010-04-09
Insert Extended Characters into a SQL Server Table Using OSQL and TSQL Tools2010-03-02
SQL Server Database Migration Checklist Upgrades and Migrations2010-02-05