Direct vs. Indirect CSP: Which Plan is Right for You?

With so many businesses partially, if not fully, running on the Cloud, Microsoft’s new Cloud Service Provider (CSP) Program is an enticing offer, even for Microsoft’s most loyal Enterprise Agreement customers. Microsoft offers two CSP options for Microsoft partners who want to get on board, Indirect and Direct. But which of the choices is right for you? Today we’re pitting the two head to head. It’s Direct vs. Indirect CSP.

At MetrixData 360, we want you to transition to your new CSP situation as smoothly as possible and have helped our clients adjust to this new life in the clouds. So today we thought we’d share some of the differences between each of the platforms to help you determine which best fits with your organization.

Direct vs. Indirect CSP

What is Indirect CSP?

With Indirect CSP, the requirements are simple: you will be a reseller of Microsoft products to customers while maintaining a relationship with your indirect provider or distributor. The provider, in turn, will deal with Microsoft.

It is likely to be the far more popular option, as Microsoft expects somewhere between 80% to 90% of its CSP subscribers to become Indirect Partners. Let’s take a look at some of the highlights of being an Indirect CSP Reseller.

Added Services and Support from the Distributor

As a Reseller, your Distributor will provide you with a number of services and support, including:

  • Technical training and assistance.
  • Marketing products and services.
  • Financial and credit terms.
  • Microsoft’s API integration to help place incoming orders for Cloud licenses.
  • Help transitioning into a cloud model or, if you already are cloud-engaged, your distributor will help you grow your value with your customers such as having a pre-sales consultant joining you on complicated deals.

This arrangement will prove most ideal for smaller organizations who will be able to reap the benefits of having their larger distributor’s resources at their disposal.

Profit Margin

As an Indirect CSP, you will buy your SKU from the distributor and you will be allowed to sell your products to your customers with a margin of profit of your choosing. It should also be taken into consideration that Indirect Resellers can expect recurring revenue as Microsoft moves its market exclusively to the Cloud. While Cloud-only products are their inevitable business plan, Microsoft doesn’t have the staff to fully support this kind of infrastructure, which is where this CSP has come from. It will be the foundation of a budding cloud reselling ecosystem and this is your chance to be a part of that.

Quick and Yet Controlled Process

You can get started quickly with the Indirect CSP partner program and once you’re there, you can evolve your business at a controlled pace, allowing you to focus primarily on your investments. The indirect CSP model will allow you to team up with a larger and more experienced provider while at the same time owning the customer relationship and experience. Considering the few qualifications you need to get started, this represents a relatively low investment for a high return.

Status

Through being an Indirect Reseller, you will begin to earn incentives straight from Microsoft. You will also receive the Partner of Record Status (POR), and you’ll also receive revenue recognition to be put towards your Microsoft Partner Status. This status and recognition will be on par with that of the Direct CSP model.

What Is a Direct CSP?

Unlike with Indirect CSP, in this model you will act as a Distributor, who will deal directly with Microsoft while also maintaining a relationship with your Resellers. This model is best suited for larger and more mature companies who have expertise in customer service. Below are some of the things you’ll have to consider if being a Direct CSP seems like a good fit for you.

Margin and Investment

Distributors can create a margin of profit for Microsoft’s product, sometimes as high as 20%. However, becoming a Direct Partner will require some level of investment, ranging anywhere from $50K to over $1M in investments.

Complicated Process

If you are going solo as a Direct CSP partner, the process can be quite rigorous and complicated, often taking as long as four months. In order to qualify for being a Direct CSP partner, you need to meet the following requirements:

  • You need to be an active Microsoft Partner with a Network ID.
  • You will need to be capable of providing your customers with 24-hour service.
  • You’ll need to purchase a Microsoft support plan and you’ll need to be able to pass a credit check before you can purchase the plan.
  • You’ll need to have at least one managed service already, an IP service, or a customer solution application.
  • You need to have a solid customer billing structure in place. Manual billing will not cut it.
  • You’ll need to maintain at least one Microsoft Gold Productivity Competency.
  • As a Direct CSP Distributor, you’ll be expected to manually manage your licenses through the Microsoft Partner Network Center.

Proactive Reductions

Before you begin the long process of applying to Direct CSP, it’s important to note that in most markets Microsoft is actively striving to reduce their number of existing Direct Partners instead of approving more. Although Microsoft recognizes both partner models and provides revenue recognition that is weighted the same, it may be very difficult to become a Direct CSP partner with Microsoft.

Looking for an opportunity to save roughly 20 to30% of your current spend on software licensing? Learn how software asset management can help in our article: Getting Started: Implementing Software Asset Management.

Choose the Right Solution for Your Business

Signing up for Microsoft’s CSP Partner Program can represent a new chapter in the growth of your business. Picking which one is right for you will prevent you from biting off more than you can chew and will allow you to benefit from this new solution.

At MetrixData 360, we have helped our clients through the trickiest of positions in regards to their software licensing when it comes to Microsoft and we can help you transition to this new CSP platform smoothly. If you’d like more information, you can contact us and a Client Success Manager will be in contact with you in under 24 hours.

Licensing a Disaster Recovery Environment in Oracle

Nothing calls for disaster recovery (DR) more than 2020, which makes this the perfect time to consider disaster recovery environments.

However, when it comes to Oracle, it can be tricky to figure out what your contracts allow you to do when it comes to creating a proper DR environment for even the stickiest of situations.

The last thing you want is to run up against compliance issues with Oracle, who is known for their brutal software audits, especially in matters of disaster recovery. At MetrixData 360, we are experts in both managing our client’s compliance issues as they arise and proactively ensuring they never occur again.

Here’s what our Software Asset Management Experts have to say about how to properly license your DR environments.

What is a Disaster Recovery Environment?

Every business has mission-critical information they need to protect and keep accessible at all times. This is why every business should have some form of disaster recovery in place. Disaster recovery is a method of security planning with the goal of protecting that data from any significant negative events.

Common types of disaster scenarios are as follows:

  • Application Failure:

    Commonly seen as a result of hardware or software configuration. DR solutions around this scenario involve application backups or active-to-active failovers.
  • Network Failure:

    When you have a full or partial Cloud environment, losing connection to this environment could be the result of power outages or performance issues. DR solutions for this scenario involve strengthening the connection to the organization’s network or creating multiple access points to the network in order to create sufficient redundancies.
  • Data Center Failure:

    Often seen as a result of mass power outages or natural disasters, which results in the loss of connection to whole data centers or domains. Creating a DR solution for this event involves potentially deploying applications across multiple domains if you have them.
  • Region Fail:

    Most likely the result of the most severe disasters, when whole regions lose either power or connection of their network. To protect against this event, you can deploy your workload over multiple Oracle Cloud infrastructures in a variety of regions.

It is the IT department’s job to ensure that this protected data is constantly updated, maintained, and easy to access, so that the organization can continue to run as normally as possible under the circumstances. Although smaller industries may be hesitant to invest in funding for a situation that has yet to occur, it is usually better to be safe than sorry.

While Disaster Recovery as a whole involves many different working elements including a DR plan, personnel, actions for dealing with financial and legal issues etc., this blog post will only be focusing on how to license the Disaster Recovery environments that organizations have built.

How to License a Disaster Recovery Environment

Since your DR environment is only used when disaster strikes, your organization (hopefully) does not have to use it constantly, in which case it may feel like you don’t have to license the environment. However, to assess whether your DR environment needs to be licensed, consider the following:

  • Check Your License Agreement and the General Terms:

    All the rules that you need to adhere to can be found in your licensing agreement, or your Oracle Master Agreement (OMA) if you have one, and any other documents that the agreement refers to.   There may be versions of basic contracts online, but these might be out of date and may not accommodate for any unique licensing metric you may have. For instance, some companies have a licensing metric based on your company’s annual revenue or the number of employees that you have. If there is any language in the contract that is ambiguous, you should seek out clarification from your Oracle rep.
  • Remote Mirroring:

    With Remote Mirroring, your data is stored in an identical storage unit or shared disk array in a dispersed location through the use of solutions like Veritas Volume Replicator, EMC SRDF, Legato Relator, and EMS StorageEdge. In this instance, both the mirrored database and the unit its replicating will need the same licenses.
  • Standby:

    With Standby, copies of the primary database are maintained on standby servers, which are dispersed geographically and any changes or updates the primary server experiences is replicated in the standby databases. In this situation, both the standby and the primary databases need to be fully licensed using the same metric.
  • Backups:

    Backups refer to a copy of a physical database structure. In the event of the loss of the original data, the backup files will be used to reconstruct the lost information. This copy may include critical elements of the database’s physical structure like control and data files and redo logs and can be stored either on a server, a storage array, a disk drive etc. Oracle will allow you to keep these copies in a storage device without needing to purchase a license but when the disaster occurs, and the data is taken from storage and installed onto the recovery server, you’ll need a license.
  • Your Oracle Licenses Match:

    It’s important to make sure that your DR servers have the same licensing metric (Processor or Named User Plus) as the primary server that it is supporting. DRs and their primary servers must also have matching database options and packs. When it comes to this coordination, you’ll find that Oracle is particularly unyielding and so it is important that any mismatching licensing is addressed before you are confronted with it during an audit.

Situations Where Licensing Isn’t Required for Disaster Recovery

While typically Oracle requires you to license any and all environments where their software is present, there are a few exceptions to the rule.

  • Failovers:

    A failover is where a database that is running on a primary server can be moved to a secondary server in the event that the primary fails. Oracle will allow a database to be run on this unlicensed secondary server for 10 days.   This scenario is allowed when both the primary and the secondary servers exist within a single cluster and share a single disk array or storage device. In this scenario only the failover server is free and once the primary server has been repaired, the database is required to switch back to the primary server. It’s also important to note that Oracle does not equate one day to 24 hours scattered over a long period of time. If the failover server is active for an hour one day and two hours another day, that counts for two days. You are only allowed to have one free failover node per cluster for up to ten separate days even if you have multiple nodes configured as failovers. This scenario also does not apply to VMware environments. If you would like to license your failover environments, you’ll need matching licenses to the databases the failovers will be supporting.
  • Testing:

    Oracle’s customers are allowed to use tape and disk backups of databases for the purpose of recreating that database for the use of testing. You can run this duplicated database on an unlicensed server four times per year, with a time restriction of two days for each test, at which time the database must either be removed from the server or will be considered licensable in the eyes of Oracle.

Be Ready for Anything with Properly Licensed Disaster Recovery

