Monthly Archives: December 2016

My 2016 by the Numbers

Posted on December 30, 2016 by

This is it, the last work day of the year. I wrote about my look back from the data side of the world, but I also wanted to take a look back at my personal 2016 from the work perspective. … Continue reading →

Posted in Blog | Tagged ,

What Will 2017 Bring?

Posted on December 30, 2016 by

What do you think will happen in the database world in 2017? That’s a question I want to ask you today, the last work day of 2016. When most of us come back to work next week, a new year … Continue reading →

Posted in Editorial | Tagged

Checking Permissions for Keys–#SQLNewBlogger

Posted on December 29, 2016 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I got a call from someone wanted to check how permissions were stored for encryption objects. I ran a … Continue reading →

Posted in Blog | Tagged , ,

Looking Back at 2016

Posted on December 29, 2016 by

We’re coming to the end of a crazy year. 2016 has seemed to be one of the craziest of my life with world events like Brexit and the US election as well as an astounding number of data breaches. More … Continue reading →

Posted in Editorial | Tagged | 1 Comment

Post TDE–Getting Unencrypted Backups

Posted on December 28, 2016 by

I saw a question posted recently about someone that had disabled TDE and was still having issues restoring a backup. This doesn’t seem like that should be an issue, but it can be. A little testing shows how. Let’s assume … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Back After the Break

Posted on December 27, 2016 by

Refreshed and back to work today. After a week at Redgate Software for SQL in the City, I took a week to travel in Ireland with my family. In that time, I really ignored almost all email and didn’t manage … Continue reading →

Posted in Blog | Tagged

Syntactic Sugar

Posted on December 27, 2016 by

There are all sort of features and enhancements that Microsoft can make to the SQL Server platform. If you look around Connect, you’ll see suggestions for improvements, such adding common checks, as well as additions like adding virtual tables. I’m … Continue reading →

Posted in Editorial | Tagged ,

New Formatting in #SQLPrompt

Posted on December 27, 2016 by

I love SQL Prompt. This might be my favorite tool from Redgate Software and just when I thought it couldn’t be any better, a new formatting engine has been released. Reading through existing source code and understanding the intent is … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Administrative Native and ConEmu Command Prompts–#SQLNewBlogger

Posted on December 26, 2016 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I would think many people know how to do this, but I’ve run into a few, so here you … Continue reading →

Posted in Blog | Tagged ,

Data Preservation

Posted on December 26, 2016 by

This editorial was originally published on Dec 3, 2013. It is being re-run as Steve is on holiday. Maintaining data across time isn’t something many of us think about. We work with data in the here and now, and in … Continue reading →

Posted in Editorial | Tagged