Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
On 15th Feb I'll be doing a talk and demo on two great new SQL Server 2005 Programmability Features: SQL Server Service Broker and SQL/CLR.
A link to the MTUG Ireland event (Thanks to Philip and Clare) is https://damtug.mtug.ie/Scripts/Events/EventInfo.aspx?ID=b2a6303b-3115-45b5-9991-55007ae1753b
Initials Topics are:
SQL Service Service Broker:
- Overview
- Messages, Contracts, Queues, Services, Dialogs
- Sending/Receiving Messages
- Error Handling
- Routing
- Security
SQLCLR:
- Overview
- Relaibility and Scalability
- App Domains
- Reliability
- Thread Management
- Exception Handling
- Versioning
- Assembly Deployment
- dot.net Procedureal Code (Stored Procs, UDFs and Triggers)
- SqlServer Data Provider
- Security
I'll try and bring as many code examples as I can with some dos and don'ts and case studies rather than a death by powerpoint.
If we get time, I'd love to show a bit of use of XML Web Services in SQL 2005 as they kinda go hand in hand with messaging and SSB (who needs IIS !)