SQL Server 2005 service pack 3 (SP3) is now available! There’s also a new version of the feature pack and of BOL.

·         SP3 itself contains all fixes from SP2 based CU1-CU9 but it does not include most CU10 or CU11 fixes due to the timing of when the CTP (beta) of SP3 started. This pure SP3 version is 9.00.4035. If you want to have al Read More »

The first cumulative update is available for SQL Server 2008. I’ve compiled the link for the cumulative update plus some other SQL Server 2008 links that you may find useful.

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 »

Sometimes you need to change the collation of a database after you have created it and populated it with objects and data. So how do you change the collation?

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 »

Comments (0)

Quest Service Broker Admin Quest Discovery Wizard

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 »

Comments (0)

Quest Service Broker Admin Quest Discovery Wizard

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 »

This year SQL injection attacks are being stepped up and even automated against SQL Server. While SQL injection attacks can occur against any DBMS, my blog will only address SQL Server.

Many people have asked where the TSQL debugger is for SQL Server 2005.

SQL Server 2008 release candidate 0 (RC0) is now available for public download. Use the links below to download SQL Server, Books Online, the Feature Pack, and more.

Finding out which build is the latest or what fixes are included in a particular build can be difficult. These links should make that job easier. Read More »