Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: Jacob Sebastian

SQLServerCentral.com profile

<< Newer    Items 41 to 60 of 95    Older >>
 

TSQL Challenge 43 – Identifying incomplete segments and missing elemen

This challenge involves writing a logic to identify incomplete segments and missing elements in an electronic data integration file exchanged between two applications.  Read more...
By Jacob Sebastian 2010/11/16 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 833 reads

TSQL Challenge 42 – Transform rows to columns with dynamic positioning

This challenge involves writing a logic to change the column position of values in the output based on the presence and absence of other values on each output row.  Read more...
By Jacob Sebastian 2010/11/01 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 2,740 reads

TSQL Challenge 41 - Extract email addresses from text data

This challenge involves extracting email addresses from a table that contains text data downloaded from various websites.  Read more...
By Jacob Sebastian 2010/10/18 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: (not yet rated) |  Discuss |   Briefcase | 2,153 reads

TSQL Challenge 40 - Convert string representation of numeric values fr

This challenge involves converting numeric values from binary format to hexadecimal format.  Read more...
By Jacob Sebastian 2010/10/04 | Source: SQLServerCentral.com | Category: t-sql challenges
Rating: |  Discuss |   Briefcase | 1,601 reads

XML Workshop 26 – SELECT * FROM XML

This article presents a generic function that makes it easy to query XML documents  Read more...
By Jacob Sebastian 2010/06/30 | Source: SQLServerCentral.com | Category: xquery
Rating: |  Discuss |   Briefcase | 11,929 reads

XML Workshop 25 - Inserting elements and attributes to an XML document

This article from MVP Jacob Sebastian looks at the modify method for changing an XML document.  Read more...
By Jacob Sebastian 2010/03/18 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 7,155 reads

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.  Read more...
By Jacob Sebastian 2009/10/22 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 9,095 reads

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.  Read more...
By Jacob Sebastian 2009/09/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,660 reads

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.  Read more...
By Jacob Sebastian 2009/07/22 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 6,545 reads

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.  Read more...
By Jacob Sebastian 2009/02/25 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 3,841 reads

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.  Read more...
By Jacob Sebastian 2009/02/10 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 4,901 reads

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.  Read more...
By Jacob Sebastian 2008/10/15 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 5,474 reads

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.  Read more...
By Jacob Sebastian 2008/10/01 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 2,854 reads

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.  Read more...
Rating: |  Discuss |   Briefcase | 6,874 reads

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.  Read more...
By Jacob Sebastian 2008/07/16 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 2,576 reads

XML Workshop XX - Generating an RSS 2.0 Feed with TSQL(SQL server 2000)

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...
By Jacob Sebastian 2008/06/04 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 3,961 reads

XML Workshop XIX - Generating an ATOM 1.0 Feed

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...
By Jacob Sebastian 2008/05/15 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 3,055 reads

XML Workshop XVIII - Generating an RSS 2.0 Feed with TSQL

Continuing on with part 18 of his series, MVP Jacob Sebastian examines building an RSS feed in T-SQL.  Read more...
By Jacob Sebastian 2008/04/09 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 5,942 reads

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.  Read more...
By Jacob Sebastian 2008/03/26 | Category: xml
Rating: |  Discuss |   Briefcase | 10,923 reads

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.  Read more...
By Jacob Sebastian 2008/03/19 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 4,626 reads
<< Newer    Items 41 to 60 of 95    Older >>