Archive for September, 2012
I know a lot of folks were disappointed that we (POSSE) weren’t able to pull together in time for a SQL Saturday in Austin this year. We are shooting for a spring date and I’ll be posting more about that in the next couple of weeks.SQL In The City To The Rescue!
Red Gate Software, a sponsor last year for Austin’s SQL Saturday, are doing something different. They have done a few of these events in the UK but they are taking it on the road! They have six events planned for us here in the states. We are one of the first stops in the tour. On October 1st More >
SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood.
Let’s start with a technical recap of the three backup types for SQL Server.1. Full Database Backup
When you request a full backup, SQL Server dumps all the data pages from your database, metadata about how your database is stored on disk and finally enough of the transaction log to bring the database back into a consistent state. There are a few things you need to know about the full backup semantics. When you take a full backup it makes a few changes. Those changes More >