2011-11-15 (first published: 2010-03-03)
9,822 reads
Raw Materials
2011-11-08 (first published: 2010-02-10)
11,423 reads
2011-11-03 (first published: 2010-02-03)
12,678 reads
2011-11-01 (first published: 2010-01-27)
10,644 reads
2011-10-27 (first published: 2010-01-20)
11,459 reads
2011-10-25 (first published: 2010-01-06)
11,558 reads
Raw Materials - Og, Sumerian DBA
A tale from the days when civilization was young and everything was harder than it is now.
2011-10-20 (first published: 2009-12-30)
10,714 reads
2011-10-18 (first published: 2009-12-23)
9,295 reads
2011-10-13 (first published: 2009-12-16)
8,806 reads
2011-10-11 (first published: 2009-12-09)
9,708 reads
Blogs
Convert SQL Audit Files to a CSV Using Read-SqlXEvent
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
Control Flow Restartability in Azure Data Factory
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
Monday Monitor Tips: Knowing Your RPO
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Forums
Error while connecting Local DB 2012 in Windows 7 PC using SSMS
I am trying to access LocalDB 2012 on my Windows 7 SP1 PC. I...
The Modern Algorithm of Chance
Comments posted to this topic are about the item The Modern Algorithm of Chance
Use Logic Apps To Save Money In Azure: Data Engineering in Fabric
Comments posted to this topic are about the item Use Logic Apps To Save...
Question of the Day
Crazy Code I
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