Thursday, November 30, 2017

Walking tour of Amalfi, Italy

September 20: It was a beautiful day in Maiori. We boarded a ferry at Maiori wharf to cruise along the Amalfi coast and visit Amalfi.

Amalfi Coast Boat ride:



After disembarking from the boat at the Amalfi wharf Katia (tour director) marched us through the portals of the city.

Named after a nymph who was in love with Hercules and buried here as the legend goes, Amalfi of former maritime glory being one of the four maritime republics (Genoa, Amalfi, Venice and Pisa) is a coastal town of what is called Costeira Amalfiana. Amalfi commanded the position as a major maritime force in the past but is now history. Traders from as far as Arabia, India and China appeared to have traded with Amalfians. Present day Amalfi is a well-known tourist attraction teeming with folks from all over the world.



It was the English aristocracy who came and enjoyed their time in former times , and now even folks like us can come and enjoy.

We could see the imposing cathedral as soon as we entered the town and St. Andrew’s statue was right next to it. We also had access to a local guide provided by Smithsonian Journeys who explained the history of Amalfi; the various details of the Cathedral and how it was modified couple of times; and the history of St. Andrews’ relics buried in the Cathedral.



We walked around the Amalfi town visiting the town square learning the architectural style of the Cathedral; the structure of the city with hidden lodgings carved into the mountain for people to hide for periods of time during enemy invasion and how maritime history came to an end and tourism began.

Katia also took us to see the network of passageways threaded into the mountains where folks hid from enemy eyes during enemy incursions into the city. We also visited a small chapel in one of these grottos maintained by a lady of advanced years where children were collected and cared for during the enemy incursions.




Coastal scenery; boats and ships in the ocean; colorful landscape; embarking / disembarking tourists; picturesque houses precariously perched on the vertiginous mountain slopes; lemon farming on terraces on the mountain slopes; gives Amalfi a unique appeal shared by other coastal towns in the same region like Sorrento and Positano which we will be visiting soon. Amalfi is one of several coast towns in this region included in the UNESCO World Heritage Sites.

We then visited Museum of Paper. The Museo Do Papel De Amalfi, the 14tth Century, oldest surviving paper making facility in Amalfi is certainly worth a visit. It is still in working condition producing the Bambagina paper much valued in Europe and elsewhere. The guides here are truly professional and explained its history; the various engineering pieces bringing water from mountain top to the cisterns; the hydraulic system driving the water wheels of the factory; and how the paper was made.


One of our fellow traveler was able to demonstrate paper making by picking the paper slurry and putting it on a drying cylinder. You can buy the Bambagina paper besides other kinds of paper in the museum shop.

Walking tour of Amalfi:  Click to see Video




There are objects of the bygone maritime era in museums such as the Museo Civico.  Right next to it was the 'Emerald cave' which we missed.



We also walked by an imposing war memorial marked for the years 1935-1945.



It was past noon when we had lunch at this very nice water front restaurant called Marina Grande. The food was excellent and the service, a little slow, getting the bill slower, but OK.

After lunch we go visit Ravello.



Ci vediamo piĆ¹ tardi a Ravello!

Wednesday, November 29, 2017

Update query with TABLOCK hint

TABLOCK is one of several table hints in SQL Server which includes the following:

   FORCESCAN 
   FORCESEEK 
   HOLDLOCK  
   NOLOCK  
   NOWAIT 
   PAGLOCK  
   READCOMMITTED  
   READCOMMITTEDLOCK  
   READPAST  
   READUNCOMMITTED  
   REPEATABLEREAD  
   ROWLOCK  
   SERIALIZABLE  
   SNAPSHOT  
   SPATIAL_WINDOW_MAX_CELLS = integer 
   TABLOCK  
   TABLOCKX  
   UPDLOCK  
   XLOCK 

Table hints can be used with any of the following operations:
Applies to:
DELETE
INSERT
SELECT
UPDATE
MERGE

Here is a query that updates a value in the Northwind Shippers table:
----------
Use Northwind
GO
UPDATE  Shippers
WITH (TABLOCK)
SET CompanyName='Speedy Gonsalez'
WHERE ShipperID=1
--
SELECT * from Shippers
------------
The query updates the name of the shipping company whose ID=1 to a new name. When TABLOCK is used in the above manner it should be within the parenthesis.


Read this recommendation from Microsoft:

"An UPDATE statement always acquires an exclusive (X) lock on the table it modifies, and holds that lock until the transaction completes. With an exclusive lock, no other transactions can modify data. You can specify table hints to override this default behavior for the duration of the UPDATE statement by specifying another locking method, however, we recommend that hints be used only as a last resort by experienced developers and database administrators"



Tuesday, November 28, 2017

ASP.NET Web Application templates in VS 2017 Community

The Web application templates in VS 2017 Community has not changed much from those available in VS 2013 except that the Facebook web application has disappeared and a new Azure API App has been added. You can add folders and core references to:


Web Forms
MVC
API


The various templates available in VS 2017 Community are:
  • Empty - No content but a template for creating ASP.NET applications
  • Web Forms-For building event driven dynamic web sites with drag and drop support. You have whole toolset of controls and components
  • MVC - Using Model-View-Controller architecture with support for test-driven apps
  • Web API-Use RESTful HTTP services that can be used by broad range of clients-browsers and mobile devices
  • Single-Page application Client side rich JavaScript driven HTML5 with CSS3
  • Azure API app-Microsoft Azure API apps for hosting REST APIs as well as API Market place. They can be consumed by mobile, desktop and web apps
