Office 2007 Retirement Is Coming!

Systems Engineer Chance WebsterChance Webster – [Systems Engineer]

On October 10, 2017, Microsoft will officially retire all editions of Office 2007.  What does this mean for you?  Microsoft will no longer offer updates or provide free or paid support for the Office 2007 family of products.  If you have not upgraded the Office suite for one or more of your PCs, this would be the perfect time to consider a more recent version of Microsoft Office.

Microsoft Office 2007 LogoOne reason to upgrade is that newer versions of Microsoft platforms such as Exchange and SharePoint will not interact with the Office 2007 platform.  Also, newer versions of Office do not interact properly or at all with older, unsupported platforms.  For example, Outlook 2016 does not work with Exchange 2007 – which is 3 versions lower in the Office family.  Likewise, Outlook 2007 does not connect to either Exchange 2016 or Exchange Online.  Both of these concerns could add more unplanned costs when planning for an on-premises Exchange or SharePoint upgrade project.

Microsoft Word 2007 IconAnother reason to upgrade is based on Microsoft’s policy change concerning Office 365 and Microsoft Office in the future.  The good news is this policy change does not fully take effect until October 13, 2020, so there is time to consider your upgrade options related to your on-premises infrastructure or any cloud initiatives.   For more detail, please see this policy change here: https://blogs.office.com/en-us/2017/04/20/office-365-proplus-updates/.

The following are alternatives to consider:

  1. Do nothing. This option is NOT recommended.  There are several exploitable vulnerabilities that rely on unpatched versions of Microsoft Office products.  Due to no additional patches being developed for Office 2007 after October 2017, continuing use of Office 2007 products would create a security risk for your organization.
  2. Purchase new Office licenses. This can be achieved via direct purchase through many resources, however this option provides only the current version of Office.  The Software Assurance option would need to be purchased via a Volume License agreement to provide you with future versions of Office at no charge.
  3. Purchase an Office 365 subscription. Office 365 suites that include Office licensing provide an array of benefits.  Not only would you get Office licensing for users licensed under a supported suite, you would also be able to take advantage of hosted platforms for Exchange, SharePoint, and Skype for Business.  This can provide a significant cost savings for your organization and reduce the technical burden often added when these technologies are deployed.

For more information about how Keller Schroeder can assist your organization with migrating to Office 365, please contact your Select Account Manager.


If These Devices Could Talk

Keller Schroeder Applications Consultant Eric MaurerEric Maurer – [Applications Consultant]

What if your devices could talk? The Internet of Things (IoT) can start to do this! What is the IoT? Putting it simply, an IoT “thing” is nothing more than a physical device connected to the internet. The device can be your phone, your thermostat, a car, or any number of remote monitoring sensors. Experts estimate that by 2020 there will be about 30 billion IoT devices. There are devices that only 15 years ago did not exist for collecting data, or if they did exist, they were so remote getting to the data was difficult.

Internet of Things CollageRecently Keller Schroeder employee-owners Eric Maurer and Ian Welsh participated in an IoT Hackathon sponsored by AT&T. This hackathon provided opportunity to learn about new devices and software from AT&T in the IoT landscape. Devices, becoming smaller than ever, are now capable of running for weeks using batteries or solar power and can transfer data captured by dozens of different sensors over Wi-Fi, Bluetooth, or LTE.

Their team quickly realized the difficult part of developing an IoT solution is no longer centered on hardware and software but comes from using industry knowledge to find the right problems for which IoT is the solution. They decided to use AT&T’s LTE enabled IoT starter kit to collect real-time GPS data from commercial vehicles to collect and process their location and mileage information automatically. Their idea was just one of many great ideas that came out of the hackathon. Some of the other projects were:

  • Using drones to take pictures of tomato fields to determine overall ripeness and calculate the perfect time for harvest with image processing algorithms and machine learning
  • A smart tool locker using Bluetooth and NFC sensors to allow users to check equipment in and out
  • A small device with humidity and PH sensors to monitor soil in home gardens

The latest generation of IoT devices now connect securely to the cloud using Microsoft’s Azure or AT&T’s M2X. These solutions allow you to secure your devices and aggregate data from any number of devices and sensors in one central location. They also provide dashboards, event notifications, alerts, and two-way communication between devices. Sifting through the large amounts of data one can collect can be daunting. Companies are making it easier and easier to collect, process, and make sense of this data using cloud-based software, such as Azure Stream Analytics.

