Are You Prepared for SQL Server 2008 End of Support?

 

Everything gets old eventually, and now it is official for SQL Server 2008.

03-2012sean-phone-328-e1377042261105On July 9, 2019, support for SQL Server 2008 and 2008 R2 will end. That means the end of regular security updates and general support for the product. Are you ready?

It took more than 10 years for Microsoft to end support for our beloved SQL 2005 and version 2008 has enjoyed a similarly long reign. But it’s over and you need to get used to the idea. Even more, you need to get upgraded to a new version of SQL so your systems can still be patched, updated and supported. With all the nasty exploits out there, letting your software get out of date is more of a business risk than ever.

With cyberattacks becoming more sophisticated and frequent, running apps and data on unsupported versions can create significant security and compliance risks. The 2008 family of products was great for its time, but we highly recommend upgrading to the most current versions for better performance, efficiency, and regular security updates.

Now is a Good Time to Consider Azure

Microsoft is giving a present to businesses that want to migrate their workloads to Azure. For those customers that elect to take this as an opportunity to move to the Azure cloud, extended security updates will be available for free in Azure for 2008 and 2008 R2 versions of SQL Server and Windows Server to help secure workloads for three more years after the end of support deadline. Moving existing systems to the Azure cloud is a natural step in modernizing the business infrastructure and makes the next step of upgrading to managed database services and/or migrating to new Azure servers a lot easier.

Upgrading isn’t simply a matter of maintaining status quo, either.

Moving to new versions can be a foundation for new strategic capability and increasing overall business potential, powering new decision-making processes fueled by analytics and business intelligence.

The Microsoft Lifecycle Policy offers 10 years of support (5 years of regular support and another 5 years of extended support) for the 2008 and 2008 R2 versions of SQL Server and Windows Server. When the extended support period ends, there will be no patches or security updates, which always creates security risk.

If your business is going to remain competitive, you can’t rely on outdated systems.

Your business is tough enough to manage without having your systems work against you.  Software that prevents you from keeping up with demand, creates risk in compliance and security, and reduces operational performance is not what you need. Collecting, storing and rationalizing data takes power and speed, and securing your growing information warehouse requires vigilance in security and update management.

Use this opportunity to review your platforms and applications, and consider moving your on-premises or co-located systems to the cloud. The upcoming milestone is a great opportunity to transform applications and infrastructure to take advantage of cloud computing and the latest versions of SQL Server and Windows Server.

jmbunnyfeetMake Sense?

J

Countdown to End of Life for QuickBooks 2016

Every year Intuit releases a new version of QuickBooks desktop software, enhancing functionality and adding features to keep the product useful in the modern world. As the program continues to move forward, keeping pace with newer operating systems and software conventions, the older technology and application models eventually expire. Without support and updates, key service features or service integrations, the end-of-life versions of QuickBooks become not only less functional, they become less secure and have a much greater potential for problems.

QuickBooks-Hosting-WordCloud

The QuickBooks Desktop Discontinuation: May 31st is the sunset date for 2016 Versions

While Intuit frequently communicates with license holders via various mailings and in-product notifications, including notices about the discontinuation of the version, the message is often lost amid the annoying messages customers receive via email or as disrupting popups in the program. It is very important that users not miss this notification because it really means more than just a need to update the software. Most businesses have more invested than than just a software purchase, they also have their data and operation to consider.

The real investments a business makes when it adopts QuickBooks desktop are the business processes the software supports, the transaction, customer, vendor, job and product information kept in the system, and the financial and performance data that comes from all of that. People, processes and information are the building blocks of the business and losing any of it can be far costlier to the business than the cost of an annual software upgrade.

When do services for QuickBooks 2016 stop?

May 31, 2019 marks the end of access to all services for QuickBooks 2016 Desktop editions. This includes QuickBooks Desktop 2016 Pro, Premier, Enterprise Solutions and Accountant editions for Windows, and the 2016 Mac edition. The software will continue to function at an basic level after that date, but technical support will end and all integrated services will stop working with the software.

What does it means when Intuit says services for QuickBooks 2016 will stop?

Software updates, online support and certain other added functionality within QuickBooks is provided as service integrated with the desktop software. When support and integrated services are discontinued, it means that subscription or added service functionality is no longer available. Payroll services, online banking, online backup and live support are some of the integrated services that will stop working on May 31, 2019.

Businesses that don’t need payroll, online banking or other services with QuickBooks should still upgrade the software.

While the basic functionality of QuickBooks 2016 will continue to work beyond the discontinuation date, the security and compatibility of the system should remain as top considerations. A major aspect of product discontinuation is the loss of software updates and security updates in particular. When users of 2016 QuickBooks versions stop receiving critical security updates, it could leave the installation vulnerable in a variety of ways. Weaknesses in security protocols or password storage, or failure to update software to remain compatible with new versions of Office or Windows (or Mac OS) could not just render the software unworkable but can also lead to potential data corruption or leave private information visible to hackers.

