MSSQL Extension

Found a cool extension for VS Code for developing SQL: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-develop-use-vscode

Passed

After months of study (and failing more than once) I have finally passed exam 70-489: Developing Microsoft SharePoint Server 2013 Advanced Solutions

Windows Update Stuck

While installing updates on my virtual Windows Server 2016 machine, Windows Update got stuck at the preparing to install updates phase and just sat at 0%. I was able to fix it by running the following commands in an elevated command prompt:

net stop wuauserv
net start wuauserv

Slow Windows Server 2016 Performance

I had terrible performance when accessing a Hyper-V guest running Windows Server 2016. We're talking minutes to just log on, let alone run programs. I found that is you disable the following settings on the host and guest network cards, everything speeds right up:

• IPv4 Checksum Offload
• Large Receive Offload
• Large Send Offload
• TCP Checksum Offload

Course Approved

My first PluralSight course has been approved. It is titled "Developing with the SharePoint Framework and AngularJS".  Should be ready around October.

Shutdown Event Tracker

Just found this handy PowerShell script that disables that annoying little popup that asks you why you are shutting Windows down (that's my business, Windows doesn't need to know):

if ( -Not (Test-Path 'registry::HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows NT\Reliability'))
{
New-Item -Path 'registry::HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows NT' -Name Reliability -Force
}

Set-ItemProperty -Path 'registry::HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows NT\Reliability' -Name ShutdownReasonOn -Value 0