Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: salary survey and certification

    It may just be saying something about the data/respondents, but I thought it was fascinating to see the dip in salary for the 6-9 years of experience across several job...

  • RE: Updating an SSIS package stored on SQL Server

    If you have permission, open the SQL Server Management Studio and make a new connection to the Integration Services on the target server. Then just right-click on the folder...

  • RE: Any SQL gurus / n00bs that are closet musicians?

    I've always been surprised that more IT professionals haven't been involved in music. I've been immersed in it since I was five (piano to violin to saxophone (alto then...

  • RE: Email Query Results Using SSIS

    I've had great luck using the sp_send_dbmail inside of an execute t-sql task.

    The setup for that is pretty easy:

    EXEC msdb.dbo.sp_send_dbmail

    @profile_Name = 'ProfileName',

    @recipients = ' recip@yourcompany.com',

    @body = 'Here's the query...

  • RE: Caution with EXCEPT

    I think it's worth mentioning that there's also an INTERSECT function for finding the overlapping rows. I spend many, many hours validating data and even I don't use intersect...

  • RE: GOOD BOOK OR ONLINE CLASS TO LEARN SQL

    I was in more or less the same boat when I was moved into a BI position. I can't agree more about the advice about Itzik Ben Gan (he's...

  • RE: Can Users Be Trusted?

    michael.wiles (12/22/2009)


    ... To me, that business model seems too propieatary and monopolistic for me and seems to run counter to the free market place we pride ourselves of having. ...

Viewing 7 posts - 1 through 7 (of 7 total)