Tag Archives: sql server

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

How SQL Server Full Backups Work

I’m writing this in support of a few talks I give that talk about backups. This is how I see things and it’s based on things I’ve learned over time. Some of this comes from a great explanation on Technet … Continue reading

Posted in Blog | Tagged , , | Comments Off on How SQL Server Full Backups Work