Meme Monday SQLstrology – Table Valued Zodiac Function

It’s Meme Monday time! Our topic is SQL Horoscopes, or more catchily, SQLStrology.
We’re going to have to figure out what astrological...

SQLSaturday Round Table at the PASS Summit (Early Reminder)

Once again this year we’ll be holding a meeting open to all SQLSaturday event leaders and key team members (and...

Subtle Errors When Using Dates-Part 1

I was reviewing some code recently that has been in production for a while and I saw something like this:
set...

Striping Backups in SQL Backup Pro

There are times you really do want to stripe backups across multiple files. If you have a short backup window,...

Meme Monday in July - PearlKnows All

It’s time for July’s Meme Monday, and below is my entry, Star date 07:11:11.  Started by Twitter|@SQLRockstar,  Thomas LaRock, today’s...

Can you delete from a view?

I have seen this question come up several times over the last few months. Can you delete from a view?...

July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft - Readying on "Hadoop"

July 21 Data Arch VC Meeting: Gaurav Aggarwal on Microsoft - Readying on "Hadoop"
Subject:Microsoft – Readying on “Hadoop”Start Time:Thursday, July 21, 2011...

The Dog Died, and The Cat's on the Roof

Despite the title, this is a serious blog entry, dedicated to all you pet lover's out there. Although, I seek to...

Denali’s Skeletons in the closet (and workaround), Part II

I continued to check SQL Server 2011 “Denali” for few things I dislike on 2008 R2 and tried to find...

Misleading Error 1475 While Setting Up Database Mirroring

Misleading Error 1475 While Setting Up Database Mirroring
Wrong Way -->

I was doing some practice work yesterday testing out some mirroring...