I could do the snippet piece, but asking for parameters isn't a capability I have. It's not built in and not sure we could build it.

However I could had a...

I hadn't thought about the puddle. I'd hope the keys can withstand some brief immersion. I know I've dropped the Prius keys in the snow and it hasn't been a...

If you mean with the catch all query? I think it's as Gail mentioned, you don't necessarily get a good plan and can end up scanning the table or getting...

Are you saying you want a read only and a read/write role? Separate from db_Datereader/writer?

That's easy to script.

loop through all tables in all databases, grant rights to a standard named...

Talk to recruiters. They often find things others don't.

Add this to your LinkedIn profile. Lots of companies and recruiters start here.

Do some testing/experimenting with the platform and write about it....

You are right, I did. I was thinking row and misread that. I've seen RBAC mostly as row based, not role.

In terms of roles, there isn't a script to do...

If you are going to 2012, think about FileTable. In some ways the development is easier than Filestream.

The filters for blobs are based on the iFilter standard. You can purchase...

Answer John's question, and then go to BIGINT. I had to do this in a system doing scans of our nodes every hour. We ran out of INTs in about...

If no other processes are running, do you care? You want the server to use the resources it has, not skimp. CHECKDB isn't set to use 10% CPU regardless of...

SQL Server roles won't help here. Row based access means you're using joins to help accomplish this.

A couple links that might help:

http://technet.microsoft.com/en-us/library/cc966395.aspx

http://stackoverflow.com/questions/1122513/how-to-implement-database-access-control-on-row-basis

It wasn't fixed until SP2. That's how. Fixed won't be back ported to another fix. That's the reason the next fix comes out.

Mock up something with 10 colums and provide the DDL and some sample data (with inserts) . Show a result set.

We can try to help, but as Sean mentioned, not...

I don't like the idea of blackballing. We all screw up, we all get second chances in different parts of our lives.

I do like disclosure, and the idea of laying...

One more thing to keep in mind, you may have statistics on columns that are not in indexes. Make sure those are being updated. Your plan could potentially skip these...

Good point. Our IT staff used the best advice at the time, which was 1 per core. It's possible that we should reduce down to 4 files.