PASS Summit 2024 – A new experience
I attended the PASS Data Community Summit held in Seattle in person this year after a long gap of 4 years and after RedGate software took over running the...
2025-01-22 (first published: 2025-01-13)
312 reads
I attended the PASS Data Community Summit held in Seattle in person this year after a long gap of 4 years and after RedGate software took over running the...
2025-01-22 (first published: 2025-01-13)
312 reads
One of the things that I like about the Data API Builder (DAB) is that there is a lot of CLI work that can be done. However, lots of...
2025-01-22
135 reads
AI and ChatGPT are all the rage these days. Seems like around every corner is another break-through in how we interact with data, regardless of if that data is...
2025-01-20 (first published: 2024-11-01)
873 reads
The post The pros and cons of self-service BI: What every industry leader should know appeared first on Joyful Craftsmen.
2025-01-20 (first published: 2024-11-04)
723 reads
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest in flip-flops. But guess what? You absolutely can become an SQL whiz without sacrificing your...
2025-01-19
253 reads
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release /revolution from Microsoft SQL Server prospect, including – AI Buildin’, as AI plays an important...
2025-01-19
134 reads
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse – from Excellent Advice for Living This is great advice. I remember myself often saying “I’m...
2025-01-17
19 reads
Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible through a RESTful API.Developers charged with building modern, scalable applications often face the burden of having...
2025-01-17
38 reads
One of the cool things I’ve seen with the new Flyway CLI is that I can combine multiple actions together in one call, which can make the process of...
2025-01-17 (first published: 2025-01-10)
428 reads
Most of us know that spending a lot of time on social media and surfing the web isn't good for us, but we still do it. Why? Because it...
2025-01-17 (first published: 2025-01-07)
506 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...
Wa:0817819444 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Wa:0817819444 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
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