Tag: Microsoft SQL Server

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 >

Microsoft Analytics Platform System: Name Overhaul in Big Data War!

I had the chance to attend a course about what used to be called Parallel Data Warehouse (PDW). PDW was introduced few years ago with the offering of SQL Server 2008 R2 Parallel Data Warehouse , something very few people…

Read More >

Why is Affinity Mask Negative in sp_configure?

While looking at a SQL server health report, I found affinity mask parameter in sp_configure output showing a negative value. name                                minimum     maximum     config_value run_value ———————————– ———– ———– ———— ———– affinity mask                       -2147483648 2147483647  -1066394617  -1066394617 Affinity mask is a…

Read More >

COLLABORATE minus 3

Musings about COLLABORATE, the 9th version of which is happening in Las Vegas USA from April 7-11 2014.

Read More >

Tips on TempDB

Are you curious about TempDB? Allow me to help make your understanding of the subject permanent. TempDB is an interesting system database that doesn’t behave quite like the others. It’s kind of like a quirky friend that you’ve come to…

Read More >

Nothing to Blog About? Think Again!

Suggestions about how to proceed if you are just getting started with blogging or searching for topics to blog about.

Read More >

SQL Server Integrity Check – A Necessary Routine

Today I’ll be discussing Integrity Check on SQL Server – we have some very good info in the community, but I’d like to summarize my thoughts here. When a DBA talks about Integrity Check, the conversation is usually redirected to…

Read More >