The Lounge is rated PG. If you're about to post something you wouldn't want your
kid sister to read then don't post it. No flame wars, no abusive conduct, no programming
questions and please don't post ads.
I've never ever worked anywhere where there has not been someone who given the choice I would not work with again. It's a job, you do your work, put up with the people you don't like, accept there are probably people there that don't like you a lot, and look forward to the weekends.
- Josh Gray.
Bundaberg Rum with beer (Coopers Sparkling Ale) chasers.
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible." - Mr.Prakash One Fine Saturday. 24/04/2004
Whiskey and Stones Ginger Wine is very useful in a hip flask for football matches, or when I'm watching my son at rugby practice; but I'm prepared to give rum and beer a go at some point.
I remember when on a football tour in east Germany that the local tipple was a bitter type beer, sweetened with coca-cola - served in litre 'steins'. Half bitter and half coke, who says the Germans have no sense of humour - I bet they went back to G&Ts the moment we left.
What was the question again?
"If you reward everyone, there will not be enough to go around, so you offer a reward to one in order to encourage everyone."
Mei Yaochen in the 'Doing Battle' section of Sun Tzu's: Art of War.
I personally prefer multiple schemata over multiple DBs.
You mean you want a logical partitioning of schemata (you and I are probably the only two people that know that that is the correct plural for schema, I bet ) but physically in one DB?
That makes sense, which is what I added to the Interacx schema designer. However, I also thought that starting with SQL 2005, there was support for that, but I can't remember how it's done, because I never used it! But I remember reading something about it.
That's definitely a useful feature, and I'm glad you asked, because I realize this would be useful for maintaining some logical information when mapping an XSD to a DB--think of using the XSD namespace as the DB schema name.
But you are bit more enamored than the average bear with XML et al aren't you Marc?
And the funny thing is, years ago when I first learned about XML, I thought "geez, what idiot would use this verbose format for data?"
But so is Microsoft, finally. Still, everything/everyone seems to be using XML, for better or worse.
Funny thing is, a client wants me to write an interface to a web service for traffic accident reports. The data payload is sent as a text file, yet the response is in XML! Totally weird, except that the accident report has hundreds of fields, and I guess the guys writing the web service were too lazy to come up with an XSD for it.
And I also figure it probably feeds into an ancient COBOL app, as the text file is highly structured, specifying the exact length of each field.
I use it to map permissions. Users are in groups, so, barring exceptions of course, users are allowed specific actions on a schema. Tres cool, non?
That's exactly how we're using them here... logical groupings of objects within a database for permissions and for ease of finding things during maintenance. It replaces an earlier convention that our developers used to prefix object names with the logical grouping. It's definitely making my job a bit easier on the databases where we've used it.
Oh, yeah. Permissions were a pain on SQL Server before they introduced schemas, especially for stored procedures. Now, using a combination of schemas and roles, I can zip through all but the most granular permissions requests.
Last Visit: 31-Dec-99 18:00 Last Update: 23-May-18 7:09