By Eric Knorr – For conclusive evidence, look no further than the staid, slow-moving world of relational database management, which is embracing XML as its own.

Yukon is the version of SQL Server that will bring .NET, the Common Language Runtime environment and XML much deeper into the plumbing of the database engine and build in considerable scale-up engineering. SQL Server 2000 had some native capability for importing XML documents and doing qu

Microsoft® ActiveX® Data Objects (ADO) is a data access interface used to communicate with OLE DB-compliant data sources, such as Microsoft SQL Server™ 2000. Data consumer applications can use ADO to connect to, retrieve, manipulate, and update data from an instance of SQL Server.

In this tutorial you are going to learn everything in detail step by step you’ll ever want to know about inserting binary data ( images, zip files etc ) into database. This is actually first of the three articles I am going to write on manipulating binary data in the database.

by Randy Dyess – This article is the second article in a series to share those stored procedures and methods I have learned with you, in order to help you document and learn a new environment if you move on, or obtain another project at your existing company.

By Brian Moran – Microsoft’s new .NET Compact Framework and SQL Server CE 2.0 might encourage the development of killer apps for mobile devices that even SQL Server administrators couldn’t live without.

By Jorge Cano – These kinds of tasks are a little more complex because we have to take care of the objects that we’ll move (or migrate) from Access to SQL Server. SQL Server has some tools and wizards that can help you, like the Enterprise Manager, Query Analyzer and others. SQL Server does not mana

Randy Holloway explains how to use SQLXML 3.0 with SQL Server to expose Web services through your ASP.NET applications by executing T-SQL stored procedures and user-defined functions.

By Bruce Johnson – By now, you have listened to reason and are utilizing stored procedures when working with you database. Assuming that you’re not using Access, that is. The reasons for taking advantage of stored procs are both numerous and beyond the scope of this articles. Just trust me on this o

By Subhagata Swarnakar – Among the many things that are changing with .NET is data access. Under the .NET Framework, data access is handled by a set of classes called ADO.NET which are essentially an augmentation of the existing ActiveX Data Objects (ADO).The ADO.NET components have been des