Monday, August 14, 2017

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:











Saturday, August 12, 2017

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

Thursday, August 10, 2017

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


Friday, August 04, 2017

2018 Toyota C-HR looks cool!

It looked beautiful and it had my choice of color too. You can get not only
single tone but also two-tone exterior colors. Price does not look too bad. Actually autos are cheaper now than a couple of years ago.

This one is from Toyota,
"With its beautifully sculptured crossover design, responsive and engaging hybrid drive, the all-new Toyota C-HR offers complete harmony in active lives. Forget the continual stop-start, it’s time to find your city’s perfect flow at the wheel of the new Toyota C-HR…
"
These are quoted price from Toyota:
First $22,500 starting MSRP 1
as shown $24,3501
27/31
est. mpg 12
Here are some pictures








Get a brochure:
https://www.toyota-europe.com/new-cars/c-hr/#/ajax/%2Fnew-cars%2Fc-hr%2Fe-brochure

Thursday, August 03, 2017

Windows as Service


Windows versions, Windows Vista, Windows ME, Windows XP, etc. are soon to end.
The reason being Windows OS will be offered as a Service - that is there is a new model for Windows- Windows as a Service.

Details of this model are in the video at the end of the post. But, if you are impatient glean over the screen shots of the same. One thing I will expect from Microsoft is to take complete care of the malware and virus threats. Can Microsoft promise this?

Presently, how the Windows as Service it is going to be priced, is up in the air and may slowly emerge. Everyone who has Windows will get an upgrade.

The other question although you do not worry about Windows software, what about computer hardware upgrade? How often it needs to be upgraded? I have about 4 laptops in my apartment which resulted from the relentless Microsoft upgrades of not only Windows but also other Microsoft products like SQL Server, SharePoint etc. Can we go back to terminal services with a barebones Windows Dumb! to access the Windows as Service.

Most importantly will Microsoft makes money for the investors?












Read more here:
https://docs.microsoft.com/en-us/windows/deployment/update/waas-overview

Wednesday, July 26, 2017

mssql-scripts is a multi-platform tool to script database objects

In your SSMS on your computer you can use the Generate Scripts drop-down
menu to create scripts for database objects as shown here for Northwind database on SQL Server 2016 SP1.


The above is for SQL Server on Windows Platform. However, mssql-scripts tool provide the same functionality as Generate Scripts wizard on SQL Servers on Linux and macOS. Of course mssql-scripts would work on Windows as well.

Using mssql-scripts based on Python you can generate T-SQL scripts for objects on SQL Servers, Azure SQL database and Azure SQL Data Warehouse. The generated script is saved to a .sql file or on Linux can be piped to standard Unix utilities (sed, awk and grep). The scripts can be checked into source control systems as well.

The source code for mssql-scripter is found here:
https://github.com/Microsoft/sql-xplat-cli

Tuesday, July 25, 2017

HTML5 related technology to replace Adobe Flash

Adobe itself concedes that Adobe Flash need to go and will turn-off Adobe Flash by 2020. Adobe in the mean time will migrate users to other programs.

Why did Adobe take that decision?

Two things, flash plug-ins are insecure, the other, the emergence of HTML5. Why keep something that can be done as easily with a option adored by the community and more secure.

However, Adobe Flash may stay on for gaming and related applications.

I am sorry that it has to go!

Saturday, July 22, 2017

YouTube disappears from Samsung Smart TV

This happened on our Samsung Model UN46F7500AF Smart TV purchased in 2013 but the Model began selling in 2012. Speaking to the Samsung support team in USA gives me the feeling that YouTube created a new platform and that the older TV (Prior to 2012) does not support the new YouTube platform.

I will have to pursue this matter with YouTube site for confirmation.

In Summary, the reason YouTube disappeared is not because of Samsung, but because of YouTube's platform changes according to Samsung.

Thursday, July 20, 2017

Open source and Single Page Web apps

It is exactly what it says. Single Page Applications (SPAs) are web applications with a single web page that uses AJAX for its dynamic interactions. As page refresh is on the client side the SPAs can have downside of performance degradation if they are not properly designed and SEO optimized.

There are many JavaScript frameworks to write SPAs. There are lots of JavaScript frameworks that you can use to build SPAs. Lots of them are Open Source. Here are some:

WinJS
Angular
React
Ember
Aurelia
Dojo
Vue.js
Cycle.js
Backbone
Dojo


I hear a lot about Angular and Aurelia, perhaps more people are using them.
Intel XDK had both Angular and Backbone templates, but they are not supporting them anymore.

AngularJS is in Version 2.

I have a large number of posts on Intel XDK here.


ntext, nchar and nvarchar differences

These are basically used for textual information related data types. There is a strong recommendation not to use ntext as it is not going to be supported.

These are their definitions from Microsoft Documentation.

ntext (National Text):
Variable-length Unicode data with a maximum string length of 2^30 - 1 (1,073,741,823) bytes. Storage size, in bytes, is two times the string length that is entered

