Upgrading SQL Server in a Container
I decided to update software on my laptop recently during a trip. I’m loathe to do this on most trips, as I don’t want any instability before a presentation....
2025-07-07 (first published: 2025-06-25)
361 reads
I decided to update software on my laptop recently during a trip. I’m loathe to do this on most trips, as I don’t want any instability before a presentation....
2025-07-07 (first published: 2025-06-25)
361 reads
It’s been a week since I flew home from London and Redgate to begin my sabbatical. Actually, at this time last week I was just about to land in...
2025-07-05
17 reads
When you're searching about the future of a career in MS SQL Server, you're not just looking for a pat on the back. You want to know the truth....
2025-07-05
107 reads
In 2025, artificial intelligence is no longer a futuristic concept—it’s a central force in the creative world. From music and film to fashion, literature, and visual arts, AI is...
2025-07-04
22 reads
As businesses increasingly migrate their databases to the cloud, the demand for skilled database administrators is skyrocketing. The DP-300: Administering Microsoft Azure SQL Solutions certification is designed for professionals...
2025-07-04
86 reads
In a recent video, I took a hands-on look at the Next Gen General Purpose service tier in Azure SQL Managed Instance—and it brings some exciting advancements to the...
2025-07-04 (first published: 2025-06-19)
242 reads
I’ve been very happy with Docker Desktop for years, running it on both laptop and desktop. However, a corporate decision was made to move to Rancher Desktop, so I...
2025-07-04 (first published: 2025-06-16)
359 reads
Calling APIs directly from SQL Server has been available in Azure SQL DB since 2022, but now it's available in on-prem in SQL Server 2025...
2025-07-03
6 reads
It’s been a minute since I’ve gotten out to speak at events, but the second half of 2025 is going to be packed.
2025-07-03
27 reads
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted to republish every single object, claiming they were new, despite having incrementally published changed objects...
2025-07-02 (first published: 2025-06-15)
214 reads
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp:0821-8154-398 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
WhatsApp:0821-8154-398 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
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