It seems in Windows Server latest versions the good old disk clean up tool is not enabled by default. If you just want it back you can run the below commands in a command prompt to copy the required files.

Copy C:\Windows\winsxs\amd64_microsoft-windows-cleanmgr_31bf3856ad364e35_6.1.7600.16385_none_c9392808773cd7da\cleanmgr.exe C:\Windows\System32\

Copy C:\Windows\winsxs\amd64_microsoft-windows-cleanmgr.resources_31bf3856ad364e35_6.1.7600.16385_en-us_b9cb6194b257cc63\cleanmgr.exe.mui C:\Windows\System32\en-US\

Then create a shortcut pointing to the Disk Clean up tool found in the following path.

C:\Windows\System32\CleanMgr.exe

I did try this on Windows Server 2008 R2 and hope it works as it is or with slight changes on other versions of Windows as well.

Advertisements

Recently I needed to filter the results of a Stored Procedure, After some searching I found 2 options for this as below.

1. Using OpenRowSet Command

SELECT * FROM OPENROWSET (‘SQLOLEDB’, ‘Server=ServerName;TRUSTED_CONNECTION=YES;’, ‘EXEC sp_Who2’)

Remember in this method this feature should be enabled in the server.

2. Using Temporary Tables.

— Creating a temporary table.
CREATE TABLE #tblSPWho2
(SPId INT, Status NVARCHAR(200), LoginName NVARCHAR(200), HostName NVARCHAR(200), BlockedBy NVARCHAR(200), DBName NVARCHAR(200),
Command NVARCHAR(200), CPUTime BIGINT, DiskIO BIGINT, LastBatch NVARCHAR(200), ProgramName NVARCHAR(200), SPId2 INT, RequestId NVARCHAR(200))

— Inserting the results of the Stored Procedure into the temporary table.
INSERT INTO #tblSPWho2
EXEC sp_Who2

— Doing the required filtering using the temporary table.
SELECT * FROM #tblSPWho2 WHERE LoginName = ‘Domain\UserName’

— Removing the temporary table.
DROP TABLE #tblSPWho2

SP_Who2 Stored Procedure will bring all the processes that is currently active in SQL server with the relevant information, the above query will filter the results and will only display the processes that are initiated by the given username (Domain\UserName).

Today a friend of mine started getting this error while he tried to deploy his solution to a server. This only started when ‘Precompiling during publishing’ option is selected.

image

“Error 20 It is an error to use a section registered as allowDefinition=’MachineToApplication’ beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.”

After having a look, I identified this was caused by a temporary copy of a Web.Config file. Earlier developer created a copy of the Web.Config and placed it inside a folder named Backup within the solution. This backup config file had authentication tag (<authentication>), which is a tag that can be only used in global Web.Config file or the Web.Config file in applications root. Due to the presence of authentication tag, compiler started complaining that there is a virtual directory not configured as a application in IIS.

The solution for my friend’s issue was to simply exclude the copy of the Web.Config file from project by right clicking the file. Then the project started deploying happily.

Have you heard the good news that SriLankan Airlines is going to restart their direct flights to Australia. Yes it is true, SriLankan is going to start direct services between Sri Lanka and Australia from November 2017. They have decided to do this after acquiring brand new aircrafts from Airbus Industries. So when compared to other airlines, you will fly in more recently built modern aircraft with SriLankan.

SriLankan A340

SriLankan A333

With this new competition I think we will see better fairs to more Asian destinations. Introductory prices for the month of November 2017 from SriLankan seems very good as you see from some of the screenshots I have taken from the web site. Reserve your seats quickly by visiting SriLankan web site.

image

imageimageimageimage

As you may be knowing, now you do not need to separately download and install .Net framework as we used to do with the older .Net frameworks. Since it is coming with Windows, you can just go to “Turn Windows Features On or Off” screen and enable framework you are after. It is simple right?

But in one of the machines it was not that simple for me. The installation tried to download files from Windows Update and was failing mentioning that it cannot get connected to Windows Update when the machine is connected to the internet without any issues.

