Jugal Shah

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

MSSQLTips award

Central Management Servers

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)

Change Data Capture

Restoring a SQL Server database that uses Change Data Capture (last update: 6/24/2011)

Clustering

Steps to Check the Host Name for a Clustered SQL Server Instance (last update: 10/26/2012)

Database Administration

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)

Dynamic Management Views and Functions

New DMF for SQL Server 2008 sys.dm_fts_parser to parse a string (last update: 12/3/2010)

Install and Uninstall

Standardize SQL Server Installations with Configuration Files (last update: 10/24/2011)

Log Shipping

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)

Monitoring

Monitor, Start and Stop SQL Server services using xp_servicecontrol (last update: 6/11/2010)

PowerShell

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)

Security

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)

SQL Server Configurations

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)

SQL Server Management Studio

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)

Tools

Insert Extended Characters into a SQL Server Table Using OSQL and TSQL (last update: 3/2/2010)

Upgrades and Migrations

SQL Server Database Migration Checklist (last update: 2/5/2010)

More SQL Server Solutions

download

get free sql tips