Tag Archives: sql server

SQL Server Backups – When is it current?

Posted on September 1, 2011 by way0utwest

I saw a post recently where someone was asking about the restore sequence for a series of backups. The scenario was this: Full backup starts at 3:00am, and takes 30 minutes Log backup 1 starts at 3:05am, and takes 2 … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on SQL Server Backups – When is it current?

Computed Columns and UDFs

Posted on August 30, 2011 by way0utwest

I wrote about the basics of computed columns and also using CASE in a computed column recently, but there’s a better way to implement a computation, and reuse the code. You can include a UDF in a computed column. UDFs … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Computed Columns and UDFs

The Basic Security Model in SQL Server – Skill #3

Posted on August 29, 2011 by way0utwest

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011. Users and Objects The basic security model diagram that I use is the one below. … Continue reading →

Posted in Blog | Tagged , , , | 3 Comments

Create a Log Backup Schedule – #1 Skill You Need

Posted on August 25, 2011 by way0utwest

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011. You Need Log Backups By default databases in SQL Server are created with the Full … Continue reading →

Posted in Blog | Tagged , , , , , | Comments Off on Create a Log Backup Schedule – #1 Skill You Need