Tag Archives: sql server

Create a Database Master Key–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the first things you need in a SQL Server database in order to implement encryption is a … Continue reading

Posted in Blog | Tagged , , , , | Comments Off on Create a Database Master Key–#SQLNewBlogger

SQL Server 2016: The Data Protection Version

I’ve spent a few years working with SQL Server encryption and security, trying to educate people on the various capabilities involved. There are some nice features available in the platform that can help you run a more secure SQL Server, … Continue reading

Posted in Editorial | Tagged , , | Comments Off on SQL Server 2016: The Data Protection Version

Should Production Databases Be in a VCS?

There was a great discussion recently on my true version of code editorial. It was interesting to see how some people viewed the idea of a version control system as the source of code, while others truly see the production SQL … Continue reading

Posted in Editorial | Tagged , | Comments Off on Should Production Databases Be in a VCS?

Zero Downtime for 2016

I’ve never felt that zero downtime is possible for a system over any length of time. There are no shortage of companies that seek to prove me wrong, and some are doing very well. For example, when is the last … Continue reading

Posted in Editorial | Tagged , | Comments Off on Zero Downtime for 2016