Virtual Training – SSIS, and Replication – LAST DAY TO REGISTER
February 1 – 28, 2011
This is the last day to register for the 12 virtual classes on SSIS and Replication design by SQL Server MVP, Eric Johnson. I had an Email just today from a reader asking how to get up to speed on SSIS skills. This is a good value, and being self paced, you can work it into your schedule. So, Register today for SSIS or SQL Server Replication.
DBTechCon – Spring 2011
The SSWUG Spring 2011 virtual conference is quickly coming together. Without a doubt, this will be the largest virtual conference in the information technology industry. Access more than 70 sessions from well seasoned professionals with in-depth instruction on technologies such as SQL Server, SharPoint, .Net, Business Intelligence and much more. Register any time from now to April 19th. There are early registration discounts for those who register early. go to the Registration page for more details and to get signed up right away.
$$SWYNK$$
Featured Article(s)
Using SQL Server Profiler (Part 2 of 3)
This will be a demo filled session with just a few slides to explain the basics. We will go over all facets of SQL Profiler used in daily production support and development. The first section with cover many of the common tasks. The second section with cover the different event classes to help you understand when to use them and how to better filter. The final section will cover more advanced techniques and external tools like starting a trace from TSQL, SQLDiag, and SQL Nexus among others.
Featured White Paper(s)
Why and How You Should Find and Fix Index Fragmentation
In a high-volume database you need frequent critical maintenance. If you skip this important task, index fragmentation may ca… (read more)
Service Broker Experiences
Lots of you have responded with comments regarding useages for the Service Broker. Key features that have been useful to many is the capability to break the dependency between different processes or the ability to assgine multiple threads to a single process.
Rick writes:
The more I learn about SB, the more I see many potential and valuables uses. I will be proto-typing and testing soon I hope !
Other than the introduction to S/B in MS’s 2005 course book for exam prep, I need to study much more and better understand approaches and see examples of successful implementations as solutions.
Thanks for asking !
Tim writes:
SSBS also allow you to do rudimentary multi-threading which is also in
the category of "capabilities not usually found".
Example: You have a couple of long running (or high priority) things
that need to happen when a record is saved to a table.
Solution: Queue a single "record saved" message when the record is
saved. When the message queue activation procedure fires, have it queue
a separate message (each on different conversations) for each task that
is able to be run independently. You can sort-of control the amount of
"threads" by adjusting the MAX_QUEUE_READERS parameter, although you
can’t control when the server will choose to run additional readers.
Robert writes:
Yes I am using it! Great tool!
In one scenario I am using Service Broker’s External Activator application to start up an application on a remote machine. An SSIS package sends a broker message to a queue which the External Activator monitors. Once the message comes in, the Activator kicks off the application and then the application performs its work and sends a message back to the SSIS package.
Another scenario where I am using Broker services is to execute an SSIS package from an application. I have written a stored procedure which uses xp_cmdshell to run dtsexec, and that procedure is activated when messages hit the queue. The broker message contains the name of the SSIS package to execute. The package then sends a message back to the queue once it is complete.
We also use Broker Services to log DDL statements across our servers to a central repository.
As yoiu can see, because the service broker allows you to insert into a queue just about any kind of message, the capabilites are really rather broad reaching.
Do you have other ways you have implemented the service broker that you’d like to share. Send your exerience or comments to btaylor@sswug.org.
Cheers,
Ben