Sunday, May 01, 2016

Internet of Things: Visual Studio 2015 Community Edition and Arduino

Visual Studio 2015 Community is a one-stop tool by Microsoft for most things and you can use the same tool for working with Arduino/Intel line of IOT boards. However, a default installation of VS 2015 Community does not support these boardss. You need to install an extension available online as shown here:

Launch Visual Studio 2015 and click on Tools | Extensions and Updates...

In the search box for items online, type Arduino and Click search. Arduino IDE for Visual Studio get displayed in the results pane as shown.

 Click Download and the program starts downloading the VSIX (5.55.MB) installer.

It is now ready to install but accept the license terms and click Install.

It takes a little while to install and after it is installed you get the following message. You need to restart for changes to take effect,

Restart VS 2015 Community and there are items in Menu, Tools and Project where you can see that the installation has been effective.

vMicro menu item:
 New | Arduino Project

 Tools | Visual Micro

Now that you have installed the extension you can work with Arduino projects importing the Arduino 'Sketches' or creating from scratch.

Saturday, April 30, 2016

Must see video for SQL Developers

SQL Server 2016 is advertised to be the most significant SQL Server in recent times and has a plethora of new ideas and concepts. This presentation (over an hour long) really provides a great background for SQL Server 2016 which is in RC3 presently but appears to be on Azure (preview?) already.

This is a video that you must see if you are a SQL Database Developer. The presentation (nearly an hour, March 30, 2016 Build event) by Lindsey Allen and Tony Petrossian is really informative, helpful and well made.

The stated overview of the presentation was:
"Microsoft offers SQL Server and Azure SQL Database to help you develop great relational database applications. In this session you will learn about the top developer features coming in SQL Server 2016 which are already in Azure SQL Database. Additionally, you will see the latest investments in Azure SQL Database that enable you to easily manage thousands of databases and get the performance and security insight needed to build robust and secure applications in the cloud.
You can hear the full presentation with all the demos here:
(Day 1 of the Microsoft Build meeting. Lindsey Allen and Tony Petrossian March 30, 2016)

The following demos were presented to deliver the 'wow' impact (it is possible that I might have omitted some).
  • In-memory OLTP Demo nicely presented.
  • Always encrypted demo(Security schema, security policy  etc)
  • Dynamic data matching
  • SQL Injection/Auditing
  • Demo with Python script
  • Demo with Ruby
The video presentation is copied over here as well:

However, if you are short on time and just would like to glance over the slides they used, you may review the following images captured from the video as screen shots.




Thursday, April 28, 2016

Download and evaluate SQL Server 2016 RC3

 It is supposed to be the most significant SQL Server besting both Oracle and SAP verify it for yourselves at no cost.

You can download the 120 day edition from here after registering.

Three types of download (only 64-bit):


Hardware and software requirements (abbreviated):

  • .NET Framework 4.6, Installation setup installs.NET Framework
  • Network Software: Shared memory, Named Pipes, TCP/IP and VIA
  • Hard disk space: Minimum of 6GB
  • Drive/Monitor/Internet required.
  • Memory: 1GB
  • Processor: x64 bit 1.4GHZ
  • Processor type: x64 Processor: AMD Opteron, AMD Athlon, Intel Xeon with Intel EM64T Support and Intel Premium with EM64T support
  • No support for WOW 64

Here are the benefits of SQL Server 2016:
Enhanced in-memory performance provide up to 30x faster transactions, more than 100x faster queries than disk based relational databases and real-time operational analytics
◾New Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes
◾Built-in advanced analytics– provide the scalability and performance benefits of building and running your advanced analytics algorithms directly in the core SQL Server transactional database
◾Business insights through rich visualizations on mobile devices with native apps for Windows, iOS and Android
◾Simplify management of relational and non-relational data with ability to query both through standard T-SQL using PolyBase technology
◾Stretch Database technology keeps more of your customer’s historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner  without application changes
◾Faster hybrid backups, high availability and disaster recovery scenarios to backup and restore your on-premises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure

There are several different types of SQL Server 2014 available and details are here: Protection Status