GetDate() V/s GetUTCDate()

Today my colleague asked me, what is the difference between GetDate() and GetUTCDate()? and I thought it would be a nice idea to blog about it. So here it is, my next article. In simple words the GetDate() returns the local time where as GetUTCDate() returns the GMT time. GETDATE()… Continue Reading GetDate() V/s GetUTCDate()

Transfer Login to Replica servers

Recently I was working on configuring AlwaysOn replica setup. After a fail-over my application was not able to connect to the SQL server using the same SQL accounts. The error was “Login failed for user” The reason is SQL Server never replicates the SQL Server Login, though it replicates the… Continue Reading Transfer Login to Replica servers