To get the Host Name and IP address in C#

using System.Net;
string getHost = System.Net.Dns.GetHostName();
string getIP = System.Net.Dns.GetHostByName(getHost).AddressList[0].ToString();

To Findout the Port no. , Server name of sql server.

DECLARE @SqlServerName VARCHAR(255)
        , @SqlVersion VARCHAR(255)
        , @PortNumber VARCHAR(10)

DECLARE @Result TABLE(ServerName VARCHAR(255), Version VARCHAR(255), Port VARCHAR(10))

SELECT @SqlServerName = @@ServerName,  @SqlVersion = LEFT(@@Version, 38)

EXEC xp_regread
    @rootkey = 'HKEY_LOCAL_MACHINE',
    @key = 'SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\SUPERSOCKETNETLIB\TCP',
    @value_name = 'TcpPort',
    @value = @PortNumber output

Select @PortNumber,@SqlServerName ,@SqlVersion

What Means of CMM Level ?

Hi,
Any company which has been started new comes under CMMiLevel1 which says that they are not using any documents or following any processes.
CMMi - means Capability Maturity Model integrated.
CMMi is newly introduced. So most of the companies will have CMM certification only and not the CMMi. Only few companies at present are CMMi level.
Actually this certification is given by the Software Engineering Institute by USA.

CMM software Maturity Levels:

Level1:Initial: The s/w development process at this level are adhoc and often chaotic.The project's success depends on heroes and luck.There are no general practices for planning monitoring or Controling the process.It's impossible to predict the time and cost to develop the software.The test process is just as adhoc as the rest of the process.

Level2:Repeatable: This maturity level is best describled as project level thinking.Basic project management processes are in place to track the cost shedule functionality and quality of the product.Lessions learned from previous similar projects are applied.There is a scense of descipline.Basic software testing practices such as test plans and test cases are used.

Level3:Defined: Organizational not just project specific thinking comes in to play at this level.Common management and engineering activities are standerdized and documented.These standerds are adapted and approved for use on different projects.The rules are not thrown out when things get stressfull.Test documents and plans are reviewed and approved before testing begins.The test group is independent form developers.The test results are used to determine when the s/w is ready.

Level4:Managed: At this maturity level the organizations process is under statistical control.Product quality is specified quantitatively beforehand (for example this product wont release until it has fewer than 0.5 defects per 1 000 lines of code) and the s/w isn't released untill that goal is met.details of the development process and the s/w quality are collected over the projects development and adjustments are made to correct deviations and to keep the project on plan.

Level5:Optimizing: This level is called optimizing (not optimized )because it's continually improving from level 4. new technologies and processes are attempted the results are measured and both incremental and revolutionary changes are instituted to achieve even better quality levels.Just when everyone thinks the best has been obtained.the crank is turned one more time and the next level of improvement is obtained.

Thanks.

HAPPY BIRTH DAY

Happy B'day my dear...

Difference Between Virtual and Cache memory

Nowadays memory seems to be almost infinite and nobody actually gets the “not enough memory” messages of yester-year. How did they accomplish that?

The answer to that is a very smart memory management procedure. By placing some parts that should be in memory inside your hard-disk they can extend the memory capacity of a computer way beyond what is installed; this is called virtual memory. So let’s say that your computer only has 1GB of memory and you launch a few programs whose total memory consumption is at around 1.5GB. Without virtual memory, you are not allowed to do that. But with virtual memory, the operating system assigns a portion of the hard-disk as a part of memory and keeps the data there. So in the above example let’s say that the virtual memory is also 1GB. 1GB actual memory + 1GB virtual memory = 2GB system memory. That way even though your memory is limited you can still use memory extensive applications.

There is a disadvantage to virtual memory though. Reading data from a hard disk is substantially slower than reading from memory. So the more information that is stored in your hard-disk the slower your system becomes making it seem sluggish.

Cache memory on the other hand doesn’t extend the amount of memory you have, it merely lessens the amount of time needed to access data. So that you can understand the concept easily, let’s say that the processor is a student doing a report. Whenever he needs data he goes to the bookshelf (the bookshelf being the memory, and the books are the data) ,that is called Cache memory.

SAP memory vs ABAP memory

ABAP (Advanced Business Application Programming) programs run on a SAP database. ABAP programs can utilize two types of memory, ABAP memory and SAP memory. The main difference between these two types of memory is their scope. ABAP memory is pretty limited and can only be accessed within one main internal session. Other programs running outside that session will not be able to read or write to that memory. On the other hand, SAP memory is pretty much like global memory and is accessible not only by programs that are running under the same main session but also across different main sessions.
The different scopes between the two lead to two different uses. The main use of ABAP memory is to make data accessible across multiple transactions within the same session. Although SAP memory is also capable of performing this function, it is reserved for its own purpose; making information available or transferring data across main session.

Summary:

1. SAP memory is global and can be used to pass data across main sessions while ABAP memory is local and is uses to pass data across internal sessions
2. GET PARAMETER and SET PARAMETER are used to write and read to SAP memory while IMPORT FROM MEMORY and EXPORT TO MEMORY are used for ABAP memory

Read more: Difference Between SAP memory and ABAP memory | Difference Between | SAP memory vs ABAP memory http://www.differencebetween.net/technology/software-technology/difference-between-sap-memory-and-abap-memory/#ixzz19ZPzN86a.

Get-IP-address-all-computers-under-network

using System.Net;

string hostName = System.Net.Dns.GetHostName();

System.Net.IPHostEntry IpAddress = System.Net.Dns.GetHostEntry(hostName);

foreach(System.Net.IPAddress Ip in IpAddress.AddressList)
{
MessageBox.Show(Ip.ToString());
}