Forum Replies Created

Viewing 15 posts - 19,351 through 19,365 (of 19,560 total)

  • RE: DBAs Pen

    Lynn Pettis (9/9/2009)


    I find much value in getting published. Having authored 4 articles (2 here on SSC and 2 on SSWUG.ORG), I find it a way to give back...

    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

  • RE: How can the domain of a SQL Server be determined

    I also forgot to mention another method:

    Ask the Engineering, Network, Server Admin team (whatever they are called at your work) what the domain for that server is.

    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

  • RE: How can the domain of a SQL Server be determined

    Elliott W (9/9/2009)


    SET NOCOUNT ON

    DECLARE @Domain varchar(30)

    CREATE TABLE #cmdshelloutput ( outtext varchar(255) )

    INSERT #cmdshelloutput EXEC master.dbo.xp_cmdshell 'SET'

    SELECT @Domain = RIGHT(outtext, LEN( outtext ) - 11 )

    FROM #cmdshelloutput...

    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

  • RE: If you weren't a DBA what would you be doing?

    SQL Iron Chef (9/9/2009)


    we could always be full time college students for life 😎 where's the party at!? :w00t:

    Ahh, but where will the money come from? Ma and Pa...

    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

  • RE: Are the posted questions getting worse?

    Greg Edwards (9/9/2009)


    Jan Van der Eecken (9/9/2009)


    GilaMonster (9/9/2009)


    Silverfox (9/9/2009)


    No it isnt, Gail made some money by the sounds of it.

    No I didn't. No one local was willing to bet that...

    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

  • RE: Are the posted questions getting worse?

    GilaMonster (9/9/2009)


    CirquedeSQLeil (9/9/2009)


    So my curiosity is if you live close to Durban or somewhere else.

    Durban? Hell, no. I'm in JHB.

    Well put.

    Thx

    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

  • RE: Are the posted questions getting worse?

    GilaMonster (9/9/2009)


    Silverfox (9/9/2009)


    No it isnt, Gail made some money by the sounds of it.

    No I didn't. No one local was willing to bet that the pigeon would lose.

    Let's put it...

    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

  • RE: Am I the only DBA

    Silverfox (9/8/2009)


    CirquedeSQLeil (9/8/2009)


    Laptop / Desktop - Yes. Laptop supplied by work is usually always a fight with the employers.

    Books - Yes. I buy my own.

    Certification - Not since...

    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

  • RE: Are the posted questions getting worse?

    But maybe, just maybe, two european swallows flew to Mauritius, procurred a coconut and presented it to two african swallows. That solves that.

    Now if we only knew the avg...

    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

  • RE: Am I the only DBA

    Laptop / Desktop - Yes. Laptop supplied by work is usually always a fight with the employers.

    Books - Yes. I buy my own.

    Certification - Not since SQL2000. ...

    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

  • RE: If you weren't a DBA what would you be doing?

    Florian Reischl (9/8/2009)


    SQL Iron Chef (9/8/2009)


    The world would store their data in flat text files or excel spreadsheets lol :hehe:

    Wouldn't exist, too. CSV and Excel are just a lousy kind...

    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

  • RE: What on earth is a Database Administrator Architect

    And here I thought along the same lines as Jeff - just a different title for a DBA.

    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

  • RE: SQL 2005 Encryption and PCI Compliance....

    I would ask your auditor concerning this.

    Our auditor informed us that DMKs did NOT need to be regenerated. Rather the certificates and keys other than DMK needed to be...

    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

  • RE: IF condition in CURSOR

    Bob Hovious (9/3/2009)


    Sudhanva,

    Please do not think for a moment that we are making fun of you personally. Obviously, those of us who volunteer to help others...

    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

  • RE: IF condition in CURSOR

    Jeff Moden (9/3/2009)


    CirquedeSQLeil (9/3/2009)


    Paul White (9/3/2009)


    Just for completeness, this is also valid:

    -- Just to simulate some condition or other

    declare @v-2 int;

    set @v-2 = 2;

    -- Dear Lord, why am I using...

    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

Viewing 15 posts - 19,351 through 19,365 (of 19,560 total)