nchar [ ( n ) ]
Fixed-length Unicode string data. n defines the string length and must be a value from 1 through 4,000. The storage size is two times n bytes. When the collation code page uses double-byte characters, the storage size is still n bytes. Depending on the string, the storage size of n bytes can be less than the value specified for n. The ISO synonyms for nchar are national char and national character..
1
nvarchar [ ( n | max ) ]
Variable-length Unicode string data. n defines the string length and can be a value from 1 through 4,000. max indicates that the maximum storage size is 2^31-1 bytes (2 GB). The storage size, in bytes, is two times the actual length of data entered + 2 bytes. The ISO synonyms for nvarchar are national char varying and national character varying.

ntext is supposed to be discontinued, but in actuality it is still present as a choice in data types listing even in SQL Server 16.



Monday, July 17, 2017

Backing up legacy database to SQL Server 2012 (x86) using SSMS 17.1

SQL Server Management Studio 17.1 does well in backing up a Northwind database to a SQL Server 2012 Express (x32bit) on Windows 10 OS.

A backup of Northwind database was obtained from the Codeplex site and was saved to one of the folders on a Dell computer with Windows 10 OS. The computer also has SQL Server Management Studio (v 17.1). You should be able to restore using the SQL Server Management Studio installed when you installed the SQL Server 2012 Database engine.

Follow these steps to restore the Northwind database to an instance of SQL Server 2012 (x86) installed on the same computer.

Step 1. Start SQL Server Management Studio v17.1 (Run as administrator)

The SSMS is version 17.1 and Hodentek9\PCATT is a SQL Server 2012 Express

Step 2. Right click the Databases node highlighted in the PCATT isntnace as shown.




RestoreDB_01

Step 3: Click Restore Database...

Restore Database window is displayed as shown.


RestoreDB_02

Step 4: The Default Source is Database and it is greyed out as shown. Chnage it to Device. The Restore Database gets changed as shown.


RestoreDB_03

Step 5: Click the ellipsis button along 'Device' in the above image.

Select backup devices window shows on top of Restore Database window as shown.


RestoreDB_04

Step 6: Click Add button in Select backup devices window.
Locate Backup File window gets displayed as shown.


RestoreDB_05

Usually the 'backup files with extension .bak' are found in the following directory in the case of x32 bit SQL Server.
C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.PCATT\MSSQL\Backup

However, for this exercise it is stored in a different location.

Step 7: Now browse to that location and highlight the Northwind.bak (A backup file which came from a Microsoft site) as shown.


RestoreDB_06

Step 8: Click OK. The file path is entered in the Select backup devices window as shown.


RestoreDB_07.png

Step 9: Click OK
You are returned to the Restore Database - Northwind as shown.


RestoreDB_08.png

Step 10: Click OK in the above.

Microsoft SQL Server Managment Studio message reports that the database
'Northwind' restored successfully.


RestoreDB_09.png

Step 11: Click OK to the message. Verify that Northwind database is in the SQL Server 2012 instance Hodentek9\PCATT


RestoreDB_10.png


Bye





Wednesday, July 12, 2017

Set-Location : A positional parameter cannot be found that accepts argument <.....>

Power Shell does not like white spaces. While it may like or .  I got stumped for while as I started getting this exception.



The trick to do this changing directory is to use double quotes around words with white spaces as shown here.


I have Power Shell 5.0 on my Windows 10 Pro OS.

Go on, build apps with Microsoft Graph...

Microsoft SQL Server is for accessing data and Microsoft Graph is to access the myriad of things that are not really part of the database. The thing that spring to the mind are thins like, emails; your devices; the teams you work with; calendars; files; messages, peoples etc..

Also read this post on Graph databases:

http://hodentek.blogspot.com/2013/12/what-is-neo4j.html

A quick look at this image shows how Microsoft Graph is positioned.



Well, what is it Microsoft good for?

Believe me, you indeed have a great deal of use for it. Allow me to quote Microsoft:
'
Looks at your next meeting and helps you prepare for it by providing profile information for attendees, including their job titles and who they work with, as well as information on the latest documents and projects they're working on (pro-active, do diligence).

Scans your calendar, and suggests the best times for the next team meeting.

Fetches the latest sales projection chart from an Excel file in your OneDrive and lets you update the forecast in real time, all from your phone.

Subscribes to changes in your calendar, sends you an alert when you’re spending too much time in meetings, and provides recommendations for the ones you could miss or delegate based on how relevant the attendees are to you.

Helps you sort out personal and work information on your phone; for example, by categorizing pictures that should go to your personal OneDrive and business receipts that should go to your OneDrive for Business.
'
Behind Microsoft Graph is the Microsoft Graph API; a RESTful web api that enables you to access Microsoft Cloud serivce resources.
Come back to this blog again for more on Microsoft Graph.

Go here and gets started:

https://developer.microsoft.com/en-us/graph/docs/concepts/get-started

Monday, July 10, 2017

