Monthly Archives: December 2013

Routinely Check SSRS Log Files

This week I learned that SSRS can run without writing to the SSRS log file.  I am referring to the text file in the  …<InstanceName>\Reporting Services\LogFiles directory.  In this case SSRS had stopped writing log files for over a month.  … Continue reading

Posted in SQL Server Reporting Services | Tagged | Leave a comment

Auditing data changes

Great post about using the output command to capture data changes when running update statements.  A nice alternative when backing up the entire table isn’t that great of an option. http://www.sqlservercentral.com/blogs/sqlstudies/2013/06/26/using-output-to-back-up-a-change/

Posted in Database Administration | Tagged , , , , , | Leave a comment