Roanoke Valley SQL Server User Group - August Meeting

From my friends at rvssug, who have a great meeting planned for August, with none other than SQL rockstar Bill Vaughn coming to speak:

The Roanoke Valley SQL Server Users Group ( is announcing its next meeting for 2006 to benefit SQL Server Professionals in the Roanoke Valley area.

Title – Coding CLR functions for SQL Server 2005

One of the most talked-about new features in SQL Server 2005 is its ability to execute CLR-based assemblies on the server. This topic is especially important for DBAs concerned with developers’ use of CLR code. While SQL Server has been able to execute non-TSQL code for some time, this session discusses how developers and DBAs can use Visual Studio 2005 to create, test, deploy and debug CLR-based stored procedures, User-defined Types (UDTs) and User-Defined Functions (UDFs).

We’ll discuss where this technology makes sense (and where it doesn’t) and how it’s implemented. The presentation walks through three examples: one that does not make sense for conversion but illustrates the development techniques, and two others that provide a rich example of the issues and techniques associated with writing CLR Assemblies for SQL Server 2005.

This presentation discusses and demonstrates the following topics:
• What is CLR-based code? How is it written? What languages can be used? What
happens to TSQL?
• When does CLR-based code make sense? What are good examples of its use?
• How does SQL Server 2005 support managed assemblies? Where are they stored,
and how can they be managed?
• How are CLR Stored Procedures or Triggers created in Visual Studio 2005? How is
the code deployed and tested?
• How are CLR User Defined Types (UDTs) created, deployed and tested? How can
they be optimized to reduce storage and data transport requirements?
• How are User-defined aggregates created, deployed and tested?
• How are CLR assemblies secured? How do they protect the server resources?
• How can CLR assemblies be debugged?

Speaker – William (Bill) Vaughn

Date and Time – Thursday, August 17, 2006 @ 5:30 PM  

Roanoke County Public Safety Building 
3568 Peters Creek Road
Roanoke, VA 24019

Directions –

RVSSUG  Corporate Sponsors
• Roanoke County  (
• Idera  (
• Red-Gate Software (

RVSSUG August Sponsor – Ineta Speakers Bureau(
The International .NET Association (INETA) provides structured, peer-based organizational, educational, and promotional support to the growing worldwide community of Microsoft® .NET user groups. Our mission is to offer assistance and resources to community groups that promote and educate their membership in Microsoft's .NET technologies. INETA welcomes all facets of the .NET user community, from developers and architects to project managers and IT professionals.
Food and refreshments will be served at the meeting, and there will be a drawings for several door prizes.