A Domain for Data
A SQL DDL statement that Steve never knew about is the subject of today's editorial.
2025-04-04
143 reads
Editorials
Database DevOps Metrics
DevOps includes the idea of measuring how code flows through your organization and looking for ways to improve your software development process. Steve has a few thoughts on the four main metrics many developments use.
2025-04-02
78 reads
Is GenAI Coming Faster Than You Think?
GenAI technologies have created a lot of concern among many tech workers. Steve has a few thoughts on how these technologies might impact data professionals.
2025-03-31
137 reads
Fantasy baseball and old habits
Old habits are hard to change sometimes. Time and again, regardless of what the task or query for information might be, my go-to source of information is Google. Whether on my phone or computer, my muscle memory instinctively opens a browser window or clicks into the search widget and starts typing. My “google foo” has […]
2025-03-30 (first published: 2025-03-29)
56 reads
The Inefficiencies of Kubernetes
Kubernetes hasn't proved to be as useful to many companies as they expected.
2025-03-28
130 reads
The End of SQL Server 2019
Steve has a few thoughts after the end of mainstream support for SQL Server 2019.
2025-03-26
1,385 reads
Monoliths and Microservices
Should we build modern software as monoliths or microservices? Or something else? Steve has a few thoughts today.
2025-03-24
145 reads
Smile and Wave Boys
I won't even try to hide it. I got a huge kick out of the penguin characters in the animated movie, Madagascar. For those who don't know, they're trying to escape the zoo, but are trying to hide that from anyone discovering it. So, they put up a front, "Smile and wave boys. Smile and […]
2025-03-22
88 reads
More Supply Chain Attacks
Code is vulnerable to supply chain attacks, which aren't something many of us think about.
2025-03-21
116 reads
Lower Your Attack Surface Area
We all know security is important, but we sometimes make the job harder when we don't handle data appropriately.
2025-03-19
168 reads
Blogs
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...
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
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