Tag Archives: linkedin

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

A Little Fun With DateTime

Posted on February 5, 2011 by Phil

A colleague asked me how to get the last day of the month for the current month using T-SQL. It’s an interesting problem, myself and another colleague both gave different answers to his question (which just goes to show that … Continue reading →

Posted in T-SQL Code Examples | 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

What I’ve Been Doing Lately

Posted on January 14, 2011 by Phil

We’ll it’s been a busy period of late and this the first time I’ve been able sit down and write a blog entry, Christmas has come and gone; and we’ve all welcomed in the new year with the hope that … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

ITunes Drives Me Nuts!!!

Posted on December 7, 2010 by Phil

ITunes drives me nuts sometimes, for example, I needed to bring my laptop into sync with the music on my IPod. I didn’t have another source available to me at the time, so I did some searching around and found … Continue reading →

Posted in Personal | Tagged , | Leave a comment

Bulk Scheduled Reporting Using SSRS

Posted on December 2, 2010 by Phil

We are migrating from Crystal Enterprise to SSRS, but we have found one major short coming in SSRS – you can’t bulk schedule reports, nor can you control how many reports can be executed at the same time. I know … Continue reading →

Posted in SQL Server 2008, SSRS | Tagged , | Leave a comment

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