1. Using DBCC CLONEDATABASE to create a schema only copy of your database.

    Leave a comment

    August 11, 2022 by Kenneth Fisher

    DBCC CLONEDATABASE is one of those features that I don’t use often but it’s really cool when I need it. …
    Continue reading

  2. Visiting with DBAs at midnight : T-SQL Tuesday #153

    Leave a comment

    August 9, 2022 by Kenneth Fisher

    🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our host for this month’s episode of …
    Continue reading

  3. What’s next III

    2

    August 4, 2022 by Kenneth Fisher

    In case you didn’t know I was given notice about a month and a half ago. Since I’ve talked about …
    Continue reading

  4. SQL Homework – August 2022 – Replication part 1

    Leave a comment

    August 2, 2022 by Kenneth Fisher

    You’ll hear a lot of people complain about replication. Including me. That said, replication is an amazing tool. There really …
    Continue reading

  5. Perspective

    1

    July 28, 2022 by Kenneth Fisher

    I recently passed the second anniversary of the start of my stay in the hospital. A lot has happened since …
    Continue reading

  6. EXECUTE AS USER vs EXECUTE AS LOGIN

    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

  7. SSMS Put pinned tabs in their own row

    2

    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

  8. #PowershellBasics: Multi-line commands

    2

    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

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

    1

    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

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

    2

    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

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

Join 3,703 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013