Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 3,662 total)

  • RE: Write tsqlt tests for stored procedures.

    Steve Jones - SSC Editor (5/5/2014)


    TDD is head, or haven't you heard 🙂 - http://david.heinemeierhansson.com/2014/tdd-is-dead-long-live-testing.html

    https://watirmelon.com/2012/01/31/introducing-the-software-testing-ice-cream-cone/

    While I understand David's frustrations in two years since the article was written I don't see...

  • RE: Losing All Traces of Data

    The ability to remove an individual's records is a legal requirement in the UK. It is intended for data that is inaccurate or false.

    We also have the European Court of...

  • RE: Cloud First

    Steve Jones - SSC Editor (4/27/2016)


    Cloud providers know this, but I think they'd like to get you to code better. After all, they want successes and more customers, not just...

  • RE: Problems With RAND()

    I've just submitted the article on RAND(). I'm not sure if it is quite what you had in mind.

    Let me know and I will alter it as you see...

  • RE: Cloud First

    I've been using AWS for the past 12 months. The beauty of it is that I have more time using the DB rather than managing it.

    I'd be fascinated to...

  • RE: A nice whistle and flute

    There are things that today are regarded as antipatterns which were the only reliable way of doing things yesterday.

    Some features that are regarded as horrors (cursors and triggers spring to...

  • RE: The Pen Test

    Gary Varga (4/25/2016)


    Iwas Bornready (4/25/2016)


    Management accepts that security is a priority when the company gets breached.

    ....or more like...

    Management accepts that security should have been a priority when the company gets...

  • RE: Problems With RAND()

    When you say "Same seed over time" are you talking about using time as a seed?

    I'll take this article on.

  • RE: Backups Over Time

    I went to an interesting talk given by a guy from NASA. One of the problems NASA face is that they may have a scientist whose lifes work is...

  • RE: Backups Over Time

    One problem with backups is what you have to do if you get a requirement to expunge a person's records.

    The risk is that you accidentally restore expunged records from an...

  • RE: Crack that Encrypted Data

    Gary Varga (4/19/2016)


    This is a wicked problem and is just like the ransom dilemma with human hostages

    Given that medical records have been a victim of Ransonware I think there...

  • RE: The Hidden Trigger

    I can understand deficits in terms of SSMS giving visibility but SYS.objects and INFORMATION_SCHEMA. ROUTINES identify them pretty clearly and also reveal lineage.

    I'm reluctant to condemn any weapon in my...

  • RE: Successful Projects

    Steve Jones - SSC Editor (4/14/2016)


    Agile isn't about just coding whatever. Many of the successful projects are engineered well, with thought about what they will do, and won't do,...

  • RE: Successful Projects

    I've spent a lot of time analysing project failures.

    It boils down to breakdowns in communication and failure to check that communication has been successful.

    Requirements are given and received. Both...

  • RE: How Much Can You Learn?

    The value I got out of the original SQL Server 6.5 courses (admin & developer) was largely due to the trainer who was 26 but looked 46. He'd been...

Viewing 15 posts - 1,291 through 1,305 (of 3,662 total)