Over-Engineering
Steve Jones thinks that we often over-engineer software, trying too hard to consider every possibility rather than getting it close.
2024-11-29 (first published: 2009-07-15)
273 reads
Editorials
2024-11-27
103 reads
2024-11-25
184 reads
Giving Thanks
My last two months have been packed full of activity. I’ve had the amazing opportunity to be with PostgreSQL friends in New York, Greece, and Seattle. In between, it was a treat to be back in Pittsburgh for the first SQL Saturday since before the pandemic. The strength of the database community at each event […]
2024-11-24 (first published: 2024-11-23)
64 reads
New SQL Server 2022 Functions
There were a number of T-SQL functions added in SQL Server 2022. Today Steve asks if you are using any of these in your work.
2024-11-22
1,077 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-11-20 (first published: 2015-05-18)
458 reads
How Do You Patch 100 Database Servers?
The challenges of managing lots of system are significant and there aren't easy solutions, but Steve has a few thoughts on what you can do.
2024-11-18
263 reads
It's The People
Last week the 2024 PASS Data Community Summit conference was held in Seattle. 1,700 of my closest friends got together for a week of learning (well, technically it's a three day conference, but there are two days of pre-conference seminars) and sharing. I'm still exhausted a week later (although, old age and an aggressive travel […]
2024-11-16
119 reads
Do You Want a Microsoft Solution?
Today Steve wonders if official solutions from a vendor are that important.
2024-11-15
123 reads
Separate Reads
Today Steve wonders how many software developers use separate connections for reads and writes in their application.
2024-11-13
138 reads
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers