Author Archives: Kenneth Fisher

  1. DBA Myths: Can a differential backup get bigger than the full backup?

    4

    February 14, 2019 by Kenneth Fisher

    The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one …
    Continue reading

  2. What is your why?: T-SQL Tuesday #111

    Leave a comment

    February 12, 2019 by Kenneth Fisher

    This month Andy Leonard (b/t) wants to know why we do what we do. Funnily enough, this is something I …
    Continue reading

  3. Using Cloud Academy

    Leave a comment

    February 6, 2019 by Kenneth Fisher

    The other day I talked about using Microsoft Learn. Well, honestly, Cloud Academy is the learning tool I’ve been using …
    Continue reading

  4. SQL Homework – February 2019 – Instance configurations

    4

    February 4, 2019 by Kenneth Fisher

    This homework series really has two purposes. It’s a primer for beginners. These are tasks I think most if not …
    Continue reading

  5. See SQL Run

    5

    January 30, 2019 by Kenneth Fisher

    Note: I am perfectly aware of my ability as an artist so let the ribbing begin 🙂

  6. Disabling Indexes

    1

    January 28, 2019 by Kenneth Fisher

    Indexes are probably the number one tool we have to improve performance. That said, there are times when we want …
    Continue reading

  7. What’s a differential backup?

    1

    January 23, 2019 by Kenneth Fisher

    Of the different basic types of backups (full, differential and log) I find the differential the most interesting, and frequently …
    Continue reading

  8. Read-only tables

    4

    January 21, 2019 by Kenneth Fisher

    Sometimes you need a table that is read only. You don’t want anyone to be able to write to it …
    Continue reading

  9. Controlling the firewall for an Azure SQL DB via T-SQL

    2

    January 16, 2019 by Kenneth Fisher

    The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I …
    Continue reading

  10. SQL Bits 2019: The Great Data Heist

    Leave a comment

    January 14, 2019 by Kenneth Fisher

    SQL Bits is almost here! It’s February 27th to March 2nd. SQL Bits is one of the most popular SQL …
    Continue reading

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

Join 2,484 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013