June 3, 2011 at 4:28 pm
So can beer, Jeff. I'm about to go sample some. Have a great weekend, y'all.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 4, 2011 at 3:15 am
jcrawf02 (6/3/2011)
GSquared (6/3/2011)
Jim Murphy (6/3/2011)
The Dixie Flatline (6/3/2011)
I've given the matter considerable thought, and have conclusively concluded that the posted questions are indeed getting worse.Bob - this is an old thread and is no longer about the original topic. <poke>
What? Who changed the subject? When did that happen?
As far as the original goes, I'm currently in the middle of answering someone on why .9-repeats is equal to 1. What's next? "Why is B after A in the alphabet?" Most of the people on that thread are treating it just as seriously as it deserves (jokes about beer-philosophy and such), but the question .... well .... (magoo jumped in and got a few people's goats - almost including mine - it was well done).
That thread was well worth the headache it produced just for Magoo's response to "How many mathematicians does it take to screw in a lightbulb?" :-D:hehe:
The answer to that is two (just like any other people) - but you do need a pretty large lightbulb, and it's difficult to get us to do it if the lightbulb doesn't come with appropriate soft furnishings.
Tom
June 4, 2011 at 3:53 pm
All (but mostly Gail),
Why is it hard to find sessions about corruption and repair?
A) sessions not attended well because no one really cares (percieved as largely irrelevant).
B) community already knows everything about it.
C) because Paul R is the master since DBCC still stood for 'Database Consistency Check', and no one wants to somehow 'compete'?
D) knowledgable speakers are hard to come by (but what about PR, KT, GS?)
E) none of the above. Reason:____________.
I would love to know because it is highly relevant to a DBA's job in my opinion. Big time. When disaster happens, that is no time for reading PR's blog. Must be known already, at least mostly. And practiced.
I'm working up a presentation for a local UG/SS session and I see somewhat of a void in these types of sessions, compared to other topics. I don't want to do a bunch of work to find that it ends up being unattended or otherwise not a good idea for a reason that I don't know.
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
June 4, 2011 at 4:00 pm
Jim Murphy (6/4/2011)
All (but mostly Gail),Why is it hard to find sessions about corruption and repair?
A) sessions not attended well because no one really cares (percieved as largely irrelevant).
B) community already knows everything about it.
C) because Paul R is the master since DBCC still stood for 'Database Consistency Check', and no one wants to somehow 'compete'?
D) knowledgable speakers are hard to come by (but what about PR, KT, GS?)
E) none of the above. Reason:____________.
C, D, E.
It's a difficult subject, it's not something that one should get wrong (but it's very easy too), there's lots and lots of subtleties (I know, I've written one and planned another article on the subject). There's a lot of 'it depends' and very few absolute rules.
That said... http://www.quest.com/events/ListDetails.aspx?ContentID=13506, and the same session's been submitted as a SQLPass abstract (and I got high praise from PR re that webcast)
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
June 4, 2011 at 6:40 pm
GilaMonster (6/4/2011)
It's a difficult subject, it's not something that one should get wrong (but it's very easy too), there's lots and lots of subtleties (I know, I've written one and planned another article on the subject). There's a lot of 'it depends' and very few absolute rules.
Agreed. I totally get this. I also don't claim to be a master in this domain; only coming across a few different types of corruption and Suspect issues. But I'm not going for a level 600 precon. I think there is a community need for some 100 recovery techniques, and a few 200. Simple stuff like hacking a database in because the Jr. DBA detached a Suspect database which has corruption or getting a db back online after ldf drive set barfs while the system is still up, or the unbacked up 200GB ldf fills the drive. I would consider this stuff 100 stuff. No hint of what DBCC Page is/does. No mention of digging through NCI's to try to salvage a little more data (which I have never personally done). Not even a peep about exporting data to another table/database. Those topics could be other sessions.
I would think the more typical scenarios should be taught by someone at every SQL Saturday - at least one common session. Then more folks will have a better idea of what to do when the day comes that they are in the hot seat with the executives stressing over when the system will be back online and was data lost.
And we can't expect Paul, Kimberly or you to attend each SSat. But I too don't want to see misinformation getting out there either.
That said... http://www.quest.com/events/ListDetails.aspx?ContentID=13506, and the same session's been submitted as a SQLPass abstract (and I got high praise from PR re that webcast)
Wife and kids just returned from a trip. I'll watch this later. Thanks for the link.
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
June 4, 2011 at 9:11 pm
Okay denizens of The Thread, I got a call yesterday evening from my oldest daughter that actually left me speechless.
I am going to be grandfather![/i]
Looks like I'll need to get my passport and save some money for a round trip ticket to Germany next year.
June 4, 2011 at 9:53 pm
Lynn Pettis (6/4/2011)
Okay denizens of The Thread, I got a call yesterday evening from my oldest daughter that actually left me speechless.I am going to be grandfather![/i]
Looks like I'll need to get my passport and save some money for a round trip ticket to Germany next year.
'bout time!
You'll enjoy it even more than being a father... you can spoil them, then hand them back to the parents!
Seriously... congrats!
PS - you might want to plan on leaving your wife over there for a month or so... 🙂
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 4, 2011 at 9:59 pm
Lynn Pettis (6/4/2011)
I am going to be grandfather![/i]
Congratulations! That is great news.
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
June 5, 2011 at 4:09 am
Jim Murphy (6/4/2011)
Simple stuff like hacking a database in because the Jr. DBA detached a Suspect database which has corruption
Restore from backup. Depending on your downtime SLA and how long a restore will take you may need to fail to DR, fix the primary and then fail back.
or getting a db back online after ldf drive set barfs while the system is still up
Restore from backup, unless the DB was cleanly shut down and the log can be recreated. Depending on downtime SLA and how long a restore will take you may need to fail to DR, fix the primary and then fail back.
Data will almost certainly have been lost here, and unless the app keeps record there will be no way of telling what was lost.
or the unbacked up 200GB ldf fills the drive.
Depending on the system's tolerance for risk, either switch to simple recovery, shrink the log to its usual size, switch back to full, take a backup and fix the log backups or create a second log file, fix the log backups, shrink the log as soon as it's possible and remove the second log file.
I would consider this stuff 100 stuff.
Closer to 200 I would expect.
The complexities aren't necessarily in the technical details (which often you only need to go into if things are badly messed up already), it's in the figuring out which option of the ones available will fix the situation without violating the SLAs
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
June 5, 2011 at 4:18 am
Lynn Pettis (6/4/2011)
Okay denizens of The Thread, I got a call yesterday evening from my oldest daughter that actually left me speechless.I am going to be grandfather![/i]
Looks like I'll need to get my passport and save some money for a round trip ticket to Germany next year.
Woot! Congrats.
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
June 5, 2011 at 9:24 am
Lynn Pettis (6/4/2011)
Okay denizens of The Thread, I got a call yesterday evening from my oldest daughter that actually left me speechless.I am going to be grandfather![/i]
Looks like I'll need to get my passport and save some money for a round trip ticket to Germany next year.
Awesome and congrats!
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 5, 2011 at 10:02 am
Lynn Pettis (6/4/2011)
Okay denizens of The Thread, I got a call yesterday evening from my oldest daughter that actually left me speechless.I am going to be grandfather![/i]
Looks like I'll need to get my passport and save some money for a round trip ticket to Germany next year.
Congratulations all around. Congrats to Lynn for having a Grandchild...
congrats to his daughter for leaving him speechless. 😀 😛 😉 :hehe:
Seriously, congratulations to you and yours, Lynn.
I do have a question, though... What is your daughter doing in Germany? I hadn't heard about that. Is this the one in the military?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2011 at 1:02 pm
Jeff Moden (6/5/2011)
Lynn Pettis (6/4/2011)
Okay denizens of The Thread, I got a call yesterday evening from my oldest daughter that actually left me speechless.I am going to be grandfather![/i]
Looks like I'll need to get my passport and save some money for a round trip ticket to Germany next year.
Congratulations all around. Congrats to Lynn for having a Grandchild...
congrats to his daughter for leaving him speechless. 😀 😛 😉 :hehe:
Seriously, congratulations to you and yours, Lynn.
I do have a question, though... What is your daughter doing in Germany? I hadn't heard about that. Is this the one in the military?
Yesn this is my oldest and in the Army. Her boyfriend got orders for Germany so they got married in February so she could go with him. They were also supposed to deploy to Afghanistan shortly after getting to Germany. I guess she won't be going there now.
June 5, 2011 at 3:08 pm
Lynn Pettis (6/4/2011)
Okay denizens of The Thread, I got a call yesterday evening from my oldest daughter that actually left me speechless.I am going to be grandfather![/i]
Looks like I'll need to get my passport and save some money for a round trip ticket to Germany next year.
Congratulations!
June 5, 2011 at 5:13 pm
Congratulations, Lynn! Hope all goes smoothly for mother and child.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 15 posts - 26,971 through 26,985 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply