SQL Performance

JANUARY 12, 2022

Despite the poor performance, working on the solution is an interesting exercise. The outer query also computes the trade quantity in the SELECT list as: LEAST ( EndDemand , EndSupply ) - GREATEST ( StartDemand , StartSupply ) If you're using Azure SQL, you can use this expression.

Code 116

Code Servers Performance Azure 116

Particular Software

DECEMBER 9, 2019

Decommissioning Public102 was an exercise in the mundane, gradually transitioning tiny service after tiny service to new homes over the course of weeks, as the development schedule allowed. Ultimately, this comes down to testing. Even if you don't know there will be a problem, test anyway, early in your development cycle.

Wireless 52

Wireless DevOps Infrastructure Network 52

SQL Server According to Bob

JUNE 27, 2016

Before joining Microsoft in 1994 I worked at State Farm Insurance and spent several years in a testing group and later joined a team developing applications against SQL Server for OS/2. We are a bit wiser (you could take that as older) now and we don’t wait until 5 o’clock but we still try everything we can think of to exercise the code.

Servers 40

Servers Games Azure Testing 40

SQL Server According to Bob

JANUARY 26, 2017

“Quick question about a behavior we’re seeing at a customer and in testing. Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest.

Servers 40

Servers Database Azure Cache 40

SQL Performance

JUNE 10, 2020

In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. Now this could be a really interesting exercise in patients to hit F5 repeatedly until you get two different values. Notice in the plan that the function is invoked only once.

C++ 109

C++ Database Servers Code 109

SQL Performance

JUNE 10, 2020

In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. Now this could be a really interesting exercise in patients to hit F5 repeatedly until you get two different values. Notice in the plan that the function is invoked only once.

C++ 93

C++ Database Servers Code 93

Tasktop

OCTOBER 30, 2019

Over the past months, a number of Fortune 100 customers have been testing Tasktop’s new product, Tasktop Viz , to implement the Flow Framework. In the first 24 hours, 1,247 defects automatically flowed from ServiceNow to Azure DevOps. Day two recap.

DevOps 8

DevOps Education Innovation Metrics 8

O'Reilly

NOVEMBER 26, 2024

Examples of these skills are artificial intelligence (prompt engineering, GPT, and PyTorch), cloud (Amazon EC2, AWS Lambda, and Microsoft’s Azure AZ-900 certification), Rust, and MLOps. Some other topics with high completion rates are ggplot (for data-driven graphics in R), GitHub, and Selenium (a software testing framework).

Education 108

Education Azure AWS Java 108