There is a plethora of new T-SQL features and enhancements in SQL Server 2005. Learn about one of them specifically, Common Table Expressions (CTE), because they often come in handy.
Latest Database Articles - Page 6
Table-valued user-defined functions (UDFs) are functionally similar to views but structurally similar to stored procedures, giving them all the important features of views and stored procedures and some additional functionality that they lack.
Learn to implement and OLE and IDispatch interface to access basic Excel functions from a C++ application.
In ASP.NET 2.0, you can customize the session state store as per your requirement. Explore one of the scalable and reliable approaches for storing session variables—SQL Server.
Learn how to process XML documents' content with the Microsoft COM implementation of Simple API for XML (SAX).
Need to gather some metrics on the steps within your BizTalk 2004 Orchestration? Check out Business Activity Monitoring (BAM).
Latest Developer VideosMore...
Latest CodeGuru Developer Columns
The Transactional File System (TxF), which allows access to an NTFS file system to be conducted in a transacted manner through extensions to the Windows SDK API. MFC 10, has been extended to support TxF and related technologies. This support allows existing MFC applications to be easily extended to support kernel transactions.
Adding extra fields to an ASP.NET membership set-up doesn't have to be difficult, especially if there is only a small amount of data.
Hannes du Preez explains what delegates are and how to use them to call managed and unmanaged code in VB.NET.
This article introduces you to Big Data, Apache Hadoop and MapReduce jobs. We will also learn how to create MapReduce jobs using C#.