Viewing 15 posts - 12,721 through 12,735 (of 39,963 total)
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...
March 22, 2013 at 6:17 pm
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....
March 22, 2013 at 10:55 am
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...
March 22, 2013 at 10:42 am
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...
March 22, 2013 at 10:13 am
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...
March 22, 2013 at 10:08 am
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...
March 22, 2013 at 10:07 am
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
March 22, 2013 at 10:06 am
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.
March 22, 2013 at 10:05 am
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...
March 22, 2013 at 10:05 am
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...
March 22, 2013 at 9:46 am
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...
March 21, 2013 at 9:23 am
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.
March 21, 2013 at 9:04 am
Sorry, this should be fixed.
March 21, 2013 at 8:49 am
In a practical sense, it doesn't matter if it's cat videos or anything else. We still need to manage the data, which means work for us in the data business....
March 21, 2013 at 8:45 am
WayneS (3/20/2013)
Can you tell what days Steve featured one of my blog posts in the newsletter? Thanks Steve!
You are welcome. But it's not just me, some of the excitement is...
March 21, 2013 at 8:42 am
Viewing 15 posts - 12,721 through 12,735 (of 39,963 total)