Skip to content

Instantly share code, notes, and snippets.

View joelverhagen's full-sized avatar

Joel Verhagen joelverhagen

View GitHub Profile
@joelverhagen
joelverhagen / AppInsightsDataSize.kql
Created October 1, 2023 18:25
Determine what telemetry is taking up the most space in Application Insights
let since = ago(1d);
let bucket = 5m;
let dt = datatable(table: string)[];
dt
| union (availabilityResults | where timestamp > since | summarize sum(estimate_data_size(*)) by bin(timestamp, bucket), cloud_RoleName | extend table = "availabilityResults")
| union (browserTimings | where timestamp > since | summarize sum(estimate_data_size(*)) by bin(timestamp, bucket), cloud_RoleName | extend table = "browserTimings")
| union (customEvents | where timestamp > since | summarize sum(estimate_data_size(*)) by bin(timestamp, bucket), cloud_RoleName | extend table = "customEvents")
| union (customMetrics | where timestamp > since | summarize sum(estimate_data_size(*)) by bin(timestamp, bucket), cloud_RoleName | extend table = "customMetrics")
| union (dependencies | where timestamp > since | summarize sum(estimate_data_size(*)) by bin(timestamp, bucket), cloud_RoleName | extend table = "dependencies")
| union (exceptions | where timestamp > since | summarize sum(estimate_data_size(*)) by bin(timestamp, bucket), clou
@joelverhagen
joelverhagen / train-caged.lua
Created August 21, 2023 17:20
DFHack script train-caged: Marks all caged, trainable creatures for training
-- Marks all caged, trainable creatures for training.
-- Author: Joel Verhagen (@joelverhagen on GitHub)
local utils = require('utils')
function getTrainingAssignment(unit)
local training_assignment, _, _ = utils.binsearch(
df.global.plotinfo.equipment.training_assignments,
unit.id,
'animal_id')
using System.Globalization;
using System.Net.Http.Headers;
using System.Text;
using System.Text.Json;
using System.Text.Json.Serialization;
using CsvHelper;
using CsvHelper.Configuration;
using CsvHelper.Configuration.Attributes;
using CsvHelper.TypeConversion;
using System.Diagnostics;
using System.Net;
using System.Text;
var sw = Stopwatch.StartNew();
string? previousRequest = null;
string? previousResponse = null;
while (true)
{
using var httpClient = new HttpClient();
@joelverhagen
joelverhagen / chart.png
Last active March 12, 2021 19:59
orleans runs
chart.png
Id Version
2.0.0-alpha1 2.0.0-alpha1
AbstractUltraGrid 1.0.0
AbstractUltraGrid 1.0.1
Acheve.AspNet.TestHost.Security 1.0.0-rc1-final
Acr.BarCodes.TEMP 3.2.0
Adform.Advertising.SDK 2.0.1
Adform.Advertising.SDK 2.0.2
Adform.Advertising.SDK 2.0.2.1
Adform.Advertising.SDK 2.0.3
@joelverhagen
joelverhagen / AuthHelper.cs
Created February 27, 2021 01:16
Manual validate AAD OAuth 2.0 JWT in Azure Functions
using System.Threading.Tasks;
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.Logging;
using System.Security.Claims;
using Microsoft.IdentityModel.Protocols.OpenIdConnect;
using Microsoft.IdentityModel.Protocols;
using Microsoft.IdentityModel.Tokens;
using System.IdentityModel.Tokens.Jwt;
using System.Linq;
using System.Collections.Concurrent;
using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using Microsoft.WindowsAzure.Storage;
using Microsoft.WindowsAzure.Storage.Table;
namespace EntityLimits
{
class Program
{
@joelverhagen
joelverhagen / Output.txt
Created January 10, 2021 07:06
Entity limits
Size: 1048488 (1048576 - 1048488 = 88)... success!
Size: 1048489 (1048576 - 1048489 = 87)... Bad Request
public class AsyncDisposableTest : IAsyncDisposable, IDisposable
{
private readonly ILogger<AsyncDisposableTest> _logger;
public AsyncDisposableTest(ILogger<AsyncDisposableTest> logger)
{
_logger = logger;
_logger.LogWarning("CREATED");
}