What would you do with IoT data? Have ideas and want to explore them further? Contact your Keller Schroeder Select Account Manager or call us at 812-474-6825 today!


Veeam + Azure: Cost Effective & Flexible Cloud Backup

Matt Barton – [Senior Consultant]

Ok… 3 Questions, 30 Seconds, 300 Words…. about your backup solution.  This shouldn’t take long.

 


Question 1 :   Do you have an off-site backup? 

Yes?  Great!

No?  Why Not?  Using Veeam & Azure, quickly and easily create a cloud off-site backup, that is cost efficient & scalable based on your needs. Configure Veeam to backup the most critical data for DR, or provide long-term retention using cost-effective cloud storage. Azure charges are based on actual used capacity.  Unlike other cloud offerings or on-premises equipment, this solution provides a true consumption model, allowing you to shrink or grow the amount of data being backed up to more effectively manage costs.


Question 2 :  Does it meet the 3-2-1 rule?

The “Golden Rule” of backup.  The 3-2-1 rule states having three copies of your data – 2 on different media, and 1 copy offsite. We highly recommend Veeam integrated snapshots on Nimble Storage, copied to a Cisco UCS backup appliance, & then copied off-site to Azure.


Question 3 :  Are you able to backup Office 365 data?

You need to securely backup Office 365 email data back to your environment for a variety of reasons; to follow the 3-2-1 Rule of backup, to facilitate eDiscovery, and to meet internal policies and compliance requirements. The most important reason being the peace-of-mind that comes from knowing you will be able to restore your users’ data when needed!

With Veeam Backup for Microsoft Office 365, you can retrieve Office 365 Exchange Online mailbox items (email, calendar, and contacts) from a cloud-based instance of Office 365 and uniquely back up this mailbox data into the same format that Microsoft Exchange uses natively — an archive database based on Extensible Storage Engine (ESE), also known as the Jet Blue database.


Interested in hearing more or want to schedule a Veeam & Azure Demo?  Reach out to your Keller Schroeder Account Manager today!


Evansville’s SQL Server 2016 Discovery Day

Rob Wilson  – [Business Unit Director – Applications Solutions]

PASSRecently, Keller Schroeder hosted the local SQL Server 2016 launch event, coordinated by Ed Rhodes of the local Professional Association for SQL Server (PASS). Ed Rhodes of Walt’s Drive-A-Way leads the local PASS chapter with Pat Minnis of Vectren. The Saturday event consisted of presentations and demos by Ed, followed by video presentations of what is new in SQL Server, and a friendly group competition to “hack” the new SQL Server 2016 features.

Some of the great new features explored at the SQL Server 2016 Discovery Day were:

  • Security updates such as column-level encryption and encryption at rest
  • Data masking
  • Major updates to SQL Server Reporting Services (SSRS)
  • Analytics and performance monitoring
  • JSON support

You can learn more about the SQL Server 2016 features here: https://www.microsoft.com/en-ca/server-cloud/products/sql-server/Features.aspx

SQL-Server

 

Without a doubt, this is the most anticipated SQL Server release in recent history. The added features in addition to the performance enhancements make a strong case for organizations to take a look earlier rather than later.

The group competition at the event was won by a team of DBA’s who scripted solutions around the new security enhancements. This team (made up of Terri Smith and Evans Owusu of SpringLeaf, Todd Greenwell and Shawn Repphan of Old National, and Kael Dowdy of Keller Schroeder) won $50 gift cards provided by Microsoft and the national PASS organization. It was a great day of camaraderie and round table discussions. We thank everyone who joined us, and thank Ed for his leadership and coordination of the event.

IMG_4119

 

For more information on our local technology groups, please visit www.evansvilletech.com. Our user groups are a great local resource for IT professionals to receive free training and collaborate with other professionals over a long lunch break (meal provided). For more information on how Keller Schroeder can assist you with your SQL Server 2016 migration, please contact your account manager.

 


Microsoft Goes Cross Platform?

Microsoft LogoEric Maurer  – [Consultant – Applications Solutions Group]

Things have been changing recently within the Microsoft ecosystem.  You no longer have to decide to be a Microsoft shop or embrace anything but Microsoft. They are fulfilling their original promise for .NET to be a platform that can be written anywhere and run anywhere. Microsoft has now embraced open source, blurring the lines between the two camps.  At a recent user group meeting, I talked to users who were running Linux Bash on Windows 10, installing Microsoft SQL server on Linux, and developing iOS and Android applications using C#.  You can also now run Linux on Azure, and since the .NET Core has been open sourced, you can now run ASP.NET on Linux or Mac as well.

