Tag Archives: best practices

  1. Deleting a lot of data

    5

    April 12, 2018 by Kenneth Fisher

    I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
    Continue reading

  2. What’s the difference between Files and Filegroups?

    Leave a comment

    March 28, 2018 by Kenneth Fisher

    tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct …
    Continue reading

  3. GDPR – After the restore

    1

    March 19, 2018 by Kenneth Fisher

    I joined in on an interesting conversation the other day on twitter. It was about some unusual ramifications of GDPR …
    Continue reading

  4. Simply Debugging

    3

    March 7, 2018 by Kenneth Fisher

    Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it …
    Continue reading

  5. The default filegroup, and why you should care.

    2

    February 19, 2018 by Kenneth Fisher

    You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index …
    Continue reading

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

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

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

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

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

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

Join 2,176 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013