It’s always better to be prepared, whether that is getting your software environment ready for a natural disaster or making sure your licenses are orderly in the event of a software audit from Oracle.

It would be a terrible situation to discover that the very thing that was supposed to be there to keep your business afloat could cost you a staggering amount in compliance gap thanks to under licensed servers.

At MetrixData 360, our goal is to ensure you only pay for what you need to and to fight for your best interests when you go up against Oracle. If you’d like to know more about what our services entail when it comes to your Oracle Licensing, you can check out our Contract Negotiation page for more information.

Data Lakes and How They Can Help with SAM

“Where do we store our data?”

It’s a question that comes up constantly in the tech world and serves as a fundamental pillar of the software infrastructure of organizations everywhere. The way that data is stored, the speed with which it can be accessed, and the way with which it is protected are all critical for businesses to function properly. Data lakes are the newest means of storing data, but how does it work? Are they right for you? And, is there a way they can actually help you with software asset management?

At MetrixData 360, we have found that data lakes can be particularly useful in our efforts to wrangle our client’s software environment into order.

What is a Data Lake?

For a long time, data was stored in warehouses, a familiar term for the veterans of the tech industry. While it may be easy to assume that a data lake is just the newer version of the data warehouse, there are a few distinct differences.

A data lake can be thought of similarly to real-life lake water. The data gathered in a data lake might stream in from a variety of sources, accepting and retaining data from all sources, types, and schemas.

This data may not be formatted in any way, with no hierarchy or organization to speak of, instead it is in its rawest form, neither processed or analysed. This allows businesses to apply the scheme and organization model that best fits the nature of the data that data lake houses, often proving both its greatest strength and its biggest drawback.

How a Data Lake Works

The sheer volume of data that companies have can be overwhelming and traditional data management isn’t equipped to handle big data or its analysis. Data warehouses are designed much like their namesake, with rows and columns of organized data. While this provides limitations like lack of flexibility and the requirement to standardize all data that is stored in these warehouses, they do allow for quicker operations.

In contrast, data lakes are commonly built using either Hadoop or through the use of Infrastructure as a Service (IaaS). Both AWS and Azure offer data lake architectures to store and analyze current data.

Data lakes provide their structure through one or two methods:

  • Metadata stores
  • Self-describing data formats

Why is a Data Lake Needed?

If you’re working on a big data project, you’ll need to know what data you’ll need to reach your desired outcome and you’ll also need to get your hands on the right data to analyze and leverage to better achieve those outcomes.

One of the major benefits of data lakes is their ability to provide cheap scalability, allowing you to keep large quantities of data for a good price. Data lakes can allow you to draw from a variety of data, and in turn store any data you wish on the data lake and create unlimited ways to query in search for data, providing you with tremendous flexibility. The use of data lakes can help break down data silos and allow for a unified view of data across your organization.

Data Lakes and Software Asset Management

Data lakes can prove quite useful in assisting efforts surrounding software asset management if executed correctly. Auditors don’t typically look to data lakes when conducting a software audit at the moment. We suspect they will become a target of scrutiny in the future, as their use becomes more sophisticated and wide-spread.

A good example of when these data lakes might be accessed is in regards to hybrid use benefits in Azure, which allows you to bring your own on-prem licenses to Azure at a discounted rate.

Technically speaking, there would be nothing stopping your company from using hybrid benefits to deploy software on Azure while still having it installed on-prem, and Microsoft is currently turning a blind eye to this loophole, trusting that you’ll respect your arrangement.

However, with the rough year 2020 has proven for everyone (except Zoom), Microsoft may be eager to make up losses by conducting audits in new areas. This is why it is also best to understand how the data stored in these data lakes can be used to your advantage.

Data lakes can help you hunt down Shadow IT and they can prove to be an excellent resource in the event of an audit. This is because they can often provide missing data such as VM guest to host relationships, processors, cores, perhaps even unique details about your software environment.

They can also be used as a means of tracking cloud usage and cross-referencing other data sources. In order to use your data lakes to serve your SAM goals, you’ll need to make sure the data is accurate and complete, you can do so by considering the following:

 
  • Cross Reference Data Lake Resources with that of Your Active Directory:

    Your AD is one of the first areas that will be consulted in the event of a software audit. Within a company, the AD is often disorganized and is far from an accurate picture of your whole environment. Which is what our Active Directory Reporting Tool is for, allowing you to create an easy to understand chart of assets within your AD. For more information you can check out our AD reporting tool, here.
  •  
  • Compare with Your Inventory Tools such as ServiceNow CMDB:

    SAM tools often provide the basis of a company’s software asset management solutions and are often used during a software audit, they fail to provide an accurate picture of your data. For this reason, it is important that you verify their accuracy.

Get Your Data Lakes to Serve Your Goals

Data lakes are an excellent way to keep your resources stored and organized. It’s important to be aware of how data lakes can potentially help your organization remain in compliance with software vendors and keep your software infrastructure organized by assisting in software asset management.

Software Asset Management in and of itself is a great way to allow your organization to discover an estimated 20% to 30% of savings pulled out of their current IT spend through simply cutting out unnecessary licensing and making sure that costly fines and unbudgeted spending are avoided.

If you’d like to learn more about how Software Asset Management can benefit your company, you can check out Software Asset Management for Beginners.

Pros and Cons of Power BI

Microsoft’s budding new thought child is Power BI and although Microsoft is quick to sing its praises, what sort of tangible benefits does it hold for you and your company? There’s no point jumping on this Power BI band wagon if it doesn’t match your business goals and needs. At MetrixData360, we believe in educating our customers and making sure that they are only buying the software licenses that they need, and not what the sales rep says they want. So today, we’ll go over everything you need to know to make sure Power BI is the right investment for your company.

What is Power BI?

Officially released in 2015, Power BI is an umbrella term used to describe a number of data collection apps that is offered by Microsoft for the purpose of analyzing and visualizing raw data. Praised by Gartner for its exceptional analytics and business intelligent platforms, Power BI has come to be known as a business essential tool for customers of all sizes and every industry, from construction to finance to insurance. The apps that comprise the interwoven matrix of Power BI include:

 

  • Power Pivot: Allows you to import data from a variety of sources
  • Power Query: Allows you to transform data
  • Power View: Helps you to visualize the data that has been compiled
  • Power Map: A nice 3D feature that can create a better visualization of the data
  • Power Q&A: An engine for question/answer style interactions with your data

 

Together, with all these interweaving parts, Power BI customers can perform such demanding tasks like examining what-if scenarios, conveying business models in an easy to read format, and forecasting business requirements.

Pros of Power BI

Affordable

You don’t have to worry about breaking the bank when you sign up for Power BI, as Power BI even has free alternatives such as the Power BI Desktop which can be downloaded to create interactive reports. However, these free versions are quite simplistic and limited when compared to Power BI’s true processing potential, that performance capability is saved for the paid versions. Pricier models like Power BI Pro allow users to share data and dashboards and Power BI premium allows for much deeper and meaningful insights, as well as on-prem reporting. If you already have an Office 365 plan, you may have Power BI as an added feature at no additional cost. Want to know how Power BI relates to SQL Server Licensing? Check out our article: SQL Server Licensing Explained for more information.

Customizable

If you have a very specific look you’d like to achieve, then Power BI can make it happen, offering a variety of custom visualizations, available in the Microsoft marketplace in addition to general visualizations used for polishing up reports and dashboards.

Excel-User Friendly

You have the option of uploading and viewing your data in Excel if that’s your thing. Power BI is built using the same interface as Excel, so if you know your way around an Excel spreadsheet, then you’ll find using Power BI to be both easy and familiar. Even if you aren’t exactly an Excel wizard, Microsoft has a wide array of tutorials, blog posts, and other available learning resources to assist you up this learning curve. There’s also a budding community of Power BI experts you can turn to if you need an extra helping hand.

Cons of Power BI

Difficult to Use

Despite the wide array of resources available, Microsoft is known for its hyper complexity when it comes to their software and Power BI is no exception. Since Power BI is merely a collection of apps, that means to properly maintain Power BI and get it to create the reports your looking for, it will require learning what each item in Power BI’s ensemble does and how it relates to the rest of the structure. This also means if Power BI isn’t working, you’ll have to go through the task of figuring out which app is broken and why.

Not Very Versatile

The expression language that Power BI uses is DAX , which is not known for being the easiest language to work with or master, once again adding to the learning curve. When compared to its competitor Tableau, Power BI is often viewed by customers as less flexible due to the fact that at the end of the day it is designed mainly for visualization purposes. Customers need to be careful to account for unique fields that can create inaccurate graphics and tables.

Large Data Sets Cause Lags

There is a cap for the digestible material that Power BI can handle at any given time, especially if you only have the free version at your disposal. If your business is on the smaller side, this limited space may not be an issue, and even such problems may be counteracted with a few space saving techniques such as writing simpler queries or splitting the queries into several different components. If you want to expand your Power BI capacity, you’ll have to upgrade to a pricier model.

Conclusion

