Tag Archives: security

Half Baked Features

Posted on May 17, 2016 by way0utwest

I gave a talk recently on some of the data protection features being added in SQL Server 2016, along with a few that have been available for some time. I think the talk went well, but I point out lots … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Half Baked Features

The Proliferation of Roles

Posted on May 13, 2016 by way0utwest

The best practice guidance for SQL Server security is to use roles for permissions, instead of granting rights to users. I’ve always followed this guidance in my career. I’ve learned that if one person needs access, sooner or later someone … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Proliferation of Roles

Am I a sysadmin?–#SQLNewBlogger

Posted on April 28, 2016 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was doing some security testing and wondered if I was a sysadmin. There are a few ways to … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Am I a sysadmin?–#SQLNewBlogger

The Pen Test

Posted on April 25, 2016 by way0utwest

We need something like the Air Force project seeking network vulnerabilities for our database systems. While there are tools that can help from the outside, but we need SQL Server specific tools. Why don’t we have a Best Practices Analyzer for … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Pen Test