SQL Rob

SQL Server and other database technologies

Notepad++

Notepad++ Shortcuts:

Ctrl + O: Open File
Ctrl + N: New Tab
Ctrl + W: Close Tab
Ctrl + Tab: Switch Tabs
Alt + F4: Exit Application
Select multiple lines to edit all lines at once – add commas to all lines, etc.: alt + shift + arrow
Ctrl + Shift + Home/End: Select all from cursor to beginning (Home) or End (End) of file

Settings:

Settings => Preferences => Auto-Completion – Uncheck “Enable Auto-Completion…”
View – Check Word Wrap

Plugins:

JSON Viewer : Format JSON
MarkdownViewer++ : See markdown as rendered text – Export to HTML or PDF
XML Tools : Format and validate XML