Hi Rick,
I’d like to personally thank you for the extraordinary efforts you went to in helping me solve extensive SQL performance issues for my Australian client. Whilst I have over 17 years of solid M1 experience I had not seen a problem that so severely affected performance like this. I contacted Rick and I am so glad I did.
Rick, you went way beyond my expectations in solving the multiple areas that SQL and Crystal Reports needed tuning with. Some users were taking 120 seconds to login. Several reports were taking 20 minutes to run and caused SQL to lock tables. One by one, other users came crashing down! After running some diagnostic queries Rick came up with a plan to test for a fix. The results speak for themselves. Login times went from between 1 to 2 minutes down to 4.5 seconds. After the first logon, subsequent logons ranged from 1.3 to 3.5 seconds thereafter. Reports went from 20 minutes to 7 seconds … fantastic result! Thank you Rick for being available to help out.
Kind regards,
Martin Maloney
Director
Bondmark Pty Ltd
Type your paragraph here.
In the past we have had times that we wondered why M1 couldn’t do a task which seemed so easy and obvious to us.
Since Rick at ERP SQR Pro was recommended to us we have learned that we can get much more out of our system.
Whether it’s a custom report or just some advanced training Rick has helped us out every time.
The only problem that we have is thinking of enough useful customizations to keep him busy for a day when he comes out! Not a bad problem to have!!
Thanks Rick!
Steve Reynolds
Manufacturing Manager
Lee's Enterprise Aerospace Manufacturing
We have many M1 customizations done by a developer who no longer was able to service our company. Rick has tremendous knowledge of M1 and was able to understand, finish and create new reports and modify old ones. He gets back to us quickly with both small and larger questions and projects. We are lucky to have ERPSQLpro as a valuable and appreciated resource.
Jim – Precision Brush Co – M1 user since 2011
ERPSQL Pro has been a tremendous help to us in customizing M1 to meet our company’s needs. Rick Sheridan not only implements the customizations we request, but, many times offers suggestions that maximize the output of the customizations allowing us to save time and money. ERPSQL Pro has also been a valuable resource in demonstrating attributes of M1 that we may not have been using efficiently and in sharing other types of tools with us, such as custom reports. We have started streamlining various processes and procedures and are very pleased with the relationship we are building with ERP SQL Pro.
Terry Lamberies
General ManagerSchutt Industries, Inc.
Rick,
Superior Thread Rolling has been able to improve our use of M1 greatly with the help of ERPSQL Pro. We had modules in M1 that we had not successfully used for years and with some minor programing and Crystal work with you we are getting information real time and using it daily. Your help in customizing our modules has been very valuable. Your custom reports have also opened our eyes and helped us improve the way that we manage the shop floor! You are always very quick to respond to our requests and we know that if our request might cause another module problems or M1 already has a module that does what we want… I can depend on you to explain all of the options to us before you just write code!! Thank you Rick for being there for my company!
M1 user since 2005
Tom Mundy
President Superior Thread Rolling Co. Inc.
When joining TriTec Seal, in February 2016, as Interim CFO, I knew we had an M-1 business system…although not fully functioning, and I knew we needed an M-1 expert that would “get in the weeds” with me to quickly assess/ train/implement changes in all critical business areas, pertinent to this manufacturing concern. Rick Sheridan with ERPSQL Pro, was just that expert.
Rick and I performed an initial assessment of the current users, module usage and security, understanding the depth of the usage and areas for improvement. Rick became my trusted business partner, implementing everything from, a job description based security system , to developing general training documents, to implementing the Production Planning-Materials module, and developing a standard cost inventory/cost of goods reports allowing the company to reduce the monthly financial closing process by 15 days.
I have worked quite extensively with Rick during 2016/2017, he is a great resource with a practical approach to resolving client issues. Rick provides cost effective, knowledge based solutions for clients utilizing an M-1 business system. His hands on approach, attention to detail and timely response makes it easy to resolve our operating system issues.
It has been a pleasure to work with you!!
All the Best
Dan Shook
TriTec Seal
Rick,
I wanted to drop you a note just to say Thank You for all of your help and support over the past year.
Many times the answers are in the details, and you have helped me tremendously by creating tools that put this information at my fingertips. The latest Sales Forecast, Mapping and new Quote Analysis report have been most helpful. These have saved me many hours turning data into information to help me understand our business trends to develop our 2017 Strategy.
Thanks for all that you do!
Lance J. Wadley TRITEC
Rick,
We cannot overstate how valuable it is to tune our SQL server setting with the Microsoft SQL Server Management Studio. After just 4 hours of tuning, we have seen significant improvements in load times on our grids and entry screens. Our general navigation speed feels about 50% faster. Shop floor boards refresh times have been reduced from 7-8 seconds down to 1-2 seconds. Our customized "Velocity" metric grid has been reduced from 90 seconds to 2 seconds. The gains are so obvious, that we are receiving requests from all departments to look at slower grids. Thank you for all your help!
Ray Baade
Ace Metals Crafts Co.
ERP SQL Pro has been helping us modify our M1 program for approximately a year. Rick has been collaborative, responsive, and a true extension of our team for our M1 modifications. We cannot say enough good things about Rick and highly recommend his services.
Marty Mrozinski, American Autocoat