T-SQL Tuesday #119–Changing My Mind
After missing the last T-SQL Tuesday, I’m back for the latest invitation from Alex Yates. In this one, Alex asks us to write about something in IT where you...
2019-10-08
14 reads
After missing the last T-SQL Tuesday, I’m back for the latest invitation from Alex Yates. In this one, Alex asks us to write about something in IT where you...
2019-10-08
14 reads
Azure SQL Database can be patched without stopping the sqlsrvr.exe process. Quite a feat of engineering.
2019-10-08
180 reads
I’m hosting a webinar later this week with Abel Wang, one of the talented members of the League of Extraordinary Cloud DevOps Advocates at Microsoft. This Thursday, October 10,...
2019-10-07
8 reads
2019-10-07
587 reads
Being a standards advocate, Steve has a few thoughts on team code structure.
2019-10-07
406 reads
The idea of using more unit tests to improve code quality has been around for some time. However Steve Jones notes today that some people use tests for documentation.
2019-10-04 (first published: 2015-05-14)
269 reads
2019-10-04
655 reads
I’m off to Memphis today for SQL Saturday #870. I’m excited as I’ve never been to Memphis and hope to wander around and see something while I’m there. I...
2019-10-04
34 reads
This is part of a demo series I did for a customer workshop. I’m adding a little more detail and explanation of the demos of products I gave. A...
2019-10-04 (first published: 2019-09-30)
393 reads
If you have a list of striped backup files, how can you find the latest backup set? Steve Jones uses dbatools and PowerShell to automate this process.
2019-10-03
2,399 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