Create an HTML unordered list in SQL

I am trying to create an unordered list of html links in SQL, and output the results as the desired unordered list. select tblRoster.ID,tblRoster.pRank,tblRoster.pName,tblRoster.pSquad, (select ‘<ul>’ + stuff((select ‘<li>’+ ‘<‘+ ‘img src=’ + pm.dLink from tblPlayerMedals pm where tblRoster.ID = pm.pID order by dID asc for xml path(”)),1,0,”) + ‘ /></li>’ + ‘</ul>’) AS dLink,…

Details

Filter list of files using an array of regular expressions (regex)

How can I change this so that I can cycle through a list of files and compare them all to an array of regular expressions? $Regex_FileList = @” TestFile_53-1227.txt^Home/Client/ Testfile_R-122719.txt^Home/Client/ TestingAFile1219.csv^Home/Client/ Test_PMT_122719.txt^Home/Client/ This_is_a_TEST_122719.txt^Home/folder/ “@ $Regex_1 = “^TestFile_R-\d{1,6}” $Regex_2 = “This_is_a_TEST_\d{1,6}\.txt” $Regex_3 = “^Test_NB” $Regex_Array = @($Regex_1,$Regex_2,$Regex_3) [array]$files = $Regex_FileList -split ‘\r?\n’ $files = $files |…

Details

GraphQL + Spring Boot: how to collect (error) metrics?

I’ve been working on adding monitoring metrics in our GraphQL gateway recently. We’re using graphql-spring-boot starter for the gateway. After reading the following documentations, I manage to send the basic graphql.timer.query.* metrics to Datadog https://www.baeldung.com/spring-boot-actuators https://docs.spring.io/spring-boot/docs/2.0.x/actuator-api/html/#metrics https://github.com/graphql-java-kickstart/graphql-spring-boot#tracing-and-metrics What I’ve achieved so far is, when I send a GraphQL query/mutation, I’d collect the request count and…

Details