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
Learn to implement exception handling mechanism in C++.
The addition of ValueTask to the asynchronous tool box has been a big new feature in C# 7.
Learn how you can use Visual Basic to make a program that mounts ISO files.
Take advantage of pattern matching to check for patterns in your code, improve performance, and simplify your code.