Forum Replies Created

Viewing 15 posts - 7,126 through 7,140 (of 19,560 total)

  • RE: Pros vs Con Storing SSIS Packages in the File System vs MSDB

    One benefit I like of storing in MSDB is that the changes get versioned within msdb. Plus, I can backup the msdb database and know that those packages have...

    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

    January 16, 2012 at 3:03 pm

    #1434317

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (1/16/2012)

    Chad Crawford (1/16/2012)

    WayneS (1/16/2012)

    So, what kind of laptop do you have?

    Slacks M-Th, Levis on Friday and the weekend.

    I guess I should find it amusing...

    ... but my...

    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

    January 16, 2012 at 3:00 pm

    #1434315

  • RE: Are the posted questions getting worse?

    SQL Kiwi (1/16/2012)

    Gianluca Sartori (1/16/2012)

    Also, I don't find 2012 SSMS to be slow at all, even in a VM. I must admit that my laptop is a very fast machine...

    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

    January 16, 2012 at 2:58 pm

    #1434314

  • RE: Are the posted questions getting worse?

    WayneS (1/16/2012)

    Chad Crawford (1/16/2012)

    WayneS (1/16/2012)

    So, what kind of laptop do you have?

    Slacks M-Th, Levis on Friday and the weekend.

    cute. got'cha beat... jeans all week

    Even better - no pants...

    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

    January 16, 2012 at 2:57 pm

    #1434312

  • RE: How to prevent user login to SQL Management Studio ?

    I think the better method is to use a firewall. Through the firewall, put explicit permissions for IP addresses to access the Database Zone. This doesn't prevent somebody...

    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

    January 16, 2012 at 2:53 pm

    #1434306

  • RE: Are the posted questions getting worse?

    Chad Crawford (1/16/2012)

    WayneS (1/16/2012)

    So, what kind of laptop do you have?

    Slacks M-Th, Levis on Friday and the weekend.

    :hehe:

    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

    January 16, 2012 at 2:48 pm

    #1434301

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/16/2012)

    SQLRNNR (1/16/2012)

    Anybody else get a request like this recently?

    Yup. I got one last week. It went to spam and I left it there because...

    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

    January 16, 2012 at 2:46 pm

    #1434300

  • RE: What, when and who? Auditing 101 - Part 2

    Nicely done Roy.

    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

    January 16, 2012 at 12:50 pm

    #1434239

  • RE: Are the posted questions getting worse?

    Anybody else get a request like this recently?

    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

    January 16, 2012 at 12:41 pm

    #1434233

  • RE: How to prevent user login to SQL Management Studio ?

    thang_ngo_2002 (1/16/2012)

    SQLKnowItAll (1/16/2012)

    is my solution correct ("db_denydatareader" to MASTER)

    No, it is not correct.

    Could you please explain me why, I'm try that way, I can connect from my program and...

    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

    January 16, 2012 at 10:48 am

    #1434192

  • RE: How to prevent user login to SQL Management Studio ?

    Gianluca Sartori (1/16/2012)

    I did a similar thing some years ago.

    Here's the code:

    CREATE TRIGGER [TR_LOGON_APP]

    ON ALL SERVER

    FOR LOGON

    AS

    BEGIN

    DECLARE @program_name nvarchar(128)

    DECLARE @host_name nvarchar(128)

    SELECT @program_name = program_name,

    @host_name = host_name

    FROM sys.dm_exec_sessions AS...

    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

    January 16, 2012 at 10:45 am

    #1434190

  • RE: Are the posted questions getting worse?

    SQL Kiwi (1/16/2012)

    GilaMonster (1/16/2012)

    Hell, it's hard enough going back to SQL 2000.

    I installed a 2000 VM recently just to test something specific. I had almost no clue where to...

    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

    January 16, 2012 at 10:43 am

    #1434185

  • RE: Are the posted questions getting worse?

    GilaMonster (1/16/2012)

    Revenant (1/15/2012)

    the fact is that there is 2012 waiting for the official release; IMO all adequate tests today ought to be for that one - the newest version -,...

    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

    January 16, 2012 at 9:37 am

    #1434146

  • RE: Rainbow Table

    I was surprised to see a question about this here. Now that has me thinking of importing some rainbow tables into SQL Server...hmmm:cool:

    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

    January 16, 2012 at 8:47 am

    #1434116

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/14/2012)

    Ultimately I think the exams aren't well done. They don't have a large enough pool of questions, they aren't "thinking" questions, and there's no feedback...

    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

    January 14, 2012 at 3:36 pm

    #1433762

Viewing 15 posts - 7,126 through 7,140 (of 19,560 total)