| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-08-12 : 01:49:14
|
| Dear All,i've recently attended an interview, and i failed to answer some.some of those are1)what are the security steps you implement after joining an organization?i've given the answer but that is at user level. they asked me at server level. may i know what are the steps to be implemented at server level?2)some times after restarting the server, sql server will not start. why?i've told them that may be the service is at manual level so we need to start the service manually.---nono that is in automatic mode. still the problem exists. how can you resolve?may i know the answer pleaseArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-12 : 01:58:09
|
"2)some times after restarting the server, sql server will not start. why?"The questions are too general. Without knowing the exact situation, anything is possible.- somebody uninstalled SQL Server- some files was deleted / corrupted- the dog eat up the hard disk- . . .basically anything under the sun may be the reason of thisThe interviewer should not be asking WHY but How / What are the steps / area to check / troubleshoot
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-12 : 02:50:32
|
1) Change password for SA account. Write the password on a note. Put the note in a safe. Drop the safe in the Mariner gorge.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-12 : 03:04:24
|
1) Asian version : Change password for SA account. Write the password on a note. Burn the note. dissolve the ash in a glass of water and drink it.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-12 : 06:46:17
|
| very funny KHthank you Peso and KHArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-12 : 08:29:14
|
| only for asians this solutions? or for all?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2008-08-12 : 08:54:33
|
quote:
Originally posted by Peso
1) Change password for SA account. Write the password on a note. Put the note in a safe. Drop the safe in the Mariner gorge.
E 12°55'05.25"N 56°04'39.16"
This may not always be a good idea. The crappy ERP system that I am forced to administer actually uses the SA account for everything. If I changed it, I would crash most of our systems. Go ahead, ask me how I learned this.  |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2008-08-12 : 09:25:48
|
| I prefer to bury safe under new foundation.JimUsers <> Logic |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-08-12 : 09:46:18
|
quote:
Originally posted by DavidChel
quote:
Originally posted by Peso
1) Change password for SA account. Write the password on a note. Put the note in a safe. Drop the safe in the Mariner gorge.
E 12°55'05.25"N 56°04'39.16"
This may not always be a good idea. The crappy ERP system that I am forced to administer actually uses the SA account for everything. If I changed it, I would crash most of our systems. Go ahead, ask me how I learned this.
I found a database being used by a building access/security application that was using MSDE with a blank SA password installed on an old laptop computer. I always wondered if everyone would be locked in or locked out of the building if I changed the password.CODO ERGO SUM |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-08-12 : 09:55:53
|
and you never tried????? now i'm a bit disapointed in you  _______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-08-12 : 10:01:08
|
| I didn't bother because it wasn't at a site I work at, so I wouldn't have the pleasure of seeing everyone standing outside in freezing winter weather.CODO ERGO SUM |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2008-08-15 : 07:36:15
|
quote:
Originally posted by sunsanvin
1)what are the security steps you implement after joining an organization?
Build some trojans into the master database so that if you get fired for dicking around on Facebook all day, the whole server and the data falls apart and they beg you to come back and fix it. Then you can up your rate.quote:
2)some times after restarting the server, sql server will not start. why?
You restarted the WRONG SERVER!!!! OMG(either that or the user you were running SQL Server under has it password expired or changed, blame the domain admins then spend the rest of the week on Facebook while the problem gets resolved)Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-15 : 08:27:49
|
quote:
Originally posted by Merkin
quote:
Originally posted by sunsanvin
1)what are the security steps you implement after joining an organization?
Build some trojans into the master database so that if you get fired for dicking around on Facebook all day, the whole server and the data falls apart and they beg you to come back and fix it. Then you can up your rate.quote:
2)some times after restarting the server, sql server will not start. why?
You restarted the WRONG SERVER!!!! OMG(either that or the user you were running SQL Server under has it password expired or changed, blame the domain admins then spend the rest of the week on Facebook while the problem gets resolved)Damian"A foolish consistency is the hobgoblin of little minds." - Emerson
 |
|
|
|
|
interview question please answere