Videos from MITRE ATT&CKcon 4.0
If you aren’t familiar with the ATT&CK framework and knowledge base, it’s a tool to help classify and understand cyberattacks. Recently (Oct 2023), ATT&CKcon 4.0 was held and MITRE...
2024-01-29
29 reads
If you aren’t familiar with the ATT&CK framework and knowledge base, it’s a tool to help classify and understand cyberattacks. Recently (Oct 2023), ATT&CKcon 4.0 was held and MITRE...
2024-01-29
29 reads
lyssanmania – n. the irrational fear that someone you know is angry at you, that as soon as you wander into the room, you’ll be faced with a barrage...
2024-01-26
35 reads
All Spark Connect Posts
Code
Goal of this post In the first two posts, we looked at how to run some Spark code, firstly against a local Spark Connect server and...
2024-01-26
369 reads
The Flyway Desktop Version Control tab is gone and a new blade has appeared in its place. This post looks at the changes and what that means for a...
2024-01-26 (first published: 2024-01-12)
123 reads
I’ve had a really disappointing experience with the Liquid Web sales team, regarding the web server that hosts this blog post you’re reading right now. My disappointment is compounded...
2024-01-26
45 reads
Understanding query plans is key to successful query tuning in Microsoft SQL Server. Randolph West of the Microsoft docs team posted on Thursday that the logical and physical showplan...
2024-01-26
50 reads
So what did I learn? I think a better question is, "What did I re-learn?"
2024-01-26 (first published: 2024-01-09)
244 reads
It’s T-SQL Tuesday again! In fact, it’s the first of the year and our intrepid host is Reitse Eskens (blog|twitter). ... Continue reading
2024-01-24 (first published: 2024-01-09)
543 reads
I am a big fan of the cloud. While I appreciate local storage and privacy/control/security, etc., that stuff can also go away locally. Plus, I like the convenience, and...
2024-01-24
43 reads
A couple of weeks ago, I encountered a DAX question that I had not previously considered. They had a situation where there were two paths between two tables: on...
2024-01-24 (first published: 2024-01-09)
499 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