Author: Robert Virag

SQL Server Service Engineer at IT Services Hungary, Member of T-Systems; MCITP: Database Administrator 2008; former MCT

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

Robert Virag
SQL Server Security Ponderings – Part 2 | Database owner + TRUSTWORTHY
2.5 (50%) 4 vote[s]

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

Robert Virag
SQL Server Security Ponderings – Part 1 | DMI – Bobby Returns
4.3 (86.67%) 6 vote[s]

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.

Read More