Welcome to Your Blog

Review the posts below for some great tips. To edit this header go to Settings > Categories.

Section 1:

Market Overview

Key Points

Small and medium businesses (SMBs), typically defined as having fewer than 500 employees, are a major part of the U.S. economy. These firms represent 99.7% of the six million total U.S. employer firms, and have generated 63% of net new jobs over the past 15 years.As companies of all sizes begin to view technology as a strategic imperative, SMBs are also changing their unique relationship with IT. While reducing costs or overhead is still the prime strategic driver (cited by 58% of firms), reaching new customers implies a desire for growth and diversification (cited by 55% of firms).SMBs may want technology to drive new business for them, but many are not currently in an ideal position. Only 17% of SMBs say that they are exactly where they want to be with technology, with medium-­‐sized businesses and lines of business appearing to be a sweet spot for pushing new technology usage.

The Small and Medium Business Market

Although large companies tend to dominate the headlines and have a greater effect on the shape of business due to their size and scope, small and medium businesses account for the vast majority of American organizations and drive significant economic activity. Consider the following statistics from the Office of Advocacy of the U.S. Small Business Administration (SBA):

Small businesses (defined by SBA as fewer than 500 employees):

CompTIA uses the following definitions for different segments of the SMB market: - Micro firms: 1-9 employees - Small firms: 10-99 employees - Medium-sized firms: 100-499 employees

Note: these are firms with employees and payroll. Following Bureau of Labor Statistics categorization practices, self-employed workers are counted separately.

Represent 99.7% of the six million U.S. employer firms. (In addition, there are over 21 million non-­‐ employer firms, many of which are businesses run by a single owner.)On an establishment basis, there were a total of 9 million in 2014. An establishment is defined as a business entity; a single company may have multiple establishments (aka offices or locations).Have generated 63% of net new jobs over the past 15 years (driven primarily by startups).Employ 48.5% of all private sector employees.Pay 42% of total U.S. private payroll.Account for 37% of high-­‐tech employment.Generate 33% of export value.Using IDC’s slightly broader definition of SMB (1-­‐999 employees), IDC estimates this segment of U.S. customers spent more than $152 billion on IT hardware, software and services in 2014.Gartner estimates SMBs account for approximately 44% of IT spending globally (note: Gartner also defines SMB as 1-­‐999 employees).

The small and medium business market is also very dynamic. According to the SBA Office of Advocacy, the most recent Census data showed approximately 409,000 employer firms beginning operations in 2011 and approximately 471,000 firms closing that same year. About half of all new firms last five years, and one-­‐third reach their ten-­‐year anniversary.

In times of economic uncertainty, the small and medium business market is keenly watched as an indicator of employment and spending trends. According to the quarterly Wells Fargo/Gallup Small Business Index from December 2014, 71% of small businesses expect their financial situation to be very good or somewhat good over the next 12 months, and 26% plan to increase the number of jobs at their company. Both of these numbers represent increases from index scores earlier in 2014. This sentiment is also mirrored in CompTIA’s 2015 Outlook numbers, where small and medium businesses expect industry growth of 5% or greater, in part due to optimism about their firms’ prospects.

Thanks to the impact on the economy of small business, the U.S. government takes special note of this segment. Both the House and Senate have committees focused on small business. These committees were created in the 1940s and have been permanent standing committees for at least three decades. Their purpose is to evaluate all legislation passing though Congress for effects on small business, giving weight to the concept that small businesses have distinctive needs yet substantial economic bearing.

SMBs and Technology

Small and medium businesses have a unique relationship with technology, and that relationship is growing more critical. Without an abundance of capital to invest on technology initiatives, many firms seek the best value or the minimum requirement investment. On the other hand, there is an increasing sense of urgency since many technologies available today can significantly increase the abilities of a smaller business and create capabilities on par with a larger enterprise.

Companies of all sizes are beginning to view technology more as the primary vehicle for achieving objectives instead of simply a support mechanism for day-­‐to-­‐day operations. For small and medium businesses, the strategic goals that can be met through technology reflect both the current realities these firms face and the future possibilities they envision.

Across a broad range of companies, cost reductions have started to drop in priority as many firms have been cutting costs for several years and are now pursuing expansion or innovation. However, smaller businesses still feel financial pressures, especially as resources become more limited. Reducing costs is cited as a top priority among 63% of micro-­‐sized companies, 58% of small companies, and 52% of medium-­‐sized companies.

Other top priorities—such as improving operational efficiency and improving staff productivity—also highlight the desire to reduce overhead burdens and make the business more productive. SMBs understand that technology can deliver these benefits, and it is the primary motivation behind most technology decisions.

There is another strategic imperative that drives the approach to technology. Fifty-­‐five percent of SMBs cite reaching new customers as a top priority. These companies, just like larger firms, recognize that business environments and customer behaviors are changing drastically. Since those changes are largely driven by technology, it makes sense that this objective will create new thinking among SMBs about the role of technology in their organizations.

This dual role of technology, with operational efficiency on one side and innovative goals on the other, is not exclusive to SMBs, but it is encouraging to see that they recognize this dynamic. The innovative side of business technology is forcing new practices, new policies, and new partnering; and business growth and even sustainability are dependent on embracing these new areas.

With this perspective in mind, are SMBs in a good position with their current technology? For the most part, the answer is no. Only a small percentage of firms feel that they are exactly where they want to be, and the profile of those firms suggests that their self-­‐assessment may be somewhat optimistic.

Looking at firm size, the very smallest firms are most likely to say that they are exactly where they want to be. These firms have the fewest resources to spend on technology or even to explore new options. It is reasonable to assume that these firms simply cannot envision being in a place to use technology any differently than they are today, but new models of technology management may open their eyes to new possibilities.

Considering job role, the gap between employees in an IT function and employees in a business function is not enormous, but it still tracks with the current view of non-­‐technical employees becoming more tech savvy and pushing for technology that will help them meet objectives. Of course, the smallest businesses will not have formal IT departments, but this is still an area to watch for third party firms that play the IT role for their small customers.

Finally, the age of a business plays a role in their satisfaction with technology. The sweet spot seems to be those companies that have been in business between 5 and 9 years. These firms have built enough of a foundation to pursue the technology they need, and they are not overly encumbered by past decisions or investments. Younger firms tend to be more resource constrained, and older firms tend to have infrastructure pieces in place that may hinder flexibility.

As firms consider their current position, they are also thinking about how they will take the steps to improve that position in the future. A small group of SMBs (12%) are basically a blank slate, working to figure out their business needs and then build the strategy for meeting those needs. Another 46% feel that they are well positioned with a vision and strategy for execution. This group is skewed towards medium-­‐sized business, and there are doubtless still some opportunities for presenting new ideas that may not have been considered.

The best opportunity, though, lies with the 43% of SMBs that claim to have some ideas for where they would like to go, but are unsure of the strategy for achieving those goals. These companies already have the piece that they are best suited to bring to the table—ideas for transforming their business and taking it to the next level. The piece they need is the technology that will take them there, and the connection between those two pieces is the primary challenge that must be addressed.

Section 2: Usage Patterns

Key Points

As the technology landscape grows broader and more complex, SMBs are seeing a range of technology issues that they need help with, led by IT security (42% cite as an area for improvement), data management (42%), and modernizing architecture (39%). Work in these areas will require not only new technology, but also new workforce education and new processes.There are many different triggers for technology decisions at SMBs, with executives or business owners typically seen as the decision-­‐makers. A relatively low number of firms typically see IT companies making technology pitches, and there is opportunity to create a businesses discussion around technology at the smallest and youngest firms.Although pitches from IT firms are not the primary way technology decisions have been made in the past, 66% of SMBs say they are somewhat likely or very likely to seek outside help or expertise as they consider new strategic uses of technology. Outside firms can bring improvements to the technology decision process, such as education on the wide range of services and products available or a better understanding of how everything integrates together.

Digging Into SMB Tech Issues

As small and medium businesses consider their technology strategies for the future, the ultimate goal is to build systems that help move the business forward. The challenge is that building these systems and integrating them with each other and with a company workflow is more complicated than ever, thanks to a wider range of options and a dynamic environment.

While many IT projects are narrowly focused on a single application or workflow component, the notion of building new business systems carries an implication of overarching themes, and these themes stand out as the top areas of concern for SMBs. There is a common thread among these themes: they are all topics that have likely been lower priorities for smaller businesses but which now play an increased role in IT operations.

Security is quickly becoming a top priority for all businesses as breaches occur more frequently and carry more serious repercussions. Small businesses are not immune to attacks simply because their data sets are smaller. Cyberattacks have a growing variety of motivations, and data from Symantec shows that attacks on the smallest firms (where defenses are weak) occur just as often as attacks on the largest enterprises (where the data may be more valuable). Furthermore, the impact to an SMB is proportionally larger—the October 2014 Global Report on the Cost of Cyber Crime conducted by the Ponemon Institute found that the per capita cost of a breach for the smallest businesses was significantly higher than at the largest firms—$1,601 vs. $437.

Keeping data safe is just one aspect of data handling that is cause for concern among SMBs. As businesses undergo digital transformation, data turns into a more critical asset. The Big Data movement has also raised interest in using data for analysis and decision-­‐making, and even when the data sets are not massive there are tools and techniques required for performing good analytics. Many small businesses have never managed data as a primary resource, and they must take steps towards consolidating data silos, handling rapidly growing data collections, and establishing strong business continuity/disaster recovery plans.

