How to drop all procedures

USE databasename
GO

declare @procName sysname

declare someCursor cursor for
select name from sysobjects where type = 'P' and objectproperty(id, 'IsMSShipped') = 0

open someCursor
fetch next from someCursor into @procName
while @@FETCH_STATUS = 0
begin
exec('drop proc ' + @procName)
fetch next from someCursor into @procName
end

close someCursor
deallocate someCursor
go

Windows Azure basics and its uses

Introduction
Windows azure is cloud computing OS. It mainly contains three components namely windows azure, windows Fabric and Windows azure SQL. It can be compared with cloud computing provided by Amazon but there are some basic difference with Amazon cloud computing. Amazon has provided basic platform for cloud computing but Microsoft Azure has provided basic platform along with basic services so developer can focus only their task rather than peripheral areas.

Areas of windows azure are:
- Web roles, data storage, worker role
Window azure – compute and storage in the cloud
SQL Azure – relational database in the cloud
.Net Services – Web based services e.g. Connectivity and access control
http://azure.snagy.name/blog/?p=176
http://azure.snagy.name/blog/?p=26

Download SDK for visual studio
http://www.microsoft.com/windowsazure/getstarted/default.aspx

Get Free Test Windows Azure server
For one month without credit card information
http://www.windowsazurepass.com/?campid=9FE3DB53-E4F0-DF11-B2EA-001F29C6FB82
Free subscription up to June
http://www.microsoft.com/windowsazure/free-trial/

How to create self assigned certificate for Windows Azure portal
1. Load the IIS 7 management console. I’m assuming here you have IIS7 installed since its required for the Windows Azure SDK.
2. Click on your Server.
3. Double Click Server Certificates in the IIS Section in the main panel.
4. Click Create Self-Signed Certificate… in the Actions panel.
5. Give it a Friendly Name.
6. Close IIS Manager.
7. Open Certificate Manager (Start->Run->certmgr.msc)
8. Open Trusted Root Certification Authorities, then Certificates.
9. Look for your certificate (Tip: Look in the Friendly Name column).
10. Right Click your certificate, then choose All Tasks, then Export…
11. In the Wizard, choose No, do not export the private key, then choose the DER file format.
12. Give your cert a name. (remember to call it something.cer).
13. Navigate to the Windows Azure Portal – http://windows.azure.com
14. Click the Account Tab, then click Manage My API Certificates.
15. Browse to the certificate file you created earlier and upload it.
16. Done!
(Ref: http://www.davidaiken.com/2009/12/21/how-to-create-a-x509-certificate-for-the-windows-azure-management-api/ )

Windows migration wizard from SQL Server to SQL Azure
http://sqlazuremw.codeplex.com/releases/view/32334
(download and run its exe file)

Connect SQL Azure via SQL Server management studio
Use the same way as in SQL server
1. Server name: Azure server name
2. Username: SQL azure user name
3. Password: SQL azure password
4. Use TCP/IP protocol, and put specific database name extending option of login window

OPENXML() and Nodes()
SQL Azure does not support OPENXML() but we have better alternative of it. Nodes() is good alternative.
Example:
DECLARE @xml xml
SET @xml = N'

CustomerNo123
CustomerNo321
CustomerNo555


SELECT
doc.col.value('Key[1]', 'NVARCHAR(200)') ponumber,
doc.col.value('Val[1]', 'NVARCHAR(MAX)') podate
FROM @xml.nodes('Parameter/Collection/Row') doc(col)

jQuery examples

jQuery is a collection library having different functionality in Java Script. It can be used with any type of server side scripting language like PHP, ASP, JSP, Perl etc..

see examples where you can use jQuery

1. Menu bar using jQuery Online example and Code

2. Post data check and message
online example and
Code

3 Over all functionality of jQuery can be seen in this tutorial

LAMP --- Linux-Apache-Mysql-PHP(Perl/Python)

LAMP is an abbreviation of Linux, Apache, Mysql and PHP or Pern or Python. It a complete package for developing web application. Whole package is available in internet with free of cost. It is a open source software package.
where,
Linux- operating system highly secured operating system
MySQL- Database management system owned by oracle corporation
Apachee- HTTP web server
PHP - Hypertext pre-processor a server side scripting language.(available in object oriented form also)

For window plat form LAMP is called as WAMP where w for windows
You can download LAMP via this link
CLICK

And Link for downloading WAMP is
CLICK

DOM, Java Script, jQuery

Code written in HTML, DHTML and XML is changed in sequence of objects for interoperability and further processing propose this sequence object is called DOM(Document Object Model). HTML do not need the sequence of Objects but JavaScript needs sequence of objects to indentify each tag and data of html or xml or dhtml.

so java script can process html, xml, dhtml data in client side dynamically. Java script is a client side scripting language for DOM objects.


jQuery is a collection of java script library. It is developed on basis of Java script and It also used for representing DOM objects and other functioning like creating animation, handeling events and develop Ajax applications.

How to add new user in sql server management studio 2008

Hei guys,
I was also suffering from this problem and finally I got succeeded so i am sharing my experience here.

Steps:
(This is a experience of doing it in windows 7 but should work in xp, vista and 2000 as well)

1. Open SQL management studio and log in
first as windows authentication mode.
(choose proper server name in which you want to add user)
as shown in figure










2. Extend security folder content which is located in right side if window. Right click on login tab (as shown in figure) and add new user.

3. put login name, click radio button to SQL Authencation,
put password
uncheck enforce password policy and select database as master as shown in figure










4. click on user mapping tab and click on master database and make it owner of database as shown in figure.

















5. Now you completed the process click ok and restart computer then try to login with your new user account. For sure it will work.

If you have any problem please feel free to ask me :)

Thank you
mebalkrishna@gmail.com

Difference between Stack and Heap

Stack

It used by value type. It can store fixed amout of data and stored in RAM.

Stack is used by Int, Array, Enumerator, Struct. Memory management is automatically done by program so we dont need to create desctructor.

Heap

It is Used by reference type. It has unlimited size. Data whose size can not be determined before execution of program and need to allocate dynamically in run time are fall in this category. For example if we need to read data of file then it may have any size so this type of date are stored in heap. It is stored in secondary memory i.e. harddisk.

String, Classes use heap for storing data. Program doesnot about memory status of heap so programmar him/herself need to destruct it.