Leave a comment

    July 26, 2022 by Kenneth Fisher

    I use impersonation a lot. It’s a really easy way to check if someone has the permissions they are supposed …
    Continue reading

  2. SSMS Put pinned tabs in their own row


    July 21, 2022 by Kenneth Fisher

    A while back (6 years ago 😲) I talked about how you can change the behavior of SSMS so that …
    Continue reading

  3. #PowershellBasics: Multi-line commands


    July 19, 2022 by Kenneth Fisher

    When I’m sharing code one of the things I hate most is having a scroll bar along the bottom. I …
    Continue reading

  4. #PowershellBasics: Write the output to a file.


    July 14, 2022 by Kenneth Fisher

    Last week I posted about a request to get a list of services. The first problem I ran into was …
    Continue reading

  5. You’re doing your POC wrong! : T-SQL Tuesday #152


    July 12, 2022 by Kenneth Fisher

    It’s T-SQL Tuesday again! Deborah Melkin (blog|twitter) is our host this month and she’d like to hear our opinion. A …
    Continue reading

  6. #PowershellBasics: Expanding the column width to avoid truncation


    July 7, 2022 by Kenneth Fisher

    I was recently asked to get a list of all of the services running on one of the boxes we …
    Continue reading

  7. SQL Homework – July 2022 – Update your resume.


    July 5, 2022 by Kenneth Fisher

    Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to …
    Continue reading

  8. What’s next? Pt 2


    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

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


    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

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


    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

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