The final item causing major concern for SMBs is their infrastructure. The smaller the firm, the less infrastructure there is in place. In the early days of cloud computing, this slowed adoption since small or micro businesses did not see a return in migrating small installations to the cloud. The thinking has shifted, as these firms begin to understand that cloud systems can give them expanded options at a reasonable price. As current pieces of infrastructure move towards the end of their life cycle, SMBs need to understand how to choose the best mix of cloud systems and on-­‐premise systems, and that will lead to the challenge of managing a complex architecture.

Sifting through complexity is clearly the next overall challenge after the top three problem areas. Education on available options, calculating ROI, and integration of disparate pieces are all activities that SMBs need help with as they try to simplify a complicated landscape. Not only do SMBs need to figure out which pieces can help make their current operations more efficient, but they also need to figure out how to add new pieces that help drive the business forward.

The use of technology to actually transform business occupies the final three spots on the list of SMB tech concerns. As Section 1 describes, many SMBs feel that they have ideas for the direction they would like to take their business. What they need is help in understanding how technology can make that vision a reality.

There are three primary ingredients that go into any technology solution: the hardware or software that make up the solution, the people involved to use or maintain the solution, and the process by which the solution fits into a business workflow. Among these three, SMBs rate people and technology nearly the same in terms of needing improvement, with process improvements a trailing priority.

The emphasis on people highlights the need for education. An obvious place for education is with any technical team that may exist that would own responsibility for installing or maintaining the application. However, education is also needed among the general workforce, as technology solutions become more user-­‐accessible and the endpoints (such as mobile devices) become more powerful. Such education will both ensure proper usage and reduce security risk.

Although process is not rated as highly as the other two components, it is an area that needs just as much attention. CompTIA’s research in the cloud space has shown that as companies move deeper with cloud adoption, they need to modify process and workflow in order to fully transform their business. As the technology solutions become more complex, SMBs will face the same challenge.

The Technology Process at SMBs

When considering how SMBs deal with technology, it is important to understand how they use their limited resources to make decisions and procure what they need.

The most common triggers for beginning a technology purchase process involve issues being brought directly to executives. At firms large enough to have a formal IT department, that group is largely responsible for bringing forward new concepts. At smaller firms, these issues come from all departments in the organization. The bottom line is that these decisions are brought to business executives and owners, where the final call is made. In larger companies, there is a movement towards greater interaction between technology and business; in smaller companies, this interaction naturally takes place.

With this interaction in place, the gap that many SMBs face is the correct knowledge and application of technology. The suggestions that are brought forward will often be more tactical than strategic in nature, and there is little bandwidth for considering the many ways in which a new strategy could create a widespread advantage. This is where a third party can be very useful, but pitches from outside firms are one of the least common triggers. In addition, the traditional selling pattern for outside firms is bypassing certain segments, and there is opportunity to engage these segments in order to build strategic technical plans.

SMBs are quite open to the idea of outside help. Sixty-­‐six percent of firms say they are somewhat likely or very likely to seek outside help or expertise as they consider new strategic uses of technology. Among those segments that are not frequently pitched by IT firms, there is varying sentiment about using third parties. Twenty-­‐nine percent of micro firms say they are somewhat likely or very likely to seek outside help, compared to 65% of employees in a business function, 51% of firms in business for less than five years, and 57% of respondents ages 40-­‐54. IT firms that are targeting these segments may have a receptive audience or may have some work to do in selling the value proposition.

The major challenge in making an outside relationship work is the finances. Two thirds of SMBs spend less than $100,000 annually on technology, with 29% spending $10,000 or less. With this raw dollar amount not being very high, it is difficult for an outside firm to draw in enough revenue. There is a silver lining, though—two thirds of SMBs are also planning increases to their technology budget, with 30% projecting an increase of 10% or more over the next year. Using technology in a new way could drive that total even higher—47% of SMBs say that they would be willing to increase their overall technology budget if presented with an innovative solution that could enable new business processes. Money may be tight, but the right offering could result in a valuable partnership.

Section 3:

Channel Dynamics

Key Points

Without an abundance of resources to devote to vetting outside firms, SMBs have a tendency to work with the firms they already know. Sixty-­‐five percent of SMBs say that they continue to work with firms they have worked with in the past. However, this mix may shift as companies move their technology needs beyond repair and integration and into new areas such as mobile app development or business process automation.The biggest driver for using an outside IT firm is the need for greater technical expertise, cited by nearly half of all SMBs. Other factors are important too, such as driving the business with technology (cited by 46% of IT executives) and the need to reduce the cost of IT support (cited by 40% of IT executives).Although cost has declined somewhat as a primary concern among businesses of all sizes, it remains slightly more critical in the SMB space. Forty-­‐two percent of SMBs say that they moved to a new IT firm because of cost, making it the biggest factor in deciding to make a switch. The second biggest factor was the need for innovative solutions, showing the need for IT firms to push into new areas.

