Exact Synergy Enterprise certified for Windows Server 2008 R2

As of product update 240, Exact Synergy Enterprise is certified for the latest  Microsoft server platform Windows Server 2008 R2. This is another great step of Exact in supporting the latest technology of Microsoft. Exact Synergy Enterprise can be used in 32 bits or 64 bits mode.
Exact Synergy Enterprise and Exact Globe now supports the latest available Microsoft operatings systems like Windows 7, SQL2008 and Windows Server 2008 R2.

My favorite SQL Server Management Studio settings

I work a lot with SQL Server Management Studio (SSMS). From a performance perspective I'm not so happy with the default settings of this application. Therefor I made some changes to the settings of SSMS.

To made changes to the setting of SSMS start SSMS and select Tools, Options in the menu.

1. Startup with an empty environment. (Environment, General, At startup: Open empty environment)
2. To avoid to lock other users when you execute long running SELECT queries. Set the default transaction isolation level to: READ UNCOMMITTED (Query Execution, SQL Server, Advanced, SET TRANSACTION ISOLATION LEVEL)
3. Include column headers when copying or saving results. (Query Results, SQL Server, Result to Grid)
4. Quote strings containing list seperators when saving to .csv results. (Query Results, SQL Server, Result to Grid)
5. Word wrap. This is a setting which I changed a lot depending on the kind of queries I'm analyzing. (Text editor, Plain Text, General, Settings)

Enjoy using SSMS

Using SQL Profiler Trace without the SA server role

By default users who has the SA role (SysAdmin) server role on the SQL server are able to trace activity on the SQL server with SQL Profiler. However not all users who need to trace SQL server activity will have the SA server role. To give users permissions to run SQL Profiler traces without the SA role, you need to grant ALTER TRACE permissions to the these users.

For instance grant SQL Profiler permissions to the user account Mark from domain MyCompany:

GRANT ALTER TRACE to [MyCompany\Mark]

For more information see: Permissions required to run SQL Profiler trace.

IIS Database Manager to easily manage your local and remote databases within IIS Manager

IIS Database Manager allows you to easily manage your local and remote databases from within IIS Manager. IIS Database Manager automatically discovers databases based on the Web server or application configuration and also provides the ability to connect to any database on the network. Once connected, IIS Database Manager provides a full array of management options including managing tables, views, stored procedures and data, as well as running ad hoc queries.

IIS Database Manager provides native support for SQL Server and is also fully extensible for developers to add support for other database systems. In addition, because IIS Database Manager is an extension of IIS Manager, administrators can securely delegate the management of databases to authorized local or remote users, without having to open additional management ports on the server.


First of all install the IIS Database Manager of your web server.
Start the IIS Manager.
Select your web server
In the management view click on the Database Manager icon

Create a database connection to the database you want:

Open your connection:

Press on the new query button:

Now you can start executing queries on your database

Be aware this is a simple query analyzer. You can't for instance retrieve query plans etc. But for simple checks it can be a nice tool without the need to install the full SQL Server Management Studio (SSMS)