Forum Replies Created

Viewing 15 posts - 30,556 through 30,570 (of 49,552 total)

  • RE: How to prevent our database to access any person

    kumar.sachu08 (9/19/2010)


    Other Person (Client) not give me permission to access own server for the security point of view.

    No, I don't imagine he would.

    he is self sql administrator. So, we...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: Shouldn't the trans log backup be truncating my log file?

    SkyBox (9/19/2010)


    Shouldn't the trans log backup be truncating my log file? I even set up a trans log backup maintenance plan through the GUI and that did...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: SQL Server 2005 DBCC Error consistency

    The database is irreparably corrupt. Basically some critical portion of the system tables can't be read

    Do you have an earlier backup? Can you try and restore the March backup...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/19/2010)


    Gail will be harder since she's in South Africa, and a lot "sends" don't quite get there. I'll have to work with RG on something.

    Redgate's sent...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: How to prevent our database to access any person

    kumar.sachu08 (9/19/2010)


    Sometime such cases come for DBA or developer. He don't want to share own database

    In those cases the DBA or developer should host the database themselves. If you give...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: How to prevent our database to access any person

    Lowell (9/19/2010)


    I know the feeling...you put a lot of hard work and time into designing the database objects, and you don't want anyone to look at them because they could...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: How to prevent our database to access any person

    There is no way you can prevent someone who is a SQL sysadmin from doing what they want with the database. A sysadmin by definition has full permissions to everything...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: Anyone know where the MS Auditing tool is?

    blacklabellover2003 (9/19/2010)


    GilaMonster (9/19/2010)


    No such free tool that I know of. I wrote a whole bunch of scripts to do such audits. They're not that hard to write, just tedious.

    Did you...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: Anyone know where the MS Auditing tool is?

    No such free tool that I know of. I wrote a whole bunch of scripts to do such audits. They're not that hard to write, just tedious.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: Are the posted questions getting worse?

    Jeff Moden (9/18/2010)


    Gail has less than 40 points to go to hit 20k points and less than 1000 posts to go for 20k posts. Way to go Gail!

    :w00t:

    Should hit...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/18/2010)


    Lynn Pettis (9/17/2010)


    CirquedeSQLeil (9/17/2010)


    Just curious if anybody here has ever walked out of an interview...What would be your justifications for doing so?

    I've terminated an interview when...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: How to prevent our database to access any person

    You can't. There are things you can do to slow them down, but if a person is a SQL administrator, they have complete and total control over the server and...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: What was my very first post?

    Steve Jones - Editor (9/18/2010)


    I think most of us would be hard pressed to impress Gail in an interview :w00t:

    Nah. Know what you claim to know and show some enthusiasm...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: MCSE or MCITP

    zenchew (9/17/2010)


    MCSE or MCITP what is better and have a more career opportunity.....?

    I suspect this was a spam post and the link was removed, but for anyone running across this...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • RE: What was my very first post?

    Lowell (9/18/2010)


    Gail had an excellent point about how someone could sabotage their chances by posting mostly entry level questions vs posting solutions and answers and then having the interviewer actually...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 15 posts - 30,556 through 30,570 (of 49,552 total)