Monthly Archives: August 2022

  1. When good enough is good enough

    3

    August 30, 2022 by Kenneth Fisher

    Any time I’ve learned about the optimizer there is always one important thing that’s brought up. The optimizer is not …
    Continue reading

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

  3. Why is security important in a dev environment?

    6

    August 23, 2022 by Kenneth Fisher

    I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve …
    Continue reading

  4. New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo

    Leave a comment

    August 18, 2022 by Kenneth Fisher

    I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in …
    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. 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

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

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

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

Join 3,738 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013