Skip to content

Instantly share code, notes, and snippets.

View mikebesso's full-sized avatar

mikebesso

2 followers · 2 following
View GitHub Profile
@mikebesso
mikebesso / destinct-counting.md
Created April 29, 2026 23:05
example table for distinct-counting
Work Country Work Type Division Aggregation Level Work Item Count Client Count Client Count Is Additive?
Canada Inspection East Detail 145 100 No
Canada Inspection West Detail 112 80 No
Canada Inspection (All Divisions) Subtotal 257 155 No
Canada Consulting East Detail 74 60 No
Canada Consulting West Detail
@mikebesso
mikebesso / split_string_medium.md
Created December 29, 2024 15:58
@mikebesso
mikebesso / bcp-parameters-ingest-tsv.md
Last active December 28, 2024 17:14
Parameter Value Description
before in SCHEMA.TABLE Ingestion destination
after in FILEPATH Source Data (a TSV file)
-S SERVER Server URL
-D DATABASE Name of database
-U USERNAME SQL Username
-P PASSWORD SQL Password
-u . Trust server certificate.
-c . Everything is character data.
@mikebesso
mikebesso / matching-schema-1.md
Last active December 27, 2024 23:38 
---
title: From Data Mart
---

erDiagram

Account {
	uniqueidentifier Account_GUID PK
	nvarchar(255) Company_Name
@mikebesso
mikebesso / types-of-accents.md
Created December 22, 2024 15:09
Character Description Unicode HTML Entity
á lowercase a acute U+00E1 á
é lowercase e acute U+00E9 é
í lowercase i acute U+00ED í
ó lowercase o acute U+00F3 ó
ú lowercase u acute U+00FA ú
à lowercase a grave U+00E0 à
è lowercase e grave U+00E8 è
ì lowercase i grave U+00EC ì
@mikebesso
mikebesso / types-of-quotes.md
Created December 22, 2024 15:07
Character Description Unicode HTML Entity
' Straight Single Quote/Apostrophe U+0027 '
' Left Single Quote U+2018 ‘
' Right Single Quote U+2019 ’
" Straight Double Quote U+0022 "
" Left Double Quote U+201C “
" Right Double Quote U+201D ”
‹ Single Left-Pointing Angle Quote U+2039 «
› Single Right-Pointing Angle Quote U+203A »
@mikebesso
mikebesso / types-of-hyphens.md
Created December 22, 2024 14:38
Character Description Unicode HTML Entity
- Standard keyboard hyphen used for hyphenation and compound words U+002D -
– Slightly longer, used for ranges and relationships (e.g., 1990–2000) U+2013 –
— Longest dash, used for breaks in thought or emphasis in sentences U+2014 —
­ Invisible until needed for line breaks, used in web content U+00AD ­
‑ Prevents line breaks, keeps hyphenated terms together U+2011 ‑
‒ Width matches numerals, used in tabular number layouts U+2012 ‒
@mikebesso
mikebesso / types-of-spaces.csv
Last active December 21, 2024 23:33
Space Type Description Unicode HTML Entity
Zero Width Space aasdf adf adsf
@mikebesso
mikebesso / types-of-spaces.md
Last active December 22, 2024 14:33
Space Type Description Unicode HTML Entity
Space Regular space character U+0020  
Zero Width Space Invisible, allows line breaks U+200B ​
Em Space Width of letter 'M' U+2003  
En Space Width of letter 'N' U+2002  
Thin Space 1/5 or 1/6 of em space U+2009  
Hair Space Thinnest possible space U+200A  
Figure Space Width of monospace numeral U+2007  
Punctuation Space Width of period U+2008  
@mikebesso
mikebesso / html2tagList.R
Created August 7, 2017 20:20 — forked from yonicd/html2tagList.R
convert raw html to htmltools::tagList
#'@title html2tagList
#'@description convert raw html to htmltools tagList
#'@param x character vector of html
#'@examples
#'
#'x<-'<h1>Title</h1>
#' <h2>Header text</h2>
#' <p>Text here</p>
#' <h1>Title</h1>
#' <h2>Header text</h2>