Thursday, July 27, 2017

Steps to improving the MS SQL Agent


1. Allow for better error handling in SQL agent jobs

For example Error 12 may not mean a complete failure. don't make me have to create a wrapper to take of this.. Allow me to set success and error flags (and what to do)

2. Allow for If X = THIS THEN DO THAT ELSE SKIP

3. Allow us to disable steps. sometimes we just want to skip a step without having to remove the step completely

4. Allow the Error log to be included /attached in the e-mail notifications

If you find this article useful please leave me a comment.

Tuesday, July 04, 2017

SSRS list view bug in Internet Explorer 11 with SQL 2016 SP1 CU3 update

Issue: 
If you happen use SSRS with IE 11 and you have SQL 2016 SP1 with CU3 installed and then try to switch to 'list view' you'll get an error message about could not load folder contents


Workaround:
Go back and just use 'Tile View' or  switch to Chrome (doesn't seem to be affected) or Uninstall CU3 and go back to CU2.

I have reported this to Microsoft but no response yet.

More info:
https://social.technet.microsoft.com/

https://connect.microsoft.com

If you find this article useful please leave me a comment.