How do you test your IPv6 connectivity?

The best way to do this is go to this site which provides many other sites from where you can search. Go here directly:

http://test-ipv6.com/

You get both the IPv4 and IPv6 of your ISP. You also get related information about your ISP.

Intentionally some parts of IPv4 and IPv6 are sliced off.

How do I find my WAN IP Address in IPv6 format?

All traffic coming to your computer is via your router which then routes the traffic to your local IP Address.

One way to find your WAN IP address, the address assigned to you by your Internet Provider is go to the site. It can be in IPv4 or IPv6 format.

In my previous post you saw how to find the IPv4 address.

To find the WAN IP Address in IPv6 format just access the following site from your computer that is in a local network behind your router:

https://whatismyipaddress.com/?u=TRUE

Which immediately responds by showing your WAN IP Address as well as your host server as shown for my ISP Provider:

How to find the WAN IP Address?

Your local network is behind a router which is connected to your Internet Provider. All traffic coming to your computer is via your router which then routes the traffic to your local IP Address.

One way to find your WAN IP address, the address assigned to you by your Internet Provider is go to the site.

http://getmywanip.com/

Which immediately responds by showing your WAN IP Address as well as your host server as shown for my ISP Provider:

WANIPFinder.png

What are the differences between datetime and datetime2 data types in SQL Server?

You can evaluate GetDate() function in SQL Server 2012 to see the default format of datetime as shown.

Date related data in SQL Server 2012 by default is of datetime format. There are two types of datatime in SQL Server, the datetime and datetime2. The date data type does not have any information on time. You can create a column with datatype time or datetime or datetime2 as shown.

Now, what are the differences between datetime and datetime2?

The syntax is different; the date range is different and dattime2 can have higher number of decimal seconds.

Syntax: datetime
date range: Jan 1, 1753 to Dec 31, 9999
Time range:00:00:00 through 23:59:59.997
Default value:1900-1-1 00:00:00


Syntax: datetime2[fractional seconds]
date range: 0001-01-01 through 9999-12-31
Time range:00:00:00 though 23:59:59.0000000
default fractional seconds 7
Default value:1900-01-01 00:00:00

Here is an example of using datetime2:

The ISO 8601 format is: 2004-05-23T14:25:10.487
where T is start of time format

What is an Advanced Driver Assitance System?

Accidents are a part of modern day life especially traffic related accidents. Built-in systems in most vehicles such as restraining seat belts, airbags, crumple zones are effective only after or during an accident. However what is really needed is accident prevention or mitigation to reduce effects of an accident. This is the issue that is addressed by the Advanced Driver System. In the coming age of connected cars parts of which are already implemented, there is a great deal of improvement to safety by adopting Advanced Driver Assistance(ADA).

ADA is the byword for safety and safe cars are of crucial importance to consumers and automakers go all the way to look at distinguishing themselves in this regard. Some of the ADA elements are already present in some of the cars you buy, such as,

Adaptive Cruise Control
Blidspot-monitoring
Lane departure warning
Night Vision
Adaptive-light control
Collision avoidance systems with proximity sensors

ADA is a preemptive feature to help preventing an accident and should not be included as a luxury. ADA is especially useful on highways where cruise control is essential. Use of sensors help monitor speed and provide feedback to adaptive cruise control. This is perhaps the most well known ADA feature. While the core idea is speed control its implementation is different in different automakers.

For example, the Audi (Audi A4 sedan,Q7 cross-over etc) the winner of the 2017 Autoblog Technology of the Year awards does quite a few things in adaptive cruise control, such as

Takes into account topology of road, curves, and speed limits
Reads speed limit signs and resets them in the system to match
Slows down around corners
With destination set, slowing down while approaching destination is automatic

More and more cars, even the middle range cars will have ADA features implemented in the coming years.

Is it possible to use PowerShell to work with Hyper-V?

The short answer is yes. On a Windows 10 machine you can use Hyper-V to work with VMs. On a Windows 10 machine you need to enable Hyper-V using the 'Turn Windows features on or off' pop-up from the Program and Features in the Control Panel. When you enable it you should be able to see this.



You can then search for Hyper-V and start the GUI.



Clicking on Hyper-V Manager brings up the graphic user interface.

Hyper-V with PowerShell

It is also possible to use Hyper-V PowerShell module to simplify and automate management tasks. Most of what you do on the GUI can be carried out using PowerShell.

The advantages of using PowerShell is that you can automate most of the actions with flexibility. It can also provide you with features not implemented in the GUI.

If Hyper-V is already present, as in the present case (or machine) you can check if the Hyper-V module is available by using the Get-Command as in the following statement after bringing up the PowerShell command prompt:
Get-Command -module Hyper-V

This brings up the following response when run. The following is a screen shot of PowerShell ISE from the present machine. I have only included a portion of the result and most commandlets are named after their task.

For example:

Get-VMHOST gets the host information as shown.

PS C:\Users\Jayaram> get-vmhost

Name      LogicalProcessorCount MemoryCapacity(M) VirtualMachineMigrationEnabled
----      --------------------- ----------------- ------------------------------
HODENTEK8 8                     8116.2734375      False


PS C:\Users\Jayaram> get-vmhost|Select *

Just peruse the list and you can do many things with PowerShell.

If you are looking for installing Hyper-V on Windows 8.1 or Windows 10 go here:

Install Hyper-V on Windows 10:
http://hodentekhelp.blogspot.com/2016/04/how-do-you-install-hyper-v-on-windows-10.html

Install Hyper-V on Windows 8.1:
http://hodentekhelp.blogspot.com/2015/05/how-do-you-enable-hyper-v-in-windows-81.html

What's new in Office 365 features?

Microsoft is tops in Office applications with its Office 365 suite because of continuous development. Some of the features described here are available only if you have a subscription to Office 365 and Office Insiders.

In the latest version of Office 365 (November 2016)  these are the new features:

Learning tools for improved reading:

Use Read Mode with new commands and improve your reading skills. You can adjust text spacing, observe syllable breaks and highlight each word as document is read aloud.

Built-in accessibility
Improved support for asistive technology with Narrator. You can also create accessible documents as well.

Insert and edit icons:

Your document should have visible impact and to this end use icons available, some 500 of them. You can insert and edit icons

SVG images can now be used in Word:

You can now insert and edit SVG graphics without using any export software. Office 365 Word supports SVG graphics embedding.