Slow in the Application, Fast in SSMS? – Understanding Performance Mysteries
More on the topic of SQL Server performance. A long in depth article by a SQL Server MVP.
NumPy: How to Get Indices Where Value is True
It probably helped answer a small “how to” question I had.
PlantUML
A declarative language for describing diagrams as code. Has support for many UML diagram types as well as many other types of diagram.
A Visual Studio Code extension is available.
Diagrams can be generated using the command line or via one of many integrations.
Direct link to PDF guide for uncluttered reading: https://pdf.plantuml.net/PlantUML_Language_Reference_Guide_en.pdf
PlantUML has many similarities with Mermaid, another Diagrams as Code language.
UML Specification
Or for a lighter introduction to UML, try Martin Fowler’s UML Distilled. It may be nearly two decades old, but it is still a good brief introduction and reference.
DotNext
.NEXT (dotNext) is a set of powerful libraries aimed to improve development productivity and extend .NET API with unique features.”
Azure Functions warmup trigger
Some code I was reading used a warmup trigger, so I looked up what it did.
Await anything
I saw a method that was implemented as the following single line:
public async Task<Thing> GetThing() => await _thingContainer;
I was puzzled as to how one could await a member variable. As the article explains, one can await anything provided a GetAwaiter method is implemented for the object’s type. Even an extension method will do.
(async/await, and the article, are over a decade old, but how often do many of us need to think about it beyond simply putting the keywords in the correct place?)
Cancellation in Managed Threads
Thinking about await got me thinking about Task in general, and in particular how little I know. For example, I had seen cancellation tokens used many times, but had no real idea about how they work or how to correct use them.
OData search.in function in Azure Cognitive Search
Saw the search.in function in a query for the first time, so I checked the syntax.
T-levels Parents’ Guide
Until very recently, I, perhaps like many, had never heard of T-levels. T-levels are a new UK “high school” qualification. The first cohort graduated this summer.
See also https://www.tlevels.gov.uk/ and https://www.gov.uk/government/publications/introduction-of-t-levels/introduction-of-t-levels.
AsciiDoc
AsciiDoc is plain text markup language somewhat similar to Markdown.
AsciiDoc is a single standard, unlike Markdown with its many flavours!
AsciiDoc claims that it “provides all the essential elements in technical writing out of the box”.
An AsciiDoc Visual Studio Code extension is available.
Big Village Small Barn 