Look inside .NET DLL files with Reflector

 

 

Download Dot net Reflector here

 

http://www.red-gate.com/products/reflector/

 

ref site = http://blogs.techrepublic.com.com/programming-and-development/?p=625

 

What is Virtual Memory?

 

What is Virtual Memory?

Virtual memory is simulated RAM. When you have used up all your RAM, your computer will shift data to an empty space on the hard drive. The computer swaps data to the hard disk and back to your RAM as needed. When you increase your virtual memory you are increasing the empty space that is reserved for your RAM overflow.

Also having enough available space is absolutely necessary for your virtual memory and RAM to function properly. You can increase Virtual Memory performance automatically by freeing up resources in your registry. You may want to use a Registry Cleaner. Click Here to learn more!

How to increase Virtual Memory?

In Windows XP

1.Click Start, and then click Control Panel.
2.Click Performance and Maintenance, and then click System.
3.On the Advanced tab, under Performance, click Settings.
4.On the Advanced tab, under Virtual memory, click Change.
5.Under Drive [Volume Label], click the drive that contains the paging file that you want to change.
6.Under Paging file size for selected drive, click to Custom size check box. You can enter the amount of memory you would like to reserve for Virtual memory by entering the initial and maximum size.
7.Click Set
When you are prompted to restart the computer, click Yes.
Special Note: You should choose the same amount for the initial size and maximum size. This will Stop your CPU from constantly changing the paging file.

HOT TIP: To stop your CPU from constantly changing the paging file, set the initial and maximum size to the same value. For example, 500 and 500. The value should be at least 1.5 times more than your physical RAM. If your computer has 512MB of RAM increase the virtual memory paging file to 1.5*512= 768

In Vista

1. Click Start button Picture of the Start button
2. Click Control Panel
3. Choose System and Maintenance and then click System.
4. In the left pane, click Advanced system settings.
5.On the Advanced tab, under Performance, click Settings.
6. Click the Advanced tab, and then, under Virtual memory, choose Change.
7. Click Custom to change the Initial size (MB) and Maximum size. See the hot tip above.

 

Sql Commands [usefull For Injection]

 

ABORT                                      -- abort the current transaction
ALTER DATABASE                      -- change a database
ALTER GROUP                          -- add users to a group or remove users from a group
ALTER TABLE                            -- change the definition of a table
ALTER TRIGGER                        -- change the definition of a trigger
ALTER USER                             -- change a database user account
ANALYZE                                  -- collect statistics about a database
BEGIN                                      -- start a transaction block
CHECKPOINT                             -- force a transaction log checkpoint
CLOSE                                      -- close a cursor
CLUSTER                                  -- cluster a table according to an index
COMMENT                                 -- define or change the comment of an object
COMMIT                                    -- commit the current transaction
COPY                                        -- copy data between files and tables
CREATE AGGREGATE                 -- define a new aggregate function
CREATE CAST                            -- define a user-defined cast
CREATE CONSTRAINT TRIGGER -- define a new constraint trigger
CREATE CONVERSION               -- define a user-defined conversion
CREATE DATABASE                   -- create a new database
CREATE DOMAIN                       -- define a new domain
CREATE FUNCTION                    -- define a new function
CREATE GROUP                         -- define a new user group
CREATE INDEX                          -- define a new index
CREATE LANGUAGE                   -- define a new procedural language

 

CREATE OPERATOR                   -- define a new operator
CREATE OPERATOR CLASS         -- define a new operator class for indexes
CREATE RULE                           -- define a new rewrite rule
CREATE SCHEMA                       -- define a new schema
CREATE SEQUENCE                   -- define a new sequence generator
CREATE TABLE                          -- define a new table
CREATE TABLE AS                     -- create a new table from the results of a query
CREATE TRIGGER                      -- define a new trigger
CREATE TYPE                            -- define a new data type
CREATE USER                           -- define a new database user account
CREATE VIEW                           -- define a new view
DEALLOCATE                            -- remove a prepared query
DECLARE                                  -- define a cursor
DELETE                                    -- delete rows of a table
DROP AGGREGATE                    -- remove a user-defined aggregate function
DROP CAST                               -- remove a user-defined cast
DROP CONVERSION                   -- remove a user-defined conversion
DROP DATABASE                       -- remove a database
DROP DOMAIN                          -- remove a user-defined domain
DROP FUNCTION                       -- remove a user-defined function
DROP GROUP                            -- remove a user group
DROP INDEX                             -- remove an index
DROP LANGUAGE                      -- remove a user-

 

 

DROP TYPE                                -- remove a user-defined data type
DROP USER                               -- remove a database user account
DROP VIEW                               -- remove a view
END                                          -- commit the current transaction
EXECUTE                                  -- execute a prepared query
EXPLAIN                                   -- show the execution plan of a statement
FETCH                                      -- retrieve rows from a table using a cursor
GRANT                                      -- define access privileges
INSERT                                     -- create new rows in a table
LISTEN                                     -- listen for a notification
LOAD                                        -- load or reload a shared library file
LOCK                                        -- explicitly lock a table
MOVE                                       -- position a cursor on a specified row of a table
NOTIFY                                     -- generate a notification
PREPARE                                   -- create a prepared query
REINDEX                                  -- rebuild corrupted indexes
RESET                                      -- restore the value of a run-time parameter to a default value
REVOKE                                    -- remove access privileges
ROLLBACK                                -- abort the current transaction
SELECT                                     -- retrieve rows from a table or view
SELECT INTO                            -- create a new table from the results of a query
SET                                          -- change a run-time parameter
SET CONSTRAINTS                    -- set the constraint mode of the current transaction
SET SESSION AUTHORIZATION -- set the session user identifier and the current user identifier of the current session
SET TRANSACTION                    -- set the characteristics of the current transaction
SHOW                                       -- show the value of a run-time parameter
START TRANSACTION                -- start a transaction block
TRUNCATE                                -- empty a table
UNLISTEN                                 -- stop listening for a notification
UPDATE                                    -- update rows of a table
VACUUM                                   -- garbage-collect and optionally analyze a database

 

 

