XML in SQL Server

New & Notable

Download this free guide

Free Resource: Hive vs. Spark vs. Presto

While SQL is the common langue of many data queries, not all engines that use SQL are the same—and their effectiveness changes based on your particular use case. So what engine is best for your business to build around? Compare Hive, Spark, and Presto to see which is best for you.

Corporate E-mail Address:
You forgot to provide an Email Address.
This email address doesn’t appear to be valid.
This email address is already registered. Please login.
You have exceeded the maximum character limit.
Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

XML in SQL Server Get Started

Bring yourself up to speed with our introductory content

Microsoft Visual FoxPro (Microsoft VFP)

Microsoft Visual FoxPro (VFP) is an object-oriented programming environment with a built-in relational database engine. Continue Reading
XQuery

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 or Commerce Extensible Markup Language)

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.

Manage traces in SQL Server 2005 Analysis Services with XMLA commands

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.

An introduction to XML shredding for SQL Server

It's critical to understand the effects XML shredding can have on your database environment before selecting a particular shredding approach. Continue Reading
Processing XML files with SQL Server functions

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
Create a computed column in SQL Server using XML data

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

SearchBusinessAnalytics

Tibco expands analytics offerings with IBI acquisition

In a move designed to add complementary capabilities to its platform, Tibco said it will acquire business intelligence vendor IBI...

Chief data and analytics officer roles: What you need to know

Whether you have a chief analytics officer or chief data officer, there is a need for a unified leadership structure for data and...

Logi Analytics keeps focus on embedded app development

Kevin Greene is the new CEO of Logi Analytics after previously serving as the vendor's COO. In an interview, Greene discusses his...

SearchDataCenter

IBM cloud revenues climb as hardware continues to decline

IBM cloud revenues continue to increase as hardware sales drop, sharpening the company's strategy to focus on hybrid cloud.

Figure out the differences of asset management vs. CMDB

There is no shortage of software options for change management tools. Operational goals can help IT teams decide if ITAM or CMDB ...

IBM partners with HBCUs to promote quantum computing

IBM is partnering with a group of historically Black colleges and universities to set up a quantum computing center in hopes of ...

SearchDataManagement

MongoDB Atlas now enables multi-cloud database clusters

Multi-cloud data portability comes to MongoDB Atlas with a new capability that will enable users to run a database application ...

How AI data privacy can help your enterprise

Enterprises benefit in many ways from AI data privacy tools that reduce the need for manual efforts from data professionals. Read...

The new normal for enterprise data governance

Mastercard data exec highlights the foundational role of enterprise data governance during the pandemic era with more people ...

SearchAWS

New Amazon grocery stores run on computer vision, apps

Amazon dives deeper into the grocery business with its first 'new concept' grocery store, driven by automation, computer vision ...

Amazon's sustainability initiatives: Half empty or half full?

Amazon's public perception and investment profile are at stake as altruism and self-interest mix in its efforts to become a more ...

How Amazon launched the warehouse robotics industry

In 2012, the warehouse robotics industry consisted of Kiva Systems, the sole supplier to serve all e-commerce companies. When ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchContentManagement

Choosing the right collaboration suite for business

Collaboration suites are an essential component of remote work, enabling teamwork throughout a distributed enterprise. Decide ...

Acquia Drupal, Marketing Cloud get feature boosts

Acquia users get Drupal migration tools and marketing automation features built with technology from recent acquisitions as the ...

How automated content tagging improves findability

Companies that use AI to automatically tag their metadata can improve findability of content across the entire organization. AI ...

SearchWindowsServer

5 WSUS alternatives for patch management

Compare the features and functionality of five prominent patch management tools for Microsoft and third-party applications to ...

Critical TCP/IP bug gets fixed for October Patch Tuesday

The number of security updates from Microsoft dips below the average of the previous several months, but a TCP/IP bug looms large...

Microsoft Ignite 2020 conference coverage

This Microsoft Ignite guide compiles news from the online event, including upcoming products and how they might address some of ...

New & Notable

XML in SQL Server Get Started

Manage XML in SQL Server

Problem Solve XML in SQL Server Issues

Related Definitions