The solution is to use DISM (Deployment Image Servicing and Management) tool to get it installed.

First you need to find a Windows setup media, a setup DVD or an ISO downloaded will work.

Then use the below command to enable the feature using a local source. Remember to open the Command Window as an Administrator of the machine.

DISM /Online /Enable-Feature /FeatureName:NetFx3 /All /LimitAccess /Source:E:\Sources\sxs

/Online – Targets the currently active and running OS.

/LimitAccess – If some installation files are missing, this will check Windows Update for the missing files. For not to check use /LimitAccess:True.

/Source – Is the location to find the source files, E: is my virtual drive which I mounted the previously downloaded Windows ISO.

If typed correctly, there will be a progress bar showing the installation progress.

image

If you are interested in waterfalls and not too fussed about the height, I think you will like Genoa falls in Genoa in the state of Victoria, Australia. Belonging to the Croajingolong National Park, Genoa falls is a set of small cascades of water each with a height of no more than 3 meters, located near the Victorian and New South Wales border.
Genoa falls is located in about 488 kilometers East from the city of Melbourne and can be reached in about 5 and half hours’ drive. Access to the falls is via an unsigned dirt road which can be easily missed. I am sure there are many who are passing in Princess highway daily without knowing there is a small waterfall in this location. After turning to the dirt road, you just need to drive about 200 meters to reach the place to park the car. There is space to park 3 or 4 cars comfortably. This will not be a problem since this is not much of a famous attraction, so you will find space to park your car at any time of the year.
At the car park, there will be a small sign mentioning that you are in the Genoa falls in Croajinolong national park. Camping, open fires and pets are not allowed to make you and others safe at the location. You have to walk about 500 meters to reach Genoa waterfall from the car park, I would say the walk is moderately difficult because the last part descending to the Genoa creek is having one or two steep steps and path is narrow. Better look for reptiles such as snakes and lizards on your way. Keep a good eye at your children if you got them on your trip since the area is hazardous specially with uncovered waterholes.
Once you go down the final set of steps, turn left to reach the main attraction. It is a Basalt floor all the way to the waterfall with random water holes. In dry weather, you will be able to reach the waterfall without getting your feet wet.
After the waterfall the stream will divide into two parts, one will be going behind the boulders and hidden, the other smaller stream will be visible, follow it downstream. In about 30 meters, to your left you will see the other stream joining back with two small waterfalls.
Another good thing is that you can walk the breadth and length of the stream in dry weather without getting wet. When wet, be mindful, the area will be slippery with the algae build-up. I feel the water is bit Ionic from the slight Brown colour seen.
Apart from space to park the car, there are no facilities available on site. So, if you plan to have a barbecue or a picnic, this is not the place. Also, be prepared to carry your garbage out, since there are no garbage bins available.

Score out of 5
1 Parking Availability Adequate

3

2 Wheelchair Access Main Viewpoint – No

Secondary Viewpoint – No

Picnic Areas – No

0

3 Accessibility Moderately difficult walk of about 15 minutes from car park.

2

4 Facilities Covered Sitting Areas – No

Toilets – No

Barbecue – No

Garbage Bins – No

1

5 Scenery Waterfall

Stream

Mountains

3

Hope you will enjoy the video.

Map

In my recent travels to Victoria I visited the Loy Yang power station. This power station consists of two sections named as “Loy Yang A” and “Loy Yang B” which was built in 1980s, both these plans are coal fired thermal power stations. Taken together these generate 4300 MW of power which is about 30% of Victoria’s current power needs and is the largest power station in Australia (when taken together). AGL owns and operates Loy Yang A and the adjacent coal mine.

There are no tours to look inside the power station but there is a picnic area where you can see the plants from a distance.

      Score out of 5
1 Parking Availability  

4

2 Wheelchair Access Easy

5

3 Accessibility Easily accessible within about 3 minutes walk from carpark.

4

4 Facilities

No covered sitting areas.

Toilets – No

Barbecue – Yes

2

5 Scenery  

2

 

Map