By Alex Petrovsky on 8/18/2008 10:32 AM
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 »
|
By Alex Petrovsky on 8/11/2008 10:23 AM
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 »
|
By Alex Petrovsky on 8/10/2008 11:40 PM
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 »
|
By Alex Petrovsky on 8/10/2008 11:34 PM
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 »
|
By Cindy Gross on Tuesday, June 24, 2008 5:09:22 PM
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.
Read More »
|
By Cindy Gross on Tuesday, June 24, 2008 8:44:58 AM
So how do you estimate the amount of disk space needed for a server that runs SQL Server? My assumption in answering this is that you already know approximately how big the data/indexes/logs will be but need to know how much total disk space to request on the server. The information below is for SQL Server itself, not for Analysis Services or Reporting Services. My answer is really a list of questions, because once you answer the questions for your environment you'll have a good idea of how much space you need. This is an art, not a science, so there is no one right answer.
Read More »
|
By Cindy Gross on Monday, June 23, 2008 4:18:30 PM
Many people have asked where the TSQL debugger is for SQL Server 2005.
Read More »
|
By Cindy Gross on Monday, June 23, 2008 8:44:19 AM
This week at the Boise Library in the William F. Hayes Auditorium at 5:30pm on June 25: Kalen Delaney, of Inside SQL Server fame, is looking forward to meeting local SQL Server enthusiasts and sharing some of her vast SQL Server knowledge with us. Kalen is currently the director of training for SQLTuners.net, and has recently published her first SQL Server training
Read More »
|
By Cindy Gross on Thursday, June 12, 2008 11:09:45 AM
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.
Read More »
|
By Cindy Gross on Tuesday, May 13, 2008 10:43:06 AM
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 »
|
By Sirisha Kommushetty on 5/12/2008 12:11 AM
Row Constructors are a relief to single ton manual inserts. They definitely help boost the efficiency of I-Transactions (INSERT). If you really want to second my statement  … then I bet you should have a quick look at the case study below.
Read More »
|
By Sirisha Kommushetty on 5/3/2008 7:54 PM
Dependency Tracking in SQL Server 2008 is an aspect that helps users (SQL Developer/DBA) to track all the underlying dependencies or references of a given DB Object with minimum effort. SQL Server 2008 facilitates some really cool utilities that are used to: § Track both schema-bound and non-schema-bound dependencies. |
By Cindy Gross on Wednesday, April 30, 2008 2:31:16 PM
A Universal Data Link (UDL) can be very useful in troubleshooting SQL Server and Analysis Services connectivity issues.
Read More »
|
By Cindy Gross on Monday, April 28, 2008 6:53:33 AM
Microsoft has recently revised the documentation on the below message due to our recent history with troubleshooting the warning:
A significant part of sql server process memory has been paged out.
Read More »
|
By Cindy Gross on Monday, April 14, 2008 12:04:41 PM
Have you heard about the new Service Broker functionality in SQL Server but don't know where to start with installing, understanding, or troubleshooting it? These links will help you get started.
Read More »
|
By Cindy Gross on Wednesday, April 09, 2008 8:03:11 AM
The switch from 32-bit to 64-bit systems can seem overwhelming. I have summarized the major changes and differences to help make your transition a bit smoother.
Read More »
|
By Cindy Gross on Wednesday, March 26, 2008 4:30:22 PM
http://blogs.msdn.com/sqlheroes/
Read More »
|
By Cindy Gross on Monday, March 24, 2008 12:59:23 PM
Do you put SQL and AS on the same machine or different machines? How do you configure memory on an AS box to avoid conflicts with other applications?
Read More »
|
By Cindy Gross on Friday, March 21, 2008 9:37:08 AM
It can be difficult to know how to configure the maximum degree of parallelism statement on each SQL Server instance. These guidelines will help you determine the best configuration for your environment. There may be exceptions to the rules below, but they will work in the majority of cases.
Read More »
|
By Cindy Gross on Thursday, March 20, 2008 8:31:38 AM
Some SQL Server troubleshooting and investigation requires checking operating system configuration, security settings, and currently running processes. These tools can help you in those sorts of issues. They are free downloads available from TechNet.
Read More »
|