What is the best way to dynamically collect data from an SQL Database : <p>So currently I have a system that pulls data from an SQl database and displays the details in separate counts.</p>

<p>For Example, Total Tickets, Tickets with Support, Tickets with customer etc.</p>

<p>The only time this data get update is when the user  reload the page or navigates to another part of the system.</p>

<p>I am looking to revamp the whole system to that the data is always valid instead of users needing to reload the page. </p>

<p>I have been looking into JQuery and AJAX however all the information I have been finding still requires user input.</p>

<p>So I would some advise or links on how to setup a system that requires no user input and instead pulls the data every X seconds and updates the page without refreshing it. </p>

<p>I also want to then be able to expand this functionality to display in-page alerts when new tickets are logged etc.</p>
