Monthly Archives: August 2021

  1. Rule 1: Be kind, be polite.

    2

    August 31, 2021 by Kenneth Fisher

    In my house, this is rule one. Sometimes it’s my wife or I reminding our kids, sometimes it’s them reminding …
    Continue reading

  2. The sysname datatype defaults to not NULL.

    3

    August 26, 2021 by Kenneth Fisher

    The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for …
    Continue reading

  3. Error: Cannot continue the execution because the session is in the kill state.

    Leave a comment

    August 24, 2021 by Kenneth Fisher

    This was a rather interesting error. I’d certainly never seen it before, and based on one of the answers to …
    Continue reading

  4. A new presentation on Auditing your databases

    Leave a comment

    August 19, 2021 by Kenneth Fisher

    I’m giving a presentation at the PASS Data Community Summit 2021 being put on by Redgate! It’s going to be …
    Continue reading

  5. Experiment: Does sp_recompile on a table update associated views.

    2

    August 17, 2021 by Kenneth Fisher

    tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the …
    Continue reading

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

    3

    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

  7. Thoughts on a work/life balance – Spend Wisely : T-SQL Tuesday #141

    1

    August 10, 2021 by Kenneth Fisher

    Wow, it’s TSQL Tuesday again! Tjay Belt (blog|twitter) is our host this month and he’d like us to talk about …
    Continue reading

  8. Interview Tip: Know your resume

    Leave a comment

    August 5, 2021 by Kenneth Fisher

    Seriously. Make a point of reading your resume before submitting it, and again before an interview. I’ve been helping with …
    Continue reading

  9. SQL Homework – August 2021 – Security Standards

    1

    August 3, 2021 by Kenneth Fisher

    A few years back (wow time flies) I had you Work with Security. It’s been a while so if you …
    Continue reading

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

Join 3,569 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013