Upgrade to a newer version of QuickBooks Desktop to continue use of payroll, online banking, online backup, support and updates. For Windows users, 2017, 2018 and 2019 versions continue to be supported, but 2019 becomes the only supported version for Mac. Intuit previously indicated that there wouldn’t be a new Mac version, so having a 2019 edition represents a big win for Mac users who wish to keep their QuickBooks compatible with newer Mac OS versions.

People, processes and data are reliant on the software that supports the activities that keep the business running. Central to retaining the value of your business information and operational processes is keeping the software supporting them up to date with the most current feature set, service integrations, and application and update support. After all, the incremental investments made to maintain important assets of the business tend to be less costly than recovering from lost data and reduced productivity due to failure of an unsupported system.

Joanie Mann Bunny FeetMake Sense?

J

 

4 Rules of Thumb for Getting Business Benefit From EDI

The First Step in Transformation is to Stop Doing Things Twice

Double-entry is dumb. Entering data once introduces the possibility of making an error, and entering the data again only increases the chances for a mistake. Typing information into the computer also takes time and the more manual entry is done the greater the potential is for input errors which take even more time to find and correct. Manual entry of information may be required when starting with a paper-based process, but double-entry of information doesn’t make any business sense. In this age of computers, the internet and electronic commerce, reducing manual entry to increase performance and accuracy is more important than ever. Thankfully, manual data entry is being eliminated and EDI is the foundation that helps make it happen.

tall-tower-vancouver“… the key is the unattended and intelligent movement of data from one system to another.  People don’t have to get involved in order for the information to flow from one system to another… it just goes by itself.  Like a robot.”

Robots are just automation you didn’t know you needed

Electronic Data Interchange (EDI) is the use of computer and telecommunication technology to move data between or within organizations. EDI uses strictly structured information that can be transferred from one program to another without human intervention. EDI is one of the most important subsets of e-commerce, being the technology that helps two parties exchange information around a commercial transaction. One of the fundamental first steps in business transformation is the automation of business processes, and this is the main goal of EDI.

EDI addresses and solves problems inherent in paper-based processes. For many, EDI is the basis for reengineering processes and giving manual workflows an automation overhaul.

4-rules-of-thumbHere are 4 Rules of Thumb regarding implementing EDI in the business and where it can deliver the biggest benefits

Rule 1: Go paperless and reduce or eliminate paper-based processes

Delays in activity performance and access to information are often due to paper-based processes, where transportation, storage and retrieval of documents cost valuable time. Labor costs are also higher when paper-based processes reign, increasing overhead costs for document processing and handling. Non-EDI systems also tend to be more error-prone because information is keyed multiple times, and because documents are transported, stored and retrieved by humans.

Rule 2: Reduce operational costs by increasing the speed of business and decreasing processing times and errors

Cutting costs is a top benefit of implementing EDI in the business, centered on doing away with the use of paper while automating key business transactions, saving both time and money in the core process as well as in error correction and problem resolution. Increased productivity is an expected result of employing paperless solutions and technologies. By reducing paper-based processes and embracing electronic transaction processing, businesses can handle more operational activities with the same (or fewer) human resources.

Rule 3: Re-Structure workflows to improve activities that make customers happy

Using EDI in the business helps to structure information and workflows, increasing efficiency and process performance in a variety of areas.

EDI also improves performance because processing time can be reduced to seconds, enabling greater efficiency in services delivery and a level of responsiveness that makes customers happier. Because EDI permits access to a potentially vast amount of detailed transaction data, the information can now be used to automate other processes and stored for analysis.

Rule 4: Get better data and more insight

EDI solutions help to minimize errors in the data, creating a basis for better reporting and analysis. Mistakes in data entry or order taking can be significantly reduced (if not eliminated), and well-structured data removes the need for “interpretation” of the information. Replacing paper documents with electronic ones can also make it easier to keep track of the status of an item, which is why EDI solutions ensure traceability of transactions that paper-based tracking can’t readily provide. All this serves to help the business gain the insight necessary to respond more quickly to changing market conditions and customer demands.

Integrating EDI into the business processes is key to improving business performance in a wide variety of areas. Like moving from phone to fax orders, or from fax to online, EDI represents a big change in how transaction processing takes place. By enabling EDI transactions with current and new suppliers and channels, the business also enables more efficient, seamless communications between all participants in the supply chain. Removing the need to re-key data and reducing the need to rely on human manual processes, EDI systems connect orders and invoices and shipping and returns… and all the trading partners along the way.

 

jmbunnyfeet

