We combine our expertise with accounting skills and systems experience, tailoring our services and solutions to satisfy your technology needs.
What are Statistics in SQL Server and why do they matter to me? Executive summary – You want to ensure that at the data base level your configuration to maintain statistics are set properly. This means that AUTO_CREATE_STATISTICS is set to ON, .
Continue readingBusiness Insights Explorer (BIE) tasks can quickly compile data using a SQL query from data existing in one or more Sage 500 tables. The user can personalize a BIE task by filtering, grouping, and subtotaling the data as needed.
Continue readingYou created a custom Business Insights View (BIE) but now you need to grant access to users so they can start using it from their menu. In order to add the view to the menu, you must add it in the Task Editor (System Manager > Tools > Task Editor).
Continue readingIf you have spent any time performance troubleshooting your SQL Server, you have probably run across Glenn Berry’s SQL diagnostic queries. In one of these, using the missing index DMVs, Glenn calculates a column called Index_Advantage. I was .
Continue readingSage 500 ERP Aging Recalculation Within Sage 500 ERP, there are tasks that allow you to age all of your Open Receivables and Open Payables to ensure that they are current when viewing this information on reports and explorer views throughout Sage .
Continue readingThere are many times that exchanging data with other systems in the supply chain might be done via text-based files (such as ASCII files, CSV files, and more). Sometimes it is to make the pertinent data available to external systems—like Microsoft® .
Continue readingI was working through a request from a customer to import an excel spreadsheet into SQL Server on a recurring basis. I decided to create an SSIS Package to accomplish this and then call the package from a job in SQL Server Agent. However, when I ran .
Continue readingThere is often a need for end-users to run SQL Jobs on an ad-hoc basis. This creates a security issue because we don't want to install SQL Server Management Studio on the end-user workstation and we don't want to give out Remote Desktop access to .
Continue reading