Using Prompt AI for a Travel Data Analysis
I was looking back at my year and decided to see if SQL Prompt could help me with some analysis. I was pleasantly surprised by how this went. This...
2026-01-16 (first published: 2025-12-31)
323 reads
I was looking back at my year and decided to see if SQL Prompt could help me with some analysis. I was pleasantly surprised by how this went. This...
2026-01-16 (first published: 2025-12-31)
323 reads
2026-01-14 (first published: 2026-01-05)
453 reads
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine. This version focuses on AI features and better performance, aiming to meet the needs of...
2026-01-14 (first published: 2026-01-05)
780 reads
Part of being a DBA is dealing with transaction logs that grow uncontrolled for some reason. This often gets raised to the DBA in the form of a drive...
2026-01-13
6 reads
In the era of cloud-native applications, Kubernetes has become the default standard platform for running containerized workloads. While Kubernetes is one of the best orchestration tools, it also presents...
2026-01-12 (first published: 2025-12-31)
153 reads
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names. I had to test and discover if I could make things better, and I could....
2026-01-12
53 reads
One of the more frustrating aspects about creating an Azure virtual machine is that if you do not place it into an availability zone at deployment time, you’ve traditionally...
2026-01-12 (first published: 2025-12-15)
126 reads
fawtle – n. a weird little flaw built into your partner that somehow only endears them more to you, in the way that impurities dissolved in water are what...
2026-01-09
31 reads
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests, demands, suggestions, and more about how to add AI into our products and help developers...
2026-01-09
23 reads
One of the things that I like about the SQL Server docs (MS Learn Docs) is that I can fix things I find wrong. For years we had downloaded...
2026-01-09 (first published: 2025-12-10)
256 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