http://www.sqlservercentral.com/Articles tagged Programming, Basics posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This article will quickly dive head first right into XML. http://www.sqlservercentral.com/articles/Basics/20010422115709/78/2008/01/04http://www.sqlservercentral.com/articles/Basics/20010422115709/78/This article shows how to retrieve both remote and local XML data and display it in a data Web control.http://www.sqlservercentral.com/redirect/articles/3170/2007/09/10http://www.sqlservercentral.com/redirect/articles/3170/This article will quickly dive head first right into XML. http://www.sqlservercentral.com/articles/Basics/20010422115709/78/2008/01/04http://www.sqlservercentral.com/articles/Basics/20010422115709/78/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/Jon shows you several ways you can parse XML. http://www.sqlservercentral.com/articles/Miscellaneous/20010422115707/77/2004/10/01http://www.sqlservercentral.com/articles/Miscellaneous/20010422115707/77/This article will quickly dive head first right into XML. http://www.sqlservercentral.com/articles/Basics/20010422115709/78/2008/01/04http://www.sqlservercentral.com/articles/Basics/20010422115709/78/Jon shows you several ways you can parse XML. http://www.sqlservercentral.com/articles/Miscellaneous/20010422115707/77/2004/10/01http://www.sqlservercentral.com/articles/Miscellaneous/20010422115707/77/This article demonstrates the ability to use the XML DOM on the client-side browser. http://www.sqlservercentral.com/articles/Basics/20010422115713/79/2002/04/11http://www.sqlservercentral.com/articles/Basics/20010422115713/79/Andy read this book recently and gave it a great review. Even though it's not a SQL book! Seriously, take a look at the review. It's a good book that is fun to read. http://www.sqlservercentral.com/articles/Miscellaneous/reviewofdebuggingthedevelopmentprocess/612/2002/02/26http://www.sqlservercentral.com/articles/Miscellaneous/reviewofdebuggingthedevelopmentprocess/612/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it! http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/2002/02/06http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/This sample is provided in conjunction with the MSDN Magazine article, "SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web." This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency. http://www.sqlservercentral.com/redirect/articles/575/2002/01/18http://www.sqlservercentral.com/redirect/articles/575/Your database design should be impervious to this documented behavior of the ADO delete method. Be one of the first five members to give a compelling reason why not, and take a dollar from starving columnist Sean Burke. http://www.sqlservercentral.com/articles/Basics/noprimarykey/224/2001/05/21http://www.sqlservercentral.com/articles/Basics/noprimarykey/224/