Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 3,617 total)

  • RE: Logging Tables

    Kristen, it sounds like you chose the right thing for your company, your use case and the size of problem.

    There are no absolutes. The epiphany I had was...

  • RE: Logging Tables

    At one point I would have taken variations and amalgamations of what has been written here.

    Now I would question why logging needs to be in the DB at all if...

  • RE: Find Missing FK Constraints and Fixing them

    I've been playing with this sort of thing for a while.

    1. Identify missing primary keys and unique constraints
    2. Identify the number of fields in the key
    3. Identify naming conventions for primary key...

  • RE: Data Sprawl

    The more data technologies you use the more you see the borrowing of ideas.

    In fact it becomes easier to switch between technologies once you grasp the underlying principles. Then...

  • RE: Find Missing FK Constraints and Fixing them

    I'll give this one a go Steve. It dovetails nicely with some work I'm going to be doing on RedShift and Teradata.

  • RE: Data Liability

    I can see no winners in this other than the legal profession.

    People share so much on social media that I'm not sure what view would be taken for disclosure of...

  • RE: High Volume Reads and Writes

    If you are migrating to AWS I take it that your existing offering is either on your own physical tin or virtualised in your own data centre?

    I'd seriously recommend that...

  • RE: Who's a Good Developer?

    Thank God my last recruiter wasn't that shallow...

    I think you have the wrong end of the stick. If you have someone so objectionable that even the most affable member...

  • RE: Who's a Good Developer?

    I've interviewed loads of staff over the years including a few technically brilliant ones that were rejected unanimously by myself and whichever colleague was interviewing with me.

    • Technically brilliant but would...

    • RE: ER Modeling

      The point that keeps cropping up here is that anERD document is useful in the short term until the individual learns the system. The benefit the individual gets from the...

    • RE: ER Modeling

      The whole point of these models is that they are communication tools and I've found that people generally want one and curse the fact that one doesn't exist but are...

    • RE: Working with People

      I have Aspergers. I have had to learn to think about peoples motives and what will enable them to understand my point of view and to accept that even...

    • RE: NoSQL inside SQL Server

      I think the first thing to do is look at your use case, identify the pain points and see if the proposed solution addresses more pain than it solves.

      OLTP does...

    • RE: Adjusting Model

      Where there are utility procs such as those used to test for absent clustered indexes, primary keys, use of reserved words etc it makes sense to install these in the...

    • RE: The Case for Upgrading

      I'd say that a business should upgrade at the latest time possible but while it is still a choice rather than a diktat. An upgrade should take place when...

    • Viewing 15 posts - 1,396 through 1,410 (of 3,617 total)