Monthly Archives: November 2010

Contained Databases

Posted on November 24, 2010 by Phil

Contained databases are a new feature that currently exist only in SQL Server 2011 “Denali” (currently in CTP 1). According to Microsoft’s documentation on this new feature, contained databases remove any dependency from the SQL Server management level, all objects, … Continue reading →

Posted in Contained Databases, SQL Server 2011 "Denali" | Tagged , , | Leave a comment

Beta Testing Software

Posted on November 23, 2010 by Phil

I don’t know how many of you try out beta software, I know that it’s not always without it’s headaches, but in the end; you do get to help shape the product that you might be using in the future. … Continue reading →

Posted in Testing | Tagged , | Leave a comment

Fun With SET Based Operations 2

Posted on November 23, 2010 by Phil

Okay, now for a little more fun with SET based operations. This is a quick post that will show you how to combine multiple rows for 1 column, into a 1 row, 1 column, as a comma delimited list. It’s … Continue reading →

Posted in T-SQL Code Examples | Tagged , | Leave a comment

Fun With Set Based Operations

Posted on November 22, 2010 by Phil

Ok, maybe the title is a little misleading, perhaps fun is not quite the right word, perhaps it’s better to say ‘Something Interesting About Set Based Operations’, but it just doesn’t seem that catchy. You’ve probably worked with variables before, … Continue reading →

Posted in T-SQL Code Examples | Tagged , , | Leave a comment