Forum Replies Created

Viewing 9 posts - 46 through 55 (of 55 total)

  • RE: SQL Unit Testing

    Hi Jonathan,

    I see your point, I misunderstood the "integration test" line. Actually, it's a good observation, and I partially agree with you. If you just run the test as if,...

    Alejandro Pelc

  • RE: SQL Unit Testing

    Hi Jonathan,

    I'm confused about what you mean with integration tests. Why you think this is the case ? It's true that I used it to test different systems, as mentioned...

    Alejandro Pelc

  • RE: Search SQL Error Log

    Hi James,

    That means that one of the log files is not there. I'll review the script to validate that the log file exists.

    Cheers,

    Alejandro

    Alejandro Pelc

  • RE: SQL Unit Testing

    Hey Brian,

    totally agree about the complexity. I guess the first thing to do before using this is knowing how deep you want / can go. For brand new projects is...

    Alejandro Pelc

  • RE: SQL Unit Testing

    Hi Brian,

    This is a good observation, and I agree with you about the system testing if you just run it out-of-the-box.

    This tool saves tons of time writing the queries from...

    Alejandro Pelc

  • RE: SQL Unit Testing

    Hi Mike,

    The test will validate if it runs without errors. Because you're executing stored procedures or t-sql commands, if there's an error, the unit test will fail, so the overall...

    Alejandro Pelc

  • RE: SQL Unit Testing

    Hi karthikshanth,

    You can actually test the calls to the database, so in a certain way you are testing the SSRS backend.

    If you want to test the reports, there's a free...

    Alejandro Pelc

  • RE: SQL Unit Testing

    Hi there,

    GermanDBA is right, you should create some sort of backup/restore strategy or include the DB creation / data population prior to run the tests and then just drop the...

    Alejandro Pelc

  • RE: Search SQL Error Log

    Hi Nancy,

    sorry the delay but I'm on a trip and just saw your post. First of all, it won't work on SQL 2000 because I create a table variable, which...

    Alejandro Pelc

Viewing 9 posts - 46 through 55 (of 55 total)