Get this funding support and start training if you are in Hawaii

Things are changing very fast, especially in the STEM area. Do not wait to get qualified. IT industry  requires a lot of people (of course, with right skills). Learning is both time intensive and expensive in many cases. There are, low cost but very effective training programs, that will bring you up to speed to address todays job requirements.

Strada Hawai'i Government Stem Workforce Fund can help you to get started if you are eligible and work for government(City, State or Federal). This agency is geared to fund in the following fields: Science, Technology, Engineering and Mathematics.




Read up this information on this image and start making calls. Who knows, you may end up getting support to get into one of the many possible courses depending on your suitability.
The Pacific Center for Advanced Technology Training offer a number of courses in the IT Arae  and you could register for one of these courses on getting this fund. Contact PCATT.org or the Program Manager, Beryl Morimoto at beryl.morimoto@hawaii.edu

Two important points to note:
1. Training must be completed on or before September 29, 2017. 
2. With supervisory approval, the employee can pay for training and receive Strada support if the department or agency does not have training funds.

Also other resources of immediate use:
https://pcatt.org/strada-hawaii-government-employee-stem-workforce-development-fund

Go on, start off with the application process:
Download application form here:
https://pcatt.org/uploads/widget/stemworkforcefund_v11.pdf

Three of my present students attending the BASIC SQL course are funded by STRADA.

Wednesday, July 05, 2017

Check out new features in Power BI Desktop (July 2017 Version)

The July 5 version of Microsoft Power BI Desktop can be downloaded from here:

https://www.microsoft.com/en-us/download/details.aspx?id=45331

The details of this version  are here


Summary of new/improvements:
Reporting
    New table & matrix visuals are now generally available
    Renaming fields in visuals
    Custom visuals store integration
    Relative date filters
    Responsive layout for visuals (preview)
    New waterfall chart option - breakdown
    Custom visual updates
        Drilldown Choropleth
        Drilldown Cartogram
        Drilldown Player
        Certified custom visuals

Analytics & modeling
    Quick measures from the community
        Star rating
        Concatenated list of values
    Bidirectional cross filtering for DirectQuery is now generally available

Data connectivity
    Snowflake connector general availability

Query editing
    Add Column from Examples enhancements

Watch the video for new feature details:

Monday, July 03, 2017

Microsoft has done quite well, don't you think?

Cloud and Big Data has made a lot of changes...

Big Data exposure with Oracle and Microsoft

The above title and the below paragraph is from the following link:
http://www.valuewalk.com/2014/07/oracle-corporation-orcl-launches-big-data-sql/

"Moerdler rates Oracle Corporation (NYSE:ORCL) as Outperform, giving it a $49 price target (currently $41) based on a 12-month adjusted EPS estimate of $3.58, a 13x PE multiple, and adding back in net cash per share discounted by 30%"
Current: $50.14 (7/2/2017)

"He also argues that Microsoft Corporation (NASDAQ:MSFT) is a good Big Data play, rating it Outperform and giving it a $56 price target (currently $43.50), because he believes management is heavily focused on mobile and cloud products and that EPS growth is going to pick up as the company moves its focus away from the slowing PC market"

Current: $68.93 (7/2/2017)

After a 3 year period of many political and economic changes Microsoft seems to have outformed Oracle which may be attributed to its all out effort and emphasis on Cloud Services not withstanding its PC and Phone performance.



Wednesday, June 28, 2017

Vienna to Prague bus ride

Day 8:
A long bus ride from Vienna to Prague. There are places to stop in between for lunch and breakfast.

We stopped at a roadside restaurant at a place called Melikana about an hour before reaching Prague.
It's a buffet style lunch with lots of buses arriving simultaneously making it a run around carrying platters. Food is OK. Coffee too but not as good as in Budapest. There are charging stations for smart phones and ATMS. They accept Euros or Czech currency. They have only pay toilets, better take Euros or Korunas.

We reached Prague late in the evening and had our group dinner at our hotel. Later went out without tour director who showed us how to work the Metro. The nearest Metro to our Hotel was Andel. You come across many shopping areas before you get to the metro, a 10 minutes’ walk. Metro is quite clean and Czech people value their assets, no defacing of the walls etc.

We walked around the old town and had the first look at the Astronomical Clock...

Here are some pictures of the day:

https://www.youtube.com/watch?v=LtIyGsg-pDU

Friday, June 23, 2017

Danube river cruise and the Melk Abbey

We went from Vienna to Dürnstein, after about an hour or more of bus ride. We did some sightseeing of this town with the fabled blue church over the hill and 16th century residences. It was typically a town for tourists with lots of shops, restaurants, wine shops etc. on both sides of narrow, cobbled streets. We then boarded the boat at Dürnstein pier at the foot of the hill around 10:00 AM. The ride was for about 3 hours or more and the boat had an on-board restaurant. At a distance, you can see the castle now in ruins that had held Richard the Lionheart captive.

