A Bad Report Card
The Federal Communications Commission doesn't get a good report on it's data handling and management processes.
2008-03-24
58 reads
Editorials
Feature (In)Complete
A look at some of the interesting database news from the previous week (March 24, 2008).
2008-03-24
196 reads
Sharing
As humans we look to share with each other, but there are times that this can be a bad thing. Steve Jones has a poll asking you about your sharing habits.
2008-03-21
75 reads
Fire Drills
How often do you have those fire drills, testing what you would do in the event of an emergency. Would you be satisfied with a 30% success rate?
2008-03-19
88 reads
Get Rid of the Indexes
An idea that could save time and resources for backup and recovery in SQL Server.
2008-03-18
381 reads
SQL Server Data Services
SQL Server isn’t used much for web-based applications, simply because the cheapest ISPs use Linux and Apache for their platform. There are ISPs that provide a .NET platform and SQL Server but it is at a cost. SSDS seems to be Microsoft’s latest attempt to break into the market for database-driven websites.
2008-03-17
137 reads
2008-03-17
239 reads
2008-03-16
39 reads
2008-03-14
117 reads
Scaling Out
Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?
2008-03-13
266 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