Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Albert Rognan: "Thank you for this quick reply. I must say I am impressed of the number of functions that is available within this tool".
Alex Torin: "Several months ago I downloaded the trial versions of several Microsoft SQL administration tools that I was able to find using google. I had considerable trouble with most of them crashing... but using your product I was able to isolate and solve the problems I was having. I decided to add it to my toolkit and have recommended it to a few others".

More

Add your opinion

SQL Maestro Group / Products / MS SQL Server / MS SQL Maestro / News / MS SQL Maestro 17.6 released

MS SQL Maestro 17.6 released

Jun 29, 2017

Prev Next
MS SQL Maestro

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

Please consider the list of new features implemented in this version since the last official release:

New feature highlights:

  • This version has been successfully tested with SQL Server 2017 Community Technology Preview 2.1 (the latest SQL Server 2017 version available at the moment). Hope it will work fine with the official release too.
    Connecting to an SQL Server 2017 databasePicture 1. Connecting to an SQL Server 2017 database
  • Support for row-level security policies has been implemented (SQL Server 2016 and higher). These policies enable you to implement restrictions on data row access. For example ensuring that workers can access only those data rows that are pertinent to their department, or restricting a customer's data access to only the data relevant to their company.
    RLS Policy EditorPicture 2. RLS Policy Editor
    New policies can be created with the appropriate wizard that allows you to define policy properties as well as add predicates to the policy.
    Create RLS Policy WizardPicture 3. Create RLS Policy Wizard
    Existing policies can be viewed/modified via the corresponding editor. Among other things the editor provides the Dependencies tab that allows you to quickly determine the tables affected by the policy.
    RLS Policy Editor - DependenciesPicture 4. RLS Policy Editor - Dependencies
  • Starting from this version it is possible to specify a custom label and/or a font color for server nodes in the Database Explorer tree.
    Explorer Tree: custom labels and colorsPicture 5. Explorer Tree: custom labels and colors
    To change these properties, right-click a server node, select "Edit Server Properties" from the popup menu and provide the values you need in the modal dialog.
    Edit Server Properties dialogPicture 6. Edit Server Properties dialog
  • The Statistics tab has been added to the Edit Database Profile dialog. Here you can find such information as profile creation time, total number of connections, last connection time, and so on.
    Database Profile StatisticsPicture 7. Database Profile Statistics
  • Data Grid: now it is possible to copy the value of the selected cell to Clipboard using grid's popup menu or Ctrl+Shift+C shortcut.
    Data Grid: copy cell valuePicture 8. Data Grid: copy cell value
  • The "Show SQL Help" command now displays the manual that corresponds the version of the database server you are connected to.
    Show SQL Help commandPicture 9. Show SQL Help command
  • Default Data Import settings can now be set up in the Program Options dialog.
    Data Import defaultsPicture 10. Data Import defaults
  • "Show special chars" and "Convert tabs to spaces" options have been added to the Editor settings.
    Editor OptionsPicture 11. Editor Options

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


Related links:

Prev Next