Daily Coping 21 Mar 2023
Today’s coping tip is to listen to a piece of music without doing anything else. This is surprisingly hard. I turn something on, but then I look around, think...
2023-03-21
8 reads
Today’s coping tip is to listen to a piece of music without doing anything else. This is surprisingly hard. I turn something on, but then I look around, think...
2023-03-21
8 reads
My biggest fear when my book went into production was that any factual errors had slipped through my checks and the various reviews. I had a lot of reviewer...
2023-03-21
23 reads
At the most recent SQL Bits, I gave two 20 minute sessions. I also gave one last year. There is a little bit of controversy around these (nothing real,...
2023-03-20
4 reads
Today’s coping tip is to get outside and notice how the weather feels. This was a good tip to see before my trip last week to the UK. I...
2023-03-20
8 reads
V Joyful Craftsmen máme skvělý bonus (tzv. SGP), v rámci, kterého se můžeme vzdělávat v určitém tématu a tím se posouvat dopředu. Já jsem si jako Data Tester pro svoje...
2023-03-20
3 reads
It’s been a good week at SQL Bits. This is my favorite conference, and the organizers go out of their way to make it a fun and sustainable event....
2023-03-20
15 reads
In SQL Server 2022, a new feature called Intelligent Query Processing (IQP) makes use of machine learning to enhance query performance. Because of the automatic workload adjustment provided by...
2023-03-20 (first published: 2023-03-09)
484 reads
I recently did a talk to the Data Platform Down Under User group and it covers a whole heap of stuff that I’ve written about in this series. Check...
2023-03-20
7 reads
In late March 2021 Azure Data Explorer Engine v3 was release and it is the latest version of the engine that powers Azure Data Explorer. It is designed to...
2023-03-20
29 reads
I can’t really write about provisioning anything in Azure without mentioning Azure CLI.My last two posts were about using terraform and bicep Here we will be using the Azure...
2023-03-20
8 reads
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers