How to Add Content to SQLCLR.net

Any registered user can submit Articles and Examples to the site for consideration of publication on the site.  One of the primary goals of this site is to create a community driven resource for information about using CLR inside SQL Server.  However, in the interests of ensuring that the content is of an appropriate nature, all new content will require approval by one of the site administrators before being published live.

To submit an Article or Example for Review:

  1. Register on the site as a user.
  2. Login to the site.
  3. Click the Create Article Link under Articles/Examples.

    Create Article Image 

 

 

 

 

  1. Add a Title
  2. Select the Category or Categories that this post best fits under.
  3. Provide a brief synopsis in the Summary box.  Formating can be accomplished through the toolbars.
  4. Scroll down to the Article Details, and provide the information that you wish to share in detail here. 
  5. If you need to leave a contribution and return to it later, you can Save it, or when you are complete, you can click Publish Now to submit it for approval.

Some guidelines to follow:

  1. Post content that is applicable to the use of CLR in SQL Server, and content that supports your articles implementation.  This site is not intended to be an all things SQL site, and has a specific focus.  Any posting not aligned with this focus may not be approved.  However, that being said, the following can/will be considered acceptable:

    -  Supporting references and TSQL code that relate to or support the content of an article.
    -  TSQL Impementations created that outperform a common CLR Implementation.
    -  Other content as approved by the site administrator or one of the content managers on the site. 
  2. Source code can be used inside of Articles to the extent that it helps make the point of the article.  T-SQL and CLR are both allowed.
  3. If possible, please provide a C# and a VB.NET example of your source code.  If this is not possible, don't worry, one of the site administrators will try to flag the article for update later with the missing code type.  This will help those who have trouble following examples not in the language they are familiar with.
  4. It is best to not make changes to the center section of the Create Article form.  These items will be removed in a coming release of this site for non-admin users.  If you change these, they will be reset before the article is published.

Remember that this is a community site, and the information contained within will be used by people who might not know as much as you.  Please be detailed enough for the average person to follow your information to the extent possible.  Most of all have fun, and enjoy contributing to the SQL community at large so that others may learn from your experience.

Survey

Which of the following CLR objects are you currently using in SQL Server?




Submit Survey  View Results

Links

  Search

What's New

 Subscribe in a reader

Q&A with Adam Machanic - Who's Afraid of SQLCLR by Jonathan Kehayias

You could almost hear the gasps of horror when Microsoft integrated the .NET Common Language Runtime (CLR) into SQL Server 2005. Run C# or VB.NET code inside SQL Server? For many database developers and administrators, it was like an alien had just burst through SQL Server’s midsection.

But SQL Server MVP Adam Machanic says that more and more developers and DBAs are discovering that far from destroying SQL Server performance and security, SQLCLR is actually a powerful ally in solving complex business and technical problems.

Read More on the PASS website..

SQLCLR String Splitting Part 2: Even Faster, Even More Scalable by Site Administrator

SQL Server MVP Adam Machanic shows a new way of parsing strings in SQL Server using SQLCLR that outperforms all conventional TSQL methods, as well as the most common SQLCLR implemenations, using a custom split function that allows streaming of the results.

Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents by Jonathan Kehayias

Learn how to use SQLCLR to get file system information instead of using xp_cmdshell on your SQL Servers.

Recent Examples


Copyright 2007 by SQLCLR.net Terms Of Use Privacy Statement
Website graphics provided by Matt Green Designs
Page generated in 0.1092035 seconds.

All information and example code on this site is provided 'as-is', without any express or implied warranty. In no event will the authors be held liable for any damages arising from its use.

This site is in no way affiliated with Microsoft. Unless specifically stated otherwise, nothing should be construed to represent the official positions or opinions of Microsoft and/or its Employees.