Creating a Comma-Separated List (2024-08-09)

SQLServerCentral Newsletter for August 9, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Creating a Comma-Separated List (SQL Spackle)]( - [Promote Simple Talks podcast episode 2: Coffee chat with Huxley Kendell]( - [Express a Number or Currency in Words with T-SQL Code]( - [From the SQL Server Central Blogs - Tech in 2030]( - [From the SQL Server Central Blogs - PASS Data Community Summit: A Personal Journey]( - [Deciphering Data Architectures]( Question of the Day - [Synapse Analytics History II]( The Voice of the DBA  Send Metrics Not Logs This is part of a series on observability, a concept taking hold in modern software engineering. One of the interesting things I saw in [an engineering presentation on Observability from Chik-Fil-A]( was that they are sometimes bandwidth constrained at remote sites. In an early version of their platform, they sent logs back to HQ, and their logs used all the available bandwidth, so they were unable to process credit card transactions. While most of us don't deal with lots of remote offices sending data back to a central data warehouse, we do often work in distributed environments, and we may send data to/from a cloud or even employees' remote offices. Bandwidth is very good in many parts of the world, but it isn't infinite. In the presentation, they talked about a tool, called [Vector]( that can work with data lots and slice/dice/aggregate/sample/etc. the data and then send the results to a sink location. This works like many other ETL tools that have a source and sink, along with various transforms that operate on the data. It's an interesting philosophy to try and send back metrics that might be useful to developers or Operations staff in understanding the performance of their system. By only sending metrics, the load on downstream systems is reduced. This also allows us to store less data and read metrics sooner rather than storing all the data and processing it each time someone needs a metric. The flip side of this is that taking this approach means that the consumers of the metrics need to ensure they are getting useful and actionable information. Determining what is needed will be like any development project, something built, iterated, re-tested, and repeated. This might even be an ongoing part of building software as new features and logging are added to your software or system. In general, I prefer to have more data over less, but the volumes of logging and instrumentation data have grown dramatically. Some systems are producing more log data than actual data on a daily basis. Like audit data, we likely need to reduce and limit the amount of data stored long-term. However, we want to keep the important data that we find useful. I am looking forward to trying out Vector and seeing what's possible. Having good CLI-based tools that can work with data is becoming more important all the time, especially as more of us move to DevOps flows, coding our systems operation in text, storing it in version control, and deploying on demand. If you've used Vector, let us know what you think, and if you prefer another tool, share why today. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [SQLServerCentral Article]( [Creating a Comma-Separated List (SQL Spackle)]( WayneS from SQLServerCentral.com Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield. [External Article]( [Promote Simple Talks podcast episode 2: Coffee chat with Huxley Kendell]( Additional Articles from SimpleTalk Host Louis Davidson meets with Solutions Engineer Huxley Kendell, to chat about his experience in working in the tech industry. Listen in to this episode for discussions including LLMs and AI, Coding and Career paths, all the way to Dungeons and Dragons. [External Article]( [Express a Number or Currency in Words with T-SQL Code]( Additional Articles from MSSQLTips.com This SQL script allows you to take a number and convert the number to words, and convert a currency value into words. [Blog Post]( From the SQL Server Central Blogs - [Tech in 2030]( BLOB EATER from All About SQL What will the technology world look like in 2030? Cloud computing will naturally be the backbone of the world but I think with variants in “decentralising” concepts. By this... [Blog Post]( From the SQL Server Central Blogs - [PASS Data Community Summit: A Personal Journey]( Chris Yates from The SQL Professor As someone attending the event since 2011, I would like to share my personal experience, the value of attending, and how the event has helped me throughout my career.... [Deciphering Data Architectures]( [Deciphering Data Architectures]( Additional Articles from SQLServerCentral Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.   Question of the Day Today's question (by Steve Jones - SSC Editor):  Synapse Analytics History II Before Synapse Analytics was a service in Azure, what was the last name of the on-premises data warehousing appliance from Microsoft? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Versions Supporting Developing User CLR Functions In which versions of SQL Server can I develop a user CLR function? Answer: In SQL Server on-premises on Windows or Linux, or in Azure SQL Managed Instance only Explanation: You can add CLR functions developer by users in the on-premises versions of Windows or Linux, though only those marked as SAFE in Linux. You can add these to Managed Instance, but not Azure SQL Database. Ref: CLR Integration - [ [Discuss this question and answer on the forums](    Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- SQL Server 2017 - Administration [ssbdiagnose syntax error ?]( - Im running the following (realnames replaced ) ;; ssbdiagnose -level info -E configuration from service "TCP://fromServer:4023/serviceName/DataSender" -S "fromServer" -d "brokerDatabaseName" TO Service "serviceName/DataWriter" -S "toServer" -d "brokerDatabaseName" on Contract "//ContractName/Contract" And it shows (amongst other "stuff" ) "An internal exception occurred: Input string was not in a correct format." Any idea which part of the […] [Adding a NEW Node to AG replacing Broken Node]( - Hello, SQL DBA here. Info: ALWAYS ON config Windows 2012 R2 Standard SQL Server 2017 ——----- Node A & B Node B went down and not recoverable . Setting up Node C. A  is a physical box(as was B), C is virtual. Configured WSFC, added feature & node C to AG Role. Removed B. Both […] SQL Server 2017 - Development [Connect to MySql databse]( - Hi, I have installed MySql connector and configured the ADO.NET Source(.NET provider/MySql data provider). It is all working fine. I need to parameterize the server details like server name, database name, userid and pwd. How can I pass variable to database name? I can't see database as the parameter in the expressions. I need to […] Development - SQL Server 2014 [View works for me ...but doesn't return results for a user in SSMS but no errors]( - Hi I have this view to check if a job is running:  SELECT job.NAME ,job.job_id ,job.originating_server ,activity.run_requested_date ,DATEDIFF(SECOND, activity.run_requested_date, GETDATE()) AS Elapsed FROM msdb.dbo.sysjobs_view job JOIN msdb.dbo.sysjobactivity activity ON job.job_id = activity.job_id JOIN msdb.dbo.syssessions sess ON sess.session_id = activity.session_id JOIN ( SELECT MAX(agent_start_date) AS max_agent_start_date FROM msdb.dbo.syssessions ) sess_max ON sess.agent_start_date = sess_max.max_agent_start_date WHERE […] SQL Server 2019 - Administration [Database Mail (Database Mail Log) getting failed when configure a db mail]( - HI ALL, Database Mail (Database Mail Log) getting failed when configure a db mail, how to fix this to send the db mail success using server name as email smtp.office365.com and port 587 Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2024-07-29T11:48:14). […] SQL Server 2019 - Development [Return string between parentheses]( - Hi. I have a column that lists group names. Varying lengths. I want to extract the text between the parentheses within the string. Example group names Domain Administrators (abc.domain.com) Group Members - I would like to return abc.domain.com Engineering Supervisors (xyz.domain.com) Members - I would like to return xyz.domain.com The grey matter is not able […] [how to find a table who have updated and when have updated in a week duration i]( - how to find a table who have updated and when have updated in a week duration in sqlserver need a user and login details who have done changes in a table and want to see data for last n days [Compare query results between two databases]( - Hi. I would like to compare results of a query to highlight differences in the data between a production database and a database restored from backup. My queries are as follows. Any help much appreciated. Kind regards, Phil. Use ProductionDatabase Select usergroup.Name, AppUser.UserName from AppUser INNER JOIN AppUser_UserGroup ON AppUser.UserId = AppUser_UserGroup.UserId INNER JOIN UserGroup […] [When exporting data from SQL Server to Excel file getting error message.]( - I am working with a SSIS package that loads .CSV files from a network drive to the database, processes the data, then it is supposed to export the data from 5 tables to 5 tabs in the same excel workbook on a network drive. I am constantly getting the following error message, DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. I am […] Azure Data Factory [Handling Output Parameter for Identity Field in Stored Procedure with ADF]( - Hi everyone, I'm currently working on a data migration task using Azure Data Factory (ADF) and encountering an issue with handling an output parameter that is also an identity field in a SQL Server stored procedure. Objective: Migrate data from a JSON file stored in Azure Blob Storage to a SQL Server table using a […] Reporting Services 2008 Development [Why doesn't the error show up in the SQL Log?]( - We've got a third party app that runs on SQL Server 2008 R2. There's a SQL Job which runs two SSIS packages. (I am not a DBA, and I don't know how to develop SSIS.) Anyway, this SQL Job has been failing for a few days, but there's no error in the job's history. From […] SSDT [SSIS File system Task]( - Hi all  We've got an SSIS package that downloads a zipped database, unzips the contents, and then copies the contents to new locations. When doing the copy (using a file system task), we occasionally get an error that simply says "An unexpected network error occurred".  I've checked there's enough room on the receiving […] Integration Services [Migrating SSIS 2016 to SSIS 2022 (Oracle Attunity to Oracle Connector v1.2) LDAP]( - We're upgrading from SQL Server 2016 to SQL Server 2022. Our current SSIS packages utilize Oracle Attunity drivers to extract data from an external Oracle database using the LDAP protocol. We have to use Microsoft Oracle Connector v1.2 connection manager with SSIS 2022, which works well with tnsnames.ora when using the TNS_Admin environment variable. However, […] SQL Server 2022 - Administration [sqlserver services not stopping even after disconnecting from SSMS]( - SQL server is installed in Win Server and accessed via SSMS from local. I noticed that even after I closed SSMS, the sqlserver's services didn't stop. I recently ran IndexOptimize against 1 DB and saw the memory being used upto 95%. But the process is done and SSMS is too closed from local. Its been […] SQL Server 2022 - Development [Dark mode, other color schemes]( - All, if you are like me and do not care for the built-in color schemes, try www.sqlshades.com. I just downloaded the EXE and instead of me taking an hour or two to find the right colors and without able to change the docked windows colors, I installed it, restarted SSMS and already love the dark […]   [RSS Feed]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -