SQL Server 2000 developers and DBAs who've been yearning for better XML support in SQL Server will be pleased with the new XML datatype in SQL Server 2005. If you're one of them, learn the fundamentals of the datatype so you can get going.
Latest SQL Server Articles - Page 6
Learn all you need to know about the CLR integration available in SQL Server 2005. Get a high-level introduction, followed by a discussion of the implications of writing database objects in CLR code and a comparison with existing alternatives such as T-SQL or extended stored procedures.
SQL Server 2005 is the first version to include end user reporting capabilities. See how the new Report Builder makes it easy for analysts to generate reports while avoiding the performance pitfalls of completely ad hoc reporting.
Hibernate is the most popular and most complete open source object/relational mapping solution for Java environments. Learn Hibernate by using a simple Java application.
Before embarking a major database change such as upgrading to SQL Server 2005, how do you assess the scope of the change on your DTS packages? Use the DTS class library and .NET Interop.
Learn how to create and execute packages using SQL Server 2005's new ETL platform SQL Server Integration Services and its integrated development environment, Business Intelligent Development Studio.
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#.