Tag Archives: security

Changing the Default DB for a Login–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I got into a bit of a pickle. I was detaching some databases for a demo, which is … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

A Tour of SQL Server Security Features

Abstract Protecting data from unauthorized access becomes more important all the time. SQL Server includes a number of features that make data protection and security easier for developers and DBAs with a framework for protecting data. Come learn how Always … Continue reading

Posted in Presentations | Tagged , , , , | Leave a comment

The Blame Game

Make no mistake, this is going to be something that happens again. The former CEO of Equifax blames their massive data breach on a bad scanner and a person. I’m not talking about a data breach, of course those are going … Continue reading

Posted in Editorial | Tagged | 3 Comments

Enabling Database Containment for an Instance – #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it. I wanted to … Continue reading

Posted in Blog | Tagged , , , , | Leave a comment

The Problems with Gods

When I was learning how to work with computers early in life, I ran across various documentation and writings that would liken the root account to being a god on the system. Over the years, I’ve seen other articles that … Continue reading

Posted in Editorial | Tagged , | Leave a comment

A SQL Server Bug and Data Security

This week I saw a post from Microsoft Tiger Team on the issues with backup compression and TDE databases. Apparently when they added compression, they didn’t test a few edge cases. Or a few regular cases, like WITH INIT. There … Continue reading

Posted in Editorial | Tagged | Leave a comment

A SQL Server Bug and Data Security

This week I saw a post from Microsoft Tiger Team on the issues with backup compression and TDE databases. Apparently when they added compression, they didn’t test a few edge cases. Or a few regular cases, like WITH INIT. There … Continue reading

Posted in Editorial | Tagged , | Leave a comment

A Data ID

It sounds good. A universal ID that can be used for your identifiable data, in case you happen to lose your paperwork. Paperwork? When will that term become lost to history? These days, less and less of anything is available … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Auto DevOps

As much as I like DevOps, this scares me. There are a lot of employees (20%) at BMW that are software engineers. They want to increase that to a larger percentage, which I assume means that we’ll have more and more … Continue reading

Posted in Editorial | Tagged ,

Advancing Security

One of the topics that is very important to many technology professionals is security. Security also might be one of the least understood aspects of our jobs. It’s an area that requires regular learning, monitoring, reactions, and vigilance. A healthy dose … Continue reading

Posted in Editorial | Tagged