Microsoft SQL Server

SQL Server Error: 18056, Severity: 20, State: 29

Howdy everyone, One of the most frequent error messages I come across when dealing with SQL Server, particularly SQL Server 2008 R2, is Error 18056, Severity: 20, State: 29. Not only do I constantly see this error message in the SQL logs, but also in the Microsoft community forums. I often see inquiries likes, “I have SQL…

On the Road with Laerte

For the month of October, Microsoft PowerShell MVP, Laerte Junior will be touring Brazil and Europe for various SQL Server-related speaking engagements. “Thankfully, I am working at a company that fully supports their employees to speak and participate in community events.” Laerte says. “I can travel to Europe for 5 SQL Server conferences, and then…

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

This blog post is the second in a series of three which will demonstrate how to configure a Point-to-Site VPN step-by-step. In my first blog post, I demonstrated how to configure a virtual network and a dynamic routing gateway. Today’s post will be about creating certificates. CREATING CERTIFICATES At this step, we will create and…

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 blog posts will demonstrate how to create the certificates, and how to configure the VPN…

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 below, MaxCmdsInTran number_of_commands Specifies the maximum number of statements grouped into a transaction as the Log…

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 capturing the network monitor output during the connectivity with different scenario. Here is an executive…

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 then failing back about 4 to 5 times in 15 minutes. I was holding pager,…

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 was trying to create a database. The application seemed to have a default timeout setting…

Page 3 of 5012345...102030...Last »