XML Workshop XVII - Writing a LOOP to process XML elements in TSQL

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.

XML Workshop XVI - Shaping the XML results

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.

XML Workshop XV - Accessing FOR XML results with ADO.NET

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.

XML Workshop XIV - Generating an XML Tree

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

Generating Missing Dates and Numbers

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.

SQLCE Workshop IV - Integration with Visual Studio 2005

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.

Max Storage Capacity of XML Data Type

SQLCE Workshop III - Getting started with 3.5 Beta

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.

XML Workshop XIII - XSD And Variable Content Containers

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

Creating Location Independent SSIS packages

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.