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.

Installation

  • 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.

SetupSupport

 

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

ProductKey

 

 

SetupRole

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

Features

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

InstallationRules

  • Specify the instance name of the SQL instance.

InstanceConfig

ServerConfig

 

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

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.

Collation

 

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

SSAS

 

SSRS

 

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

InstallConfig

 

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

SSMS

 

SSMSlogin

 

  • 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

 

TSQL_Azure

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.

bigdata

ecommerce

  • 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.

storedata

processdata

MR

  • 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.

HDinsight

  • 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.

MSBigdata

  • 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.

HDFS

  • 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.

hdinsight_API

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.

azurewebmatrix

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

installingterms

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

AppRun

  • 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.

Signin

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

webmatrix_az

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