Forum Replies Created

Viewing 15 posts - 4,381 through 4,395 (of 6,041 total)

  • RE: How do you approach undocumented code?

    sqldriver (10/6/2014)


    Eric M Russell (10/6/2014)


    sqldriver (10/6/2014)


    At what point do you decide to throw it in and start over from scratch? This thing uses 38 tables, countless temp tables, 47 stored...

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

  • RE: How do you approach undocumented code?

    sqldriver (10/6/2014)


    At what point do you decide to throw it in and start over from scratch? This thing uses 38 tables, countless temp tables, 47 stored procs of varying length,...

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

  • RE: How do you approach undocumented code?

    sqldriver (10/6/2014)


    If you're tasked with debugging/troubleshooting?

    Specifically:

    Assigning workable values to parameters/finding out where they're passed from or stored

    Heavy use of temp tables/table variables/real tables that get truncated

    Verifying results

    Bonus points if it's...

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

  • RE: The Next Five Years

    Azure first gave us the ability to create a database, as opposed to just a key value store.

    Steve, perhaps you meant to say: "Azure first gave us (SQL...

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

  • RE: Life Logging

    webrunner (10/1/2014)


    Interesting idea, thanks for the post.

    I think human memory plus a written journal of some kind could handle a lot of the "non-quant" parts of life.

    And about the quant...

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

  • RE: Life Logging

    Maybe it’s a good idea for programmers or DBAs. What if you could have all the code you'd ever written?

    Who knows, maybe your employer is already recording your every...

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

  • RE: The Value of Data

    xsevensinzx (9/30/2014)


    I didn't really agree with this article because I felt it put too much emphasis on predictive or making decisions rather than mentioning data that represent results.

    For me, making...

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

  • RE: Why do they not listen?

    GilaMonster (9/30/2014)


    Eric M Russell (9/30/2014)


    So, if a DBA removes an end user from the DBO role in the process of performing a migration to the next release of SQL Server,...

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

  • RE: Why do they not listen?

    So, if a DBA removes an end user from the DBO role in the process of performing a migration to the next release of SQL Server, and then he says...

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

  • RE: Why do they not listen?

    Jeff Moden (9/30/2014)


    Eric M Russell (9/30/2014)


    GilaMonster (9/30/2014)


    Eric M Russell (9/29/2014)


    Upgrading to the next release of SQL Server offers an excellent pretext for removing unneeded permissions from app developers.

    "I'm so sorry,...

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

  • RE: Why do they not listen?

    Jeff Moden (9/30/2014)


    GilaMonster (9/30/2014)


    Eric M Russell (9/29/2014)


    Upgrading to the next release of SQL Server offers an excellent pretext for removing unneeded permissions from app developers.

    "I'm so sorry, I know it...

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

  • RE: Why do they not listen?

    GilaMonster (9/30/2014)


    Eric M Russell (9/29/2014)


    Upgrading to the next release of SQL Server offers an excellent pretext for removing unneeded permissions from app developers.

    "I'm so sorry, I know it a pain...

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

  • RE: Why do they not listen?

    Jeff Moden (9/29/2014)


    Alvin Ramard (9/29/2014)


    Luis Cazares (9/29/2014)


    Revoke create and alter permissions and create policies to apply changes to the database. People will start to do things right when they're enforced.

    That...

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

  • RE: Why do they not listen?

    Unfortunately, many IT shops are operated like a sausage factory. The DBA is just there to mop up spills and bang the data meat-grinder with a wrench when it breaks...

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

  • RE: Why do they not listen?

    Koen Verbeeck (9/29/2014)


    Hire an overpriced consultant. Chances are they'll listen to him/her...

    Quit, and then be that overpriced consultant.

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

Viewing 15 posts - 4,381 through 4,395 (of 6,041 total)