Help / Tips and Tricks

SQL Server 2005 driver - how to use Windows authentication mode:

    In the Add/Modify connection dialog add ";domain=DOMAIN_NAME" after the host, for example if your host is 192.168.0.1 and the domain in which you want to log in is my_domain then enter 192.168.0.1;domain=my_domain in the Host field. Then fill your domain User Name and password.

Performance boost:

     Open Settings/Preferences. Then in the General Tab there is a section called "Performance". You can un-check database object types there if you will not need them preloaded in the tree. You can later refresh database objects manually in order to show them (choosing "Refresh" or just double-clicking on their folder). Note that all un-checked database object types will not appear in the completion popups (except if they have been refreshed manually).

Adding own completion templates

    There is still no user interfaces for adding custom queries for completion in the sql editor. You can do it manually by editing PATH_TO_EXTRACTED_ZIP_FOLDER\config\templates.xml