Maruti Nandan

I am working at one of the top MNCs and have extensive experience on all versions of SQL Server since 2000,I have good hands on experience on following database features: Database Mirroring, Always ON, Replication, Log Shipping, Geo-Clustering and Performance Tuning and delivered many SQL Server projects on consolidation, upgrades, heterogeneous replication, HA / DR solutions, automation and major performance tuning

How to Fix SQL Server Installation Error 1639?

Last week, I was installing SQL Server 2012 on one of the database server. Unfortunately, the installation was failed with…

Understanding Different Types of SQL JOINs with Examples

SQL JOINs are used to retrieve set of information from two or more different tables based upon certain common values…

How to update License Key or Product Key of SQL Server Instance

I was working in a project where I came to know client was using MSDN licenses on production environment. Though…

Create a Logon Trigger to Restrict sysadmin logins to connect to SQL Server for given Time Interval

I was struggling with unwanted modifications of SQL Server configurations by random SQL Server sysadmin logins who were part of…