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

Content with tags XML, Miscellaneous Rss

   Items 1 to 20 of 35    Older >>
 

The SQL Server 2005 XML Temptress

SQL Server 2005 has greatly expanded the XML capabilities of this platform, but should you use it in your database? New author and MVP Simon Munro brings us a look at how he has used XML and where it might fit in your database.   Read more...
By Simon Munro 2007/03/26 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,245 reads

Importing XML Files Into SQL Server

Have you ever received an XML file from someone to import into SQL Server? It's not as easy as you might expect, especially in SQL Server 2000. New author Steve Moore brings us an article and code on how to do just that.   Read more...
By Steve Moore 2007/11/23 (first published: 2006/02/15) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 37,454 reads

An Auditing Solution with XML And XSL

Auditing is something that almost every DBA needs to tackle at some point in his or her career. David McKinney brings a new twist on the solution by using XML and XSL to help implement auditing in your SQL Server application.   Read more...
By David McKinney 2007/08/20 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,988 reads

XML not boring! New workbench

Robyn Page and Phil Factor almost dispel the myth that XML is boring, with their radical new SQL Server XML workbench.  Read more...
By Additional Articles 2007/07/06 | Source: SimpleTalk | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,169 reads

XML Workshop II - Reading values from XML variables

Continuing with his series on XML in SQL Server 2005, Jacob Sebastian brings us a number of examples on how to work with XML in different situations with SQL Server 2005.   Read more...
By Jacob Sebastian 2007/06/06 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 20,547 reads

Upload multiple XML files to an XML data type column

Learn how to upload multiple XML files to an SQL Server 2005 database XML data type column.  Read more...
By Additional Articles 2007/05/29 | Source: Database Journal | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,861 reads

XML Restructuring and Reshaping Should Not be Considered the Same

Michael M. David returns to SQLSummit.com to explore two approaches to XML hierarchical structure transformations. He explains the difference between restructuring and reshaping XML data, with the latter driven by the semantics of the data structure.   Read more...
By Additional Articles 2007/05/14 | Source: SQL Summit | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,685 reads

SQL Server XML Cribsheet

If you're like me and find XML a bit of an acronym minefield, Robyn Page's Cribsheet will help sort out your XSLT from your XDM.  Read more...
By Additional Articles 2007/04/16 | Source: SimpleTalk | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,411 reads

Sales Order Workshop Part III

In the previous articles, Jacob Sebastian looked at using XML to save a sales order with variable numbers of line items to a SQL Server 2000 database. In this part, he expands upon the processing to access that data from multiple nodes.   Read more...
By Jacob Sebastian 2007/04/03 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,668 reads

Sales Order Workshop Part II

In part 2 of this series, Jacob Sebastion continues looking at XML in SQL Server 2000 with some advanced XML processing.  Read more...
By Jacob Sebastian 2007/03/29 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,246 reads

Saving a Sales Order Part 1

How many times have you tried to save a sales order to your database? For many DBAs this is a common scenario and one of the challenges is the many round trips for the various line items. Jacob Sebastian brings us the first part of a four part series looking at how you can use XML to reduce the round trips in SQL Server 2000.   Read more...
By Jacob Sebastian 2007/03/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,999 reads

The SQL Server 2005 XML Temptress

SQL Server 2005 has greatly expanded the XML capabilities of this platform, but should you use it in your database? New author and MVP Simon Munro brings us a look at how he has used XML and where it might fit in your database.   Read more...
By Simon Munro 2007/03/26 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,245 reads

How do I... Transfer and store data from an XML document in a relation

XML really makes it easy to move data from here to there and from there to here. However, eventually the data needs to be stored somewhere, most likely in a relational database. Here is how Edmond Woychowsky gets data from an XML document into a relational database.   Read more...
By Additional Articles 2006/11/22 | Source: Builder.com | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,546 reads

XML Argument Protocols for SQL 2005 Stored Procedures

SQL Server 2005 has made it much easier to work with XML data in your database applications than ever before. In this article, new author Jack Hummer examines how you can use XML to move data through stored procedures.   Read more...
By Jack Hummer 2006/10/02 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,353 reads

How Do I create an XML document from undefined legacy data?

This article explains how to transform a nebulous application requirement like "take a flat file that was produced by an upstream mainframe application and produce an XML document for a downstream application," into a flexible working solution.  Read more...
By Additional Articles 2006/08/18 | Source: Builder.com | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,927 reads

What is XML?

The use of XML is growing all the time and if you listen to the media, XML is a technology you cannot do without. New author Stephen Hirsch brings us a look at XML from more of a skeptic's point of view.   Read more...
By Stephen Hirsch 2006/07/24 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,922 reads

XML - Good and Bad

XML is becoming more and more the mainstream for data transfers between systems. Web services and SOAP communications are built into SQL Server 2005, requiring the more and more DBAs understand how to work with XML. Raj Vasant has written a number of articles on XML and brings us a look at how XML should and should not be used.   Read more...
By Vasant Raj 2006/06/05 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,742 reads

Importing XML Files Into SQL Server

Have you ever received an XML file from someone to import into SQL Server? It's not as easy as you might expect, especially in SQL Server 2000. New author Steve Moore brings us an article and code on how to do just that.   Read more...
By Steve Moore 2007/11/23 (first published: 2006/02/15) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 37,454 reads

Secrets of successful IT projects

Some time ago, I worked on a team that was attempting to define an IT strategy for a large multinational company. Management incorrectly thought the company was unique in that it had a high number of failed IT projects. In fact, only one in four IT projects can be termed successful, if the benchmarks of success are adherence to scheduled completion time and budget, and realization of the project goal, whether that be saving money, growing the business, or what have you. I have to explain this because many of you may never have come across one.   Read more...
By Additional Articles 2005/12/05 | Source: Red-Gate | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,418 reads

Simplify the Creation of XML from SQL Server Data

SQL Server 2000 had extensions built in to allow you to work with XML data, however, most installations did not work with it. XML has proven that it is a very powerful way of transmitting and working with data, but creating it from relational data has proven to be difficult. New author Hugh Lynch, CTO of Restricted Stock Systems, Inc. brin gs us a method for easily creating XML from your SQL Servers.   Read more...
By Hugh Lynch 2005/10/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,420 reads
   Items 1 to 20 of 35    Older >>
 
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)