Tag Archives: Microsoft SQL Server

  1. Why do I (they) own that database?

    2

    February 20, 2019 by Kenneth Fisher

    Ever looked at the list of databases and wonder why you own one of them? Or why some other user …
    Continue reading

  2. Error in SSMS: Attempted to read or write protected memory.

    2

    February 18, 2019 by Kenneth Fisher

    There are a lot of reasons to write a blog post. One of my favorites is when I’ve been asked …
    Continue reading

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

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

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

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

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

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

  10. SQL Homework – January 2019 – Baselines

    Leave a comment

    January 2, 2019 by Kenneth Fisher

    Happy New Year! Every year for New Years we all make a big deal of coming up with New Years …
    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