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 CodeGuru Developer Columns
Here, the proverbial rubber meets the road. Finish this project and create a working magnifier.
Explore making use of batch files to delete the program, but only after the program has been closed. Examples are in C# and VB.NET.
Discover the world of Portable Class Libraries (PCLs) and how they can work for you.