This is a simple Missing Index Script with no Advertisements to bog you down. A few words of guidance: Don’t blindly add indexes. For example, DO NOT add all the indexes this script returns. Be methodical in determining what indexes would have impact and test them one at a time. Keep track of what indexes …
SQL Server Contained Availability Groups are a new, shiny feature that has great use cases and potential. With that said, you may want to hold off on using them if you haven’t taken the time to understand the impact and limitations. By next version of SQL Server, I see this getting closer to being the …
At a recent customer onsite, a customer asked if we would be able to create a report that more accurately reflected their Gross Profit. Some of the challenges they were facing were related to the applications they were using. Either the lack of integration between the ATS (Applicant Tracking System) and ERP (Enterprise Resource Planning) …
As part of your Azure SQL VM Migration project, if you do NOTHING ELSE, read this: Checklist: Best practices & guidelines – SQL Server on Azure VMs | Microsoft Learn Do you want to make certain you have a successful Azure SQL VM Migration? Then, keep reading. 🙂 If you would have asked us 5 …
Dynamics GP does not allow a user to void a document where the unapplied amount is greater than $0. Thus, a workaround is needed to allow the transaction to be voided. Ultimately, the steps involved are: Fully apply the transaction. Void the historical transaction(s) (fully applied AP document(s) automatically move to history). Let’s use an …
Power Automate – Connecting to the Acumatica REST API Are you an avid Power Automate User looking to connect to Acumatica but ran into roadblocks creating a Power Automate Custom Connector? Or starting anew and looking for some guidance? You are not alone! The answer to this topic has been somewhat elusive. So, we felt …
Connect to Acumatica REST API with Power Automate Read More »
No matter how long you have been using Dynamics GP, you can be certain that you will encounter an issue while posting batches. To help minimize your probability of encountering a posting interruption, it is recommend you always print and review the Batch Edit lists prior to posting. The Batch Edit Lists can be printed …
Another SQL Product End of Support?? We have reached the end of another SQL Server product life cycle from a support standpoint. I remember when SQL Server 2012 came out. It was a very exciting release since we had waited over four years for this release to arrive. Not only that, but we were also …
Najaxa Software LLC is pleased to announce a reseller partnership with Acumatica, the world’s fastest growing ERP solution. Customer demands are quickly changing and with a growing remote workforce, moving to an ERP Solution that understands digital transformation is paramount. Acumatica is a future-proof, cloud-based solution that offers anytime, anywhere access to your data. With …
Najaxa Software LLC Announces Partnership with Acumatica Read More »
