Build a Custom Research Pane for Excel with VSTO   21 Jul 2006 18:16 GMT
Action Panes provide a convenient way for developers to inject custom UI into Office applications, saving users the time and effort of launching and copying information between separate applications.
Source: DevX

Prepare for SQL Server Everywhere   21 Jul 2006 00:03 GMT
Introduces SQL Server Everywhere, a slimmed-down version of SQL Mobile. SQL Everywhere removes the restrictions that keep the SQL Mobile product from running on a desktop or laptop, making SQL Everywhere the ideal database for many scenarios.
Source: MSDN

Automatically Update Visual Basic 6 Applications with .NET and ClickOnce   20 Jul 2006 21:53 GMT
See how to automatically update Visual Basic 6.0 applications and COM objects, using the .NET Framework 2.0 and ClickOnce deployment.
Source: MSDN

3-tier Architecture with ASP.NET 2.0: Tutorial 2: Creating a Business Logic Layer (Visual Basic)   20 Jul 2006 18:34 GMT
A well-architected application is crafted into distinct layers, each of which encapsulates a particular role; in this tutorial we build a Business Logic Layer as a series of classes in our application's App_Code folder that call down into our DAL.
Source: MSDN

Flickr-ing about with .NET   20 Jul 2006 17:18 GMT
Sam Judson shows you how simple, easy, and fun it is to integrate the Flickr API into your "Web 2.0" Web-based applications. This public API provides you with new and interesting ways to display and manipulate your photos.
Source: MSDN

3-tier Architecture with ASP.NET 2.0: Tutorial 2: Creating a Business Logic Layer (Visual C#)   19 Jul 2006 20:41 GMT
A well-architected application is crafted into distinct layers, each of which encapsulates a particular role; in this tutorial we build a Business Logic Layer as a series of classes in our application's App_Code folder that call down into our DAL.
Source: MSDN

Interview with Jakob Nielsen   19 Jul 2006 07:36 GMT
Matt Mickiewicz interviews Jakob Nielsen, author of the brand new book "Prioritizing Web Usability," about AJAX, usability's close link to keyword advertising, and some of the advertising formats we're seeing around the Web today.

Source: SitePoint

Common Table Expressions (CTE) in SQL Server 2005   19 Jul 2006 00:00 GMT

When crafting a query in SQL, there are often times when we may need to operate over a set of data that doesn't inherently exist within the system. For example, the database for an eCommerce web application would have the standard tables - Products, Customers, Orders, OrderDetails, and so on - but we may need to run reports on a particular subset of the data or against aggregate data across these tables. Or the reporting queries we need might need to group or filter by results returned by scalar subqueries. Typically, views are used to break down complex queries into digestible chunks or to provide scalar subquery results that can be grouped and filtered. Views, however, are sometimes overkill, as they are permanent objects at the system-level. If we only need to reference this complex query in a single stored procedure or UDF, another option is to use a derived table. Unfortunately, derived tables muddle the readability of the query and must be repeated for each use in a statement.

Common Table Expressions, or CTE, are a new construct introduced in Microsoft SQL Server 2005 that offer a more readable form of the derived table that can be declared once and referenced multiple times in a query. Moreover, CTEs can be recursively defined, allowing a recursive entity to be enumerated without the need for recursive stored procedures. In this article we'll examine the benefits, uses, and syntax of both recursive and non-recursive CTEs. Read on to learn more!
Read More >

Source: 4GuysFromRolla

Using PHP and Flex to Browse a MySQL Database   18 Jul 2006 23:03 GMT
PhpMyAdmin is a powerful, open source, graphical user interface to MySQL, the most popular freely available database application. This article explores how to replicate some of the phpMyAdmin functionality, using a combination of PHP and Flex to create an even more elegant application for browsing a database.
Source: DevX

Achieving Synchronicity: A ListBox Double Feature   18 Jul 2006 02:28 GMT
See how to combine two Rendered controls to create a single control that provides the ability to move items both within and between lists.
Source: DevX