Tag Archives: sql server

It’s not the platform

Posted on December 26, 2013 by way0utwest

I agree with Brent. Actually, I’ve felt this way for years when I’ve been asked the SQL Server v Oracle question, or even earlier in my career when I was asked about Windows v Unix. The choice doesn’t matter that much … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on It’s not the platform

Symmetric Keys

Posted on December 16, 2013 by way0utwest

One of the encryption options in SQL Server is symmetric key encryption. This is the type of encryption most people think about when they consider encrypting data. In symmetric key encryption, we use a key to encrypt data, and then … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

A Full Backup Includes Everything (with a caveat)

Posted on December 11, 2013 by way0utwest

Full database backups in SQL Server include all of the data, objects, tables, rows, functions, stored procedures, etc. If something is in the database when the data reading portion of the backup concludes, it’s in there. Note that “in there” … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on A Full Backup Includes Everything (with a caveat)

The Future of Auditing

Posted on December 5, 2013 by way0utwest

I was reading Captain’s Share the other day and enjoying a quiet afternoon at home. It’s a science fiction book about one man’s journey in the future as a captain of a space freighter. It’s an interesting series from Nathan Lowell that … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on The Future of Auditing