2012 review: the year by the numbers

The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down the numbers that have been my life this year. 8081324 (roughly): the number of page views across my blog (up almost 10% from 2011) according to Google, from 141 countries (same as last […]

2012: the year in books

Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011) and people have been enjoying it, so I present the 2012 end-of-year post. I set a moderate goal of 60 books this year and I managed 59. Next year we […]

Importance of how often you take full backups

A couple of weeks ago I kicked off a survey asking how often you perform full backups of your databases. Here are the results: The ‘Other’ values are: 20 x ‘Daily for small dbs, weekly (with daily diff) for large dbs.’ 16 x ‘Depends. Some daily, some weekly.’ 5 x ‘Daily on small, weekly on […]

Importance of where you store your backups

A couple of weeks ago I kicked off a survey about where you store your backups. Here are the results: The’Other’ responses are: 8 x ‘Stored on same SAN, different LUN as databases, with off-site copies.’ 6 x ‘Copy 1 stored on same SAN (1-2 days) for quick restore in non-physical disaster. Copy 2 stored […]

Survey: how often do you perform a full backup?

In this survey, I'm interested in how often you perform a full database backup of your production databases. I'll editorialize the results in a week or two. Thanks!

SQLskills holiday gift to you: all 2011 Insider videos on YouTube

As we approach the 2012 holiday season, we want to give the SQL Server community a holiday gift to say ‘thank you’ for all your support during 2012, and what better gift than more free content?! As many of you know, I publish a bi-weekly newsletter than contains an editorial on a SQL Server topic, […]

Survey: where do you store your database backups?

In this survey I'd like to know where you store your SQL Server backups. If a disaster occurs, where do you get them from? It doesn't matter what method you use to create the backups (native SQL Server, 3rd-party backup solution, DPM) but we're talking about database backups here, not OS-level backups. I'll report on […]