Power BI has become an excellent and essential tool for many companies but just because it is the popular option doesn’t mean its necessarily the option that will best suit your business needs. At MetrixData 360, we teach that you should buy based on the data, based on what you know you need and not on what you think you want. Which of course, is where software asset management comes in. SAM is an excellent way of gaining control over your delicate software infrastructure by knowing what you have, what you need to license, and whether you are using your software in accordance to the licenses that you have. If you’d like to know more about what SAM is and how it can save you money, you can check out our article: Software Asset Management: Its Importance, Purpose, and How it Saves Money.

    Getting Ready to Certify Your ULA

    Oracle’s ULA: Ready to Leave or Willing to Stay?
    Consequences of Both

    When your company is in an Oracle Unlimited License Agreement (ULA), the deal is that you hand over a single up-front payment and you get access to the licenses for a select set of Oracle products. With the volatile market, you may be asking if you should certify your ULA, and what it takes to complete an Oracle ULA Certification?

    Of those select products, you can order an unlimited number of licenses for a set period of time, either three years or five years. The only costs in between renewals are the maintenance fees, which are 25% of the cost of the license. There are many reasons an organization would find this set up appealing:

    • It provides predictability in terms of costs, giving organizations the opportunity to plan for that expense.
    • It’s ideal for heavy users of Oracle products.
    • It puts a wide variety of products on a single payment, making the process of purchasing licenses that much easier.
    • The risks of having your ULA audited are minor.
    • It is sometimes purchased for the preparation of a large, long term project to accommodate potential growth.

    Despite these advantages, the ULA can also be restrictive or even a trap for your company. Organizations might get into a ULA with the best intentions and end up staying in one simply because it’s easier to renew than to leave.

    There may come a point where the maintenance fees no longer make the ULA a suitable option and you think about getting out of the agreement.

    What does this shift look like?

    At MetrixData 360, we have been working through tricky licensing agreements with Oracle for many years and we want you to know what you can expect and how you can prepare.

    Why Certify Your ULA?

    COVID

    Signing up for a three-year business plan is a great strategy for times of stability and predictability. However, COVID-19 mixed with its following recession and the threat of a second or third wave means that flexibility and the ability to roll with the punches will be a critical element to future business plans. This is something that the rigid structure of the ULA doesn’t provide.

    Freedom

    Freedom: Flexibility has become essential as our world is rocked by constant uncertainty but also when it comes to the constant shift of technology. The ULA is rather rigid in the products you can pick from, and if new products are released that would fit your organization better, you wouldn’t be able to simply add it to your ULA. When you are in your ULA, you will also experience pressure from Oracle towards products that don’t fit your needs but suit their agenda. ULA customers often experience pressure to move to Oracle’s Cloud products, for instance. You will also find that trying to negotiate the price and products of your ULA is particularly difficult. Getting out of the ULA, even temporarily, will give you the freedom to explore your alternatives.

    Cut Potential Costs

    Few businesses have gotten out of the pandemic unscathed and many people’s top priority is to pinch pennies for short term cash flow and avoid costs wherever possible. Extending your ULA can often be more costly than simply certifying out, especially when you take into account the fact that support costs can add up over time. This rising expense comes with no added value, Oracle is simply increasing the prices on products you may not even be using because they know you are chained to your chair. If you certify out now, you can also simply sign up for another ULA later when things are more stable.

    ULA and Audit Risks

    Staying with the ULA

    Oracle hasn’t been faring very well during 2020, as their Q4 report for 2020 has revealed with its release in mid-June. It doesn’t help that May, which was traditionally Oracle’s most lucrative month, was also the worst month of the pandemic.

    Oracle is currently faced with record low numbers and many customers are worried this will result in more audits. It certainly won’t result in fewer audits.

    While the products within your ULA might be safe, the products that are not a part of your ULA will be targeted. Since you have a ULA, members of your organization could have easily gotten mixed up about which products are covered under the ULA and which are not, meaning that you may be targeted for unlicensed products thinking that they were safe under the ULA.

    Certifying Your ULA

    When it comes to their ULA users, Oracle tends to be rather lenient and leaves you to your own devices (pun intended). You’re left in charge of keeping track of your own licenses and Oracle rarely bothers to check up on you.

    Many organizations, as a result, tend to lose track of their deployments. Employees will install Oracle products after having been granted little or no authorization, resulting in sprawl and shadow IT.

    As a result, when you are certifying out of your ULA and it comes time to declare how many licenses you have, Oracle will suspect that your declared number is little more than a guess. After losing the ensured revenue from your ULA, Oracle will happily make up for the losses by checking the state of your sprawl for potential compliance gaps.

    At the end of the audit, they might even propose you renew your ULA instead of paying for the compliance gap they find. In other words, once you certify out of your ULA, it’s safe to assume an audit will be coming your way in 6 to 18 months.

    What Do You Need To Do Before You Certify Your ULA?

    Before you get excited and drop the news on Oracle that you’re letting them go, you’ll need to make sure you have everything ready for your departure.

    1. Plan Your Exit

    It’s best that you start preparing for your exit well ahead of time, at least 12 months before your ULA is up for renewal. There’s nothing in your contract that says you can’t hand in your certification for your ULA much sooner than the expiration date, and the last thing you want to do is run past the due date and be forced to renew.

    2. Understand How You Certify Out

    The certification process itself is quite simple. You merely need to write a letter signed by a C-level executive of your company, complete with the number of licenses you are certifying, and it needs to be submitted within 30 days of your ULA’s expiration. Finding those numbers, on the other hand, will be easier said than done.

    3. Tell Your Team You Are Certifying Out

    Communication between departments is not always top priority in large organizations. It’s important you convey that you are getting out of Oracle’s ULA to any employees who might install Oracle products with the same carefree attitude they expressed while the ULA was still in place.

    4. Take Inventory and Perform a Self Audit

    This will be the quickest way to decide whether certifying out is the best thing for your business right now. It will keep you from having to guess your usage and exactly how much you’ll save by leaving your ULA.

    A self-audit will also ensure that you are compliant with any contracts you have with Oracle, and that the licenses you will be declaring are accurate. Now is the time to chase after any unknown information in regard to sprawl or shadow IT that may have cropped up under your ULA.

    This is important to do before you certify out in order to maintain control over the certification process.

    Oracle may want to take the lead by offering to certify you and it’s important you don’t let them. This will give them control over a process that they didn’t want to happen in the first place, and they will take as long as they wish.

    Get Control Over Your Software Spend

    There’s no need to keep a toxic relationship going if all your partner does is take and take, and it’s the same with your Oracle ULA.

    Perhaps at one point it served your company well but if the agreement has grown old and stale in your mouth then you should have the freedom to leave and explore your options, lest you be stuck paying for a ULA that is simply a waste of money.

    At MetrixData 360, we have your back throughout every step of this process. We can help you conduct a self-audit to create an accurate depiction of your deployment and usage, we know how to talk to Oracle so that you don’t feel pressured throughout these seemingly one-sided negotiations. We will teach you how to keep your head above water in the event of an Oracle audit.

    If you would like more information on how MetrixData 360 can help you through an Oracle ULA Certification, you can visit our Audit Defense page.

    Tips for Surviving a Microsoft EA True Up

    Tricks for your Microsoft EA True Up

    If you have an Enterprise Agreement (EA) with Microsoft, then you are probably familiar with the EA’s annual True-Up. It’s a straightforward way of condensing a year’s worth of headaches and frustrations around purchasing software licenses into a short period of only 90 days (although hopefully, you’re preparing earlier than that!).

    Since these true ups amount to such a large investment for enterprises, it is important that you remain in control of the situation and know what you can and can’t do. Often companies can feel trapped or chained to their chairs in these agreements but with MetrixData 360, we have helped many clients truly harness the potential of their EA. We’ve helped our enterprise clients cut down wastage in their EAs (sometimes hundreds of thousands of dollars have been removed from EA agreements), and we know how to dance this dance with Microsoft.
    So in this blog post, we will share some tricks from our experts.

    And don’t forget. At any point in reading this article, you would like some further explanation, check out our downloadable EA True Up Guide below:




    Tricks for your Microsoft EA True Up

    If you have an Enterprise Agreement (EA) with Microsoft, then you are probably familiar with the EA’s annual True-Up. It’s a straightforward way of condensing a year’s worth of headaches and frustrations around purchasing software licenses into a short period of only 90 days (although hopefully, you’re preparing earlier than that!).

    Since these true ups amount to such a large investment for enterprises, it is important that you remain in control of the situation and know what you can and can’t do. Often companies can feel trapped or chained to their chairs in these agreements but with MetrixData 360, we have helped many clients truly harness the potential of their EA. We’ve helped our enterprise clients cut down wastage in their EAs (sometimes hundreds of thousands of dollars have been removed from EA agreements), and we know how to dance this dance with Microsoft.
    So in this blog post, we will share some tricks from our experts.

    And don’t forget. At any point in reading this article, you would like some further explanation, check out our downloadable EA True Up guide below:

    You Don’t Need to Fill Out Every True-Up Form that Comes Your Way

    If you have a reseller supporting you with your EA, then you may receive True-Up forms quite frequently — some of our clients report that they receive them on a monthly basis. You might feel compelled to fill each one of them out, either because your reseller encourages you to do so, and they know best, or because you’d rather not go up against Microsoft. However, unlike your annual True-Up, which will require a mandatory Update Statement (even if you haven’t added to your counts this year), these monthly True-Up forms are completely optional features that you don’t have to fill out.

    You Can True-Down to your Original Count…Or Zero!

    If this is not your first True-Up, you likely noticed that adding counts to your EA is easy – encouraged even – however, it can be very difficult to true-down or reduce your counts in any way. While it may be difficult, it is not impossible if you are following these steps:

    Know Your Data

    The first step of Truing-Down is to know what you are truing down to.
    There are many ways to check your counts:

    • in your Active Directory;
    • in your SCCM or your SAM Tool (only useful if you’re trying to find your Qualified Device Count); or
    • in your HR Systems and Email Accounts (only useful for finding your Qualified User Counts).

    You can also guess based on your number of employees, but while this is something most companies are forced to resort to, this is not something MetrixData 360 advises.

    Create a Value Gap

    Knowing your data will also allow you to create a Value Gap, and build your argument for truing down based upon cold, hard data. At MetrixData 360, we have built our tools for this task, which can significantly cut down your workload and your guessing.

    Start Preparing for Your Microsoft EA True Up Early

    You can True-Up pretty much up to the last second, but if you want to True Down, you will have to be prepared well ahead of time and adhere to the deadlines outlined in your agreement. Microsoft will only let you reduce your counts up until 30 days before your True-Up date, so you will have to be ready with your data and your arguments for Truing Down long before then.

    Check Your Original Counts

    When you are trying to reduce your counts in your EA, there are two things that really prove to be determining factors on how low you can go: if the product is an enterprise-wide purchase and if it is a subscription or a perpetual license.

    If you have an enterprise-wide purchase, the only way Microsoft will allow you to reduce your counts is by scaling back online service subscriptions down to their original number that you started with. For example, if your original EA asked for 500 subscriptions and the following year you grew to 1,000, the lowest you can reduce your count to is 500. However, if your purchase is not enterprise-wide, it is possible to reduce the counts, so long as the minimum requirements are maintained.

    Check Additional Products that are Available as Subscription Licenses

    There are a few different products which are included in the EA, such as Enterprise Products, Enterprise Online Services, Additional Products, Additional Products Online Services. Additional Products that have subscriptions can be reduced to a count of zero! We’ve pulled such a move before at MetrixData 360, which resulted in our client saving $800,000!

    Watch Out for Complicated Products

    While Microsoft may have products that are easy to use, there are, of course, the challenging ones that are difficult to wrap your head around, let alone manage. Make sure to pay close attention to your deployment data around these products, ensuring that you have a strong understanding of your contract’s language and deployment data. Some of Microsoft’s more complicated products include:

    At MetrixData 360, we put extensive effort into understanding both products and have a wide collection of material to read and tools to assist you in gaining a strong handle on these two products in your software environment.

    Need Help Getting Ready for Your True-Up?

    With your True-Up approaching, it’s important to have a few tricks up your sleeve. Closing such deals could mean the difference between optimizing your spending and spending copious amounts of money that you don’t need to.

    The Microsoft reps may be nice, but there is only so much that they will be willing to help you save when their job is to make sure you do exactly the opposite. That is why you need someone who can support you and have your back during this engagement.

    MetrixData 360 is here for you. We have many Fortune 500 customers who we have helped to minimize the impact of their EA on their software budget.

    If you would like to learn more about getting ready for your Microsoft True-Up, you can download our free booklet, Preparing for a Microsoft True-Up.

    Properly Sizing Azure for Your Organization

    The Many Complexities of Azure Cloud Sizing

    Moving to Microsoft’s Azure can be an exciting experience, with so many services including File Storage and Machine Learning Analytics, SQL Databases, and Data Transfer, to name just a few. With so many infrastructure options in one place, moving to the cloud is becoming the obvious option for IT departments. Correctly sizing Azure is a vital first step to maintaining your IT budget. It’s like getting a new pair of shoes; you don’t want to waddle around in clown shoes, but you also will need something that doesn’t pinch your toes.

    Unfortunately, Azure is a large and complex system, meaning correctly sizing for your organization’s needs is no simple task. At MetrixData 360, we have provided our expert advice to many companies hoping to gain insights into how best to size their Azure environment. As a result, we have helped them maximize value from their Azure purchase. In this article, we’ll go through everything you need to think about when purchasing the right Azure size for you.

    Different Azure Sizes for Your Virtual Machines

    Microsoft has 11 different Azure Series available, from the entry-level A-Series to the far more robust N-Series. Within each series, there are also multiple sizes of virtual machines (VMs) available, pushing the number of offered virtual machine options into the hundreds. Some of these options types include:

    • General purpose (ideal for testing and development)
    • Compute Optimized (great high CPU-to-memory ratio, only available in Fsv2)
    • Memory Optimized
    • Storage optimized (only available in Lsv2)
    • GPU (Graphics Processing Unit) Optimized
    • High Performance Compute

    Each option comes with a variety of different sizes and different pricing metrics. In such a complex environment, how are you supposed to know how to properly size your organization’s needs when moving to Azure?

    That is where we come into the picture. We understand the complex nature of Azure and their licensing structure. With our custom-built tool set, we can accurately determine your sizing and computing needs, ensuring your IT department avoids over-licensing fees, costly true-ups, or being under-equipped. By collecting the most accurate data we can from your environment, our specialists are able to make well informed decisions regarding your needs. Microsoft has provided a basic Azure Pricing calculator of their own, though it is a convoluted tool to use.

    Provisioning Virtual Machines

    While finding the perfect Azure size is critical for your cost saving efforts, Microsoft’s unique way of calculating cost can make it difficult to size correctly, thanks to a little something Microsoft calls ‘provisioning’. Provisioning refers to a payment method where you pay based on a fixed capacity. This capacity could refer to memory capacity, bandwidth capacity or any other type of capacity. This capacity doesn’t reflect actual usage but instead is merely a fixed amount of space that you are paying for at any given moment, provisioning for less than you actually use could lead to your VMs struggling to cope with their tasks. This fixed capacity also doesn’t account for the changes in demand over a given year. However, it is more likely that you will pay for more than you use, which means you are wasting money on things you don’t use.

    Determining When to Puchase Reserved Instances

    Strategic purchases of Microsoft’s Azure Reserved Instances (RI) can provide you with great discounts compared to the pay-as-you-go model – 36-47% cheaper for a one-year term; 60-72% cheaper if you sign up for a three year term; and potentially up to 80% cheaper if you combined it with the Hybrid Benefit. The fact that you can pay either a single upfront payment or monthly payments also offers a simpler solution when you are trying to budget your IT expenses. The process of purchasing your RI is as easy as selecting your Azure region, the virtual machine type, or how long you’d like your term to be (one year or three years) and you’re good to go. It is easy to exchange and cancel your reserved instances as you choose. However, it is important to note that a Reserved Instance is not an actual instance, it’s more like a coupon you can use when your instances are billed. Microsoft gets a guarantee in your business, and you get a discount. There are, however, still some drawbacks to purchasing reserved instances:

    • You’re locked in with the payment system once you’re signed up for it, and a lot of the costs, if not all of them, are upfront.
    • It’s not as easy to scale up or down compared to the Pay-as-You-Go system.

    Thinking about your Move to Azure?

    While significant changes to any department can cause a struggle, the same goes for the transition into Azure’s environment. Employees will have to be trained on managing the new platform and there needs to be management of both your on-prem and Azure assets. It may even be a smart idea to hire someone to look after your Azure platform.

    At MetrixData 360, we provide our clients with the knowledge and the tools they need to manage their transition to the Azure’s platform successfully, which is why we have made a whole guidebook around the subject. If you would like to learn more about Azure, you can download our guide to Azure Licensing here.

    Understanding Software Contracts

    How to Go Through Your Software Contracts Before a Negotiation

    You’ve been handed a software contract in the wake of a negotiation with your software vendor, and it’s an inch thick with tiny font and a lot of words you’ll need a dictionary to look up. Now what? How can you tell if there are any saving opportunities that can be utilized in this agreement? Or (in the case of a software audit) how can you tell if you’re as far outside of compliance as the auditors say you are? The answer lies in understanding software contracts and how they function.

    The preparation right before conducting software negotiations is a very important step that shouldn’t be taken lightly. Even if you have a strong relationship with your vendor, you need to ensure that you’re not placing the fate of your software environment into their hands. No matter how nice they are, their goal is to have you buy more licenses, regardless of what is best for you. Don’t rely on the software vendor to tell you what you need, only you can do that. So, how do you scan your contract to see if there is room for savings? To the untrained eye, it can seem like a daunting task consisting of hours on hours of mindlessly flipping through seemingly useless information. If you know what you are looking for and depending on how organized your software environment is, it may only take you an afternoon.

    At MetrixData 360, we have ripped into contracts that we’ve never laid eyes on before and have been able to pull out hundreds of thousands of dollars in savings. So, in this blog post, we’ll show you some of our methods.

    Details, Goals, and Additional Documents

    When reviewing your contract, take the time to highlight any date or specific numbers (when does this contract begin? If you have a discount, how much is it for and how long will that discount last? etc.). Next, make sure that you have at least a basic understanding of what your contract is trying to accomplish. Is it a new count to your software environment? Are you trying to reduce the licenses? What will you have after the license is enacted as far as new software licenses? Are there any additional documents that you need to have with you to fully understand the document, such as a Product Use Terms document. Knowing what you’re looking at and the details surrounding it will be the foundation of your understanding.

    Related: Dealing with a specific Microsoft software contract? Check out our articles for more tailored details: Microsoft SPLA Contracts Explained and Getting Ready for a Microsoft True-Up

    Check Your Software Contract for Fees and Additional Expenses

    Now that you have the basic outline of the contract, what it is trying to do, and what other documents you’ll need to consult to understand it, the next thing to do is find any mentions of fees, costs, or price increases over time. Find anything relating to the schedule of payment; is the contract asking for a lump-sum payment or installments? If so, what will your annual payments look like? Make sure you have a clear distinction between your purchase of the software and any payments needed to maintain the software. Make sure you consider all these additional costs to the software, as sometimes the software vendors can add on additional fees that make the overall product cost more than it’s worth.

    However, it’s important to remember that your goal is to cut costs, not to shoot yourself in the foot and take away from value through undermining services. Maintenance is a good example of this, since most software companies charge 20% for maintenance which means over the course of five years, you can very easily end up paying for the software twice. Maintenance is the bread and butter for software companies, so they will be keen for you to simply passively renew your maintenance, but it is important you challenge this to weigh costs against benefits.

    Look up the Definitions

    Your goal is to reduce what you don’t need but before you can do that, you will need to examine the definitions of the contract since this entire process may involve a lot of slogging through the intricate and confusing language of the software contracts. Just remember though, you’re not looking at this from a legal perspective, so there are whole paragraphs in this contract that will be of little value to you. While it might be useful to know definitions like ‘Confidential Information’, and ‘Documentation’; and paragraphs like ‘Representatives/Services’, it doesn’t serve the purpose of this exercise, so it will just be extra homework for you. What you’re looking for is anything to do with:

    • How you count your licenses
    • How you pay
    • When you pay
    • What you pay

     

    So, terms like ‘System’, ‘User,’ ‘Disaster Recovery,’ ‘Dev/test licensing,’ and ‘Invocation’; and paragraphs like ‘License Fee, Taxes and Expenses’, ‘Hardware’, ‘Master Software Support and Maintenance,’ and ‘Audit Rights/Compliance’ should be things that catch your eye. As you read, make note of any terms with similar definitions. For example, let’s say you notice ‘Web Users’ and ‘Occasional Users’ have strikingly similar definitions when it comes to the number of hours your users have to run the software and the privileges they need in order to qualify. If that is the case, investigate if it is cheaper to be considered a Web User or an Occasional User, and see if your company’s Users could be counted exclusively as the cheaper option.

    The good news is that within the contract you will find whole pages filled with nothing but legal jargon that you can just briefly skim over to see if you can find any words like ‘license’, ‘user’, or ‘price’. While the document may be over 50 pages, skimming in this high manner should result in you spending maybe an hour reading.

    Consider Next Steps

    Alright, you’ve read through your contract and you’ve pulled out all the necessary information, so what do you do with it now? There are a few things that you can do with this data:

     

      • Compare Your Deployment Data:

        Now that you have a clear understanding of what you have and what you’re signed up for, compare it with what you have in your software licensing environment. You may find usage that doesn’t match what you’ve paid for; it may be either too high or too low. You may also notice a consistent pattern in the usage, for example maybe there is a spike in usage for the last half of the year and so you have purchased licenses to account for that spike, but you are paying all year round. Data patterns like this would suggest that investigating a licensing type to accommodate for this fluctuating usage (for our example, a subscription license would be perfect) would be well worth the effort.

     

      • Check Your Ammendments:

        Make sure you also consult any amendments your company has made to the contract in the relevant years. Just like with the definitions, you are looking for things revolving around payments and licenses, examples of relevant amendments would include increasing or decreasing licenses or maintenance. You will also want to look for any amendments that alter the definitions of the contract, especially if the definition is involved with users or licensing types.

     

      • Holes in Your Contracts:

        With all this careful scrutinizing and confusing legal jargon, you may find that you have questions that your contract doesn‘t answer. Is there a term missing? Are there grey areas around what you can and can’t do with this license? Are there True-ups and have they been clearly defined? Seek clarification in any areas where the rules are not laid out clearly. If you are in the middle of a software audit, grey areas might prove useful to you. Depending on the exact wording of the section in question, you may be able to make the case for ‘it’s open to interpretation and this is how we have interpreted this’.

     

    • Start Prepping for Your Negotiation:

      Now that your investigation has concluded, you can compile the information you need to conduct a successful contract negotiation. You understand your software contract, its amendments, its supporting documents, and you can point out any grey areas. You know what is deployed in your software licensing environment, you can see what you’re using and how it compares with what you’re paying for, which will allow you to spot cost-saving opportunities. Create a list of questions and talking points based on the facts. You can now focus your attention and budget on what you need instead of guiding yourself by guesswork and good intentions.

    Still Confused?

    It’s not like these contracts are the stuff you curl up with on a rainy Sunday afternoon to read with a cup of tea, but if you want to cut costs in your software environment, if you want to be prepared for an audit or a software contract negotiation, you’ll need to understand what makes your software contracts tick. At MetrixData 360, we provide our clients with all the heavy lifting when it comes to understanding their software contracts, we usually act as our client’s secret weapon, telling you what you need to say to the software vendors and how you need to say it. If you’d like to learn more about how MetrixData 360 can help you get the best software contracts for your company, you can check out our Contract Negotiation Page.

    SQL Server Licensing Explained

    SQL Server Licensing Explained

    SQL Servers are the most complicated, most expensive, and most critical element of an organization’s software infrastructure and it can be confusing to think about how it works, let alone how to license them. It is easy to get overwhelmed and to simply let your SQL Server sales rep handle it and tell you what you need to purchase and how many. Of course, just because they know their way around their CALs, cores, and sockets does not mean they know what is best for your business. Only you can answer that question.

    At MetrixData 360, we strongly believe in educating our clients to improve their understanding of software asset management and software licenses in order to lead to strong, long-term SAM practices after our engagement has concluded. So, today we’re hoping to answer some of your more pressing questions around how to license your SQL servers.

    What Are SQL Servers? A Brief Overview

    Just to make sure we’re all on the same page, the main job of SQL Servers are to store data and retrieve it upon the request of other software applications, sort of like a company’s personal Google. SQL servers are made of many varied sizes and targeted towards different workloads and different types of workforces. Some exist in the Cloud with thousands of concurrent users and others exist in small to medium size on-prem businesses.

    SQL servers are also designed to process different types of data, including primitive types like Char, Varchar, binary, and text, just to name a few. SQL Server licensing can be staggeringly overwhelming due to its sheer size and the number of other applications that interact with it.
    Before we get into how a SQL Server works, here are some terms that you may need to know:

    SQL 2012 License changes consider the following section
    • Physical Server: the actual wires-and-bolts physical hardware system.
    • Physical Processor: the physical chip that is housed in a socket within the physical server that contains one or more cores.
    • Physical Core: Something like a mini server inside the server, a physical core is a smaller processing unit within the physical processor of the server, and are found in groups of two.

    How Do You Buy a SQL Server License?

    Microsoft sells their SQL Server Licenses in a variety of ways, including:

    • Retail (although you cannot buy an enterprise license through this means)
    • Volume licensing programs (including the MPSA, the EA, the EAS, the SCA, OPEN)
    • A third party through either Independent Software Vendor Royalty (ISVR) or Services Provider License Agreement (SPLA). Web edition purchases can only be made through a SPLA

    Free downloads for some editions (sees SQL Server editions section of this document to learn more about free editions of SQL Servers).
    SQL Servers come with different licensing types and different editions, all of which we will break down. First, let’s look at licensing types, of which there are two: Core Based Licensing, and Server + CAL Licensing.

    Core Based Licensing

    This license allows for an unlimited number of users and devices to be connected to a server. If you want to install your SQL servers under a Core Based License, make sure you can follow these rules:

    • You need to license every physical operating system environment (OSE) that is running SQL server software. You will need a core license for every core in the processor.
    • You need at least four core licenses for each physical processor on the server (core licenses are sold in packs of two).
    • The SQL Server or any of its components needs to be licensed. What this means is that you can’t separate products of the SQL server over different machines. If the SQL Server Agent is running exclusively on one SQL server and the SQL server reporting services is being run exclusively on another machine, you’ll run into problems if you try to license that all under a single license. You would need two separate licenses for that scenario.
    • Anything that is installed on the physical machine you need to have a license for. You don’t necessarily need it to be running to require a license for it.
    • The same logic is applied when using virtual cores in virtual environments.

    A math problem: Let’s say I have a single physical server. On the physical server, there are two processors, each with six physical cores with a total of twelve cores. In addition to the license for the operating system, I would need 6 core licenses (since they come in packs of two) in order to be properly licensed.

    Core Based Licensing

    Benefits of Core-Based Licensing

    • Core-based licensing is typically the only option you have at your disposal when the SQL server in question is being accessed by devices and users outside your company’s network, since Server + CAL licenses would require you to purchase a license for every external person/device, which would not only be expensive, it would also be impossible to keep track of.
    • Ideal for larger companies, since it is easy to manage. Imagine having an international corporation with tens of thousands of employees, keeping track of who needed what CAL would be exhausting.
    • It also can prove cheaper for larger organizations, especially if your users far outnumber the cores you have.

    Table of Contents

    Table of Contents

    SQL Servers are the most complicated, most expensive, and most critical element of an organization’s software infrastructure and it can be confusing to think about how it works, let alone how to license them. It is easy to get overwhelmed and to simply let your SQL Server sales rep handle it and tell you what you need to purchase and how many. Of course, just because they know their way around their CALs, cores, and sockets does not mean they know what is best for your business. Only you can answer that question.

    At MetrixData 360, we strongly believe in educating our clients to improve their understanding of software asset management and software licenses in order to lead to strong, long-term SAM practices after our engagement has concluded. So, today we’re hoping to answer some of your more pressing questions around how to license your SQL servers.

    What Are SQL Servers? A Brief Overview

    Just to make sure we’re all on the same page, the main job of SQL Servers are to store data and retrieve it upon the request of other software applications, sort of like a company’s personal Google. SQL servers are made of many varied sizes and targeted towards different workloads and different types of workforces. Some exist in the Cloud with thousands of concurrent users and others exist in small to medium size on-prem businesses.

    SQL servers are also designed to process different types of data, including primitive types like Char, Varchar, binary, and text, just to name a few. SQL Server licensing can be staggeringly overwhelming due to its sheer size and the number of other applications that interact with it.
    Before we get into how a SQL Server works, here are some terms that you may need to know:

    SQL 2012 License changes consider the following section
    • Physical Server: the actual wires-and-bolts physical hardware system.
    • Physical Processor: the physical chip that is housed in a socket within the physical server that contains one or more cores.
    • Physical Core: Something like a mini server inside the server, a physical core is a smaller processing unit within the physical processor of the server, and are found in groups of two.

    How Do You Buy a SQL Server License?

    Microsoft sells their SQL Server Licenses in a variety of ways, including:

    • Retail (although you cannot buy an enterprise license through this means)
    • Volume licensing programs (including the MPSA, the EA, the EAS, the SCA, OPEN)
    • A third party through either Independent Software Vendor Royalty (ISVR) or Services Provider License Agreement (SPLA). Web edition purchases can only be made through a SPLA

    Free downloads for some editions (sees SQL Server editions section of this document to learn more about free editions of SQL Servers).
    SQL Servers come with different licensing types and different editions, all of which we will break down. First, let’s look at licensing types, of which there are two: Core Based Licensing, and Server + CAL Licensing.

    Core Based Licensing

    This license allows for an unlimited number of users and devices to be connected to a server. If you want to install your SQL servers under a Core Based License, make sure you can follow these rules:

    • You need to license every physical operating system environment (OSE) that is running SQL server software. You will need a core license for every core in the processor.
    • You need at least four core licenses for each physical processor on the server (core licenses are sold in packs of two).
    • The SQL Server or any of its components needs to be licensed. What this means is that you can’t separate products of the SQL server over different machines. If the SQL Server Agent is running exclusively on one SQL server and the SQL server reporting services is being run exclusively on another machine, you’ll run into problems if you try to license that all under a single license. You would need two separate licenses for that scenario.
    • Anything that is installed on the physical machine you need to have a license for. You don’t necessarily need it to be running to require a license for it.
    • The same logic is applied when using virtual cores in virtual environments.

    A math problem: Let’s say I have a single physical server. On the physical server, there are two processors, each with six physical cores with a total of twelve cores. In addition to the license for the operating system, I would need 6 core licenses (since they come in packs of two) in order to be properly licensed.

    Core Based Licensing

    Benefits of Core-Based Licensing

    • Core-based licensing is typically the only option you have at your disposal when the SQL server in question is being accessed by devices and users outside your company’s network, since Server + CAL licenses would require you to purchase a license for every external person/device, which would not only be expensive, it would also be impossible to keep track of.
    • Ideal for larger companies, since it is easy to manage. Imagine having an international corporation with tens of thousands of employees, keeping track of who needed what CAL would be exhausting.
    • It also can prove cheaper for larger organizations, especially if your users far outnumber the cores you have.

    Server + CAL Based Licensing

    There are instances where a Server + CAL license arrangement may suit your business’s needs better, although it will involve a lot more mixing and matching. You have to fulfill a certain number of guidelines in order to use a Server + CAL license successfully:

    • Just like with the core-based licenses, any physical operating system running SQL server software or any of SQL server’s components will need a SQL server license assigned to the physical server hosting OSE.
    • In addition to the license for the OSE, you will also need to purchase a license for each device and/or user that has access. Think of the OSE license like purchasing the lock on your door, the CALs are the keys, you need both to gain access.

    Client Access Licenses (CAL)

    Client Access Licenses (CAL), is a license that grants access to specific Microsoft server software, usually in conjunction with other Microsoft server software licenses. Basically, while the server license allows for the installation of the software on an operating system, the CAL allows for people or devices to access the services that the operating system is hosting. There are two different types of CALs, depending primarily on what your company’s needs the server software you intend to use your CAL for.

    User CAL: Allows for a single unique physical user to access the Microsoft software from many different devices. This includes work devices, personal devices, Internet kiosk or a personal digital assistant without the need to purchase a CAL for every device. However, you are licensed per physical person, not log-in usernames, so all the John Smiths in your company can breathe easy.

    Device CAL: Allows a large number of users to access the server software through a single device.

    Be very careful with the version number your CAL has when you purchase it (IE. Windows Server 2010 CAL). The CAL must be of the same version or be a more recent version than the version of the Server software you are pairing it with. For instance, a Windows Server 2010 CAL can be paired with a Windows 2010 or 2008 server but not a 2012 Server.

    Each server product will require the associated CAL. For instance, if you have a Windows Server and an Exchange Server, which both access the Active Directory, then you will need a Window Servers CAL and an Exchange CAL. A CAL can also give you access to multiple servers of the same kind throughout your domain.

    As you can imagine the pairing of your CALs to your servers can get extremely confusing and complex, especially if you try to mix and match. So, it is always a good idea to consult your Microsoft Rep or your third-party rep, give them a clear picture about what your software environment looks like and then they can tell you about the CALs you need.

    Benefits of the Server + CAL Licenses

    Types of SQL Server Edition

    Now that we have our SQL server licensing models laid out, we can move onto the next level of complication: Editions. Microsoft first deploy SQL Server Express to see if it is sufficient for their specific applications and will only move to the fee-based editions when they can confirm that Express will not meet their requirements.

    Developer: This edition allows you to build, test, and demonstrate applications in a non-production environment. It is important that the ‘non-production’ element is upheld in this edition, since using the developer edition on anything that is full production can result in heavy fines. A piece of software will be considered in production if individuals, either inside or outside of the organization, use the software for any reason beyond development, including evaluation acceptance testing such as a review of the application before it is put into general use.

    A SQL server will also be considered in production if it is connected to another database that is in production or runs as a backup or to provide disaster-recovery to a SQL server in production. As you can probably imagine, mixing production and non-production environments is a recipe for disaster, as this can cause hyper complexity and compliance issues, especially if access controls are not established that prohibits use outside of development and testing. There are a few ways to counteract this problem:

    • Use naming conventions for SQL Server instances to explicitly state if a Server is in development or in testing.
    • Install the SQL server on a separate network segment or cloud environment to lower the chance of unauthorized interaction.
    • Require that installs be developer-specific editions.

    The main challenge with these editions is proving which edition you have. For example, if you are in a software audit, unless provided with evidence that proves otherwise, the software auditors will assume that you only have Enterprise editions, which are the most expensive. Proving which editions, you have could mean the difference between owing hundreds of thousands of dollars and owing nothing.

    Licensing for Development Environments

    While Development and Express environments can be great in saving you money, in testing and demonstrating your software before deployment, it is important that these scenarios are licensed properly and that you understand their limitations. There are two types of SQL Server Development licenses:

    Developer-Specific Licenses: Used primarily for debugging, designing, development, testing and demonstrating purposes. This license is for non-production use only and is often purchased when programmers, professional testers, technical writers, database professionals, or IT administrators are involved. Developer specific licenses are assigned on a per-user basis, in which Users can install and access an unlimited number of SQL Server instances and share those instances only with other users who have been assigned the same type of developer-specific user licenses.

    That means, for this licensing model, if anyone wishing to access a development environment requires a developer-specific license, even for tasks as hands-off as administrative purposes. The only exception to this is user acceptance testing. Installations can be set up and taken down at any time and can be placed on desktops, dedicated servers, shared servers, and cloud environments. Some potentially less expensive alternatives to this license include the following:

    • Purchasing new production licenses
    • Cloud-based services like Windows Azure, which are usually based on a monthly subscription model (if you have an MSDN subscription, it includes Windows Azure credits, discounted rates and the ability to use MSDN software at no additional charge)
    • Free editions like SQL Server Express and the SQL Server Compact (a free embedded edition of SQL specifically for developers)

    </div class=”listbox”>Evaluation Licenses: Used to assess the software for potential business use. Again, only used for non-production environments but it is not often used in development and test environments. Usually comes with an expiration date (60-180 days to evaluate the use of the software) when obtained through volume license contracts.

    Licensing Virtualized Environments

    It is possible and necessary to license virtualized environments, and you have the ability to cover your VMs under your Enterprise + Software Assurance addition licensing model if you have one. This will cover all the VMs that your software environment will ever see, which comes in handy since VMs are so easily and quickly cloned and installed.

    However, it is terribly important to consult with your Microsoft Rep to ask if virtualized environments can be properly covered by your software assurance as you don’t want to run the risk of facing any compliance issues with Microsoft. You will need a license for every virtual core that you have.

    Licensing your Virtual Environment all depends on the licensing model you choose, with the per core model proving much more cost-effective for many clients. If you aim to license the Virtual Cores on Virtual Operating System Environments (OSE), then you will need a minimum of four licenses per processor if you have more than four cores on each of your virtual processors, then you’ll need to calculate what you’ll need based on the number of cores. If your OSE is mapped to different pieces of hardware, you’ll need additional licenses for anything the OSE is touching.

    Power BI and SQL Server

    Power BI is one of the most popular services for large businesses, and it can quickly become the most complicated due to its robust environment and its complicated, although critical, relationship with SQL servers. You can obtain Power BI either through purchasing one of the Power BI plans or through having SQL Server Enterprise Edition + Software Assurance. SQL Server Enterprise Edition + Software Assurance will give you access to the Power BI Server, this will allow for on-prem sharing of Power BI Content through the Power BI report server.

    Although you will still need to have a Power BI account for content creation. If your organization already has an Enterprise SQL Server edition and intends to use Power BI strictly for On-prem sharing of content, simply getting Software Assurance will be the more cost-effective option as opposed to buying a Power BI plan.

    It is also important to note that Power BI Desktop has access to SQL Server, but not Power BI Service. Although Power BI Service can provide a connection to Azure SQL Database and SQL Data Warehouse, it can’t do the same with SQL Server. With the Desktop, however, you can retrieve SQL Server data from tables and run queries that can retrieve a subset of the data from multiple tables.

    Licensing for Disaster Recovery and High Availability

    Making sure that your SQL server can properly store information and making sure you can access it at any time is a critical element for SQL servers’ customers and one of the most popular features in their software assurance benefits. Which is why Microsoft, as of November 1st, 2019, has three enhanced benefits to offer to software assurance customers, which can be applied to any SQL Server that is still supported by Microsoft, including failover servers for high availability, disaster recovery, and disaster recovery in Azure. What this means is that you can run passive SQL Server instances on separate operating system environments (OSE) or servers for high-availability on-prem or in Azure to cover any sort of failover event.

    If you have a secondary server that is only used as failover support, then you do not need to license that server separately from the SQL server it is supporting, as long as the server remains truly passive and the primary SQL Server is covered by your Software Assurance.

    If the passive server is providing data, such as reports, to clients or performing any other ‘work’ including additional backups, then it will be considered active and will require its own license. It is most important that you have a means of proving when your servers are passive, since during a software audit, the software auditors will assume that all your servers are active if given the chance to assume so.

    If you are licensed using the Server + CAL model, then any user or device that is indirectly accessing your SQL server data through another hardware device or software application will require their own SQL Server CALs.

    Upgrading your SQL Server

    If your SQL Server Edition reaches a certain age (Server 2005, for example) Microsoft could eventually announce that they are no longer supporting your particular brand of SQL Server (Microsoft announced in 2016 that support for SQL Server 2005 would end that April).
    This means no more security or feature updates, no more help from Microsoft to keep your environment healthy and protected. Even if your license is perpetual and legally speaking you are allowed to keep the product forever, it may still be within your best interest to upgrade your license anyway to one that Microsoft supports.

    However, it will not be easy since a SQL Server upgrade will take months and you should plan accordingly. When you are considering updating from one Server to the next, the first thing you need to do is make a to-do list containing everything you have to do, such as:

    • Making sure you have all the Window Updates
    • Do you have .NET Framework installed correctly?
    • Do you have KB2919355 installed (if you are using Server 2012 with SQL 2014 installation)
    • Insure that you have enough free space to allow for the upgrade (at least 100GB). After all such preparations are ready you can begin the whole upgrading process

    If you have Software Assurance, then you are covered to upgrade your SQL Server edition, if not then you will have to purchase more licenses. Check to make sure what sort of changes have occurred since you last updated SQL Server, since depending on how old your SQL Server is, you may find yourself confronted with new features, new definitions, and new licensing metrics.

    Do some research into the new SQL Server model you are planning on upgrading to and familiarize yourself on any differences the new edition has compared to your old model. If you are purchasing brand new licenses, consider which new SQL Server Edition will best suit your company’s needs and budget. Lastly, decide whether, this time around with your new SQL Server, if Software Assurance is something that interests your company.

    Want to Learn More?

    SQL Server licensing should not be a mystery, it’s important that you have a strong understanding of your software environment, including the backbone of the whole infrastructure. SQL Servers are so thoroughly implemented throughout the software environments of organizations that a simple mistake could easily be scaled up to mean millions of dollars in software auditing fines.

    At MetrixData 360, we understand the importance of making sure that your SQL Server licensing is understood and maintained. Our expertise in software licenses has led to clients saving 20%-30% of spending on your software environment. If you’d like to find out how you can put money back into your IT department, you can contact us using the information below.

    Book an Appointment with a SQL Server Licensing Expert Today

    SQL Servers are the most complicated, most expensive, and most critical element of an organization’s software infrastructure and it can be confusing to think about how it works, let alone how to license them. It is easy to get overwhelmed and to simply let your SQL Server sales rep handle it and tell you what you need to purchase and how many. Of course, just because they know their way around their CALs, cores, and sockets does not mean they know what is best for your business. Only you can answer that question.

    At MetrixData 360, we strongly believe in educating our clients to improve their understanding of software asset management and software licenses in order to lead to strong, long-term SAM practices after our engagement has concluded. So, today we’re hoping to answer some of your more pressing questions around how to license your SQL servers.

    Table of Contents

     


    What Are SQL Servers? A Brief Overview

    Just to make sure we’re all on the same page, the main job of SQL Servers are to store data and retrieve it upon the request of other software applications, sort of like a company’s personal Google. SQL servers are made of many varied sizes and targeted towards different workloads and different types of workforces. Some exist in the Cloud with thousands of concurrent users and others exist in small to medium size on-prem businesses.

    SQL servers are also designed to process different types of data, including primitive types like Char, Varchar, binary, and text, just to name a few. SQL Server licensing can be staggeringly overwhelming due to its sheer size and the number of other applications that interact with it.
    Before we get into how a SQL Server works, here are some terms that you may need to know:

     

    SQL Licensing Changes to consider SQL sever licensing diagram

      • Physical Server: the actual wires-and-bolts physical hardware system.
      • Physical Processor: the physical chip that is housed in a socket within the physical server that contains one or more cores.
      • Physical Core: Something like a mini server inside the server, a physical core is a smaller processing unit within the physical processor of the server, and are found in groups of two.

     

    How Do You Buy a SQL Server License?

    Microsoft sells their SQL Server Licenses in a variety of ways, including:

    • Retail (although you cannot buy an enterprise license through this means)
    • Volume licensing programs (including the MPSA, the EA, the EAS, the SCA, OPEN)
    • A third party through either Independent Software Vendor Royalty (ISVR) or Services Provider License Agreement (SPLA). Web edition purchases can only be made through a SPLA

    Free downloads for some editions (sees SQL Server editions section of this document to learn more about free editions of SQL Servers).
    SQL Servers come with different licensing types and different editions, all of which we will break down. First, let’s look at licensing types, of which there are two: Core Based Licensing, and Server + CAL Licensing.

    Core Based Licensing

    This license allows for an unlimited number of users and devices to be connected to a server. If you want to install your SQL servers under a Core Based License, make sure you can follow these rules: SQL Server Core based licensing diagram

    • You need to license every physical operating system environment (OSE) that is running SQL server software. You will need a core license for every core in the processor.
    • You need at least four core licenses for each physical processor on the server (core licenses are sold in packs of two).
    • The SQL Server or any of its components needs to be licensed. What this means is that you can’t separate products of the SQL server over different machines. If the SQL Server Agent is running exclusively on one SQL server and the SQL server reporting services is being run exclusively on another machine, you’ll run into problems if you try to license that all under a single license. You would need two separate licenses for that scenario.
    • Anything that is installed on the physical machine you need to have a license for. You don’t necessarily need it to be running to require a license for it.
    • The same logic is applied when using virtual cores in virtual environments.

    A math problem: Let’s say I have a single physical server. On the physical server, there are two processors, each with six physical cores with a total of twelve cores. In addition to the license for the operating system, I would need 6 core licenses (since they come in packs of two) in order to be properly licensed.

    Benefits of Core-Based Licensing

    • Core-based licensing is typically the only option you have at your disposal when the SQL server in question is being accessed by devices and users outside your company’s network, since Server + CAL licenses would require you to purchase a license for every external person/device, which would not only be expensive, it would also be impossible to keep track of.
    • Ideal for larger companies, since it is easy to manage. Imagine having an international corporation with tens of thousands of employees, keeping track of who needed what CAL would be exhausting.
    • It also can prove cheaper for larger organizations, especially if your users far outnumber the cores you have.

    Server + CAL Based Licensing

    There are instances where a Server + CAL license arrangement may suit your business’s needs better, although it will involve a lot more mixing and matching. You have to fulfill a certain number of guidelines in order to use a Server + CAL license successfully:

    • Just like with the core-based licenses, any physical operating system running SQL server software or any of SQL server’s components will need a SQL server license assigned to the physical server hosting OSE.
    • In addition to the license for the OSE, you will also need to purchase a license for each device and/or user that has access. Think of the OSE license like purchasing the lock on your door, the CALs are the keys, you need both to gain access.

    Client Access Licenses (CAL)

    Client Access Licenses (CAL), is a license that grants access to specific Microsoft server software, usually in conjunction with other Microsoft server software licenses. Basically, while the server license allows for the installation of the software on an operating system, the CAL allows for people or devices to access the services that the operating system is hosting. There are two different types of CALs, depending primarily on what your company’s needs the server software you intend to use your CAL for.

    User CAL: Allows for a single unique physical user to access the Microsoft software from many different devices. This includes work devices, personal devices, Internet kiosk or a personal digital assistant without the need to purchase a CAL for every device. However, you are licensed per physical person, not log-in usernames, so all the John Smiths in your company can breathe easy.

    Device CAL: Allows a large number of users to access the server software through a single device.

    Be very careful with the version number your CAL has when you purchase it (IE. Windows Server 2010 CAL). The CAL must be of the same version or be a more recent version than the version of the Server software you are pairing it with. For instance, a Windows Server 2010 CAL can be paired with a Windows 2010 or 2008 server but not a 2012 Server.

    Each server product will require the associated CAL. For instance, if you have a Windows Server and an Exchange Server, which both access the Active Directory, then you will need a Window Servers CAL and an Exchange CAL. A CAL can also give you access to multiple servers of the same kind throughout your domain.

    As you can imagine the pairing of your CALs to your servers can get extremely confusing and complex, especially if you try to mix and match. So, it is always a good idea to consult your Microsoft Rep or your third-party rep, give them a clear picture about what your software environment looks like and then they can tell you about the CALs you need.

    Benefits of the Server + CAL Licenses

    Types of SQL Server Edition

    Now that we have our SQL server licensing models laid out, we can move onto the next level of complication: Editions. Microsoft first deploy SQL Server Express to see if it is sufficient for their specific applications and will only move to the fee-based editions when they can confirm that Express will not meet their requirements.

    Developer: This edition allows you to build, test, and demonstrate applications in a non-production environment. It is important that the ‘non-production’ element is upheld in this edition, since using the developer edition on anything that is full production can result in heavy fines. A piece of software will be considered in production if individuals, either inside or outside of the organization, use the software for any reason beyond development, including evaluation acceptance testing such as a review of the application before it is put into general use.

    A SQL server will also be considered in production if it is connected to another database that is in production or runs as a backup or to provide disaster-recovery to a SQL server in production. As you can probably imagine, mixing production and non-production environments is a recipe for disaster, as this can cause hyper complexity and compliance issues, especially if access controls are not established that prohibits use outside of development and testing. There are a few ways to counteract this problem:

    • Use naming conventions for SQL Server instances to explicitly state if a Server is in development or in testing.
    • Install the SQL server on a separate network segment or cloud environment to lower the chance of unauthorized interaction.
    • Require that installs be developer-specific editions.

    The main challenge with these editions is proving which edition you have. For example, if you are in a software audit, unless provided with evidence that proves otherwise, the software auditors will assume that you only have Enterprise editions, which are the most expensive. Proving which editions, you have could mean the difference between owing hundreds of thousands of dollars and owing nothing.

    Licensing for Development Environments

    While Development and Express environments can be great in saving you money, in testing and demonstrating your software before deployment, it is important that these scenarios are licensed properly and that you understand their limitations. There are two types of SQL Server Development licenses:

    Developer-Specific Licenses: Used primarily for debugging, designing, development, testing and demonstrating purposes. This license is for non-production use only and is often purchased when programmers, professional testers, technical writers, database professionals, or IT administrators are involved. Developer specific licenses are assigned on a per-user basis, in which Users can install and access an unlimited number of SQL Server instances and share those instances only with other users who have been assigned the same type of developer-specific user licenses.

    That means, for this licensing model, if anyone wishing to access a development environment requires a developer-specific license, even for tasks as hands-off as administrative purposes. The only exception to this is user acceptance testing. Installations can be set up and taken down at any time and can be placed on desktops, dedicated servers, shared servers, and cloud environments. Some potentially less expensive alternatives to this license include the following:

    • Purchasing new production licenses
    • Cloud-based services like Windows Azure, which are usually based on a monthly subscription model (if you have an MSDN subscription, it includes Windows Azure credits, discounted rates and the ability to use MSDN software at no additional charge)
    • Free editions like SQL Server Express and the SQL Server Compact (a free embedded edition of SQL specifically for developers)

    </div class=”listbox”>Evaluation Licenses: Used to assess the software for potential business use. Again, only used for non-production environments but it is not often used in development and test environments. Usually comes with an expiration date (60-180 days to evaluate the use of the software) when obtained through volume license contracts.

    Licensing Virtualized Environments

    It is possible and necessary to license virtualized environments, and you have the ability to cover your VMs under your Enterprise + Software Assurance addition licensing model if you have one. This will cover all the VMs that your software environment will ever see, which comes in handy since VMs are so easily and quickly cloned and installed.

    However, it is terribly important to consult with your Microsoft Rep to ask if virtualized environments can be properly covered by your software assurance as you don’t want to run the risk of facing any compliance issues with Microsoft. You will need a license for every virtual core that you have.

    Licensing your Virtual Environment all depends on the licensing model you choose, with the per core model proving much more cost-effective for many clients. If you aim to license the Virtual Cores on Virtual Operating System Environments (OSE), then you will need a minimum of four licenses per processor if you have more than four cores on each of your virtual processors, then you’ll need to calculate what you’ll need based on the number of cores. If your OSE is mapped to different pieces of hardware, you’ll need additional licenses for anything the OSE is touching.

    Power BI and SQL Server

    Power BI is one of the most popular services for large businesses, and it can quickly become the most complicated due to its robust environment and its complicated, although critical, relationship with SQL servers. You can obtain Power BI either through purchasing one of the Power BI plans or through having SQL Server Enterprise Edition + Software Assurance. SQL Server Enterprise Edition + Software Assurance will give you access to the Power BI Server, this will allow for on-prem sharing of Power BI Content through the Power BI report server.

    Although you will still need to have a Power BI account for content creation. If your organization already has an Enterprise SQL Server edition and intends to use Power BI strictly for On-prem sharing of content, simply getting Software Assurance will be the more cost-effective option as opposed to buying a Power BI plan.

    It is also important to note that Power BI Desktop has access to SQL Server, but not Power BI Service. Although Power BI Service can provide a connection to Azure SQL Database and SQL Data Warehouse, it can’t do the same with SQL Server. With the Desktop, however, you can retrieve SQL Server data from tables and run queries that can retrieve a subset of the data from multiple tables.

    Licensing for Disaster Recovery and High Availability

    Making sure that your SQL server can properly store information and making sure you can access it at any time is a critical element for SQL servers’ customers and one of the most popular features in their software assurance benefits. Which is why Microsoft, as of November 1st, 2019, has three enhanced benefits to offer to software assurance customers, which can be applied to any SQL Server that is still supported by Microsoft, including failover servers for high availability, disaster recovery, and disaster recovery in Azure. What this means is that you can run passive SQL Server instances on separate operating system environments (OSE) or servers for high-availability on-prem or in Azure to cover any sort of failover event.

    If you have a secondary server that is only used as failover support, then you do not need to license that server separately from the SQL server it is supporting, as long as the server remains truly passive and the primary SQL Server is covered by your Software Assurance.

    If the passive server is providing data, such as reports, to clients or performing any other ‘work’ including additional backups, then it will be considered active and will require its own license. It is most important that you have a means of proving when your servers are passive, since during a software audit, the software auditors will assume that all your servers are active if given the chance to assume so.

    If you are licensed using the Server + CAL model, then any user or device that is indirectly accessing your SQL server data through another hardware device or software application will require their own SQL Server CALs.

    Upgrading your SQL Server

    If your SQL Server Edition reaches a certain age (Server 2005, for example) Microsoft could eventually announce that they are no longer supporting your particular brand of SQL Server (Microsoft announced in 2016 that support for SQL Server 2005 would end that April).
    This means no more security or feature updates, no more help from Microsoft to keep your environment healthy and protected. Even if your license is perpetual and legally speaking you are allowed to keep the product forever, it may still be within your best interest to upgrade your license anyway to one that Microsoft supports.

    However, it will not be easy since a SQL Server upgrade will take months and you should plan accordingly. When you are considering updating from one Server to the next, the first thing you need to do is make a to-do list containing everything you have to do, such as:

    • Making sure you have all the Window Updates
    • Do you have .NET Framework installed correctly?
    • Do you have KB2919355 installed (if you are using Server 2012 with SQL 2014 installation)
    • Insure that you have enough free space to allow for the upgrade (at least 100GB). After all such preparations are ready you can begin the whole upgrading process

    If you have Software Assurance, then you are covered to upgrade your SQL Server edition, if not then you will have to purchase more licenses. Check to make sure what sort of changes have occurred since you last updated SQL Server, since depending on how old your SQL Server is, you may find yourself confronted with new features, new definitions, and new licensing metrics.

    Do some research into the new SQL Server model you are planning on upgrading to and familiarize yourself on any differences the new edition has compared to your old model. If you are purchasing brand new licenses, consider which new SQL Server Edition will best suit your company’s needs and budget. Lastly, decide whether, this time around with your new SQL Server, if Software Assurance is something that interests your company.

    Want to Learn More?

    SQL Server licensing should not be a mystery, it’s important that you have a strong understanding of your software environment, including the backbone of the whole infrastructure. SQL Servers are so thoroughly implemented throughout the software environments of organizations that a simple mistake could easily be scaled up to mean millions of dollars in software auditing fines.

    At MetrixData 360, we understand the importance of making sure that your SQL Server licensing is understood and maintained. Our expertise in software licenses has led to clients saving 20%-30% of spending on your software environment. If you’d like to find out how you can put money back into your IT department, you can contact us using the information below.

    Book an Appointment with a SQL Server Licensing Expert Today

     

    Table of Contents

    Oracle’s 2020 Q4 Report Is In, Does It Mean An Audit For You?

    Oracle released their 2020 Q4 report and it may mean that there are Oracle Audits coming. Software audits can be a living nightmare if you find yourself unprepared, leaving the possibility for things to spiral out of control until the next thing you know you’re facing outlandishly large compliance gaps no idea how to prove them wrong. Oracle audits are no exception to this and many of their customers find themselves at a loss when confronted with one. While we have covered how to handle a general audit, there are a few things about Oracle audits that make them unique, which is what we’ll go over today. At, MetrixData 360, we have gone up against the biggest software companies in the software industry today and have empowered our clients with the knowledge they need to walk away from such audits with minimal damage to their IT budget.

    Oracle’s Results Released for Q4

    On June 16, 2020, Oracle released its Q4 report for their fiscal year and the results show case exactly how hard Oracle has been hit by the COVID-19 pandemic . The report showed four areas of Oracle’s business that were suffering. First, the Cloud services and licenses support, which saw only a 1% increase in revenue over the past year, which is a considerably weak increase since, historically, Oracle has seen a 4% increase in that same category. Their other main streams of revenue have declined with hardware seeing a 9% dip, services seeing an 11% dip, and cloud licenses and on-prem licenses seeing a staggering nosedive of 22%.

    Those are 2008-recession levels of bad and it doesn’t help that Oracle’s traditionally highest grossing month is May, where they haul in almost 40% of their year’s total revenue. May was also the same month that saw the worst of the pandemic lock down, where the last thing on anyone’s mind was buying more software. Part of this may be just a COVID-19 blip, with Oracle having only to make it to the other side of this truly terrible year before they can see their usual numbers again. However, these numbers have many of Oracle’s customers sweating at what this might mean for Oracle audits.

    From the Beginning: What Attracts an Oracle Audit, and How to Respond to Receiving One

    With this news, there is a strong chance that there will be an increase in audits, and it’s suspected that these audits will be aimed towards small to medium size companies with lower investments in Oracle, while companies who have large investments in Oracle are not expected to feel any significant changes. But while there might not be any significant increase for these large companies when it comes to Oracle audits, there will certainly not be a decrease in them any time soon, so it’s important that you are prepared all the same. While some software companies have routine audits or send out audits at random, Oracle tends to be a bit more precise when it comes to who they audit.

    Generally, you can expect an Oracle audit once every 3-4 years, unless your last audit was restricted to only a single Oracle product or area of your software environment, then you can expect to be audited more frequently. Your Oracle audit may have been brought on by any of the following factors occurring in the past 24 months at your organization:

    • You’ve gone through a merger or acquisition
    • You are still in possession of old or outdated Oracle software whose metrics are no longer used by Oracle
    • You’ve conducted a hardware environment refresh
    • Your organization has seen an organic growth of 10% or greater
    • You have trimmed back on Oracle products in any way such as cancelling or reducing support from Oracle
    • You have an Unlimited Licensing Agreement (ULA), since it is suspected that Oracle will be focusing its auditing efforts on either getting you to renew your ULA or switch to a perpetual ULA

    When you receive either an Oracle License Review or an Oracle License Audit, don’t let the different names distract or tempt you to take the Review as less serious than the Audit. They are essentially the same in both process and stakes. The only real difference between the two is that ‘review’ is a friendly, less threatening term when compared to an audit.

    LMS and Oracle Tools: Dealing with Both

    Oracle Licensing Management Service (LMS) is the internal team from Oracle that you will likely be dealing with throughout your audit. Although it is possible for Oracle to outsource the project to their partners, and other departments of Oracle will perform audit-like services such as reviews, their internal audit team is the only department authorized to perform License Audits on behalf of Oracle.

    When you interact with Oracle’s LMS, one consistent element that you’ll run into is that they will want you to run their own, Oracle approved, SAM tools to collect the data from your software environment. Your first goal in this audit is to make sure that your tools are used instead, an argument which we cover in length in our Software Audit Defense Procedure . While you are required to comply with the audit, nowhere in your contract does it require you to install their SAM tools. So long as you can prove that your own SAM tools can accurately retrieve the data that Oracle is asking for, then there is nothing wrong with using your own tools.

    Who Foots the Bill? The Old Oracle vs. the New Post COVID Oracle

    In the past, Oracle’s audits and their sales reps had the same goal: sales for the sake of sales. Sales reps got commission annually for every transaction, these numbers were usually 1% of the contract value, and if it was cloud services they were selling, that number rose to a tantalizing 5-10%. So, sales reps preferred cloud services and at the end of an audit, it was often the case that cloud services would come up when it was time for settlement. Oracle has essentially offered its audited customers get-out-of-jail free cards in exchange for the purchase of cloud services at a much smaller cost than your compliance gap, even if you didn’t need the cloud solution you are purchasing. All the sales rep really cared about was selling the services, it didn’t matter to them if you never used it again afterwards, since they got to walk away with that 5%-10% commission jingling in their pockets.

    Now, however, Oracle has made a few changes to their sales rep models. They have significantly cut back on their staff numbers, and have put the vast majority of the remaining sales reps on the task of exclusively selling cloud services, and will only see that same level of compensation if their customers use the cloud services that were sold to them. This means that you will not see be seeing any cloud service deals at the end of your audit, you’ll just be expected to pay the compliance gap, which will be painfully more expensive than the previous alternative.

    Now, however, Oracle has made a few changes to their sales rep models. They have significantly cut back on their staff numbers, and have put the vast majority of the remaining sales reps on the task of exclusively selling cloud services, and will only see that same level of compensation if their customers use the cloud services that were sold to them. This means that you will not see be seeing any cloud service deals at the end of your audit, you’ll just be expected to pay the compliance gap, which will be painfully more expensive than the previous alternative.

    In addition to these costs, if you are found to be out of compliance by a significant degree, then you will be forced to cover the expenses for the entire software audit, including any expenses that Oracle racks up.

     

    How Should I prepare?

    Once you have received a software audit notice from Oracle, you will have about 45 days to respond. During that time, you need to get the following ready:

    • A Non-Disclosure Agreement: This will ensure that any information that you give to the auditors must remain between you and them unless they ask for your consent to send it to the rest of Oracle’s higher ups. This will allow you to remain in control of how Oracle perceives your organization and your compliance, both of which will become important when you enter into the negotiation and settlement phase of the audit.
    • A Single Point of Contact (SPC): You will need to make sure that you have a team to act as a single point of contact (ideally with legal, technical, and Oracle specialization) in place who will exclusively deal with communications with Oracle’s audit team. The auditors will only talk to the SPC and anything that is passed from your organization to the auditors will pass under the SPC’s eyes first. Anyone who is planning to be interviewed by Oracle will discuss with the SPC what they are planning on saying and how they should answer Oracle’s questions. This isn’t done for the sake of hiding anything from Oracle, but this will help to keep track of where you stand with Oracle and ensures your negotiation strategies remain uncompromising.
    • A Scope for the Audit: This is done so that, in the case that you are not so far out of compliance as Oracle originally thought, they do not keep looking through your software environment trying to find the profit they anticipated, also referred to as ‘scope creep’.

    This needs to be laid out during the kick-off meeting and it’s important that you do not let the data collection phase begin without those three things in place.

    Want to become an Expert a Handling Software Audits?

    No one will claim software audits are easy or simple, and if they claim it’s anything other than a thinly veiled attempt to squeeze more money out of your company, then they’re kidding themselves. Oracle audits can be especially tricky, considering the sheer size of Oracle’s company and the vast amount of resources you’ll be going up against. It can feel like you’re outnumbered and out of your depth as you’re surrounded by sharks who do this for a living. Which is why you don’t have to go through this experience alone. At MetrixData 360, we have created a whole reservoir of resources in order to better equip you to face any software audit that comes your way. If you would like to download our free e-book on a step-by-step process on handling software audits, you can click the link below.