Later we visited the Benedictine Melk Abbey (Lower Austria) adjacent to the Wachau Valley. It has the tomb of the past rulers and a library with a huge manuscripts collection. We also visited the blue gallery and enjoyed the projected slide show on the walls of the museum. on the way to the the Melk Abbey we saw from the boat the ruins of a castle where the Richard of Lion heart was imprisoned.

Wachau valley is well known for its vineyards and wineries. We visited one of them and were served wine ex-gratis...

Watch the slide show of the visit on YouTube here:

https://youtu.be/0bcEmuUUJM0

Microsoft launches phased roll-out of Microsoft Stream

Microsoft Stream is meant as a replacement for Office 365 Video service. Microsoft Stream is video service for business users.

Microsoft is always aiming at corporate users and this service allows for uploading, sharing, managing and viewing corporate video for company-wide education and information sharing.

The base platform for Stream service is Azure Media Services. Of course integration of its various components be it Skype or Office is a feature paramount in its business vision and Stream integrates with SharePoint. Teams, Office 365 groups etc. Security is via Azure Active Directory with its authentication and encryption features.

Stream is a lot more than video managing, it can,

* searchable speech-to-text transcribed audios
* Face detection in videos
* Linked time codes

Follow the link below to see all the details about Microsoft Stream.

Migration from Office 365 Video to stream is phased and is supposed commence in the second half of 2017.

More on stream here.

This video gives some idea of what it was sometime ago (not the latest)

Thursday, June 22, 2017

Using AngularJS on the localhost

AngularJS directives are extensions of HTML markups. They are one of several components of AngularJS. Directives can be attributes, element names, CSS class etc.

AngularJS script reference is important and the script can be found here:

https://ajax.googleapis.com/ajax/libs/angularjs/1.2.25/angular.min.js"
The above script reference needs to be added to your hTML page.

You can find the whole list of directives here:
https://docs.angularjs.org/api

Here is the usage of some directives placed in a html page that can be displayed on your localhost (in this case the IIS in Windows 10). Place this code with a suitable name in the inetpub / wwwroot directory.

======================


  Some directives in AngularJS

ng-app
Sorry, blogger still does not support the "pre" tag!
==============
When viewed on the browser (in this case Microsoft Edge), the HTML page renders as shown.


Do the following on this interactive page:
  • Type anything it gets copied next to Hello
  • Enter the increment region with your mouse, the count (presently 1) gets incremented
  • Click the link and you get to the page
Directives used in the page above and their description:
ng-app: initializes an AngularJS application
ng-model: binds the value of HTML controls (input, select, textarea) to application data
ng-init: initializes application data
ng-mouseenter: an AngularJS mouse event as a cursor moves over an dom element
ng-href: supported by the "a" tag and should be used when AngularJS code as in the example


Tuesday, June 20, 2017

Vienna is synonymous with Klimt

We could visit quite a few places. It was a very warm day and one can get quite tired.

  • Rococo style Schönbrunn Palace (UN Heritage Site) and its environs
The palace museum is huge and it reflected the opulence of the times. Room after room filled with art objects; huge mirrors; chandeliers and paintings.

  • Ringstrasse
  • Goudi styled Hundertwasser haus - Out of the ordinary, fairytale
  • Leopold Museum
  • Mozart Statue in the Palace grounds
    Albertina Museum
    Shopping, Karlsplatz  etc
Here are some slides of the day:

https://youtu.be/LpQUyy1NN28





Friday, June 16, 2017

A must place to visit near Budapest


We visited the picturesque town of Szentendre on the bank of Danube in Hungary not too far from Budapest. It is easy to reach there by bus. It is truly picturesque as you see in the pictures and if you are into painting you may like to visit. It has a beautiful church and there are restaurants although we did not eat there.

We visited this town during our recent trip to Europe and spent a delightful hour there on the way from Budapest to Vienna. Later we travelled to Vienna...

Arriving in Vienna we went out although it started getting dark. The subway (metro) is clean and convenient. Karlsplatz was where we headed to...






Thursday, June 15, 2017

Bend in the river Danube and the river cruise at night


It was more like a free time in Budapest.

We visited the World Heritage listed Gellert-Hegy (Hills) from where one can see the bend in the Danube river. The panoramic view is great. It was somewhat a hot day in June but it was quite breezy. We went up part of the way in a taxi (about 5 Euros) and came down in a bus. About half a mile from the hill top there was a fine restaurant that people go on special occasions. It was quite nice.

We looked forward to the boat ride in the night but half way during the cruise it started raining heavily. After the cruise we took a taxi to the hotel as it was still raining and somewhat dark.

Here are some pictures of the day:



Tuesday, June 13, 2017

Touring Budapest, Hungary by bus

Into the 3rd day of our European visit we toured Budapest by bus. We had a local guide who spoke reasonable English. Our tour director spoke English, German and Czech.

Touring a city by bus (Inside the bus) has advantages as you cover many places. The downside is you miss 'your feet on the ground' and the opportunity to look at things from a couple of directions. If you are some what hard of hearing and the sound system is less than adequate, you miss a awful lot of information the guide is giving.

