The Cloud Security Problem
Cloud security can be better than on-premises, but it requires work and knowledge.
2024-10-30
1 reads
Editorials
Databases for Executives
Data and databases are critical in today's world. Executives should understand that, and Steve has something you can pass along.
2024-10-28
103 reads
Knowing Your Total Reward
When you agree to work for a company, you should understand all your compensation.
2024-10-25
116 reads
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
83 reads
Boring or Scripting
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)
299 reads
Idempotent
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)
364 reads
Over-Engineering
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)
200 reads
Tech Debt Perils
Ignoring technical debt can cause no shortage of problems for companies. Today Steve has a recent example of this.
2024-10-21
119 reads
Are We Dinosaurs?
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
223 reads
2024-10-18
64 reads
Blogs
Extending a SQL Server Failover Cluster Across Regions in Google Cloud Platform (GCP)
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
Heading to 2024 PASS Summit
By Brian Kelley
I am able to head back to Seattle for the PASS Summit this year....
Tell me the positives of your solution
By Brian Kelley
I still have a tendency to talk about all the cons of a proposed...
Forums
The Cloud Security Problem
Comments posted to this topic are about the item The Cloud Security Problem
Virtualizing AWS data by using Fabric Shortcuts: Data Engineering with Fabric
Comments posted to this topic are about the item Virtualizing AWS data by using...
Timescale Brings PostgreSQL into the GenAI Era with pgai Vectorizer
Comments posted to this topic are about the item Timescale Brings PostgreSQL into the...
Question of the Day
The LAGging NULL
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers