Search
About me
Carlos Bercero Carlos Bercero is a BI Consultant for one of the leading BI firm in Puerto Rico, Nagnoi, Inc. (nagnoi.com). His professional IT career started in 1995 playing many different roles in the IT industry. He is now specialized in Business Intelligence Solutions and Custom Application Development.
Writing a CLR Stored Procedure on SQL Server

As I mentioned in my previous posts, CLR objects on SQL Server can be very useful in certain scenarios. Here I will show you how to create, deploy and test a simple CLR stored procedure. This stored procedure will return a file list from the file system upon the specified path.

Read full article
How to create an SQL CLR Project in Visual Studio 2008

Visual Studio 2008 comes already with a project template for this purpose. In this example I will show you how to create an empty project.

Read full article
What is SQL CLR?

SQL CLR is the ability to create SQL Server programmability objects using .NET languages and framework.

Read full article
What is CLR (Common Language Runtime)

Common Language Runtime (CLR) is the runtime environment that manages the interpretation, compilation and execution of .NET program code. It also provides services such as memory management, exception management, debugging and security.

Read full article
SQL CLR Basics presentation at PR PASS (Professional Association for SQL Server, Puerto Rico Chapter) meeting

Last Thursday, November 5 2009, I had the honor to be the speaker of one of the sessions of the PR PASS (Professional Association for SQL Server, Puerto Rico Chapter) meetings. I made a short presentation called “SQL CLR Basics”. In it, I showed the attendants the basics on how SQL works and how to get started with it.

Read full article


Domain Registrations starting at $9.69
Powered by Carlos Bercero Blog Platform © 2009