Tag Archives: sql server

Memories of 2013

Posted on December 27, 2013 by way0utwest

the holiday season and are not too busy at work.  I hope most of you had a great year in 2013, and with that in mind, I wanted to ask you a simple question: What’s your best SQL Server memory … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

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)