Windows7 connect to wifi before login

You cannot log in windows 7 with domain user because wireless is not connected on logon screen. This feature is available only on Windows 8, 8.1, 10.

Workaround:
1. Open REGEDIT HKLM\Software\Microsoft\Windows\CurrentVersion\Run

2. Add new string value with any name you like. For example WiFiAutoconnect

3. Set value: %comspec% /c netsh wlan connect name="MyWiFi" where MyWiFi is your wireless profile name.

Find nonregular character in text file

Open file with Notepad++ -> Find
Enable regular expression.
Search for [^\x00-\x7F]+

Reset windows network state

Reset WINSOCK entries to installation defaults : netsh winsock reset catalog (change static ip to dhcp)
Reset TCP/IP stack to installation defaults : netsh int ip reset reset.log
Flush DNS resolver cache : ipconfig /flushdns 
Renew DNS client registration and refresh DHCP leases : ipconfig /registerdns 
Flush routing table : route /f (reboot required)

Change windows 8/2012 network status.

Change windows 8/2012 network status from Public to Private
Open PowerShell
Get your NIC InterfaceIndex: Get-NetConnectionProfile
Change status: Set-NetConnectionProfile  -InterfaceIndex XXX -NetworkCategory Private

Test server dns and dc

Open command prompt

NLTEST /DSGETDC:dc.local

DCDIAG /TEST:DNS /V /E /S:dc.local

Excel revers find()

B1 - cell with string
~ - replace tilde(~) with other symbol if your string contains it.

=IF(ISERROR(FIND("\",B1)),B1,RIGHT(B1,LEN(B1)-FIND("~",SUBSTITUTE(B1,"\","~",LEN(B1)-LEN(SUBSTITUTE(B1,"\",""))))))

Windows 7/8 enable NumLock on startup

Press Win + R and type in Regedit
Navigate to registry key HKEY_USERS\Default\Control Panel\Keyboard 
Right click on the “InitialKeyboardIndicators”, select Modify and change Value data to 2.