Uninstall PolyBase from SQL Server
If you have SQL Server 2019 or SQL Server 2022 installed with PolyBase and you try to install SQL Server 2025, it will fail during...
2025-05-24
21 reads
If you have SQL Server 2019 or SQL Server 2022 installed with PolyBase and you try to install SQL Server 2025, it will fail during...
2025-05-24
21 reads
If you have any doubt about being able to carry a load in one trip, do yourself a huge favor and make two trips – from Excellent Advice for...
2025-05-23
29 reads
Here are the slides from my talk today at the Redgate NYC Devour Hour: Architecting Zero Downtime Deployments.pptx The Repo is here: https://github.com/way0utwest/ZeroDowntime An interesting question on feature toggles:...
2025-05-23
38 reads
Back in 2018, I wrote a blog post about my Home Lab environment, which I had built around VMware vSphere to showcase various SQL Server workloads and demonstrate how...
2025-05-23 (first published: 2025-05-12)
323 reads
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0) was announced, I was a few months in at the SQL Docs team, and had...
2025-05-23 (first published: 2025-05-19)
571 reads
I recently was privileged to speak at SQLDay in Wroclaw Poland… man, I love visiting Poland… Anyway… Great event. Worth your time to attend, and if you’re a speaker,...
2025-05-22
46 reads
Once again there were a number of Microsoft Build announcements related to data and AI, and some were very impressive. Below are my favorites. Everything announced at Build can...
2025-05-22
50 reads
You know I had to do it as soon as I found it was possible. Yes, I installed and enabled AI in the DBeaver Query Editor so I can...
2025-05-21 (first published: 2025-05-05)
261 reads
I had a suggestion from somone on a place where AI helps them and I decided to try it. The person had an AI summarize their work and if...
2025-05-21
31 reads
Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it, the new version of SSMS is now generally available. It’s a big new version and...
2025-05-21
8,369 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