Monthly Archives: February 2016

Excel formatting SQL results

Posted on February 25, 2016 by martincroft

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

Posted on February 24, 2016 by martincroft

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)

Posted on February 24, 2016 by martincroft

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

Posted on February 24, 2016 by martincroft

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

Posted on February 11, 2016 by martincroft

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