Jugal Shah

Jugal Shah has 8+ years of extensive SQL Server experience and has worked on SQL Server 2000, 2005, 2008 and 2008 R2.

   

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   

CategoryTitle
Central Management ServersSQL Server Central Management Servers System Tables
Central Management ServersUsing PowerShell to Register All SQL Instances Into Central Management Server
Change Data CaptureRestoring a SQL Server database that uses Change Data Capture
ClusteringSteps to Check the Host Name for a Clustered SQL Server Instance
Database AdministrationDifferent ways to make a table read only in a SQL Server database
Database AdministrationRemote Desktop Error terminal server has exceeded the maximum number of allowed connections
Database AdministrationRemotely Shutdown, Restart or Log Off the local or network computers
Database AdministrationScript to Get Available and Free Disk Space for SQL Server
Database AdministrationSQL Server restart validation checklist
Database AdministrationStart, Stop, Pause and Query Windows SQL Server Services Remotely
Dynamic Management Views and FunctionsNew DMF for SQL Server 2008 sys.dm_fts_parser to parse a string
Install and UninstallStandardize SQL Server Installations with Configuration Files
Log ShippingDifferent ways to monitor Log Shipping for SQL Server databases
Log ShippingStep By Step SQL Server Log Shipping
Log ShippingSteps to add Log Shipping monitor into an existing SQL Server
Log ShippingSteps to Move SQL Server Log Shipping Secondary Database Files
MonitoringMonitor, Start and Stop SQL Server services using xp_servicecontrol
PowerShellPowerShell script to find files that are consuming the most disk space
PowerShellSetting the PowerShell Execution Policy
PowerShellUsing a PowerShell Script to delete old files for SQL Server
SecurityDifferent ways to secure the SQL Server SA Login
SecurityHow to check SQL Server Authentication Mode using T SQL and SSMS
SecuritySQL Server Login Failure Error 18456, Severity 14, State 10
SecuritySQL Server Login Issue With Default Database
SecuritySteps to Drop an Orphan SQL Server User when it owns a Schema or Role
SQL Server ConfigurationsConfiguring SQL Server to Use Multiple Ports
SQL Server ConfigurationsCreate a 32-bit DSN on 64-bit machine for SQL Server
SQL Server ConfigurationsResolving could not open a connection to SQL Server errors
SQL Server ConfigurationsSteps to change the server name for a SQL Server machine
SQL Server ConfigurationsSteps to monitor the SQL Server Services
SQL Server Management StudioEnabling IntelliSense and Refreshing IntelliSense Data in SSMS 2008
SQL Server Management StudioHow to use RunAs command for SSMS if option does not exist
SQL Server Management StudioIssues with Run As to Start SQL Server Management Studio with a Different Login
SQL Server Management StudioSQL Server Management Studio Error 916
SQL Server Management Studio ConfigurationChange Setting for Recently Used Files in SQL Server Management Studio SSMS
SQL Server Management Studio ConfigurationCustomize SSMS Query Window for Standard Comment Block and Frequently Used Commands
SQL Server Management Studio ConfigurationHow to Turn Off SQL Server Management Studio SSMS Auto Recovery Feature
SQL Server Management Studio ConfigurationPrevent Truncation of Dynamically Generated Results in SQL Server Management Studio
SQL Server Management Studio ConfigurationSteps to clear the server list in SQL Server Management Studio
ToolsInsert Extended Characters into a SQL Server Table Using OSQL and TSQL
Upgrades and MigrationsSQL Server Database Migration Checklist
No Records Found
No Records Found
CategoryGroupCategory (articles)
Analysis ServicesAnalysis Services Administration (31)
Analysis ServicesAnalysis Services Development (95)
Analysis ServicesAnalysis Services Dimensions (16)
Analysis ServicesAnalysis Services Measure Groups (7)
Analysis ServicesAnalysis Services Performance (14)
Analysis ServicesAnalysis Services Security (7)
Analysis ServicesAnalysis Services Tools (1)
Analysis ServicesAnalysis Services Tutorials (6)
Analysis ServicesCortana (5)
Analysis ServicesPerformance Point (4)
Business IntelligenceBig Data (25)
Business IntelligenceData Warehousing (4)
CloudAmazon AWS (47)
CloudApache Spark (3)
CloudAzure (188)
CloudAzure Backup and Restore (25)
CloudAzure Cosmos DB (12)
CloudAzure Data Factory (68)
CloudAzure Databricks (23)
CloudAzure Integration Services (14)
CloudAzure Synapse Analytics (36)
CloudCloud Strategy (12)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (75)
Database AdministrationBackup (78)
Database AdministrationCentral Management Servers (9)
Database AdministrationClustering (73)
Database AdministrationComparison Data and Objects (14)
Database AdministrationCompression (22)
Database AdministrationContained Databases (4)
Database AdministrationContainers (12)
Database AdministrationDatabase Administration (190)
Database AdministrationDatabase Configurations (18)
Database AdministrationDatabase Console Commands DBCCs (25)
Database AdministrationDatabase Mail (18)
Database AdministrationDatabase Mirroring (33)
Database AdministrationDBA Best Practices (39)
Database AdministrationDedicated Administrator Connection (4)
Database AdministrationDeprecated Features (5)
Database AdministrationDevOps (34)
Database AdministrationDisaster Recovery (23)
Database AdministrationError Logs (11)
Database AdministrationExpress Edition (16)
Database AdministrationExtended Events (22)
Database AdministrationFILESTREAM (9)
Database AdministrationFragmentation and Index Maintenance (27)
Database AdministrationHardware (13)
Database AdministrationHigh Availability (3)
Database AdministrationIndexing (82)
Database AdministrationInstall and Uninstall (32)
Database AdministrationLicensing (4)
Database AdministrationLinked Servers (18)
Database AdministrationLocking and Blocking (38)
Database AdministrationLog Shipping (18)
Database AdministrationMaintenance (34)
Database AdministrationMonitoring (115)
Database AdministrationOther Database Platforms (74)
Database AdministrationPartitioning (15)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (123)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (129)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (41)
Database AdministrationSQL Server 2016 (100)
Database AdministrationSQL Server 2017 (44)
Database AdministrationSQL Server 2019 (19)
Database AdministrationSQL Server 2022 (10)
Database AdministrationSQL Server Configurations (75)
Database AdministrationSQL Server on Linux (76)
Database AdministrationStreamInsight (2)
Database AdministrationSystem Databases (31)
Database AdministrationUpgrades and Migrations (54)
Database AdministrationVirtualization (25)
Database AdministrationWindows Internal Database (1)
Database DevelopmentApplication Development (36)
Database DevelopmentChange Data Capture (15)
Database DevelopmentCommon Runtime Language (13)
Database DevelopmentCommon Table Expressions (3)
Database DevelopmentConstraints (20)
Database DevelopmentData Cleansing for Validation (2)
Database DevelopmentData Science (3)
Database DevelopmentData Types (17)
Database DevelopmentDatabase Design (71)
Database DevelopmentDates (49)
Database DevelopmentDebugging (4)
Database DevelopmentDynamic Management Views and Functions (33)
Database DevelopmentDynamic SQL (7)
Database DevelopmentEntity Framework (13)
Database DevelopmentError Handling (8)
Database DevelopmentFull Text Search (21)
Database DevelopmentFunctions System (70)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (77)
Database DevelopmentIn Memory OLTP (32)
Database DevelopmentJOIN Tables (21)
Database DevelopmentLanguage Integrated Query LINQ (7)
Database DevelopmentMicrosoft Access Integration (8)
Database DevelopmentMicrosoft Excel Integration (40)
Database DevelopmentMicrosoft Flow (1)
Database DevelopmentPaging (5)
Database DevelopmentPython (48)
Database DevelopmentQuery Optimization (14)
Database DevelopmentQuery Plans (20)
Database DevelopmentR Language (11)
Database DevelopmentScripts (35)
Database DevelopmentService Broker (11)
Database DevelopmentSpatial Data Storage (9)
Database DevelopmentSQL Injection (5)
Database DevelopmentSQL Server Management Objects SMO (3)
Database DevelopmentStored Procedures (28)
Database DevelopmentSynonyms (5)
Database DevelopmentTable Valued Parameters (4)
Database DevelopmentTemp Tables (9)
Database DevelopmentTemporal Tables (13)
Database DevelopmentTesting (31)
Database DevelopmentTransactions (9)
Database DevelopmentTriggers (44)
Database DevelopmentTSQL (321)
Database DevelopmentUser Defined Type UDT (3)
Database DevelopmentViews (13)
Database DevelopmentXML (14)
Integration ServicesData Transformation Services (5)
Integration ServicesIntegration Services Administration (10)
Integration ServicesIntegration Services Analysis Services Tasks (5)
Integration ServicesIntegration Services Best Practices (12)
Integration ServicesIntegration Services Configuration Options (21)
Integration ServicesIntegration Services Connection Managers (5)
Integration ServicesIntegration Services Control Flow Transformations (14)
Integration ServicesIntegration Services Data Flow Transformations (19)
Integration ServicesIntegration Services Development (107)
Integration ServicesIntegration Services Email (3)
Integration ServicesIntegration Services Error Handling (8)
Integration ServicesIntegration Services Excel (14)
Integration ServicesIntegration Services Execute Package Options (8)
Integration ServicesIntegration Services Import and Export Wizard (2)
Integration ServicesIntegration Services NULL Management (4)
Integration ServicesIntegration Services Oracle (4)
Integration ServicesIntegration Services Performance (12)
Integration ServicesIntegration Services Security (7)
Integration ServicesIntegration Services Upgrade (4)
Power PlatformPower Apps (17)
Power PlatformPower BI (133)
Power PlatformPower BI Charts (46)
Power PlatformPower BI Formatting (15)
Professional DevelopmentProfessional Development Books (3)
Professional DevelopmentProfessional Development Branding (13)
Professional DevelopmentProfessional Development Career (17)
Professional DevelopmentProfessional Development Career Planning (16)
Professional DevelopmentProfessional Development Career Transition (4)
Professional DevelopmentProfessional Development Certifications (47)
Professional DevelopmentProfessional Development Community (16)
Professional DevelopmentProfessional Development Conferences (2)
Professional DevelopmentProfessional Development Interview Questions BI (15)
Professional DevelopmentProfessional Development Interview Questions DBA (23)
Professional DevelopmentProfessional Development Interview Questions Developer (9)
Professional DevelopmentProfessional Development Interviewing (38)
Professional DevelopmentProfessional Development Job Search (17)
Professional DevelopmentProfessional Development Management (9)
Professional DevelopmentProfessional Development Recruiters (6)
Professional DevelopmentProfessional Development Resume (13)
Professional DevelopmentProfessional Development Skills Development (18)
Reporting ServicesReporting Services Administration (19)
Reporting ServicesReporting Services Analysis Services (4)
Reporting ServicesReporting Services Best Practices (6)
Reporting ServicesReporting Services Charts (25)
Reporting ServicesReporting Services Configuration (10)
Reporting ServicesReporting Services Custom Report (2)
Reporting ServicesReporting Services Dashboard (1)
Reporting ServicesReporting Services Data Sources (10)
Reporting ServicesReporting Services Development (37)
Reporting ServicesReporting Services Drill Through (4)
Reporting ServicesReporting Services Dynamic Reports (11)
Reporting ServicesReporting Services Filtering (3)
Reporting ServicesReporting Services Formatting (26)
Reporting ServicesReporting Services Functions (5)
Reporting ServicesReporting Services Images (2)
Reporting ServicesReporting Services Installation (9)
Reporting ServicesReporting Services KPI (5)
Reporting ServicesReporting Services Maps (4)
Reporting ServicesReporting Services Migration (5)
Reporting ServicesReporting Services Monitoring (5)
Reporting ServicesReporting Services Network Load Balancing (4)
Reporting ServicesReporting Services Overview (5)
Reporting ServicesReporting Services Parameters (15)
Reporting ServicesReporting Services Performance (6)
Reporting ServicesReporting Services Report Builder (9)
Reporting ServicesReporting Services Report Models (1)
Reporting ServicesReporting Services Security (8)
Reporting ServicesReporting Services SharePoint (1)
Reporting ServicesReporting Services Subreports (4)
Reporting ServicesReporting Services Tutorials (1)
SecurityAuditing and Compliance (45)
SecurityEncryption (32)
SecuritySecurity (196)
SecuritySurface Area Configuration Manager (4)
SharePointSharePoint (130)
SharePointSharePoint Administration (46)
SharePointSharePoint Configuration (27)
SharePointSharepoint Design (46)
SharePointSharePoint Document Management (20)
ToolsAzure Data Studio (16)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (93)
ToolsSQL Server Management Studio (77)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (33)