dougwaldron

Check .NET Framework version from PowerShell

Get-ItemPropertyValue -LiteralPath 'HKLM:SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full' -Name Release

Compare the above result to this table.

dougwaldron

# Last time system was turned off
Get-WinEvent -MaxEvents 3 -FilterHashTable @{ProviderName='Microsoft-Windows-Kernel-Power';LogName='System'}

# Last time system was turned on
Get-WinEvent -MaxEvents 1 -FilterHashTable @{ProviderName='Microsoft-Windows-Power-Troubleshooter';LogName='System'}

dougwaldron

# Load omp theme
oh-my-posh init pwsh --config 'https://gist.githubusercontent.com/dougwaldron/8a84062beb55414d99bcdd5240e4f447/raw/32c1e20ab792340716d4fdcf4da6dc5527c794c3/doug.omp.json' | Invoke-Expression

# How to load one of the default themes instead:
# oh-my-posh --init --shell pwsh --config "$env:POSH_THEMES_PATH\powerlevel10k_lean.omp.json" | Invoke-Expression

# Load terminal icons
# Adds 900 ms to PWSH startup time!
# Import-Module -Name Terminal-Icons

dougwaldron

# 1. Make sure the Microsoft App Installer is installed:
#    https://www.microsoft.com/en-us/p/app-installer/9nblggh4nns1
# 2. Edit the list of apps to install.
# 3. Run this script as administrator.

Write-Output "Installing Apps"
$apps = @(
    @{name = "7zip.7zip" },
    @{name = "Adobe.Acrobat.Reader.64-bit" },
    @{name = "Axosoft.GitKraken" },

dougwaldron

Application Quality Goals

Overall application quality goes beyond implementing features and includes:

• Accessibility
• Usability
• Performance
• Security
• Reliability
• Maintainability

dougwaldron

wevtutil qe system "/q:*[System [(EventID=1074)]]" /rd:true /f:text /c:1

dougwaldron

# Workflow to register a new application deployment with Raygun.

# The workflow is triggered when a tag with the specified prefix is pushed to
# GitHub. The tag should be formatted as a prefix followed by the version
# number. For example: "prod/1.0.0"
#
# To use this workflow, you must:
#
# 1. Make sure the tag prefix is set correctly below. The default is "prod/".
#

dougwaldron

Remote Desktop shortcut	Description
Alt + Home	Start Menu
Alt + Page Up	Alt + Tab switcher
Alt + Page Down	Shift + Alt + Tab switcher
Alt + Insert	Cycle through open apps
Alt + Delete	Open the window menu of the active window
Ctrl + Alt + End	Ctrl + Alt + Del
Ctrl + Alt + Break	Toggle between full screen mode and windowed
Ctrl + Alt + Home	Activate connection bar in full-screen mode

dougwaldron

USE msdb
GO

-- List info on all failed SQL Server agent jobs

select j.name                                                                                  as JobName,
       h.step_name                                                                             as StepName,
       CONVERT(char(10), CAST(STR(h.run_date, 8, 0) AS datetime), 111)                         as RunDate,
       STUFF(STUFF(RIGHT('000000' + CAST(h.run_time AS varchar(6)), 6), 5, 0, ':'), 3, 0, ':') as RunTime,
       h.run_duration                                                                          as StepDuration,

dougwaldron

Oracle to SQL Server Migration Plan

Documentation

• Business processes
• Codebase
• Database
• Data flows

Infrastructure