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
79 reads
This editorial was originally published on Jul 13, 2019. It is being re-run as Steve is out of town. I recently had the pleasure of catching Paul McCartney in concert, and he was amazing. I have been a fan forever and have heard him tell the same stories he over and over with great delight. […]
2024-08-21 (first published: 2019-07-13)
486 reads
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
67 reads
During a speaker dinner the other week, a lot of topics were swirling around and a few caught my ear. One of these topics dovetailed nicely with a mistake I recently made. More on that later. The discussion was on the effect on safety that all the new safety-based tech is having on driving. Some […]
2024-07-13
64 reads
I was in a social media discussion the other day where someone said “Perfection isn’t real, but progress is.” This started me thinking, is there really no perfection? Can you not actually create a piece of software that is perfect? Of course you can. As long as your requirements are perfect, and the code does […]
2024-06-08
82 reads
Or for short, “Why you have to play the game” “Don't tell me the odds”, cried out Han Solo just before doing something that seemed impossible. How on Coruscant did he do that? Well, as a certain director said about a certain floating door in a galaxy we all call home. ”It was in the […]
2024-05-18
70 reads
Since the title might be considered a bit vague, I don’t want you to wade through the article to figure it out. I will spare you the typical clickbait introduction, with me telling you what a foreign key constraint is, and why it and all the other constraint types provided by relational engines are useful. […]
2024-04-27
178 reads
I want to make this a participation topic. When you are working, do you listen to music or do you need quiet? And if it isn’t music, do you do something else? TV, movies? For me, it is almost always music. As I write my first Database Weekly newsletter editorial in a few months, I […]
2024-04-20
123 reads
During one my yearly review, I got one particularly interesting piece of feedback. “You need to share the work you are doing and share with the company.” This is basically a matter of letting people know about the stuff we are putting out on Simple-Talk.com. It is something that is regularly done here, but to […]
2024-01-27
74 reads
I hate coming up with ideas for editorials, but my last editorial of the year gives me a very simple topic just staring me in the face: New Year’s Resolutions. Love them or hate them (or it we are honest, a good bit of both,) this end of one year and the start of another […]
2023-12-30
127 reads
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
By Rob Sewell
The partner directory connects your agency with new customers.
I had an excellent group of people in Gothenburg Sweden when I taught there...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
CREATE TABLE [dbo].[zA]( [InvoiceNo] [nvarchar](255) NULL, [Code] [nvarchar](255) NULL, [Date] [datetime] NULL, [Type] [float]...
Hello all, Is there an easy way to output my records to a flat...
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers