My Blog

ApexSQL Complete with SQL Server 2016 on cloud

1-click AWS Deployment 1-click Azure Deployment

Overview

  • Automatically complete SQL statements
  • Improve productivity with snippets
  • Keep track of all your tabs
  • Easily navigate to SQL objects
  • Review an object’s script and description
  • Identify the structure of complex SQL queries
  • Log every executed query
  • Check queries in test mode

ApexSQL Complete with SQL Server 2016 on cloud For AWS

 

 

Features

Major Features of ApexSQL Complete with SQL Server 2016

  • Automatically fill in SQL keywords and names
  • Complete SQL fragments, such as JOIN statements or cross-database queries, in a single click
  • Automatically insert the fully qualified object name
  • View the object’s definition and description inline
  • Seamlessly work with encrypted objects
  • View detailed information on SQL identifiers inline
  • Determine whether the SQL code is formed correctly by highlighting paired elements
  • Ensure the number of closing characters matches the number of opening ones with automatic closing character insertion
  • Improve SQL identifier visibility by bracketing them automatically
  • Format auto-completed keywords in upper, lower or proper case
  • Finds an object from database and highlights it inside the object explorer
  • Execute queries without affecting a database
  • Reuse SQL code fragments as snippets and insert context-specific values as needed
  • Save development time by creating your own snippets or editing the predefined ones
  • Specify aliases to be filled in for objects from all SQL Server instances and database
  • Keep track of opened and recently closed tabs
  • Log information about executed queries
  • Identify the structure of complex SQL queries at a glance
  • Copying all/selected cells from query execution results to clipboard as CSV, HTML, or XML format
  • Define insertion keys and fine tune SQL complete layout and performance
  • Define custom keyboard shortcuts for commands

 

AWS

Installation Instructions For Windows

Installation Instructions For Windows

Note:  How to find PublicDNS in AWS

Step 1) RDP  Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows  instance on AWS Cloud

Connect to the 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 .

Step 2) On the Start page, type ApexSQL Complete with SQL Server 2016  and then click on ApexSQL Complete with SQL Server 2016

Step 3)  Other Information:

1.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

 

 

 

 

 

 

 

 

 

 

 

 

 

Videos

ApexSQL Complete with SQL Server 2016 on cloud

Related Posts