Tag Archives: sql server

Learning from Microsoft

I know that many data professionals out there are skeptical of the cloud. Certainly there are problems with reliability, security, and more that prevent many of you from migrating to some online database. However that doesn’t mean that everything being … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Learning from Microsoft

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?