Tips to work with SQL Server 2019 clustering Consider using SQL Server 2019 Big Data Clusters. SQL Server Big Data Clusters allow you to deploy scalable clusters of SQL Server, Spark, and HDFS containers running on Kubernetes. With Big Data Clusters you can read, write, and process big data from Transact-SQL or Spark. Set the performance boost for the foreground...
Tag: nodes()
XML Support and SQL Server (Part 5)
XML Support and SQL Server (Part 5) By Basit A. Farooq Editor’s Note: 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()...
XML Support and SQL Server (Part 4)
XML Support and SQL Server (Part 4) By Basit A. Farooq Editor’s Note: This article is the fourth part of my XML support and SQL Server article series. In this part, I’ll talk about XML data type. I’ll also demonstrate how you can create XML variables and XML columns, and compare between typed and untyped XML. With the release of...