Forum Replies Created

Viewing 15 posts - 751 through 765 (of 1,221 total)

  • RE: TechEd - Day 1

    David.Poole (6/11/2008)


    ... I've been looking at spatial geography and trying to understand the new indexes which are really odd. I'm not sure why the new geography and geometry types...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: SSIS Is Not Just for SQL Server

    Charles Kincaid (5/21/2008)


    ...(1) In your database create a nonsense, but unique, filename for each "target".

    (2) Use that to include in a well crafted HTML email that references an external graphic....

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: SSIS Is Not Just for SQL Server

    Jim Russell (5/21/2008)


    I was disappointed when, per the MS Connect site, that the horrible flaw in the SSIS FTP task was not fixed. (The flaw is that the source/destination directory...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: TechEd - Day 1

    There are also the free SQL boot camp weekends occasionally done in Florida and California (and sprouting up in other places), again your boss would be out transport, meals, and...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: TechEd - Day 1

    Grant's got it right. If the company doesn't have a good training plan, you can pretty much forget it. And it used to be that you could write-off...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: A Private Database

    There's a good article on Technet on implementing row-level security, actually it's on building a classified database, but it does include row-level security, which doesn't look too difficult to implement.

    http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Stop, Smell, Smile

    It's kind of funny. My best friend (she was best man at my wedding, my wife and I just celebrated our third anniversary Wednesday) frequently told me that no...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Mixing DDL and DML - DECLARE and SET - Which is which?

    James Raddock (6/3/2008)


    ... Some people I've worked with think it's best to declare your variables at the top of the proc with your temp tables, but that's more of a...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: connect to Sftp using putty ssis

    Your best bet for getting the files into a specific directory is to either move them through a CMD file (which is how I invoke PSFTP), or to download them...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: SFTP Subscription Error

    I don't have an answer for you, but I might have a clue to suggest. I'm trying to set up an SFTP download in a scheduled job and I'm...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Composite Key Question

    Ah, I hadn't noticed the PERSISTED, it was off into the scrolled section. It's kind of funny, I'd never had a problem with non-deterministic indexing until I started developing...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Composite Key Question

    I don't have time to test what you did, but it looks like it might be viable. Try two dates: 5/2/08 and 2/5/08, it's a good test if people...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Composite Key Question

    It was pretty simple, at least on the surface. The case study was a drug study where you have a group of subjects with a condition and you're testing...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: DTS Problem with Text File Line Length

    Answered my own question!

    There's a box that lets you skip X number of rows. When I told it to skip the first row, then it allowed me to define...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The Hot DBA

    But if we're packaging ourselves to be more sellable, do we have to put an expiry date on ourselves? And if we don't expire on that date, is it...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

Viewing 15 posts - 751 through 765 (of 1,221 total)