How to add function list in Notepad++

In SAS Proc SQL code like this can be use to create a function list in NotePad++. It makes code navigation easy.

CREATE TABLE WORK.TEMP_SECMOVE_1 AS

Now go to Notepad++. open up %appdata%/Notepad++/functionList.xml

Add following to the associationMap section:

        <association userDefinedLangName="SAS" id="sas_function"/>

Add to the parser section:

        <parser id="sas_function" displayName="SAS">
            <function
                mainExpr="^[\s]{0,}(CREATE TABLE|INSERT INTO)[\s]{1,}[\w._]{1,}">
                <functionName>
                    <funcNameExpr expr=".*"/>
                </functionName>
            </function>
        </parser>

This website is very helpful for one to learn Regular Expression.

https://regex101.com

It allows you to see result in real time.

How to auto login a user at boot on windows server 2016

There are two stpes, first to set auto-login without user name/password then disable Ctrl+Alt+Del which is enabled for Windows server by default. It works great for vm in Azure.

To set auto-login account

  1. Start > Run > netplwiz (as explained in other answers)
  2. Un-tick “Users must enter a user name and password to use this computer.”
  3. Provide login credentials to be used for auto-logon

Disabling CTRL+ALT+DEL logon requirement

  1. Start
  2. Type ‘Local Security Policy’ (no quotes) and click on item matching this name
  3. Open ‘Local Policies’
  4. Open ‘Security Options’ Locate Policy called ‘Interactive logon: Do not require CTRL+ALT+DEL’
    Double click on it Set to ‘Enabled’

After applying this change and rebooting the server it managed to successfully auto-login to the account I had provided.