November 2007 - Posts

2
Comments

Going deeper with LINQ to XML Operations by Kasim.Wirama

Going deeper with LINQ to XML Operations By : Kasim Wirama, MCDBA, MVP SQL Server This article will discuss about classes in LINQ for XML. What is goal behind the creation API (separate DLL) LINQ for XML. At the beginning, I thought that LINQ for XML...
Filed under:
0
Comments

Introduction Using LINQ in XML by Kasim.Wirama

Introduction Using LINQ in XML By : Kasim Wirama, MCDBA, MVP SQL Server This article, I would begin to explore LINQ implementation in XML. .NET framework 3.5 provide API dll for LINQ to XML through System.Xml.Linq, so include this into project reference...
Filed under:
2
Comments

Querying Dataset with LINQ by Kasim.Wirama

Querying Dataset with LINQ By : Kasim Wirama, MCDBA, MVP SQL Server This article, I would like to show how to access ADO.NET dataset and datatable using LINQ. System.Data.Dataset is a in-memory representation of a set of data. It has relational objects...
Filed under:
1
Comments

Execute Stored Procedure and Function from LINQ by Kasim.Wirama

Execute Stored Procedure and Function from LINQ By : Kasim Wirama, MCDBA, MVP SQL Server In this article I would like to show you how to call stored procedure, scalar function, and table value function from LINQ. For these three kinds database object...
Filed under:
50
Comments

Lambda Expression as Predicate and Expression Tree in C# 3.0 by Kasim.Wirama

Lambda Expression as Predicate and Expression Tree in C# 3.0 By : Kasim Wirama, MCSD.NET, MVP SQL Server One of C# 3.0 new feature is lambda expression. What is it actually Lambda expression? How to use Lambda expression? In C# 2.0, ability to pass method...
Filed under:
0
Comments

Querying into Database with LINQ by Kasim.Wirama

Querying into Database with LINQ By : Kasim Wirama , MCDBA, MVP SQL Server This article, you can begin your exploration of LINQ into database. The LINQ to SQL concept is intended to provide thin layer between application and database. Purpose of LINQ...
Filed under:
3
Comments

First time with LINQ by Kasim.Wirama

st1\:*{behavior:url(#ieooui) } First time with LINQ By : Kasim Wirama , MCDBA, MVP SQL Server I am wondering what LINQ looks like. So I begin my exploration to LINQ from simple query to most complex one. I would like to describe a little what LINQ is...
Filed under:
9
Comments

C# 3.0 new language features by Kasim.Wirama

C# 3.0 new language features By : Kasim Wirama , MCDBA, MVP SQL Server .NET 3.5 has been launched in November 2007. I read and tried new features of C# language (code name : Orcas) with Visual Studio 2008. These are new features for C# 3.0 in .NET framework...
Filed under:
1
Comments

Data Flow behavior in SSIS by Kasim.Wirama

Data Flow behavior in SSIS By : Kasim Wirama, MCDBA, MVP SQL Server Data flow is the core of data processing in SSIS package, where data are handled, managed, processed, transformed, integrated and cleansed. You can say it is data pipeline, analogized...
Filed under:
0
Comments

Controlling Your Control Workflow in SSIS by Kasim.Wirama

Controlling Your Control Workflow in SSIS By : Kasim Wirama, MCDBA, MVP SQL Server This article will discuss more about parallel processing in workflow designer and how much maximum possible parallel thread can get executed in control flow designer. Control...
Filed under:
1
Comments

Understanding difference between control flow and data flow in SSIS by Kasim.Wirama

Understanding difference between control flow and data flow in SSIS By : Kasim Wirama, MCDBA, MVP SQL Server You might wonder to find out difference between control flow designer and data flow designer. At a glance, they are similar, so why to divide...
Filed under:
0
Comments

Viewing Flow of Your Data in SSIS by Kasim.Wirama

Viewing Flow of Your Data in SSIS By : Kasim Wirama, MCDBA, MVP SQL Server You can see output path from each transformation by right clicking the transformation path and choose Data viewers. It is very important feature for debugging your data. You can...
Filed under:
2
Comments

Transformation in SSIS by Kasim.Wirama

Transformation in SSIS By : Kasim Wirama, MCDBA, MVP SQL Server Key component of SSIS is transformation. SSIS provide many transformation components that you can see in toolbox with Control flow designer focused. You can process data flowing from one...
Filed under:
1
Comments

Data Destination component in SSIS by Kasim.Wirama

Data Destination component in SSIS By : Kasim Wirama, MCDBA, MVP SQL Server This article will show you kinds of destination components available in SSIS. They consume input data from either source component or transformation components. You need connect...
Filed under:
1
Comments

Data Source component in SSIS by Kasim.Wirama

Data Source component in SSIS By: Kasim Wirama, MCDBA, MVP SQL Server SSIS provide kinds of data source. Data source need connection manager as interface to your real data source. The source data’s connection manager is created in connection manager....
Filed under:
More Posts Next page »
Powered by Community Server (Commercial Edition), by Telligent Systems