New & Notable
XML in SQL Server Get Started
Bring yourself up to speed with our introductory content
Microsoft Visual FoxPro (VFP) is an object-oriented programming environment with a built-in relational database engine. Continue Reading
XQuery is a specification for a query language that allows a user or programmer to extract information from an Extensible Markup Language (XML) file or any collection of data that can be XML-like. Continue Reading
Commerce XML (cXML) is a standard for the online exchange of business transaction information in common formats. Continue Reading
Manage XML in SQL Server
Learn to apply best practices and optimize your operations.
SQL Profiler is an efficient tool for tuning and troubleshooting Microsoft Analysis Services 2005, that is, unless you're managing numerous instances. In this tip, you'll learn how to use XMLA to automate tracing to monitor MSAS. Here's what you ... Continue Reading
Problem Solve XML in SQL Server Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
It's critical to understand the effects XML shredding can have on your database environment before selecting a particular shredding approach. Continue Reading
The procedure of loading XML files onto a SQL Server database and processing them into tables is not well documented. Discover a prescribed method that uses both SQL Server functions and XPath expressions. Continue Reading
In this tip, SQL Server expert Robert Sheldon demonstrates how to create a function that runs the XQuery expression and then use that function within your computed column definition. Continue Reading