StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<blockquote> <p>Is there a zero or near zero config/maintenance piece of software that would achieve this? What are the options?</p> </blockquote> <p>Possibly, but what you would save in configuration and implementation time would likely hurt performance more than your polling service ever could. SQL Server isn't made to do a push really (not easily anyway). There are things that you could use to push data out (replication service, log shipping - icky stuff), but they would be more complex and require more resources than your simple polling service. Some options would be:</p> <ol> <li><p>some kind of trigger which runs your executable using command-line calls (sp_cmdshell)</p></li> <li><p>using a COM object which SQL Server could open and run</p></li> <li><p>using a SQL Agent job to run a VBScript (which would again be considered "polling")</p></li> </ol> <p>These options are a bit ridiculous considering what you have already done is much simpler.</p> <p>If you are worried about the polling service using too many cycles or something - you can always throttle it back - polling every minute, every 10 minutes, or even just once a day might be more appropriate - this would be a business decision, so go ask someone in the business how fast it needs to be.</p> <p>Simple polling services are fairly common, because they are, well... simple. In addition they are also low overhead, remotely stable, and error-tolerant. The down side is that they can hammer the database into dust if not carefully controlled.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload