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

Upcoming Content Preview

It has been a few weeks since I last posted.  I know, I’m a slacker, thanks for pointing that out. ...

How to merge (combine) date intervals in T-SQL

On my current project, I am dealing with date intervals in T-SQL very heavily. I’ve hit interesting issue recently – how...

Showing slowest parts of SQL query

I’ve received interesting question/requirement few days ago:
“… When viewing a query plan graphically, we usually have to hunt for the...

Learning From the Mistakes of Other DBAs

I have been a judge for the Exceptional DBA of the Year Awards ever since its inception, and one of...

Free SQL Server 2008 R2 Business Intelligence Training Course

If you are new to Business Intelligence (BI) and learn best by watching videos and “playing”, then this course is...