XML Support and SQL Server (Part 5)

This article is the fifth part of my XML support and SQL Server article series. In this part, I’ll discuss the basic XML queries and data manipulation. I’ll also give the brief introduction to the XQuery language and the use of query(), value(), exist(), nodes(), and modify() methods.

Read this article...

Basit A. Farooq

Basit Farooq is an internationally known Lead SQL DBA, trainer, and technical author with twelve years' experience of the Microsoft technology stack. He is an accomplished development and production SQL Server DBA with a proven record of delivering major projects on time and within budget. He is an expert at evaluating the clients' needs against the capabilities of the SQL Server product set, with the objective of minimizing costs and maximizing functions by making innovative use of advance capabilities.

He has also developed and implemented many successful database infrastructures, data warehouses, and business intelligence projects. He holds a Master's degree in Computer Science from London Metropolitan University and industry-standard certifications from Microsoft, Sun, Cisco, Brainbench, ProSoft, and APM, which include MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications. He also has a good understanding of ITIL principles.

He was the author of SQL Server 2014 Development Essentials book published by Packt Publishing. He was a technical reviewer for SQL Server 2012 Reporting Services Blueprints, Marlon Ribunal and Mickey Stuewe and Reporting with Microsoft SQL Server 2012, James Serra and Bill Anton, both by Packt Publishing. Basit has also authored approximately 250+ SQL Server technical articles on various SQL Server topics for different SQL Server community sites, including:,,,,, and He also blogs regularly at about SQL Server topics.

He can be reached via Twitter (@BasitAali), his blog (, or via LinkedIn (

comments powered by Disqus