Extended Events: Avoid the XML
One story I hear over and over goes like this: I tried setting up Extended Events, but then I saw the output was XML so I stopped. Look, I...
2021-04-08 (first published: 2021-03-29)
372 reads
One story I hear over and over goes like this: I tried setting up Extended Events, but then I saw the output was XML so I stopped. Look, I...
2021-04-08 (first published: 2021-03-29)
372 reads
I just found out that VMware has updated their in-guest time synchronization with the 7.0 Update 1 release. Previously, we had to manually disable some of the advanced time...
2021-04-08 (first published: 2021-04-01)
251 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-04-07
11 reads
This is part five in a five part series this week, Moving into Consulting 101.
In the business consulting system, the clients are served by two separate yet equally important groups....
2021-04-07 (first published: 2021-03-26)
239 reads
The last time I presented a session was at the final PASS Summit in November 2020, so it is time to get back on the virtual conference trail again....
2021-04-07
13 reads
In this post we look at Transparent Data Encryption (TDE) in SQL Server. What it is - and how it works.
2021-04-07 (first published: 2021-03-29)
418 reads
Just a little over a year ago, I started posting a “Good Morning!” tweet on Twitter every work day. I’ve kept it up for over a year and I’d...
2021-04-06
113 reads
Edit: The April 26 workshop will be at 10:30am Central Time, because right after that I get my second Covid […]
The post Bullet Journal Workshop for April/May! appeared first...
2021-04-06
15 reads
I’ve started up a monthly Bullet Journal workshop: a recurring meetup to talk organization, productivity, and tools to support mental health. All centered around Bullet Journals, of course. The...
2021-04-06
11 reads
I’ve started up a monthly Bullet Journal workshop: a recurring meetup to talk organization, productivity, and tools to support mental health. All centered around Bullet Journals, of course. The...
2021-04-06
24 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