It is very easy to install SQL Server 2017

Installing SQL Server has gotten a lot easier compared to versions earlier than 2016. Installing SQL Server 2017 (a default installation) is a breeze. After you install SQL Server you are guided to install the required client tool, the SQL Server Management Studio.

Here are some screen shots with some explanations. They are mostly sequential.

Installing SQL Server 2017

Click to enlarge the picture and follow the link [ https://www.microsoft.com/en-us/sql-server/sql-server-downloads ] to the download page and choose a on-premises, developer edition. The next images on this post assumes a Windows 10 platform. You can get SQL Server 2017 on LINUX and MacOS as well.

Click double click the downloaded file to begin importing files and installing.

I chose the Basic option. When you click it the background turns blue.

Before proceeding you need to accept the license terms.

It starts installing and shows the progress.

Well, you have a default instance of SQL Server 2017 installed. Boy! was it easy. It also starts the SQL Server Database Engine Service immediatley. You may have to restart the computer at this point.

Installation is a Success!

The following shortcuts were added to my All Programs.

I opened up the SQL Server 2017 Configuration Manager from the above and checked out that the Server indeed installed.

Installing SQL Server Management Studio

If you need to work with SQL Server 2017 there is no better visual aid than SQL Server Managment Studio. 

Clicking InstallSSMS button on the previous image maked [Installation is a Success! ]takes you to the next site. You may need to do nothing for this to install. In my case, it did not complete. My download was interrupted and only got a partial file.

I downloaded the SSMS file from here.

This is the executable for SSMS.

Double cliking the executable begins installing the SQL Server Management Stuido 17.9.1.

Click Install.

 Installation is complete.

Although I was expecting only SSMS, a whole lot of programs were added. Is it real, or the others shortcuts were added after SQL Server 2017 installation and restart of the computer, I cannot say,

Starting the SQL Server Maangement and Connecting to the SQL Server 2017

First check if the Windows Service for SQL Server 2017 Database Engine has started and if it has not you can start here.

Now click the SQL Server 2017 Management Studio in your All Programs menu above.

Now display the SQL Server 2017 from the lis tof Database engines as shown and click connect. You do not need to do anything else as the installaiton program has set you up as the Owner with your Windows Login.

In the Browse for Servers window highlight the Database instance [Hodentek9-New in this post] and click OK. The Server name appears in the window left to it and click Connect.

After a little checking you get connected. Now you can expand the Object Explorer to have the first look at the objects on your default instance as shown.

That's it folks. You are cooking!

Installing Azure Data Studio

As per previous post SQL Operations Studio has become Azure Data Studio.

You can download from this site here:

https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-2017

You will be downloading this executable file:

azuredatastudio-windows-setup-1.2.4.exe (77,371KB)

You can double click and install. Here are some instllation screen shots.

After clicking Finish you should find the app added to your All Programs.

Because of your choice, the file will be in this folder.

C:\Program Files\Azure Data Studio\azuredatastudio.exe (64.5MB)

Perugia on the way to Tuscany - September 28,2017

September 28, 2017

We left Orvieto and travel to Tuscany to taste its wine and take in its splendid scenery. Along the way we stop at Perugia, an Etruscan stronghold in the past but which came under Romans later. the Papacy and travails of WWII effectively made Etruscans disappear. It is the provincial capital of Umbria.

Source: https://www.distancesfrom.com

The city of Perugia has a hilltop area (669 ft above sea level) which has all the main sightseeing places and can be reached by a Mini monorail, a fully automated driverless transport system. Perugia also has a town in the foothills. To escape the mosquitos it appears that hill-top city was built.

We used the Mini metro as a group to go to the hilltop city. Metro Pichetto.

The main attractions that we could cover in our short visit were the Papal built underground city merging with the remains of Etruscan's constructions; the Vittorio Emanuel the II's statue in Piazza of Italy; the group of important sights - the Fontana Maggiore; the National Museum of Perugia; the St. Lawrence’s' Cathedral and the Palazzo dei Priori; and the main streets of Perugia connecting all these locations.

Our main regret was we could neither enter the Cathedral nor visit the museum which appears to have some important paintings.

Here are some pictures of our visit.

Perugina Chocolate shop. They also gave out samples distributed by our tour director.

Eglo was a communist and cousin of Ricardo Tenerini who organized the resistance during WWII.

Exit from Rocca Paolina, the Etruscan underground city. 

Statue of  Vittorio Emanuel the II. Source: Bing Maps

Lunch at the Caffe Blu. All water carafes are blue.

Just entered the museum but did not visit the interior. The Galleria Nazionale dell'Umbria is hosted in the upper floors of Palazzo dei Priori, with the entrance in Corso Vannucci. 

 Fontana Maggiore from Bing Map. It is next to the St. Lorenzo Cathedral.

The Fontana Maggiore is a monumental medieval fountain located between the cathedral and the Palazzo dei Priori in the city of Perugia in Italy. It was made between 1277 and 1278 by sculptors Nicola Pisano and Giovanni Pisano. The hydraulics were by Fathers Bevignate and Boninsegna. [Source: Bing Search]

Watch Video Here:
https://www.youtube.com/watch?v=XYzmpp8lw7Y&t=6s

https://www.charminly.com/perugia-a-walk-in-his-underground-city/

We will be leaving around 2:30 PM on our way to Tuscany.

Arriving at Hotel di CorteFreda

We were welcomed by the staff of the hotel, with an assortment of snacks, Prosecco and wines of the region. The hotel has its own winery. We all sat in the courtyard at the back of the hotel and sipped wine.

This was when I began drinking the wine after the course of antibiotics. I felt good.

Love truly begets pleasure and love. These do not exist where there is no wine.