Make Sense?
J

 

cropped-logo_mc_w_short-1Cooper Mann works closely with the experts at Mendelson Consulting, experts at QuickBooks and EDI.

4 Rules of Thumb for Better Inventory Management

Do you know where your stuff is? I’m talking about your inventory, and whether or not you know exactly where it is. Surprisingly enough, many small business owners don’t know where their stock is (and isn’t) or when it will get to where it is supposed to be. Whether the items are in-stock or on-order, staged or stored, shipping or standing, managing inventory can be complicated.

Some inventory problems may be easy to identify but there are so many other issues that may be more difficult to track down.

4-rules-of-thumb

The challenges of inventory management are too numerous to count, but these four rules of thumb can help reduce much of the frustration for small businesses and midsize companies alike.

Rule 1: Get real-time inventory status information

To manage your inventory well, you have to know where each item is and what its status is. When you don’t have up-to-date information on product stock you will end up increasing your costs. It costs more when you are rushing the shipment of items in, overstocking products, transferring stock from the location that really has the product to the location that thought they had it, increasing losses due to spoilage or losing productivity by not getting materials to the site when the workers need it. Shipping, overtime labor and other related costs go up simply due to not knowing the status of every item, and customer satisfaction and loyalty goes down.

Getting real-time information on inventoried items requires that item status be tracked throughout the inventory lifecycle. From purchasing to sales, inventory item and stock tracking will allow you to more effectively manage your products and avoid the troubles and additional costs that come with not knowing whether you’ve got it or not. Centralize the information in a software system which has the functionality to support end-to-end inventory management functions and keep that information up to date as activities occur. This is the key to knowing exactly the status of your stuff.

Rule 2: Don’t rely on manual processes

Manual Processes are dumb, m’kay? Really, though, they’re inefficient and take a lot of time and generally result in too many errors. Spreadsheets are hard to manage and time-consuming to update, and manually updating anything makes it prone to errors. When information is managed through manual processes it makes collaboration and sharing of that information far more difficult, which often impedes the performance of those who rely on the data. Perhaps the worst thing about manual processes is that they do not lend themselves to analysis or history tracking, making it difficult to identify historic trends or areas of possible improvement. And manual processes just don’t scale well.

Using software to manage your inventory introduces not just efficiency, but provides the information required to make informed decisions about purchasing and stocking items. Inventory management software delivers a level of automation in recordkeeping for inventoried items that reduces errors and makes the data more useful. When the inventory management software is combined with barcodes and scanning, manual entry of data is further reduced which increases the accuracy even more while also stepping up productivity.

Rule 3: Everyone should get access to the information they need to perform their work

Workers throughout the business need information to perform their jobs, but not every worker needs the same information. Buyers may focus on which products are in demand so they can negotiate the best deal with a supplier, but finance likes to see that purchased stock isn’t languishing in warehouses or on store shelves. While all users may work with the same product inventory, not all users should be able to view or change data that is outside of the scope of their work. A change made inadvertently by one user could become a costly issue to track down and correct.

Getting access to the information necessary to perform the work is a challenge when the systems or software aren’t geared to fully support all the business processes. On the other hand, workers shouldn’t have access to information outside of their area or which is not relevant to their jobs. The key is in providing the right functionality and information for each worker, enabling them to perform their tasks efficiently but not exposing them to other information or processes that may complicate or interfere, or simply take focus away from the task at hand.

Another aspect of information access is making the solution available to workers regardless of where they work from. Warehouse locations and sales offices or retail stores are often separate, so any central system should also address remote office or mobile worker access. Cloud deployment of desktop and network software solutions enables anytime/anywhere access and allows remote offices and warehouse locations to work seamlessly together.

Rule 4: Just know that you can’t scale a manual inventory system

Keeping track of inventory may be do-able when there are just a few items and a single location, but increasing the numbers turns manual inventory unmanageable. More items mean a greater likelihood that products will be missed or miscounted, and more locations increases the complexities of stock management and logistics. Without detailed item and location tracking a business won’t be able to recognize costs or losses per location. The business is more likely to lose or misdirect product, in part because issues with missing product due to worker theft are more difficult to identify because of the manual system.

Scaling a business needs the support of good software and systems to ensure that productivity and performance aren’t stifled even as business requirements expand. Manual systems or low-tech approaches to managing products and inventory may seem usable when there are few products and limited sales activity, but when the activity and volume cranks up, so does the need for a robust system that can keep up. With more orders, products, locations and workers involved a business also increases the chances for loss due to logistical issues, theft or purchasing mismanagement.

Among the considerations when implementing an inventory management solution should be the ability of the system to adjust to changing business needs through customization of processes or by integration with other solutions which extend and expand functionality. Additionally, training workers to use the software should be straightforward and not unnecessarily complicated by other unrelated processes, making it easier to expand use of the solution in the business.

How do you set yourself up for successful inventory management?

Get better software. It isn’t as complicated as you might think and it is really important.

The expense is worth it because the business will end up being more efficient, which drives profitability. The challenge is that there are many software products to choose from and they all seem big and expensive. Inventory management and stock control isn’t a simple endeavor, but the right solution will deliver business benefit quickly rather than requiring extensive training and complicated configuration that eliminates a near-term return.

Connect with us to find the inventory management and control solutions that meet the needs of growing businesses like yours. Our team understands the intricacies of single- and multi-location inventory management, just in time inventory and purchasing for stock, and we also know that small businesses can’t be overburdened by their software else there is no business benefit.

jmbunnyfeet

Make Sense?
J

 

cropped-logo_mc_w_short-1Cooper Mann works closely with the experts at Mendelson Consulting, the best in QuickBooks inventory management implementation.

Contrary to What You Learned in Grade School… Sharing is Bad, Okay?

There is a place and time for sharing. Share your color crayons, share your toys… share your feelings with those you love. But when it comes to business technology and infrastructure, sharing isn’t always the best approach. Some things you should just keep for yourself… like the servers you use for hosting business desktops, desktop applications and business data.

When we first began the journey of bringing small business desktops and applications like QuickBooks to the Internet, the “cloud” was not yet a thing. Hosting providers put up servers in racks in data centers, installed software and stored data on behalf of customers, and did their best to find ways of making the service affordable. Elastic resources, massive scalability and built-in redundancy (which are benefits of a real cloud fabric) were not generally available nor were they even remotely affordable. Because the hardware, networking and other resources that make up the hosting infrastructure is costly, it is important for the hosting service provider to be able to spread those costs across the entire customer base.

In most cases, this meant creating shared servers where many customers run their applications and store their data. Even when a provider suggests that a customer has a “private” server, there is still a good chance the server is using shared storage and/or networking resources made accessible in the environment.

Sharing can be a good thing or a bad thing, and it often depends on the behavior of those involved. In shared application hosting environments, particularly desktop hosting environments, there is a lot of potential for intentionally and unintentionally causing problems that can and will impact other users and customers on the platform.

A simple provisioning error might allow a user to see data belonging to another company or have access to applications or services they should not.

With shared resources, bad actors and intruders can often escape permission boundaries, attaching to network shares and other computers on the platform.

Malware accidentally introduced by an innocent user from one company could easily penetrate the entire system, following paths to data storage locations and other servers, spreading the problem to many customers and systems and even data centers.

If you are operating on the compromised system you are at risk, even if the compromise wasn’t initiated by one of  your users or from within one of your applications.

In the realm of QuickBooks hosting providers, the issues around sharing infrastructure and resources have created some very difficult situations for hosts and for their customers alike – especially when it comes to dealing with computer viruses, malware and ransomware. A few high-profile events, as well as numerous incidents which have flown under the radar, have revealed just how damaging the shared approach can be.

With the IRS, AICPA and other agencies issuing increasingly strong guidance for tax and accounting professionals to protect client information, finance professionals should strongly consider the risk introduced through shared hosting service arrangements and evaluate if it is greater than the costs of having a more private system.

Cloud platforms available today are fully matured, delivering scalability and agility at price levels that are affordable even for very small businesses.  No longer solely for enterprise enjoyment, real cloud solutions and delivery models can be used by small businesses for desktop and application hosting without compromise. Every business deserves their own cloud, and we know how to make that affordable.

Cooper Mann works with teams deploying on the Microsoft Azure platform, offering an agility in design not previously available with legacy computing approaches. Because every delivery is absolutely private to each customer, the solution can be scaled up (or down!) on demand to suit the specific needs of the individual business. More important is the fact that each customer operates separately, so any bad behavior the system may suffer from is their own.

jmbunnyfeetMake Sense?

J

Your QuickBooks Connected Services Will Not Work as Expected

“Your Connected Services Will Not Work as Expected”

Intuit has notified customers of Merchant Services that QuickBooks may not work as expected if they are not running the current release.

Source: Is QuickBooks (Desktop) up to Current Release?

Over the past few weeks, I have received calls from clients that have current versions of QuickBooks (2017, for example), but the software isn’t able to update because the customer doesn’t have a maintenance plan for the software. QuickBooks displays the message saying updates are available, but the user isn’t able to download the updates and receives a message indicating that they do not have a current or in-force subscription.

Intuit is making it clear that maintenance and support is not longer an option with QuickBooks.  Not having maintenance means not getting updates, and not having updates means parts of the software and its connected services stops working. Now, even your desktop QuickBooks is exclusively subscription-based.

Make Sense?

J