Refactoring and static code analysis tool for SQL Server
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Jacob's Blog

Recent Blog Posts

Most Viewed

Archive

Review of “The ART OF XSD – SQL Server XML Schema Collections” by ASP.NET MVP Hima Vejella

I was very much surprised to see a fabulous review of my book ‘ The Art of XSD – SQL Server XML Schema Collections ’ by Hima Vejella , a well known .NET expert, author and speaker from the Microsoft Most Valuable Professionals (MVP) community. It took...
Posted: 06-14-2010 7:31 AM by Jacob Sebastian | with 1 comment(s)
Filed under: , , , , , ,

SQL Server XML Schema Collections Deep Dive Course

This is a full day course that focuses on learning XSD and XML Schema Collections. SQL Server supports a limited subset of the XSD specification. This session will examine all the XSD features supported in SQL Server 2005 and all the new features added...
Posted: 01-01-2010 8:52 AM by Jacob Sebastian | with no comments
Filed under: , , ,

My Latest Book: “The Art of XSD - SQL Server XML Schema Collections” available for free download

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 collections...
Posted: 04-26-2009 7:58 AM by Jacob Sebastian | with 2 comment(s)
Filed under: , , ,

Practical SQL Server XML: Part Three

This is the third part of the XML blog series which intends to demonstrate some practical usages of the XML support extended by SQL Server 2005 and 2008. SQL Server MVP Pinal Dave wrote the first post in this series at http://blog.sqlauthority.com/2009...
Posted: 03-17-2009 5:39 AM by JacobSebastian | with no comments
Filed under: , ,

SQL Server XSD - Typed XML and SCHEMA Collections

Introduction SQL Server 2005 supports two flavors of XML, namely TYPED and UNTYPED. A TYPED XML column or variable is bound to an XML schema which defines the structure of the XML that the variable or column can store. An UNTYPED XML variable or column...
Posted: 03-15-2009 8:33 AM by Jacob Sebastian | with no comments
Filed under: ,

SQL Server XSD - Creating variable content containers

Introduction There are times when we need to allow data with different XML structures. Let us take an example. Assume that we are working on a billing application and we need to store the payment details. Our application supports the following payment...
Posted: 03-14-2009 8:42 AM by Jacob Sebastian | with no comments
Filed under: ,

SQL Server XSD - Mixed Types

Introduction XML is getting widely accepted as the format for data exchange. Wide adoption of architectures like SOA (Service Oriented Architecture) contributed to the growth of applications and services that talk to each other and exchange data in XML...
Posted: 03-13-2009 8:44 AM by Jacob Sebastian | with no comments
Filed under: ,

SQL Server XSD - Custom Types and Inheritance

Introduction The previous articles were focusing on TYPED XML and had been explaining how to generate an XML schema that can be used to validate the XML data. We have seen how to validate the existence of elements and attributes, how to validate data...
Posted: 03-11-2009 8:46 AM by Jacob Sebastian | with no comments
Filed under: , ,

SQL Server XSD - Validating values with SCHEMA

Introduction In the previous article we have seen how to work with TYPED XML and XML SCHEMAs. By using a TYPED XML which is bound to an XML SCHEMA, you can make sure that the value being stored to your XML column or variable is EXACTLY as per the format...
Posted: 03-10-2009 8:47 AM by Jacob Sebastian | with no comments
Filed under: , ,

XML Workshops

  XML Workshop - A series of XML articles published at www.sqlservercentral.com XML Workshop I - Generating XML with FOR XML - A short article that explains how to generate XML output with TSQL keyword FOR XML with AUTO and RAW directives XML Workshop...
Posted: 12-20-2007 12:19 AM by Jacob Sebastian | with no comments
Filed under: , , , ,

Copyright © Beyondrelational.com