List of supported by SQLExecMS  features.

Wonder how SQLExecMS can be helpful for you?
Check the following list of features divided by categories

for DBA:

  • Easily navigate through Databases and DB Objects objects
  • Monitor active connections, oldest transactions and vital SQL server performance counters
  • Watch locks
  • Review space used by DB files, tables and indexes.
  • Check space utilization of serve's HDDs.
  • Backup/restore and attach/detach databases
  • Manage DB file and file groups
  • Check utilization of proc cache
  • Manage scheduled jobs
  • Manage maintenance plans for your databases
  • Change SQL server and database options
  • Turn on and off trace flags
  • Analyze fragmentation of the tables
  • Analyze wait statistics
  • Manage indexes and analyze the selectivity of an index
  • Review error logs of SQL server
  • Manage extended stored procedures
  • Manage logins and users
  • Use bulk insert
  • Compare meta data of two databases

for Developers:

  • Execute any T-SQL statements
  • Review estimated execution plan
  • Watch locks
  • Find substring in objects DDL (no script generation required)
  • Use SQL history of your sql statements
  • Use quick reference and code assistant
  • Easily view the table and view data.
  • Manage triggers
  • Manage indexes
  • Compare scripts of two databases
  • Easily navigate through DB objects and view its DDL
  • Review objects dependencies in tree-like view
  • Review object properties
  • Find an object by its ID
  • Generate SQL script of your database including INSERT INTO script for selected tables
  • Use automatically built INSERT, UPDATE, DELETE and EXECUTE scripts for an object
  • Generate INSERT INTO script of your tables or for the result of your SQL statements

for end users of your DB solution:

  • View and edit tables' data in tabular or columnar representation
  • Easily filter and search data
  • Export data into different formats
  • Perform data manipulations using T-SQL
  • Print data

And many others handy features....