SQL Server Security

Grant View Server State

Grant View Server State

There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without having these permissions there are a number of diagnostic queries that you cannot perform. Whilst one way to deal with this is to make users a member of the sysadmin group, it really doesn’t adhere […]

Yesterday I was hacked

Yesterday I was hacked

That’s right, for all my years in IT yesterday I was the victim of a vicious and deeply distressing incident. OK, a colleague changed my wallpaper while I was away from my laptop, so not a big deal – but it could have been. The act of locking ones desktop when you leave the keyboard […]