I completely agree with Thom about sending emails. I tend to use a table for the target and then poll it as well, because this gives me a record, and...

Be good to see a second article doing this in SQL Server 😉

If any of you would like to see it,  encourage Thomas to write more.

https://blogs.msdn.microsoft.com/sqldev/2009/07/09/dns-srv-record-support-for-sql-connectivity/

The where and what I'd get some version control. If you're not using this, you're hoping developers don't make mistakes, which is not likely as we're all human.

I...

Personally, I like the Instead of Trigger, unless you are willing to alter the schema to a new setup. The reason is this. There's no reason to through any error....

I'm not quite sure what you are trying to accomplish here. I assume this is some formatting of the data all on one line. Is that correct?

Can...

Indexing would be preferred over the constraint, especially if you might get lots of inserts occurring in a short period of time. I'd go with Thom's solution.

If you...

Apologies on the answer. My scheduling thing didn't quite work as expected.

Answer here: http://www.sqlservercentral.com/articles/Logic+Puzzle/176523/

Yes, apologies. The code and repl had sample.py, but I edited the name in the question to make it sound better.

Corrected

It's definitely a thorny issue to use stats in sports. The thing many people want in sports is some guarantee. This doesn't do that. You can't predict a score, but...

FWIW: https://sqldusty.com/2018/08/21/nfl-football-player-stats-analysis-2018-is-now-available/

The answer I got it that there are a number of features from that security tab that write to the registry, which doesn't exist on Windows.  I think the Windows...