Select : Lock or No Lock?

Here is a post I happen to find today: why select command is not blocked by update command?

http://blog.csdn.net/zjcxc/article/details/4383113
First, I...

Spring SQL Server Connections / DevConnections

I returned late last night from the Spring DevConnections event, delivering three sessions in the SQL Server Connections conference. I...

SQL Saturday #130 Jacksonville Schedule Posted

SQL Saturday Jacksonville is just under a month away (April 28) and I’m happy to announce the we recently released...

SQL Server Upgrade error: It is not possible to change the SQL Server features to be upgraded in this release. Validation errors. There are no features selected for upgrade.

On a recent project I was asked to “upgrade” a licensed SQL Server 2008R2 Standard Edition to SQL Server 2008R2 Enterprise Edition....

Start Building Your Next Network

Take a look at your network right now and while it probably has some diversity, I bet it’s tied pretty...

Stress Thoughts-Part 4

Recently I suffered through a frustrating and contentious meeting, and that was stressful. I needed a walk, a few minutes...

An Amusing New Chapter of My Career

Starting next week, that’s the first week of April, this will be my new office. Well, not really, but I’ll be working for the company that hosts this coaster,...

An Amusing New Chapter of My Career

My New Office
Starting next week, that’s the first week of April, this will be my new office. Well, not really,...

Caveats of a CONTROL SERVER permission

Today morning I was working on one of the server to complete the regular documentation of security audit with details...

Contained Databases in SQL Server 2012

One of the problems with databases in SQL Server is the dependency of the database on various parts of the...