How to move the Master database

The catch to moving the Master database is that you must also move the Resource database.  Microsoft states that the...

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

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

Meme Monday – Horoscope

Did you know that your sign may have changed?  I didn’t – at least not until reading the meme Monday announcement....

Meme Monday – Horoscope

Did you know that your sign may have changed?  I didn’t – at least not until reading the meme Monday announcement.  Most people probably will see no difference in...

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

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

Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac

Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Chinese Zodiac Figures by Joe Ledbetter

It’s time for July’s Meme Monday post, and...

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

Select random records using TABLESAMPLE clause

While I was reading Martin Catherall’s post about Selecting from a table with no rows returned I remembered TABLESAMPLE function...