Expert Roundtable: The ROI on SQL Server 2016

Published On: 2016-07-27By:

1. On a scale of 1-10, how vital is upgrading to 2016 in your opinion?

Denny: 9-10. This release is probably the biggest release we’ve seen since SQL Server 2005. Every system upgraded will benefit; from the improvements in Clustered ColumnStore, to increased throughput in Always On Availability Groups, to the enhancements of In Memory OLTP, not to mention the new security features. Watch the SQL Server 2016 training kit videos which Microsoft just released which feature our own Joey D’Antoni.

Joey: 7. There are a lot of other challenges (mainly with 3rd party applications), but if the customer has specific requirements and SQL Server 2016 meets them, the benefits are tremendous.

Kerry: 6. A lot depends on the version deployed, but SQL Server 2005 just went off support and 2008/R2 isn’t far behind. Third party application support may make an upgrade difficult in the near-term, but new features and performance enhancements make this a very worthwhile upgrade.

2. If a CTO is trying to decide whether to upgrade, any recommendations on how to evaluate the investment?

Denny: Companies that have been looking for ways to archive data out of their SQL Server database without code change to the application have features available to them in the Stretch Database feature. Companies looking to implement database encryption with little to no code change should be looking at Always Encrypted. These can be implemented with relatively little cost once SQL Server 2016 is deployed, offering a huge ROI.

Joey: Biggest thing is existing licensing agreements. If they have software assurance, there is no direct cost associated with the migration. Otherwise, it’s a matter of whether the applications they are using can support it so they can take advantage of some the new features.

Kerry: SQL Server 2016 is a worthwhile upgrade for any environment. The older the version(s) currently deployed, the more compelling the upgrade is, as that’s where the biggest improvements in raw performance of the database engine and increased feature availability will be felt.

3. Outside of DBA’s, what other departments are likely to experience substantial ROI with this upgrade?

Denny: Reporting teams will get great ROI with Clustered ColumnStore in SQL Server, especially those that don’t have ColumnStore indexes. General business departments will get better ROI through better uptime so they can services customers better and faster.

Joey: There is a tremendous amount of added value in the Business Intelligence side of things. SQL Server Reporting Services gets major upgrades and Enterprise Edition supports mobile reporting, which is beneficial to any end users of business reporting applications.

Kerry: Any department that utilizes SQL Server directly or applications that rely on it will be able to glean good ROI, as line-of-business applications will see an increase in performance simply because SQL Server 2016 just runs faster.

4. And now for the motherlode: how much is this going to cost, and are there any tips on what a company can do to make the licensing cheaper?

Denny: Customers that have Software Assurance are able to upgrade to SQL Server 2016 for free. Those that have an Enterprise Agreement for SQL Server may have credits on their Enterprise Agreement which can be used to help pay for consulting time to assist with those migrations.

Joey: You can get some full details on SQL 2016 licensing in long form on my blog.

Kerry: With Microsoft solidifying its software release cycle(s), Software Assurance is probably the best deal it’s ever been for companies interested in staying up-to-date and having the most flexible licensing structure.

Stay Informed

Receive exclusive technical updates and information

You’ll get exclusive technical information as well as information about about new and discounted services which we offer. Subscribe Now!


Contact the Author | Contact DCAC

Rise Services: Time Slice DBA and Disaster Recovery

Published On: 2016-07-01By:

With headquarters in Arizona, Rise is a nonprofit organization that specializes in home and community-based support services for children and adults with developmental and other disabilities, children with mental health challenges, aging adults and children and families with foster care and adoption needs. For 25 years their purpose has remained constant. They create opportunities for and with the people they serve, their families and for the men and women providing supports to their clientele.

Time Slice DBA

  • Payroll used to take 4 people a week to process. Now done by one person in 2 hours.
  • Billing has gone from 9 people working about 2 ½ weeks to 7 people compiling it in less than a week.
  • Audits used to take 5 FT employees a week. Now gives the auditor read-only access to the resources they require.

Disaster Recovery

  • Previous DR was onsite, local backups & tape backups.
  • DR now includes real-time replicating between two primary offices.
  • Can meet zero losses on databases and 24 hour recovery on all file servers.

Read Now >


Contact the Author | Contact DCAC

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner    Microsoft MVP    Microsoft Certified Master    VMWare Partner    VMWare vExpert
   Best Full-Service Cloud Technology Consulting Company    Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers