Monthly Archives: September 2010
Catching SQL Script Errors from an SQL Job
When structuring scripts to execute in production, I often wrap a transaction around the contents of my statements. This is done to keep data integrity in-tact and to make things simpler to support in the event that the execute fails. Here is a quick example:
Posted in SQL Server
Leave a comment
Crystal Reports – Row Level Security
Recently I was asked to take a look at a slow running Crystal Report. This report makes use of row-level security and only returns records the report executor has been granted permissions to see. I was told this report was originally migrated to production with adequate performance (~2-3 second range), but over the past month users have been complaining of a slowdown (~20 seconds).
Posted in Crystal Reports, Report Security
Leave a comment