Use of Third Party IT Firms

Many small and medium businesses have no IT department, choosing to handle technology issues internally using employees who may be tech savvy but actually hold other jobs such as sales or accounting. Other companies, especially those on the medium-­‐sized end of the spectrum, will build a formal IT function as infrastructure demands grow.

For all these companies, third party IT firms can provide value in providing and managing technology to meet strategic objectives. With smaller clients, an IT firm may act as the overall IT function, needing to both handle tactical plans and drive strategic vision. With larger clients, the role may be more complementary, with opportunities to apply technology in innovative ways for new business results.

Moving into a more strategic role will be a step forward for many VARs and MSPs currently working with SMBs. Over 70% of SMBs used an outside IT firm at least occasionally over the past 12 months. In most cases, this has been a firm (or firms) that they use regularly, demonstrating an established relationship. That relationship is likely one that has been formed around specific tasks or projects. The list of areas where IT firms have been used is mostly filled with traditional and tactical IT activities, led by repair/troubleshooting and installation/integration.

Other areas on the list indicate possibilities for starting more strategic conversations. Web design may refer to simple management or upkeep of a standard web presence, but this could be expanded into a broader digital transformation where products and services reach a new audience thanks to online and mobile efforts. Cloud computing has become a catch-­‐all term that also covers regular hosted datacenter services, but even those services can lead into the multi-­‐cloud architecture than many businesses of all sizes are now pursuing. Analytics is one of the least common areas for an outside firm to manage, but a heavier reliance on data for decision-­‐making may force many SMBs to explore new options.

In general, new options are exactly what SMBs are looking for as they consider using outside IT firms. While it is not surprising to see that medium-­‐sized firms are the most likely to cite this as a driver (50%), it is noteworthy that micro firms are the second most likely (47%). Medium-­‐sized firms have a well-­‐ established business strategy and want to ensure future growth, and micro firms include many startup firms that are working to establish their businesses in the same way and ensure future viability. Other drivers continue to reinforce the dual nature of technology in today’s business environment, from taking on routine tasks so that an SMB can focus internal resources on core operations to driving the business forward using the technology models that are available today.

Working Through Issues

Maintaining a relationship with clients is challenging in any environment. Today, when technology is creating such dramatic shifts in the way IT and even business are managed, the challenges multiply. “Consumerization of IT” can mean many different things, but for MSPs it means that their clients are becoming more aware of technology capabilities and more sensitive to the places where their business is not taking full advantage.

Reviewing the IT activities where SMBs use outside IT help, the satisfaction scores indicate that many companies can imagine improvements to their current level of IT support. Less than one-­‐third of all companies using outside help for some type of IT issue claimed to be “very satisfied” with the IT firm’s work on that issue (See Appendix for additional insights on customer satisfaction with IT services). Interestingly enough, the highest satisfaction came in the area of analytics. There may be few SMBs currently seeking this type of assistance, but those IT firms with the right skills are making an impact.

Looking at those areas where customers are “partly satisfied” or “dissatisfied,” there are several technical areas where IT firms should consider placing more emphasis or building more expertise.

24% of SMBs cite this level of satisfaction with telecom efforts. As the telecom industry and IT industry continue to merge, clients are looking for firms that understand the traditional issues associated with communications but also understand how to make communications happen over an IP network.25% of SMBs cite this level of satisfaction with web design or e-­‐commerce efforts. As both consumer behavior and B2B transactions become more digitized, it is essential to have a strong digital strategy.27% of SMBs cite this level of satisfaction with workflow automation. Cloud systems and mobile devices are opening new doors for higher levels of automation, which can reduce overhead spent on routine tasks. SMBs may be pushing for greater automation as they build their cloud/mobile foundation.

There is one area in particular that stands out from the pack, though: 44% of SMBs cite lower levels of satisfaction with mobile app development efforts. Weak mobile app development may actually contribute to dissatisfaction with all the other areas that give SMBs heartache. With mobile devices as the new computing frontend for the workforce, many companies are realizing that successful integration goes well beyond the device management decision. Success in many areas—including telecom, e-­‐commerce, and automation—will depend on having some level of custom development work. This is new ground for both end users and solution providers, and there will be much to learn as both sides pursue success in the era of mobility.

Of course, technology is not the only part of the equation for satisfied customers. There are several reasons that SMBs have made a switch from their regular tech firm, and these potential shortcomings are good for IT firms to examine as they manage marketing, customer service, and internal operations.

