1. 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

  2. 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

  3. 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

  4. 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

  5. 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

  6. Server vs Instance. A rant.

    2

    July 29, 2021 by Kenneth Fisher

    It’s a SQL Server Instance not a SQL Server. The product is SQL Server. The installed copy is an Instance. …
    Continue reading

  7. Speaking: In person vs webinars vs recordings

    Leave a comment

    July 27, 2021 by Kenneth Fisher

    I don’t speak all that often. A few times a year for the most part. Because of that I don’t …
    Continue reading

  8. How do I unlock a SQL Server Login using T-SQL (without changing the password)?

    1

    July 22, 2021 by Kenneth Fisher

    We recently had an application login (SQL Server authenticated) in one of our training environments start locking out on a …
    Continue reading

  9. Experiment: If I have Dynamic Data Masking enabled will BCP pull the non masked data.

    2

    July 20, 2021 by Kenneth Fisher

    Hypothesis: If I have Dynamic Data Masking enabled on a column then when I use something like BCP to pull …
    Continue reading

  10. Padding a string in SQL Server

    1

    July 15, 2021 by Kenneth Fisher

    I’ve been working on converting a piece of DB2 code into T-SQL and one of the functions I had to …
    Continue reading

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

Join 3,570 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013