In Lab 15, we saw how to modify an attribute based on the value of a variable. We used the value of a variable to locate the correct element. We located the element having a specific attribute with the value specified in a variable. Now let us ...

  In the previous labs, we have seen several examples of inserting/updating/deleting attributes. The syntax for updating the values of elements is slightly different from that of attributes. Let us see an example to understand this. <</...

  We had seen an example that demonstrated how to delete an attribute from an XML variable. Let us now try to delete an element from an XML document/variable. Here is the sample XML document for this lab. <sp......

  XML Data Type functions can be used to perform a number of string operations. This post explains how to parse a delimited string using the XML approach. The XML approach helps you to avoid the WHILE-LOOP that you might need with most other appro...

Finally, my XSD book is ready and is available for FREE download. Thank you Red-Gate for making the free download available. You can download the ebook from http://www.red-gate.com/specials/Ebooks/XSD_0409.htm I tried to explain XML Schema collectio...

Some of you must have noticed that I became a bit irregular in blogging for the past few months. I was busy working on a number of critical assignments and most of my free time was dedicated to building the new website www.beyondrelational.com (which is...

For those of you who are eager to know what is happening with me and with Tech-ED in Hyderabad, here is a quick update. The main attraction of the day was the Keynote session by Microsoft CEO Steve Ballmer. Keynote Auditorium <img style="borde...

Tech-ED is rocking and the second day was quite interesting. The day started with Keynote Session by Resul Pookutty (Oscar Award Winner – Film Sound Designer) Keynote Session by Resul Pookutty Resul gave a detailed overview of how technology is us...

Tech-ED India 2009 is over. It was a great experience meeting a lot of technology experts, product team and developers from all around the country. I met many readers of my blogs and articles and had a great time interacting with them. It was really int...

I am exploring the FILESTREAM data type these days for my next book. So expect a number of blog posts on FILESTREAM in the next few weeks. Yes, I am back to SQL Server blogging after a short break. I would like to start with clarifying a common misund...