-
Vimperator: make your Firefox behaves like VI/VIM
I stumbled into this Firefox gem today: Vimperator. It makes your Firefox behaves like the venerable VI/VIM editor. Warning: if you are not a VI/VIM guy, don’t even try this. It will cause you grief. For VI/VIM aficionados like me, this is almost like the best thing since sliced bread, or, VI. A couple of…
-
Interesting findings on schema owner permissions
I found out recently that a schema owner does not necessarily have right to create objects for its own schema, but can drop and grant permissions for its objects, which is kind of strange. Try this: 1. Create 2 logins: USE [master] GO CREATE LOGIN [Login1] WITH PASSWORD=N’xxx’, DEFAULT_DATABASE=[AdventureWorks], CHECK_EXPIRATION=ON, CHECK_POLICY=ON CREATE LOGIN [Login2] WITH…
-
C2 and Common Criteria Compliance
In Sql Server 2000, C2 auditing is a US government standard that monitors database security. When it is enabled, a trace will be created to collect all Security Audit related events, 21 or so of them. You can find what those events are by browsing through them in Profiler. By default, the trace file will…
-
Seeking mobile communication advice
I am going through some changes, dear reader: I have decided to quit my corporate day job and start my own consulting/training business, starting on April 9th, 2007. I could use your help here: I’d appreciate it greatly if you could offer me leads on Sql Server, Oracle, and MySQL consulting and training gigs. I…
-
A few handy Sql Server tips
Here are a few handy tips I learned lately: 1. When using sp_configure, you don’t need to type the whole parameter string. You just need to type enough of it for Sql Server to be uniquely identify it. For example, sp_configure ‘show ad’ will resolve to sp_configure ‘show advanced’ 2. In Query Analyzer or Management…