Tag Archives: Performance

The Growth of IQP

Posted on October 3, 2022 by way0utwest

When Microsoft started to talk about Intelligent Query Processing (IQP) before SQL Server 2017, I wasn’t sure what to think. There was a diagram with 20 things on it, and only 5 were highlighted (you can see that in the … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Growth of IQP

The Need for 256GB

Posted on January 21, 2022 by way0utwest

I have seen a few people call for raising the RAM limit in the Standard Edition of SQL Server. In 2016, Aaron Bertrand voiced this, and for 2019, Glenn Berry asked that the limit be raised to 256GB. In the … Continue reading →

Posted in Editorial | Tagged , , | 5 Comments

The PASS Pro Videos are Live

Posted on February 22, 2021 by way0utwest

The PASS Pro program was an interesting educational opportunity that came out last year. A number of people subscribed, including me. I did this more to support the org than for the content, but I did want to watch the … Continue reading →

Posted in Blog | Tagged , , , , , | Comments Off on The PASS Pro Videos are Live

The Database Server Upgrade for Let’s Encrypt

Posted on February 1, 2021 by way0utwest

Let’s Encrypt is a service the provides free SSL certificates for web servers. They have grown from a small project to a critical service on the web that serves over 235mm clients each year, and often issues over 1.5mm certificates … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Database Server Upgrade for Let’s Encrypt