|
A current issue regarding SQL Server 2008 R2, if you change a user's name in AD SQL Server still returns the old name via SYSTEM_USER.
We have a bunch of stored procedures that return SYSTEM_USER to identify who is running processes and confirm their permissions.
There are some solutions including bouncing the server(not possible currently) and installing patches(sysadmin won't currently allow) and others that I have tried and intermittently work.
So now the database table holding permissions, for actions users can perform, contains the person's old and current names to get around this SQL Server feature bug.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
|
Top marks for being mister memory 2015 
It worked the first time the user changed their name. Then for some reason, known only to the the Gods of the darkest and deepest recesses of Hades, the personnel department forced us to change the name back and that's when it did not work 
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
A lesson on how consultants can make a difference in an organization.
Last week, we took some friends to a new restaurant, ' Steve’s Place,' and noticed that the waiter who took our order carried a spoon in his shirt pocket.
It seemed a little strange. When the busboy brought our water and utensils, I observed that he also had a spoon in his shirt pocket.
Then I looked around and saw that all the staff had spoons in their pockets. When the waiter came back to serve our soup I inquired, 'Why the spoon?'
'Well, 'he explained, 'the restaurant's owner hired Andersen Consulting to revamp all of our processes. After several months of analysis, they concluded that the spoon was the most frequently dropped utensil. It represents a drop frequency of approximately 3 spoons per table per hour.
If our personnel are better prepared, we can reduce the number of trips back to the kitchen and save 15 man-hours per shift.'
As luck would have it, I dropped my spoon and he replaced it with his spare. 'I'll get another spoon next time I go to the kitchen instead of making an extra trip to get it right now.' I was impressed.
I also noticed that there was a string hanging out of the waiter's fly.
Looking around, I saw that all of the waiters had the same string hanging from their flies. So, before he walked off, I asked the waiter, 'Excuse me, but can you tell me why you have that string right there?'
'Oh, certainly!' Then he lowered his voice. 'Not everyone is so observant. That consulting firm I mentioned also learned that we can save time in the restroom.
By tying this string to the tip of our you-know-what, we can pull it out without touching it and eliminate the need to wash our hands, shortening the time spent in the restroom by 76.39%. '
I asked quietly, 'After you get it out, how do you put it back?'
'Well,' he whispered, 'I don't know about the others, but I use the spoon.'
|
|
|
|
|
|
I and Supriti married on 30th Jan 2015 at Kolkata is there any CP member who change his relationship status within last 15 days...
Life is all about share and care...
public class Life : ICareable,IShareable
{
// implements yours...
}
|
|
|
|
|
Suvabrata Roy wrote: I and Supriti married on 30th Jan 2015 at Kolkata <layer>is there any CP member who change his relationship status within last 15 days...
was it by fluke that i also changed by facebook relationship status on that same date?
|
|
|
|
|
its a coincident... whatever congrts buddy have a great future with your loved one...
Life is all about share and care...
public class Life : ICareable,IShareable
{
// implements yours...
}
|
|
|
|
|
Suvabrata Roy wrote: I and Supriti married on 30th Jan 2015 at Kolkata is there any CP member who change his relationship status within last 15 days...
Nope, but that was my son's 18th birthday.
Michael Martin
Australia
"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
|
|
|
|
|
Congratulation... and belated happy birthday to your son 
Life is all about share and care...
public class Life : ICareable,IShareable
{
// implements yours...
}
|
|
|
|
|
Congrats buddy... ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Now you need to inherit the ICareable and IShareable interfaces really  Otherwise you will be forced to inherit IRepentable 
All the very best for your married life!!!
|
|
|
|
|
Thank you Dinesh I will remember your words
I care of my wife...
Life is all about share and care...
public class Life : ICareable,IShareable
{
// implements yours...
}
|
|
|
|
|
Congratulations to you and your wife !
«I'm asked why doesn't C# implement feature X all the time. The answer's always the same: because no one ever designed, specified, implemented, tested, documented, shipped that feature. All six of those things are necessary to make a feature happen. They all cost huge amounts of time, effort and money.» Eric Lippert, Microsoft, 2009
|
|
|
|
|
Thank you sir...
Life is all about share and care...
public class Life : ICareable,IShareable
{
// implements yours...
}
|
|
|
|
|
Recently I embarked on a mission to find a new place to rent...Tenancy application for the new place require me to hand out so much personal information it really makes me feel insecure...on the other hand I have no choice but to give these info or else I cannot get a new place to stay...
What they are asking for ?
Passport
Driving License
Pay Slips
Current and previous rental address
Current and previous employer details
Medicare card
Current utility bill
Bank statement
How hard it is for someone to use all those documents I just gave to agent to use for some sinister purpose like taking out a new shiny credit card on my name.. ?
My father-in-law did not ask for such level of details before marrying his daughter to me !!!
What would you do in such situation ? Makes me wonder do they really need all those info to identify me as a genuine renter ? 
Zen and the art of software maintenance : rm -rf *
Maths is like love : a simple idea but it can get complicated.
|
|
|
|
|
Is your future landlord some big rental company? If yes, you are kind of OK - they tend to require way too much paperwork, but it is relatively unlikely for them to abuse your personal information.
|
|
|
|
|
My problem is that paperwork goes to property owner before he/she says OK... and how reliable the ghost of property owner whom you don't see/meet/hear ?
We talk about privacy on the internet but this is literally abuse of the power given to rental agents to get as much info from you as possible in a physical form...
Zen and the art of software maintenance : rm -rf *
Maths is like love : a simple idea but it can get complicated.
|
|
|
|
|
As an owner in Oz, I don't see the paperwork, I am informed of the details but never see the doco. I resides with the agency. I am however appalled at the detail I am supplied by some agencies. Job details, bank holdings and current salary, feels intrusive even from this side.
However I do agree with the level of vetting an agency does, 1 crappy tenant and you can lose a major part of your capital.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
F'em
They can't assume you have a passport or Medicare card.
They are not allowed to ask for a Driving License (in the U.S.).
|
|
|
|
|
Pay slips or bank statement I can understand... They want to make sure you can afford the rent. Just redact any account numbers.
Addresses make sense... They want to check with your previous landlord to make sure you're alright... Well, current address makes sense... Previous is a bit much.
Passport/license is just so they can make sure you are who you say you are. I assume they just need "Governmnet-issued photo ID" of some sort, not both of those.
As for medicare... That's just none of their business, and depending on where you are, I wonder if it might even violate some discrimination law to even request it...
So I can see how SOME of that is justified, but ALL of it? Bit overboard... I'd steer clear. Might be phishy, if you catch my meaning...
|
|
|
|
|
Medicare is justified if you are a welfare recipient or retired. Again, it all goes to the ability to afford the rent (gross income less medical expenses, etc.).
Previous address is necessary if you happen to move alot. I'm surprised they don't require a drugs test. Landlords here in NZ have been experiencing problems with P users and drug labs.
The difficult may take time, the impossible a little longer.
|
|
|
|
|
Think that's bad wait till you apply for a mortgage. 
Hold my drink and watch this.
|
|
|
|
|
This would also make me nervous. One reason is that despite the assurances they may give the secure storage of the information cannot be guaranteed. It seems however (at least in Western Australia) they are fully entitled by law to do this. http://www.commerce.wa.gov.au/sites/default/files/atoms/files/rentapplicationform18.pdf[^]
Peter Wasser
"The whole problem with the world is that fools and fanatics are always so certain of themselves, and wiser people so full of doubts." - Bertrand Russell
|
|
|
|
|
I am lending an apartment and demand about that much of paperwork to my tenants. It is not to be inquisitive : it is what information is needed when you want to sue someone - to get back the money they own you if they don't pay you the loan. Of course, these documents are easier to get right from the start - you obviously do not get them once you are already in conflict - that is why they are requested when you rent.
|
|
|
|
|
Way to start a healthy relationship with someone.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
