Connected cars and infotainment systems

You stay connected and stay informed with Infotainment systems

We are seeing enormous changes in the infotainment systems by the many vendors catering to the auto lovers. All most all auto vendors have some kind of infotainment system.

Which is better?

Probably the answer will change from year to year and from every any kind of model changes.

These are some of the recent infotainment systems line up and listed by the consumerreports.org in the order of their likeability.

Not included in the listing follows the Jaguar model that has the latest infotainment system which you will find in the conclusion of this posting taken directly from the Jaguar site.

The Standout
Fiat-Chrysler Uconnect 8.4: 70 percent very satisfied

Very Good Systems
Hyundai Blue Link: 63 percent very satisfied
BMW iDrive: 60 percent very satisfied
GM (Chevrolet, Buick, GMC) MyLink/IntelliLink: 57 percent very satisfied
Kia Uvo: 57 percent very satisfied
Audi MMI: 57 percent very satisfied
Lexus Remote Touch: 56 percent very satisfied

Average Systems
Nissan NissanConnect: 54 percent very satisfied
Infiniti Infiniti Connection: 54 percent very satisfied
Volvo Sensus Connect: 52 percent very satisfied
Mercedes-Benz Comand: 51 percent very satisfied
Subaru Starlink: 50 percent very satisfied
Ford MyFord/MyLincoln Touch: 49 percent very satisfied
Mazda Mazda Connect: 49 percent very satisfied
Honda HondaLink/AcuraLink: 49 percent very satisfied

Back to the Drawing Board
Toyota Entune: 44 percent very satisfied
Cadillac Cue: 40 percent very satisfied




This is what Jaguar is pitching:
THE NEW JAGUAR XE: OFFERING ADVANCED CONNECTIVITY
- All-new Jaguar InControl® infotainment system with 8-inch touchscreen*
- InControl Remote™ enables smartphone control of functions such as door unlocking and engine start
- InControl Apps™ allows users to access Apple and Android smartphone apps through the vehicle touchscreen*
- Optional Wi-Fi connectivity for multiple devices
- Optional laser Heads-Up Display combines sharper images with compact, weight-saving design**

Voice recognition:

Voice recognition will always be a problem unless voice-training is carried out even when the user is not aware. Just a few lines of reading some text will not ensure voice-recognition even 60% of the times. Both Cortana and Siri have failed to recognize voice. AI needs lot more turbo-charging before voice recognition becomes a reality.

Decrypt email passwords

We saw in the previous post and here how to encrypt using the EncryptByPassPhrase() function.

We will use the same encrypted text and decrypt it using the same PassPhrase used to create it.

We use the reverse function DecryptByPassPhrase() which takes two arguments, the first is the PassPhrase and the second is the encrypted value (cyphertext). The PassPhrase generates the key for decryption.

MSSS2017\ENCRPTPSWD_04.pn

Honolulu Hands-on Training: Introduction to Structured Query Language (SQL)

The next session will be starting October 12, 2017. Register early.

Explore funding opportunity here:

Encrypted email passwords in SQL Server

You could keep your email addresses and passwords in SQL Server database table. You could get a free copy of your SQL Server from a Microsoft download site.

While the email addresses can be kept un-encrypted, you may want to keep your passwords in an encrypted column of a table. If want to keep everything encrypted you can do it also.

With this table set up correctly you may need to remember just one phrase which can be of your choosing.

Here are steps to create such a table:

1. Create a table in one of your existing databases. I am creating this table in a database called 'Aloha' which I use for teaching.

Here is the statement to create the table:

USE Aloha
Go
Create Table Encrpt(
emailID int Primary Key not null,
emailAdd nvarchar(25) null,
emailPswd varbinary(250) null
)

This creates the table ENCRPT.

The email password (emailPswd) is stored in a special column(varbinary data type) as shown above.

Now keep a list of emails and the passwords ready to populate the table.

Populate the table you created by inserting values using the following code:

INSERT INTO ENCRPT(emailID, EmailAdd, emailPswd)
values (1, 'hodentek@live.com', EncryptByPassPhrase('Happy birthday to you','xyzpo')),
(2, 'mysorian@gmail.com',EncryptByPassPhrase('Happy birthday to you ','ZZZ12$' )),
(3, 'htek@mysorian.com',EncryptByPassPhrase('Happy birthday to you','$$$11X' ))

I have inserted only three values but you could add more. While the email addresses shown are my real addresses, the passwords are not.

Now when you run a SELECT statement to display all the columns, this is what you see.

Here is a screen shot of all code:

I have used the same PassPhrase for all data, you could have different on, the onus of remembering phrases is on you.

The fourth row was filled using a different PassPhrase ('Happy Anniversary).

Read more here:

https://hodentekmsss.blogspot.com/2017/08/encrypting-email-password-in-sql-server.html

SQL Server and two-digit cutoff

Remember the millenium bug fiasco. It happenned in Year 2000.
This is what chronicled in Wikipedia:

"The Year 2000 problem is also known as the Y2K problem, the Millennium bug, the Y2K bug, or Y2K. Problems resulted because people, including programmers, reduced the four-digit year to two digits. This made the year 2000 indistinguishable from 1900"

Now we have a better interpretation for people using two digit years as far as SQL Server is concerned.

The default time span for SQL Server is 1950-2049.

Two-digit year 49 is 2049, but two digit year 50 is back to 1950.

Probably you will start seeing it in your credit cards (may be?)

You may configure it in SQL Server 2017 using,

Exec Sp_Configure 'two digit year cutoff', 2038

In SQL Server 2012 Express it is enabled by default:

Read more here:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-two-digit-year-cutoff-server-configuration-option