Archives: December 2013
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
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
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
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
Day 6. This is where I found the idea of Powershell getting interested. I used pipes extensively back in my Unix… Read more
It was a busy year for me. As I look back at my speaking CV for 2013, here’s what I see:
- Richmond SQL Server User Group
- SQL in the City Seminar – Richmond,…
Day 4, and 5. This wasn’t a long chapter, but it came right around travel and vacation, and as a result,… Read more
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
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
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
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
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
Run this code:
CREATE DATABASE MyRestoreTest ; GO USE MyRestoreTest go BACKUP DATABASE MyRestoreTest TO DISK ='myrestoretest.bak';…