Hello all, In this blog, I am covering the scenario of migrating the SQL Server database from On premise environment to SQL Azure Virtual machine. There are multiple ways to migrate the application database hosted in On premise to Azure Virtual machine. Few to mention are: Use the Deploy a SQL Server Database to…
Year: 2016
Migrating database from AlwaysOn AG to another with JoinOnly option
Hi all, In this blog, I am covering a scenario of migrating a SQL database from one AlwaysOn Availability Group (AG) to a new AG. I was involved in such requirement and the goal was to migrate the database which was in terabytes size to another AG without having to apply the Full back up…
Enabling client side SSL encryption to SQL Server
Hello all, In this blog, I am covering the scenario of enabling SSL encryption on the client while connecting to SQL Server. SSL encryption with SQL server can be achieved by enabling Server side encryption or client side encryption. Server side encryption requires, enabling Force encryption= True on SQL Server which will enable encryption…
Troubleshooting IIS request performance slowness issues using FREB tracing
Hello all, In this blog, I would like to cover the scenario of troubleshooting web application page execution slowness issue using Freb logs. FREB (Failed Requests Tracing) is one of the feature available to troubleshoot IIS issues. It does request based tracing, and produces a log file (in .xml format) that shows events and…
Network Error while accessing login page of an application hosted on IIS
Hello all, In this blog I have covered the scenario where IIS site was not loading and the steps I took to identify and resolve the issue: Application user reported that they were not able to browse the “login.aspx page” of the application and were encountering the below error on the client browser: Network Error…
Common ‘SSPI handshake failed’ errors and troubleshooting
Hello all, I came across a scenario where System Center monitoring tool was constantly reporting “SSPI Handshake errors” and I was approached by SQL DBA team to assist in addressing these errors. SCOM monitors the SQL Server Error log folder and reports these alerts. In this blog, I am covering the cause of this issue…
SQL SSMS not listing MSDAORA provider when connected to 64 bit instance
Hello all, Recently I had worked with the application team on a requirement of setting up Linked server for Oracle data source. There was an interesting question on MSDAORA provider not showing up in SQL management studio to setup Linked server. In this blog, we will be covering the reason why MSDAORA provider doesn’t list…