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