Monthly Archives: December 2016

My 2016 by the Numbers

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 , | Leave a comment

What Will 2017 Bring?

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 | Leave a comment

Checking Permissions for Keys–#SQLNewBlogger

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 , , | Leave a comment

Looking Back at 2016

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

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

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 | Leave a comment

Syntactic Sugar

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 , | Leave a comment

New Formatting in #SQLPrompt

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

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 , | Leave a comment

Data Preservation

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 | Leave a comment