JosiahSiegel

# sudo apt-get install jq -y

# specifiy resource group name and days offset
resource_group=''
offset_days=90

# prevent override by checking if "created-by" tag exists
tag_search='properties.tags.\"created-by\"'

# fetch resource activites (last 90d)

JosiahSiegel

GitHub actions - get started

• Directory for GitHub objects: .github/workflows or .github/actions

Common workflow triggers

Run workflow on branch push

1. on any branch push

JosiahSiegel

1. Get local distro name

   wsl -l -v

    NAME            STATE           VERSION
    * Ubuntu-20.04    Running         2

JosiahSiegel

Keybase proof

I hereby claim:

• I am josiahsiegel on github.
• I am josiahsiegel (https://keybase.io/josiahsiegel) on keybase.
• I have a public key ASAVF-sHPe6ax0B95LQCZnveCJrqlTQdg2usNTPbopJFMAo

To claim this, I am signing this object:

JosiahSiegel

FROM node:latest
RUN apt-get update && apt-get install -y vim

EXPOSE 8000

RUN mkdir /home/node/.npm-global
ENV PATH=/home/node/.npm-global/bin:$PATH
ENV NPM_CONFIG_PREFIX=/home/node/.npm-global

RUN npm install -g @angular/cli

JosiahSiegel

FROM node:latest
RUN apt-get update && apt-get install -y vim

EXPOSE 4200

RUN mkdir /home/node/.npm-global
ENV PATH=/home/node/.npm-global/bin:$PATH
ENV NPM_CONFIG_PREFIX=/home/node/.npm-global

RUN npm install -g @angular/cli

JosiahSiegel

<policies>
    <inbound>
        <base />
        <set-backend-service id="apim-generated-policy" backend-id="la" />
        <set-variable name="dataset" value="@(context.Request.Url.Query.GetValueOrDefault("dataset"))" />
        <choose>
            <when condition="@((string)context.Variables["dataset"] == "employees")">
                <set-variable name="loopinterval" value="2" />
            </when>
            <when condition="@((string)context.Variables["dataset"] == "locations")">

JosiahSiegel

DECLARE @spid INT
DECLARE @kill_spid NVARCHAR(100)
 
DECLARE running_jobs CURSOR FOR
 
    SELECT 
    req.[session_id]
    FROM sys.dm_exec_requests req
    LEFT JOIN sys.dm_exec_sessions ses ON ses.session_id = req.session_id
    LEFT JOIN msdb.dbo.sysjobs jobs ON SUBSTRING(ISNULL(ses.[program_name],''),CHARINDEX('0x', ISNULL(ses.[program_name],'')) + 18, 16) = SUBSTRING(REPLACE(ISNULL(jobs.[job_id],''), '-',''),17,16)

JosiahSiegel

--Reference:
--https://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/

USE [master]; 
GO  
SET NOCOUNT ON 

-- 1 - Variable declaration 
DECLARE @dbName sysname 
DECLARE @backupPath NVARCHAR(500) 

JosiahSiegel

-- ========================================================================================
-- Create User as DBO template for Azure SQL Database and Azure SQL Data Warehouse Database
-- ========================================================================================
-- For login, create a user in the database
CREATE USER [my-login]
	FROM EXTERNAL PROVIDER
	WITH DEFAULT_SCHEMA = dbo
GO

EXEC sp_addrolemember N'db_owner', N'my-login'