As anyone who reads my blog on a regular basis knows, I’m a big fan of using dynamic configurations, including SSIS parameters variables, to make my ETL architectures as...
2020-01-03 (first published: 2019-12-21)
971 reads
The JOIN() function in SQL Server Reporting Services is a handy tool that allows you to turn a list into a delimited string value. This function accepts two parameters,...
2019-12-22
1,939 reads
The JOIN() function in SQL Server Reporting Services is a handy tool that allows you to turn a list into a delimited string value. This function accepts two parameters,...
2019-12-22
1 reads
Visual Studio and its business intelligence variant SQL Server Data Tools share a very powerful but extremely busy interface. If you happen to close out of one of the...
2019-12-20
121 reads
This quick tip is likely to be the most brief of the entire collection, but is also one of the most practical. When testing SSIS packages during development in...
2019-12-19
9 reads
Most folks I know go to one extreme or the other when it comes to the visual layout of SQL Server Integration Services packages: either they don’t care a...
2019-12-18
807 reads
Ordinarily I wouldn’t blog solely about a set of right-click options in an application, but in this Eleven Days of Festivus series I’m sharing some quick tips that have...
2019-12-17
216 reads
Regular expressions (or simply regex for short) have long been used by system administrators and data professionals for searching and manipulating text. Regular expressions allow the user to find,...
2019-12-16
36 reads
I’m a creature of habit. With the software tools that I use, I like to have everything in the same place every time, even if I’m working on a...
2019-12-15
275 reads
Did you know that SQL Server Management Studio can help you arrange your SQL scripts into logical groupings? SSMS includes the ability to associate multiple code files together into...
2019-12-14
36 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