MS SQL Maestro 7.5 released

May 15, 2007

SQL Maestro Group is happy to announce the release of MS SQL Maestro 7.5, a powerful Windows GUI solution for Microsoft SQL Server administration and database development.

Please consider the list of new features implemented in MS SQL Maestro 7.5 since last official release:

Server management extensions:

• Support for Service Broker objects is added (SQL Server 2005). Since this version you can manage them as follows:
  
  
  • Queues: creating, editing, dropping, viewing contents, and receiving messages.
    
    
  • Message types: creating, editing, and dropping.
    
    
  • Contracts: creating, editing, dropping, viewing message types used.
    
    
  • Services: creating, editing, dropping, viewing contracts used.
    
    
  • Conversations: creating and ending.
    
    
• Process Browser is implemented. This feature is very useful for DBAs who want to monitor the users' activity (in fact, there are potentially thousands of sessions in a database at any one time). You can view details for each process (such as login, connect time, database name, client host, last SQL statement executed and more) as well as group and filter sessions by client host, connected user, database, client application, etc.
  To access the Process Browser window, select the corresponding item from the Tools menu.
  
  
• Sometimes the "CommandText does not return a result set" error message occurred when user tried to create a new database. The bug is fixed now.

• Database Designer: a possibility of locking/unlocking diagram objects is added. This feature prevents your diagram from unforeseen changes: when the diagram is locked, you can neither move/resize/delete existing objects nor add new ones.
  
  
• Some new features are incorporated into SQL Editor and SQL Script Editor. Now it is possible:
  
  
  • comment/uncomment selected text (Shift+Ctrl+. / Shift+Ctrl+, shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift+Ctrl+, having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported;
    
    
  • convert selected text to different cases (lower, UPPER, and NameCase);
    
    
  • export the contents of the editor to RTF and HTML formats (to file or to clipboard);
    
    
  • print/preview the contents of the editor.
    
    
• The Copy to SQL Script Editor command is added to all object editors (available in the Navigation Bar on the SQL tab). Use it for quick copying object’s SQL definition (DDL) to the SQL Script Editor for future modifications;
  
  
• Explorer tree: the Browse command is added to lists' popup menus (runs the Object Browser tool).
  
  

In addition to this, several bugs were fixed and some other minor improvements and corrections were made.

Related links:

Back to news archive