Message from our President,
As the impact of COVID-19 increases across the globe, I wanted to explain the steps we’re taking to ensure continuity of customer service during the coming weeks.We aim to maintain the level of service that our customers expect from WebSan, as well as ensure that we keep our people safe. Additionally, we want to make sure our offices aren't helping to spread the virus.We’ve taken several steps to minimize the disruption over the coming period including restricting business travel, encouraging best hygiene practices and ensuring that people across all areas of our business are set up to work from outside the office.
Fortunately, we are a global business that is experienced in working with our customers remotely, over the phone or email, rather than in person, and as a result, we expect little disruption to your experience with us. We’ve built a business over the last 20 years that largely interacts with customers virtually – whether to implement our products, get support or get any assistance you might need from WebSan.
Like many organizations, we have had to change some of our plans. We won’t be running some of the face-to-face events that we had planned for the coming months, nor entertain onsite meetings, instead were using virtual events so our customers can still get access to resources and hear from our teams. This is a worrying time for everyone, but we hope with these measures in place that WebSan can be a company you can rely on during this pandemic.
Thank you for using WebSan.
President and Chief Technology Officer
What we’re doing to help businesses during the COVID-19 crisis.
We understand that we’re in unprecedented times and many businesses are operating remotely for the time being.
During these times of self-isolation or working from home, is one of the most important factors that will help our economy weather the turbulent months ahead.
WebSan Solutions wants to help businesses who are currently being affected by COVID-19. As a supportive measure against COVID-19, we are offering the following deals:
- 10% off your Office 365 licenses that will last a total of six months
- 20% off all WebSan University courses by using the offer code: COVID
- Free 1 Hr Assessment to discuss moving GP to the cloud
What Microsoft is doing to help deal with the COVID-19 crisis.
Microsoft has created a crisis communication app. The Crisis Communication app provides a user-friendly experience to connect users with information about a crisis. Quickly get updates on internal company news, get answers to frequently asked questions, and get access to important information like links and emergency contacts.
Resources and support for our global customers impacted by COVID-19
Over the past weeks, Microsoft has mobilized global teams to support communities and organizations affected by the COVID-19 crisis. The Microsoft Dynamics 365 and Microsoft Power Platform teams are working closely with organizations on the front lines of the crisis—including governments, healthcare providers, nonprofits, and schools and universities.
TSQL doesn't handle multiple transactions very well. In fact it doesn't handle it at all. So what do you do when you have nested stored procedures, all which require transaction handling?
TSQL has a built in function that will return the number of BEGIN TRANSACTION statements that have been called on the current connection.
Using this you can choose whether to begin a transaction or not based on the value it returns. If it returns a number greater than 0 then you are currently in a transaction.
However if it returns a 0 then there were no other transactions and you are free to start one. The best way to do this is to set a variable that indicates if a transaction is needed, since when you start your new transaction and you try to check again when you need to do a rollback or commit, @@TRANCOUNT will not return 0 since you recently started a transaction.
You can easily do it like this:
IF (@@TRANCOUNT = 0)
SET @transReq = 1
SET @transReq = 0
IF (@transReq = 1)
--Insert Code Here
--If no error
IF (@transReq = 1)
IF (@transReq = 1)
With this you can have multiple nested stored procedures and you won't have to worry about nested transactions errors.
By: Dustin Yee, Application Developer, WebSan Solutions Inc. a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite Awards Finalist.
On June 2nd 2013, WebSan Solutions took part in Becel’s 26th annual Ride for Heart. More than 13,000 cyclists rode their bikes across the Gardiner Expressway and Don Valley Parkway. The event raised a record of $5.5 million, which is $500,000 more than it did in 2012.
We are glad that we could make a positive impact in eradicating heart disease and stroke! It has been a proud moment for all the employees here at the office.
To view our photo and the July edition of Snap North York, click here: http://www.snapnorthyork.com/index.php?option=com_sngevents&id=520947
By: Natalie Williams, Marketing Coordinator, WebSan Solutions Inc.
Implementing a new ERP Software is a time for new learning experiences and challenges. There are some common mistakes that you want to avoid when implementing ERP software, remember this list so you can become a hero and not a victim of poor planning.
Mistake 1: Not selecting the right vendor
Browsing through a vendor’s website can’t determine if they are right for you. Call the company and speak with someone, this gives you the chance to ask questions about the company and their services. Don’t forget to ask for references so you can hear more than one opinion of the vendor.
Mistake 2: Not taking advantage of all the features that you are paying for!
For any kind of service you pay for, be mindful of what’s included. If you are unaware of a feature that you have but never use, just ask!
Mistake 3: Underestimating the time and resources required
The estimated time for the scope of a project can go two ways: Either the scope is nowhere accurate (underestimating) or the scope is close to being accurate (educated estimating). It’s your job to review the implementation plan. If things are getting out of hand, use the following steps to help you solve a problem: review the problem, resolve the problem and remember the problem so it doesn’t happen again.
Mistake 4: Not properly investing in training and change management
Encouraging questions decreases a number of misunderstandings that occur with your staff. Have other resources available such as, review videos and webinars. Fill out change order requests to make sure your change is on record and not forgotten. Verbal communication doesn’t cut it anymore.
Mistake 5: Not having an active load testing environment
You won’t see the results of your changes based on a couple of “test users”. You must be able to mimic your true user load to see the real effect of changes and to watch out for costly unplanned downtime.
Natalie Williams, Marketing Coordinator, WebSan Solutions Inc., a Canadian Certified Microsoft Partner