September 30, 2019 at 5:44 pm
Just FYI, there are some good third parties selling keys for much less, and then more and more locksmiths are avaialble to program. Often reduces that dealer $350 to something more-though-still-outrageously reasonable like $150.
My local hardware store makes the "key fob" type keys for $35. I had a third one made for my Subaru Outback. They do not do the keyless thingies yet.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
September 30, 2019 at 6:44 pm
Just FYI, there are some good third parties selling keys for much less, and then more and more locksmiths are avaialble to program. Often reduces that dealer $350 to something more-though-still-outrageously reasonable like $150.
I wouldn't pay anything like $150 for keys, neither in Britain nor in Spain. That goes for house keys (various doors and safe cupboards) and for car keys.
I had one bad "lost" key event earlier this year. The keys for my Spanish house were in a key holder in my jacket pocket. I had dinner in a restaurant that I visit quite often, and when i sat down i hung my jacket on the back of my chair. After eating I drank some more wine, and then (at about 11;00pm) went off to a bar that was half way between that restaurant and my house because (a) I wanted to hear some Irish music, which would be going strong in that bar until about 2 am, and (b) I get a discount on the price of wine as someone who sang along with that bar's lead singer in its early years as an Irish bar (and I had been the only singer who sang Irish songs in Irish during the first year or two) - but I had a plane to catch (to get back to the UK) the next morning so I left there at about 12:30 at which pont I noticed that I didn't have my jacket. So I hurried back down to the restaurant in the harbour, but of course it was shut and no-one was there. Doom and disaster - imposible to get into my house, so impossible to take my flight (passport locked securely in a safe in my securely locked house, also my boarding pass). Then wonderful luck: next door but one to the restaurant (in another restaurant) there were people (who worked there, maybe the owners there) who knew both the owners of the restaurant I had been at and me, and they came to find out way I was trying to contact a restaurant that had been shut for two hours. Once I told them my problem, they rang the people who could fix it, and fairly quickly two people from the resaturant turned up with keys, opened up the restaurant to get my jacket from the secure area in which it had been placed when they realised I wan't going to be back before they went home, and then they insisted on giving me a lift home so that I would be able to get decent amount of sleep before having to set out for the airport.
That the Spanish population of Lanzarote have seemed to me mostly to act like that is probably why I Iiked it enough to go house-hunting there when I wanted to find somewhere with a decent winter climate for my wife way back 20 years go. It took us about 5 years to find a place we wanted to buy (and that was couple of mile from the area we originally aimed at) but when I retired after another 5 years) it became our main home, with our British house definitely second not first.
It's rather sad that if our American prime minister (Boris Johnson is American, but he renounced his American citizenship and took up British citizenship as part of a clever tax evasion excercise so now he claims to be English - no Scot or Welsh or Irish person would imaginable call him British) is now doing his best to wreck the British economy in order to maximise (as reported by his sister) the profits that his friends (and preumably himself) will make from betting that the pound will go down because the British economy will inevitably crash when his desired no-deal Brexit takes place; the US Congress has already declared that it will actively prevent any trade deals with the UK unless there is a Brexit deal that adequately covers the Irish borders issue, and it's clear that Jobnson has nothing even remotely viable to suggest about that issue.
Tom
October 1, 2019 at 7:15 am
This reply has been reported for inappropriate content.
Keep updating news.
>>> ufa
October 1, 2019 at 11:33 am
Realise that the site is disliked by many (I agree that the community isn't as robust as it is here, or as well knit with many of you having meets at conferences and socially), however, anyone seen the "mass" resignation of moderators on the SE Network?
It seems that SE have a Code of Conduct change coming, which many of the moderators had concerns over. One moderator as a result of them disagreeing with the changes therefore had their permissions revoked. This has now led to another 20 mods resigning (or suspending) their activities on the network.
No one so far has stated specifically what the new Code is, but it does bode a question about what direction SE is trying to go now.
I do find SE a valuable resource, and as network for asking questions not related to SQL Server I do find myself on there often (especially Ask Ubuntu). If, however, that many mods are resigning based purely on the new CoC, and the actions that SE have already taken against their own volunteer(s) that constructively disagree with it (the CoC), then that does bode poorly on them in my view.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 1, 2019 at 3:47 pm
Whoa! That sure reads like a bit of a mess. I hope they can straighten it out. I can't say I'm a fan of SE, but I'm not actively opposed to them either.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 1, 2019 at 5:09 pm
Ouch. Don't use SE (not even signed up,) but that sounds like a bad show all around from reading the postings about it...
October 1, 2019 at 5:19 pm
Always hard when business interferes with the operation of things. I have no idea what happened, but likely it's humans behaving badly and being supported because it's good for business (or someone thinks it is).
I like SO/SE for many things, and I've found it to be great. Discussion is not one of these, but answering simple questions is fantastic there.
October 1, 2019 at 5:45 pm
I like SO/SE for many things, and I've found it to be great. Discussion is not one of these, but answering simple questions is fantastic there.
Heh..... when I've found answers on SO/SE they often end up buried deep in comments and have little to do with the original posted question.
October 1, 2019 at 6:13 pm
It seems that SE have a Code of Conduct change coming, which many of the moderators had concerns over. One moderator as a result of them disagreeing with the changes therefore had their permissions revoked. This has now led to another 20 mods resigning (or suspending) their activities on the network.
Wow, that does sound like a hot mess. I'm not active on SE or SO, so I only checked it out to see exactly what was going on over there. I was surprised to find that the fired moderator was one of my best friends in college.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
October 1, 2019 at 6:30 pm
SE = Stack Exchange?
SO = Stack Overflow?
412-977-3526 call/text
October 1, 2019 at 7:28 pm
SE = Stack Exchange?
SO = Stack Overflow?
Yep. Stack Overflow is just one site within the Stack Exchange Community. I think they have well over 100 now.
I like SO/SE for many things, and I've found it to be great. Discussion is not one of these, but answering simple questions is fantastic there.
I am far more active on SO now than I used to be be when I first signed up. I think it took me 4 years to actually start participating due to unwelcoming and unfriendly design it had back then. It's a lot better than it was now though, and I have used it as a great way to improve my "skills".
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 1, 2019 at 8:06 pm
Robert Sterbal wrote:SE = Stack Exchange?
SO = Stack Overflow?
Yep. Stack Overflow is just one site within the Stack Exchange Community. I think they have well over 100 now.
Steve Jones - SSC Editor wrote:I like SO/SE for many things, and I've found it to be great. Discussion is not one of these, but answering simple questions is fantastic there.
I am far more active on SO now than I used to be be when I first signed up. I think it took me 4 years to actually start participating due to unwelcoming and unfriendly design it had back then. It's a lot better than it was now though, and I have used it as a great way to improve my "skills".
Yeah I am in the same boat. They improved things quite a bit around the same time the traffic around here dropped significantly. Funny how often you and I talk over there as well. 🙂 Not too many of the good guys around there.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 2, 2019 at 8:09 am
Yeah I am in the same boat. They improved things quite a bit around the same time the traffic around here dropped significantly. Funny how often you and I talk over there as well. 🙂 Not too many of the good guys around there.
By "talk" do you mean citing Aaron Bertrand's "bad habit" articles? ??
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 2, 2019 at 1:40 pm
Sean Lange wrote:Yeah I am in the same boat. They improved things quite a bit around the same time the traffic around here dropped significantly. Funny how often you and I talk over there as well. 🙂 Not too many of the good guys around there.
By "talk" do you mean citing Aaron Bertrand's "bad habit" articles? ??
LOL pretty much. It really is shocking how many people still use varchar for dates and sql injection.....
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 64,021 through 64,035 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply