Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Regular Columnist: Jacob Sebastian
SQLServerCentral.com profile
Items 1 to 20 of 38
Next 20 >>
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
|
3,320 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
|
4,683 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
|
2,387 reads
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.
Read more...
By
Jacob Sebastian
2008/03/12
|
Source:
SQLServerCentral.com
|
Category:
XML
Rating:
|
Discuss
|
Briefcase
|
2,822 reads
TSQL LAB 2 - Writing Conditional WHERE Clauses
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...
By
Jacob Sebastian
2008/02/27
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
15,325 reads
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.
Read more...
By
Jacob Sebastian
2008/02/06
|
Category:
Datetime Manipulation
Rating:
|
Discuss
|
Briefcase
|
5,686 reads
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.
Read more...
By
Jacob Sebastian
2008/02/13
|
Source:
SQLServerCentral.com
Rating:
|
Discuss
|
Briefcase
|
3,347 reads
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.
Read more...
By
Jacob Sebastian
2008/01/23
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005 Compact Edition
Rating:
|
Discuss
|
Briefcase
|
1,953 reads
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.
Read more...
By
Jacob Sebastian
2007/12/27
|
Source:
SQLServerCentral.com
|
Category:
SQL Server Compact Edition
Rating:
|
Discuss
|
Briefcase
|
866 reads
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.
Read more...
By
Jacob Sebastian
2007/12/12
|
Source:
SQLServerCentral.com
|
Category:
Integration Services
Rating:
|
Discuss
|
Briefcase
|
6,124 reads
XML Workshop XII - Parsing a delimited string
Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.
Read more...
By
Jacob Sebastian
2007/12/05
|
Source:
SQLServerCentral.com
|
Category:
XML
Rating:
|
Discuss
|
Briefcase
|
3,480 reads
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.
Read more...
By
Jacob Sebastian
2007/12/19
|
Source:
SQLServerCentral.com
|
Category:
XML
Rating:
|
Discuss
|
Briefcase
|
1,760 reads
TSQL Lab I - Playing around with ROW_NUMBER
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...
By
Jacob Sebastian
2007/11/14
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
4,562 reads
XML Workshop XI - Default Namespaces
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...
By
Jacob Sebastian
2007/11/21
|
Source:
SQLServerCentral.com
|
Category:
XML
Rating:
|
Discuss
|
Briefcase
|
1,912 reads
XML Workshop X - Working with namespaces
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...
By
Jacob Sebastian
2007/11/07
|
Source:
SQLServerCentral.com
|
Category:
XML
Rating:
|
Discuss
|
Briefcase
|
2,598 reads
XML Workshop IX - Mixed Types
Continuing on with his great series on XML, Jacob Sebastian looks at elements of mixed types.
Read more...
By
Jacob Sebastian
2007/10/31
|
Source:
SQLServerCentral.com
|
Category:
XML
Rating:
|
Discuss
|
Briefcase
|
2,090 reads
XML Workshop VIII - Custom Types and Inheritance
This is the 8th installment of my XML Workshop which aims at explaining the details of working with XML in TSQL.
Read more...
By
Jacob Sebastian
2007/10/17
|
Source:
SQLServerCentral.com
|
Category:
XML
Rating:
|
Discuss
|
Briefcase
|
2,365 reads
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.
Read more...
By
Jacob Sebastian
2007/09/12
|
Source:
SQLServerCentral.com
|
Category:
News
Rating:
|
Discuss
|
Briefcase
|
12,627 reads
Server Side Paging With SQL Server 2005
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...
By
Jacob Sebastian
2007/08/29
|
Source:
SQLServerCentral.com
|
Category:
Advanced Querying
Rating:
|
Discuss
|
Briefcase
|
8,821 reads
SQL Server 2008 - The Power of Merge
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...
By
Jacob Sebastian
2007/09/11
|
Source:
SQLServerCentral.com
|
Category:
Advanced Querying
Rating:
|
Discuss
|
Briefcase
|
9,152 reads
Items 1 to 20 of 38
Next 20 >>
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use