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.

 

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

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(*.azurewebsites.net).
• 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.