April 12, 2016 – Just 1 More Day For Microsoft SQL Server 2005 – Rest in peace!

This means there will be no further security updates, increasing the likelihood of added costs to maintain legacy servers against interruptions and intrusions.

SQL Server 2005 support ends April 2016 – Here’s why that’s a good thing

You need to kick things into high gear, as Microsoft is ending support for SQL Server 2005 on April 12, 2016. The platform has been supported for a decade and Microsoft will no longer be patching the software after this date.

MS SQL-Server-2005 End Of Support



If you are looking to get out of this situation, Microsoft recommends that you move to SQL Server 2014 or Azure SQL database. If ensuring business-critical performance, maintaining security and compliance, and optimizing your data infrastructure are important to you, Sysfore has the tools and resources to support your migration from SQL Server 2005.

Sysfore offers you a Free Assessment to move your workloads to:

  • Microsoft Azure
  • Microsoft SQL Server 2014
  • Microsoft SQL Server On-Demand
  • SQL Server as a Service

Now’s the perfect time to deploy Microsoft SQL Server 2014. It enables faster data processing and performance, but that’s just the beginning.

Another update is that Microsoft will be releasing SQL Server 2016 this year but at this time (and it is also headed to Linux), it is not ready for general release and is still in the late-phase testing. You can try out that platform too but only 2014 is considered ‘production grade’.

If after April 12 you are still running SQL Server 2005, the software will continue to function but if any new exploits are found in the software, they will not be patched. In short, by running Server 2005 after this date you are putting your data at risk and more importantly, this software will become a line item on a security audit.

You can leverage Sysfore’s Technical expert in Cloud Databases and Storage by getting your Free Assessment. In addition to this, Microsoft has put together a page providing resources that will be of assistance if you are planning on upgrading from SQL Server 2005 to any other version; you can find that resource here.

Forget to upgrade your database and you’ll get into trouble putting your data at risk!

Call us at +91-80-4110-5555 to book your appointment with Sysfore or mail us at  info@sysfore.com.

Microsoft Build Developer Event 2016 – Azure Makes IoT Even Easier for Businesses

Build 2016

Adds Azure IoT Gateway SDK and Device Management to Azure IoT Hub

Microsoft held their annual developer conference called Build out in San Francisco. The three-day event from March 31 to April 1, had various Microsoft executives detailing and demonstrating the vision for computing. There were hundreds of mini-seminars on Windows development detailing what is new.

At Build 2016, Scott Guthrie, executive vice president of the Cloud and Enterprise Group, and Qi Lu, executive vice president of the Applications and Services Group, demonstrated how Microsoft Azure services and the Office platform can empower developers to easily leverage advanced analytics, machine learning, emerging cloud development models and the Internet of Things (IoT) to build their intelligent apps.

Azure Internet of Things (IoT) gets a boost

Two new offerings were announced that make it significantly easier for customers to manage their IoT deployments: Azure IoT Hub device management and the Azure IoT Gateway SDK. The preview of these powerful new capabilities, shows Microsoft’s support for providing developers, IT managers and OT operators with tools to make managing their IoT deployments easier than ever.

Drop by Sysfore Technologies, to get the latest information on the Azure IoT Hub device management and the Azure IoT Gateway SDK.

The diverse Internet of Things (IoT) environment is mixed with many types of devices with different software, firmware, connectivity and security capabilities dispersed geographically . For many businesses, it’s a challenge to keep the software, firmware and configuration of new devices up to date.

They also need to connect to older or legacy devices to communicate directly with the cloud. The new offerings address these challenges and continues to simplify IoT, so customers can focus on development instead of the logistics.

Azure IoT Hub device management

The device management feature in Azure IoT Hub allows enterprises to remotely maintain, interact with, and manage IoT devices at scale from the cloud using accepted open source standards. Administrators can enroll, view status and health, organize, control access, and update the software, firmware and configurations of millions of geographically dispersed IoT devices.

Customers can now realize significant time and resource savings by removing the burden of developing and maintaining custom device management solutions.

Azure IoT Hub scales to manage millions of devices supporting the LWM2M protocol, the leading standard from the Open Mobile Alliance (OMA) for IoT device management. The IoT Hub device management enables a simplified cloud programming model for IoT solutions through new service side APIs:

  • Device Registry Manager API:Provides a first-class device object for working with IoT devices in your cloud solution. Through this device object, your cloud solution can interact with device and service properties, which is used by the device for configuration or to inform the IoT solution of device state (e.g. firmware version, OEM name), service properties, such as tags etc.
  • Device Groups API:Work with your fleet of devices in groups and control access in a way that maps to your solution topology.
  • Device Queries API:Find devices in your IoT solution based on tags, device, or service properties.
  • Device Models API:Define the information model for the devices and entities in your IoT solution.
  • Device Jobs API:Run and monitor simultaneous device orchestrations on your global fleet of devices across a heterogeneous device population.

Azure IoT Gateway SDK

The Azure IoT Gateway SDK enables businesses to connect legacy devices and sensors to the Azure cloud without having to replace existing infrastructure. And for developers, the SDK helps to easily build and deploy “edge intelligence” modules that optimize and process data before it’s sent to the cloud, allowing your business to benefit from minimized latency, reduced bandwidth costs, and more effective enforcement of security and privacy constraints.

The Azure IoT Gateway SDK achieves this by providing source code that takes care of much of the necessary busy work required for the development of a gateway application, including dynamic module loading, configuration, and data pipelining.

Get the latest information on the Azure IoT Hub device management and the Azure IoT Gateway SDK from our IoT specialists. Mail us at info@sysfore.com or call us at +91-80-4110-5555 to leverage the new updates using Sysfore’s IOT Suite.


Managing Cloud Identities in Hybrid Cloud

As companies add more cloud services to their IT environments, the process of managing identities is getting more complex . When companies use cloud services — services they don’t control themselves — they still must develop sound policies around role-based access. They still must grant rights to users who need information to get work done, and they must be able to automatically take away those privileges when people leave a company or change roles. On top of it all, companies using cloud services are also bound by any compliance rules that govern their identity and access management (IAM) initiatives.

Businesses now have to deal with a collection of cloud services, that hold sensitive data obtained from new logins and proprietary connector APIs that often don’t work well with internal IAM systems.

Read more