Home

Author: Nisarg Upadhyay

Nisarg is a SQL Server Database Administrator and Microsoft certified professional who has more than 5 years of experience with SQL Server administration and 2 years with Oracle 10g database administration. He has expertise in 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.

SQL Server Management Studio (SSMS) Registered Server

July 03, 2018• SSMS, Tools & technologies

Managing numerous database servers in an organization is difficult. Either we must maintain a list...
Read More →

Registered Server, a Hidden Gem of SQL Server Management Studio

July 03, 2018• SSMS, Tools & technologies

Managing numerous database servers in an organization can be performed using the PowerShell scripts but it requires some complex PowerShell...
Read More →

Performing Data Changes Audit Using Temporal Table

May 29, 2018• Database administration, Tables, Work with data

SQL Server 2016 has introduced a feature called ‘System versioned temporal table’. Using normal table, you can retrieve current data;...
Read More →
↑
Close