1. What’s next? Pt 2

    Leave a comment

    June 30, 2022 by Kenneth Fisher

    Well, it’s only been about a week and a half but here’s an update. First a piece of advice. You …
    Continue reading

  2. Creating a Database Audit Specification can create new users & schemas in the background

    1

    June 28, 2022 by Kenneth Fisher

    I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on …
    Continue reading

  3. How do I tell if identity_insert is turned on and if so what table?

    Leave a comment

    June 24, 2022 by Kenneth Fisher

    TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty …
    Continue reading

  4. What’s next?

    11

    June 21, 2022 by Kenneth Fisher

    As I’m sure a fair number of you already know I was told my position had been eliminated. They are …
    Continue reading

  5. Too many coding standards : T-SQL Tuesday #151

    4

    June 14, 2022 by Kenneth Fisher

    One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding …
    Continue reading

  6. SQL Homework – June 2022 – SQL Agent Jobs continued.

    2

    June 2, 2022 by Kenneth Fisher

    A few years ago I gave you homework to create a SQL Agent Job and play with it a little …
    Continue reading

  7. An auditing mind set

    2

    May 31, 2022 by Kenneth Fisher

    I little while back I presented at Pass Data Community Summit. Specifically the presentation was Auditing your data and data …
    Continue reading

  8. Reblog from Brent Ozar: Designing a Data Model for Gender and Sexuality (Oh And Also, I’m Pansexual)

    2

    May 25, 2022 by Kenneth Fisher

    This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s …
    Continue reading

  9. TSQL Tuesday #150: Your first technical job. Rollup.

    2

    May 24, 2022 by Kenneth Fisher

    This months subject for T-SQL Tuesday was Your first technical job. I have to say I really really enjoyed reading …
    Continue reading

  10. Running dynamic SQL in a different database

    9

    May 19, 2022 by Kenneth Fisher

    This is one of those things that on hindsight was a stupid problem, but still cost me hours and a …
    Continue reading

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

Join 3,692 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013