Being a mobile developer, I was ecstatic to learn of their newest acquisition and open source release: Xamarin.

What is Xamarin?xamarin-logo

No, Xamarin is not the latest drug being pushed on late night commercials. It is a software company that allows you to deliver native iOS, Android, and Windows apps using your existing .NET skills, teams, and code. Xamarin was founded over four years ago with a mission to make native mobile development fast and easy. They wanted to allow C# developers to share their code across platforms to reach billions of devices. Those four years have been highly successful for them, as they boast having over 1.3 million developers and 15,000 companies using their software to develop apps across the Apple, Google, and Microsoft ecosystems.

Rumors have been circulating for years about a Microsoft acquisition of Xamarin. First, they worked together to create tight integration with Visual Studio, and Microsoft undoubtedly helped develop the Mono framework now maintained by Xamarin, if only unofficially.  Next, they worked together to offer a limited Start Edition free with Visual Studio and discounts and training through Xamarin University for MSDN subscribers.  Yet they stayed two separate companies until February 24, 2016, when Microsoft announced it had signed an agreement to acquire Xamarin.

NATIVE, EVERYWHERE, and now OPEN SOURCE

xamarin-joins-microsoft

Why Xamarin?

Keller Schroeder has been using Xamarin for over three years and has employed it to develop apps for iOS, Android, and Window Phone. Xamarin enables us to take advantage of the productivity and power of .NET and to use C# to write to the full set of native APIs and mobile capabilities provided by each device platform. Depending on how you architect your solution, you can realistically obtain 80% or more code reuse between apps. Having one code base reduces the chance for errors and makes same day deployments much more feasible. It also allows for a faster ramp up for new developers and makes maintenance much easier, as changes often only need to be made in one place. Xamarin is also dedicated to providing same day updates with new iOS and Android releases so new features are available at the same time as they are to native developers.

Why Microsoft and Xamarin is Even Better

“Everything you need to run Xamarin apps on any OS, any device, is now open source,” Scott Guthrie, executive vice president of the Cloud and Enterprise Group at Microsoft, declared at the Build conference. What does that mean to us?  Let’s start with the obvious reason: it is now free with Visual Studio!  Though it doesn’t take long to recoup your money, Xamarin wasn’t cheap and licensing was sometimes confusing. What I think is really more important is that Microsoft has already taken steps to tighten Xamarin integration with Visual Studio and Azure. Their goal is to allow Visual Studio to easily connect to your Mac and for your app to communicate seamlessly with Azure. They are also unveiling new Xamarin.Forms enhancements to allow for a shared UI and adding a Test Recorder in Visual Studio to make creating unit tests easier as well. Having Microsoft fully behind Xamarin is going to solidify its position as the best option for cross platform native apps well into the future.


“Are You Azure It’s a-Ready?

KS Spaghetti

Rob Wilson[Business Unit Director – Application Solutions]

Hint: You have to say it with an Italian accent, like “That’s one spicy a-meatball!”

In our neck of the woods, folks tend to watch with a curious skepticism as the bleeding-edge early adopters go through the pains of “beta testing” newer technologies. Some call it “reluctant to change” and others call it “conservative”. We level-headed, hard-working mid-westerners simply call it “prudent”. While we have all likely seen an uptick in cloud adoption, many of our clients are still being…prudent…and that’s understandable. Hopefully by now, you know our philosophy that all solutions do not belong in the cloud, and you should choose what is best for your business case. However, some solutions do make the most sense to run in the cloud, and Hybrid Cloud (cloud technologies working in conjunction with on-premises technologies) is what we believe will be the norm.

As a MicrKS Azure Logoosoft Gold Certified Partner, one of our go-to cloud platforms is Microsoft Azure. We have been prudent as well regarding Azure. Even as we adopted Office 365 for Email (Exchange Online) and collaboration (SharePoint Online), we took a more conservative approach with Azure. Our chief concerns were about the stability of the platform and the rapid pace at which the services and administration tools seemed to change. We stayed in close contact with Microsoft and other partners, and the message that seemed to resonate was: “Azure services are mostly being adopted for development and testing environments, but there has not been a significant increase in production adoptions.” Microsoft was working hard to address concerns, and we continued to grow our experience through application development in our lab environments.

