Monthly Archives: March 2018

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


    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

  2. Introducing The Blame Game


    March 26, 2018 by Kenneth Fisher

    Introducing the Blame Game! Someone has messed up the new anatomy application’s (Mr. Body) performance and no one is willing …
    Continue reading

  3. Moving a table using BCP and native format


    March 21, 2018 by Kenneth Fisher

    You need to move a table from one instance to another with the following requirements: The instances are on separate …
    Continue reading

  4. GDPR – After the restore


    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



    March 15, 2018 by Kenneth Fisher

    I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular …
    Continue reading

  6. A look back from the future. – TSQL Tuesday #100


    March 13, 2018 by Kenneth Fisher

    The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact …
    Continue reading

  7. Simply Debugging


    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

  8. SQL Homework – March 2018 – Recovery Objectives


    March 5, 2018 by Kenneth Fisher

    My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases …
    Continue reading

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

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013