Tag Archives: best practices

  1. How to read a technical blog

    4

    January 17, 2018 by Kenneth Fisher

    There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If …
    Continue reading

  2. Who should own the database?

    6

    January 15, 2018 by Kenneth Fisher

    TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and …
    Continue reading

  3. Restrict the usage of a SQL Server Authenticated Application Id

    1

    December 6, 2017 by Kenneth Fisher

    SQL Server login ids may not be the most secure thing in the world but they are likely to be …
    Continue reading

  4. Closing all of the connections to a database

    3

    November 27, 2017 by Kenneth Fisher

    Doing a database restore may not be the most common task a database professional will ever do, but it’s a …
    Continue reading

  5. Why shouldn’t I shrink my database data file?

    2

    November 20, 2017 by Kenneth Fisher

    A while back I did a post about why you shouldn’t shrink your data file. This one is going to …
    Continue reading

  6. When is it a good idea to consolidate multiple instances?

    1

    October 23, 2017 by Kenneth Fisher

    In this age of cost-saving after cost-saving, one way you may be looking at saving money is by combining multiple …
    Continue reading

  7. sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)

    1

    October 11, 2017 by Kenneth Fisher

    I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into …
    Continue reading

  8. Small identity columns

    5

    October 9, 2017 by Kenneth Fisher

    We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small …
    Continue reading

  9. Do what I say, not what I do

    Leave a comment

    September 20, 2017 by Kenneth Fisher

    I told you not to use NOLOCK even though I use it sometimes. I told you not to shrink databases, …
    Continue reading

  10. Turning ANSI_PADDING off, and why you shouldn’t

    4

    June 15, 2017 by Kenneth Fisher

    I ran into an interesting error the other day while doing a partition switch. Partition switch failed because : column …
    Continue reading

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

Join 2,163 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013