Regular Columnist: Jacob Sebastian

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...

Real world solutions are key and having different techniques can sometimes help you code quicker. Longtime author Jacob Sebastian shows us how to solve a few problems with different techniques.  Read more...

The eleventh installment of the XML Workshop continues looking at namespaces. This time Jacob Sebastian examines default namespaces and how they impact your XML processing.  Read more...

With the tenth installment of his series on XML, Jacob Sebastian turns his attention to the art of namespaces and how you can avoid ambiguity in interpreting various elements.  Read more...

Continuing on with his great series on XML, Jacob Sebastian looks at elements of mixed types.  Read more...

This is the 8th installment of my XML Workshop which aims at explaining the details of working with XML in TSQL.   Read more...

SQL Server 2008, code named Katmai, has some very interesting additions to the SQL Server platform to make your development tasks easier. One of these is passing a table variable as a parameter to a stored procedure and regular columnist Jacob Sebastian shows us how.   Read more...

One of the more common requests of an application working with SQL Server is to deal with pages, or sections, or data rather than an entire result set. Often an application retreives the entire result set and then only shows the user a few records, repeating the process with the next page. Regular columnist Jacob Sebastian brings us a more efficient method of implementing paging in SQL Server 2005.   Read more...

We have a first look at one of the features in SQL Server 2008 that was cut from SQL Server 2005, but which has been highly anticipated. How many times have you written an "insert new, update match" routine? Jacob Sebastion shows us easy this becomes with the new MERGE keyword in SQL Server 2008.   Read more...