Tag: Microsoft SQL Server

How to Configure an Azure Point-to-Site VPN – Part 1

This blog post is the first in a series of three which will demonstrate how to configure a Point-to-Site VPN step-by-step. Today’s post will teach you how to configure a virtual network and a dynamic routing gateway, and the following…

Read More >

SQL Server and OS Error 1117, Error 9001, Error 823

Along with other administrators, life of us, the DBAs are no different but full of adventure.  At times, we encounter an issue which is very new for us, rather, one that we have not faced in the past.  Today, I…

Read More >

Interesting Behavior of MaxCmdsInTran Parameter

I recently worked on transactional replication issue and discovered interesting behavior of the log reader agent switch called MaxCmdsInTran and wanted to share it with you guys. Lets take a look at  the use of this switch by looking at the msdn documentation…

Read More >

How SQL Server Browser Service Works

Some of you may wonder the role SQL browser service plays in the SQL Server instance. In this blog post, I’ll provide an overview of the how SQL Server browser plays crucial role in connectivity and understand the internals of it by…

Read More >

Unexpected Shutdown Caused by ASR

In past few days I had two incidents and an outage, for just a few minutes. However, outage in a production environment is related to cost relatively and strictly. The server that had outage was because of failing over and…

Read More >

SQL Server 2014 Delayed Durability from an Application Perspective

The idea of this blog post is to describe what the delayed durability feature is in SQL Server 2014 and to describe a use case from an application development perspective. With every new SQL Server release we get a bunch…

Read More >

Lock Timeout Error While Creating Database

Recently I worked on a issue where a third-party application was failing during the installation. Below was the error returned by the Application. Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222) The application was failing while it…

Read More >

Script to Get the Create Date of an Object from Multiple Databases

As a DBA, it is common to get a request to run scripts against production databases. However, there can be environments where there are multiple databases on same instance, where the script needs to be run against. I have seen…

Read More >

Availability Group – Delay with Listener Connectivity After Failover

The beauty of working for multiple clients from different industries, is that you get exposed to a myriad of environment setup and configuration. Every company has its own standards for Network and Server configuration, as well different hardware vendors.  This…

Read More >

List of SQL Server Databases in an Availability Group

After migrating some databases to SQL Server 2012 and creating Availability Groups for some databases, we have noticed that some of our maintenance scripts were failing with the following error: The target database (‘MyDB1’) is in an availability group and…

Read More >