Joao C Costa joaocc

## .mateuszwenus--save_restore_dependencies.sql
Forked from https://gist.github.com/mateuszwenus/

## README.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                joaocc
                / README.md
            
            
              Created
              March 15, 2023 21:25
                — forked from forivall/README.md
            
              
                git-credential-manager reaper script
              
          
    Simple background script to kill git-credential-manager when it hits the 100% cpu bug

  
## UUID_v7_for_Postgres.sql
-- Based off IETF draft, https://datatracker.ietf.org/doc/draft-peabody-dispatch-new-uuid-format/

create or replace function uuid_generate_v7()
returns uuid
as $$
declare
  unix_ts_ms bytea;
  uuid_bytes bytea;
begin
  unix_ts_ms = substring(int8send(floor(extract(epoch from clock_timestamp()) * 1000)::bigint) from 3);

## check_multi_namespaces.sh
#!/usr/bin/env bash
set -eo pipefail
set -x

while [ "$1" != "" ]
do
    bash secrets_without_certificates.sh -n "$1"
    shift
done

## acr-cleanup.sh
ACR_NAME="${ACR_NAME:-myacr}"

az acr show-usage -n  "${ACR_NAME}" -o json

DK_IMAGES=(
    "azureml/azureml_00000000111111110000000011111111"
    "azureml/azureml_11111111000000001111111100000000"
)
for i in "${DK_IMAGES[@]}"
do

## AzureAD-Get-AAD-Roles.ps1
# https://arindamhazra.com/list-azure-ad-roles-and-role-assignments/

Connect-AzureAD

$allAZADUserWithRoleMapping = @()

# Get all Azure AD roles and loop through members of those roles
# Add user/service principal details in psObject array
Get-AzureADDirectoryRoleTemplate | ForEach-Object{
    $roleName = $_.DisplayName

## gist:3ca400e0750556597dc86fe1f341d123
# USE WITH CARE... NO WARRANTIES!!!
# THESE ARE NOTES ON HOW TO CLEANUP OR REMOVE SOME KEXTS
# AS A MATTER OF FACT, YOUR SYSTEM MAY START MALFUNCTIONING
# IF YOU DO FOLLOW THIS WITHOUT UNDERSTANDING WHAT YOU ARE DOING

(after the disclaimer, just some notes for my future reference)
(glad if they help you, but taking no responsibility)

this came across as the need to cleanup some Auxiliary Kernel Collection (AuxKC)
* com.samsung.portablessd.driver

## info.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                joaocc
                / info.md
            
            
              Created
              October 29, 2021 12:19
            
              
                macOS high CPU usage from kernelmanagerd / com.apple.applefsplaceholder
              
          
    Reference info

macOS 11.6.1 (20G224) (bigSur) on ARM M1
The following will be running stuff every minute
sudo kmutil log stream

Info here:

  
## inf_refresh_recursive.sql
-- Refresh materialized views recursively

-- DEPENDS:
-- List the tables that a view depends on.
-- Thanks to Dave: http://stackoverflow.com/questions/4229468/getting-a-list-of-tables-that-a-view-table-depends-on-in-postgresql
create or replace function inf_view_dependencies(v text)
returns table (kind text, name text) as $$
SELECT     cl_d.relkind::text as kind
        ,  cl_d.relname::text AS name
FROM pg_rewrite AS r

## fulldump.sh
#!/bin/bash
#  $Id: fulldump.sh,v 1.4 2013/10/31 14:25:36 postgres Exp postgres $
#  $Source: /var/lib/postgresql/8.2/RCS/fulldump.sh,v $
#  $Log: fulldump.sh,v $
#
#  Revision 1.4  2013/10/31 14:25:36  postgres
#  Removed pg_dump '-D' option, added $RETVAL
#  default value for the initial case - MS.
#
#  Revision 1.3  2007/09/28 13:29:07  postgres
	-- Based off IETF draft, https://datatracker.ietf.org/doc/draft-peabody-dispatch-new-uuid-format/

	create or replace function uuid_generate_v7()
	returns uuid
	as $$
	declare
	unix_ts_ms bytea;
	uuid_bytes bytea;
	begin
	unix_ts_ms = substring(int8send(floor(extract(epoch from clock_timestamp()) * 1000)::bigint) from 3);
	#!/usr/bin/env bash
	set -eo pipefail
	set -x

	while [ "$1" != "" ]
	do
	bash secrets_without_certificates.sh -n "$1"
	shift
	done
	ACR_NAME="${ACR_NAME:-myacr}"

	az acr show-usage -n "${ACR_NAME}" -o json

	DK_IMAGES=(
	"azureml/azureml_00000000111111110000000011111111"
	"azureml/azureml_11111111000000001111111100000000"
	)
	for i in "${DK_IMAGES[@]}"
	do
	# https://arindamhazra.com/list-azure-ad-roles-and-role-assignments/

	Connect-AzureAD

	$allAZADUserWithRoleMapping = @()

	# Get all Azure AD roles and loop through members of those roles
	# Add user/service principal details in psObject array
	Get-AzureADDirectoryRoleTemplate \| ForEach-Object{
	$roleName = $_.DisplayName
	# USE WITH CARE... NO WARRANTIES!!!
	# THESE ARE NOTES ON HOW TO CLEANUP OR REMOVE SOME KEXTS
	# AS A MATTER OF FACT, YOUR SYSTEM MAY START MALFUNCTIONING
	# IF YOU DO FOLLOW THIS WITHOUT UNDERSTANDING WHAT YOU ARE DOING

	(after the disclaimer, just some notes for my future reference)
	(glad if they help you, but taking no responsibility)

	this came across as the need to cleanup some Auxiliary Kernel Collection (AuxKC)
	* com.samsung.portablessd.driver
	-- Refresh materialized views recursively

	-- DEPENDS:
	-- List the tables that a view depends on.
	-- Thanks to Dave: http://stackoverflow.com/questions/4229468/getting-a-list-of-tables-that-a-view-table-depends-on-in-postgresql
	create or replace function inf_view_dependencies(v text)
	returns table (kind text, name text) as $$
	SELECT cl_d.relkind::text as kind
	, cl_d.relname::text AS name
	FROM pg_rewrite AS r
	#!/bin/bash
	# $Id: fulldump.sh,v 1.4 2013/10/31 14:25:36 postgres Exp postgres $
	# $Source: /var/lib/postgresql/8.2/RCS/fulldump.sh,v $
	# $Log: fulldump.sh,v $
	#
	# Revision 1.4 2013/10/31 14:25:36 postgres
	# Removed pg_dump '-D' option, added $RETVAL
	# default value for the initial case - MS.
	#
	# Revision 1.3 2007/09/28 13:29:07 postgres