Tag Archives: microsoft sql server

  1. Viewing errors with extended events

    1

    September 27, 2022 by Kenneth Fisher

    A little while back I came across this post: Identifying failed queries with extended events. It has a script to …
    Continue reading

  2. Conversion Precedence

    1

    September 20, 2022 by Kenneth Fisher

    Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the …
    Continue reading

  3. Creating a SERVER ROLE created a LOGIN as well.

    1

    September 6, 2022 by Kenneth Fisher

    One of my co-workers came to me the other day and told me that they found their network id as …
    Continue reading

  4. Explicit and implicit datatype conversions

    2

    August 25, 2022 by Kenneth Fisher

    Did you know that 1/2=0? If you didn’t you could be in for some interesting surprises. 1/2 returns 0 because …
    Continue reading

  5. SQL Server Query Tuning and Optimization by Benjamin Nevarez

    Leave a comment

    August 16, 2022 by Kenneth Fisher

    I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin Nevarez (blog|twitter), and as soon as …
    Continue reading

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

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

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

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

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

Join 3,746 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013