I decided to resume tech blogging after a long break and this tsql-tuesday came in handy. This month’s blog part is hosted by John McCormack (B|T). He would like...
2021-11-05 (first published: 2021-10-13)
683 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...
2021-11-04
21 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...
2021-11-03
19 reads
It’s been a long two years for most of us, with little or no training budget being spent on us at conferences. Online events are convenient and accessible, but...
2021-11-03
50 reads
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and...
2021-11-03
9 reads
No doubt there will be times where you need to scale up the actual instance in terms of vCores but also you may want to move across tiers (for...
2021-11-03 (first published: 2021-10-19)
214 reads
SQL Server 2022 was announced yesterday at Microsoft Ignite, and it’s going to be a big one. Building on a lot of work in the Azure SQL space, SQL...
2021-11-03
104 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The other day I was working with a...
2021-11-03 (first published: 2021-10-27)
296 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...
2021-11-02
13 reads
A few memories from this past weekend, during the first live SQL Saturday event in the US this year. I’ve had plenty of plane flights this year, actually this...
2021-11-02
40 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:08218154393 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
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