Chamila's Blog

Keyboard shortcuts for Run Command

2011-10-08T09:40:00.000+08:00

This will helps you to do something faster than now.

Shortcut Keys	Command
%appdata%	Application Data Folder
%homedrive%	Home Directory Drive
%homepath%	Home Directory
%homeshare%	Shared Home Directory
%programfiles%	Open Program Files folder
%systemdrive%	Windows Root Drive
%temp%	Temporary Folder
%windir%	Windows Root Directory
ac3filter.cpl	Opens AC3 Filter (If Installed)
access.cpl	Accessibility Controls
access.cpl	Accessibility Controls
appwiz.cpl	Add/Remove Programs
calc	Calculator
certmgr.msc	Certificate Manager
charmap	Character Map
chkdsk	Check Disk Utility
ciadv.msc	Indexing Service
cleanmgr	Disk Cleanup Utility
cliconfg	SQL Client Configuration
clipbrd	Clipboard Viewer
cmd	Command Prompt
compmgmt.msc	Computer Management
controladmintools	Administrative Tools
controlcolor	Display Properties (w/Appearance Tab Preselected)
controldesktop	Display Properties
controlfolders	Folders Properties
controlfonts	Fonts
controlkeyboard	Keyboard Properties
controlmouse	Mouse Properties
controlnetconnections	Network Connections
controlpanel	Open Control Panel
controlprinters	Printers and Faxes
controlschedtasks	Scheduled Tasks
dcomcnfg	Component Services
ddeshare	DDE Shares
desk.cpl	Display Properties
devmgmt.msc	Device Manager
dfrg.msc	Disk Defragment
directx.cpl	Direct X Control Panel (If Installed)*
diskmgmt.msc	Disk Management
diskpart	Disk Partition Manager
drwtsn32	Dr. Watson System Troubleshooting
dxdiag	Direct X Troubleshooter
eudcedit	Private Character Editor
eventvwr.msc	Event Viewer
excel	Run Microsoft Excel (if installed)
findfast.cpl	Findfast
firefox	Run Firefox (if installed)
firewall.cpl	Windows Firewall
fonts	Fonts Folder
freecell	Free Cell
fsmgmt.msc	Shared Folders
fsquirt	Bluetooth Transfer Wizard
gpedit.msc	Group Policy Editor (XP Prof)
hdwwiz.cpl	Add Hardware Wizard
iexplore	Run Internet Explorer
iexpress	Iexpress Wizard
inetcpl.cpl	Internet Properties
intl.cpl	Regional Settings
ipconfig	IPConfiguration (DisplayConnectionConfiguration)
ipconfig/all	IP Configuration (Display Connection Configuration)
ipconfig/displaydns	IP Configuration (Display DNS Cache Contents)
ipconfig/flushdns	IP Configuration (Delete DNS Cache Contents)
ipconfig/registerdns	IP Configuration (Refreshes DHCP & Re-Registers DNS)
ipconfig/release	IP Configuration (Release All Connections)
ipconfig/renew	IP Configuration (Renew All Connections)
ipconfig/setclassid	IP Configuration (Modifies DHCP Class ID)
ipconfig/showclassid	IP Configuration (Display DHCP Class ID)
javaws	Java Control Panel (If Installed)
joy.cpl	Game Controllers
jpicpl32.cpl	Java Control Panel (If Installed)
logoff	Log Off Windows
lusrmgr.msc	Local Users and Groups
magnify	Windows Magnifier
main.cpl	Mouse Properties
mmsys.cpl	Sounds and Audio
msconfig	System Configuration Utility
mshearts	Hearts Card
mspaint	MS-Paint
mstsc	Remote Desktop
ncpa.cpl	Network Connections
netsetup.cpl	Network Setup Wizard
notepad	Notepad
ntmsmgr.msc	Removable Storage
ntmsoprq.msc	Removable Storage Operator Requests
nusrmgr.cpl	User Account Management
nvtuicpl.cpl	Nview Desktop Manager (If Installed)
odbccp32.cpl	ODBC Data Source Administrator
osk	On Screen Keyboard
outlook	Run Microsoft Outlook (if installed)
packager	Object Packager
password.cpl	Password Properties
perfmon	Performance Monitor
perfmon.msc	Performance Monitor
powercfg.cpl	Power Configuration
printers	Printers Folder
QuickTime.cpl	Quicktime (If Installed)
regedit	Registry Editor
regedit32	Registry Editor
rsop.msc	Resultant Set of Policy
secpol.msc	Local Security Settings
services.msc	Services
sfc	SystemFileCheckerUtility (ReturntoDefaultSetting)
sfc/cachesize=x	System File Checker Utility (Set Cache Size to size x)
sfc/purgecache	System File Checker Utility (Purge File Cache)
sfc/revert	System File Checker Utility (Return to Default Setting)
sfc/scanboot	System File Checker Utility (Scan On Every Boot)
sfc/scannow	System File Checker Utility (Scan Immediately)
sfc/scanonce	System File Checker Utility (Scan Once At Next Boot)
shutdown	Shutdown Windows
shutdown-r	Restart Windows
sigverif	File Signature Verification Tool
spider	Spider Solitare
sticpl.cpl	Scanners and Cameras
sysdm.cpl	System Properties
sysedit	System Configuration Editor
syskey	Windows System Security Tool
taskmgr	Task Manager
telephon.cpl	Phone and Modem Options
telnet	Telnet Client
timedate.cpl	Date and Time
tourstart	Windows XP Tour Wizard
utilman	Utility Manager
verifier	Driver Verifier Utility
winchat	Microsoft Chat
winmine	Minesweeper
winword	Run Microsoft Word (if installed)
wmimgmt.msc	Windows Management Infrastructure
wordpad	Run WordPad
write	WordPad
wscui.cpl	Security Center
wuaucpl.cpl	Automatic Updates
wupdmgr	Windows Update Launches

Exclusive access could not be obtained because the database is in use

2011-10-06T23:37:00.021+08:00

Well, after a few months of actually did some projects to complete at my deadline was successes, here I am back to blogging!

Actually This time i'm going to talk about the database restoring is not happening, it is because of the "database is in use".

Here's a common way of doing that:

1. Set the database in SINGLE_USER mode and forcibly terminate other connections:

USE [master]
ALTER DATABASE [DATABASE_NAME]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

The above command will set the database in SINGLE_USER MODE and additionally the ROLLBABK IMMEDIATE termination option will roll back all the incomplete transactions. It will also disconnect any other connections to the database.

*Note: After issuing the above command, you will only be able to use a single connection to the database. So, if you are already using a query window connected to the target database, either restore the database by using the RESTORE T-SQL command or close the query window and restore the target database by using the Restore Database Wizard from SQL Server Management Studio.

2. Restore the database.

3. Set the database back to MULTI_USER mode:

USE [master]
ALTER DATABASE [DATABASE_NAME]
SET MULTI_USER;

That's it! You have successfully restored the database!

And here's an alternative way (a little bit more complex):

1. If there are any SQL Server logins granted any access on the target database then disable them:

alter login [LOGIN_NAME] disable

*Note: Even though now you have disabled the login(s) there still might exist active connections to the database.

2. To find and terminate existing connections on the target database perform the following:

-- Query that returns all the SPIDs (process IDs)/sessions established to a given database:
SELECT spid,loginame,login_time,program_name
FROM [master]..sysprocesses
WHERE DBID=DB_ID('DATABASE_NAME')

By collecting the above SPIDs you get the sessions that must be forcibly terminated (be careful not to forcibly terminate your own session! :) By including the columns loginame, login_time and program_name in the above query, you are able to identify and exclude the spid that belongs to your session (that is, the DBA session).

You can terminate a session by executing the T-SQL Statement:

KILL @SPID

*Note 1: Replace @SPID with the appropriate SPID number.
*Note 2: You can even create a user-defined function undertaking this task.

3. Set the database in SINGLE_USER mode:

USE [master]
ALTER DATABASE [DATABASE_NAME]
SET SINGLE_USER;

*Note: After issuing the above command, you will only be able to use a single connection to the database. So, if you are already using a query window connected to the target database, either
restore the database by using the RESTORE T-SQL command or close the query window and restore the target database by using the Restore Database Wizard from SQL Server Management Studio.

4. Restore the database.

5. Set the database back to MULTI_USER mode:

USE [master]
ALTER DATABASE [DATABASE_NAME]
SET MULTI_USER;

Remarks and Considerations
------------------------------
In the case of a RESTORE operation I would personally prefer the first method as it is simpler. With a single T-SQL Statement you set the database in SINGLE_USER MODE and also terminate all the active connections immediately and roll back all the incomplete transactions.

The second method is more preferable in cases where more "elegant" session control is required. This method allows the DBA to terminate sessions one-by-one explicitly instead of the first method which massively terminates all connections.

Choosing one of the two ways I guess that relies to the urgency of the RESTORE operation, the judgment of the DBA and also any Business Policies that might stand for such cases.

Because both the abovementioned methodologies have to do with forcibly terminating connections to a database in SQL Server, you must be extremely careful when using them as you might accidentally cause severe data loss when applying them inappropriately and without the necessary authorization from the Mansgement.

Source: http://aartemiou.blogspot.com/2009/03/exclusive-access-could-not-be-obtained.html

How to transfer blogspot blog to another account

2011-05-27T18:08:00.001+08:00

Very Useful One.I Copied information from http://www.bloggertricks.com/2008/02/how-to-transfer-bloggerblogspot-blog.html.

1.First Sign into your blogger dashboard. Click on the settings link next to your blog name.[see the below screenshot]

2.Now,click on the Permissions

3.Before transfering your blog ie. before making someone admin,you need to first invite him and make him as author.Click on the 'ADD AUTHORS' button to add.

4.Enter the person's email id and click on the INVITE button.

5.After inviting him,blogger will send an email to that person asking him to visit a link and confirm that he is willing to contribute to your blog.

6.Once the invitee confirmed,go to the permissions page once again.Now,you will see an option to grant admin privileges to your partner.Click on the 'grant admin privileges' link and confirm.

7.Now,your blog has two admins.You will see the admin 'remove' link next to the author's name.Remove your's as admin(and also as author).Now your blog will be transfered from your account to your partner's.

That's it! Now,you easily transfered your blog from one account to another account.

Deadlock in SQL Server

2011-05-26T17:06:00.014+08:00

Deadlocks can be a pain to debug since they're so rare and unpredictable. The problem lies in repeating them in your dev environment. That's why it's crucial to have as much information about them from the production environment as possible.

Deadlocks occur when two (or more) processes are holding locks on resources and are waiting for locks on resources in such a way that they will never resolve.

Here I'm discussing a one of the way to monitor the Deadlocks.

How to Trace Deadlocks?
Get Info By ID

DBCC INPUTBUFFER(55)

Deadlocks can be traced by turning on two specific flags:

dbcc traceon (1204, 3605, -1)

dbcc tracestatus(-1)

Deadlocks trace output can be examined in SQL Server log.

How to Avoid Deadlocks?

Here are some tips on how to avoid deadlocking on your SQL Server:

Ensure the database design is properly normalized.

