SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 It's dead, Jim
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 17

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/14/2006 :  09:26:36  Show Profile  Reply with Quote
There seems to a a run lately of "My database is gone. I don't have any backups. How do I get it back?"

Are a lot of people really this careless/clueless? Is it something you just have to be burned by before you understand?

I have had real fights getting people to understand the importance of database backups. A lot of admins seem to feel backups are a "nice to have thing", not a vital part of protecting the data.



Recovering Deleted Databases:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67780

Recovering a deleted database:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67553





CODO ERGO SUM

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 06/14/2006 :  09:56:14  Show Profile  Visit spirit1's Homepage  Reply with Quote
damn it Bones!!!

can't you fix it?

Go with the flow & have fun! Else fight the flow
Blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/14/2006 :  10:10:54  Show Profile  Reply with Quote
quote:
Originally posted by spirit1

damn it Bones!!!

can't you fix it?

Go with the flow & have fun! Else fight the flow
Blog thingie: http://weblogs.sqlteam.com/mladenp




I'm a DBA, not a magician!

CODO ERGO SUM
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22772 Posts

Posted - 06/14/2006 :  10:13:42  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
>> "My database is gone. I don't have any backups. How do I get it back?"

Note that It may be one of the Interview questions

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/14/2006 :  10:27:39  Show Profile  Reply with Quote
Interview Question: There were no database or server backups ever made, and the database server was just completely destroyed in a fire. How do I get the database back?


Reminds me of the story of a new IT manager. He asked to see the Disaster Recovery plan. He was given a folder. He looked inside, and found copies of resumes for all the IT staff.





CODO ERGO SUM
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 06/14/2006 :  10:33:18  Show Profile  Reply with Quote
There unfortunately are that may out there. We have been looking for a couple of new contractors and permanent staff for about 4 months. We have finally taken 2 contractors on, but were going through about 5 or 6 interviews a week! It p""£es me off that people will try to get a contract paying contract rates when they really know sweet fa about the job..

We did take on 1 contractor about a month and a half ago, not sure how he got through the interview though as I wasn't involved, but he scared me every time he asked a question, really thought I was gonna end up having to work weekends trying to recover the business until the day he was sacked..
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 06/14/2006 :  11:15:39  Show Profile  Reply with Quote
Hey, don't dis' all of us!

My company is pretty picky about the people we hire. I'm frequently called in to do technical interviews on prospective candidates, and I know where you are coming from because my pass rate is about 10%. Part of the problem is clients that do not know the difference between an experienced IT professional and some noob who creates Access files in his mom's basement. And they aren't willing to pay for a qualified professional.

blindman, Senior Database Consultant - Quick Solutions Inc.
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 06/14/2006 :  12:32:29  Show Profile  Reply with Quote
I'm not dissing contractors, I am one.. I just get fed up with people coming for interviews when they clearly couldn't do the job, especially when they expect to get paid the same, if not more, than me.. lol

Edited by - RickD on 06/14/2006 12:34:56
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/14/2006 :  12:45:39  Show Profile  Reply with Quote
There are plenty of people out there that deserved to be dissed, and not just guys with no experience.

I interviewed a guy a couple of years ago who couldn’t write simple queries, or explain how to use the DATEADD or SUBSTRING functions.

He had 10 years of SQL Server experience, and he wasn’t lying about that, because one of the guys on my team had worked with him years before this.




CODO ERGO SUM
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 06/14/2006 :  13:33:47  Show Profile  Reply with Quote
He was probably more "admin" than "architect". I see DBAs fall into those two different camps, and rarely is someone proficient at both. Did you ask him questions about configuring and maintaining database servers?
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/14/2006 :  14:21:06  Show Profile  Reply with Quote
quote:
Originally posted by blindman

He was probably more "admin" than "architect". I see DBAs fall into those two different camps, and rarely is someone proficient at both. Did you ask him questions about configuring and maintaining database servers?


He was supposed to be an architect. He really didn't know anything about administration.



CODO ERGO SUM
Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 06/14/2006 :  17:18:37  Show Profile  Reply with Quote
>> Note that It may be one of the Interview questions

