Jason Horner jasonhorner

General Rules

names are case-insensitive (so using lowercase throughout is fine).

maximum number of characters in a table name: 260.

all object names must begin with a letter, number, or underscore (_).

the following characters are not allowed: . + ? / < > * % & : \

2022 Stumpjumper Expert Suspension & Tire Settings

Suspension Components

Rear Shock: FOX FLOAT DPS Performance Elite, Rx Trail Tune, EVOL Air sleeve, 3-position adjustment w/ Open Mode Adjustment, 190x45mm
Fork: FOX FLOAT 34 Performance Elite, GRIP2 damper, 15x110mm, 44mm offset, 140mm travel

Component	Setting	Manufacturer (240 lbs, 6'5")	Current	Bike Park	Trail

Overview

Documentation for setting up streamdeck

references

https://den.dev/blog/streamdeck-windows-store-apps/

https://www.linkedin.com/pulse/stream-deck-microsoft-teams-what-can-you-do-marcel-alberts/?articleId=6663050621916114944 https://adam.ac/blog/stream-deck-for-developers/

Azure Data Engineering Resources

Basics

https://docs.microsoft.com/en-us/learn/paths/azure-for-the-data-engineer/

https://docs.microsoft.com/en-us/azure/cloud-adoption-framework/

Azure Data Factory

Azure SQL Monitoring Resources

This page has the resources for my Azure SQL Monitoring Talk

Abstract

Migrating you on-premises Database to Azure SQL DB was easy but now comes the hard part how do you setup monitoring and alerts? While there are many 3rd party options, let's have a look at what comes standard with Azure:

Using Azure Log Analytics to monitor databases
How can you be sure your azure SQL Database isn't under or over allocated, so that your costs are optimized.
How can you project what future costs may be.

	@echo off
	echo Installing applications using winget...

	set apps=(
	"Microsoft.AzureCLI"
	"Microsoft.AzureDeveloperCLI"
	"Git.Git"
	"GitHub.cli"
	"Microsoft.Powershell"
	"Microsoft.WindowsTerminal"

	#!/bin/bash

	# Input parameters
	userPrincipalName=$1
	tenantId=$2

	# Check if both parameters are provided
	if [ -z "$userPrincipalName" ] \|\| [ -z "$tenantId" ]; then
	echo "Usage: $0 <userPrincipalName> <tenantId>"
	exit 1

	with schema_info
	as (SELECT t.table_catalog
	, t.table_schema
	, t.table_name
	, (
	SELECT
	c.column_name,
	c.ordinal_position,
	CASE
	WHEN c.DATA_TYPE IN ('varchar', 'char', 'varbinary', 'binary') THEN

	DECLARE @SchemaName sysname = ''
	, @TableName sysname = '';

	WITH pk /* Primary Keys */
	AS ( SELECT t.object_id
	, pkc.column_id
	, ic.index_column_id pk_index
	, pk.name AS pk_name
	FROM sys.tables t
	JOIN sys.schemas s ON s.schema_id = t.schema_id

	DECLARE @SchemaName sysname = ''
	, @TableName sysname = '';

	WITH pk /* Primary Keys */
	AS ( SELECT t.object_id
	, pkc.column_id
	, ic.index_column_id pk_index
	, pk.name AS pk_name
	FROM sys.tables t
	JOIN sys.schemas s ON s.schema_id = t.schema_id