SQL Performance

APRIL 10, 2019

The ISO/IEC 9075:2016 standard, or SQL:2016 in short, introduces support for a profound concept called Row Pattern Recognition (RPR) in SQL. You can find coverage of RPR, including illustrated examples, in a 90-page technical report ISO/IEC TR 19075-5 (available for free). Feature R010, “Row pattern recognition: FROM clause”.

C++ 73

C++ Virtualization Servers Code 73

Alex Russell

APRIL 29, 2021

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. The information it captures is, however, available going back somewhat further, providing a fuller picture of the trend lines of engine completeness. Count of APIs available from JavaScript by Web Confluence.

Media 145

Media Games Education Engineering 145

SQL Server According to Bob

APRIL 25, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40

SQL Server According to Bob

APRIL 21, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. We now have a new way of instrumenting the backup/restore process for any database or transaction log. OK, this is very cool.

Servers 40

Servers Database Processing Virtualization 40

The Symphonia

DECEMBER 6, 2017

Correspondingly, 3GB functions should see a 2x CPU performance improvement over 1.5GB Lambdas, but this is through doubling the number of cores the function has access to, rather than double the virtualized time-slices. Traffic shaping / canary deployment was pre-announced at Serverless Conf NYC in October, and this is now available.

Serverless 40

Serverless Lambda AWS Traffic 40

Alex Russell

MAY 9, 2022

It's challenging for teams climbing the maturity ladder to sift through the many available browser and tool-vendor data points to understand which ones to measure and manage. They are charting a course based on better information because they are cognizant that it is both valuable and potentially available. but against what baseline?

Performance 86

Performance Latency Metrics Engineering 86

O'Reilly

APRIL 5, 2023

confirmation bias, hindsight bias, availability bias, anchoring bias, selection bias, loss aversion bias, outlier bias, survivorship bias, omitted variable bias and many, many others). Worse yet, the AI’s bias would likely find its way into the system’s database and follow the students from one class to the next.

Artificial Intelligence 110

Artificial Intelligence Energy Government Virtualization 110