Just a Week to SQL Sat Pensacola
One of my favorite events, in a wonderful place to spend the weekend. I’ve been to Pensacola a few times (3?), including a couple times with my daughter. It’s...
2019-06-20
34 reads
One of my favorite events, in a wonderful place to spend the weekend. I’ve been to Pensacola a few times (3?), including a couple times with my daughter. It’s...
2019-06-20
34 reads
I’m traveling back from Australia today. A few weeks ago I lost a day when I flew West across the Pacific. Today I get it back, with a different...
2019-06-16
8 reads
I needed to generate some load for a demo and wasn’t looking forward to doing it. I was in a hurry, and didn’t want to deal with a lot...
2019-06-27 (first published: 2019-06-12)
461 reads
I didn’t attend the //build/ conference this year and am slightly disappointed. Only slightly, since I was in these cities in May already and didn’t need another trip: London,...
2019-06-21 (first published: 2019-06-05)
408 reads
After our SQL in the City Summit in Brisbane last week, Hamish Watson () asked me if I’d do a short version of my keynote talk at the upcoming...
2019-06-02
7 reads
I was recently doing some work on Always Encrypted in SQL Server 2019 and needed to set up an HGS server. I went through most of the setup, and...
2019-06-14 (first published: 2019-05-30)
314 reads
I’m writing this in advance, as I usually recommend for all bloggers, because this is a lost day for me. I’m not going to experience May 27th, 2019 on...
2019-05-27
25 reads
Give it a try, as the beta is out. I’ve been watching this product and getting updates for the last six months or so and lately I’ve been pushing...
2019-05-23
118 reads
I was recently doing some work on Always Encrypted in SQL Server 2019 and needed to set up an HGS server. I went through most of the setup, and...
2019-05-22
35 reads
I’m doing a tour of Australia and New Zealand with our SQL in the City crew. We’re going to be in Brisbane, Christchurch, and Melbourne on three consecutive weeks....
2019-05-21
1 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