learn.microsoft.com

My work is primarily in Microsoft’s ecosystem, so learning Copilot usage in VS Code is pretty important. If not for my own productivity gains, then for having knowledgeable conversations with coworkers about using LLMs as a SWE. Copilot-Powered Scenarios AI Code Completions I’ve found code completions more distracting than useful. Probably because I already have an idea of what I want to type, and Copilot’s hallucinations slow me down....

Aggregation functions allow you to group and combine data from multiple rows into a summary value. contains the database referenced in this document. Use the summarize operator Find the number of events by state. State TotalStorms TEXAS 4,701 KANSAS 3,166 … … StormEvents | summarize TotalStorms = count() by State summarize groups together rows based on the by clause and uses the aggregation function to combine each group into a single row....

contains the database referenced in this document. Count rows How many storm records are there in the table? Count 59066 StormEvents | count count returns a table with a single column and a single row containing the count of the remaining rows. The output is not a scalar value. See a sample of data Sample N rows from the StormEvents table....

A Kusto query is a read-only request that processes data that is organized into a hierarchy of databases, tables, and columns, similar to SQL. Query statements are separated by a ;, and only affect the query at hand. There are 3 kinds of user query statements: tabular expression statements, let statements, and set statements. The most common kind is the tabular expression statement where the input and the output consist of tables....

When you compile code for the runtime, it is converted into common intermediate language (CIL) and placed inside a portable executable (PE) file along with metadata generated by the compiler. Attributes allow you to place extra descriptive information into metadata that can be extracted using runtime reflection services. Example of reflection in C#: All types descended from the System.Object base class (the root of the type hierarchy in .NET) inherit the GetType() method....

#code-hygiene Pick up from: IEEE’s International Conference on Software Maintenance Improving Code: The (Mis)perception of Quality Metrics Springer’s Software Quality Journal On Abstractions If you find yourself adding more parameters and if-statements to an existing abstraction, is the abstraction still apt? Why not remove the old abstraction and re-extract a new [more apt] abstraction? Devs frequently succumb to the sunken cost fallacy thinking that there must have been a reason that the code was written in a certain way....