Step by Step Installation of SQL Server 2014 CTP1 & work with SQL Azure database on SSMS 2014 CTP1

SQL Server 2014 CTP 1 was already announced in TechEd 2013 North America , which is available now for download as community technology preview. You can download now SQL Server 2014 CTP1 from here.

SQL Server 2014 CTP1 has an added support for in-memory OLTP processing, 99.95% High Availability Always On preview features & focuses more on Data Explorer (Microsoft HDInsight) along with Lambda Architecture preview.

  • Lets check for a quick step by step installation guidelines of SQL Server 2014 CTP1 on Windows Server 2012 Datacenter edition.


  • Click on Installation option to start installation of a new instance of SQL Server 2014 CTP1 edition, alternatively , you can upgrade from SQL server 2012 SP1 instance from Update section.



  • Specify Evaluation edition of SQL Server 2014 CTP 1 version.





  • Lets select the features available required for SQL Server 2014 CTP1 standalone instance.


  • Click on Next in order to start the ‘Installation Rule Engine‘ for SQL Server 2014.


  • Specify the instance name of the SQL instance.




  • Next , specify the authentication mode & setup password for SQL Server authentication.



  • As you can see , in SQL Server 2014 CTP1 , there is default checking of Collation settings for Database Engine & Analysis Services. You can customize it.



  • Next, specify settings for SSAS 2014 & SSRS 2014.





  • Finally , execute the instance configuration rules & start installation.



  • After installation , click on SSMS 2014 CTP 1 & login with your Windows Authentication/SQL Server Authentication credentials.





  • Also, you can work with your Windows Azure SQL database too with SQL Server Management Studio 2014 CTP1 , you can login in with SQL Azure database credentials from SSMS 2014.

SQL Azure Login



A lap around of Big Data with Microsoft HDInsight

Big Data synonyms with three V s :  Volume , Velocity & Variety. Even with traditional e-commerce system to modern social networks  all systems data conservation is dependent on this platform. Lets check a scenario of modern e-commerce analytic s after integration with Big Data.



  • Big Data platform typically works by storing data first into clusters , then process the data through MapReduce workflows which executes by Mapping the input data through independent chunks processed by appropriate algorithms, the output from Map phase then moves to Shuffle/Sorting phase & finally the output from Shuffle phase comes to Reduce phase as input.
  • Lets check a typical Big Data MapReduce workflow.




  • Microsoft’s BigData platform works exactly same way as a collaborative solution with Horton Works named as Microsoft HDInsight. Which typically simplifies the solution of running complex batch scripts. Lets cover a little insight of HDInsight/Hadoop ecosystem.


  • Microsoft’s Big Data platform unveils solutions from storing data into HDFS to query processing on Hive up to implementing Business Intelligence analytics on Excel Powerpivot, Powerpivot, SSAS & SSRS solutions.


  • Storing data into HDFS : Petabytes to Zetabytes of data to be stored in HDFS clusters by means of Name Node followed by Data Nodes, in Azure HDInsight each Data Node is integrated with a worker roles & compute cluster. Alternatively , you can leverage the solutions using Azure Blob Storage utilizing  Front End(attaches OAuth/Security layer for authentication), Partition layer: for mapping with Azure Queue, table & blob storages , Stream layer : 3 layer HA for scaled out data stream.


  • In order to programming on HDInsight , you can opt for Java, C#, F#, .NET, .js API, LINQ to Hive APIs which leverages to code on hadoop ecosystems including hadoop pig, hive, mahout, cascading, pegasus.


Microsoft's Hadoop Vision

Microsoft’s Hadoop Vision

Implement Windows Azure Websites from Web matrix 3 installed from Windows Azure Management Portal

Recently it has been announced the availability of Web matrix 3 as mentioned  here. You can now install Web matrix in order to work on Windows Azure Websites from Windows Azure Management Portal itself as shown.


  • If  click on Webmatrix icon , you would be forwarded to following dialog.


  • Lets install the Web matrix tool in order to start coding on Azure websites.


  • After installing , lets start coding with latest interface & run directly the app with Azure website URL(*
  • You can sign in directly using your Microsoft Account or Org id in order to run your app on Windows Azure from Web matrix 3.


  • Once you sign in , you are good to go to work on code on Windows Azure websites as followed.


  • Even you can run the application from Remote server as configured from Web matrix 3 settings.
%d bloggers like this: