Tag Archives: Performance

The Growth of IQP

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 , | Leave a comment

The Need for 256GB

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

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

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