Monthly Archives: March 2017

  1. Increasing and decreasing the performance level of your Azure SQL Database

    Leave a comment

    March 29, 2017 by Kenneth Fisher

    One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability …
    Continue reading

  2. sp_SrvPermissions & sp_DBPermissions V6.0 Finally!

    5

    March 27, 2017 by Kenneth Fisher

    It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well, …
    Continue reading

  3. Creating a list of random numbers

    1

    March 22, 2017 by Kenneth Fisher

    I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly …
    Continue reading

  4. The parts of an object’s name

    Leave a comment

    March 20, 2017 by Kenneth Fisher

    Any object within a database in SQL Server has what is called a four part name. Which rather implies four …
    Continue reading

  5. Compressed backup errors and TF 3042

    6

    March 16, 2017 by Kenneth Fisher

    Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time …
    Continue reading

  6. Limits vs Goals

    1

    March 14, 2017 by Kenneth Fisher

    It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us. …
    Continue reading

  7. Review of Azure Fundamentals class on Openedx

    Leave a comment

    March 8, 2017 by Kenneth Fisher

    My company has recently adopted a Cloud first attitude. Now that’s different from Microsoft’s Cloud first. Microsoft is putting new …
    Continue reading

  8. Using GROUP BY instead of DISTINCT

    6

    March 6, 2017 by Kenneth Fisher

    Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers …
    Continue reading

  9. Event storming! It’s raining emails!

    3

    March 1, 2017 by Kenneth Fisher

    One of the most common ways to get an event notification is by email. So what happens when you get …
    Continue reading

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

Join 1,672 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013