Further Reading

This chapter touched on a number of SQL Server 2000 issues and, in particular, a number of points related to T-SQL—the SQL dialect of SQL Server. The online documentation that comes with the product (SQL Server’s Books Online) is certainly a good starting point to learn more. If you’re interested in SQL Server 2000 from an architectural point of view, I recommend Kalen Delaney’s Inside SQL Server 2000 (Microsoft Press, 2000). Delaney’s book covers the basics of the T-SQL language, but it is not an in-depth guide to T-SQL, and should be accompanied with another text more specifically targeted to the SQL Server dialect. One that I’ve found useful is Ken Henderson’s The Guru’s Guide to Transact-SQL, (Addison Wesley, 2000).

Programming Microsoft SQL Server 2000 with XML by Graeme Malcolm (Microsoft Press, 2001) is a good introductory text for exploring XML extensions in SQL Server 2000. Because the book is a bit outdated, it does not cover SQLXML 3.0 and managed extensions.

Another topic introduced in this chapter is ADO.NET and batch updating. My book Building Web Solutions with ASP.NET and ADO.NET (Microsoft Press, 2002) includes a practical chapter on batch updating from the ASP.NET perspective. A broader and in some respects more thoughtful and technology-oriented coverage can be found in Francesco Balena’s Programming Visual Basic .NET (Microsoft Press, 2002). If you’re interested in the entire spectrum of ADO.NET technologies, take a look at David Sceppa’s Microsoft ADO.NET (Microsoft Press, 2002).