Skip to content

Instantly share code, notes, and snippets.

@chilismaug
chilismaug / Garage Band for Vinyl.md
Last active September 22, 2022 00:20
Garage Band for Vinyl Rip n Split Tip

Garage Band for Vinyl Tip

Select input - USB audio device or line in (from turntable)

  • New music project
  • Tracks / New Basic Track - (on an existing song project, delete all instrument tracks)
    • Master track / tempo lowest - 40
    • Control / metronome off
    • Track properties - set Monitoring on/off to taste
  • Record
@chilismaug
chilismaug / BroadbandArsTech.md
Last active November 1, 2021 16:37
Broadband Price Talk

Negotiating with ISPs: Sam Machkovech on being nice to sales reps

When I saw this topic bubble up over email and chat channels, I didn't think I had much to add. I, too, have done the ISP renegotiation song and dance many times, though this was usually because I was trying to manage what few pennies I had. (The struggling freelance life I used to lead before getting full-time work, and all that.)

But I remembered one resumé point I have that other Ars colleagues don't—previously working in a customer service phone farm. It was the only steady paying gig I could find straight out of college, and I learned a lot... about never wanting that kind of job again.

It did train me to be kinder and more direct in a phone-service world, at least. To that end, here are my tips so that you too might have a better time on the phone or in a text chat with an ISP agent.

  1. Know your leverage: Do you have other Internet options? It doesn't matter if they are hot garbage with upload speeds that would make NetZero bl
@chilismaug
chilismaug / WorkflowDescrip-DNA-CloseoutZeroBal.md
Last active September 21, 2021 00:29
Automated WorkflowDescrip-DNA-CloseoutZeroBal.md

Automated Workflow Design sketch

Closeout - Inactive Zero Balance

Prerequisites

  • Test Data - How to build a list of target accounts, search tools, criteria
  • Test User - provide a user account that can enter the override credential

Inputs and possible decision points:

@chilismaug
chilismaug / Account Closeout RPA PoC - project puzzle pieces.md
Last active November 5, 2021 20:17
Account Closeout RPA PoC - project puzzle pieces.md

Account Closeout RPA Pilot - project puzzle pieces

  • RPA test system
    • VM
    • installed RPAutomation
    • license
      • Ms PAD attended order
      • License enabled for CR's windows account
  • test DNA user accounts
  • Ryan added override role to my account for poc
@chilismaug
chilismaug / Tableau DS Cert Topics Kramlist.md.md
Last active February 22, 2021 01:27
Tableau DS Cert Topics Kramlist.md

AZ-900 KRAMFEST TOPICS.

  • Contoso needs to protect their Internet-facing web apps from common attacks. Which Azure service(s) offers out-of-box implementation of Open Web Application Security Project (OWASP) vulnerability rule sets? Choose all that apply?

See "Azure Web Application Firewall (WAF) on Azure Application Gateway" at https://docs.microsoft.com/en-us/azure/web-application-firewall/ag/ag-overview and "Azure Front Door" at https://docs.microsoft.com/en-us/azure/frontdoor/front-door-application-security [Describe Security, Privacy, Compliance, and Trust]

MS docs: There are two options when applying WAF policies in Azure. WAF with Azure Front Door is a globally distributed, edge security solution. WAF with Application Gateway is a regional, dedicated solution. Uhhh.. ...does that mean Front Door is more expensive?


@chilismaug
chilismaug / StubServer-OpenWeather.py
Last active January 18, 2021 00:05 — forked from 0atman/static-json.py
Simple flask-restful GET json stub with a "current weather" OpenWeather response doc
from flask import Flask
from flask_restful import Resource, Api
app = Flask(__name__)
api = Api(app)
class SimpleRest(Resource):
def get(self):
return {
@chilismaug
chilismaug / Hierarchy.sql
Last active September 16, 2021 14:50
Phil Factor's Hiearchy table declaration for JSON werx
-- Create the data type IF EXISTS (SELECT * FROM sys.types WHERE name LIKE 'Hierarchy')
DROP TYPE dbo.Hierarchy
go
/****** Object: UserDefinedTableType [dbo].[Hierarchy] Script Date: 4/14/2020 8:48:14 AM ******/
CREATE TYPE [dbo].[Hierarchy] AS TABLE(
[element_id] [int] NOT NULL, /* internal surrogate primary key gives the order of parsing and the list order */
[sequenceNo] [int] NULL, /* the place in the sequence for the element */
[parent_ID] [int] NULL, /* if the element has a parent then it is in this column. The document is the ultimate parent, so you can get the structure from recursing from the document */
[Object_ID] [int] NULL, /* each list or object has an object id. This ties all elements to a parent. Lists are treated as objects here */
@chilismaug
chilismaug / JSONEscaped.sql
Created April 14, 2020 12:10
Phil Factor utility function to clean the json strings
IF OBJECT_ID (N'dbo.JSONEscaped') IS NOT NULL DROP FUNCTION dbo.JSONEscaped
GO
CREATE FUNCTION [dbo].[JSONEscaped] ( /* this is a simple utility function that takes a SQL String with all its clobber and outputs it as a sting with all the JSON escape sequences in it.*/
@Unescaped NVARCHAR(MAX) --a string with maybe characters that will break json
)
RETURNS NVARCHAR(MAX)
AS
BEGIN
SELECT @Unescaped = REPLACE(@Unescaped, FROMString, TOString)