Tag Archives: sql server

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

Transactionally Consistent

What does this mean? I had someone ask me in a session recently, and I think I have a good explanation, but I thought this was worth a blog. Transactionally Consistent means that there is a snapshot of the database … Continue reading

Posted in Blog | Tagged , , | Comments Off on Transactionally Consistent

Project Hekaton

If you haven’t heard about Hekaton by now, you should think about reading up on it. There’s some information from TechNet, a keynote video, and more. Despite the ranting from Oracle’s Bob Evans in 2012 that this was “vaporware”, it’s coming in SQL Server … Continue reading

Posted in Editorial | Tagged , | Comments Off on Project Hekaton

Risky Backups

This editorial was originally published on Jan 13, 2009. It is being re-run as Steve is away at the SQL Intersection conference. The other day I was working in the forums at SQLServerCentral and saw a question about someone doing backups and … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Risky Backups