Tutorials DBA Dev BI Career Categories Events Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Events

DBA Dev BI Categories

Jugal Shah

google plus

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.

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 atjugal.shah@sqldbpool.com.

2013 Awards

Central Management Servers

SQL Server Central Management Servers System Tables (5/23/2011)
Using PowerShell to Register All SQL Instances Into Central Management Server (3/29/2012)

Change Data Capture

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

Clustering

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

Database Administration

Different ways to make a table read only in a SQL Server database (6/15/2012)
Remote Desktop Error terminal server has exceeded the maximum number of allowed connections (4/9/2010)
Remotely Shutdown, Restart or Log Off the local or network computers (5/17/2010)
Script to Get Available and Free Disk Space for SQL Server (7/27/2011)
SQL Server restart validation checklist (7/30/2010)
Start, Stop, Pause and Query Windows SQL Server Services Remotely (8/26/2010)

Dynamic Management Views and Functions

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

Install and Uninstall

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

Log Shipping

Different ways to monitor Log Shipping for SQL Server databases (12/21/2011)
Step By Step SQL Server Log Shipping (2/22/2011)
Steps to add Log Shipping monitor into an existing SQL Server (11/16/2012)
Steps to Move SQL Server Log Shipping Secondary Database Files (12/28/2012)

Monitoring

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

PowerShell

PowerShell script to find files that are consuming the most disk space (9/24/2012)
Setting the PowerShell Execution Policy (5/22/2012)
Using a PowerShell Script to delete old files for SQL Server (6/26/2012)

Security

Different ways to secure the SQL Server SA Login (1/17/2011)
How to check SQL Server Authentication Mode using T SQL and SSMS (12/24/2010)
SQL Server Login Failure Error 18456, Severity 14, State 10 (4/27/2012)
SQL Server Login Issue With Default Database (10/7/2010)
Steps to Drop an Orphan SQL Server User when it owns a Schema or Role (2/29/2012)

SQL Server Configurations

Configuring SQL Server to Use Multiple Ports (9/13/2011)
Create a 32-bit DSN on 64-bit machine for SQL Server (9/22/2011)
Resolving could not open a connection to SQL Server errors (3/21/2011)
Steps to change the server name for a SQL Server machine (11/25/2011)
Steps to monitor the SQL Server Services (1/28/2013)

SQL Server Management Studio

Change Setting for Recently Used Files in SQL Server Management Studio SSMS (4/8/2011)
Customize SSMS query window for standard comment block and frequently used commands (5/4/2011)
Enabling IntelliSense and Refreshing IntelliSense Data in SSMS 2008 (2/1/2011)
How to Turn Off SQL Server Management Studio SSMS Auto Recovery Feature (4/15/2011)
How to use RunAs command for SSMS if option does not exist (3/7/2012)
Issues with Run As to Start SQL Server Management Studio with a Different Login (11/12/2010)
Prevent Truncation of Dynamically Generated Results in SQL Server Management Studio (11/8/2012)
SQL Server Management Studio Error 916 (9/10/2012)
Steps to clear the server list in SQL Server Management Studio (3/7/2011)

Tools

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

Upgrades and Migrations

SQL Server Database Migration Checklist (2/5/2010)

More SQL Server Solutions