Category Archives: Microsoft SQL Server

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

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

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

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

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

    1

    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. Creating a Database Audit Specification can create new users & schemas in the background

    2

    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

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

    4

    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

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

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

Join 3,746 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013