Can You Become a More Productive Engineer?
Steve has a few thoughts on becoming more effective. This involves more than just becoming a better coder.
2025-01-24
161 reads
Editorials
The AI Budget Assistant
Most of us don't work on budgets, but we are affected by them. Is it a good idea for IT management to use AI to help plan their budgets? Steve has a few thoughts today.
2025-01-22
102 reads
Why Tools Can Help You Do Your Job
This editorial was originally published on May 18, 2019. It is being re-run as Steve is on holiday. Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was […]
2025-01-20 (first published: 2019-05-18)
380 reads
2025-01-17
158 reads
The Managed Cloud Database Options
You have a number of options for moving your database to the cloud, but Steve has a few things you might want to consider before you do so.
2025-01-15
162 reads
Simple(r) Coffee
Choice is good, but too much choice can cause problems in both coffee shops and software teams, as Steve notes today.
2025-01-13
128 reads
The Weather Outside Is Frightful
Yeah, I know, holidays are over. It snowed about four inches overnight here and it's still coming down a little. You'll forgive me for having that song running through my head. Yesterday morning, before the storm started, we did a check through the house to make sure we were ready for a couple of days […]
2025-01-11
72 reads
The Lesser Used Functions
There have been a number of changes to the T-SQL language that are very specialized. Steve asks if you use any in your code?
2025-01-10
272 reads
Adding the Right Value
Are you doing the things at work that your boss cares about or the things you care about? Steve has a few thoughts on this.
2025-01-08
177 reads
The Rise of Data Centers
There is still a huge demand for data centers, both from cloud vendors and private enterprises.
2025-01-06
131 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