Microsoft SQL Server keyboard shortcuts

1. Press Windows+R
2. Type ssms
3. Press the OK button

Accessing common windows in SQL Server Management Studio

Here are the shortcut keys for common SSMS windows:

• F8 - Object Explorer
• CTRL+ALT+T - Template Explorer
• CTRL+ALT+L - Solution Explorer
• F4 - Properties window
• CTRL+ALT+G - Registered Servers explorer

Microsoft Visual Studio Keyboard Shortcuts

Navigation Shortcuts

Ctrl + ]	Moves the cursor to the matching brace in the source file
Ctrl + Hyphen (-)	Moves cursor to its previous position
Ctrl + Shift + Hyphen (-)	Moves cursor to the next browsed line of code
Shift + F7	Switch between the Design and Source View of the document
Ctrl + Tab	Displays the IDE Navigator with the current document selected. Allows you to navigate open documents. Also try Alt+W+2
Ctrl + Shift + F	Displays the ‘Find in Files’ tab of the ‘Find and Replace’ dialog box
Ctrl + I	Activates Incremental Search by searching for the next occurrence of the input text. You can even use F3
Shift + F12	Displays a list of all references for the symbol selected
Ctrl + /	Moves focus to the Find/Command box

VB - How to Split string

Private Sub Split_String_JobReq()
        Dim s As String = LBLAITREQ.Text
        Dim words As String() = s.Split(New Char() {"."})
        s = ""
        Dim word As String
        For Each word In words
            s = s + "<br>&radic; " + word + "<br><br>"
        Next
        LBLAITREQ.Text = s

    End Sub