Daily Coping 18 May 2021
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-05-18
11 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-05-18
11 reads
We have a fair number of pretty large databases, and I was having a hard time scheduling full integrity checks to run at least once a week. For a...
2021-05-18
29 reads
This series looks at the Advent of Code challenges. As one of my goals, I’m working through challenges. This post looks at day 5. I’m going to do this...
2021-05-17
31 reads
Short post today. Simple query that will tell you every job that ran between two datetime stamps. Note: this of ... Continue reading
2021-05-17 (first published: 2021-05-06)
678 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-05-17
16 reads
We have some exciting new block editor updates to share with you today including fresh collection of Portfolio block patterns, a new and improved way to embed a preview...
2021-05-17
23 reads
I attended part of the recent PowerShell + DevOps summit, and one of the sessions was from Fernando Tomlinson (@wired_pulse and @underthewire_ps) on incident response. He talked about a number...
2021-05-17 (first published: 2021-05-05)
515 reads
April 21 to 23 saw a new milestone for me. I was a new delegate for the 23rd Tech Field Day! It’s an absolute honor and thrill to be...
2021-05-17
28 reads
At the Microsoft Business Applications Summit 2021, a ton of new features for Power BI where announced. Below is my list of top ten new features, but there were...
2021-05-17
14 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-05-14
12 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:0817819444 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Wa:0817819444 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
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