Get-ItemPropertyValue -LiteralPath 'HKLM:SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full' -Name ReleaseCompare the above result to this table.
| # Alias source: https://gist.github.com/dougwaldron/b120b8a44766a5c9f0461a747359b905 | |
| # Use `git config --edit --global` to open and edit the .gitconfig file | |
| [alias] | |
| # Edit global config (this document) | |
| cg = config --edit --global | |
| # Edit local config | |
| cl = config --edit | |
| # Stage all and show status |
Get-ItemPropertyValue -LiteralPath 'HKLM:SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full' -Name ReleaseCompare the above result to this table.
| # 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'} |
| # Load omp theme | |
| oh-my-posh init pwsh --config 'D:\apps\oh-my-posh\doug.omp.json' | Invoke-Expression |
| # 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 = "AgileBits.1Password" }, | |
| @{name = "Axosoft.GitKraken" }, |
| wevtutil qe system "/q:*[System [(EventID=1074)]]" /rd:true /f:text /c:1 |
| 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 |
| 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, |