Forecasting Kyle Kuzma’s Field Goal Percentage (FG%)
More and more tools are becoming available for data analysts and data scientists. These tools provide convenience and lower the bar...
2019-01-03 (first published: 2018-12-22)
2,439 reads
More and more tools are becoming available for data analysts and data scientists. These tools provide convenience and lower the bar...
2019-01-03 (first published: 2018-12-22)
2,439 reads
It has been a busy year so far. Last March, I did a review, as a Technical Reviewer, for a...
2018-11-02
287 reads
SQL Server 2017 In-Database Machine learning has brought the analytics closer to the data. It is now convenient to do...
2018-04-11
929 reads
Creating a bar graph with R in SQL Server 2017 is relatively easy. It’s just a matter of finding the correct...
2018-04-05 (first published: 2018-04-03)
2,526 reads
As a SQL Server pro, I spend most of my productive time in the SQL Server Management Studio (SSMS). I...
2018-04-04 (first published: 2018-03-27)
2,946 reads
Prior to SQL Server 2016, running R on Microsoft platform required an installation of the R Language and its environment...
2018-03-22 (first published: 2018-03-13)
4,297 reads
Installing R packages in SQL Server 2017 is a breeze with the stored procedure sp_execute_external_script. But so far, it is limited...
2018-03-20
437 reads
Disclaimer: I’m one of the Technical Reviewers for this book.
With the rising demand for cloud computing and wide adaptation of...
2018-03-19 (first published: 2018-03-06)
2,691 reads
Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations...
2018-03-06 (first published: 2018-02-20)
5,592 reads
Productivity is hard to measure when your work has no definite structure like a typical office job. You may operate...
2018-02-27
456 reads
By Rob Sewell
The partner directory connects your agency with new customers.
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...
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