Quick Hits on the News for Nov 12, 2007
A few comment on the database news for the week ending 11/10/07
2007-11-12
19 reads
Editorials
The Pace of Information
Is the rapid pace of information being fed to us a problem? Steve Jones has a few thoughts.
2007-11-12
32 reads
2007-11-08
39 reads
Which Platform Do You Work On?
The growth of SQL Server's subsystems leaves Steve Jones wondering how should we be thinking about the product.
2007-11-07
118 reads
Whack a Database
The SQL Server team is looking for feedback on deleting databases and Steve Jones gives a few ideas.
2007-11-06
91 reads
2007-11-05
737 reads
Unstructured Data
I remember when Windows 3.1 started to gain widespread deployment in businesses. With all it's WYSIWYG features and multiple applications running at the same time, many people felt we'd get to a paperless office. Over a decade later I rarely see an office that doesn't have a copy machine and at least one printer. We've gotten better at shuffling bits, but we haven't gotten rid of paper.
2007-11-01
126 reads
2007-10-31
2,791 reads
October Energy Update
A recap of the world of energy from the previous two months. Steve looks at solar, wind, nuclear, and more.
2007-10-30
50 reads
Mining or Profiling
The more data you have, the better you should be able to predict something. Or at least that's one of the things that I learned while studying economics. If we could actually gather enough data about someone or some system, we could determine what the most likely outputs of the system will be. In the […]
2007-10-29
78 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