Remote DAC connections

TweetG’day,
I wrote a post recently about setting the DAC port for an SQL instance.
I now do this as a matter...

Thank God I Chose SQL Server part I: The Tribulations of a DB2 Trial

My last column, Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong, described a comedy of...

BIDS Helper 1.6 for SQL Server 2012 released

BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...

Execution Plan for a User Defined Function

When you execute a multi-statement user-defined function you may see an execution plan that looks something like this:

It appears as...

Liveblog for #SQLBits X Day 1 Keynote

Welcome to the show! I’ll be liveblogging today’s keynote here at SQLBits X in London.
There’s no need to refresh your...

Re-blog – March 23 – March 29

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

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....