Tag Archives: best practices

  1. Why is security important in a dev environment?


    August 23, 2022 by Kenneth Fisher

    I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve …
    Continue reading

  2. Work requests: It’s broke. Fix it.


    August 12, 2021 by Kenneth Fisher

    Many years ago I was given a work request that literally just said: It’s broke. Fix it. I’m sure you …
    Continue reading

  3. All triggers have to be able to handle multiple row operations.


    September 3, 2020 by Kenneth Fisher

    Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s …
    Continue reading

  4. Blogging and coding best practices

    Leave a comment

    September 25, 2019 by Kenneth Fisher

    I had a discussion a while back, I think it was with Grant Fritchey (b/t) but I just can’t remember. …
    Continue reading

  5. Debugging techniques (focusing on T-SQL)


    September 23, 2019 by Kenneth Fisher

    tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: …
    Continue reading

  6. Deleting a lot of data


    April 12, 2018 by Kenneth Fisher

    I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
    Continue reading

  7. What’s the difference between Files and Filegroups?


    March 28, 2018 by Kenneth Fisher

    tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct …
    Continue reading

  8. GDPR – After the restore


    March 19, 2018 by Kenneth Fisher

    I joined in on an interesting conversation the other day on twitter. It was about some unusual ramifications of GDPR …
    Continue reading

  9. Simply Debugging


    March 7, 2018 by Kenneth Fisher

    Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it …
    Continue reading

  10. The default filegroup, and why you should care.


    February 19, 2018 by Kenneth Fisher

    You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013