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.
Labels:
SQL
,
SQL Agent Jobs
Tuesday, July 11, 2017
New in SQL 2008 : Transparent Data Encryption Part I - sqldbatips.com blog
New in SQL 2008 : Transparent Data Encryption Part I - sqldbatips.com blog:
'via Blog this'
If you find this article useful please leave me a comment.
'via Blog this'
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.
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.
Subscribe to:
Posts
(
Atom
)