jasonhorner

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

jasonhorner

@echo off
echo Installing applications using winget...

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

jasonhorner

#!/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

jasonhorner

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/

jasonhorner

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

jasonhorner

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

jasonhorner

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.

jasonhorner

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

jasonhorner

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

jasonhorner

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