Bhullar 's Development Arena

Sql Server Integration Services

2010-06-06T12:45:00.000-07:00

SQL Server Integration Services (SSIS) “is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.” A simpler way to think of SSIS is that it's the solution for automating SQL Server. SSIS provides a way to build packages made up of tasks that can move data around from place to place and alter it on the way. There are visual designers (hosted within Business Intelligence Development Studio) to help you build these packages as well as an API for programming SSIS objects from other applications.

Though SSIS is almost infinitely customizable, Microsoft has produced a simple wizard to handle some of the most common ETL tasks: importing data to or exporting data from a SQL Server database. The Import and Export Wizard protects you from the complexity of SSIS while allowing you to move data between any of these data sources:

* SQL Server databases
* Flat files
* Microsoft Access databases
* Microsoft Excel worksheets
* Other OLE DB providers

You can launch the Import and Export wizard from the Tasks entry on the shortcut menu of any database in the Object Explorer window of SQL Server Management Studio.

For more details please visit:
http://www.accelebrate.com/sql_training/ssis_tutorial.htm

Describing Windows Communication Foundation

2010-03-31T11:04:00.000-07:00

The move to service-oriented communication has changed software development. Viewing services as a distinct software abstraction is fundamental to service-oriented architecture (SOA), an approach that many organizations are putting in place today. Whether implemented using SOAP or in some other way, applications that interact through services are becoming the norm.

Software development environments must keep pace with these changes. The benefits services bring should be reflected in the tools and technologies that developers use. Windows Communication Foundation (WCF), Microsoft’s technology for service-oriented applications, is designed to address these requirements. First released as part of the .NET Framework 3.0 in 2006, an updated version of this technology is included in the .NET Framework 3.5. For a large share of new software built on .NET, WCF is the right foundation.

WCF is designed in accordance with service oriented architecture principles to support distributed computing where services are consumed by consumers. Clients can consume multiple services and services can be consumed by multiple clients. Services are loosely coupled to each other. Services typically have a WSDL interface which any WCF client can use to consume the service, irrespective of which platform the service is hosted on. WCF implements many advanced web services (WS) standards such as WS-Addressing, WS-ReliableMessaging and WS-Security.

[edit] Services

A WCF service is composed of three parts — a Service class that implements the service to be provided, a host environment to host the service, and one or more endpoints to which clients will connect. All communications with the WCF service happens via the endpoints. The endpoints specify a Contract that defines which methods of the Service class will be accessible via the endpoint; each endpoint may expose a different set of methods. The endpoints also define a binding that specifies how a client will communicate with the service and the address where the endpoint is hosted.
In Windows Vista, Windows Server 2008 and Windows 7 (operating systems that include IIS 7), Windows Activation Services can be used to host the WCF service. Otherwise the WCF service can be hosted in IIS, or it can be self-hosted in any process by using the ServiceHost class, which is provided by WCF. A self-hosted WCF service might be provided by a console-based application, a Windows Forms application, or a Windows service (the Windows counterpart to a daemon), for example.

Endpoints

A WCF client connects to a WCF service via an endpoint. Each service exposes its contract via one or more endpoints. An endpoint has an address, which is a URL specifying where the endpoint can be accessed, and binding properties that specify how the data will be transferred.
The mnemonic "ABC" can be used to remember Address / Binding / Contract. Binding specifies what communication protocols are used to access the service, whether security mechanisms are to be used, and the like. WCF includes predefined bindings for most common communication protocols such as SOAP over HTTP, SOAP over TCP, and SOAP over Message Queues, etc. Interaction between WCF endpoint and client is done using SOAP envelope. SOAP envelope are in simple XML form that make WCF platform independent.
When a client wants to access the service via an endpoint, it not only needs to know the contract, but it also has to adhere to the binding specified by the endpoint. Thus, both client and server must have compatible endpoints.
With the release of the .NET Framework 3.5 in November 2007, Microsoft released an encoder that added support for the JSON serialization format to WCF.^[1] This allows WCF service endpoints to service requests from AJAX-powered web pages.

*Kindly note above information is taken from different different websites.

The Big Short: Inside the Doomsday Machine

2010-03-31T10:50:00.001-07:00

Silverlight 4 Beta

2010-01-05T21:08:00.000-08:00

Hello every body,
Hope you will be fine there.

As we all know that Silverlight 4 Beta is in the market and every one has started working over it and me too. So I would like to let you people know that what i have studied so far.

In SL 4 Beta there are new amazing features have been added in it.
New Features for Application Developers

