Batch Mode Processing in SQL Server 2019
Oct 12,
2021
Early in 2019, when SQL Server 2019 was a community preview and the release was many many months away, we were delighted to see the performance benefits of batch mode processing for some row data queries (that is, no columnstore index). Now that SQL Server 2019 is being installed in production facilities, and batch mode […]
Some Query Hints: Undocumented, But Interesting
,
2021
It’s a commonly held misconception, even among some knowledgeable SQL folks, that the SQL Server query optimizer evaluates different ways of executing a query and goes with the query plan that yields the lowest estimated cost. As is often the case with misconceptions, this one is not so much wrong as a bit oversimplified. The […]
Azure Data Studio: SQL Server Tools for Linux, Mac, Oh, and Windows Too
,
2021
What do you do if you think the name “SQL Operations Studio” isn’t quite exciting enough? Well, if you are Microsoft, you lead with the word “Azure”, as in Azure Data Studio. Don’t be fooled by the name; The Azure Data Studio is not just for Azure databases. Not only is the Azure Data Studio […]
SQL Server 2019: Can Dr. Froid Help Your User Defined Functions?
,
2021
User-defined scalar functions (scalar UDFs) provide SQL Server developers with an excellent means to organizer and re-use code. Unfortunately, these benefits often come at the price of poor, and in many cases horrendous, performance. Froid is a technology arising from Microsoft Research that addresses these performance problems with novel optimization techniques. In SQL Server 2019, […]
Keras: One API to Rule them All
Mar 5,
2020
What is Keras? Keras is an API (Application Program Interface) originally designed to allow Tensorflow developers to focus their attention on the deep-learning problems of interest rather than concern themselves with minutia of how to implement their model in Tensorflow. Since its introduction, Keras has become popular not only among Tensorflow developers, but also among […]