Monthly Archives: May 2011

How To Make Your Laptop 100x Faster

Simon Sabin had his own take on increasing laptop speed. He had some good ideas, but he inspired me to try to top his suggestions. Here’s what I came up with: Anyone needing help, let me know. I can swing … Continue reading

Posted in Blog | Tagged , | 1 Comment

Stalking the Bad Guys

Suppose you found some malicious code on your system. Maybe it’s a login that didn’t below at the sysadmin level, or maybe a stored procedure that might disable a trigger, make a change, and re-enable the trigger. What do you … Continue reading

Posted in Editorial | Tagged | Comments Off on Stalking the Bad Guys

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