The Identity Debate
Using the Identity Property might be one of the more debated features of SQL Server. This editorial was originally published on Mar 5, 2008. It is being re-run as Steve is on vacation.
2008-02-11
277 reads
Editorials
2008-02-08
38 reads
Feedback
Corporate management often asks for feedback and buy-in with their ideas and programs. Why don't they get it?
2008-02-06
51 reads
Compensation
Employee compensation is more than just salary. Steve Jones talks about how you might look at building more effective compensation plans for workers.
2008-02-05
81 reads
2008-02-04
40 reads
More Layers
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
2008-02-04
51 reads
2008-02-01
329 reads
The January Car Update
The bimonthly update looks at a compressed air car, the X-Prize, daily rentals, and hybrid pickups.
2008-01-31
135 reads
Fixing SQL Server
If we will get a new version of SQL Server every 3 years, how can we make the process smoother.
2008-01-30
209 reads
The Mistake
SQL Server 2008 has been delayed and Steve Jones thinks the entire process of building this version has been poorly handled.
2008-01-29
417 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