Cost can be somewhat of a red herring—every company would like to reduce costs, but most also realize that you get what you pay for. Especially considering the data from Section 2 showing that SMBs are willing to invest more for innovations that enable better business results, driving to the lowest cost solution may not truly be something that solution providers should aim for. With that said, cloud systems are changing the economics of IT, and many solutions could experience disruption to profit margins.

Beyond cost, the lack of innovative solutions is the top driver for switching IT firms. This ties directly to the desire for innovation that connects available technology to new business opportunities. To meet this need, IT firms will have to move beyond the managed services model, even as many firms are still working to make a managed services transition. The next transition involves moving from the management of isolated pieces of IT to management of the overall structure, then proactively driving technology decisions that are aligned with business needs. This is the same transition that many IT departments at larger firms are going through, so there is plenty of learning happening across the entire industry.

For all the hesitation that micro-­‐sized firms tend to exhibit when dealing with technology, they are the ones who are most adamant about needing innovation. Fifty-­‐seven percent of micro firms cite lack of innovation as a driver for switch IT providers, placing it above cost considerations for these companies. The budgets may be more limited, but the potential for growth (especially among startups) makes micro firms an interesting customer base.

Micro firms may show the strongest desire for innovation, but similar desire exists across the entire SMB spectrum. For solution providers, there is a great deal of opportunity but also a great many challenges that exist in building a new business model that simplifies technology, creates value, and ultimately drives new business for their SMB clients.

Verbatim Comments from SMB Customers for Ways IT Firms Can Improve:

Service Related

Availability / 24x7 supportBetter communicationsAdvisors need to be more communicativeBe more proactiveFaster response timeRespond to our issues in a more timely mannerMeet project deadlinesPrompt and courteous repliesConsistency in peopleMore training

Verbatim Comments from SMB Customers for Ways IT Firms Can Improve:

Business / Strategic / Technology Related

Listening to what we needUnderstand our businessTechnical guidanceMake system more user-­‐friendly Customizing to our needs Cloud services Innovation Better integration ideas for different areas [of our business]Life-­‐cycle management based on previous purchases lower costs Not trying to sell us things we don't need meet project cost estimates reliability

About this Research

CompTIA’s Enabling SMBs with Technology study provides insights into the ways that the small and medium business segment uses technology and interacts with outside firms provided technology solutions. The study consists of three sections, which can be viewed independently or together as chapters of a comprehensive report.

Section 1: Market Overview Section 2: Usage Patterns Section 3: Channel Dynamics

This quantitative study consisted of an online survey fielded to small and medium business executives and professionals during December 2014. A total of 500 small and medium businesses based in the United States participated in the survey, yielding an overall margin of sampling error at 95% confidence of +/-­ 4.5 percentage points. Sampling error is larger for subgroups of the data.

As with any survey, sampling error is only one source of possible error. While non-­‐sampling error cannot be accurately calculated, precautionary steps were taken in all phases of the survey design, collection and processing of the data to minimize its influence.

CompTIA is responsible for all content and analysis. Any questions regarding the study should be directed to CompTIA Research and Market Intelligence staff at research@comptia.org.

CompTIA is a member of the Marketing Research Association (MRA) and adheres to the MRA’s Code of Market Research Ethics and Standards.


SQL Server

37% of all units run Microsoft, >50% of units run 2008/R2 or older2


• Eliminate time spent managing “long tail” of applications—lift and shift to managed cloud

• Free up limited IT resources to drive transformation

• Migrate business critical apps to cloud—extend and innovate

1 Pie Chart *IDC Worldwide DB Forecast Dec 2016 2 Microsoft Internal Sources



Built-in intelligence Breakthrough productivity Seamless and compatible Competitive TCO and performance

Realize up to a 212% ROI over on-premises and hosted solutions

4.5 million databases

3 trillion batch requests/day

154 PB total size

1.4 million HTAP transactions/sec

421K subscriptions

100 million queries analyzed/hour


“We had an incident lasting for about 6 months. Before Intelligent Insights we have not had a way of figuring out where do we even start troubleshooting. Intelligent Insights gave us a list of things to do...it enables us to pinpoint where the problem is and to get a fix deployed within 24hrs.”

Frans Lytzen – CTO, New Orbit

“Intelligent Insights proactively finds a database performance problem in a more efficient way and much faster than humans. With it we can proactively help customers until we have a fix for the problem.”

Bauke Stil, App Manager, SnelStart

“SQL Threat Detection helps us to be ahead of the threats instead of chasing them.”

Shahin Kohan, CTO

“SQL Threat Detection helps us respond to activities, which were not visible beforehand.”

Manrique Logan, architect & technical lead



Database-scoped deployment option with predictable workload performance

Best for

apps that require resource guarantee at database level


Azure SQL Database Elastic Pool

Shared resource model optimized for greater efficiency of multi-tenant applications

Best for

SaaS apps with multiple databases that can share resources at database level, achieving better cost efficiency