Here is a short list of things you see in a day tour
House of Parliament
The Chain Bridge
St. Stephan's Basilica
National Opera House
The Central Market
Fisherman's Bastion
The river Danube
Holy Trinity Square

Here is a slide show video of our tour:




Sunday, June 11, 2017

Visit to Salt Mines and the Bavarian Alps


We left Arcotel Castellani early after breakfast around 8:00 AM in our bus. It takes just 30 or 40 minutes to reach Berchtesgaden in Bavaria, a mere 16.6 miles from Salzburg. This area is famous for its salt deposits and provided a rich commodity and a source of revenue for the people in ancient times. Because of this it was occupied by France, Austria(Salzburg) and Germany.

The visit to the salt mines was interesting. You need to purchase tickets to enter the Salt Mines and the shop. Shop alone is free where you can buy salt related products. You must wear the proper attire to the mines which you can wear over your clothes and store your other items in the lockers (2 Euros which will be returned). After wearing the special over clothes, you wait your turn to ride the rails. This was an interesting experience. However, there are also walk ways and staircases. After reaching the bottom of the rails you cross the subterranean salt lake in a boat with other visitors to visit the gallery in the museum. It is pretty well done with lots of stuff to see how salt was recovered and brought to surface for commercialization.

There appears to be a slat mine health resort, 'Heilstollen' where you can find relief for several kinds of ailments.
Berchtesgaden was also the holiday retreat for Hitler and his lieutenants. The Kehlesteinhaus (Eagle's Nest) atop the Kehlstein peak was a present to Hitler for his 50th birthday. We will visit the Eagle's Nest after visiting the salt mines

"Salt is the most valuable gemstone given to us by the earth." 

Justus von Liebig (known as the greatest chemistry teachers of all times)
https://www.britannica.com/biography/Justus-Freiherr-von-Liebig

Before embarking our journey to the Eagle's Nest, we had breakfast/brunch/beer/coffee at one of the smaller towns on the way. The bus to Eagles Nest takes you to an intermediate point after which you take a specially fitted bus to go another intermediate point. From here you take enter the tunnel to the elevator shaft. You then ride up to the disembarking area to walk to the Eagle's Nest. The view of Bavarian Alps from here is unforgettable. Cameras can only capture a fragment of this beauty.

Here is a slide show of this visit. Come back here later as I plan to upload at least one video.



Friday, June 09, 2017

Sightseeing in Salzburg, Austria



This is day 12 of our European tour and it was as exciting as it was tiring. We stayed at the Arcotel Castellani, Salzburg . It was quite comfortable and the breakfast was OK.

The Mirabel garden soon after the lifting of  rain was most beautiful, perhaps at its best. The city is divided by the river, the old town and the new. As is always true the old city is where you go and see most of the things. The house where Mozart was born is always crowded. Tourists milling around most of the times. The cathedral is very nice.

The 17th Century Roman Catholic Cathedral is another place you must visit. It was here that Amadeus Mozart was baptized (very obvious, the house where he was born is not too far). The Cathedral is dedicated to St. Rupert and St. Vergilius.

The Hohensalzburg castle is another place you must visit. You need to go up in a cable car and it is pretty steep. There are restaurants in the intermediate stage. The view of the city below is nice and keep you busy taking pictures.

Viennese Coffee at Tomasellis was quite good. We sat out on the terrace, but you can also sit inside the restaurant which retains some old décor.

The shopping district is never too far with lots of restaurants. I did find an Indian Restaurant run by a Punjabi and food was quite good. It was not purely Indian, you could have Italian as well as Mexican.

Here are slides from that visit.




Wednesday, June 07, 2017

Visting Český Krumlov on the way to Salzburg from Prague - Day 11

Český Krumlov is on the World Heritage list 1992. It is very beautiful with the castle, the monastery, and the gardens. A place you must visit if you are anywhere near Prague or Salzburg. Its early owners were Germans later acquired by Czechs.

You must see to believe how beautiful it is and the next best thing is to see its pictures on the Internet.

This one is a slide show of pictures taken with iPhone 6S and Lumia 950.



Sunday, June 04, 2017

Hands-on Learning Event in Honolulu 1 : Introduction to Structured Query Language


Course summary:

Databases - organized repositories of information have become indispensable. Knowledge of databases is a must for professionals and in fact even more relevant since the emergence of Big Data in today's world.

In this introductory course you will learn all about relational databases and the basics of Structured Query Language (SQL) including sorting; grouping result sets; using DDL, DML, DCL, and TCL. All SQL statements will initially be written for one table. Most practical, modern and relational databases will include a large number of tables and SQL queries have to access information from several tables. This course will then introduce you to querying more than one table. With this skill you will be able to query two or more tables in a database. This is a hands-on course which will take you from installing SQL Server 2016; learning the ins and outs of SQL Server Management Studio and of course a full dose of SQL. You will be both coding as well using Graphical User Interface during this training.

During each meeting the students will be assessed for their knowledge, competency and proficiency in SQL.





Databases, organized repositories of information, have become indispensable in today's world. In this introductory course you will learn about relational databases and the basics of Structured Query Language (SQL) including sorting; grouping result sets; using DDL, DML, DCL, and TCL. All SQL statements will initially be written for one table. Most practical, modern and relational databases will include a large number of tables and SQL queries have to access information from several tables. This course will introduce you to querying more than one table. With this skill you will be able to query two or more tables in a database.

This is a hands-on course which will take you from installing SQL Server 2012 to learning the ins and outs of SQL Server Management Studio and of course a full dose of SQL. The course covers most of the requirements to take Microsoft's certification (98-364), the Microsoft Technology Associate. During each meeting, you will be assessed for your knowledge, competency and proficiency in SQL.
Section 1 - Jul 6 - Aug 8; TTh; 5:30 pm - 7:30 pm; 10 mtgs (Register Online)

Microsoft SQL Azure Database: SQL Server in Microsoft Cloud
Windows PowerShell for SQL Server
SQL Server 2016


You may also contact the instructor: Dr. Jayaram Krishnaswamy at hodentek@live.com


Sauntering in Andel and Mustek - Must see places in Prague

There is a nice shopping center in Andel and many good eating places. Andel is well connected with many of the other places by Prague Metro which is clean and well run.

Mustek is part of Prague which has many churches, places of interest and other attractions. It has a lot of open air restaurants and side walk cafes. It is also a partying place. Foreign tourists crowd here to quench their thirst and hunger.

This is where we found the crystal and glassware vendor, Moser. Moser has two shops in Mustek.
Moser Glass
Na Prikope 12, Old Town, Prague 1, Czech Republic
Tel: +420 224 211 293




Saturday, June 03, 2017

Prague a beautiful city

Prague is a historic place with lots of church spires and Baroque architecture; a city cut in two by the Vltava river. Charles Bridge connects the two halves, the old town and the new. It is a truly beautiful city with ancient churches and history dating back to the Roman Empire. We had an optional tour to visit, a walking tour of Jewish Quarters. We missed it as we wanted to see more of the city.




Tuesday, May 30, 2017

Deep learning AI with Caffe2GO

You create a video and you want it the way Picasso or Monet would have visualized it. Can it be done? The answers appears to be answered by Facebook's Caffe2Go. It was easy with stills as many programs do it, but with a video it is another thing.

Caffe2Go is supposed to be third iteration of AI, the deep learning. This was possible earlier with big machines and lots of computing power, since the program has to learn the myrid images that these great artists envisioned it could not have been done otherwise. But to do it on the phone in the palm of your hand, that is something that Facebook seems to have pulled off, with the Facebook app Caffe2Go.

It is a deep learning platform on the mobile phone. The app takes the style of the artist and transforms the input video, it is basically a style transformer.

Here is a demo of this deep learning app:
https://www.facebook.com/Engineering/videos/1015460775164720

Monday, May 29, 2017

Creating Full-Text Catalog in SQL Server 2016 SP1

A full-text catalog is a logical container where a group of full-text indexes are stored. A full-text catalog is needed before you can create a full-text index. Full-text catalog is a virtual object and does not belong to the file group.

In order to text search a full-text index will be needed. For example, the Categories table in Northwind does not have a full-text indexed column. If you try to create a Full-Text indexed column you will get this error:
-----------
Msg 9967, Level 16, State 1, Line 11
A default full-text catalog does not exist in database 'Northwind' or user does not have permission to perform this action.

--------------

You can create a Full-text catalog using the SQL Server Management Studio or using Transact-SQL(T-SQL)
---------
Here is how it is created for Northwind database in SQL Server 2016 using T-SQL

USE Northwind
Go
Create FULLTEXT CATALOG ftCat_Nwind as default
Go

------
Before the above statement was run there was no Catalog:


After the above statement was processed the named catalog was created:


You can access the properties as shown here

All tables and views are eligible and you can assign the objects to the Catalog by transferring using the > button.

Creating a Full-Text catalog for Northwind using SQL Server Management Studio is easy. Right click Full-Text Catalogs in the Storage node and provide a name for the catalog and a owner. Choose the accent sensitivity and click OK to create.


The Catalog gets created as shown.

Is this the end of the story? No

Caution:
Although SQL Server 2016 SP1 allows you to create a Full-Text Catalog, you will find it missing in the System Views as in the following query.

This feature has not improved even from the older versions. It has not been fixed and the error messages that you get such as the following does not give a clue.

Property IsAccentSensitive is not available for the Full-Text catalog <catalog name>
Property PopulationStatus is not available for FullTextCatalog <catalog name>

The reason for this error is that the Full-Text feature was not installed in the first place.
Watch the video and review features not installed:

https://hodentekmsss.blogspot.com/2017/05/installing-sql-server-2016-sp1-for.html

Saturday, May 27, 2017

BitLocker behaving badly

This is the classic example of getting out of one problem and getting into another.

I had the virus problem (probably the ransomeware except that I did not click on any link and the threatening page did not go away after a reboot, etc.) on my Toshiba tablet with Windows 10 and decided to System Reset to clean the tablet. It went through the process and now requesting entering of a recovery key. There is a Key ID on the tablet (8 alphanumeric characters) and if I try to enter I get a basic numeric keypad like on a calculator with keys marked with only numbers.
It may work if I can enter. But how can I enter this 8 character ID using this calculator-like numeric keypad? and Drive Label with a date.



The tablet is on a Wi-Fi network with 3 other laptops (two running Windows 10 Pro and the other Windows 7 Pro)

It turns out that I am supposed to have a key and what was shown above was the KeyID (only the first part of it). The key itself is all numeric with 48 characters.

Finally I used the manage-bde commandline command to see what is going on.
Finally using manage-bde, I could find out that I have only the recovery key id without a recovery key.


What surprises me is that I never meddled with BitLocker as I do not have great secrets to guard. How come the BitLocker was locked in the first place? I toook the tablet to the Microsoft Store where they might be able to find some thing.

 It is not I don't have a key, I believe there never was one!

It is still puzzling, that since I did not lock the machine with BitLocker, who did?

According to Microsoft Store, when I signed into Microsoft Account the BitLocker by default locks it. It did not seem credible to me. I did not get the impression the technician was fully conversant with BitLocker. I avoided BitLocker for the simple reason, I did not want another layer of complexity to my files/folder that do not contain sensitive information.

One of the members of Microsoft Forum provided some background information of BitLocker's evolution. This is what might have happenned (his words):

"Earlier, Microsoft used to enable bitlocker on the home version of windows if
A a microsoft account was used
B the computer fulfilled the hardware requirements (TPM chip, instant-go compatible).
That was quite an idea... they even shot the recovery key through the network in plain text - some german IT magazine ("IX") discovered that. By now, they stopped it."

Tuesday, May 16, 2017

Microsoft's Globally distributed database, Azure Cosmos DB

"Azure Cosmos DB is Microsoft's globally distributed, multi-model database. With the click of a button, Azure Cosmos DB enables you to elastically and independently scale throughput and storage across any number of Azure's geographic regions. It offers throughput, latency, availability, and consistency guarantees with comprehensive service level agreements (SLAs), something no other database service can offer"

If you are looking for Global Distribution, horizontal scaling, guaranteed latency, high availability, comprehensive SLA's and unrivalled Data Model and APIs that no RDBMS, no no-sql database can provide, there is nothing out there to match Azure Cosmos DB.



Azure Cosmos DB Engine supports multiple database systems and it is based on the following:

 Atom: Consisting of a small set of primitive types (String, Bol, number)
 Records: Structs
 Sequence: Arrays of atoms, records and sequences

Azure Cosmos DB engine currently supports the following:

Document DB SQL
Mongo DB
Azure Table Storage
Gremlin Graphh Query API
It will support other API's in the future.

For developers looking for a globally distributed database system Azure Cosmos DB is the answer.

Wednesday, May 03, 2017

Hands-on training event in Honolulu: SQL Server Reporting Services 2012 in Native Mode



Updated information: SQL Server 2016 SP1 will be used

This hands-on course will provide you with the ability to create cutting edge reports using Microsoft's latest reporting services product, SQL Server 2012.
The course is offered by the Pacific Center for Advanced Technology Training(PACTT): http://pcatt.hawaii.edu/home
Report writing is one of the most important IT related jobs in an enterprise. This course is for you if you would like to master report writing/authoring using SQL Server Reporting Services. The course begins with a presentation of essential technical background, after which you will work through guided hands-on exercises.

At the end of the course you will have gained:

• A solid understanding of how to interact with SQL Servers
• Knowledge and experience installing and configuring reporting Services
• A working knowledge of using Report Builder to author reports and deploy them to report server
• A working knowledge of Report Manager's (Web Portal) ability to carry out administrative tasks related to all aspects of reports; creating shared data sources, folder and folder hierarchies on the report server, and report models; managing security and subscriptions; and configuring data driven subscriptions
• An understanding of how to embed report viewer controls in windows and web projects.


Venue: Honolulu Community College Honolulu Community College
874 Dillingham Blvd Honolulu, HI 96817-4598

Phone: (808) 845-9211

Official Website: honolulu.hawaii.edu/

Recommended Prep:
Computer literacy on a PC and experience using a database 


- Section 1 - May 18 - Jun 27; TTh; 5:30 pm - 7:30 pm; 12 mtgs


Thursday, April 27, 2017

This is how you save a report authored in Power BI to a Report Server - Final

I apologize to the readers of my post,Can you save reports created in Power BI to a Report Server?  for having given the wrong impression. The reports you create cannot be saved to any report server but the stand-alone report server created using the same .msi file downloaded from the same location where you downloaded Power BI Desktop Technical Preview.

I am only partly to blame for this and I apologize. Let me correctly present what kinds of reports can be saved to what kind of report server. The other reason for the problem was created by the Power BI itself for giving the wrong guidance for the users while saving the report to the report server. It must be changed.


  • The only kind of reports that can be saved to Report Server (strictly speaking, you are only saving it to the Web Portal URL) are the ones created with data from the Analysis Services server.
  • In order to save you need to configure a stand-alone Report Server whose database is stored not on a SQL Server 2016 but an earlier version. In my case I use the SQL Server 2012. The .msi file for this server is on the same download site as the Power BI Technical Preview.


After you fulfill the above conditions then only you can host the report.


I was able to get the correct server by an answer to my question on StackOverflow.com.


http://stackoverflow.com/questions/43402339/invalid-url-error-while-saving-power-bi-report-to-sql-server-reporting-services


Sunday, April 09, 2017

From PowerBi to Report Server, the easy way

If you use the Technical Preview version of Power BI Desktop. You can save reports to your on- premises SQL Server.

 NOTE: If you already have configured a SQL Server 2016 Reporting Services server you will not be able to upload the reports from Power BI. You need to install the SQLServerReportingServices.exe mentioned below and configure a Standalone SQL Server Reporting Services which will provide a http://<domain>/ReportServer.

You can download this for both x32 and x64 versions. With this you can,


  •     Connect “live” to Analysis Services models – both Tabular and Multidimensional (cubes)
  •     Visually explore data and create an interactive report
  •     Save that report to your report server running the Technical Preview
  •     View and interact with the report in your web browser

If you do have Power BI for Desktop on your computer you still need the (January 2017) Technical Preview. This can sit alongside your present Power BI.
=====================
Technical Preview of Power Bi for Desktop download link
https://www.microsoft.com/en-us/download/details.aspx?id=54610
=====================
Preview version details below:
Version:            Date Published:

0.1                1/11/2017

File Name:                                                               File Size:

PBIDesktopRS.msi                                      102.2 MB

PBIDesktopRS_x64.msi                           118.3 MB

SQLServerReportingServices.exe    49.6 MB



System Requirements:
Supported Operating System

Windows 10 , Windows 8, Windows 8.1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016

    You'll need
        .NET Framework 4.5.2 or later
        SQL Server Database Engine (2008 or later), to store the report server database
        SQL Server Analysis Services (2012 SP1 CU4 or later), to store your data models
    Links:
        Get SQL Server 2016 Evaluation
        Try SQL Server vNext CTP1.1

Find the correct way here:
The final cleaned up of this post is here:
http://hodentek.blogspot.com/2017/04/this-is-how-you-save-report-authored-in.html
http://hodentek.blogspot.com/2017/04/this-is-how-you-save-report-authored-in.html







Wednesday, April 05, 2017

How do the File Share account settings are used in SQL Server Reporting Services 2016?

This is feature is applicable only for Native Mode.

In order to specify a single file share account ( a new feature of SQL Server 2016) you must get to the Subscription Settings page of the SQL server 2016 Reporting Services Configuration Manager shown here.


The file share account that you set up here allows you to set a single set of credentials in multiple subscriptions that deliver reports to a file share.

When you want to change credentials you just change the credentials of the file share and you need not change the credentials of every subscription in the shared folder. In the subscriptions in the file share each subscription will specify; Use file share account.

However you may also configure individual subscriptions with specific credentials as well or, have some on file share and some with individual specific credentials.

Author your first report using SQL Server Mobile Report Publisher

This post is about displaying a Mobile Report created by the SQL Server Mobile Report Publisher after publishing the report to a SQL Server Reporting Services which is actually the Web Portal URL of the Reporting Services.

The present Reporting Services configuration is pertinent to SQL Server 2016 Reporting Services on the local machine.

While it should also be possible to publish it directly from the SQL Server Mobile Report Publisher, it was not possible because there were errors connecting to the Report Server although the SQL Server 2016 Database Engine; the Reporting Services were all up and running and an empty folder 'Reports' was created on the Web URL. I have not tried to verify the problem yet. This could be because of the constant upgrades coming to the OS automatically.

In this post, I consider uploading a report to the Web Portal URL after saving the file created by the SQL Server Mobile Report Publisher to a local folder.

You need to make sure the Reporting Services database is accessible which the same as the SQL Server Database Engine  running; the Reporting Services has started and the Service and Web Portal URL have no problems.

Then use the Upload button on your Web Portal URL to upload the report created and saved (to local file system) to the computer. Once it gets uploaded the report gets into the WEB Portal URL as shown.




The Northwind Report has three charts, the creation of one of them is detailed in my earlier post here. I have just added two more grid items this upload.




You can view each of them on the WEB Portal URL as well as shown here.


http://hodentek8/Reports_OHANA/mobilereport/Northwind

Herein http://hodentek8/Reports_OHANA is my Web Portal URL.








DMCA.com Protection Status