Atul Gaikwad
Atul Gaikwad has over 14+ years of experience with SQL Server. He currently works for one of the leading MNCs in Pune as a Delivery Manager handling small to large SQL Server production support projects. He is technology savvy and believes in automation and innovation. He likes to automate anything and everything which can help save time and make a DBAs life effortless and smooth, to focus on larger projects. He has extensive hands on experience in SQL Server administration and high availability solutions like clustering, replication, log shipping, mirroring, etc. He also possesses strong knowledge of SSRS and SSIS.
2016 Awards
2016 Awards
Availability Groups
- Automate refresh of a SQL Server database that is part of an Availability Group (last update: 12/14/2017)
- SQL Server misaligned log IOs which required falling back to synchronous IO (last update: 2/25/2019)
Azure
- How to Restore Azure SQL LTR Backup After Azure SQL Instance Deleted (last update: 7/3/2020)
- How to use Azure Blog Storage for SQL Server Backup and Restore (last update: 2/12/2019)
Database Configurations
- Notification for SQL Server Database in Single User Mode (last update: 11/29/2019)
Dates
- Update only Year, Month or Day in a SQL Server Date (last update: 11/14/2019)
Log Shipping
- SQL Server Log Shipping Monitoring and Email Notification (last update: 10/7/2016)
Monitoring
- SSIS Package to Centrally Monitor All SQL Servers (last update: 10/13/2017)
- SSIS Package to Centrally Monitor SQL Server Backups (last update: 10/19/2017)
Other Database Platforms
- Automate Oracle Table Space Report using SQL Server (last update: 6/22/2016)
- How to automate Oracle TableSpace report from SQL Server-Part II (last update: 6/30/2016)
Replication
- Automate SQL Server Replication Monitoring (last update: 10/19/2016)
- Resolve SQL Server Replication Error - Could not find stored procedure sp_MSupd_dboPS (last update: 10/5/2017)
SQL Server Agent
- Automate Custom SQL Server Agent Job Monitoring with Email Notification (last update: 7/13/2016)
T-SQL
- Differences between Delete and Truncate in SQL Server (last update: 4/20/2016)
- Execute SQL Scripts on Multiple SQL Servers and Save Output as CSV Files (last update: 5/30/2019)