Managed Instance

Instance-scoped deployment option with high compatibility with SQL Server and full PaaS benefits

Best for

modernization at scale with low friction and effort


Intelligent Performance learns unique database patterns and automatically tunes for improved performance

Intelligent Protection powers advanced data security features that monitor, detect, and alert on malicious activities and discover, track and remediate potential database vulnerabilities

Tuning algorithms


SQL Database

“My app gets auto-tuned”

Developer no admin skills

Database advisor

“I can do more in less time”

DBA of many databases


• One-click to enable

• Prevent and mitigate issues

• No app changes needed

• Tuning actions

• Create missing indexes

• Drop unused/duplicate indexes

• Force last good plan

Automatic tuning


Your work so far

How SQL Database helps

Hardware purchasing and management

Built-in scale on-demand

Protect data with backups (with health checks and retention)

Built-in point-in-time restore

High availability implementation

Built-in 99.99% SLA and auto-failover

Disaster recovery implementation

Built-in geo-redundancy and geo-replication

Ensure compliance with standards on your own

Built-in easy to use features

Secure your data from malicious users and mistakes

Built-in easy to use features

Role out updates and upgrades

Built-in updates and upgrades

Monitor, troubleshoot, and manage at scale

Built-in easy to use features

Tune and maintain for predictable performance

Built-in easy to use features

We take care of your database chores


Realize the benefits of real-time operational analytics

Enable scale-up with near zero downtime through cloud-born innovation

Classified as Microsoft Confidential


faster transactions with in-memory OLTP


performance gains with in-memory analytics

near 100% uptime with dynamic scalability


Combine the best of SQL Server with the benefits of a fully-managed service

Use familiar SQL Server features in SQL Database Managed Instance

Native backup and restore

Cross-database queries and transactions

Broad security features including Transparent Data Encryption, SQL Audit, Always Encrypted and Dynamic Data Masking

SQL Agent, DBMail, and Alerts for workload orchestration improved awareness

Scenario enablers including Change Data Capture, Service Broker, Transactional Replication, and CLR

DMVs, XEvents, and Query Store for troubleshooting

Full compatibility with SQL Server 2005+


Enable full isolation from other tenants without resource sharing

Promote secure communication over private IP addresses with native VNET integration

Enable your on-premise identities on cloud instances, through integration with Azure Active Directory and AD Connect

VNET support in SQL Database Managed Instance


Reduce capital and operational costs with a fully- managed service and achieve up to 406% ROI1

Financially-backed 99.99% availability SLA2

Promote business continuity with built-in capabilities

Maximize your on-premises investments with Azure Hybrid Benefit for SQL Server and reserved capacity pricing

Right-size on-premises workload requirements for the cloud with independent control of storage and compute

Up to 212% ROI with Azure SQL Database

$3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000

$500,000 $0


Financial Analysis (risk-adjusted)

1234 Series1 Series2 Series3

Source: The Total Economic ImpactTM of Microsoft Azure SQL Database Managed Instance, Forrester Consulting, September 2018

Cash flows


Challenges with translating on-premises workload requirements to the cloud when migrating

More flexibility desired to optimize resources for SQL Database workloads

Classified as Microsoft Confidential


Easier to right-size the destination environment by removing the guesswork of DTUs

You pay only for what you use

1 on-premises core = 1 vCore on Gen4 hardware

Classified as Microsoft Confidential

Introducing vCores




Independently configure compute, storage, IO

Most economical with Azure Hybrid Benefit for SQL Server



Blended measure of compute, storage, IO

May be more economical for < 3 cores

• Compare vCore-based and DTU-based options using this rule of thumb: 100DTU ~ 1 vCore

• Convert from DTU to vCore using the API or portal with no downtime and same SLO update as today


Choice drives our approach to resource management and pricing

• Simplicity: We remain committed to the DTU-based model and the simplicity it offers customers who want a pre-configured solution

• Flexibility: The vCore-based model reflects our commitment to customer choice and to simplify the hybrid benefit for customers migrating from on-premises

Customers pay for:

• Service tier + number of vCores

• Type and amount of data storage

• Number of IO*

• Backup storage (RA-GRS)*

The vCore-based model will exist alongside the DTU-based model

Learn more

*Free during preview

**4TB available on Gen 5 only

***Coming soon

Best for

Compute tiers





Most business workloads. Offers budget oriented balanced compute and storage options.

Premium remote storage (per instance)

Single/Elastic Pools

1 replica, no read-scale

RA-GRS, 7-35 days (7 days by default)

Managed Instance

32GB – 8TB


Data applications with large data capacity requirements and the ability to auto-scale storage and scale compute fluidly.

Two hardware generations to choose from

De-coupled storage with local SSD cache (per instance)

Single database

Up to 100TB

Configurable replicas, up to 15 read-scale