TRIGGER - After / Before / deleted / inserted - MS SQL

 

TRIGGER

            There are

                        BEFORE (trigger)

                        AFTER (trigger)

 

In BEFORE Trigger .

            There is no keyword in MS sql. Instead it defines for.

It is a default trigger

 

In AFTER Trigger.

            There is a keyword in MS sql.i,e After.

 

 

We can get rows which are stored in temporary table by trigger.

            Insert / update

                        Get values from inserted. ( select * from inserted) (copy of a row(s) effected).

            Delete

                        Get values from deleted .  ( select * from deleted) (copy of a row(s) effected).

 

 

During UPDATE

            On Before trigger – we can get row which is not effected by a update in deleted table.

                                                Basically we get rows from deleted table when we are maintaining log/history table.

 

            On After trigger – we can get row which is effected by a update in inserted table.

 

 

Note : there is no updated temporary table.

 

Service Unavailable

Service Unavailable

Then the first solution to the above error is http://support.microsoft.com/default.aspx?id=823552 but if this does not solve the problem try doing the following stuff.

Open the IIS Manager, right click Web Sites and select properties:



Switch to the Service Tab



Check "Run WWW Service in IIS 5.0 Isolation Mode".

You will be asked for Restart of IIS. Click yes to restart IIS. If you are not asked just restart IIS.

This message (including any attachments) contains confidential information intended for a specific individual and purpose and is protected by law. If you are not the intended recipient, you should delete this Message. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.

Different Ways to Lock Windows XP

Different Ways to Lock Windows XP

There are several ways to lock your Windows XP computer, but all of them use the same command line. The method you choose is a matter of personal preference. via the keyboard The easiest way to lock Windows XP is by simply pressing the Windows logo key and the letter L (for Lock) on a Microsoft Natural Keyboard or any other compatible keyboard that includes the Window key. Doing so will pop up the Unlock Computer Password box. via a Shortcut. If you don't have a keyboard with a Window key or simply don't like the keyboard method, then here's how you can make a desktop shortcut to lock your computer. Right click an empty area of your desktop, choose New/Shortcut and enter this line as the command line: rundll32.exe user32.dll, LockWorkStation Click Next. Name the shortcut whatever you prefer and click Finish. That's it. If you'd like to change the icon, just right click the shortcut and go to Properties/Shortcut/Change Icon. via the command line The above command line can also be used at a DOS prompt to lock your computer. One simple way you can do it would be by clicking Start/Run, typing CMD and then entering the command and pressing Enter. via a bat file This is similar to a Windows shortcut method. But it's a DOS version. If you've never created a bat (batch) file, but would like to try this method, simply open a new text file (such as with Notepad) and type the following commands: @echo off rundll32.exe user32.dll, LockWorkStation cls Save the file with a .bat extension, such as Lock.bat, and you're done. Double click to make the file run. Those are the basic methods to lock XP, but there are some other relating factors of which you should be aware. Password It should go without saying that if you don't use a password to log on to your computer, then anyone can access your computer and unlock it. If you want to use the lock feature, then set a password by going to User Accounts in the Control Panel and then click Create Password. Fast User Switching Fast User Switching allows multiple login sessions at the same time. Whether you have this feature enabled or disabled will make a big difference in how your locked computer can be accessed and on the behavior of your shortcuts when executed. If enabled, executing any of the above locking methods will bring up the Welcome screen and other users will be able to log on to the computer, as is the norm for Fast User Switching. So, you really don't get much security at all this way, if your intention is to lock your machine. With Fast User Switching, only your profile is locked, not the ability for other users to log into your system. Any other user can just log on to your computer and use it. If Fast User Switching is disabled, you will have to enter a password to unlock the computer. Double clicking your shortcut will bring up the Unlock Computer password dialog box. This is the same lock method that Windows NT and 2000 uses. If you're not sure whether or not you have Fast User Switching enabled or disabled, go to User Accounts in the Control Panel and click the Change the way users log on or off tab. There you will see your status for Fast User Switching. Welcome Screen Whether the Welcome screen is enabled or disabled also has an effect on the way your computer can be locked. If the Welcome screen is enabled, you can also lock your computer in Task Manager (Ctrl+Alt+Delete) by clicking the Lock Computer option in the Shutdown menu list. This option will only appear if the Welcome screen is enabled—without Fast User Switching being enabled. Note! In order to use Fast User Switching, the Welcome screen must be enabled. You cannot select Fast User Switching if the Welcome screen option is unchecked. If the Welcome screen is disabled, you can lock the computer by pressing Ctrl+Alt+Delete and then clicking the Lock Computer tab in the Windows Security dialog box that comes up.

Get Server and Machine Name in SQL

 

 

To Get Server name in Microsoft Sql .

select @@SERVERNAME

 

To Get Machine name in Microsoft Sql .

select host_name()