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
MSSQLTips award

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 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)

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 Management Studio

Create Custom Widget in SQL Server Operations Studio (last update: 5/31/2018)

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

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Nisarg Upadhyay

More SQL Server Solutions