RA-GRS, 7-35 days (7 days by default), constant time PITR


OLTP applications with high transaction rate and low latency IO. Offers highest resilience to failures using several isolated AlwaysON replicas

Single/Elastic Pools

1 to 80 vCores

Managed Instance

8, 16, 24, 32, 40, 64, 80 vCores

Single database

1 to 80 vCores

Single/Elastic Pools

1 to 80 vCores

Super-fast local SSD storage (per instance)

Managed Instance

8, 16, 24, 32, 40, 64, 80 vCores

Single/Elastic Pools

5GB – 4TB

3 replicas, 1 read-scale, zone- redundant HA***

RA-GRS, 7-35 days (7 days by default)

Managed Instance

5GB – 4TB

32GB – 4TB**

Choose from three tiers in the vCore-based model


Use your on-premises SQL Server licenses with active Software Assurance to save up to 55% on vCore-based SQL Database deployment options with Azure Hybrid Benefit for SQL Server

Pre-pay your SQL Database compute capacity on a one or three-year term and save up to 33% with SQL Database reserved capacity

Combine the Azure Hybrid Benefit for SQL Server and SQL Database reserved capacity for even more savings, up to 80%.

Learn more:

• Azure Hybrid Benefit

• Azure SQL Database reserved capacity

*Based upon comparison of on-demand pricing on Azure for

Managed Instance versus running SQL on AWS RDS.

Classified as Microsoft Confidential

Save up to 80% with Azure Hybrid Benefit for SQL Server and SQL Database reserved capacity

Total monthly cost of 8 vCore Managed Instance Business Critical option

Up to 55% savings1

Up to 80% savings2

Customer total cost

License included

With Azure Hybrid Benefit

Reserved capacity with Azure Hybrid Benefit

1 Savings based on eight vCore Managed Instance Business Critical in East US Region, running 730 hours per month. Savings are calculated from full price (license included) against base rate (applying Azure Hybrid Benefit for SQL Server), which excludes Software Assurance cost for SQL Server Enterprise edition, which may vary based on EA agreement. Actual savings may vary based on region, instance size and performance tier. Prices as of May 2018, subject to change.

2 Savings based on eight vCore SQL Database Managed Instance Business Critical in West 2 US Region, running 730 hours per month. Savings are calculated from on demand full price (license included) against base rate with Azure Hybrid Benefit plus 3-year reserved capacity commitment. Savings excludes Software Assurance cost for SQL Server Enterprise edition, which may vary based on EA agreement. Actual savings may vary based on region, instance size and performance tier. Prices as of May 2018, subject to change.


Take an inventory of on-premises licenses to determine potential for conversion

Convert on-premises cores to vCores to maximize value of investments

1 Standard license core = 1 General Purpose core

1 Enterprise license core = 1 Business Critical core

1 Enterprise license core = 4 General Purpose cores (virtualization benefit)

Classified as Microsoft Confidential

SQL Server license trade-in values SQL Database Managed Instance

Business Critical

General Purpose

Standard Edition

General Purpose

Highly virtualized, Enterprise Edition

Enterprise Edition

SQL Server with Software Assurance


Tools for your migration journey

SQL Server Migration Assistant (SSMA)

Automates database migration to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and SAP ASE.

Data Migration Assistant (DMA)

Enables upgrade to SQL Server and Azure SQL Database.

Database Experimentation Assistant (DEA)

Assists in evaluating a targeted version of SQL for a given workload.

Azure Hybrid Benefit for SQL Server

Maximizes current on-premises license investments to facilitate migration.

Azure SQL Database Managed Instance

Facilitates lift and shift migration from on-premises SQL Server to PaaS.

SQL Database Managed Instance

Azure Database Migration Service (Azure DMS) SQL Server Migration Assistant (SSMA)

Data Migration Assistant (DMA)

Database Experimentation Assistant (DEA)

Azure Hybrid Benefit for SQL Server


Fully managed database migration service for both operational databases and data warehouses

Enables reliable and seamless migrations to the cloud at scale and minimal downtime

Migrate SQL Server & 3rd party databases to Azure SQL Database

Classified as Microsoft Confidential

Azure Database Migration Service



SQL Server

Azure SQL Database single, elastic pools and Managed Instance


Azure Database for MySQL


Azure Database for PostgreSQL

Oracle, ...

Azure SQL Database & Managed Instance

Netezza, ...

Azure SQL Data Warehouse


Provides guidance, tools, and partners in context of your migration scenario

Enables you to:

• Build your case, find others like you

• Assess your environment

• Identify the right migration strategies

• Optimize your cloud resources

Connects you to a migration expert

• Chat enabled, backed by engineering resources

• Guides you to FastTrack, partner, seller, or DIY outcomes


Azure migration center


