Monthly Archives: May 2016

  1. I hate saying no

    2

    May 31, 2016 by Kenneth Fisher

    I really do. There is a joke that DBAs say no to everything and there is some truth to that. …
    Continue reading

  2. Connecting to Azure SQL Database

    2

    May 25, 2016 by Kenneth Fisher

    Recently I created my first Azure SQL Database. But now I need to connect to it. You can connect using …
    Continue reading

  3. Master_Views: master_objects, master_tables, etc

    Leave a comment

    May 23, 2016 by Kenneth Fisher

    There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of …
    Continue reading

  4. Re-Evaluating Best Practices

    6

    May 18, 2016 by Kenneth Fisher

    I was reading a blog post from my friend Randolph West (b/t) on Best Practices and a thought struck me. …
    Continue reading

  5. RAID your backups

    6

    May 16, 2016 by Kenneth Fisher

    Let’s start with a very brief definition of some RAID levels. RAID 0 : Stripe your data across multiple disks. …
    Continue reading

  6. Comparing the contents of two tables

    13

    May 12, 2016 by Kenneth Fisher

    I’ve been working on tuning a query for the last week and I’ve had to make several changes to the …
    Continue reading

  7. Getting your Cloud on

    3

    May 10, 2016 by Kenneth Fisher

    One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that …
    Continue reading

  8. Grant Deny Revoke

    2

    May 4, 2016 by Kenneth Fisher

    It always amazes me how often these three commands get confused. Heck it amazes me how long I confused them. …
    Continue reading

  9. Remove files from a filegroup

    Leave a comment

    May 2, 2016 by Kenneth Fisher

    You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve …
    Continue reading

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

Join 1,626 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013