2025-09-24
354 reads
2025-09-24
354 reads
Today Steve wonders what you might do with extra time if the AI can give it to you.
2025-09-24
93 reads
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking, two sessions I think. At least one. I’m excited for this session as I’ve had...
2025-09-23
25 reads
Downtime causes a lot of problems, not all of which are financial for an organization.
2025-09-22
122 reads
A short look at the MSSQL extension for VS Code, getting started with connections and running queries.
2025-09-22
9,407 reads
2025-09-22
1,429 reads
One of the most prolific and popular authors at Simple Talk has been Phil Factor. He wrote many pieces on all aspects of database work and has probably written more articles on the Redgate Product Learning site than anyone else. He has entertained, informed, and inspired many database professionals in his many years as an […]
2025-09-19
251 reads
2025-09-19
1,712 reads
Prompt AI released recently and I decided to try a few things with the tool that might help me in database work. I’ve had to do this task, but...
2025-09-17
104 reads
Many of you reading this likely have an Availability Group (AG) set up on at least one database in your organization. Maybe not most, but many of you as this has proven to be a technology that many people like for HA/DR, upgrades, and probably other uses. As the technology has evolved from it's SQL […]
2025-09-17
130 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
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