Widespread New Technology Adoption
It can be hard to change peoples' habits and get them to adopt new technology.
2025-03-15
78 reads
Database Weekly
No End to Programmers
The idea of chat-oriented programming has led some people to think that AI LLMs will reduce the need for programmers. Steve disagrees.
2025-02-08
120 reads
Subscribing to a Great New Year
It is December 27, and the most significant day of the year for reviewing your life is quickly approaching. New Year’s Day is probably the most positive day of the year when people, in all manner of situations, think back to the previous rotation around the earth and decide what they will do better this […]
2024-12-28
46 reads
The Pervasive Nature of Open Source
This week there was a headline that said "Open Source Software Powers 96% of Modern Applications, New Study Finds" and if you stopped reading there, you might think, hey, it's not in the apps I work on. Or you might think that because you use OSS software, most of the world also does. Microsoft, Oracle, […]
2024-12-07
78 reads
Lies You Should Believe - Anything is possible
We have all heard the saying I based this week's editorial on. It has been credited to Benjamin Franklin and goes like this, “You can do anything you set your mind to”. This is such a powerful way of thinking when you are starting a task. “I can do it, no matter what anyone says.” […]
2024-11-30
94 reads
PASS Summit Time
As the Simple Talk Editor, I have had the privilege of attending numerous conferences these past few years, and all of them have been somewhere between great and amazing. Still, there is something a bit more special about the PASS Summit. Even before I started this position, I have been to the PASS Summit events […]
2024-11-02
34 reads
Being an extroverted introvert at a conference
As I start this editorial, I am sitting at a PostgreSQL conference in New York City during the nighttime reception. The sound of 100 voices is not quite deafening, but it is certainly loud and understanding anyone in this group would be hard. It is also hard because I only know about four people at […]
2024-10-05
63 reads
Knowing What You Don't Know
I used to think I knew everything. I felt like I had the world all figured out. But then, when I went to kindergarten, I realized that I didn't know much at all. As I grew older and finished college, I regained confidence in my knowledge and again felt like I knew everything about the […]
2024-09-07
109 reads
Analyzing Breached Data
After a recent data breach, Steve read about an analysis of the data. He has a few thoughts on the process that Troy Hunt went through to dig into the data.
2024-08-17
104 reads
Getting and keeping fit
Don't worry, this is a technical editorial, but the initial analogy starts a bit personal. For the past decade, I've been on a journey to get fit, facing setbacks along the way, such as surgery complications and broken bones, torn cartilage, and, most recently, broken metal implants. Throughout this time, my overall physical fitness has […]
2024-08-10
77 reads
Blogs
CHOOSE’ing a Beer: #SQLNewBlogger
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Don’t Treat Your Data Catalog Like a Data Museum
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
The trade-offs associated with low-code solutions
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
Forums
DbaTools With Powershell - Omit The Id Column on CSV Export?
I am learning DbaTools in Powershell, and my current project is exporting a CSV...
SSIS - ADO Source Datetime Issue
I'm using an ADO Net Source to extract data and running into an issue...
Cummulative Total
Hi I have below query and i want Cummulative Total . Total should be...
Question of the Day
Replacing a Null
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers