Skip to content

Instantly share code, notes, and snippets.

View ssippe's full-sized avatar

Sam Sippe ssippe

  • Reckon
  • Gold Coast, Australia
View GitHub Profile
@ssippe
ssippe / CreateDashboard.cs
Created March 21, 2024 02:05
Create a dashboard per asg that beats the 3hr aws CloudWatch Metrics Insights limit
using Amazon.AutoScaling.Model;
using Amazon.AutoScaling;
using Amazon.CloudWatch.Model;
using Amazon;
using Amazon.CloudWatch;
const string Namespace = "CWAgent";
const string MetricName = "TCPv4 Connections Established";
@ssippe
ssippe / aws-env-var.ps1
Last active March 21, 2023 02:19
aws-env-var.ps1
aws --profile r1-dev sso login; aws --profile r1-dev configure export-credentials --format powershell | iex; devenv
using System.Linq;
using System.Data.Entity.Infrastructure;
using System;
namespace Reckon.Data.EF
{
public static class DbChangeTrackerExtension
{
/// <summary>
/// Get a summary of Tracked Changes on a DbContext.ChangeTracker
parse @message "* * * * * * * * * * * * * * *" as
date, time, s_ip, cs_method, cs_uri_stem, cs_uri_query, s_port, cs_username, c_ip, cs_User_Agent, cs_Referer, sc_status, sc_substatus, sc_win32_status, time_taken
| display @timestamp,cs_method, cs_uri_stem, time_taken
| filter time_taken > 1000
| sort @timestamp desc
| limit 20
@ssippe
ssippe / wslNotes.md
Last active June 22, 2021 06:08
wsl notes
namespace cs9test
{
// @jbogard "it looks like the "immutable-by-default" behavior of C# 9 records is really only with the compact positional syntax, not with just the "record" keyword"
// https://twitter.com/jbogard/status/1321120266676850688
/// <summary>
/// immutable with compact positional syntax
/// </summary>
public record Person(string FirstName, string LastName);
@ssippe
ssippe / listGen.cs
Created September 14, 2020 23:53
List generation with optional members and immutable variables
static IReadOnlyList<int> GenerateList(int option)
{
IEnumerable<int> F()
{
if (option > 0)
yield return 1;
if (option > 1)
yield return 2;
if (option > 3)
yield return 3;
steps:
- task: DotNetCoreCLI@2
inputs:
command: 'custom'
custom: 'tool'
arguments: 'update dotnet-script -g'
displayName: 'install dotnet-script'
- task: CmdLine@2
inputs:
@ssippe
ssippe / mysqlColumnLists.sql
Created June 4, 2020 00:40
mysql column lists for inserts updates etc.
set @schema = 'base_sms';
set @table = 'bayprofiles';
-- column name list
select concat('`',COLUMN_NAME,'`,') as columnName from information_schema.COLUMNS where TABLE_SCHEMA=@schema and TABLE_NAME=@table;
/*
`id`,
`profileId`,
`bayWidth`,
`bcolumn`,
@ssippe
ssippe / mysqlForceDeadlock.sql
Created May 15, 2020 05:31
mysql force deadlock
-- replace:
-- `log` with any table
-- `id` with any index column on that table
-- 81272070 with an existing value in the index column
-- in connection #1
START transaction;
select * from log where id = 81272070 FOR UPDATE;
select sleep(40);
COMMIT;