My Blog

sql prompt  on cloud

1-click AWS Deployment 1-click Azure Deployment

Overview

SQL Prompt automates the retrieval of database object names, syntax, and snippets as you write, intelligently offering only appropriate code choices. Automatic script layout provides easy code readability – particularly useful when working with unfamiliar scripts. SQL Prompt is highly productive straight out of the box. It is also customizable so you can make it perform exactly the way you want it to. Using SQL Prompt will improve your productivity and dramatically reduce your time at the keyboard.

SQL Prompt

  • Write SQL fast and accurately with code completion
  • Understand code more easily with script layout
  • Continue to use your current editor – SQL Prompt works within SSMS, Query Analyzer, and Visual Studio
  • Keyword formatting, join completion, code snippets, and many more powerful features

SQL Prompt simply sits behind the scenes and provides unobtrusive help when you press CTRL+SPACEBAR or when you type “.” after a table/view/alias name.

 

2

 

Features

Major Features of sql prompt

  • Table/View/Column/Sproc name completion
  • Layout makes scripts easy to read
  • JOIN/JOIN ON syntax completion
  • Expand wildcard to column names list
  • Object creation-SQL viewing pane
  • Mouse-over tool tips that give object definitions including a useful summary
  • Parameter hinting for user-defined functions
  • Cross-database queries
  • Distributed queries with linked SQL Server instances
  • Scripted objects included in candidate list
  • Cursors, cursor variables, and related statements
  • Auto-uppercasing of keywords and pop-up after keywords
  • Column selector screen, plus qualify object/column names option

 

 

AWS

Installation Instructions For Windows

A) Click the Windows “Start” button and select “All Programs” and then point to sql prompt

B) RDP Connection: To connect to the operating system,

1) Connect to virtual machine using following RDP credentials :

  • Hostname: PublicDNS  / IP of machine
  • Port : 3389

Username: To connect to the operating system, use RDP and the username is Administrator.
Password : Please Click here  to know how to  get password .

C) Other Information:

1.Default installation path: will be on your root folder “C:\Program Files (x86)\PoorMansTSqlFormatterSSMSAddIn\”
2.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443

Configure custom inbound and outbound rules using this link

Installation Step by Step Screenshots

1

 

2

 

3

 

4

Videos

sql prompt  on cloud

Related Posts