Have the application access server objects in the same order each time.

During transactions, don’t allow any user input. Collect it before the transaction begins.

Avoid cursors.

Keep transactions as short as possible. One way to help accomplish this is to reduce the number of round trips between your application and SQL Server by using stored procedures or keeping transactions with a single batch. Another way of reducing the time a transaction takes to complete is to make sure you are not performing the same reads over and over again. If your application does need to read the same data more than once, cache it by storing it in a variable or an array, and then re-reading it from there, not from SQL Server.

Reduce lock time. Try to develop your application so that it grabs locks at the latest possible time, and then releases them at the very earliest time.

If appropriate, reduce lock escalation by using the ROWLOCK or PAGLOCK.

Consider using the NOLOCK hint to prevent locking if the data being locked is not modified often.

If appropriate, use as low of an isolation level as possible for the user connection running the transaction.

Consider using bound connections.

Concatenation in SELECT and SPLIT functions with Transact SQL

2011-05-05T16:56:00.012+08:00

Scalar UDF with variable concatenation in SELECT

CREATE FUNCTION dbo.udf_select_concat ( @c INT )
    RETURNS VARCHAR(MAX) AS BEGIN
    DECLARE @p VARCHAR(MAX) ;
           SET @p = '' ;
        SELECT @p = @p + ProductName + ','
          FROM Products
         WHERE CategoryId = @c ;
    RETURN @p
    END

And, as for its usage:

    SELECT CategoryId, dbo.udf_select_concat( CategoryId )
      FROM Products
     GROUP BY CategoryId ;

SPLIT Function

CREATE FUNCTION [dbo].[Split]
(
@RowData NVARCHAR(MAX),
@Delimeter NVARCHAR(MAX)
)
RETURNS @RtnValue TABLE
(
ID INT IDENTITY(1,1),
Data NVARCHAR(MAX)
)
AS
BEGIN
DECLARE @Iterator INT
SET @Iterator = 1
DECLARE @FoundIndex INT
SET @FoundIndex = CHARINDEX(@Delimeter,@RowData)
WHILE (@FoundIndex>0)
BEGIN
INSERT INTO @RtnValue (data)
SELECT
Data = LTRIM(RTRIM(SUBSTRING(@RowData, 1, @FoundIndex - 1)))
SET @RowData = SUBSTRING(@RowData,
@FoundIndex + DATALENGTH(@Delimeter) / 2,
LEN(@RowData))
SET @Iterator = @Iterator + 1
SET @FoundIndex = CHARINDEX(@Delimeter, @RowData)
END

INSERT INTO @RtnValue (Data)
SELECT Data = LTRIM(RTRIM(@RowData))
RETURN
END

GO

Sources : http://balavardhanreddy.over-blog.com/15-categorie-10814096.html
http://www.projectdmx.com/tsql/rowconcatenate.aspx

Can not put more than one ModalPopup control in one page?

2011-05-05T16:36:00.003+08:00

To Show one popup Panel from multiple controls, use one ModalPopupExtender bound to an invisible 'dummy' control, then call ModalPopupExtender.Show() from the OnClick Event of each control you wish to show the popup.

This example is most related with control are added inside of the grid view and also add checkboxlist control inside of the ModelPopup.

CSS
.modalBackground {
FILTER: alpha(opacity=70); BACKGROUND-COLOR: #fff; opacity: 0.7px
}
.modalPopup {
BORDER-BOTTOM: #ccc 3px solid; BORDER-LEFT: #ccc 3px solid; PADDING-BOTTOM: 5px; BACKGROUND-COLOR: #fff; PADDING-LEFT: 5px; PADDING-RIGHT: 5px; BORDER-TOP: #ccc 3px solid; BORDER-RIGHT: #ccc 3px solid; PADDING-TOP: 5px;
}

ASPX
<asp:Button ID="btnFade" runat="server" Text="" visible="true" Width="0"/>
<asp:ModalPopupExtender
BackgroundCssClass="modalBackground"
DropShadow="true"
CancelControlID="btnCancel"
runat="server"
PopupControlID="pnlModelPopup"
id="ModalPopupExtender1"
TargetControlID="btnFade">
</asp:ModalPopupExtender>
<asp:Panel ID="pnlModelPopup" runat="server" CssClass="modalPopup" style="display:none;">
<table >
<tr>
<td>Add / Modify Competencies<br /><br /> </td>
</tr>
<tr>
<td>
<div style="height:200px; border-style:solid; border-width:thin; overflow: auto; width:100%;" runat="server">
<asp:CheckBoxList ID="chklstCompetencies" runat="server" RepeatColumns="0" >
</asp:CheckBoxList>
</div>
</td>
</tr>
<tr>
<td>
<asp:Button ID="btnSave" runat="server" Text="Save" />
<asp:Button ID="btnCancel" runat="server" Text="Cancel" />
</td>
</tr>
</table>

</asp:Panel>

In Codebehind any event if you want to fire for this ModelPopup then use this.
' show the modal popup
popupLink_ModalPopupExtender.Show()

If you need to use Save button with some process in Code behind following property need to be deleted from the asp:ModalPopupExtender
OkControlID="btnOk"

How to Restore SQL Server 2008 to SQL Server 2005

2011-04-26T18:15:00.001+08:00

This is the only way I found we can downgrade database versions.

Creating Scripts to Move SQL Server 2008 Database to SQL Server 2005
These steps show you how to generate the necessary scripts.

