SSIS Variable and Parameter Analysis

Use T-SQL to analyse the usage of all variables and parameters in an SSIS project, including the identification of any unused variables and parameters.

SQLFeatures

Basit's SQL Server Tips

SQL Player Blog

Using T-SQL to Fix Bad Data in XML Documents Using FLWOR

Learn how to use T-SQL to fix contents of an XML document using FLWOR

Representing XML data in SQL Server

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.

Examples of using XQuery to update XML Data in SQL Server

What is the most efficient way to modify XML values? To allow for precise modification of XML nodes and values, the XQuery XML query language employs an extension known as the XML Data Modification Language (DML). The XML DML uses the XML modify() method, which makes use of three operational keyword sets: insert, replace value of, and delete. Seth Delconte takes a closer look.

Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML

How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL Server table that represents a simple hierarchy within an organisation. Well once you know, it is easy and William Brewer is on a mission to tell you how.

Free ebook: Stairway to SQL Server XML

Free download to all Simple Talk users. XML has been part of the SQL Standard since 2003, and is essential for any DBA because so many of the dynamic management views return XML data. Now that the industry is more used to data defined by document markup, it is becoming more important than ever for Database Developers and DBAs to understand the technology and to know where it makes sense to use XML.

XML import from a Cross-tab Report

Source xml is a rendition of a cross-tab report. I show the evolution of a Spackle solution for import as a SQL resultset.