Fast forward many months, and now the scale is starting to tip. Microsoft Azure has continued to evolve at a rapid pace, claiming a decent amount of market share and adding to its customer list. We have watched prices drop, services added, and more consistent user experiences. We have used Azure in production environments and it has proven to be a cost-effective, reliable alternative – at least for the use cases where we have employed it. We have used Azure Virtual Machines for several internal and client use cases – including public web sites, web services, extranet applications, and reporting dashboards – and Microsoft has remained true to the up-time promised in their Service Level Agreement. This approach has helped some of our clients avoid incurring the cost of additional hardware and even reduce the project timeline. As one of my clients put it (paraphrased): “I’m in the manufacturing industry, not IT. Put the solution where it is cost-effective, easy to manage, quick to deploy, and reliable. I’ll stick to making what I make.”

Currently, we are working on projects that utilize the SQL Database services and App Services, just two of the many services now offered on Azure. We have clients and partners exploring other services as well. If you are interested in knowing what we have tried and what we have not, please reach out to us and start the conversation. You can “rest Azured” (that was bad) we will be transparent.

 


Windows Licensing Change – Processor to Core-Based

Dezarae Loewen -[Inside Product Manager & Microsoft Licensing Specialist]2015 Partner Logo

Microsoft is looking to release the newest version of Windows Server sometime in the second half of 2016. With this new significant product release, comes a change in not only the product but the licensing structure as well.  This article will take a look at a few of the new changes that Microsoft has made to Windows Server.

Windows Server 2016 will continue to come in both the Standard and Datacenter versions.  However, there now will be more differences between the two than just virtualization rights.  Datacenter will now include additional storage replication capabilities, a new network stack, and a new shielded virtual machines and host guardian service.

The major change with this new release is that the licensing moves to a per core model.  Windows Server 2016 will use a 2 core pack instead of the processor based model in Windows Server 2012. To license a physical server, all physical cores must be licensed with a minimum of 8 core licenses per physical processor.  The minimum cores per physical server is 16 cores.  Microsoft has stated that the price of the 16 core license of Windows Server 2016 will match the price of the 2 processor license of Windows Server 2012.  Those systems with up to 4 processors and up to 8 cores per processor should not see any change in cost from Windows 2012. However, pricing can get more expensive than the previous licensing model the higher the processor core count on each physical server.  This change to a per core license model does not do away with CAL requirements.  Windows CAL’s will still be required for each user and/or device accessing a licensed Windows Server.

2016 Server Licensing

With this expected release coming later this year, now is a great time to purchase Windows Server 2012 with software assurance.  By adding software assurance to your Windows purchase today, you will be guaranteed the right to a free license upgrade to Windows 2016 at its release. Once the software assurance term ends, the processor licenses will then be exchanged for a minimum of 8 two-core pack licenses or the actual number of physical cores in use.

For any additional questions, please contact your Keller Schroeder Account Manager for more information, including what Software Assurance and migration benefits your company is eligible for as well as how to purchase new licenses before these changes take effect.


New Year’s Resolutions for Application Owners & Managers

Rob Wilson[Business Unit Director – Application Solutions]

2016 Goals

Just in case you were having a hard time coming up with your goals and objectives for 2016, we wanted to pitch in and help. We asked some of our application developers, architects, and owners to contribute New Year’s resolutions for software application professionals. If you are responsible for owning or supporting an application at your organization, this list is for you.

Check your logs

Make it a goal to monitor your application logs proactively. It could be that errors are occurring behind the scenes that do not surface on the display. Proactively monitoring your application logs may help you identify smaller issues before they become large ones.

Upgrade your solution

Are you at the current release in your packaged software? Do you have a custom written app that was developed for an older version of .NET, Java, or another platform? If so, you may be missing out on some of the latest features or making yourself vulnerable to security risks that have been addressed in future releases. Make it a goal to get your packages and platforms up to date.

Archive and purge old data

If you have data that is old and irrelevant to your existing applications, it may be taking up needed space and causing performance degradation on your servers. Resolve to archive and purge that data in 2016 and maybe you will get a performance boost in your data intensive applications.

Give some needed attention to your mission critical applications

Have you developed mission critical applications in Access, Excel, or another platform that they have outgrown? Bite the bullet in 2016 and rewrite those applications on a more robust, multiuser platform such as .NET, Java, or SharePoint. The advantages will be immediately recognizable.

