Robert Virag, Author at {coding}Sight

SQL Server Security Ponderings – Part 2 | Database owner + TRUSTWORTHY

May 5, 2017September 5, 2017 Robert Virag

SQL Server Security Ponderings – Part 2 | Database owner + TRUSTWORTHY

3.5 (70%) 2 votes

This article is the second one of the three articles devoted to a particular security configuration combination of database security.

In my previous article, I presented a scenario in which we were able to compromise data in a SQL Server database.

I would like to note that the knowledge of this configuration combination is critical. In this article, I am going to provide further information and reasons for the importance of this issue. Read More

SQL Server Security Ponderings – Part 1 | DMI – Bobby Returns

December 5, 2016June 14, 2017 Robert Virag

SQL Server Security Ponderings – Part 1 | DMI – Bobby Returns

4 (80%) 4 votes

Nowadays security and data privacy are in special focus. When I deliver a training, I always refer to a DBA as the “guardian of the data.” There are two aspects of being a guardian.

The first one is integrity. It includes tasks like checking database consistency, creating backups and in case of problems being prepared to fix the database by having well designed, comprehensive DR plan.