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

MSP, IT, Telecom, Channel: Convergence and the Cloud

Small and growing businesses have always relied upon various service providers and vendors to deliver the solutions required which support the business operation. Often viewed as the critical infrastructure of the business, phone and computer systems are among the first acquisitions a new business makes.  Phones and voice service, wired and wireless networks and all forms of communications infrastructure are part of IT and represent a large portion of the business information systems.

Small businesses used to have a phone guy they could call for phone stuff. The phone guy was a person or company who got phone lines installed, ran cabling for phones, installed phone systems and set up voicemail. The phone guy could help get cheaper long distance calling rates and train users on how to use the paging system and transfer calls.  The phone guy interacted mostly with the office manager or receptionist – the person in the office most likely to be “in charge” of the phone system, influencing these purchasing decisions greatly.

The computer guy, on the other hand, made sure the workstations and server were working, defragged hard drives, installed software and set up printers. The computer guy was the person or company that sold and supported the IT in the business, and often consulted with the business owner or line manager when it came to addressing information system requirements.

Telephony and networking is now clearly in the realm of IT, which changes how services are selected and purchasing is influenced. Computing and communications infrastructure, networking and mobile is all part of business IT. The separation of services – voice versus data – is gone.  The phone vendors and the IT suppliers are now the same company, providing the critical infrastructure, the platforms and the application services that businesses are buying. These service providers understand that the foundations for delivering voice and data services are the same; the skills of their techs and the tools they use have converged to the point where there is little separation of duties.

Cloud services and outsourced solution providers offering hosted PBX and virtual applications infrastructure have revealed to business owners that there is often little difference in what the phone guy and the computer guy can provide. Business owners want converged solutions: voice and data when and where they need it to support business operations. Just a little research reveals that these anytime/anywhere models are widely available and that the cloud is the key.

IT services are critical to the business, but the server doesn’t have to be under the front desk or in a back closet in order to function.  There is simply too much evidence in the market for these business owners to ignore;  shooting the server is now a viable option.

Every day more business owners are being inspired to [shoot their servers] seek out the services that will allow them to continue to benefit from innovations in technology while relieving them of the direct responsibilities of equipment purchasing, implementation, administration and lifecycle management.

Cloud services deliver this capability, and channel partners and Value Added Resellers should recognize their opportunity to get inspired as well, and to start offering cloud-based and hosted services to their customers and capture the “buying decision” opportunity that has [been] created.

Ready. Aim. Fire.

Source: Go Ahead and Shoot the Server: End of Microsoft Small Business Server Inspires Cloud Adoption with Small Businesses « Cooper Mann Consulting

Recognition of the convergence of voice and data services and channels hasn’t really hit home for a lot of resellers and channel partners, and this has rightfully positioned providers on both sides of the equation as viewing the others as direct competitors.  The phone guy thinks he is his customer’s “trusted advisor”, and that the loyal customer will certainly come to him if there is ever a need.  As well does the computer guy believe that he is the trusted advisor, having the ear of the business owner and wielding enough influence to ensure a continued revenue-earning relationship.

In truth, both the phone guy and the computer guy probably have earned their business customer’s trust and were the go-to people when there was a new business need. The problem is that the customer may no longer call one or the other of their “go-to” guys because the forward-thinking guys are offering one-stop service that delivers everything the business needs.  The lines between phone and computer stuff are not so clearly drawn any longer; it is all cloud IT and full service providers are winning the customer business.

Channel resellers, agents and MSPs are all telling their SMB/SME customers the same things, and at a base level they’re selling the same things, too.  Everyone is talking about lower up front investments and improved business productivity… and what they’re all selling is cloud and virtual. “Businesses need cloud in order to compete; move CapX to OpX; mobile is the new office” and “remote workers and devices need a secure quality network”.

Whether it relates to telephone systems with voicemail, automated attendants and a little intelligent voice response thrown in, or if the deal is for servers and workstations, software and network cabling, it is all business information technology and the trusted advisor is the guy who can provide it all. Convergence has clearly arrived.

Make Sense?

J

Cloud and Digital are Driving Change in Professional Practice

Accounting and Finance Professionals: Cloud and Digital are Driving Change in Professional Practice

Accountants and financial consultants working in public practice are experiencing a revolutionary change, evolving from documents and paper-based processes with after-the-fact reporting to real-time business management and providing services which support daily decision-making.  The underlying cause for this evolution in business accounting is the technology: cloud and collaborative computing models are enabling much closer and regular interaction between accounting professionals and the businesses they serve. Even more, technology is taking its proper place in automating once tedious activities, allowing professionals to focus on causes and results rather than on transactions.

What is the real impact this is having on the accounting profession?  It’s forcing a new focus and attention on change management within the practice, and is causing professionals to recognize the requirement for standardization of processes and development of controls which are the foundations for creating sustainability in a business.  The goal now is placing reliance on process rather than people, which establishes the basis for intelligent automation.  Standardization of processes does not require that the firm lose its personality.  Rather, the mission at hand is to imbue the organization with its unique flavor and approach and to use process automation to develop and support consistency in the functions performed.

While cloud computing models allow accounting and finance professionals to work closer with their business clients, it is important that the practice look at those client interactions and develop standards for processes supporting frequently performed functions.  These operations generally represent the activities within the firm which generate the highest levels of profitability due to the consistency in approach and repetition of tasks, and are the activities to apply intelligent automation to first.  Those activities or engagements which represent the “one-offs” are often the most costly for the firm to perform, and therefore may not be the most profitable of activities and are certainly the most challenging to support with any significant level of automation.  It is in this area where AI will find useful value in the practice, where a more informed answer than simple process automation is required.

The surprising finding when looking at many professional practices with more than one partner/professional involved is that these firms often fail to develop even the most basic of standard processes which apply throughout the firm.  Rather, each partner or professional has “their way” of handling things, which challenges the supporting personnel as they try to deal with multiple working methods. The result is a lack of consistency in the service delivery to the clientele and reduced productivity and profitability for the firm.

The thing that these firms are failing to recognize – the light bulb over their heads that just isn’t lighting up – is that cloud computing and collaborative working models aren’t designed just to enable and facilitate a closer working relationship with clients.  They’re also able to be applied inside the professional practice, enabling a more productive and efficient workflow which addresses the strengths and capabilities of the entire organization. And it doesn’t stop there.  Businesses are relying upon their accounting professionals to provide guidance and develop controls and standards to support the client transformation from paper-based to digital operations, and embracing the entire realm of data and interactions associating with the business. Digital transformation in a client business demands transformation in those firms who serve it.

As professionals learn to go deeper in client operations they would do well to look internally, too, exploring how increased attention to process automation and consideration for the firm’s own “digital transformation” might lead to great profitability through market differentiation and improved performance.

Make Sense?

J

Licensing for Hosted Application Services: Why it costs what it costs

Licensing for Hosted Application Services:

Why it costs what it costs

Application hosting services are experiencing resurgence in popularity these days, due to the prevalence of messaging about the benefits of a “cloud” technology model.  While hosted application services aren’t really cloud (according to cloud technology purists, anyway), they can look and feel and be paid for just like cloud solutions, so the name fits OK.  Hosted applications are desktop or network applications you access via the web, where the software is implemented and managed by a 3rd party application service provider (the host) rather than being installed on your local PC or LAN.  Some software products may be rental-licensed by the ASP, and when combined with the hosting service, the entire subscription service is more like SaaS (software-as-a-service) than the old “purchase and install” approach.

An important supporting program for application hosting service providers is the Microsoft Service Provider License Agreement program. Under a formal agreement with Microsoft or via an SPLA reseller, service providers and independent software vendors are able to license the latest Microsoft software to provide software services and hosted applications to customers. With the SPLA, service providers and ISVs can lawfully license Microsoft products on a monthly basis to host software services and provide application access for their customers. The SPLA supports a variety of hosting scenarios to help providers deliver highly-customized and robust solutions to a wide range of subscribing customers, and it’s the only valid means for obtaining subscription-based provider licensing for these products.

Because the software products being hosted are essentially desktop or LAN-based products, the underlying technology to “deliver” those applications is generally of a similar foundation.  In cases where the provider is offering hosting of Windows-based QuickBooks desktop editions or Microsoft Office applications, for example, the platforms and servers used by the service provider are almost certainly Windows-based.  This operating system, as well as the rights to allow remote user connections to it, is licensed to the provider from Microsoft under the SPLA.  These elements are referred to as “user” licensing elements.

An aspect of Microsoft reporting and licensing which is not well recognized (or frequently complied with) is the difference between user and application licensing.

User licensing, which includes the Windows server access license as well as the remote desktop user license, is a named user access license. This means that the provider need only report and settle for the user license if the user actually accesses the system during the reporting period (usually each month).  Not quite like a concurrent user model, where only the high count of users is reported, the named user model requires that the license for each user be paid if that user logged in at any time and remained logged in for any length of time during the reporting period.

Application licensing applies to the application software license acquired through and governed by the use-rights provided for and granted under the Microsoft SPLA. Rental application licensing is assigned to a specific, named user, and is to be reported fully on a monthly basis regardless of whether or not the user accessed the software. This is in direct contrast to the named user access licensing described above. Providers are required to report and settle on a monthly basis the total number of subscribed application licenses available to users, including Microsoft Office applications, Exchange, SQL and others, regardless of whether or not the user actually logged in and used the products.  The license is assigned to the user and is therefore required to be paid.

Being an application hosting service provider is a complicated business, and there is a lot to consider when developing subscription services for broad customer delivery.  Pricing is one of the complaints customers voice relating to these services, but the reality is that it takes quite a bit in terms of system resources and licensing to provide an acceptable hosted application experience.  This is one of the areas where SaaS and true cloud solutions benefit from a scale economy – where the application is designed for the platform, and one instance of the solution and platform can serve a large number of customers more affordably.

When working with a hosting service provider, it is wise to recognize that the platform and software licensing costs are there to support the type of applications being hosted.  If you have an SQL-based application, you will need the SQL licensing to support it, just like you have to pay for licensing of an Exchange mailbox or a hosted copy of Word.  Enabling only a portion of the total business software requirement may make it difficult to cost justify hosting just one solution.  However, if the business utilizes the host to manage all the desktop applications and data, the cost-efficiency of the approach can increase dramatically.  Regardless of whether the business elects to continue to run software on local PCs, or if it decides to outsource IT to a host and run it there, the company will have to pay the price for software licensing.

Make sense?

J

Improving the Business of Art: Making Beautiful Business Decisions

There is a lot more to managing and maintaining an art collection than simply collecting.  In the art business, knowing where something came from, how it got to where it is now (and what it cost to get there), and keeping track of it thereafter requires software and systems to store and manage the information.  A professional art collection management solution will do much more than simply keep an inventory list of items.  This solution must store all the relevant information about the work as well as gather information while facilitating the various business processes relating to activities around the work. The first step to improvement is ensuring all the processes are being facilitated.

Acquiring the item, transporting the item, preparing the item, showing the item, maintaining the item, selling the item… all of these business activities performed must not just be accounted for, they must relate back to the work of art and become part of its historical record. Art tends to move around. Traveling from collector to collector or to different galleries, works of art may change location and ownership or custodial care frequently.  The origin of a work and the tracked purchase history, as well as the history of placements is among the critical information to be stored with each item. This most valuable data is part of the legacy of the work that any professional system should address. If information is power, then better retention and management of information regarding a work makes the entire collection stronger.

The location or exhibition of a work, its purchase history, the related museum and contact records – all this and more must be maintained and managed with each and every item in a collection.  Essential data such as provenance, condition and value is certainly kept for each work, but the key to making a truly useful system for collectors and artists both is the ability to get all the needed data in a single view or report.

Having the inventory information available for invoicing and reporting is one thing, but also being able to connect or identify individual works and collections with relevant contacts is surprisingly valuable. Tracking other information items like costs associated with shipping or framing, or storing both an appraised value as well as an insured value, provides for a comprehensive record of the work and its properties and makes forms and documents preparation not only more accurate but more efficient and useful, too.

Art businesses are like many other “product”-based businesses in that they have e-commerce needs, they build websites to show off their catalogue, they use mobile applications to display items, and they find much higher efficiency and agility when the websites and mobile applications work with the same real-time inventory data that the rest of the system works with.  The goal is to achieve measurable results through improved efficiencies, and that comes from improved information management and integrated systems.  Centralized computing models and connected cloud services establish the foundation.

Cloud hosting, remote access and mobile technologies, and location-based solutions are all part of the package for businesses involved in the business of art these days.  Implementing a hosting solution which enable anytime/anywhere access to business applications and information is often the first key to unlocking the better and more efficient art business.

Whether it is collecting, selling or showing, users involved in the business of art need secure access to all their information whether they’re in the office or not so they have the data needed to support making beautifully intelligent business decisions when it matters most. The rest is just pretty pictures.

Make Sense?

J

Hosting QuickBooks Desktop Editions – The Good and the Bad – Accountex Report

published on Sleeter.com blog, now Accountex Report, January 22, 2013. This is an oldie but a goodie… perhaps more relevant now than ever.

With the accounting industry moving towards cloud computing and fully online working models, users of Intuit QuickBooks desktop editions may believe that their best option is to migrate to a web-based edition of the software rather than continuing to use the version of QuickBooks they have come to rely on. While QuickBooks Online Edition may seem like the best option for anytime, anywhere access to financial applications and data, it might not provide the functionality or features that QuickBooks desktop edition users need. When the business needs the full capability of the desktop edition product, hosting that solution with an application hosting service provider may be the right answer.

“Hosting” QuickBooks desktop editions means that a hosting service provider installs and manages the QuickBooks software and the company data files on their own cloud-based servers. Users don’t have to install QuickBooks on their PC, because they use the Internet to connect to their QuickBooks software and company data hosted by the service provider. Whether the service is accessed by clicking on an icon on the local PC desktop or by logging in via a web page or portal, the underlying technology is still Windows and QuickBooks.

Continue reading Hosting QuickBooks Desktop Editions – The Good and the Bad – Accountex Report

check out MyQuickCloud for QuickBooks Remote Access and Managed Cloud Hosting