Monthly Archives: February 2016

Excel formatting SQL results

Sometimes its the little things that get annoying like requesting some information from a DBA or a system admin at a remote site where you can’t run scripts but need someone to do it for you. Quick example you want … Continue reading

Posted in Productivity, TSQL | Leave a comment

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

All Change again

I’ve been playing with SilvrBack for writing some blogs for a consultancy that I am involved with, which you can see these here posts blog.solutionsctrl.com however I always intended to blog on my own website as well.  I decided I was a … Continue reading

Posted in Uncategorized | Leave a comment