News

SQL Advisor Query SQL Server with PowerShell Get the right information on your SQL Servers via the Get-Service cmdlet. By Joshua Jones 03/10/2011 Last time, I discussed how to get PowerShell and SQLPS ...
I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 ...
For as long as I can remember, I have always configured the computers within my own organization to store data on network servers as opposed to the data being stored on workstations. That way, if one ...