April 1, 2011 at 5:37 pm
GilaMonster (4/1/2011)
Roy Ernest (4/1/2011)
Today is a sad day for me personally and to add more pain to it I had a car accident. My body hurts badly. My car is just one yr old and now my poor car is damaged. The front left side of my car has to be replaced. 🙁Ouch. Hope not too bad.
Today seems to be the bad car day. Just got mine back from repair with news that the panelbeater (after accident last year) intentionally shorted out the ABS (the wires are twisted together, so not an accident). ABS hydraulic pump damaged as a result, not repairable, no replacement parts available. Mechanic's suggestion: Sell the car and buy a new one.
Nice... I've been through that kind of stuff myself and that was at a supposedly reputable big 3 dealer. It's also bloody well near impossible to prove it. About the only thing you can do is stop going there and tell others what happened. Even then you have to be careful... if they find out you're "spreading the word" and you don't have the proof, the boogers can actually sue you for slander and defamation and win!
It's really too bad that high velocity pork chops leave a vapor trail.:-P
--Jeff Moden
Change is inevitable... Change for the better is not.
April 1, 2011 at 6:03 pm
Jeff Moden (4/1/2011)
It's also bloody well near impossible to prove it. About the only thing you can do is stop going there and tell others what happened. Even then you have to be careful... if they find out you're "spreading the word" and you don't have the proof, the boogers can actually sue you for slander and defamation and win!
I don't live in the USA.
I'm taking the case to the insurance ombudsman. The panelbeater was selected by my insurance, I was required to take the car there, hence that route.
I can prove it, I have a report from the panelbeater claiming that the ABS light was due to faulty brake shoe and that they cannot repair it, that I must take the car to a Mazda service centre. I have a letter from the Mazda service centre stating that the brake shoe is fine and explaining the damage and the cause. I have a photo of two wires stripped of insulation and twisted together.
About the best I expect is the panelbeater getting removed from the insurer's list of approved centres, maybe stripped of their AA approved status, nothing more.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2011 at 6:51 pm
Stefan Krzywicki (4/1/2011)
LutzM (4/1/2011)
Stefan Krzywicki (4/1/2011)
Assuming the report isn't an April Fools joke, anyone get hit by the attack?I'd bet that many learn no lesson at all about clensing data when using dynamic SQL.
To quote from that site:
Early reports suggested that the attackers were hitting sites using Microsoft SQL Server 2003 and 2005 and it is thought that weaknesses in associated web application software are proving vulnerable.
I don't think there are too many people out there using SQL Server 2003... ;-):-)
Ha! Well that's true, but considering how often the media screws up that kind of information in articles about science and technology I don't think that's enough for it to be an April Fools story. I haven't had time to see if it is reported elsewhere.
I don't believe it's a April fools bit. I first heard about it the other day, that coupled with this from SANS and this from Websense tend to make me think it's real.
-Luke.
April 1, 2011 at 9:31 pm
Dave Ballantyne (4/1/2011)
CirquedeSQLeil (3/31/2011)
I have been meaning to do some performance testing on the whole select * thing. I ran into some cases where select * actually beat the pants off a select with all of the columns listed out. This was an atypical result where I had a realllllllllllly wide select statement. And it was after we upgraded a database from sql 2000 to sql 2008.
I for one would be surprised if that were true , maybe the parsing would be faster, but once the plan is in the cache i doubt it. Though if it were a 'simple' statement ,that may not happen.
Interesting......
Believe me, I was baffled by it. 150+ columns and a where clause. The select * was nearly twice as fast. I no longer have access to that exact scenario and need to try to recreate it. In no way am I saying that I advocate it b- just so it to be true on occasion.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 2, 2011 at 1:21 am
Like I retweeted :
RT @AdamMachanic: Congrats to new SQL Server MVP Paul White!!! @SQL_Kiwi This is a blind RT, because if he wouldn't be in, nobody would !
Congrats Paul ! SQLKiwi rules 😉
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 2, 2011 at 1:24 am
Roy Ernest (4/1/2011)
Forget about the tin, take good care of yourself !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 2, 2011 at 7:10 pm
What an amazing day at SQL Saturday #71 in Boston today.
Got to meet heaps of great people including Grant and Stefan K!
If anyone would like to see the slides from my session, you can download the 1MB file here: http://www.sqlsaturday.com/viewsession.aspx?sat=71&sessionid=4119
April 2, 2011 at 10:40 pm
SQLkiwi (4/2/2011)
What an amazing day at SQL Saturday #71 in Boston today.Got to meet heaps of great people including Grant and Stefan K!
If anyone would like to see the slides from my session, you can download the 1MB file here: http://www.sqlsaturday.com/viewsession.aspx?sat=71&sessionid=4119
I already took a look. Nicely done! I wish I could have been there to hear the narrative.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 2, 2011 at 10:58 pm
That's great. Thanks for the slides. We just finished sqlsaturday #63 in Dallas today. Nice turnout.
Jim
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
April 3, 2011 at 4:59 am
Roy Ernest (4/1/2011)
Shaken and hurts. Other wise I am Ok. Thx
Sorry to hear it. Take it easy and feel better.
"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
April 3, 2011 at 5:02 am
SQLkiwi (4/1/2011)
Hi everyone. Just to confirm it officially: I am now a SQL Server MVP (yay!)Thanks to everyone for their kinds words and encouragement.
Paul
Congratulations again Paul. Extremely well deserved.
And I got to shake hands with Paul. That's right. I've met Paul White in person. Some of it may have rubbed off. Fear me!
"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
April 3, 2011 at 5:04 am
SQLkiwi (4/2/2011)
What an amazing day at SQL Saturday #71 in Boston today.Got to meet heaps of great people including Grant and Stefan K!
If anyone would like to see the slides from my session, you can download the 1MB file here: http://www.sqlsaturday.com/viewsession.aspx?sat=71&sessionid=4119
It was a great day and I was extremely happy to meet Stefan and you.
I'm just glad it's over. All that crap is out of my basement. Yay!
"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
April 3, 2011 at 10:30 am
Grant Fritchey (4/3/2011)
SQLkiwi (4/1/2011)
Hi everyone. Just to confirm it officially: I am now a SQL Server MVP (yay!)Thanks to everyone for their kinds words and encouragement.
Paul
Congratulations again Paul. Extremely well deserved.
And I got to shake hands with Paul. That's right. I've met Paul White in person. Some of it may have rubbed off. Fear me!
I felt the same way when I finally got to meet Grant Fritchey in person. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
April 3, 2011 at 2:19 pm
Grant Fritchey (4/3/2011)
I'm just glad it's over. All that crap is out of my basement. Yay!
So, whose more glad about that... you or your family?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
April 4, 2011 at 12:57 am
Darn my addled jet-lagged brain - I forgot to mention how great it was to meet Jack Corbett and have a couple of good long chats with him. I really enjoyed his session, and he helped me out a lot. Thanks, Jack!
Viewing 15 posts - 25,306 through 25,320 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply