When Companies Fail
The challenge of software pervading all aspects of our lives and inside many products is going to be create an interesting world when companies fail.
2024-10-23
51 reads
The challenge of software pervading all aspects of our lives and inside many products is going to be create an interesting world when companies fail.
2024-10-23
51 reads
There is no shortage of mundane tasks at work. Steve Jones notes that you might not want to depend on those to fill your day in the future.
2024-10-22 (first published: 2015-05-18)
283 reads
There are all sorts of coding practices that produce better code. Steve Jones talks about one today.
2024-10-22 (first published: 2015-05-06)
343 reads
Steve Jones thinks that we often over-engineer software, trying too hard to consider every possibility rather than getting it close.
2024-10-22 (first published: 2009-07-15)
195 reads
Ignoring technical debt can cause no shortage of problems for companies. Today Steve has a recent example of this.
2024-10-21
106 reads
Let's talk about the elephant in the room right up front. Yes, I'm old. I remember when Buck Woody was a little tyke on the day the last of the Tyranosaurs died (I'm older than Buck). So, I'm not asking if I'm old. Yes. I'm old. No, I'm asking if that massive meteor strike over […]
2024-10-19
193 reads
2024-10-18
62 reads
Algorithms rule the world and Steve talks about the impact those have on the world.
2024-10-16
66 reads
Steve has a few thoughts on how AIs change the role of databases.
2024-10-14
160 reads
In Azure SQL Database serverless edition, we get an upgrade to our configuration.
2024-10-12
68 reads
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
By Tim Mitchell
Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked,...
Comments posted to this topic are about the item Concatenating Multiple Row Values into...
Hi there, I've tried CROSS APPLY, PATINDEX and many other functions, but can't nail...
What is the best way to continually loop a SQL Server Agent Job? I...
I have some simple sales data in a SQL Server 2022 database that looks like this:
TransactionDate SalesAmount 2023-01-15 1200.00 2023-02-22 1500.50 2023-03-10 900.75If I run this query, what are the sales growth amounts returned?
SELECT ms.TransactionDate , ms.SalesAmount , ms.SalesAmount - LAG (ms.SalesAmount, 1) OVER (ORDER BY ms.TransactionDate) AS SalesGrowth FROM dbo.MonthlySales AS ms;See possible answers