At a recent conference I was asked how I executed code during my presentation. Running code during a presentation should be as smooth as possible…so in VS Code I...
2024-10-16 (first published: 2024-09-27)
105 reads
Please, let me reiterate: The only valid test of a backup is a restore. THE ONLY VALID TEST OF A BACKUP IS A RESTORE. I’m happy that you have...
2024-10-16 (first published: 2024-09-30)
18 reads
It's like disaster recovery (and business continuity) planning is the end-of-term research paper that the professor mentioned on the first day of class, but which most students don't start...
2024-10-15 (first published: 2024-10-10)
30 reads
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse with a metadata-driven, pattern-based approach. One of the benefits I mentioned is that it’s easy...
2024-10-15 (first published: 2024-10-14)
7 reads
SQL Server Audit is an efficient way to track and log events that occur within the database engine. For on-premises or IaaS environments, those audits can only be stored...
2024-10-15
10 reads
A customer was asking recently about the RPO for their estate, and I showed them a few things from the Estate tab in Redgate Monitor. This post covers a...
2024-10-15 (first published: 2024-10-14)
6 reads
This topic keeps coming up with my customers so the purpose of this blog post is to keep all the useful information in one post. Think of this post...
2024-10-15 (first published: 2024-10-09)
20 reads
I wanted to test a migration of Azure PostgreSQL from simple to flexible. I wanted a simple db to restore onto my single server. I may not have needed...
2024-10-14 (first published: 2024-09-25)
97 reads
“Could you help me, we deleted the database’s transaction log file and now that database is stuck in ‘Recovery Pending’?” This was a panicked call that I received a...
2024-10-14 (first published: 2024-09-26)
329 reads
I’m hosting a webinar tomorrow with Rie Merritt from Microsoft. We’ll be talking about some of the sessions that Microsoft has planned for the PASS Data Community Summit as...
2024-10-14
2 reads
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Comments posted to this topic are about the item The Modern Algorithm of Chance
Comments posted to this topic are about the item Use Logic Apps To Save...
Comments posted to this topic are about the item AWS Services Using SQL for...
I have this data in my Customer table:
CustomerID CustomerName 1 Steve 2 Andy 3 Brian 4 Allen 5 DevinI run this code:
SELECT
t.CustomerID
, c.value
FROM
( SELECT
CustomerID
, STRING_AGG (CustomerName, ',') AS me
FROM customer
GROUP BY CustomerID) t
CROSS APPLY STRING_SPLIT(me, ',') c;
What is returned? See possible answers