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$$
Virtual Training – SSIS, and Replication
February 1 – 28, 2011
Here is an opportunity for you to add or extend your SQL Server skills in the areas of SQL Server Integration Services (SSIS) and/or SQL Replication. As Stephen wrote a while back, there are so many skills a SQL Server professional needs to have today, its difficult to keep up.
Eric Johnson, SQL Server MVP, has put together 12 virtual classes on SSIS and Replication. For those who register, the classes will be available for the whole month of February. An interactive DVD is also available. This allows you to study at your own pace, and fill those gaps in your tool set.
Your going to have to register:
Register today for SSIS
Register today for Replication
Featured Article(s)
Troubleshooting SQL Server 2008 Profiler Problems
In this article, you can find the description of SQL Server 2008 Profiler bugs and the information on how to resolve or work around these problems.
Featured White Paper(s)
VIDEO WHITEPAPER – How to Avoid Downtime – VIDEO WHITEPAPER
In this Experts & Insights video, we take a close-up look at the data protection challenges and solutions surrounding downtim… (read more)
Service Broker, Are You Using It?
Do you ever have complaints that the response from your database is too slow? Perhaps you have complicated business rules implemented through triggers or stored procedures. Wouldn’t it be nice if you could just save the data for the user and return control to them, while in the background, a separate process detects (much like a trigger) that work is required, and does it in a separate process.
Thats what the service broker is all about. The primary purpose is to provide you as a database developer with asynchronous capabilities not usually found in a database.
The broker service works much like a message queue. The difference is that these queues are directly accessible from TSQL commands and objects. For example, you could have your web site save data to a queue and then return success to the web site. Another process that handles data from the queue will pick up that event and do something with it such as execute a stored procedure. The stored procedure could be very complicated, or maybe even on a completely different database or server.
The point is that you can break the close links of triggers and long running stored procedures from the intention of your user facing applications where they simply want to save the data.
So, are you using it? Drop me a note and let me know how this technology has enhanced your applications. Send your comments or feedback to btaylor@sswug.org.
Cheers,
Ben