Forum Replies Created

Viewing 15 posts - 3,991 through 4,005 (of 6,041 total)

  • RE: The Opportunistic Hacker

    Leveraging something like a botnet or backdoor trojan, a hacker doesn't even need physical access to the laptop to get at your files. The type of security threats that keep...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Truncate table failing (intermittently), no errors presenting.

    Consider setting up an audit event, DDL trigger, or profiler trace to keep track of when exactly a truncate operation is performed on this table. The simplist explanation is that...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Converting date column that is a varchar data type to a datetime data type

    Sigerson (4/9/2015)


    ZZartin (4/3/2015)


    Quick question Grant, how many times have you seen systems/processes fail on the 13th of the month? I can count a good handful.

    In my last job I managed...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Your Cloud Held Hostage – Could It Happen?

    I hear that Bruce Willis is making a 6th 'Die Hard' movie about an aging night shift security guard at Windows Azure data center that gets held hostage by a...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Your Cloud Held Hostage – Could It Happen?

    Wayne, I guess what you're saying is that you don't trust your Cloud provider's ISP, because your own local ISP can't be trusted. However, one advantage to geo-location, aside from...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Incremental Load

    RonKyle (4/7/2015)


    in the real world this typically ends up being a type 1, 2, or 3 slowly changing insert / update

    How does it end up being a type 3? ...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Efficient way to delete historical data

    Maddave (4/7/2015)


    Thanks. I agree there are definitely some improvements that could be made with this design.

    Unfortunately, I cannot implement the delete by hour, well not yet anyway. The machines...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Efficient way to delete historical data

    I hate delete operations. I always feel deletes, especially bulk deletes, indicate something is wrong with the database model or ETL design. What I mean by that is: why insert...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Your Cloud Held Hostage – Could It Happen?

    If you have some slush money left over in your disaster recovery planning budget, you can play off the fear of executive management by blocking off an entire day to...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Your Cloud Held Hostage – Could It Happen?

    Geo-replication and geo-backups are two different things. Every cloud data vendor should have daily or weekly off-site backups that include even the lowest tier customers who arn't paying for geo-replicatation.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Matching Column IDs based on field contents

    tomsharp85 (4/3/2015)


    Create Table for CompanyAddress1

    ...

    I don't think an insert into the names is relevant here.Also I thought of splitting the address tables into 3 as in total there are more...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Converting date column that is a varchar data type to a datetime data type

    As a side note, without a constraint on this VarChar "date" column it will be a constant struggle to get users to enter data consistently and any conversion functions you...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Matching Column IDs based on field contents

    tomsharp85 (4/3/2015)


    OK, the names table was a generic way of listing for brevity, the tables are different industry sectors. Yes all of those tables are exactly the same. will your...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Large Chunks of Data

    Robert.Sterbal (4/3/2015)


    Eric,

    Are they just afraid of electronic signatures?

    Somewhere in the bowls of every large corporation and government agency, there is at least one gray haired person dedicated to doing this....

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Large Chunks of Data

    The total number of pages on a report a user wants to scan through hasn't changed in five years. However, there are scenarios where an oranization prints 1,000 page reports...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 3,991 through 4,005 (of 6,041 total)