* Comprehensive printing support enabling hardcopy reports and documents as well as a virtual print view, independent of screen content.
* A full set of forms controls with over 60 customizable, styleable components. New controls include RichTextbox with hyperlinks, images and editing and Masked textbox for complex field validation. Enhanced controls include DataGrid with sortable/resizeable columns and copy/paste rows.
* WCF RIA Services introduces enterprise class networking and data access for building n-tier applications including transactions, paging of data, WCF and HTTP enhancements.
* Localization enhancements with Bi-Directional text, Right-to-Left support and complex scripts such as Arabic, Hebrew and Thai and 30 new languages.
* The .NET Common Runtime (CLR) now enables the same compiled code to be run on the desktop and Silverlight without change.
* Enhanced databinding support increases flexibility and productivity through data grouping/editing and string formatting within bindings.
* Managed Extensibility Framework supports building large composite applications.
* Exclusive tooling support for Silverlight, new in Visual Studio 2010. Including a full editable design surface, drag & drop data-binding, automatically bound controls, datasource selection, integration with Expression Blend styling resources, Silverlight project support and full IntelliSense.

Developer tools

* Fully editable design surface for drawing out controls and layouts.
* Rich property grid and new editors for values
* Drag and drop support for databinding and automatically creating bound controls such as listbox, datagrid. New datasources window and picker.
* Easy to pick styles and resources to make a good looking application based on designer resources built in Expression Blend.
* Built in project support for Silverlight applications
* Editor with full intellisense for XAML and C# and VB languages.

Above given information has been taken from silverlight web site

http://silverlight.net/getstarted/silverlight-4-beta/

Getting Started With Silverlight

2009-12-14T09:12:00.001-08:00

Hello To All.

As i always try to help my friends by giving them source code and links to tutorial
so that they can start doing work easily and more quickly.
Here i have i link of video in which you will come to know how to start with Silverlight application:

http://silverlight.net/learn/videos/silverlight-videos/getting-started-with-silverlight-development/

The calling thread cannot access the object because different thread owns it

2009-11-05T00:05:00.000-08:00

Hello Friends as i have mentioned the error in the Title has been solved.I m posting it on the net so that you can get help from it.Please also see the links given below.

///

/// This method is getting voice input from microphone
/// Hardeep Bhullar
/// 1/11/2009
///
///
/// Description Of Change
///

private void Voice_In()
{
try
{
bool firstTime = true;
_sendingPortText = (string)this.Dispatcher.Invoke(new Func(() => this.TextBoxSendingPort.Text));
byte[] br;
//this.Dispatcher.BeginInvoke(DispatcherPriority.Normal, (Action)(() =>
//{
_socket.Bind(new IPEndPoint(IPAddress.Any, int.Parse(_sendingPortText)));
//}));
while (true)
{
br = new byte[16384];
if (firstTime)
{
firstTime = false;
//Thread.Sleep(250);
}

_socket.Receive(br);
m_Fifo.Write(br, 0, br.Length);
}
}
catch (Exception ex) { }
}

///

/// This method is passing out the recorded voice to the speakers
/// Hardeep Bhullar
/// 1/11/2009
///
///
/// Description Of Change
///

private void Voice_Out(IntPtr data, int size)
{
try
{
string strOtherMachineIP = (string)this.Dispatcher.Invoke(new Func(() => this.TextBox1.Text));
//for Recorder
if (m_RecBuffer == null || m_RecBuffer.Length < size)
m_RecBuffer = new byte[size];
System.Runtime.InteropServices.Marshal.Copy(data, m_RecBuffer, 0, size);
IPEndPoint m_endPoint;
//this.Dispatcher.Invoke(DispatcherPriority.Normal, (Action)(() =>
//{
//Microphone ==> data ==> m_RecBuffer ==> m_Fifo
//get the end point.
m_endPoint = new IPEndPoint(IPAddress.Parse(strOtherMachineIP), int.Parse(_sendingPortText));
// _socket.SendTo(m_RecBuffer, new IPEndPoint(IPAddress.Parse(strOtherMachineIP), int.Parse(sendingPortText)));
_socket.SendTo(m_RecBuffer, m_endPoint);
//}
//));
}
catch (Exception Ex) { }
}

http://social.msdn.microsoft.com/Forums/en-US/wpf/thread/885d6b03-0699-472b-867b-e526c93d8fb8/

Peer To Peer Video Streaming C#

2009-10-27T00:25:00.000-07:00

Hello To All,

This is my first blog on P2P Streaming.When i started working on it i found it very hard but later
i felt easy and continued my development.Now i m able to capture from webcam .I can broadcast my webcam to the persons who are in my mesh or group. But the problem comes when i try to view another webcam on my application ,Stream gets mixed it shows mixed stream of two webcam 's .I googled, researched and worked very hard to get a way but no gain.So i decided to post a blog on P2P Streaming.

I m developing my application in WPF Browser Application.
*Certificate problem is there it should be installed automatically right now i have to install it manually.
Please help me to get the best solution.

Thanks ans Best Regards
Hardeep Singh Bhullar