Make your web site mobile friendly

If you did not get the message in 2015 that Google will not include non-mobile sites in its mobile index, then you need to get motivated right away. Mobile devices are prominent. Google has said that more searches are performed now from mobile devices than from desktops in some regions. If the Google threat alone does not motivate you, focus on the improved user experience you will be providing to your employees, customers, and prospects.

Get a handle on your source code

Is the latest source code for all of your custom applications checked in to a central repository? Is it backed up regularly? If one-off applications do not make it into the repository, or if developers do not check in their latest revisions at the appropriate times, then you may put yourself in a precarious situation if those developers are unavailable or their workstations are compromised. Make 2016 the year you get a handle on the source code situation.

Have a security assessment performed

Do you have sensitive information in a database? Do you integrate with Active Directory or another directory service every place that you should? For every high profile data breach that hit the news in 2015, there were more data breaches that went unreported and possibly undetected.  Learn from the mistakes of others and have a security assessment performed by an experienced, quality partner.

Learn something new

There are plenty of free online resources that you can use to keep your skills relevant and up to date.  Try GitHub (https://github.com/vhf/free-programming-books), YouTube (https://www.youtube.com), or the free Pluralsight (https://www.pluralsight.com) subscription that comes with a MSDN license.  Spend a few hours to make sure your next project takes advantage of the latest software tools and runs as efficiently as possible.

If you need assistance accomplishing any of your Applications New Year’s Resolutions, contact your Keller Schroeder Account Team. We are here to help!

 


Azure Rights Management Service from Microsoft

Microsoft Azure

Chance Webster – [Systems Engineer]

We have all seen stories on the news about company information being accidentally disclosed because of employee error or stolen during a breach of a company’s security infrastructure.  In many cases, company’s data is critical and confidential, and protecting this vital asset is a high priority.  The problem that organizations often face is protecting the company’s data within a budget that adequately aligns with the risk of data loss.

 

While there are many solutions available, Microsoft has developed a strong solution with the Azure Rights Management Service which natively integrates with many applications already in use within the business.  The Azure Rights Management Service is a cloud based Rights Management platform that provides a holistic approach to protecting your information within the Office 365 platform.  This service allows information owners to maintain access controls over the data that is being sent via email, stored on portable media, or even within the organization.  In addition, Azure Rights Management can be configured to provide notifications, either on-demand or by using a Rights Management template, that the data has been accessed by authorized users or that unauthorized access has been attempted.  Additionally, as part of the Azure Rights Management Premium service, this same protection can be extended to your on-premise Exchange, SharePoint, and File servers without a need for additional infrastructure that typically requires significant effort to implement and maintain.

 

Azure Rights Management Devices

An additional feature of the Azure Rights Management service is the Office 365 Message Encryption service.  This service provides an easy to use email encryption platform that requires very little setup and integrates with your existing email infrastructure.  Internal users can easily encrypt emails without a need for cumbersome setup time or need to exchange email certificates with a recipient in order to send an encrypted message.  Recipients of messages encrypted by the Office 365 Message Encryption service will find it easy to use and without a need for any additional setup.

 

The Azure Rights Management service is included in the Office 365 E3 and E4 plans or available for separate purchase for use with other Office 365 plans.  For on-premise infrastructure or for additional features such as tracking of RMS protected documents, Azure Rights Management Premium is available for separate purchase or as part of the Enterprise Mobility Suite or Enterprise Cloud Suite.

 

For more detailed information on Azure Rights Management Service and how it may help with protection of your organization’s data, contact your Keller Schroeder Account Manager.

 

 

 


The Results are In

quality survey form with red pencil showing marketing concept

As a Microsoft Gold Competency Partner, Keller Schroeder annually participates in a customer satisfaction survey to gain valuable feedback regarding our services.

For the past 6 years, our clients have been asked to rate these services based on several key performance indicators. As in previous years, Keller Schroeder significantly outpaced partner averages in categories such as the quality of our products, customer satisfaction, and the technical competency of our staff. Our customers would also highly recommend Keller Schroeder, feel they receive great value from the services they receive from us, and are confident in our ability to meet their needs.

2015 Survey Results

AI-Gold-Black

Does your company need assistance with Microsoft? Contact your Account Manager at Keller Schroeder for more information regarding our Microsoft skills and how they might benefit your organization.