Interlink Cloud Blog

Matt Scherocman brings more than 15 years of experience in the information technology industry to Interlink Cloud Advisors. His experience includes both the system integrator and manufacturer sides of the business. During his time at the Microsoft Corporation he was responsible for all the the Large Account Reseller (LAR) relationships in the four state Heartland Area of Michigan, Ohio, Kentucky, and Tennessee. Prior to Microsoft, Scherocman led a Cincinnati based IT consulting company to grow 5000% and become a Microsoft Worldwide Partner of the Year. He is actively involved in the strategic vision and operation decisions of the company including finance, selling strategy and marketing. Matt holds a Bachelor of Science in Business degree from Miami University and is a Certified Expert in Microsoft licensing including speaking engagements at both Microsoft's Worldwide Partner Conference and Channel Partner Summit. He is a frequent contributor to leading industry publications.

Matt Scherocman

SQL Server in the Public Cloud: SQL Database vs. SQL Server on Azure VMs

SQL Server in the Public Cloud: SQL Database vs. SQL Server on Azure VMs

When it comes to hosting SQL Server in the public cloud, there are two major options. 

  1. SQL Database
  2. SQL Server on Azure Virtual Machines (VMs)

Customers can choose just one or both, as each is designed for different SQL workloads and fit into Microsoft’s platform a different way.

In order to choose the right route for your application workload, you’ll want to match your business requirements with the benefits and capabilities of these two options. But first, know that if you choose a cloud path, you don’t have to be all in the cloud. Same goes for an on-premises direction. A hybrid cloud option, which means having part of your data centers in the cloud while keeping a select workloads on-premises, is what most businesses choose and what Microsoft’s cloud platform is built for.

The diagram below, courtesy of Microsoft Azure, shows the relation of cloud options to the level of administration you have over the infrastructure and the degree of cost efficiency:

SQL Server in the Public Cloud

The public cloud options (represented in blue) are outlined below, starting with…

Microsoft Azure SQL Database

SQL Database is hosted, and maintained by Microsoft. This Azure cloud platform is categorized as Software-as-a-Service (SaaS) or Platform as a Service (PaaS) and offers a few desirable features to help companies scale efficiently. First of which is cost flexibility. Users pay as they go, scaling up or down for more power and little interruption. You can also develop directly on the service using Azure's built-in features and functionality.

#1 Benefit: Lowered Overall Cost and Administration

In addition to lowering the overall cost of running multiple databases, SQL Database reduces ongoing administration costs because you don’t need a full IT team to manage any virtual machines, operating systems, or database software.

How to Purchase

SQL Database is sold as a service, not with a license. In order to limit your cost exposure, clients will need to manage and monitor what is in use along with what can be scaled back to reduce subscription fees.

Administration

With SQL Database, you can continue to administer your database, but Microsoft takes care of the underlying hardware, can replicate data to provide high availability, configures and upgrades the database software, manages load balancing, and does transparent failover if there is a server failure. Ultimately, taking away the time-consuming administration duties.

SQL Server on Azure VMs

SQL Server on Azure VMs allows you to run SQL Server inside a virtual machine in the cloud. This falls under the Infrastructure as a Service (IaaS) category and is meant to extend on premise SQL Server applications to the cloud.

#1 Benefit: Customizability

If you already have a full-time IT staff and need administrative rights, yet desire a fully customizable setup, SQL Server on Azure VMs is optimized exactly for your scenario.

How to Purchase

Traditional SQL Server licensing is available for SQL Server on Azure VMs. Customers with current software assurance have the ability to run use that license to cover their instances of SQL within Azure. If there is a workload running full time, it is typically less expensive to purchase the SQL than to subscribe to it in scenario 1. 

Administration

SQL Server on Azure VMs makes it possible to keep control over database location down to the location of the disk. You can upgrade on your own schedule.

When deciding what public cloud option is right for you, assess your situation first and determine which workloads fit which cloud scenarios best.  Keep in mind that you may want to reuse licensing that may already be used to run the same workload on premises. 

Whatever your situation, Interlink can help you determine the best fit and then take the right next steps from there. Contact Interlink.

SQL Modernization Assessment Ad

Matt Scherocman

Top 5 Benefits of Microsoft Azure SQL Database

Top 5 Benefits of Microsoft Azure SQL Database

The question of whether or not to put your business data in the cloud is getting easier and easier these days and a lot of that is thanks to Microsoft’s investment in Microsoft Azure. Their strategy to create an infrastructure, like Microsoft Azure SQL Database, that can manage big data (as big as petabyte-scale) and everything on down from that is working and it’s working well.

The advancements made in SQL Database are making it more and more possible businesses of all sizes to save money and scale up or down efficiently. Below are the top five benefits that companies are realizing with SQL Database as their database service:

1) Scalability and Beyond

First of all, flexible service plans for SQL Database meet the needs of both big and small business users. SQL is no longer way out of reach for smaller operations because the pricing structure allows users to pay as little as $4.99 per database per month with a maximum storage set at 150 GB per database. That’s a lot of space for very little cost.

Microsoft Azure SQL Database

2) High Speed and Minimal Down Time

High availability architectures mean high speed connectivity and data retrieval as well as low down time at your organization. There’s nothing worse than stopping business because your technology can’t keep up, but that is no longer a problem with SQL Database.

Secondly, companies can add application instances as needed through sharding, for example. Sharding is a type of database partitioning that separates very large databases into smaller, faster, more easily managed parts called data shards. Not only can you spin nodes up and down on demand, you can leverage a federation infrastructure to scale more easily without affecting other areas of the server. SQL Azure Federation Data Migration Wizardcan even further automate this process, which impacts your organization and the employees much less.

