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
What is a Stored Procedure in SQL Server

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.

Read full article


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