Daily Archives: February 24, 2016

Sysadmin Shenanigans & Lying Error messages

One of the databases that is for DBA use was in restricted user mode , this allows only certain users access to the database, basically its sysadmin users , db_owner or db_creater access to the database. I wanted to create … Continue reading

Posted in TSQL | Tagged , , | Leave a comment

SQL Server Security ( Post 2)

Have you any issues? (re-post from http://blog.solutionsctrl.com/sql-security-part-2) Can you answer yes to all these questions:- • Do you have a defined security policy that tells you what are acceptable settings? • Have you and do you regularly check compliance against these? … Continue reading

Posted in SQL Security | Tagged , | 1 Comment

SQL Server Security Part 1

SQL Server Security Series on creating policy / checks and the locking down of you servers Continue reading

Posted in SQL Security | Tagged | Leave a comment