TechReflections

Stretch your database onto the cloud

I recently delivered an online webinar on one of the new features of SQL Server 2016 - Stretch...

Author: Devashish_Salgaonkar Date: 07/17/2016

Fixing orphaned Windows user logins in SQL Server

This is going to be a short blog post on a scenario which I encountered recently. Although there is...

Author: Devashish_Salgaonkar Date: 12/25/2015

Powershell Script to get the last SQL Server restart Time

I wrote this powershell script to find out the last SQL Server Restart times from a batch of servers...

Author: Devashish_Salgaonkar Date: 12/24/2015

Login Failure with Pass-Through Authentication

Although SQL Server login failure issues are pretty common I did not find this one documented...

Author: Devashish_Salgaonkar Date: 07/16/2015

Certificates not visible in Server Certificates console of IIS 7/IIS 8 Manager

You are planning to deploy SSL certificate for your website. You go ahead and get the required...

Author: Devashish_Salgaonkar Date: 07/04/2015

Troubleshooting Null Reference Exceptions in live ASP.NET applications

This post is more developer centric than for administrators but as the industry moves towards DevOps...

Author: Devashish_Salgaonkar Date: 05/31/2015

Case of Transaction Log backups not getting restored

I got a call from a DBA late night waking me up from deep slumber. They were restoring a critical...

Author: Devashish_Salgaonkar Date: 05/23/2015

Files not getting uploaded using Web service

The other day, a web application developer contacted me and said that he was not able to upload...

Author: Devashish_Salgaonkar Date: 05/16/2015