Tag Archives: SQL Server 2011

When I Drop a Database, Why Does 1 Or More Files Still Exist?

Posted on February 17, 2011 by Phil

This is a quick post about an issue we have encountered a couple of times when drop a database and one or more files appear to be left over for some time afterwards. This time, we found the culprit! Essentially, … Continue reading →

Posted in SQL Server Issues | Tagged , , , , , | Leave a comment

SQL Server 2011 on a Windows 2008 R2 Core Server

Posted on January 28, 2011 by Phil

I have to admit, I had a little trouble with the title here, everything I wanted to use as the title just seemed a little bit too long; and to be honest, I think that one I settled on may … Continue reading →

Posted in SQL Server 2011 "Denali" | Tagged , , , | 1 Comment

Changes To Exception Handling In SQL Server 2011

Posted on January 19, 2011 by Phil

When SQL Server 2005 was released, we saw the introduction of structured exception handling using BEGIN TRY, BEGIN CATCH statements. This fantastic feature allowed us to trap and handle exceptions that we may encounter in the course of our code … Continue reading →

Posted in SQL Server 2011 "Denali", T-SQL Code Examples | Tagged , , , | 3 Comments

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