Use the scripting wizard in SQL Server 2008 to script data as well as schemas into SQL Server 2005 compatibility mode.
Run "Generate SQL Server Scripts" wizard in SQL Server Management Studio (once Object Explorer is connected to the appropriate instance) by right clicking on database and selecting "Tasks –> Generate Scripts."
Click "Script all objects in selected database" & then click "Next."
Change script options: Specifically, set "Script for Server Version" to "SQL Server 2005" and set "Script Data" to "True". (SQL Server 2000 is also supported.) If you are putting the database on a new instance for the first time, make sure the "Script Database Create" option is set to "True." Click "Next" when you are happy with options.
Finish the wizard.

After creating the file with these changes, you can run the script in SQL Server 2005 Management Studio to recreate the database in your development environment. You can now test data against SQL Server 2008 and SQL Server 2005.

Sources :

Sys.WebForms.PageRequestManagerParserErrorException error - ASP.NET Ajax 1.0

2011-04-26T17:54:00.008+08:00

Error Message :
Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled.
Details: Error parsing near '
<!DOCTYPE html PUB'.

Have you ever got these kind of error when you are doing an Async postback using AJAX.NET .Actually If you’ve seen this error, you’ve probably already spent some time to resolve it. Anyway The solution mentioned below is worked for me.

1) Make sure this in is your web.config
   <httpModules>
   <add name=”ScriptModule” type=”System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35?/>
   </httpModules>

2) Add this to the to the Page declaration if you’re experiencing some page refresh bugs
   enableEventValidation=”false”

Source : http://weblogs.asp.net/albertpascual/archive/2008/04/22/how-to-fix-sys-webforms-pagerequestmanagerparsererrorexception-in-ajax-1-0.aspx

If you’ve found alternatives to this problem or our suggested solution isn’t working for you, please feel free to comment below.

It’s a Matter of Time and Heart Sinhala & Tamil Aluth Avurudu

2011-04-14T12:24:00.000+08:00

Aluth Avurudu is perhaps one of the most important days of the year in Sri Lanka, when people all over the country and small communities all across the globe celebrate Sinhala & Tamil New Year. Festivities take place in every small village of the country.

In the fullness of the bak maha, (the month of April, the month of abundance and prosperity), the Prince of Peace Indradeva ( sun god) comes to earth bringing peace and happiness to mankind. Nature responds with abundance – flowers on every bush and vine, trees laden with ripening fruit. Plentiful harvest is the reward of hard work for the human kind. It is no wonder that it is a time of celebration.

This is also the time when the sun moves from the Meena Rashiya (House of Pisces) to the Mesha Rashiya (House of Aries) in the celestial sphere. Time, interpreted according to astrological charts pertaining to and guiding the destiny of the country, plays an important role. It is the time when Sri Lankans begin celebrating Aluth Avurudu (in Sinhala) and Puththandu ( in Tamil). It is a time to honour the common destiny of the diverse people that call Sri Lanka home.

The ending of the old year, and the beginning of the new year, occur several hours apart from one another. This period is referred to as the nona gathe (neutral period). During this time people are encouraged to refrain from material pursuits, and engage solely in religious activities and traditional games.

The emphasis on time using the astrological charts is an interesting phenomenon. There is a proper time for everything- to stop work, to start work, to cook food and to eat food, to bathe, to wash hair and to oil it, to visit family and friends and to play. Interestingly they are the routine, mundane tasks of everyday life. Delving deeper beyond the superficiality of observing merely another tradition, the emphasis on time is an indicator of the importance placed on punctuality. Embedding it in astrology elevates time to the realms of divinity.

The new year is incomplete without the anointing of head with oil- hisa thel gema. Nanu (medicated shampoo) and oil are important ingredients according to Ayurveda, the ancient medical practices, of promoting health.

It is clear that customs and rituals associated with the new year are those that promote, health, harmony and well-being. Goodwill, promoted through community activities of sports, religious activities and family time around rituals and customs, is the antidote for stress. Family as the foundation of community is subtly emphasized in the leadership roles played by the mother and the father and the respect given to the elders and affection shown to the children in the activities.

In the community the mutual exchanging of traditional food of kevum , kiribath and plantains is an opportunity to share good will and commit to harmonious living. Petty rivalries are forgiven and forgotten in the spirit of aluth avurudu.

The value of paying respect to elders is found underlying all aspects of New Year celebrations. The link between generations are strengthened by ganu denuexchanging of bulath (betal leaf), money and other gifts. Aluth Avurudu indeed is not mere ritual. It is an enactment of meaningful living.

උදාවූ අලුත් අවුරුද්ද සාමය,සතුට පිරි සුභ අලුත් අවුරුද්දක් වේවා!...

Source : http://www.pdf4me.net/pdf-data/sinhala--stories.php

'Sys' is undefined - ASP.NET AJAX

2011-04-06T17:33:00.000+08:00

When I was using ASP.NET 2.0 along with Ajax Extensions 1.0. I received this error ‘Sys’ is undefined error message every time I used an Ajax control.

Wondering why, I search in internet and hope that I will find one of the solution. After several trial and error finally I can find the solution and it work just fine for me.

Why this error?
This error occurs specifically when you try upgrading your existing ASP.NET 2.0 Applications to AJAX by using the ASP.NET AJAX controls like UpdatePanel, etc., The common cause for this error is that you havent updated the Web.Config file of the application to enable the runtime understand ASP.NET AJAX. Let me explain a little more.

When you install ASP.NET AJAX your Visual Studio 2005 gets the toolbox updated with ASP.NET AJAX Server side controls like ScriptManager, ScriptManagerProxy, UpdatePanel, UpdateProgress etc., You already have your existing ASP.NET 2.0 application pages and you can add ScriptManager, UpdatePanel and other controls from Toolbox to your pages. When you run the page, you would get 'Sys' is undefined javascript error. The reason being that, your web.config of the existing ASP.NET 2.0 application misses certain settings that require to be added to make it understand the ASP.NET AJAX Server side controls like UpdatePanel, UpdateProgress etc.,

