Generate ATOM feed in Microsoft SQL Server

Microsoft SQL Server 2005 can generate XML document straight from the relational tables. If you want to publish an ATOM feed based on data stored in your database, you no longer have to write complex server-side scripts; the SQL server can do all the work for you. I've described the step-by-step solution complete with code samples and printouts in an article “Generating Atom Feed from SQL Data” that was recently published by InformIT.

Implementing Access Controls on SQL Server Data

Most relational databases provide fine-tuned access controls to various objects in the database, including tables, views, and indices, but lack the support for individual row (record) access control. In the “Implementing Access Controls on SQL Server Data” article I wrote for InformIT, I'm describing how you can implement record-level access control in any relational database that supports triggers and separate access controls for views and underlying tables.

XML Handling in Microsoft SQL Server 2005

InformIT.com has just published my article describing how you can use XML data type in SQL Server 2005 to optimize SQL queries and updates.

Storing XML Data in a Relational Database

The Storing XML Data in a Relational Database article just published by InformIT.com describes the various methods you can use to store XML data in an SQL database. I've also tried to explain when it would be appropriate to store XML data in a database and when you'd be better off using the traditional relational database model. The rest of the article details the procedures you can use to insert, query, retrieve and modify the stored XML data.

Serve SQL data in XML format

InformIT has just published my next article that explains various options you have when your data resides in an SQL database and the client side of your AJAX application expects the data in XML format. The article covers a number of different approaches, including:

• Creating the XML markup in the server-side script
• Using the SQL server to generate the XML markup
• Using server-side XSLT transformation in combination with SQL server-produced XML data