SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: December 2013

Slimming down The Voice of the DBA Podcasts

I announced in the Christmas editorial that I was discontinuing the video podcasts. Needless to say I heard a complaint from my Mom that afternoon. She enjoys the podcasts, even though she doesn’t understand all the technology. I did get a couple other notes from people and thought I should… Read more

2 comments, 1,407 reads

Posted in The Voice of the DBA on 31 December 2013

The Effective Cell Phone

I’ve written a bit about phones recently as I’ve experienced the switch back to iOS from Android. There are a few other posts in this series:

I wanted to stop and take a moment and think about design… Read more

0 comments, 843 reads

Posted in The Voice of the DBA on 27 December 2013

Quick SQL Prompt Tip – SSF

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into a few people that weren’t aware of some of… Read more

8 comments, 2,088 reads

Posted in The Voice of the DBA on 23 December 2013

Android is better than iOS

Not in many ways, and certainly not in enough for me to stick with Android over iOS, but here are a few things I do think.

If you’re slightly lost, I’ve written on Android v iOS after moving to a G4, my move back to iOS, and why I left.… Read more

0 comments, 1,117 reads

Posted in The Voice of the DBA on 20 December 2013

Powershell in a Month – Day 6 The Pipeline

This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones.

Day 6. This is where I found the idea of Powershell getting interested. I used pipes extensively back in my Unix… Read more

1 comments, 2,366 reads

Posted in The Voice of the DBA on 19 December 2013

Traveling in 2013

It was a busy year for me. As I look back at my speaking CV for 2013, here’s what I see:

Read more

0 comments, 803 reads

Posted in The Voice of the DBA on 18 December 2013

Powershell in a Month– Day 4 and 5 – Providers

This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones.

Day 4, and 5. This wasn’t a long chapter, but it came right around travel and vacation, and as a result,… Read more

1 comments, 1,131 reads

Posted in The Voice of the DBA on 17 December 2013

Symmetric Keys

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 also use a key to decrypt data.

The key used… Read more

2 comments, 2,895 reads

Posted in The Voice of the DBA on 16 December 2013

Android Annoyances

I wrote last week that I had switched back from Android to iOS, but I didn’t list out specific gripes or issues I had. This post looks at some of my complaints with Android, and specifically the S4. I’ve also included a few things that I think I’ll miss, or… Read more

3 comments, 885 reads

Posted in The Voice of the DBA on 13 December 2013

A Full Backup Includes Everything (with a caveat)

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” means committed in a transaction.

If someone tells you the… Read more

0 comments, 792 reads

Posted in The Voice of the DBA on 11 December 2013

Back to iOS from Android

I pre-ordered a Samsung Galaxy S4 last spring, after listening to my wife talk about how much happier she was with an S3 than an iPhone 4. There were a few things I thought Android was doing better for smartphones and after spending some time in the store with various… Read more

5 comments, 583 reads

Posted in The Voice of the DBA on 9 December 2013

SQL in the City and SQL Saturday–Washington DC

Actually, Maryland, but close enough. I’ll be in Chevy Chase this weekend, first for our SQL in the City Seminar on Deployment Friday, and then SQL Saturday #233 on Saturday. Both events are free, so if you can come to one or both this weekend, register and come. The registration… Read more

0 comments, 689 reads

Posted in The Voice of the DBA on 3 December 2013

Accidently Kicking a Database into the Restoring State

I learn new things all the time. This was one that actually stunned me. Huge props to Gail Shaw for posting a note about this in a thread.

Run this code:

CREATE DATABASE MyRestoreTest ; GO USE MyRestoreTest go BACKUP DATABASE MyRestoreTest TO DISK ='myrestoretest.bak';…

Read more

10 comments, 2,365 reads

Posted in The Voice of the DBA on 2 December 2013