SQL You Can UseThis is session designed to illustrate user interactions with the BusinessPlus database and provide some tips and tricks that may help you with your own BusinessPlus installation.
I will walk through four scripts of varying complexity giving hints and pointers on how you can cusotmize these scripts for your own organization. After the session, I will make the scripts available for anyone to use and customize.
0 - Trivia
1 - Semi-automated Refresh Test Database (refresh.sql)
2 - Randomize personal information in your Test database (randomize.sql)
3 - Functions for fun (and CDD)
4 - Normalize those tables (Payroll timecards and pay history)
5 - Username changes in Nucleus/Workflow without creating a new user
Note:
There is a lot to cover here and this is going to be fast moving. Attendees should be comfortable with SQL and have a good familiarity with the BusinessPlus data structure. The session is interactive, bring your questions, curiosity and overall, have fun!
Deep links to the documents:
https://static.sched.com/hosted_files/snug2022/b7/2022%20NationalConference-SQL.pptx
https://static.sched.com/hosted_files/snug2022/ba/PresentationSNUG2022.zip
https://static.sched.com/hosted_files/snug2022/52/2022%20NationalConference-SQL.pdf
Also added some workflow information. Including the workflow watcher script that will send an email alert when workflow queue is backed up. Schedule that script to run about every 15 minutes via SQL Server job.
.
