Monthly Archives: November 2013

What is SQL Server not good at?

I was reading a post that had this quote: ” The MongoDB docs tell you what it’s good at, without emphasizing what it’s not good at. ” This isn’t to pick on MongoDB, but the post did make me wonder what SQL … Continue reading

Posted in Editorial | Tagged | Comments Off on What is SQL Server not good at?

Backups and Consistency

I wrote about transactional consistency recently. Why do we need this? Imagine that I have an orders table and an ordersdetail table in my database. The orders table has the order header (date, customer, etc) and the detail table includes … Continue reading

Posted in Blog | Tagged , , | 1 Comment

It Starts with Version Control

As a software developer, I learned about the value of version control over time. My first forays into development were as a child, where I made a single backup of my code on a separate floppy disk in the event I had … Continue reading

Posted in Editorial | Tagged , , , | Comments Off on It Starts with Version Control

Testing Skills

This editorial was originally published on May 11, 2009. It is being re-run as Steve is on vacation. How can you measure someone’s skills? Is there a good way to actually assess how well a DBA or developer will do … Continue reading

Posted in Editorial | Tagged , | Comments Off on Testing Skills