Wednesday, November 30, 2016

Get moving installing SQL Server 2016 SP1

SQL Server 2016 Service Pack 1 is released  and now generally available(GA).

According to the above release blog:

Many of the features (listed in the table here) available in Enterprise Edition are now available in several other editions as well after installing the SP1 (Standard, web, express and LocalDB).


SQLSrvrSp1_00

Note that Change Data Capture requires SQL Server Agent not available in Express and In Memory OLTP not possible in LocalDB due to security reasons

DBCC CLONEDATABASE added supports cloning of CLR, Filestream/Filetable, Hekaton and Query Store objects are available after installing SP1

DBCC CLONEDATABASE  (source_database_name, target_database_name)    –– Default CLONE WITH SCHEMA, STATISTICS and QUERYSTORE metadata.
DBCC CLONEDATABASE  (source_database_name, target_database_name) WITH NO_STATISTICS                                                                                               –– SCHEMA AND QUERY STORE ONLY CLONE
DBCC CLONEDATABASE  (source_database_name, target_database_name) WITH NO_QUERYSTORE                                                                                              –– SCHEMA AND STATISTICS ONLY CLONE
DBCC CLONEDATABASE  (source_database_name, target_database_name) WITH NO_STATISTICS,NO_QUERYSTORE                                                          –– SCHEMA ONLY CLONE

New Create/Alter supports modifying and deploying database objects such as
Stored Procedures, 
Triggers, 
User–Defined Functions, and 
Views

This is just a short list from more than a dozen others. Make sure you visit the link referenced at the top.

The SQL Server 2016 Enterprise specific sample database, WorldWorldImporters can now be used in Standard and Express editions.

Download SQL Server 2016 SP1 here .

Sunday, November 27, 2016

IoT and changing direction of Intel XDK

If you have been using Intel XDK to build apps both HTML5 based and native apps, there is going to be (actually has been going on) a change in the direction. A number of frameworks were used with Intel XDK in the designer. You might have noticed that the number of frameworks are being deprecated. Presently, in version (the latest) 3641 only the Twitter Bootstrap is currently supported and the others are being deprecated.

Intel XDK is going to focus more on IoT apps. The other apps are not going to be supported in the Intel XDK. Since most of the technologies used in developing non-IoT apps are mature, Intel XDK will get provide documentation help to use these technologies.

This is according to Paul, one of the Intel XDK moderators:

" it's not that there is a benefit for developing IoT apps over mobile apps, they are quite different apps; the point is that we are focusing the tool to emphasize IoT app development, especially since the free and open-source tools available for developing, debugging and building Cordova mobile apps have now become quite mature. We will continue to support the development of Cordova mobile apps, but will rely more heavily on these freely available tools, rather than try to compete with them. The product today supports the creation of two basic types of apps: IoT apps and mobile Cordova apps. When we say "IoT companion apps" we simply mean a mobile Cordova app that is focused on working with an IoT app and any supporting IoT cloud services. As the product progresses it will make more sense."



In version 3641




That going forward the emphasis will be on IoT apps makes great sense from the point  view of Intel Corporation. Intel Corporation makes IoT boards of different kinds and will be investing a lot of effort on IoT.

What better way can be there than this change of direction.

More here for all comments on related topic:
https://software.intel.com/en-us/forums/intel-xdk/topic/700951

Wednesday, November 16, 2016

Visual Studio 2017 RC available

Visual Studio 2017 RC! is now available for download. Download here for free (during trial period):
https://www.visualstudio.com/vs/visual-studio-2017-rc/



VS2017RC_00
I am not sure probably it also went by the name Visual Studio "15".

Read the release notes here as it provides you with most of the enhancements to the IDE; layout for off-line installation; new commandline installation;code navigation related improvements and many more. The release note runs several pages covering all aspects of Visual Studio.
Download release notes here:
https://www.visualstudio.com/en-us/news/releasenotes/vs2017-relnotes

Interesting about the installation is there is a new installer which has good features:

  • Reduce the minimum footprint of Visual Studio.
  • Install more quickly with less system impact, and uninstall cleanly.
  • Make it easier for you to select and install just the features you need.
Earlier you had editions targeting Windows Desktop, Windows Web etc.

There seems to be Visual Studio Community 2017 (yours to keep edition) but I cannot find any links to it except this one:

https://www.visualstudio.com/en-us/productinfo/vs2017-system-requirements-vs

You will hear from me here when I find it.
DMCA.com Protection Status