Friday, March 10, 2017

Hyperloop One - Setting up the tracks

Since my first post in 2013 things have moved up a little bit. According to this news item, the start up company Hyperloop One (not an affiliation of Elon Musk's business) has begun constructing a full-scale test track called the DevLoop in the Nevada desert. According to their one liner, Hyperloop One has promised to deliver a means of transit that offers airplane speed at bus ticket prices.

You know what, this was unveiled appropriately in a Middle East Rail Conference in Dubai.  It appears the first implementation of Hyperloop may take place connecting Dubai with Abu Dhabi. Well this is a very hopeful choice with Dubai having a lot of cash and a wide open desert. There is lot more of this news at this NBC's news site.

Read at Hyperloop One here for the full story:

Here is a You Tube video :


Traffic congestion is a major, major problem and any thing to mitigate its effects such as lost time, pollution, stress at a reasonable cost is worth the effort & justifies support.

India  has teeming millions with cities congested with traffic beyond imagination and unbelievable pollution. No wonder India is looking at this technology although bringing Hyperloop India will not be easy.

Saturday, March 04, 2017

2oth anniversay Visual Studio Event - Congratulations

In a matter within the week, Visual Studio 2017 will be released (March 7). I cannot help but recollecting the journey, I had with Visual Studio.

I started using Visual since the day 1 it appeared. Actually I was attracted by the Visual IDE even earlier with Visual Basic, Visual InterDev (the precursor for Visual Studio) and all the other Visual programs from Microsoft.

I also used Visual InterDev for some projects at WorldCom. Neither Visual InterDev nor I had anything whatever to do with whatever happened to WorldCom (http://www.cbsnews.com/news/world-class-scandal-at-worldcom/).

I was teaching out of work folks during the bubble period who were eager to acquire Web related technology that can access back-end databases. They loved it all, although Visual InterDev had a long way to go.

Later on I had a lot to read up on Visual Studio for the five books I wrote from (2007 to 2012). They are all displayed on my blogs. They really helped me to write as the software was available free. In order to get a free copy, distributed in one of the Microsoft events in Long Island, NY I traveled from Princeton to Long Island and did an overnight stay.

Wish you a very happy birthday Visual Studio and many more birthdays to come.
I have blogged extensively on Visual Studio about all versions in four of my blogs. Review the following:

Hodentek (11 years):235 Posts
http://hodentek.blogspot.com/search?q=visual+Studio

HodentekHelp (10 years): 50 posts
http://hodentekhelp.blogspot.com/search?q=visual+Studio

HodentekMobile(9 Years):30 posts
http://hodentekmobile.blogspot.com/search?q=visual+studio

HodentekMSSS (8 years): 49 posts
http://hodentekmsss.blogspot.com/search?q=visual+studio


Thursday, March 02, 2017

Bacpac file on GitHub can also be used to construct Wide World Database on SQL Server 2016

In my previous post I showed you how easy it is to bring the Wide World Importers (WWI) database into a named instance of SQL Server 2016 SP1 on your computer(desktop / laptop).

In this post I describe how you may construct the database on the named instance using a BacPac file.
If you have not used this kind of file please review the following link here.

In what follows I describe using the .bacpac file to construct the WWI database
Go here:
https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0

Get this bacpac file:
Azure SQL Database Standard tier

    WideWorldImporters-Standard.bacpac - standard edition OLTP sample database in bacpac format. For Azure SQL Databases in the Standard tier.


Download the 58.4 MB file from the above site.


SQL Server 2016 SP1 like the other versions has a wizard to bring the database using a .bacpac file such the one you downloaded.

You invoke the wizard as shown in the next image and follow through.


bakpacWWI_01.png

Click Import Data-tier Applicaiton... to open the window shown in the next image.  Read the steps in this introductory page.


bakpacWWI_02.png

 Click Next. You click the Browse... button to locate the  indicated file. This is the location to which I saved the WideWorldImporters-Standard.bacpac file. 
It does not matter it is for Azure SQL Database.


bakpacWWI_03.png

After getting the file location from the location as shown in the next image proceed to next step.


bakpacWWI_04.png


After getting the file location in the wizard's interface (the image one above the previous) click Next.


bakpacWWI_05.png

 Just verify that the location for files are what you want. Herein defaults are accepted. You could browse and park elsewhere.

The database name was changed to WWI_Bacpac.

Click Next. The Summary of processing is presented as shown.


bakpacWWI_06.png


Click Next. The next four images shows the progress captured in images. Indexes are dropped and created, etc.

 bakpacWWI_07.png
 bakpacWWI_08.png
 bakpacWWI_09.png
bakpacWWI_10.png

Object explorer refreshed - last processing step.

The WWI database is imported successfully.

Here is the final verification of the import into the named instance.

bakpacWWI_10.png

This method of importing the database appears to be slower than the one in the previous post. as there is a lot of processing related to deconstructing and reconstructing the indexes.

Wednesday, March 01, 2017

Bharthi Airtel, Nokia Collaboration to bring 5G to India

Airtel and Nokia waded through 2,3,4G technologies together and now they are gearing up to bring 5G to India.

5G is expected to make dramatic improvements to:
  • Peak Data speeds
  • Improvements to Network Latency
  • Agility
  • Enable new network capability such as network slicing

Nokia's First end-to-end 5G solution (AirScale radio access portfolio and AirFrame data center platform) will be leveraged.

More importantly this technology will be crucial for IoT(smart city, connected vehicles, industrial automation, etc).

Read more here:
http://english.jagran.com/tech-auto-nokia-airtel-join-hands-on-5g-iot-applications-226054

Hang on to your Nokia stocks!

Get ready to using Wide World Importers Database from Microsoft

In order to get this database first go here ( https://github.com/Microsoft/sql-server-samples ).

There are three releases of which the first one Wide World Importers sample database v1.0 is the one you should get.

Before you begin to do this task, verify that you have done a dependent tass (upgrading to SP1). If not, go here and complete the task.

Click on that link. This should take you to this site here .

I will show you the easy way to get this task done. SQL Server has both Backup / Restore hookups that you can use.
Download WideWorldImporters-Standard.bak

From Databases choose Restore Database....


Restore Database screen gets displayed. Click on Device and click the ellipsis button to locate the backup file.



  

Go locate the backup file you downlaoded as shown (your location will be different).

Click OK. The file can now be accessed by the processor.


Click OK. After a short while of processing you should see this message.


 Wide World Importers is now in your named instance of SQL Server 2016 SP1 as shown.


It does come with data as shown.


Don't you think it was easy!

DMCA.com Protection Status