Customers are generally interested in “Collect Data” feature so I have decided to write about it.

You can collect data from instances for which you know access credentials.
- select some instances in the grid
- click the "Collect Data" button under the grid or select corresponding item from right-click menu
- specify connection details
- click Save

Now, you can use additional information for selected instances:
* General - general information about SQL Server instance
* Databases - information about all databases in the instance
* Logins - information about registered logins in the instance
* Applications - information about application which are working with the instance Read More »

Quest Discovery Wizard has two search methods:

* By Domain - you can choose existing added domains or specific domains from the "Domains" list.

* By IP List - if you have to find servers from your network, you can search servers using IP or IP range list:
- On the By IP List tab, click Add New...
- In the IP Address dialog window, choose Single IP or IP range.
Note, that you can save IP rules after changes you’ve made or load them from .txt files. Moreover, it is possible to use several IP rules at once. Read More »

Quest Discovery Wizard for SQL Server is a freeware product for administrators who monitor Microsoft SQL Server in their network. If you are a such administrator keep reading because this product can facilitate your work :)

Which instruments do you usually use to monitor SQL Servers in a network? Register SQL Server Wizard from MS SQL Server 2000, may be. You can see only machine names and can’t see any helpful information such as instance name , SQL Server version, OS version and so on…

Or “Browse for Server” from MS SQL Server 2005\2008 Management Studio?
Browser for Servers provides information about instances and SQL Server versions. It’s really better than his small brother from MS SQL Server 2000, but has the following restrictions: you can search only in the current domain, you can’t sort information, you can’t define ip\port servers and so on.

Next is SQL Ping It’s a good product with several useful features such as adv Read More »

Hi guys,

Several days ago I have joined to the Quest Discovery Wizard for SQL Server, a really valuable project and in my blog I intend to describe its main features for it. You’ll be able to discover secrets of next releases and ask questions ;) Read More »

One of our customers has found a slight issue: In the "Create Service Broker Application Wizard" user can't create a new queue without activation (for external activation), he has to create a stored procedure for activation or select existing. So if you are planning to configure your Service Broker using our wizard, keep in mind this restriction. Read More »

Yesterday I worked on Event Notification and found new events in SQL Server 2008:

DLL (Database and Server)
CREATE_ASYMMETRIC_KEY, ALTER_ASYMMETRIC_KEY, DROP_ASYMMETRIC_KEY
ALTER_AUTHORIZATION
ADD_COUNTER_SIGNATURE, DROP_COUNTER_SIGNATURE
CREATE_CREDENTIAL, ALTER_CREDENTIAL, DROP_CREDENTIAL
CREATE_DEFAULT, DROP_DEFAULT, BIND_DEFAULT, UNBIND_DEFAULT
CREATE_EXTENDED_PROPERTY, ALTER_EXTENDED_PROPERTY, DROP_EXTENDED_PROPERTY
CREATE_FULLTEXT_CATALOG, ALTER_FULLTEXT_CATALOG, DROP_FULLTEXT_CATALOG
CREATE_FULLTEXT_INDEX, ALTER_FULLTEXT_INDEX, DROP_FULLTEXT_INDEX
CREATE_PLAN_GUIDE, ALTER_PLAN_GUIDE, DROP_PLAN_GUIDE
CREATE_SPATIAL_INDEX
RENAME
CREATE_RULE, DROP_RULE, BIND_RULE, UNBIND_RULE
CREATE_SCHEMA, ALTER_SCHEMA, DROP_SCHEMA
ALTER_SERVICE_MASTER_KEY, BACKUP_SERVICE_MASTER_KEY, RESTORE_SERVICE_MASTER_KEY
ADD_SIG Read More »

As you know, the SQL Server 2008 (Katmai) has been released to the public.
In next Quest Service Broker Admin release, we are planning to support some of the new Katmai features, such as Conversation Priority, new events for Event Notification (more details in my next post) and so on.
We are considering implementing a similar plug-in for SQL Server Management Studio. Using this plug-in you will be able to work with our dialogs and intellectual wizards from Management Studio. I would like to know your opinion: will this plug-in be interesting to you? Read More »

Hi guys,

Welcome to my blog. My name is Alexander Petrovsky and I'm working in Quest Software in Toad for SQL Server team. In particular, I'm working as a QA engineer for Toad Service Broker Admin plug-in. In my blog I will post news about Service Broker that cought my eye. I will also share with you news and plans from my team related to Service Broker plug-in development. Read More »