Skip to content

Instantly share code, notes, and snippets.

View jrichardsz's full-sized avatar

JRichardsz jrichardsz

View GitHub Profile
@jrichardsz
jrichardsz / how to organize flow diagrams in a portal.md
Created July 19, 2024 15:04
how to organize flow diagrams in a portal

create-a-dashboard

DROP table IF EXISTS [t1];
CREATE TABLE t1 (
    id int IDENTITY(1,1) NOT NULL,
    c1 int DEFAULT 0,
    c2 int DEFAULT 0,
    c3 int DEFAULT 0
);

DROP table IF EXISTS [t1_history];
@jrichardsz
jrichardsz / generate pfx openssl.md
Created July 3, 2024 23:19
generate pfx openssl
@jrichardsz
jrichardsz / One Liner to Download the Latest Release from Github Repo.md
Created June 16, 2024 00:51
One Liner to Download the Latest Release from Github Repo

Using this repository https://api.github.com/repos/pdf2htmlEX/pdf2htmlEX/releases/latest

With an asset name of pdf2htmlEX-0.18.8.rc1-master-20200630-Ubuntu-bionic-x86_64.deb

{
  "url": "https://api.github.com/repos/pdf2htmlEX/pdf2htmlEX/releases/assets/22311467",
  "id": 22311467,
  "node_id": "MDEyOlJlbGVhc2VBc3NldDIyMzExNDY3",
  "name": "pdf2htmlEX-0.18.8.rc1-master-20200630-Ubuntu-bionic-x86_64.deb",
@jrichardsz
jrichardsz / google search, googlesearch.md
Created June 9, 2024 22:09
google search, googlesearch

http://www.chromakinetics.com/ebooks/searchGoogleMP3

Searching Google for Music - Advanced Guide

This How-To will teach you how to use google to find mp3s. This How-To will be highly pragmatic and will focus on the hows and not the wherefores of the various search strings. Index

  1. Key
  2. Directories
@jrichardsz
jrichardsz / sql server snippets.md
Last active June 3, 2024 18:05
sql server snippets, sqlserver

Create database, user able to login using [SQL Server Authentication mode]

USE [master]
CREATE DATABASE UmbrellaEnterprises
GO
USE [UmbrellaEnterprises]
CREATE LOGIN support_team_login WITH PASSWORD = 'P@ssW0rd';
CREATE USER support_team_usr FOR LOGIN support_team_login;
EXEC sp_addrolemember N'db_owner', N'support_team_usr'

Hello world (very simple)

exports.handler = async (event, context) => {
    return {
        statusCode: 200,
        body: {
            code: 200,
 message: "Deployment has started. Check your mail."
@jrichardsz
jrichardsz / who is lock me.md
Last active June 17, 2024 22:08
windows tunning snippets