Display exactly 2 digits after decimal without Rounding on SQL Server

let say, we had a value 7.35642132 on sql query return, then we want to display it only exactly 2 digits after decimal without Rounding, here is the way :

to get only two digits after decimal for a value 7.35642132
Select LTRIM(RTRIM(STR(7.35642132,10,2)))

the results is 7.35

Enable content expiration under IIS 7

In IIS6, it was with the website properties –> HTTP Headers. Here in IIS7, you can do this on the “HTTP Response Headers” feature on the website.

  • Select the website in the Connections pane.
  • Double click on the “HTTP Response Headers” feature in the features pane
  • In the action pane, click on the “Set Common Headers…”

image

  • You will see the following popup

image

Now, you know what to select. You should enable the HTTP Keep-Alive on this popup only.

 

Source : http://blogs.msdn.com/b/rakkimk/archive/2007/07/10/iis7-how-to-enable-content-expiration.aspx

Excel 2003 Add-in: XML Tools Add-in

Instructions

To install the add-in, complete the following steps:

    1. Start Excel.
    2. On the Tools menu, click Add-Ins.
    3. Click the Browse button and navigate to the .xla file.
    4. Select it and then click OK.
    5. Click Yes to any file copy or overwrite prompts.

 

How to install Add-in in MS Excel 2007

1. Click the ball office logo at the top-left of the program
2. Click button “Excel Option”

3. Select item “Add-Ins”
4. Select “Excel Add-Ins” in Manage list box and click button “Go…”

5. Tick the add-ins that you want and click button “OK”

Convert a Excel workbook to an xml file

This post is a bit off topic for this blog but I’ll post it anyway as a reminder for myself and hopefully to help others who want to do the same. At a client someone had to convert a very simple, plain, flat text excel 2007 workbook to an xml file format.

I have made an example to let you see how to do this. Below you see the workbook that has to be converted to xml.

exc_workbook1

I thought that just saving the file with “save as” to xml format would do it but I thought wrong. I got an error that there were no XML mappings found in the workbook. For Excel 2007 you need a add-in that is called OfficeExcel2003XMLToolsAddin.exe and which can be downloaded here. On the download page you can also read how to install and open the add-in in Excel 2007.

Read more: http://www.information-worker.nl/2010/04/19/howto-convert-a-excel-workbook-to-an-xml-file

Unlocking files that are in use

Sometimes you cannot delete or rename a file that is currently in use. You might receive an access violation error, or simply a message telling you that your action could not be completed because the file is open in another program.

image

You may have already come across the Unlocker freeware tool that lets you “unlock” files that are in use by some application.

Here is another way (let’s call it the ‘techie’ way) to unlock files that are in use. It makes use of the Process Explorer tool from Windows SysInternals.

  • Download the Process Explorer tool. Execute procexp.exe
  • Choose Find Find Handle or DLL option

image

  • Type the name of the file you want to unlock and hit Search.

image

  • The process EXE locking the file and the path to the file are listed. Double click on the result.

image

  • The file handle will be highlighted. Right-click on it and choose Close Handle.

Your file is now unlocked and can now be deleted, moved or renamed.

A little disclaimer here, closing handles might cause data inconsistency, loss and/or other undesirable effects. Make sure you understand what you’re doing before you do it.

Add RunAs to Explorer Context Menu in Vista and Server 2008

As a Domain Admin for a small or large corporation, it’s NEVER a good idea to login as the Domain Admin (or other privileged user) to read email or surf the Internet.  After all, if you pickup a nasty bug/virus, from Outlook or Internet Explorer your logged in credentials will have the ability to spread the virus to every system in the company…  Not a good thing!

 

That’s where the RunAs command (XP and Server 2003) came in handy over the years.  You could login as a non-privileged user but if you needed to do something which required Admin rights, you could hold down Shift and Right Click on the application in Windows Explorer and start the application using your Admin credentials.

 

With the release of Windows Vista and Server 2008, this all changed.  True, you could still use the RunAs.exe from the command line however, if you wanted to do it with Windows Explorer.  Fortunately Mark Russinovich has written a new tool called  which adds the RunAs feature to Windows Explorer.

 

Follow the below Step by Step to get it rolling on your box:

 

 

Add Run As Different User to Windows Explorer Context Menu for Vista and Server 2008

1) After you download ShellRunAs from here, copy it to your WindowsSystem32 folder,

 

2) Open a command line and Runshellrunas /reg

Add Run As Different User to Windows Explorer Context Menu for Vista and Server 2008 :: groovyPost.com

 

3) Click OK to confirm Install completed

Add Run As Different User to Windows Explorer Context Menu for Vista and Server 2008 :: groovyPost.com

 

To test, hold down SHIFT and Right-Click on an application.  You should now see the Run as different user in your context menu.

 

Before:

Add Run As Different User to Windows Explorer Context Menu for Vista and Server 2008 :: groovyPost.com

 

After:

Add Run As Different User to Windows Explorer Context Menu for Vista and Server 2008 :: groovyPost.com