1. What’s a differential backup?

    Leave a comment

    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

  2. Read-only tables

    3

    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

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

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

  5. #SQLCareer 4/4 January 2nd 2019

    Leave a comment

    January 10, 2019 by Kenneth Fisher

    Last July (yes, it’s taken me 5+ months to finally finish this) Steve Jones (b/t) suggested that it might be …
    Continue reading

  6. Automation starts by doing something once, very very carefully: T-SQL Tuesday #110

    5

    January 8, 2019 by Kenneth Fisher

    After a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s …
    Continue reading

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

  8. Using Microsoft Learn

    2

    December 31, 2018 by Kenneth Fisher

    I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows …
    Continue reading

  9. Identity in a SELECT

    4

    December 19, 2018 by Kenneth Fisher

    Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here? …
    Continue reading

  10. Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

    4

    December 17, 2018 by Kenneth Fisher

    Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error …
    Continue reading

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

Join 2,474 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013