Migrate an on-premises SQL Server database to Azure SQL Database

The Migration Cookbook describes various approaches you can use to migrate an on-premises SQL Server database to the latest Azure SQL Database Update

Download: https://azure.microsoft.c om/en-us/resources/choosing- your-database-migration-path-to- azure/en-us/

Classified as Microsoft Confidential


Classified as Microsoft Confidential

• Azure SQL Database

• SQL Database Managed Instance

• Create a Managed Instance

• Forrester Consulting Total Economic ImpactTM study

• Azure Hybrid Benefit for SQL Server

• Azure Database Migration Service

• Migration Guide

• SQL Server Integration Services

• Hands-on-lab to lift SSIS to Azure with Azure Data Factory: aka.ms/adflab


• Balance performance requirements and price with two hardware generations

• Match your on-premise application behavior

Classified as Microsoft Confidential


Performance levels



7GB per vCore

Gen 4

Intel E5-2673 v3 (Haswell) 2.4 GHz processors

vCore = 1 PP (physical core)

1, 2, 4, 8, 16, 22 vCores

Up to 4TB premium remote storage Up to 1TB local SSD storage

Gen 5

Intel E5-2673 v4 (Broadwell) 2.3 GHz processors, fast eNVM SSD

vCore=1 LP (hyper-thread)

2, 4, 8, 16, 24, 32, 48, 72 vCores

5.5GB per vCore

Up to 4TB premium remote storage Up to 4TB local SSD storage


Not installed side-by-side with Managed Instance

Migrate your SSIS packages to new SSIS on Azure Data Factory (PaaS service)

Migrate your OLAP models to Azure Analysis Services

... or run these services in Azure virtual machines

For SSRS: run in a virtual machine, or switch to Power BI

Classified as Microsoft Confidential

Recommendation - move BI solutions to PaaS model





Managed Instance is available in 8, 16, 24, 32 and 40 vCore instances

The number of instances eligible for Azure Hybrid Benefit is calculated based upon

• number and type of licenses you are exchanging

• Managed Instance vCore selection, rounding down to the nearest whole value.

Classified as Microsoft Confidential

How to calculate instances eligible for the hybrid benefit

Calculation = (10 Standard license cores * 1 core) + (10 Enterprise license cores * 4 cores) = 50 cores

Eligible number of instances:

(50 cores / 8 vCore instance) = 6 eligible instances

Calculation = (5 Standard license cores * 1 core) + (20 Enterprise license cores * 4 cores) = 85 cores

Eligible number of instances:

(85 cores / 16 vCore instance) = 5 eligible instances

1 Standard license core = 1 General Purpose core

1 Enterprise license core = 4 General Purpose cores (virtualization benefit)


License all physical cores in the server

6 6

Deploy VMs equal to number of core licenses

VM SQL Server


For virtualized EE workloads, customers get 4X vCore on Azure SQL DB vs. 1X core on Azure IaaS

SQL Database Managed Instance

SQL DB will be ~22%

cheaper than Azure IaaS


8 vCore at Base rate w/ SA

8 vCore at Base rate w/ SA

8 vCore at Base rate w/ SA

8 vCore at Base rate w/ SA




Enterprise Edition Customer Highly Virtualized

e.g. 32 core virtualized workload with 8 core SQL EE License

8 core at BYOL w/ SA

8 core at License Included

8 core at License Included

8 core at License Included

*All the SKUs above are 8 vCPU or vCore memory optimized equivalent. (D13v2 for Azure IaaS). The SA cost are based Open NL EE for SA. The License included prices are 8 core D13v2 for Azure IaaS. US East price. ** Prices as on Oct 2 2017

Classified as Microsoft Confidential

Cost on SQL DB (MI)= $6.21

AHB for SQL Server with Managed Instance

License Mobility for Azure IaaS Standard SE


Cost on Azure IaaS= $7.92





Christmas deal from SherWeb and Creative WebMatrix Solutions.

Adopt the digital transformation and move your business to the cloud today!

Terms and conditions:

Applicable to new organizations only Available for all members of SherWeb’s partner program

This promo CANNOT BE COMBINED with any other SherWeb promo

Here are the SKUs that are eligible for the promo:

$5 credit for

Business Essential Business

Exchange Online Plan 2 Enterprise E1 Enterprise ProPlus Microsoft 365 F1 

$10 credit for Business Premium Enterprise E3 Enterprise E5 Microsoft 365 Business

$15 credit for

Microsoft 365 E3 Microsoft 365 E5 Dynamics 365 Business Central Essentials and Premium Dynamics 365 Customer Engagement and Unified & Operations Applications and Plans

Contact is today and use Promo Code: Xmas


Upcoming Events

Online Meeting
Time is TBD
Location is TBD
Time is TBD
Location is TBD
Microsoft Training Session