Where's the Printer Friendly Option?
Steve reminisces about the older technology of putting words on paper, often from the web.
2024-10-04
70 reads
Editorials
Cleaning Up Your Database
How many of us clean up our databases and is it worth it? Steve has a few thoughts.
2024-10-02
541 reads
Effective Engineering
Platform engineering is a new area of focus for some, but it's already being seen as passé by some. Steve notes that there isn't a magic bullet for building better software. It comes about by us working together.
2024-09-30
112 reads
Unstuck
Have you ever been stuck in some area of your life? Maybe at work? That big project. Progressing in your career. The slow query that seems impossible to make faster. Learning new skills to switch careers. Maybe outside of work? The weekend home project that’s been going on for more than a few weekends… possibly […]
2024-09-28
87 reads
2024-09-27
671 reads
AI Is Great and Tech is Failing
Steve is a little disappointed in technology that didn't work well after a security incident.
2024-09-25
186 reads
No Backdoors
Governments want backdoors built into encryption software, which Steve thinks is a bad idea.
2024-09-23
125 reads
2024-09-21
142 reads
Bad Stored Procedures
Stored procedures can be poorly written, but Steve prefers them over embedded code.
2024-09-20
436 reads
When Do We Worry About Scalability?
Steve has a few thoughts on the tradeoff between getting work done quickly and producing well performing code.
2024-09-18
133 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