Nisarg Upadhyay

Nisarg Upadhyay is a SQL Server Database Administrator and Microsoft certified professional who has more than 5 years of experience with SQL Server and 2 years with Oracle 10g including: database design, performance tuning, backup and recovery, HA and DR setup, database migrations and upgrades. He has completed the Bachelors in Information Technology from Ganpat University. When Nisarg is away from computers, he loves travelling, reading books and watching Sci-Fi movies.
  • MSSQLTips Awards: Rookie of the Year Contender - 2018
Title Category Date
SQL Create Database Valuable Tutorial with T-SQL and SSMS Database Design2024-12-11
Automatically Generate Restore Database SQL Server Scripts Restore2024-11-28
SQL Server Default File Locations – Data, Transaction Log and Backup Backup2023-10-31
SQL Server Backup Compression using WinRAR Compression2019-12-31
Create a SQL Server Linked Server to Azure SQL Database Azure SQL Database2019-10-30
Refresh Excel Pivot Tables Automatically Using SSIS Script Task Integration Services Development2019-02-26
PowerShell to Read Directory Contents and Store in SQL Server Table PowerShell2019-01-28
SQL Server Replication Latency Alert via Email Replication2018-11-20
Add Article to Publication for SQL Server Transactional Replication Replication2018-10-15
Generate HTML Email for SQL Server Database Consistency Check Errors Database Console Commands DBCCs2018-10-02
Export MySQL data to Excel using SSIS Integration Services Excel2018-09-20
Create Custom Widget in SQL Server Operations Studio SQL Server Management Studio2018-05-31
Stored procedure to import files into a SQL Server FILESTREAM enabled table FILESTREAM2018-05-17
Find SQL Server identity values close to reaching maximum values Identities2018-04-30
Move SQL Server Maintenance Plan from One Server to Another Maintenance2018-03-22
SQL Server Replication Error: cannot create publication because the server is too old Replication2018-03-05
Export SQL Server Data to Multiple Excel Worksheets using SSIS Integration Services Excel2018-02-16
Export SQL Data to Multiple Excel Worksheets with Integration Services Integration Services Excel2018-02-07
How to Recover Data from a SQL Server Temporal Table Disaster Recovery2018-01-18