Tuesday, July 23, 2013

I have Windows 7 on my laptop, can I dual boot?


Yes you can.

If you have set up dual boot, you will come up with a window as shown when you start up.



If you want to go to Windows 7 you click on Windows 7 or, on Windows 8 otherwise. If you do not take any action within a certain time it will boot to Windows 8.

Even if you are in Windows 8, you can access the files and folders in Windows 7. If you are the administrator you can access files and folders.

How do I set up dual booting?

These two posts show you, how you can.

This post shows how you can set up your Windows 7 computer for dual booting.
http://hodentek.blogspot.com/2012/08/windows-8-rtm-is-out-go-grab-it.html

The following post shows how you can install Windows 8 after preparing the computer as shown previously. I used a evaluation copy but you can use the full version you have.

http://hodentek.blogspot.com/2012/08/installing-windows-8-rtm-enterprise.html

Friday, July 5, 2013

What are data bars in SQL Server Reporting Services 2012?

Looking at a bunch of data does not give a feeling for the big and small values without making comparisons by reasoning.


This comparison is built into the idea of presenting data bars in Microsoft programs such as MS Excel and Microsoft SQL Server Reporting Services 2012.

If you have used Microsoft Excel (for example MS EXCEL 2010) you would have come across what is known as 'conditional formatting'. In MS Access you could format a range of data with several conditional formatting options such as data bars; color scales; icon sets; and value dependent highlighting.


The first step in applying this formatting is to access Conditional Formatting menu in the Ribbon as shown.


Next you highlight the range of data to which you want to apply data. For example, in the first figure, the whole column 'Item Value' consisting of 6 values.

After you highlight the values (do not highlight the column heading), click Conditional Formatting (to access this you must be in 'HOME'). This displays a drop-down menu and their menus as shown.

Now you can pick the type of formatting you want to apply. For example, you can choose Color Scales and pick the one that appeals to you from its drop-down. Similarly, you could choose the other options instead.

The following figure shows several types applied to the same set of data and I am sure you intuitively know what they mean.

The first one 'Data Bars' shows how your data appears as rectangular boxes (horizontally drawn) whose length is proportional to the data. Probably with 6 numbers you may not need this as your eye can easily notice. What if you had 50 numbers?

Data Bars were added to Report Builder 3.0 which was released with SQL Server Reporting Services (SSRS) 2008 R2. They continue in SSRS 2012. In SQL Server Reporting Services 2012 you could do the same with the reports you author. This is explained in Chapter 5 which describes the use of Report builder 3.0 in my new book, 'Learn SQL Server Reporting Services 2012' released recently in June 2013.


The details are available at this link:



 Databars related page from the book:








Wednesday, April 17, 2013

How do you make changes to Application Pool Settings in Internet Information Services?


Sometimes the Identity of the Application pool settings needs to be managed. You may make modifications in the IIS Management Console as shown.

1. Type-in “IIS” in Start | Search of the desktop. In the pop-menu click on Internet Information Services (IIS) Manager 

The Internet Information Services Manager’s page will be displayed.

2. Click on Applications Pool in Connections . The list of Application Pools will be displayed.

Let us assume that the identity of SecurityTokenServiceApplicationPool needs to be changed.
3. In the list of Application Pools right click on the above Application Pool as shown.

4. Click on Advanced Settings...
The Advanced Settings page is displayed as shown.
In the Process Model, the identity is a Custom Identity (in this case that of the IIS Administrator).You may change it by hitting the ellipsis button of the identity.

5. Click the ellipsis button.
This brings up the Application Pool Identity page.





These are built-in identities. The next option on this screen is the Custom identity which has been set using the identity (HodentekWin7\mysorian) which has Windows Authentication. On the Advanced Settings page you may modify other parameters as well.

Finally, when you make changes to Application Pool in IIS you will have to run if you are changing this for a SharePoint farm standalone or otherwise,

Thursday, January 31, 2013

How to start an IE browser with Administrator's privileges?


Some programs even though opened in a browser, needs special permissions, usually that of the adminsitrator's pemissions.

You can always right click IE browser and click Run as administrator

However you can set it up so that it always opens in the above manner.

Review the next image:





 

How do I find the number of cores in the computer?

The following procedure showed that I have 8 cores in my Toshiba Laptop (Satellite P775).

Click Start | Computer |

Right click Computer to look at Properties (Click Properties from the drop-down menu).


Click Device Manager.



Click Processors.


Count the number of processors. They all have the same name.

Right click one of the processors and look at the properties to see the version and the name of SYS file as shown.
 
Mahalo

 

Monday, December 3, 2012

How do you copy from Notepad and paste to command line(DOS)?

Sometimes you may want to run a huge script from the command line but you hesitate to type it into the DOS window. In such cases you may want to type the script into NOTEPAD where you can more easily edit and then paste it into command line. Is this possible?

Yes, you can do it. First you have to run the DOS program with elevated permission, that is as an administrator. Once you do that you can paste it into the command line.
Step 1:
Run CMD with Administrators permission.

The DOS program starts

Step 2:
Prepare your script in NOTEPAD such as the one shown here.

Highlight the script you want to run and copy it to clipboard

Step 3:
Right click in the open DOS screen to pop open drop-down menu.

Click Paste (Control-V does not work). Your text is now copied to command line.
You are done!!

 

Thursday, November 15, 2012

Do you want to upload 2GB files to sky?

Aloha from Bengaluru

Microsoft SkyDrive has just released the stuff that helps you to upload 2GB files. That's hefty!!

You can also pick and choose files that you need (Selective Sync) from SkyDrive as well as better organize your uploads. SkyDrive also has a SkyBin. You don't need it, send it to SkyBin and, you want it, get it restored.

Web, Mobile and Desktop (WMD, not that WMD) boundaries are disappearing. They are all one and the same, your stuff, but just 3 avataras.

Note: SkyBin is the blogger's construct.




Organize

















Share / Sync












Skybin (Recycle bin on SkyDrive)