How to Solve the error ?

To solve the error we need to modify web.config file.

<httpHandlers>
<remove verb="*" path="*.asmx"/>
<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
</httpHandlers>

What is Cloud Computing ?

2011-03-31T16:53:00.005+08:00

Cloud computing is a general term for anything that involves delivering hosted services over the Internet. These services are broadly divided into three categories: Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS) and Software-as-a-Service (SaaS). The name cloud computing was inspired by the cloud symbol that's often used to represent the Internet in flowcharts and diagrams.

So what’s a definition for real people?
Cloud Computing = Web Applications

That’s all there is to it. If you’re using a web or internet-based application from a major provider like Google or Microsoft, you’re using cloud computing. Congrats!

Every web application that you’ve ever used, like Gmail, Google Calendar, Hotmail, SalesForce, Dropbox, and Google Docs, are based on “cloud computing”, because when you connect to one of these services, you’re really connecting to a massive pool of servers somewhere out there on the internet. The client doesn’t need to be a web browser, but that’s the direction everything is heading.

Types of Cloud Services

Advantages of the Cloud Computing

Reduced CostCloud technology is paid incrementally, saving organizations money.
Increased StorageOrganizations can store more data than on private computer systems.
Highly Automated
No longer do IT personnel need to worry about keeping software up to date.
FlexibilityCloud computing offers much more flexibility than past computing methods.
More Mobility
Employees can access information wherever they are, rather than having to remain at their desks.
Allows IT to Shift Focus
No longer having to worry about constant server updates and other computing issues, government organizations will be free to concentrate on innovation.

Web Applications are the future. Cloud Computing is a stupid buzzword. Discuss.

You can download most valuable information from following link.
http://www.microsoft.com/asia/cloud/singapore.aspx#downloads

A Software Engineer’s Feelings…..Touching...

2011-03-20T11:10:00.026+08:00

Software engineer deals with computer applications and manages software development projects. Companies from all sectors of the economy are looking for software engineers and programmers. The software engineering is one of the best jobs in this modern age with a lot of knowledge containing in it and a good earning, too. But what is his Actual Life???

Here it is one of the good article I found from some one's blog(source is below) about the feelings of the Software Engineer.Read this story and just see how touchy it is !!!!!!!!!!!!

It was raining heavily outside. Dark clouds gathered in the sky and nature was in its ominous best. I took a break from my work and went to the pantry to grab a cup of coffee. I had a sip and went near the window to see the rain pouring down heavily outside the glass structure. I was inside our huge office building, unruffled by even the fierceness of the nature.

Through the heavy transparent glass, I could see a small girl trying to hold on to her umbrella which the wind was snatching away from her. I felt sorry for the girl, and was happy that I was not in a similar pathetic situation. Yes. I take pride for the fact that I am a software engineer.

I have everything which a common man would envy; money, status, respect, you name it I have it. I always wanted to be software professional and here I am, working for one of the best firms in the world. But then, am I really happy? Now, I could see an imprint of my palm on the other glass window, through which I reminisced my past, basked in the warmth of the sun shine.

My childhood was so much of fun. I vividly remember those rainy days, when I hugged my mother tightly during sleeping listening to all the stories told by her. Now, I have a big house here, but then it is just a house, not a home. My parents are pretty far away from me now. I have a cell phone to talk to them everyday, but then I really miss those dinners which I had with my family everyday. I could easily afford to taste all the different cuisines these days, but the best of food there, lack the love and affection which is present in the food prepared by my mother.

I threw a lavish party for my colleagues for my birthday, but then they would never replace the birthdays when my friends secretly brought a cake and at the end, half of the cake would have ended up on my face. The couple of hundred bucks that u save for a long period just to give a treat to your friends in the road side chat shop can never give the pleasure even after spending a few thousand bucks these days.

The scene of me crying and refusing to have dinner on the day when I fought with my best friend came to my mind. Today, she has gone far away from me, taking away my love and with it my life, but I am sitting and coding here with a false smile on my face. Everyday I meet new people, but then I long ceased to make a new friend.

It’s true that I have a lot of things now. I have a nice bed, but no time to sleep. Lots of money, but no friends to spend it with. The latest designer clothes, but a worn out body . Awards for technical excellence, but no reward for the crave for peaceful ambience. A confident demeanor, but a reluctant and apathetic mind. Full of rain, but no sunshine even in the farthest distance.

Now, I could see the small girl on the road enjoying in the rain with her umbrella firmly in her grip. She might not have all the comforts which I have, but then she has the innocence and fun which I lost a long time back.

I have decided to come out of this false fantasy, even if it is at the expense of losing the tap of the software engineer. I am going to again enjoy my life. I am going to go out in the rain and play with the small kid now. I removed my tie, and went near my computer to shut it down. Just then, I saw a new mail alert in my mail box. I slowly opened outlook and I found a message from my manager with an attachment saying that there was a critical defect in the code and I have to fix it soon. I convinced myself that I am not going to get bogged down again by these pressures and stick to my decision. I ignored the mail and went to the rest room. After a couple of minutes, the software engineer in me came out, his shirt tucked in with the perfect tie knot, sat before the computer, and started typing,

Hi XYZ,

I am looking into the defect and will send the patch files before EOD.

Source From : http://www.raasukutty.com/blog/musings/a-software-engineers-feelings.html/comment-page-1#comment-1367

User Define Functions In Java Script

2011-03-18T22:48:00.000+08:00

Here are some functions which are very important in developments.

