Carlos Bercero Professional Blog

SQL Stored Procedure Array Parameters Dilemma, Solved with CLR

Carlos Bercero — Tue, 15 Dec 2009 22:55:00 -0400

If you work actively with SQL Server and do most of the data operations using stored procedures, then I bet that at least once, you wanted to pass an array of values as a parameter to a stored procedure (or function). Just like you, I had the same situation. I’ve seen many approaches to this problem and all of them has their pros and cons. I’ve implemented a solution using a CLR Stored Procedure, that I find quite practical and well performing.

...View full article

Writing a CLR Stored Procedure on SQL Server

Carlos Bercero — Mon, 23 Nov 2009 01:42:43 -0400

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.

...View full article

How to create an SQL CLR Project in Visual Studio 2008

Carlos Bercero — Thu, 19 Nov 2009 22:49:03 -0400

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.

...View full article

What is SQL CLR?

Carlos Bercero — Wed, 18 Nov 2009 22:07:00 -0400

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

...View full article

What is a Stored Procedure in SQL Server

Carlos Bercero — Tue, 17 Nov 2009 10:00:46 -0400

A Stored Procedure is a single or a set of SQL statements typically involving some (or a lot of) logic typically designed to accomplish a business data operation. Think of it as a T-SQL script stored in the database itself. Best practices suggests that all data-centric business logic operations should be encapsulated in stored procedures at the database level.

...View full article

SQL, DDL, DML, DCL and TCL Terms – What on earth are those?

Carlos Bercero — Mon, 16 Nov 2009 00:55:59 -0400

Sure you heard those acronyms very often… but do you know what they really mean?

...View full article

What is T-SQL (Transact SQL)

Carlos Bercero — Mon, 16 Nov 2009 00:54:00 -0400

T-SQL (Transact SQL) is an sql statements based and data centric language, typically used for operations over a database in Microsoft SQL Server. It provides features such as transaction control, logic such as conditions and loops, exceptions and errors handling, row processing, and declaration of variables. It is the SQL Server native programming language.

...View full article

What is CLR (Common Language Runtime)

Carlos Bercero — Sun, 15 Nov 2009 21:00:00 -0400

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.

...View full article

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

Carlos Bercero — Sat, 07 Nov 2009 23:27:00 -0400

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.

...View full article

My first post!

Carlos Bercero — Sun, 01 Nov 2009 17:25:00 -0400

Hello World!!
Around the globe, that is probably the most famous string of characters that almost any software programmer have used to test their first lines of code. It was for me on my first QBasic, Pascal and Cobol programs I made back in my college years in the mid 90s.

...View full article