Tag Archives: sql server

Accidently Kicking a Database into the Restoring State

Posted on December 2, 2013 by way0utwest

I learn new things all the time. This was one that actually stunned me. Huge props to Gail Shaw for posting a note about this in a thread. Run this code: CREATE DATABASE MyRestoreTest ; GO USE MyRestoreTest go BACKUP … Continue reading →

Posted in Blog | Tagged , , | 13 Comments

Is Your Data Relational?

Posted on December 2, 2013 by way0utwest

When should you use MongoDB? I’ve asked that question a few times, and I haven’t gotten a good answer I understand. I’ve read about a few of the NoSQL, document databases, and I think they do have a place in … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Is Your Data Relational?

Checking Up on Developers

Posted on November 26, 2013 by way0utwest

This editorial was originally published on May 8, 2009. It is being re-run as Steve is on vacation. The other day I was reading Brad McGeHee’s post on duplicate indexes, and it struck a chord with me. That same issue … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Checking Up on Developers

Core T-SQL

Posted on November 22, 2013 by way0utwest

Often I find myself wondering about the minimum bar we expect people to clear to be competent in some field. Almost all fields are evolving these days as technology and new ideas are put into practice in medicine, art, construction, … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Core T-SQL