Use this script to rebuild all FullText Indexes across every database. It would be wise to set this up as a repeated Job on a maintenance window. Remember; Standard Editions does not […]
Here’s a quick script to query the SQL Audit log. Remember; you could always do a SELECT * FROM sys.fn_get_audit_file, but this could be a reeeaaallly looong time before you get the […]
Here’s a quick audit solution using SQL Server Auditing. This will only work if you are using Enterprise Edition. Just remember to right-click the Audit file, and make sure it’s enabled. Hope […]
So you have your SQL Audit setup which is cool, but now you want to capture all the SELECT, INSERT, UPDATE, DELETES, EXECUTES, etc.. ( By the way if you’re somewhat new […]
Here’s how to find out how long your backup has been running.
Here’s a basic script which will show you basic information such as the time remaining, and time spent on a backup operation.