Author Archives: Dr. SubraMANI Paramasivam

ByDr. SubraMANI Paramasivam

Try SQL Server 2016 Release Candidate 3 in Azure Virtual Machine today

Don’t waste your monthly credits and if you have some you can always spin it up with Azure virtual machines to try the SQL Server 2016 RC3 Evaluation on Windows Server 2012 R2.

This is a great and quick fun as you don’t need to manually download the ISO file and keep installing them like I mentioned in this article with step by step instructions.

As you can see in the below Azure portal screen, I am using New => Virtual Machine and then clicked on “See all”, to see all available options and also to search on what I need to search for. The prebuilt images are already available for all of us to try and you can see the highlights that I have made.

SQL2016RC3_Azure_01

Then I got the below screen to confirm on what I was going to create and enable me to create it either with Resource Manager or Classis Deployment Model. In newer version Resource Manager is chosen as default for all deployment models.

SQL2016RC3_Azure_02

In below screen I have given basic options  with Name, username, my subscription, resource group, location. Once you have chosen all your settings till 5, then you will get your fully functional SQL Server 2016 RC 3 virtual machine in 10 to 15 minutes. How cool is that.

SQL2016RC3_Azure_03

ByDr. SubraMANI Paramasivam

Step by step instruction on installation of SQL Server 2016 RC3

Following the download of my ISO file from my earlier article, I am going to show you the step by step instructions on installation of SQL Server RC3.

Step 1 is to run the exe file and you get to the Planning tab. Below screenshot, shows the options available in next Installation tab. You can then click on first option which is “New SQL Server stand-alone installation or add features to an existing installation”.

Install_SQL2016RC3_01

Step 2: Here you have option to evaluate the free edition or enter the product key that you purchased already. Here I chose the Evaluation which is the default screen and then I clicked on next.

Install_SQL2016RC3_02

Step 3: In the License Terms screen, you have full terms that you can read through to accept the license from Microsoft before start installing.

Install_SQL2016RC3_03

Step 4: I got error message in the product updates section, as I did not had internet connection in my virtual machine as I had problems in bridging the connection during this setup process. You can click on “Check again” button if you have got the same error screen and still have the internet connection. Then you can click on Next or you can do the product updates later and you can directly click on Next button.

Install_SQL2016RC3_04

Step 5: Then the system starts installing the necessary setup files  and rules. In my below screen you can see the warning messages that I got. As long as it is not failing, we are good to go. So click on Next.

Install_SQL2016RC3_05

Step 6: Here you will get the options to choose the features. As I am doing main testing on R, SSRS, Polybase, Analysis services, I have ensured to check them all here. You can check/uncheck based on what you need to install.

Install_SQL2016RC3_06

Step 7: Here I got one task failed for not having Oracle JRE 7 Update 51 to support the polybase installation. After installing this seperately, I was able to continue my installation. Note: till this setup is not installed, the Next button won’t be enabled. Once I have this installation done, I made sure to click on “Re-run” button to test the latest and then this enables me to click on Next button. Here, no need to cancel and then no need to go through all above 6 steps.

Install_SQL2016RC3_07

Step 8: Then I get the option to configure the name of the instance and I chose it to reflect the RC3 here.

Install_SQL2016RC3_08

Step 9: As this is the setup in my standalone laptop, I chose the SQL Server as standalone polybase enabled instance.

Install_SQL2016RC3_09

Step 10: In Server configuration section, it shows all the relevant account names that will be created and the type of startup services (Manual or Automatic). When it is set to automatic, this will then start the services whenever you system is booted. If it is Manual, then you have to start it manually via the services or configuration manager.

Install_SQL2016RC3_10

Step 11: In the database engine configuration, I have chosen to opt for Mixed Mode to keyin my preferable password, and this also helps me to recover the instance if my current user gone cranky. Also I have added the current user YSMUser1 from the “Add Current User” button. I also have option to choose the data directories, tempdb and filestream.

In here, you also have the new feature of trying to have more than one tempdb and you can get it configured in this place.

Install_SQL2016RC3_11

Step 12: In Analysis Services Configuration tab, I have chosen to use the Multidimensional and Data Mining server mode and also added the current user to get admin rights.

Install_SQL2016RC3_12

Step 13: In reporting services configuration, I then have option to choose whether to install and configure or just install only. You still can configure at the later stage, however in regards to Reporting services, I always choose to get it configured as well as you can see below.

Install_SQL2016RC3_13

Step 14: For the distributed replay controller, I again choose my current user to give the admin permissions to manage it.

Install_SQL2016RC3_14

Step 15: Then you get to the place where you have option to choose where your controller name, working and result directories should be placed. I have not made any changes here and left it to reflect the default installation folder.

Install_SQL2016RC3_15

Step 16: This is very new specifically for SQL Server 2016 and you have to accept to download Microsoft R Open and install and also to agree to accept patches and updates for the software. This feature enables us to work on R side from Microsoft itself.

Install_SQL2016RC3_16

Step 17: I then get this screen to choose the installation path for the Microsoft R Open and Microsoft R Server.

Install_SQL2016RC3_17

Step 18: I have provided below install path for Microsoft R Open and Microsoft R Server to be installed.

Install_SQL2016RC3_18

Step 19: This is the last part where you can see the summary of installation on what necessary information you have provided to verify before installation. You still have option to go back to any configuration and make changes and then click on Next.

Install_SQL2016RC3_19

Step 20: This is the final screen where it says the installation was successful and advise to restart to complete the installation process.

Install_SQL2016RC3_20

Have good findings in your SQL Server 2016 journey.

ByDr. SubraMANI Paramasivam

Download and install SQL Server 2016 RC3

You can now download the SQL Server 2016 Release Candidate 3 from TechNet Evaluation Center. In the below screenshot, I have chosen to download it as ISO copy. This will enable me to attach it as disk drive in my Hyper-V Virtual Machine.

SQL2016RC3_Download_01

Based on few browser plugin issues and local settings, the download may not start immediately. Hence you can click on Manual download again in case if the above chosen ISO file does not download.

SQL2016RC3_Download_02

I am looking to find if all the previous issues that I faced with previous releases have been fixed in this new Release Candidate 3 or not.

Have a good journey in this SQL Server 2016 as we have now come to the last RC3 before we get the full SQL Server 2016.

ByDr. SubraMANI Paramasivam

FREE Technical Data Seminar in London

Hi Everyone. I am very excited to announce the DAGEOP’s first FREE DATA SEMINAR programme now available for you to attend and enjoy the sessions from world renowned speakers. Please visit this link to get yourself registered and I have 3 sessions frozen already and awaiting for the final one. I will get back to you with final agenda once that is confirmed.

You can find more information on this from http://www.dageop.com/Events/DaGeopsDataDay.aspx

Also provided you the agenda that is available as of now. Don’t forget to register as this seating is limited.

DaDataDay_May142016_Schedule

 

ByDr. SubraMANI Paramasivam

Data Driven & SQL Server 2016

Following today’s Data Driven live streaming from New York, Satya Nadella have opened the speech by providing insights on what CEOs and organization owners should see with Data being the key factor driving the business.

DataDriven_02

DataDriven_01

 

Also SQL Server 2016 RC (Release Candidate) is now available here and no more CTPs from Microsoft download site. Be the first to download the latest Release Candidate and try the brand new features of SQL Server.

DataDriven_04

DataDriven_05

ByDr. SubraMANI Paramasivam

Install R Studio 0.99.491

You can download the latest R Studio 0.99.491 and install for FREE in this link. However if you need support then you need to agree to a monthly term to support you and your production system, and you can compare it from this link about the pricing for your desktop and server.

I have downloaded the RStdio-0.99.491 and have started installing and provided you the below screenshots for your reference.

Install_RStudio_099_01

In here, you have option to choose your folder and it also gives you the amount of space required for this installation. I know, I am running out of space, but I am doing this in my virtual machine.

Install_RStudio_099_02

Here you get option to add to the start menu and create shortcuts. I chose the default options in below screenshot.

Install_RStudio_099_03

As you can see below, the extraction and installation takes place for about couple of minutes.

Install_RStudio_099_04

That’s it. We are now done with the installation of R Studio.

Install_RStudio_099_05

ByDr. SubraMANI Paramasivam

Create a work station for a Data Scientist – Part 2

Following my first post on this same series on creating a work station for a Data Scientist, this will be the next one.

Next you need Revolution R Enterprise 7.5.0 Server (RRE-7.5.0) and you can download this from this link.

This will download about 81MB of “Revolution-R-Enterprise-Node-SQL-7.5.0-Windows.EXE”

Once downloaded you can then start installing this exe and below screenshots are provided for a successful installation.

InstalRevolutionREnterprise75_01

InstalRevolutionREnterprise75_02

InstalRevolutionREnterprise75_03

InstalRevolutionREnterprise75_04

InstalRevolutionREnterprise75_05

InstalRevolutionREnterprise75_06

InstalRevolutionREnterprise75_07

InstalRevolutionREnterprise75_08

InstalRevolutionREnterprise75_09

InstalRevolutionREnterprise75_10

InstalRevolutionREnterprise75_11

InstalRevolutionREnterprise75_12

InstalRevolutionREnterprise75_13

InstalRevolutionREnterprise75_14

InstalRevolutionREnterprise75_15

InstalRevolutionREnterprise75_16

InstalRevolutionREnterprise75_17

InstalRevolutionREnterprise75_18

InstalRevolutionREnterprise75_19

ByDr. SubraMANI Paramasivam

Create a work station for Data Scientist – Part 1

In this post, I am going to cover how to create the work station that will make it suitable for a Data Scientist. Sounds interesting!? Go ahead reading my other parts on this.

First of all you need Microsoft R Open 3.2.2 for Revolution R Enterprise 7.5.0 which can be downloaded here.

Once you have downloaded this 56MB file, you can start installing and I have provided step by step screenshots below.

InstalRevolution322Enterprise75_01

InstalRevolution322Enterprise75_02

InstalRevolution322Enterprise75_03

InstalRevolution322Enterprise75_04