Building Microsoft Oslo Models
Rating: none
Jeffrey Juday - 12/18/2008
Learn modeling and M development with the Oslo CTP SDK.

Exploring the Oslo Repository
Rating: none
Jeffrey Juday - 12/08/2008
Walk through examples and see how existing Repository models are constructed using the M language, how the models are stored in a SQL database, and how to query the SQL database for model information.

.NET Tip: Using a Nullable Value Type
Rating: none
Jay Miller - 10/03/2008
Discover how to use nullable types when retrieving data from your database.

Introducing Visual Studio Team System 2008 Database Unit Testing
Rating:
Jeffrey Juday - 07/14/2008
Learn how to build Unit tests and generate sample data for your database development projects.

Auditing in SharePoint 2007
Rating: none
Gustavo Velez - 06/27/2008
Careful registration of information in a Portal can be vitally important to a company, not only internally but also for possible juridical consequences. SharePoint 2007 has the necessary infrastructure to gather and conserve the entries in a secure way.

Working with the XML Data Type of SQL Server
Rating: none
Bipin Joshi - 06/25/2008
Store XML data directly in SQL Server. Use the power of the XML data type to store and manipulate XML data efficiently and easily.

A Database Driven Reporting Application
Rating: none
Chi-Wei Wang - 06/16/2008
Discover how reporting applications can adapt to changing reports by shifting its report-related information into a database.

Leveraging Content Types in SharePoint Document Libraries and Lists
Rating: none
Daan De Brouckere and Raj Agarwal - 06/04/2008
Many organizations are not fully realizing the power of content types when using SharePoint. Here you will learn how to leverage content types and use them properly through examples.

Controlling SQL Text Indexing Services with SQL Managed Objects and VB.NET
Rating: none
Paul Kimmel - 05/28/2008
Control the SQL Server service from your VB code using SQL Management Objects (SMO).

.NET Tip: Sort an ArrayList Using a Custom Comparer Class
Rating: none
Jay Miller - 05/09/2008
Provide your own comparison algorithm when sorting by implementing the IComparer interface.

.NET Tip: Sort Your Objects by Implementing the IComparable Interface
Rating: none
Jay Miller - 04/18/2008
Allow your classes to easily be sorted they way you would like by implementing the IComparable interface.

Using Connection Pooling in ADO.NET
Rating: none
Bipin Joshi - 02/25/2008
Learn how ADO.NET connection pooling works and how to configure it to suit your performance requirements.

Building a BizTalk Pipeline Content Enricher with SQL Server 2005
Rating:
Jeffrey Juday - 11/05/2007
Learn how to implement the Content Enricher integration pattern using BizTalk 2006 R2 and SQL Server 2005.

Implementing a Custom ConnectionString Installer for Setup
Rating: none
Paul Kimmel - 10/10/2007
See how a setup project with a custom action lets the user define the connection string using the Data Links dialog and encrypt that connection string using RSA encryption.

Business Data Catalog in Microsoft Office SharePoint Server 2007: Architecture and Schemas
Rating: none
Gustavo Velez - 10/03/2007
Microsoft Office SharePoint Services (MOSS) 2007 introduces a mechanism to integrate back-end systems and Line of Business processes with the Portal infrastructure, bringing external data inside the Portal.

The Basics of Manipulating File Access Control Lists with C#
Rating: none
Jani Järvinen - 09/26/2007
Learn about file access control lists and how to use C# to read and modify them to improve the security of your applications and your IT infrastructure.

SqlProcessor
Rating: none
cigsmh - 09/12/2007
This class can work with any database that supports ADO.NET and saves a lot of code writing.

BizTalk Pipeline Dreams Become Reality
Rating: none
Jeffrey Juday - 08/16/2007
Learn how to more easily extend, re-use, and configure a BizTalk Custom Pipeline Component.

Connecting to Oracle or Access from ASP.NET 2.0
Rating: none
Devin Rader and Bill Evjen - 04/25/2007
Discover how to use the ASP.NET 2.0 SqlDataSource and AccessDataSource Controls to work with Oracle and Access data from Wrox Professional ASP.NET 2.0 Special Edition authors Bill Evjen and Devin Rader.

SQL Server 2005: Creating Scalar User-Defined Functions from Assemblies
Rating: none
Robert Vieira - 04/11/2007
Learn some of the differences between SQL stored procedures and scalar functions in .NET code from Wrox Professional SQL Server 2005 Programming author Robert Vieria.

Database Tip: Managing Transactions with a Stack
Rating: none
Eric Smith - 03/12/2007
In development scenarios where you make multiple changes to the database, consider using transactions and, optionally, nesting transactions.

.NET Tip: Compressing/Decompressing Your Files
Rating: none
Eric Smith - 03/02/2007
One of the many new libraries included with .NET 2.0 allows for compression and decompression of files using the gzip file format. Find out how to use it.

User Profiles and Audience Targeting in SharePoint 2007
Rating: none
Sahil Malik - 02/14/2007
Organizations struggle with communicating only relevant information to its members, especially when that information lives in disparate systems that do not talk to each other. SharePoint 2007 provides an answer with user profiles and audience targeting.

A BizTalk Administration Solution for Real-Time Data Warehousing
Rating: none
Jeffrey Juday - 02/09/2007
Designing an administration solution for your real-time data warehouse is important to the long-term success of your BizTalk solution. Picking a platform your users are comfortable with is a good start.

Recursive XSL Templates
Rating: none
kirang - 01/09/2007
Learn about the recursive nature of call templates.

The Only Data Access Layer You'll Ever Need?
Rating:
Paul Kimmel - 12/20/2006
A useful data access layer (DAL) makes managing persistence easier than writing CRUD behaviors all over your code. Learn to build a flexible, simple one that does just that with a relatively few lines of code.

Many-to-Many Relationships in O/R Mapping
Rating: none
Iqbal M. Khan - 11/13/2006
If you are developing an object-oriented .NET application that has to talk to a database, you'll inevitably map objects to a relational model. And, most likely, you'll face situations where many-to-many relationships exist in your database. Learn how to handle these situations with ease.

IBM DB2 Application Development with Visual Studio .NET
Rating: none
Anil Mahadev - 09/18/2006
Thanks to the DB2 Development Add-In for Visual Studio .NET, you can develop DB2 database applications using Visual C#.

Reporting on Hierarchical Recursive Data Using MS Reporting Services
Rating: none
Asif Sayed - 07/05/2006
Here's a new twist on creating database reports.

.NET Sorting: Compare Just About Any Property of Any Object
Rating:
Paul Kimmel - 06/23/2006
Implement the generic interface IComparer with some reflection, and .NET will provide sorting that compares just about any property of any object. See how it's done.

DLINQ: Submitting Your Changes
Rating: none
Sahil Malik - 06/16/2006
Submitting changes as update, insert, and delete queries is at the heart of any data-driven application. Learn the various support options DLINQ offers for these tasks.

Transactions in the .NET 2.0 Framework
Rating: none
Joe Duffy - 05/04/2006
Learn about the importance of transactions and key transaction management features in .NET 2.0 from JOe Duffy, author of Professional .NET Framework 2.0.

Domain Objects Caching Pattern for .NET
Rating: none
Iqbal2004 - 04/27/2006
Explore how to cache your domain objects and put caching code inside your persistence classes.

Eliminate Unnecessary Code and Boost Performance with C# 2.0 Iterators
Rating: none
Mark Strawmyer - 01/05/2006
With the .NET Framework 2.0 release now available, you can explore the C# 2.0 iterators feature. Examine the iterators design pattern and find out what it takes to implement and then modify it manually.

System.Transactions: Implement Your Own Resource Manager
Rating: none
Sahil Malik - 11/18/2005
Very few resource managers (RMs) are available with the framework of System.Transactions right now. So why not write your very own RMs and use them in conjunction with the hordes of RMs that will appear in future releases of the .NET Framework?

For Developers, Microsoft Has More in Store than Ever Before, Part 2
Rating:
Patrick Gallucci - 10/10/2005
Microsoft announced so many new tools and technologies at its Professional Developers Conference (PDC) 2005 that our "man on the scene" needed a second article to cover it all. Find out what else Redmond has planned for .NET developers.

Create Provider-Independent Data Access Code with ADO.NET 2.0
Rating: none
Thiru Thangarathinam - 08/26/2005
ADO.NET 2.0 offers new base classes and factory classes that enable you to write data access code that works with almost all data stores. Find out how to seamlessly working with multiple providers like SqlClient, OleDb, and ODBC without having to lock into a specific implementation.

What .NET 2.0 Has in Store for ADO.NET
Rating: none
Mark Strawmyer - 05/11/2005
Take a foray into ADO.NET to see what's in store for the next release. You'll find some very handy additions and enhancements.

Database Provider-Independent Data Access Layer Using ADO.NET 2.0
Rating:
SeenivasaRagavan Ramadurai - 03/17/2005
Learn to use ADO.NET 2.0 to access data layers.

Managed C++: Write Image Data Using the ADO.NET Command and Parameter Objects
Rating: none
Tom Archer - MSFT - 02/04/2005
Tom Archer illustrates in step-by-step fashion how to read an image file from disk and then save it to a SQL Server database by using the ADO.NET SqlCommand and SqlParameter objects.

Generic Code to Execute Stored Procedures
Rating:
Sriram Surapureddy - 01/26/2005
Generic code to execute any stored procedure/batch of stored procedures with different number of parameters and data types

Reading From Databases
Rating:
Wiley Publishing - 11/08/2004
Learn some time-saving tricks to use ASP.NET to read information from a database to your Web site.

A Practical Guide to a Post-Relational Database for .NET: Matisse
Rating:
johnssk - 04/12/2004
This is a step-by-step guide for a post-relational database for .NET that provides you with better productivity and extensibility for data management. The article aims to help developers quickly evaluate this alternative solution for .NET database.

Developing an Application Integration Component (AIC) in BizTalk Server to Parse XML Data and Store
Rating: none
Syed Hameed - 03/29/2004
Application Integration Component (AIC) can be developed in BizTalk Server to parse XML data and store into SQL Server table.

Parsing Data Files
Rating:
Mark Strawmyer - 03/08/2004
Learn more about reading from files and examine the task of parsing data from a file.

Doing Database Operations In Batches
Rating:
Tom Archer - MSFT - 02/26/2004
There are times when it is advantageous to perform certain database operations in batch. This excerpt from Extending Applications with the .NET Framework details how and when.

Performing Various Iteration Methods in .NET
Rating: none
Trevor Misfeldt - 05/02/2003
Iterate through data as quickly as possible. This article shows a comparison of various methods for iterating through data in .NET.