Lastly, there are multiple levels of implementation that you can benefit from. If you just need a website and a database, you can hitch a SQL Azure instance to an Azure website and you’re done! If you need a full-blownvirtual machine(VM) now or even down the road, you can get that as well. You can even use a locally deployed instance of SQL Server in the VM instead of SQL Azure. These implementation options help make your company more adaptable to the inevitable changes it undergoes on a regular basis. With SQL Azure, you’re not stuck. You’re on a foundation that encourages growth while working with it!

3) Improved Usability

SQL developers are familiar with all things SQL and SQL Database can be updated with SQLCMD or the SQL Server Management Studio. Better yet, there’s no coding required! Using standard SQL, it’s much easier to manage database systems without having to write or update a huge amount of code.

4) Time Is On Your Side

With no administrative duties on your physical location, employees can take time for strategic work to advance and grow all-around business success. When your database is hosted in the cloud, you don’t have to deal with setting up SQL Server, apportioning databases, and dealing with physical machine maintenance and upkeep. All of this results in better alignment of your organization and ultimately more time on your side.

5) Easy-to-Use Migration Tools

Ramp up time with SQL Database is now easier than ever and free! SQL Data Sync allows you to either sync your SQL Server-stored data or migrate the data without having to worry about the costs to migrate by syncing gigabyte-sized tables.

Take into account all that SQL Azure has to offer and contact us at Interlink if you have any questions. 

SQL Modernization Assessment Ad

Matt Scherocman

Three Ways Microsoft Enterprise Mobility Suite (EMS) Has Changed Everything

Three Ways Microsoft Enterprise Mobility Suite (EMS) Has Changed Everything

Looking at how technology has evolved, the cloud has certainly changed everything in terms of how we do business and what’s expected of us as a company. The cloud has created a ton of benefits and possibilitieslike the promise for users to be able to work anywhere on any device. That flexibility also created several challenges. Those challenges include security, device management, and data protection.

 
[...]
Matt Scherocman

How To Protect Your Users From Ransomware and Vicious New Maladies Hidden In Your Incoming Email

How To Protect Your Users From Ransomware and Vicious New Maladies Hidden In Your Incoming Email

Protecting Your Email with Exchange Online Advanced Threat Protection 

With the constant threat of malware, companies have to constantly find ways to stay ahead.  How do you protect your data from these threats when they are constantly evolving and becoming more aggressive?  Microsoft has a solution in Exchange Online called Advanced Threat Protection (ATP).  It is another layer of must-have security that Microsoft offers to meet all your business needs. 

[...]
Matt Scherocman

Top 5 Benefits to Upgrading Your SQL Server 2005 Databases

Top 5 Benefits to Upgrading Your SQL Server 2005 Databases

Time is winding down as extended support for SQL Server 2005 ends. For users still on this version, this milestone means no more hotfixes and security updates. In addition, you may also be missing out on a few very important benefits and costing your business more money.

By upgrading your SQL Server 2005 databases you can realize the five following benefits:

1. Better Compliance:

With an upgraded version of SQL Server, you can rest assured your data is protected and you’ll stay on top of regulatory compliance and internal security audits. As reporting requirements change and your business scales, make sure your systems are tracking every step along the way. The best way to do this is to stay current with SQL Server.

2. Faster Performance:

SQL Server 2014 delivers 13x performance gains relative to SQL Server 2005 and 5.5x performance gains over SQL Server 2008. If you’re looking to speed up your business processes and streamline operations, this is the area to focus on.

3. Reduced Total Cost of Ownership (TCO):

Azure Virtual Machines can help you reduce the TCO of deployment, management, and maintenance of your enterprise database applications as it’s all managed and maintained in the cloud instead of under your roof!

4. Easier Migration:

Microsoft Azure SQL Database has enhanced compatibility with SQL Server that makes it easier than ever to migrate from SQL Server 2005 to SQL Server 2014 and Microsoft Azure SQL Database. With helpful tools and support directly from Microsoft, upgrading does not have to be an overwhelming task that results in a ton of downtime for your business.

5. Short Payback Period:

You can maximize your IT spend by seeing a return on your investment quicker than ever! According to the Forrester Total Economic Impact of Microsoft SQL Server study, you can also experience a payback period of just 9.5 months for moving to SQL Server 2012 or 2014.


If you need help with your SQL Server Upgrade, Interlink offers a SQL MODERNIZATION ASSESSMENT or POC.

SQL Modernization Assessment Ad

These offers help you learn the right approach, technologies, and tools for a data platform modernization to either SQL Server 2014 and/or Azure SQL Database.*

Contact us today!

* Some organizations may qualify for free Microsoft funding to cover the assessment and POC.

Welcome to the Interlink Cloud Blog

All content provided on this blog is for informational purposes only. The owner of this blog makes no representations or warranties regarding the information from our partners or other external sources.

Blog Categories

Interlink Cloud
Interlink Cloud
6 post(s)
Tips and Tricks
Tips and Tricks
2 post(s)
Outlook
Outlook
2 post(s)
Reporting
Reporting
1 post(s)
Cloud Storage
Cloud Storage
2 post(s)
Webinars
Webinars
15 post(s)
OneDrive
OneDrive
5 post(s)
Yammer
Yammer
3 post(s)
Azure
Azure
20 post(s)
SharePoint
SharePoint
10 post(s)
Microsoft
Microsoft
6 post(s)
Lync
Lync
8 post(s)
Office 365
Office 365
59 post(s)

Blog Archive