VS Live Cancelled
I got a note this week from the organizers of VS Live. They let me know the March event in Las Vegas was being cancelled. That was disappointing to...
2022-01-28
11 reads
I got a note this week from the organizers of VS Live. They let me know the March event in Las Vegas was being cancelled. That was disappointing to...
2022-01-28
11 reads
Heraflux Technologies was invited to co-present on an “Ask the Experts” webinar with Pavilion Data featuring Costa Hasapopulous, Pavilion Data’s Chief Field Technology Officer, and myself! RSVP for this...
2022-01-28
17 reads
Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and scale, built for globally distributed
2022-01-27
110 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-27
48 reads
SQL Server has a very useful function called DATEDIFF. This function is used to calculate the difference between the two dates. Read more he
2022-01-27
299 reads
(2022-Jan-27) When Hogarth, a nine-year-old boy, a character from “The Iron Giant” movie, met a 50-foot tall alien robot, whom he eventually befriended, he didn't know about a very special...
2022-01-27
561 reads
(2022-Jan-10) My short answer to this question is Yes and No. Yes, you can use Windows self-hosted Azure DevOps agent to deploy Python function to the Linux based Azure Function...
2022-01-26 (first published: 2022-01-10)
1,046 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve been working with encryption in SQL Server...
2022-01-26
1,478 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-26
43 reads
I have been selected to speak at the DataGrillen conference later this year. I will be presenting my session How Does SQL Server Store That Data Type?, which I debuted during...
2022-01-26
23 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