Daily Coping 3 Jan 2023
Today’s coping tip is to use one of your strengths in a new or creative way. I have a lot of strengths. They’ve helped me to be successful. This...
2023-01-03
23 reads
Today’s coping tip is to use one of your strengths in a new or creative way. I have a lot of strengths. They’ve helped me to be successful. This...
2023-01-03
23 reads
Today’s coping tip is to start the new year off with something new – listen, watch, read something completely different. I started listening to more country music last year....
2023-01-02
16 reads
This is a bit of a niche blog post, because you don’t actually need this to make your Azure Function work :). When you create a new HTTP-triggered Azure...
2023-01-02 (first published: 2022-12-16)
202 reads
Other PASS Summit 2022 Days - Pre-Cons | Day 1 | Day 2
--
Day 3 of Summit 2022 was "Community Day" with a "community keynote" given by the amazing Kimberly Tripp (@kimberlyltripp)...
2023-01-02 (first published: 2022-11-19)
205 reads
It was about time. The blog and all related services are being changed the name. From SQL Player to Azure Player. You probably noticed over several years that the...
2023-01-02 (first published: 2023-01-01)
66 reads
Trigger warning: suicidal ideation, depression, bipolar, mania If you would prefer to stick to all the positives skip to the numbered list at the bottom.
The post T-SQL Tuesday #121:...
2022-12-31
23 reads
Recently a customer was trying to sync up production and development. They’d somewhat lost control of both environments and wanted to build a plan of how to sync them....
2022-12-30 (first published: 2022-12-19)
345 reads
Today’s coping tip is to give thanks. List the kind things others have done for you. I know that my life is great, but it’s because of a lot...
2022-12-30
25 reads
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. December is usually quiet, though this year I spent the...
2022-12-30
15 reads
I am humbled that many posts were submitted for T-SQL Tuesday #157. There is such a wide range of plans to wind down 2022. So enjoy the posts below...
2022-12-30 (first published: 2022-12-20)
257 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