Do You Really Need HA?
Steve asks the question about whether or not a particular environment really needs HA implemented.
2025-11-10
137 reads
Editorials
Economics of AI: What is the Real Cost to Profit?
Artificial intelligence is everywhere: It’s in our tools, our workflows, our marketing pitches…and increasingly, in our bottom lines. But a thought-provoking article published recently on the AI bubble asks a far more sobering question: What’s it really going to cost to profit from AI? Many people will roll their eyes and say, “Isn’t that obvious? […]
2025-11-08
87 reads
Poor Name Choice
Steve has a few thoughts on the names we choose for tables, columns, files, and more.
2025-11-07
132 reads
Data > Hype
Most of us believe in the importance of data. Steve has a few thoughts on using data to determine if AI is helpful.
2025-11-05
78 reads
Practice Until You Don't Get It Wrong
We will all make mistakes, but practice can help reduce the errors we cause.
2025-11-03 (first published: 2017-11-27)
290 reads
The Selfish Case for Learning AI
Steve has a good reason to spend time working with and learning about AI technology.
2025-10-31
132 reads
Reducing Cloud Cost
Cloud costs are high and growing. Some orgs think they're out of control and are trying to limit spend. Some orgs are looking to leave the cloud. A lot of IT spend over the years has been seen as a cost center, with many executives trying to limit the growth or spend, even while they […]
2025-10-29
173 reads
DevOps is DevOps
DevOps includes a lot of practices, but no matter which technology that you use, the ideas are the same.
2025-10-27
113 reads
Why Data Modelling Still Matters - More Than Ever
In today’s fast-paced landscape, where agile development and cloud-native platforms dominate, data modelling might seem like a relic of the past.
2025-10-25
229 reads
2025-10-24
96 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
any reason to avoid asking ssis to extract files from ftp
hi we have to replace talend which generally was used to move files. talend's...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers