Migrate SQL database from On-Prem to Azure using SQL Database Migration Wizard tool

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…

0

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…

0

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…

0

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…

2

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…

0

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…

0

SQL Server: Impact of renaming the partitioned table on data

Hello all, Recently I helped an application team to rename a partitioned table of a production database. The application team had questions around data availability when the table is being renamed and ensure that the existing data is intact even post renaming the table. In this blog, I am covering the scenario of renaming the…

0

SSIS package execution failure when SSISDB is configured with AlwaysOn

Hello all, Recently I worked on an interesting issue with SSIS package execution issue. In this blog, I am sharing the steps taken to isolate the cause and fix it. Issue Description: SSIS Package execution fails when it is executed from Integration Services catalog from the secondary replica node using the listener name. No issue…

0

Database Mirroring Configuration Failure scenarios

Hello all, In this blog, I am covering few scenario’s that I have encountered while configuring Database mirroring as a high availability solution for SQL Server database. For demonstration purpose, I am using SQL 2012 instances on Windows 2012 R2 server. Principal Server: SQLServer\SQL2012Mirror Server: SQLServerDR\SQL2012Witness Server: Witness\WitnessMirrored Database: DBMirrorMirroring Port : 5022Service Account: SQLServiceAccount@contoso.lab…

5