I'd hire anyone who could answer it!

Kristen
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 06/14/2006 :  18:10:35  Show Profile  Reply with Quote
quote:
Originally posted by Kristen

>> Note that It may be one of the Interview questions

I'd hire anyone who could answer it!

Kristen


You just have to use the undocumented rowset function, OPENTIMEWARP, and retieve the data from the past.



CODO ERGO SUM
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

Australia
4970 Posts

Posted - 06/14/2006 :  19:26:18  Show Profile  Visit Merkin's Homepage  Reply with Quote
quote:
Originally posted by blindman

Hey, don't dis' all of us!

My company is pretty picky about the people we hire. I'm frequently called in to do technical interviews on prospective candidates, and I know where you are coming from because my pass rate is about 10%. Part of the problem is clients that do not know the difference between an experienced IT professional and some noob who creates Access files in his mom's basement. And they aren't willing to pay for a qualified professional.

blindman, Senior Database Consultant - Quick Solutions Inc.




Don't knock access. You'll upset Jeff



Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson
Go to Top of Page

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2050 Posts

Posted - 06/15/2006 :  03:48:28  Show Profile  Reply with Quote
quote:
Don't knock access. You'll upset Jeff



FIGHT! FIGHT! FIGHT!


steve

-----------

Oh, so they have internet on computers now!
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 06/15/2006 :  09:12:16  Show Profile  Reply with Quote
quote:
Originally posted by Michael Valentine Jones

quote:
Originally posted by spirit1

damn it Bones!!!

can't you fix it?

Go with the flow & have fun! Else fight the flow
Blog thingie: http://weblogs.sqlteam.com/mladenp




I'm a DBA, not a magician!

CODO ERGO SUM




No, no, no...it's

"Damn it Jim, I'm a DBA, not a miracle worker..."



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page

JimL
SQL Slinging Yak Ranger

USA
1537 Posts

Posted - 06/15/2006 :  10:48:33  Show Profile  Visit JimL's Homepage  Reply with Quote
quote:
"My database is gone. I don't have any backups. How do I get it back?"


1. Walk up to DBA and remove his/her head from his/her @$$.

2. Kick same @$$ out front door.

3. Throw personell director that hired him/her out highest window in vicinity.

4. Relace with individuals that actually have a brain.

Jim
Users <> Logic
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 06/16/2006 :  11:27:47  Show Profile  Reply with Quote
I wouldn't knock Access. It's a great little tool for small, rapid application development. I have the same affection for Access that most guys have for their first car...
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 06/16/2006 :  12:09:31  Show Profile  Reply with Quote
Yeah, but it's when you walk into a company and they tell you they have this small app in Access (turns out its 5 or 6 mdb files with queries 20 levels deep streching across all mdb's). Then they tell you that it's your job to upgrade it to SQL!

That's when you start to hate Access..
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 06/16/2006 :  12:57:55  Show Profile  Reply with Quote
Any app can be poorly written. Access and Excel just lend themselves to mis-use because of their ease of use. We've all seen crappy database designs in SQL Server and Oracle too, right?

And as long as I didn't put in a fixed bid, I'm happy to upgrade their convoluted system!
Go to Top of Page

mfemenel
Professor Frink

USA
1421 Posts

Posted - 06/16/2006 :  13:35:43  Show Profile  Visit mfemenel's Homepage  Reply with Quote
For those of you who have to interview people I have a great question I always like to ask at the end of the interview. "As a developer, what is the longest day in terms of hours you've worked?
" I'm hoping to hear someone give me an answer over 15, although many of us have done more. What I really enjoy are the people who say 8, or my favorite, the one who proudly said 9, I worked through lunch. Two problems with these people. 1 if you aren't smart enough to give me a high number, you shouldn't be hired. 2 if you worked 9 hours you aren't a developer. Most of us are just warming up by then since after 5 is the quiet part of the day when we can think.

Mike
"oh, that monkey is going to pay"

Edited by - mfemenel on 06/16/2006 13:36:20
Go to Top of Page
Page: of 17 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000