Forum Replies Created

Viewing 15 posts - 736 through 750 (of 3,677 total)

  • RE: Internal Controls

    I would be curious to know from those who have audit controls whether they are something formally recognised and supported.  I know of DBAs who maintain a log of queries...

  • RE: Wasted Work

    Steve Jones - SSC Editor - Wednesday, November 7, 2018 2:34 PM

    ZZartin - Wednesday, November 7, 2018...

  • RE: Wasted Work

    Rod at work - Wednesday, November 7, 2018 9:35 AM

    . As a team we've worked on more than 4, but I think...

  • RE: Wasted Work

    The DevOps culture is great for allowing a continuous stream of small enhancements and improvements.  Switching across to such a culture is more difficult than it appears as small incremental...

  • RE: The SQL Twilight Zone

    When you move away from SQL Server you realise just what a fantastic product it is, how good the query optimiser is, its integration with a wide toolset, the ease...

  • RE: Rolling Back Migrations

    I'd agree with Steve.  Migrations work in the vast majority of cases.  The problem is that non-DBAs have a tendency to think the majority of cases = all cases.

  • RE: Using Tools That Fit

    With regard to software and letting people or teams choose their tools, assuming pricing and licencing aren't issues integration becomes a sticking point.
    Team A use a different setup to...

  • RE: Using Tools That Fit

    At work it's a Macbook pro with that odd little bluetooth keyboard and Apple mouse and dual 22" monitors.
    I'm not keen on the keyboard and the mouse brings back...

  • RE: Self-Healing ETL

    xsevensinzx - Thursday, October 11, 2018 5:37 AM

    This is why I switched primarily to Python for all of my ETL so we...

  • RE: Self-Healing ETL

    Back in the days of DTS it was possible to write a DTS package that altered itself dynamically at run time.  We tended to use this for things that are...

  • RE: Single Source of Truth

    Single source of truth in one place is a paradigm that has scuppered many an EDW project.  Once an organisation gets beyond a certain scale you are on a hiding...

  • RE: Are Indexes Actually Changes to the System?

    If I was worried about disk space then I'd be asking how I could determine the amount of disk space required through automated means. Similarly could I predict locking/blocking impact...

  • RE: Give Up on Natural Primary Keys

    xsevensinzx - Sunday, September 30, 2018 5:18 PM

    In the data warehouse side, it makes sense to use surrogate keys and replace all...

  • RE: Fitting Into RAM

    The ridiculous thing is that the cost of peoples time arguing why you shouldn't have a RAM upgrade far exceeds the cost of that RAM upgrade.
    The cost of nursemaiding...

  • RE: Dark Reads During a Migration

    Given the variability of the preferences this could be an example of where a good Document DB would fit.
    Of course if youvyo got the in-house skills to keep an...

Viewing 15 posts - 736 through 750 (of 3,677 total)