Daily Archives: May 17, 2011

Checking Permissions

Someone posted this query recently: select a.*,name, b.* from sys.database_principals a, sys.database_permissions b where permission_name = ‘INSERT’ and b.grantee_principal_id = a.principal_id That’s a little ugly, so let’s fix it: SELECT  a.name, a.principal_id, a.is_fixed_role       , a.default_schema_name       , b.permission_name, b.permission_name … Continue reading

Posted in Blog | Tagged , , | Comments Off on Checking Permissions

Working Long or Working Hard

Seth Godin has some very interesting things to say and often makes me think with his short posts on the world. I saw him speak a few years ago, enjoyed it, and while I don’t always agree with the way … Continue reading

Posted in Editorial | Tagged | Comments Off on Working Long or Working Hard