Daily Coping 29 Dec 2022
Today’s coping tip is to ask for help and let someone else discover the joy of giving. I do most of the cooking in the house, but I thought...
2022-12-29
14 reads
Today’s coping tip is to ask for help and let someone else discover the joy of giving. I do most of the cooking in the house, but I thought...
2022-12-29
14 reads
People have done creative things with SVG measures in Power BI, ranging from KPI cards to infographics to fun games. For my latest Workout Wednesday challenge, I used SVG...
2022-12-28 (first published: 2022-12-15)
298 reads
Today’s coping tip is to look for something positive to say to everyone you speak to. This works well during the holiday season as most people are in a...
2022-12-28
15 reads
We looked earlier at the various places our data lives – on disk, in memory, in-transit across the network. A good strategy will protect all of these locations –...
2022-12-28 (first published: 2022-12-14)
554 reads
Today’s coping tip is to share a happy memory or inspiring thought with a loved one. This is a memory for me: This came up in a Google Photo...
2022-12-27
23 reads
I’m heading back to VS Live in March 2023 for the Las Vegas show. This time it’s at Planet Hollywood, which is a hotel I’ve never visited. I’m excited...
2022-12-27
45 reads
I’m doing another webinar on Jan 18, 2023 with the SQL Solutions Group. You can register here and reserve a spot. Scott Klein and I did a webinar last...
2022-12-27
39 reads
TL;DR: My home firewall/router is slow, please help me pick out a new one.
After replacing my firewall/router/WiFi access point one too many times, I’m ready to get off the...
2022-12-27
116 reads
The nice people from Packt Publishing sent me a digital copy of Benjamin Nevarez new book to review: SQL Server Query Tuning and Optimization – Optimize Microsoft SQL Server...
2022-12-26 (first published: 2022-12-02)
335 reads
Today’s coping tip is to see how many people you can smile at today. Easy one for me. I find this makes me happier and my day better when...
2022-12-26
22 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