Visual Studio 2017 templates:

Visual Studio 2013 templates

Sunday, November 26, 2017

Windows 10 and Universal Windows App

UWP is an app for the Windows 10 and Windows 10 runs on a number of hardware devices: PC, tablet, Xbox, HoloLens, Surface Hub etc. UWP with just one API set and one app package and one store can reach all screen sizes from the smallest to the largest.

It can support different modes of interaction;
touch
mouse + key board
pen
game controller

Programming UWP apps is very flexible, just not limited to C# and XAML. You can use JavaScript(& HTML). You could also use Unity or MonoGame. You can mix them as well.

You will create just one project for (any) every device you want to address.

Let me enumerate the features:
  • Common API surface across all devices
  • Extension SDKs to do specific stuff on chosen device
  • Apps packaged using .AppX packaging format and distributed from store
  • One store for all devices
  • Adaptive controls and input are supported(Keyword Responsive design)
Go on, monetize your app!

Friday, November 24, 2017

Create SQL Server 2016 ODBC DSN using Report Builder

ODBC source is one of the many sources that you can connect to in Reporting
Services using the Report Builder.

Here are the steps. It is assumed you have SQL Server 2016 SP1 installed; Report Builder is also
installed on the same machine. For these steps it is assumed that the SQL Server is up and running
and you are the owner of the computer who installed the SQL Server.

1. Launch Report Builder with Administrative Privileges.
2. Right click Data Sources and Click Add DataSource... to bring up the Data Source properties window.
3.  Provide a name for the data source, DS_ODBC
4. Choose Use a connection embedded in my report
5. Select connection type: click handle and choose ODBC at the bottom of list
6. Click Build... to bring up the Connection properties window
7. In the Data source specification section choose Use connection string:
8. Click the Build... button that gets activated to display Select Data Source window
9. Click Machine Data Source
10. In Machine Data Source tabbed page, click New... to display Create New Data Source
11. Accept the default, User Data Source and click Next
12. In the Select a driver for which you want to set up a data source, scroll down and
    select SQL Server (SQLSRV32.dll); click Next to display the next window
13  Click Finish. Create a New Data Source to SQL Server is displayed
14. Provide a name of your choice (ODBC_DSN); Description:(ODBC for Report Builder); Server
    use handle to locate: Hodentek9\OHANA. Click Next
15. Accept the default in the displayed page: with Windows NT authentication using the
    Network login id. Click Next
16. Change the default database by clicking handle to Northwind. accept all other
    defaults. Click Next
17. Accept all defaults on the displayed page. Click Finish
18. In the ODBC Microsoft SQL Server Setup page test the connection and make sure it works. Click OK
19. ODBC_DSN enters the Machine Data Source tabbed page. Click OK
20. SQL Server Login window gets displayed. Enter creator owner's credentials
21. Copy the connection string from the connection properties window.
Dsn=ODBC_DSN;description=ODBC for Report Builder;trusted_connection=Yes;app=Microsoft SQL Server;wsid=HODENTEK9;network=DBNMPNTW
22. Test Connection to make sure it works
23. Click OK
The Connection string enters the Data Source Properties window as shown.







Map with Microsoft Excel

Excel provides excellent, easy-to-use MAP element that can be inserted into an Excel spreadsheet. It is easily accessed from the Insert menu item as shown. Of course your data must have geographical data.


Let us get some data into a work sheet. Click create Data and use the option to get from the Web. Let us use some data from Wikipedia which in turn shows data from Indian census. Let us use the Basic option.


Click OK.


You will get the next window that you are accessing the web content anonymously.

Click Connect. The connector starts connecting to the Demographics of India source.


When the connection succeeds you can access a bunch of data that comes into the Navigator pane of  a pop-up window as shown.


There is a wealth of data to be analyzed in the Navigator. We just choose the one shown, ‘Population between age 0-6 by state/union territory. This displays the data in the Table View pane as shown above.

Click Load to load the data into your Excel application in Sheet 1 as shown.


Excel has this nice feature of displaying the Recommended charts as you begin to insert a chart. It also shows how to do it as shown next. When you choose the whole data and try to bring in a Map, you will sent to BING (map provider) because BING  has the right map to provide and of course you need to accept their terms. When you accept, Map of the World comes up which now focuses on India as shown in the next window.


Note that it has already added the Min and Max values of the data. Clicking any particular map region shows the data for that region.


Now you can pretty up the map with all sorts of details using the Chart Elements.


Don't you think that was easy as 1-2-3?








Tuesday, November 21, 2017

Power BI and OLE DB Provider MSDASQL

Power BI does not support the Microsoft OLEDB Provider for ODBC Drivers also known as MSDASQL.

Power BI uses the .NET Framework Data Provider of OLEDB (System.Data.OLEDB).
This was found while connecting Power BI to Microsoft Excel using the connection string developed using a (Universal Data Link) UDL file.
----------
[oledb]
; Everything after this line is an OLE DB initstring
Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=Excel7_11;DBQ=C:\Users\Owner\Desktop\Blog2017\MSSS2017\Hindu_Islam_old.xls;DefaultDir=C:\Users\Owner\Desktop\Blog2017\MSSS2017;DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5;";Initial Catalog=C:\Users\Owner\Desktop\Blog2017\MSSS2017\Hindu_Islam.xlsx
----------------------------
Also Power BI does not support the Persist Security Info attribute set to false.
This is the error message about OLE DB Provider support.



DMCA.com Protection Status