Monthly Archives: December 2013

Data Preservation

Maintaining data across time isn’t something many of us think about. We work with data in the here and now, and in the database world, we typically only need to recover or restore data from a short window. Like most … Continue reading

Posted in Editorial | Tagged | Comments Off on Data Preservation

SQL in the City and SQL Saturday–Washington DC

Actually, Maryland, but close enough. I’ll be in Chevy Chase this weekend, first for our SQL in the City Seminar on Deployment Friday, and then SQL Saturday #233 on Saturday. Both events are free, so if you can come to … Continue reading

Posted in Blog | Tagged , , , , | Comments Off on SQL in the City and SQL Saturday–Washington DC

Accidently Kicking a Database into the Restoring State

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?

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?