To Trim the String type text

function Trim(str) {

return str.replace(/^[\s]+/, '').replace(/[\s]+$/, '').replace(/[\s]{2,}/, ' ');

}

function trim(argvalue) {
var tmpstr = ltrim(argvalue);

return rtrim(tmpstr);

}

Check the Text field no of characters

function NoOfCharacters(ctrl) {

return ctrl.value.length;

}

To Get the Part of a String

Function Substring(str,startValue,endValue) {

return ctrl.substring(startValue,endValue);

}

Eg:

Substring('ABCDE',0,1)

'A'

To Split a Text

function Splitting(str,SplitBy) {

var arrSplit =str.split(SplitBy);

var intCount = 0;

var strRetVal = '';

while (intCount < arrSplit.length) {

strRetVal += arrSplit[intCount] + ' - ' + '';

intCount += 1;

}

return strRetVal ;

}

Eg:

Splitting('ABC\nDEFG','\n')

'ABC-DEFG'

function customSplit(strvalue, separator, arrayName) {
var n = 0;

if (separator.length != 0) {
    while (strvalue.indexOf(separator) != -1) {
      eval("arr"+n+" = strvalue.substring(0, strvalue.indexOf(separator));");
      strvalue = strvalue.substring(strvalue.indexOf(separator)+separator.length,
          strvalue.length+1);
      n++;
    }
    eval("arr" + n + " = strvalue;");
    arraySize = n+1;
}
else {
    for (var x = 0; x < strvalue.length; x++) {
      eval("arr"+n+" = \"" + strvalue.substring(x, x+1) + "\";");
      n++;
    }
    arraySize = n;
}

eval(arrayName + " = new makeArray(arraySize);");

for (var i = 0; i < arraySize; i++)
eval(arrayName + "[" + i + "] = arr" + i + ";");

return arraySize;
}

Eg:

var strvalue = "abc##123##zzz##$$$";
var returnArraySize = customSplit(strvalue, "##", "NewArray");
The above will create the following:
NewArray[0] has value "abc"
NewArray[1] has value "123"
NewArray[2] has value "zzz"
NewArray[3] has value "$$$"
returnArraySize has value "4"

Replace Text

function ReplaceString(str,oldValue,newValue)

{

Return str.replace(oldValue,newValue);

}

Eg:

ReplaceString('Hello World','World','!')

Hello !

Sort Method

//Sort alphabetically and ascending:

var myarray=["Bob", "Bully", "Amy"]

myarray.sort() //Array now becomes ["Amy", "Bob", "Bully"]

//Sort alphabetically and descending:

var myarray=["Bob", "Bully", "Amy"]

myarray.sort()

myarray.reverse() //Array now becomes ["Bully", "Bob", "Amy"]

Custom Sort Method

function customSort(a,b) {

    return( a.toString().length - b.toString().length );

}

var arlene = new Array("orange","apple","strawberry","banana");

alert( arlene.sort(customSort).toString() );

Add Space

function addSpace(argvalue, numlength) {

if (! numlength > 0)
numlength = 10;

if (argvalue.length < numlength) {
for(var i = argvalue.length; i < numlength; i++)
argvalue = " " + argvalue;
}

return argvalue;

}

Eg:

addSpace("123.45", 10);

" 123.45"

Highlighted the text in selected textBox

function ShowSelection(textComponent) {

var selectedText;

// IE version

if (document.selection != undefined) {

textComponent.focus();

var sel = document.selection.createRange();

selectedText = sel.text;

}

// Mozilla version

else if (textComponent.selectionStart != undefined) {

var startPos = textComponent.selectionStart;

var endPos = textComponent.selectionEnd;

selectedText = textComponent.value.substring(startPos, endPos)

}

return selectedText;

}

Disable the Key Press event in a text box

