Learn to how to make SQL Server Integration Services a part of Windows Workflow Foundation.

Want to store documents or photos in SQL server? Learn how SQL Server and ADO.NET together can provide an elegant solution for storing and retrieving BLOBs.

Store XML data directly in SQL Server. Use the power of the XML data type to store and manipulate XML data efficiently and easily.

Microsoft Office SharePoint Services (MOSS) 2007 introduced a mechanism to integrate back-end systems and Line of Business processes with the Portal infrastructure, bringing external data inside the Portal. In addition to creating XML schemas manually, with SharePoint's Object Model the BDC can be generated programmatically.

When you pass arguments to a subroutine or function, you absolutely must know whether the type is a value type or a reference type. Only then can you determine which keyword to use to pass the data.

In development scenarios where you make multiple changes to the database, consider using transactions and, optionally, nesting transactions.

Caching can dramatically improve the performance of a database-driven .NET application. The Enterprise Library caching block encapsulates the plumbing code required to implement caching in a reusable block.

By encapsulating the plumbing code in the data-access layer of applications, the Data Access Application Block, part of Microsoft's Enterprise Library, frees you from the tedious details of data access and allows you to concentrate on the business logic in your applications.

Data access can be a real bottleneck when you work on Web applications that use dynamic content. Luckily, the ASP.NET runtime offers data-caching services that can help. Learn how to effectively implement them without over-complicating your code.

Does your C# ASP.NET application scream or does it trip along? In the newest installment from industry leader, Jeff Prosise, you learn to use the application cache to make your applications scream.