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

Content with tags Miscellaneous, XML Rss

<< Newer    Items 21 to 35 of 35   
 

XML Options in Microsoft SQL Server 2005

Three options for handling XML data in the Visual Studio 2005/SQL Server 2005 environment are discussed, including usage scenarios and guidelines to help you choose between them. (34 printed pages)  Read more...
By Additional Articles 2005/02/08 | Source: MSDN Communities | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,208 reads

Reduce Database RoundTrips Using XML

SQL Server 2000 added XML support to allow some basiuc manipulation of XML data. At the time, XML was a hot buzzword in the computer industry and there were lots of applications being written to use XML. While the buzz has cooled, Jon Winer still uses XML in some interesting ways to make his life easier and his applications more rebust. Here he brings us a technique he's used to reduce the number of round trips required by an application.   Read more...
By Jon Winer 2004/11/29 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,398 reads

An Alternative XML Solution

SQL Server 2000 added support for XML documents in a few ways. However the support was a little kludgy as it had not been designed into the product from the beginning, but added on later. New author Wayne Fillis brings us some C++ code and a new way to easily retrieve well formed XML documents from your SQL Server.   Read more...
By Wayne Fillis 2004/11/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,226 reads

Methods for Parsing XML files

Jon shows you several ways you can parse XML.   Read more...
By Jon Winer 2004/10/01 (first published: 2002/06/20) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,272 reads

An Introduction to InfoPath 2003

Office 2003 has a new tool: InfoPath 2003, which can work with SQL Server along with numerous other data stores. It's a great way to begin working with XML, Web Services, and many of the newer technologies that are available today. Join Dinesh Askanka on his journey to learn more about InfoPath2003 in the start of another series.   Read more...
By Dinesh Asanka 2004/06/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,553 reads

Reducing Round Trips Part 4

The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!   Read more...
By Andy Warren 2004/04/23 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,948 reads

For SQL Server, XML Is One Answer

New author! Nick discusses why 'XML is One Answer', outlining some of what he believes are key points about using XML with SQL Server. This is a follow up (and sort of counter point) to another great article we had here on the site a couple weeks ago by Don Peterson. Good stuff!   Read more...
By Nick Malik 2003/10/22 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 5,702 reads

Replacing BCP with SQLBulkLoad

New Author! Stephan writes about why he thinks the bulk load capabilities added in the SQLXML3 addition are a great way to handle imports - maybe so good that you'll stop using BCP.   Read more...
By Stefan Popovski 2003/07/21 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,990 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,205 reads

Methods for Parsing XML files

Jon shows you several ways you can parse XML.   Read more...
By Jon Winer 2004/10/01 (first published: 2002/06/20) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,272 reads

Reducing Round Trips - Part 2

Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!   Read more...
By Andy Warren 2002/02/06 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,234 reads

BizTalk and XML: Add E-Commerce to Your App with XML and SQL Server

XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information.   Read more...
By Additional Articles 2002/01/28 | Source: Microsoft MSDN | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,271 reads

Simple OLE DB Provider for XML

The OLE DB Simple provider for XML (XML OSP) can be used to load the hierarchical data that is in an XML document into a read-only ADO recordset. The data can then be read and accessed by using the standard methods of the ADO Recordset object. The XML OSP can be used to provide a different method for working with data that is contained in XML documents.   Read more...
By Additional Articles 2001/12/10 | Source: ASPToday | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,177 reads

SQLXML 2.0 (XML for SQL Server 2000)

Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.   Read more...
By Additional Articles 2001/10/29 | Source: Microsoft MSDN | Category: news
Rating:  Rate this |   Briefcase | 5,922 reads

Creating SQL Objects on the fly with VB and XML

A method for creating databases and other objects on the fly and distribute these objects to multiple servers.   Read more...
By Additional Articles 2001/06/08 | Source: ASPToday | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,656 reads
<< Newer    Items 21 to 35 of 35   
 
Tags
t-sql (9)    
basics (6)    
programming (4)    
stored procedures (4)    
openxml (3)    
performance tuning (3)    
sql server 2005 (3)    
sql server 7 (3)    
updategrams (3)    
xsl (3)    
security (2)    
strategies (2)    
visual basic 6 (2)    
administration (1)    
ado (1)    
backup / restore (1)    
configuring (1)    
database design (1)    
development (1)    
distributed queries (1)    
dts (1)    
english query (1)    
indexing (1)    
installation (1)    
monitoring (1)    
news (1)    
replication (1)    
schemas/dtds (1)    
system development life cycle (1)    
triggers (1)    
user defined function (udf) (1)