function DisableKeyPressEvent(e) {

var unicode = e.charCode ? e.charCode : e.keyCode

if (unicode!=0) //if not a number

{

return false //disable key press

}

Select the Item from ComboBox

function SelectComboItem(combo,value)

{

if(value!=null)

{

for (var i=0 ; i <= combo.length; i++)

{

combo.selectedIndex= i;

if (combo[combo.selectedIndex].value==value)

{

combo.selectedIndex= i;

return true;

}

else

{

combo.selectedIndex= 0;

}

else

{

combo.selectedIndex= 0;

}

Set Current Date

function setDate()

{

var currentTime = new Date();

var month = currentTime.getMonth() + 1;

var day = currentTime.getDate();

var year = currentTime.getFullYear();

var dateLast=day+'/'+month+'/'+year;

document.getElementById("txtDate").value=dateLast;

return true;

}

Reference : http://www.tneoh.zoneit.com/javascript/js_func.html

Best Practices for Speeding Up Your Web Site

2011-03-12T20:57:00.009+08:00

Why We Need To Think About This ?

Actually most of the developers just like me always thinking how much effort we can put to develop to access web pages as much as fast and also how to do this.According to this I found one of the good article and like to shared with u all.Alright here are some number of best practices for making web pages fast. The list includes 35 best practices.

For Detail Info Follow this : http://developer.yahoo.com/performance/rules.html

Minimize HTTP Requests
Use a Content Delivery Network
Add an Expires or a Cache-Control Header
Gzip Components
Put Stylesheets at the Top
Put Scripts at the Bottom
Avoid CSS Expressions
Make JavaScript and CSS External
Reduce DNS Lookups
Minify JavaScript and CSS
Avoid Redirects
Remove Duplicate Scripts
Configure ETags
Make Ajax Cacheable
Flush the Buffer Early
Use GET for AJAX Requests
Post-load Components
Preload Components
Reduce the Number of DOM Elements
Split Components Across Domains
Minimize the Number of iframes
No 404s
Reduce Cookie Size
Use Cookie-free Domains for Components
Minimize DOM Access
Develop Smart Event Handlers
Choose over @import
Avoid Filters
Optimize Images
Optimize CSS Sprites
Don't Scale Images in HTML
Make favicon.ico Small and Cacheable
Keep Components under 25K
Pack Components into a Multipart Document
Avoid Empty Image src

More info : http://developer.yahoo.com/performance/rules.html

Funny things :

How to get count with some filtering condition in select command using groups as well

2011-03-12T15:33:00.000+08:00

count(case when IsNull(G.EmpCode,'X')='X' then null else 1 end) as Fullfilled
count(case when A.Selected = 'Y' then 1 else null end) as NoOfGaps

Eg:

SELECT A.EmpCode
,F.EMPLOYEENAME as EmployeeName
,E.DESCSHORT
,count(case when IsNull(G.EmpCode,'X')='X' then null else 1 end) as Fullfilled
,count(case when IsNull(G.EmpCode,'X')='X' then 1 else null end) as NotFullfilled
,count(case when A.Selected = 'Y' then 1 else null end) as NoOfGaps
,sum(case when A.Status = 'T' then G.TrainingHrs else 0 end) as NoOfHrs
,sum(case when A.Status = 'T' then G.TrainingFees else 0 end) as Costs
,count(case when A.Status = 'A' then 1 else null end) as Attending
from tb_Employee as A
left outer join HR_Competency D on A.CompetencyGroup = D.CompetencyGroup and A.Competency = D.Competency and D.CompanyCode = A.CompanyCode
left outer join HR_EmployeeMaster F on A.CompanyCode = F.CompanyCode and A.EmpCode = F.EmpCode
left outer join HR01_CODEREF E on F.JobGrade = E.Code and E.CodeType = 'JOB' and E.CompanyCode = A.CompanyCode
left outer join TR_EmployeeTraining G on A.CompanyCode = G.CompanyCode and A.EmpCode = G.EmpCode and A.TrainingYear = G.TrainingYear
and A.CompetencyGroup = G.CompetencyGroup and A.Competency = G.Competency and G.Status not in ('S', 'P', 'R', 'C', 'W','Z')

where A.CompanyCode = 'LSH' and rtrim(A.TrainingYear) = year(getdate())
and A.EmpCode IN (SELECT X.EMPCODE FROM HR_EMPLOYEEMASTER X, HR_PAYROLL Y WHERE X.COMPANYCODE = 'LSH'
AND X.COMPANYCODE = Y.COMPANYCODE AND X.EMPCODE = Y.EMPCODE AND Y.CPFSTATUS <> '4' AND X.EMPCODE='IQ001' )
group by A.CompanyCode,A.EmpCode,F.EMPLOYEENAME,E.DESCSHORT

Java Script Validations

2011-03-11T00:00:00.000+08:00

Check the Text field Value is Empty or not

function IsValueEmpty(ctrl) {

if (ctrl.value== '') {

alert("This field cannot be empty!");

return false;

}

Check the selected index of the dropdown

function IsValueEmpty(ctrl) {

if (ctrl.selectedIndex == 0) {

alert("Please select the one of the Item from the dropdown!");

return false;

}

Check the selected value of the checkbox

function Ischecked(ctrl) {

if (ctrl.checked == false) {

alert("Please checked the value of the checkbox !");

return false;

}

Email Check

function echeck(str) {

var at="@"

var dot="."

var lat=str.indexOf(at)

var lstr=str.length

var ldot = str.indexOf(dot)

if (str != '') {

if (str.indexOf(at) == -1) {

alert("Invalid E-mail ID")

return false

}

if (str.indexOf(at) == -1 || str.indexOf(at) == 0 || str.indexOf(at) == lstr) {

alert("Invalid E-mail ID")

return false

}

if (str.indexOf(dot) == -1 || str.indexOf(dot) == 0 || str.indexOf(dot) == lstr) {

alert("Invalid E-mail ID")

return false

}

if (str.indexOf(at, (lat + 1)) != -1) {

alert("Invalid E-mail ID")

return false

}

if (str.substring(lat - 1, lat) == dot || str.substring(lat + 1, lat + 2) == dot) {

alert("Invalid E-mail ID")

return false

}

if (str.indexOf(dot, (lat + 2)) == -1) {

alert("Invalid E-mail ID")

return false

}

if (str.indexOf(" ") != -1) {

alert("Invalid E-mail ID")

return false

}

return true

}

function isEmail(argvalue) {

if (argvalue.indexOf(" ") != -1)
    return false;
else if (argvalue.indexOf("@") == -1)
    return false;
else if (argvalue.indexOf("@") == 0)
    return false;
else if (argvalue.indexOf("@") == (argvalue.length-1))
    return false;

// arrayString = argvalue.split("@"); (works only in netscape3 and above.)
var retSize = customSplit(argvalue, "@", "arrayString");

if (arrayString[1].indexOf(".") == -1)
    return false;
else if (arrayString[1].indexOf(".") == 0)
    return false;
else if (arrayString[1].charAt(arrayString[1].length-1) == ".") {
    return false;
}

return true;

}

Num Check Function

function NumbersOnlyWithEnter(e) {

var unicode = e.charCode ? e.charCode : e.keyCode

if (unicode < 48 || unicode > 57) //if not a number

{

if (unicode != 13) {

return false //disable key press

}

function numCheck(argvalue) {

if (argvalue.length == 0)
return false;

for (var n = 0; n < argvalue.length; n++)
if (argvalue.substring(n, n+1) < "0" || argvalue.substring(n, n+1) > "9")
return false;

return true;

}

Eg:

The followings will return "true".
numCheck("1234")
numCheck("0123")

The followings will return "false".
numCheck("abcd")
numCheck("a123")
numCheck("123a")
numCheck("12.3")

Check the URL format is Correct or Not

function isURL(argvalue) {

if (argvalue.indexOf(" ") != -1)
    return false;
else if (argvalue.indexOf("http://") == -1)
    return false;
else if (argvalue == "http://")
    return false;
else if (argvalue.indexOf("http://") > 0)
    return false;

argvalue = argvalue.substring(7, argvalue.length);
if (argvalue.indexOf(".") == -1)
    return false;
else if (argvalue.indexOf(".") == 0)
    return false;
else if (argvalue.charAt(argvalue.length - 1) == ".")
    return false;

if (argvalue.indexOf("/") != -1) {
    argvalue = argvalue.substring(0, argvalue.indexOf("/"));
    if (argvalue.charAt(argvalue.length - 1) == ".")
      return false;
}

if (argvalue.indexOf(":") != -1) {
    if (argvalue.indexOf(":") == (argvalue.length - 1))
      return false;
    else if (argvalue.charAt(argvalue.indexOf(":") + 1) == ".")
      return false;
    argvalue = argvalue.substring(0, argvalue.indexOf(":"));
    if (argvalue.charAt(argvalue.length - 1) == ".")
      return false;
}

return true;

}

DB Backup, Restore, Shrink

2011-03-06T17:58:00.000+08:00

Backup Database to Disk

USE TESTDB;

GO

BACKUP DATABASE TESTDB

TO DISK = 'D:\SQLServerBackups\TESTDB201101241156.Bak'

GO

Restore Database

----Make Database to single user Mode

ALTER DATABASE YourDB

SET SINGLE_USER WITH

ROLLBACK IMMEDIATE

----Restore Database

RESTORE DATABASE YourDB

FROM DISK = 'D:BackUpYourBaackUpFile.bak'

WITH MOVE 'YourMDFLogicalName' TO 'D:DataYourMDFFile.mdf',

MOVE 'YourLDFLogicalName' TO 'D:DataYourLDFFile.ldf'

/*If there is no error in statement before database will be in multiuser

mode.

If error occurs please execute following command it will convert

database in multi user.*/

ALTER DATABASE YourDB SET MULTI_USER

Shrinking a database and specifying a percentage of free space

DBCC SHRINKDATABASE (TESTDB, 10);

GO

Truncating a database

DBCC SHRINKDATABASE (TESTDB, TRUNCATEONLY);

How to Clear Recent Project list or File list from Visual Studio .Net Start Page

2011-03-03T10:16:00.001+08:00

Close Visual Studio (if its open)

    GOTO > Start > Run > RegEdit

    GOTO > HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\\ProjectMRUList
    remove unnecessary items from list.

    Similarly repeat the steps for FileMRuList
    GOTO > HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\\FileMRUList
    remove unnecessary items from list.

    To Clear the Find and Replace List
    GOTO > HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\\Find
    remove unnecessary items from list.

Another Simple way is,
    Create one Text file "Clear.txt" and add below contents in it

   Windows Registry Editor Version 5.00

   [-HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\ProjectMRUList]
   [HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\ProjectMRUList]

    Save and Close the file and rename is as "Clear.reg"; that is Registry file. Double Click to Run the file, this will clear the "Recent Project List" on your Visual Studio 2005 Startup Page. You can add entries for "Recent File List" and "Find and Replace List" in this same .reg file.

Source : http://dotnetslackers.com/Community/blogs/kaushalparik/archive/2008/06/17/clear-recent-project-list-or-file-list-from-visual-studio-net-start-page.aspx

Get all the object definitions: SPROC, TRIGGER, VIEW & FUNCTION

2011-03-01T00:36:00.002+08:00

SELECT SchemaName=schema_name(schema_id),

ObjectName=object_Name(m.object_ID),

ObjectDefinition=definition

FROM sys.SQL_Modules m

INNER JOIN sys.objects o

ON m.object_id=o.object_id

ORDER BY SchemaName, ObjectName

How to Change Schema for Tables, Views and Stored Procedures

2011-02-28T02:06:00.002+08:00

SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + o.Name

FROM sys.Objects o

INNER JOIN sys.Schemas s on o.schema_id = s.schema_id

WHERE s.Name = 'yourschema' And (o.Type = 'U' Or o.Type = 'P' Or o.Type = 'V')

How to Change DB Owner for Tables , Views and Stored Procedures

2011-02-28T02:04:00.000+08:00

declare @OldOwner varchar(100)

declare @NewOwner varchar(100)

set @OldOwner = 'ABC'

set @NewOwner = 'dbo'

--Tables--

select 'EXEC sp_changeobjectowner ''[' + table_schema + '].[' + table_name + ']'', ''' + @NewOwner + ''' '

from information_schema.TABLES

where Table_schema = @OldOwner

--Views--

select 'EXEC sp_changeobjectowner ''[' + table_schema + '].[' + table_name + ']'', ''' + @NewOwner + ''' '

from information_schema.VIEWS

where Table_schema = @OldOwner

--Stored Procedures--

select 'EXEC sp_changeobjectowner ''[' + @OldOwner + '].[' + obj.name + ']'', ''' + @NewOwner + ''' '

from Sys.objects obj

Inner join Sys.schemas sch ON obj.schema_id=sch.schema_id

where [type]='P' AND is_ms_shipped=0 AND sch.[name] = @OldOwner

2009-04-05T10:54:00.000+08:00