Integrating Visual APL assemblies with SQL Server 2005
This webcast will show the basics of deploying Visual APL assemblies to a database in Microsoft SQL Server 2005, and using methods in your deployed assemblies as stored procedures.
Stored procedures are the most common form of database automation in SQL Server 2005, and using Visual APL to integrate your functions and code directly into SQL for use as stored procedures is a powerful tool.
Examples shown in this webcast include:
Enabling the CLR on a database in SQL Server 2005.
How to add the common Visual APL assemblies to a database.
Introduction to the Microsoft.SqlServer.Server namespace, which is the Microsoft namespace that contains all objects, types, and functions for interacting with SQL Server.
Create a class library, create a method, and mark that method with the Microsoft.SqlServer.Server.SqlProcedure attribute. Marking a method with this attribute allerts SQL Server that the method can be used as a stored procedure once the assembly has been deployed.
Deploy your newly created Visual APL assembly to the SQL database.
Call your method as a stored procedure from SQL queries, and even call your stored procedure from other stored procedures!
This webcast will be available from the following urls:
For the best experience, enter the following in your browser address bar:
mms://wms.aplnext.com/meeting26
If your firewall does not permit access via mms, use:
http://wms.aplnext.com/meeting26
These links are live now, and have a short webcast looping for you to see which works best for you.
Details
This webcast will have an accompanying IM session. There will be a moderator using IM to take your questions, provide answers and forward questions to the presenters to be answered during the webcast. This should provide a similar experience to raising your hand to ask a question during a presentation, but with the advantage that you can chat without getting in trouble. The moderator IM account to be used with the presentation will be MS/Yahoo.
IM account
webcast@aplnext.com
If you don't have Windows Live Messenger you can get it free at: http://get.live.com/messenger/overview
If you don't have a Microsoft Passport Id or a Windows Live ID you can get it for free at: http://ideas.live.com by clicking on the “Sign In“ link on the upper right corner of the page.
Once you have your Windows Live ID open the Windows Live Messenger and click on the “Sign In“ button. After signing in go to Contacts > Add a Contact and type “webcast@aplnext.com“ in the “Instant Messaging Address:“ field. At this point you should be able to participate in the Realtime WebCast Q&A.
If you are behind a firewall you can try the web based version at http://webmessenger.msn.com/
If you cannot use IM just send your questions by email to webcast@aplnext.com.