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.
2018 Awards
2018 Awards
Azure
- Create a SQL Server Linked Server to Azure SQL Database (last update: 10/30/2019)
Compression
- SQL Server Backup Compression using WinRAR (last update: 12/31/2019)
Database Console Commands DBCCs
- Generate HTML Formatted Email of SQL Server Database Consistency Check Errors (last update: 10/2/2018)
Disaster Recovery
- How to Recover Data from a SQL Server Temporal Table (last update: 1/18/2018)
FILESTREAM
- Stored procedure to import files into a SQL Server FILESTREAM enabled table (last update: 5/17/2018)
Identities
- Report of SQL Server identity values close to reaching maximum allowed values (last update: 4/30/2018)
Integration Services Development
- Refresh Excel Pivot Tables Automatically Using SSIS Script Task (last update: 2/26/2019)
Integration Services Excel
- Export MySQL data to Excel using SQL Server Integration Services (last update: 9/20/2018)
- Export SQL Server Data to Multiple Excel Worksheets using SQL Server Integration Services (last update: 2/16/2018)
- Export SQL Server Data to Multiple Excel Worksheets with Integration Services (last update: 2/7/2018)
Maintenance
- Move SQL Server Maintenance Plan from One Server to Another (last update: 3/22/2018)
PowerShell
- PowerShell Module to Read Directory Contents and Store in a SQL Server Table (last update: 1/28/2019)
Replication
- Add new article to existing publication for SQL Server Transactional Replication (last update: 10/15/2018)
- SQL Server Replication Error: cannot create publication because the server is too old (last update: 3/5/2018)
- SQL Server Replication Latency Alert via Email (last update: 11/20/2018)
SQL Server Management Studio
- Create Custom Widget in SQL Server Operations Studio (last update: 5/31/2018)
