Getting started with SQL Azure

The cloud services from Microsoft for SQL Server are known as SQL Azure. MVP Jacob Sebastian brings us a introductory article about how to work with this service.

T-SQL Challenge #1

Do you want to improve your T-SQL skills? MVP Jacob Sebastian runs regular challenges to get you to think about how to solve a problem in T-SQL. These run monthly and we have a summary and explanation from challenge #1 to help you learn more about moving data from 3 tables into a specific format.

XML Workshop 24 - Modifying XML Documents Using XQuery Part 1

This next few installments of this series from MVP Jacob Sebastian will deal with how to modify XML documents. Part 1 looks at XQUERY.

XML Workshop XXIII - A TSQL ATOM Library

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.

Passing a Table to a Stored Procedure

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.

SQL Server XML Schemas

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.

• Download free eBook
• Printed book:
  • US
  • UK

SQL Server 2008 SSMS Enhancements - Debugging Support

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.

XML Workshop XXII - A TSQL RSS Library

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.

SQL Server 2008 SSMS Enhancements - Part I

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

XML Workshop XXI - Generating an ATOM 1.0 Feed with FOR XML EXPLICIT

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