Forum Replies Created

Viewing 15 posts - 5,626 through 5,640 (of 6,022 total)

  • RE: Why Use the Principle of Least Privilege?

    Steve Jones - SSC Editor (4/12/2011)


    Eric M Russell (4/12/2011)


    It's just like those big concrete dividers that the department of transportation puts between the east and west bound lanes of an...

  • RE: Why Use the Principle of Least Privilege?

    In any database that I have ownersip of, I typically grant application accounts authorization by adding them as members of a single role, and that role grants them only EXEC...

  • RE: Data Warehouse Development: Version 0

    David.Poole (4/11/2011)


    The intent of Version 0 is to show what can be achieved. A taster with a promise of jam tomorrow. My worry is that executive thinking is...

  • RE: Trying to connect SQL Server 2008 64-bit to Oracle 10g

    Gift Peddie (4/11/2011)


    Eric M Russell (4/11/2011)


    Gift Peddie (4/11/2011)


    Eric M Russell (4/11/2011)


    Aaron N. Cutshall (4/11/2011)


    Thanks Eric! I'll try that out and let you know although it will be a while...

  • RE: Trying to connect SQL Server 2008 64-bit to Oracle 10g

    Gift Peddie (4/11/2011)


    Eric M Russell (4/11/2011)


    Aaron N. Cutshall (4/11/2011)


    Thanks Eric! I'll try that out and let you know although it will be a while before I do since I'm...

  • RE: SQL Injection Everywhere

    Years ago, I read an article about experiments with web scent devices. Just like audio, it would basically be a device that sits on your desktop and contains chemicals for...

  • RE: Trying to connect SQL Server 2008 64-bit to Oracle 10g

    Aaron N. Cutshall (4/11/2011)


    Thanks Eric! I'll try that out and let you know although it will be a while before I do since I'm getting ready to go on...

  • RE: SQL Injection Everywhere

    Once a smart team of engineers create a really practical piece of technology, it's inevitable that the consumer marketing industry will come along behind them, FUBAR the technology, and then...

  • RE: Trying to connect SQL Server 2008 64-bit to Oracle 10g

    Aaron N. Cutshall (4/11/2011)


    nick.mcdermaid (4/11/2011)


    And yes unfortunately the Oracle client is a hideously bloated thing that needs to be installed.

    I couldn't agree with you more! That sucker is HUGE...

  • RE: Using IDENTITY or handling it your own?

    If I need to generate a unique sequential integer IDs for transactional records (for example sale_id or customer_id), then I'll use an identity. I call that an instance ID. However,...

  • RE: Data Warehouse Development: Version 0

    Martin Mason (4/7/2011)


    magarity kerns (4/7/2011)


    I think the first assertion needs a slight modification; a first version DW should produce one reporting subject area, not just one report. From there, it's...

  • RE: Data Warehouse Development: Version 0

    There are a series of canned questions that should always be asked upfront, and these should be documented in the requirements. However, I also find it essential to ask the...

  • RE: NEW SEQUENCE NUMBER DAILY?

    Brandie Tarvin (4/6/2011)


    Now that's a clever solution. I like the use of Rank, Partition, and Right there.

    One caveat to using the ranking method is that each row is ranked dynamically...

  • RE: NEW SEQUENCE NUMBER DAILY?

    DMS11X (4/4/2011)

    Can someone mark this thread as solved? So if anyone else needs help...

    Looking at your sample resultset above, it seems to me that the column SequenceNumber is derived...

  • RE: Analyzing an Unfamiliar and Undocumented System

    Well, the good news is that you've got your work cut out for you and don't need to worry about getting laid off anytime soon.

    In most large proprietary databases...

Viewing 15 posts - 5,626 through 5,640 (of 6,022 total)