Regular Columnist: Jacob Sebastian

MVP Jacob Sebastian has written a great series on working with XML in SQL Server and we have the latest installment today. This time he presents a library of functions that can produce an RSS ATOM compliant feed of data.  Read more...

When information is exchanged in XML format, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. An XSD (XML Schema Definition Language) Schema can be used to enforce this contract and validate the XML data being exchanged. Jacob Sebastian's book explains all.  Read more...

Continuing on with his series on SQL Server 2008, MVP Jacob Sebastian brings us a look at the debugger, which has returned in SQL Server 2008.  Read more...

RSS feeds are becoming almost required for any type of data publication. SQL Server MVP Jacob Sebastian brings us the next installment of his XML Workshop series that looks at a series of T-SQL functions to generate the RSS formatted data.  Read more...

SQL Server MVP Jacob Sebastian starts a new series looking at the changes in SQL Server 2008 to the management tools.  Read more...

This long running, and very popular, XML series continues with a look at building an ATOM feed with SQL Server.  Read more...

SQL Server MVP Jacob Sebastian continues his very successful XML series with a foray into SQL Server 2000's XML capabilities for generating custom documents.  Read more...

Continuing on with his amazing series on XML, SQL Server MVP Jacob Sebastian shows us how to use XML in SQL Server 2005 to generate an ATOM feed.  Read more...

Continuing on with part 18 of his series, MVP Jacob Sebastian examines building an RSS feed in T-SQL.  Read more...

Jacob Sebastian brings a little more complexity to working with XML documents. Here we learn how to iterate through a document and use each node and perform some action on each one.  Read more...

Continuing on with his series, Jacob Sebastian shows how you can shape the query results to a certain pre-defined XML structure in this article.  Read more...

The next installment of Jacob Sebastian's great series on XML looks at how a .NET application might consume XML data returned from SQL Server.  Read more...

Jacob Sebastian takes a look at some different ways to write your WHERE clauses. A good basic article for those starting to work with T-SQL.  Read more...

Finding missing data in a sequence of numbers or dates is a common request of DBAs. Regular author Jacob Sebastian brings us a new article that shows just how you can do this.  Read more...

Continuing on with his comprehensive series on XML, Jacob Sebastian shows us how to generate a tree of parent-child data using XML.  Read more...

Continuing on with his series on SQL Server 2005 Compact Edition, regular author Jacob Sebastian takes a look at how Visual Studio fits into your SQL CE project.  Read more...

Part 3 of his series looking at SQL Server Compact Edition, then embedded version of SQL Server. This time we look at the new version that's in beta.  Read more...

Building SSIS packages and deploying them to production can be a challenge as connection strings and directory structures change. Longtime SQL Server guru Jacob Sebastian brings us a technique for building packages to make this easier.  Read more...

Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.  Read more...

Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.  Read more...