System Information for Windows

SIW - System Information for Windows  "Everything you want to know about your computer"

 
SIW is an advanced System Information for Windows tool that gathers detailed information about your system properties and settings and displays it in an extremely comprehensible manner.
SIW can create a report file (CSV, HTML, TXT or XML), and is able to run in batch mode (for Computer Software and Hardware Inventory, Asset Inventory Tracking, Audit Software Licenses, Software License Compliance).


The system information is divided into few major categories:

• Software Inventory: Operating System, Installed Software and Hotfixes, Processes, Services, Users, Open Files, System Uptime, Installed Codecs, Software Licenses (Product Keys / Serial Numbers / CD Key), Passwords Recovery.
• Hardware Inventory: Motherboard, CPU, Sensors, BIOS, chipset, PCI/AGP, USB and ISA/PnP Devices, Memory, Video Card, Monitor, Disk Drives, CD/DVD Devices, SCSI Devices, S.M.A.R.T., Ports, Printers.
• Network Information: Network Cards, Network Shares, currently active Network Connections, Open Ports.
• Network Tools: MAC Address Changer, Neighborhood Scan, Ping, Trace, Statistics
• Miscellaneous Tools: Eureka! (Reveal lost passwords hidden behind asterisks), Monitor Test, Shutdown / Restart.
• Real-time monitors: CPU, Memory, Page File usage and Network Traffic.

Read more here 

Download here

Visual Studio Programmer Themes Gallery

Website that makes it easy to download VS color scheme


Check out here 

  

Download and Share Visual Studio Color Schemes

New website that makes it easy to download and share VS color scheme

http://studiostyl.es/ enables you to easily browse and download Visual Studio color schemes that others have already created.

You can apply the setting through – Tool -- > Import and Export Setting

Code Converters

Hands up who wants to hand convert C# to VB.NET (or back again)? No? Well, we've got just the tools for you. These will do it automatically and won't cost you a penny!

Refer the below URL

http://www.developerfusion.com/tools/

Recursive Directory Info

Imports System
Imports System.IO

Public Class MainClass

  Shared Sub Main()

    Dim nameOfDirectory As String = "C:\"
    Dim myDirectory As DirectoryInfo
    myDirectory = New DirectoryInfo(nameOfDirectory)
    WorkWithDirectory(myDirectory)

  End Sub

  Shared Public Sub WorkWithDirectory(ByVal aDir As DirectoryInfo)
    Dim nextDir As DirectoryInfo
    WorkWithFilesInDir(aDir)
    For Each nextDir In aDir.GetDirectories
      WorkWithDirectory(nextDir)
    Next
  End Sub

  Shared Public Sub WorkWithFilesInDir(ByVal aDir As DirectoryInfo)
    Dim aFile As FileInfo
    For Each aFile In aDir.GetFiles()
      Console.WriteLine(aFile.FullName)
    Next
  End Sub

  
End Class



Reference URL

C# Code : Connection strings for SQL Server 2008

using System.Data.SqlClient;

private void ValidationFile()

{

 string FilePath = "";

 using (SqlConnection myConnection = new SqlConnection("Data Source=servername;Initial Catalog=db_name;User ID=user;Password=pass;"))

                {

 using (SqlCommand myCommand = new SqlCommand("select scanned_document_id, master_id, file_path from scanned_documents", myConnection))

                            {

                                myCommand.CommandType = CommandType.Text;

                                myConnection.Open();

                                using (SqlDataReader myReader = myCommand.ExecuteReader())

                                      {

                                            if (myReader.HasRows)

                                                  {

                                                       while (myReader.Read())

                                                           {

                                                               FilePath = 

                                                               myReader.GetString(myReader.GetOrdinal("file_path"));                           

                                                            }

                                                    }

                                       }

                              }

                }

 }

What is Google Chrome OS?

Google Chrome OS UI Concept Video

Agile Software Development

Definition : Agile software development is a group of software development methodologies based on iterative and incremental development, where requirements and solutions evolve through collaboration between self-organizing, cross-functional teams

Agile Manifesto reads, in its entirety, as follows:

We are uncovering better ways of developing software by doing it and helping others do it. Through this work we have come to value:

Individuals and interactions over processes and tools
Working software over comprehensive documentation
Customer collaboration over contract negotiation
Responding to change over following a plan

That is, while there is value in the items on the right, we value the items on the left more.

Twelve principles underlie the Agile Manifesto, including:

• Customer satisfaction by rapid, continuous delivery of useful software
• Working software is delivered frequently (weeks rather than months)
• Working software is the principal measure of progress
• Even late changes in requirements are welcome
• Close, daily cooperation between business people and developers
• Face-to-face conversation is the best form of communication (co-location)
• Projects are built around motivated individuals, who should be trusted
• Continuous attention to technical excellence and good design
• Simplicity
• Self-organizing teams
• Regular adaptation to changing circumstances

 Agile methods
 
Well-known agile software development methods include:

• Agile Modeling
• Agile Unified Process (AUP)
• Dynamic Systems Development Method (DSDM)
• Essential Unified Process (EssUP)
• Extreme Programming (XP)
• Feature Driven Development (FDD)
• Open Unified Process (OpenUP)
• Scrum
• Velocity tracking

 Reference URL


Related Information

http://www.agilemodeling.com/



     

Google Chrome OS Release Date: Q4 2010

We have known for some time that Google was to release Chrome OS sometime this year, we have new information that it will be in Q4 2010 – so from September to December. This is the most accurate release date we have so far, and will join a list of operating systems to battle the dominance of Windows.
Saying that, Microsoft has been losing ground in its market share and the future release of Google Chrome OS could become one large headache for Windows. Google were once underestimated in the mobile OS market – but look how dominant they are now.


It had been thought that Chrome OS would have a Q3 launch but NetworkWorlds, Dan Nystedt, reports that Google’s vice president of product management, Sundar Pichai has a different view on this release date. Also announced at Computex 2010 was that the Chrome Web Store would open to coincide with the launch of the new OS.
This new service will allow Chrome OS users to visit the store and download web apps to be used on the operating system . 2011 will be an even better year for Google, as they will have an OS for both the smartphone and laptop and PC market.

Read more about Google Chrome

Related News and Information

http://the-it-articles.blogspot.com/2010/10/google-chrome-web-store-plans-details.html

Reference URL

What's New in Visual Studio 2010?

This topic contains links to information about new features and enhancements in Visual Studio 2010 and associated service releases.

New in Visual Studio 2010

---

Languages

Title	Description
What's New in Visual Basic 2010	Describes new features in the Visual Basic language and Code Editor. The features include implicit line continuation, auto-implemented properties, collection initializers, and more.
What's New in Visual C# 2010	Describes new features in the C# language and Code Editor. The features include the dynamic type, named and optional arguments, enhanced Office programmability, and variance.
What's New in Visual C++ 2010	Describes new and revised features in Visual C++. The features include lambda expressions, the rvalue reference declarator, and the auto, decltype, and static_assert keywords.
What's New in Visual F# 2010	Describes the F# language, which is a language that supports functional programming for the .NET Framework.

For More Details Log on to

http://msdn.microsoft.com/en-us/library/bb386063.aspx

http://msdn.microsoft.com/en-us/library/dd547188.aspx


   

Windows 7 Installation Guide / Tutorial

Windows 7 Installation Guide / Tutorial

The Windows 7 is finally here. It's released for beta testers a few days ago and I am here with a small step by step picture guided tour through the installation process. I downloaded the x86 version of the M3 build ( build No: 6801) from Microsoft Connect site, which is 2.72 GB ISO. The x64 version is around 3.2 GB in size.

The installation process was just like vista setup and to my surprise completed in just around 20 minutes in my low end Virtual hardware. This surely indicates the performance improvements Microsoft has put on this windows vista replacement.

Poll : Windows 7

For More Detail Log on to 

http://www.techtalkz.com/windows-7/514412-windows-7-installation-guide-tutorial.html



   

Windows Vista Deployment Step-by-Step Guide

Windows Vista Deployment Step-by-Step Guide

 This document provides instructions for implementing a basic image-based deployment of Microsoft® Windows Vista® operating system. We recommend that you first use the steps provided in this guide in a test lab environment as a means to become familiar with new and updated deployment features and technologies available in Windows Vista.
Step-by-step guides are not necessarily meant to be used to deploy Windows Vista operating system features without accompanying documentation (as listed in the Additional Resources section) and should be used with discretion as stand-alone documents.

Windows Vista Deployment Overview

This document is designed for IT professionals and deployment specialists who are responsible for deploying Windows® operating systems in an organization.

Deployment scenario

You will use the steps in this scenario and the procedures in the examples to implement a basic image-based deployment of Windows Vista on hardware without an operating system installed. For more information about the tools and technologies referenced in this section, see Tools and Technologies later in this document.
The process for the deployment scenario includes:

• Building a lab environment.
• Creating an answer file by using Windows System Image Manager (Windows SIM).
• Building a master installation by using the product DVD and your answer file.
• Creating an image of the master installation by using the Windows Preinstallation Environment (Windows PE) and ImageX technologies.
• Deploying the image from a network share onto a destination computer using Windows PE and ImageX technologies.

At the end of this example, you should have a working lab environment that includes a technician computer, a valid answer file, a CD that you can use to start Windows PE, and your first custom Windows image.
In addition, you will gain a basic understanding of the Windows AIK toolset. With this knowledge, you can modify your answer file to include additional customizations. You can also automate parts of the process by scripting some of the manual steps in this example.

In this document

Topics covered in this document include:
Tools and Technologies
Requirements and Prerequisites
Step 1: Building a Lab Environment
Step 2: Building an Answer File
Step 3: Building a Master Installation
Step 4: Creating an Image
Step 5: Deploying an Image
Additional Resources

For More Detail Log On to 


http://technet.microsoft.com/en-us/library/cc721929(WS.10).aspx

Install Windows XP

Install Windows XP

Most new computers come with Windows XP installed, so many people never have to install it. However, you may need to install Windows XP if:

•	You replaced your hard disk drive with a new hard disk drive that does not have Windows XP installed.
•	You are reinstalling Windows XP on a computer because you want to clean off your hard drive and remove any unwanted programs, such as spyware.
•	You purchased a computer without an operating system.

Fortunately, you do not need to be a computer expert to install Windows XP. Installing Windows XP is a straightforward process that takes between one to two hours. Of that time, you need to be present for only about 30 minutes.

•	Pre-installation checklist
•	Install Windows XP For More Detail Log on to  http://www.microsoft.com/windowsxp/using/setup/winxp/install.mspx

Migrating Logins from One SQL Server to Another

As part of the normal work, a Database Administrator (DBA) will be required to migrate databases between servers. One of the reasons for a migration might be that you are moving an application from a quality assurance (QA) environment to a production environment. Another reason might be your current database server hardware has reached the replacement date and you need to migrate your databases from the current, out-dated server to a new server. Yet another reason might be you are migrating your application from SQL Server 7.0 to SQL Server 2000. Whatever the reason you will more than likely have to deal with migrating not only the data, but the SQL Server logins that access that data as well.
There are a number of different ways to migrate SQL Server logins. You can manually re-enter the entire existing login on the new server. You can use DTS to transfer logins. There are probably a number of other ways to transfer logins. This article will discuss one of those other ways to streamline the migration of SQL Server logins, by using the stored procedure (SP) sp_help_revlogin.

What does the sp_help_revlogin do?

The sp_help_revlogin SP is a Microsoft provided utility that generates a TSQL script to migrate logins from one server to another. This SP will not only copy the existing logins, but it will also copy the passwords and Security Identification Numbers (SID) associated with SQL Server Authenticated users.

Why you might want to use sp_help_revlogin

When you move a database from one server to another, the entire database and all the system tables associated with it are also moved. One of those system tables is the sysusers table. The sysusers table contains all the users, groups and roles that have access to the database. In order for a person to be able to access the database, they must have two things. The first thing they must have is a SQL Server login. The second thing they need is to be defined as a user in the database. Therefore, if you copy a database from one server to another and the users of the database don't have SQL Server logins then these database users become orphan users. An orphan user is a user in a database with a SID that does not exist in the syslogins table in the master database. Also if the SID stored in the database sysusers table, differs from SID stored in the syslogin table for the matching database user, then the database user is also considered an orphan user. If you retain the original SID for logins, when a user database is migrated, you will not have a problem with orphan users.

By using the sp_help_revlogin SP, you can move logins from one server, and create the login entries in the new server and retain the sid. By making sure that all logins exist on the new server prior to copying a database, you will ensure there will be no orphan users after you complete the database copy The sp_help_revlogin SP helps DBA's quickly move logins from one server to another.

How the sp_help_revlogin Works

The process of moving logins requires not only the sp_help_revlogin SP, but also the sp_hexidecimal SP. These scripts and more information about migrating logons can be found in the following Microsoft Knowledge Base article http://support.microsoft.com/default.aspx?scid=kb;en-us;246133. I have also included a script to create both of these SP's at the bottom of this article. Let's review the sp_help_revlogin process.
The easiest way to execute the sp_help_revlogin script is via Query Analyzer. The SP accepts a single optional parameter, @login_name. If you only want to generate a single login, then you can pass a valid login to sp_help_revlogin, and it will generate a script to create the specified login. When @login_name is not specified this SP generates a TSQL script to create all the logins on the server.
Based on whether the @login_name was specified, the sp_help_revlogin SP builds a cursor called login_curs that contains information in the sysxlogins table in the master database for a single login or all the logins on the server, except sa'. The columns placed in the cursor are sid, name, xstatus and password. The xstatus column will be used to determine if the login is a Windows or SQL Server Authenticated users, as well as whether the login has been denied access. The sid and password will be used to make sure the new login on the new server retains the same sid and password as the original server.
Next the sp_help_revlogin SP processes through the login_curs cursor one login at a time in a while loop. Inside the while loop the SP determines if the login is a Windows authenticated user or group (xstatus = 4) or not. If the user is a Windows authenticated user then a sp_grantlogin statement is generated. For the SQL Server authenticated users a sp_addlogin statement, with the skip_encryption parameter is generated. The skip_encryption parameter is used on the sp_addlogin statement to tell SQL Sever that an encrypted password is being specified when the login is being created, so the password should not be encryted.
For SQL Server authenticated users, the SP needs to determine the sid and password of the login. Since the sid and the password as stored as binary numbers, the sid and password values need to be converted to a string that contains the hexadecimal representation of the binary number. The sp_hexadecimal SP is used to do this binary number to hex string conversion.
When the sp_help_revlogin execution is complete, the script to create the logins should be displayed in the Query Analyzer results pane. All you need to do to add these logins to a server would be just to copy the script from the results pane and run it against the new server where you want to add the logins.

Other uses for the sp_help_revlogin SP

Using the sp_help_revlogin as it comes from Microsoft will move all logins or a single login. Maybe you only want move all the logins for a single database. It is easy to modify the code that creates the "login_curs" to identify only the users you want to move.
Often I am only moving a single database. When I do that, I modify the creation of the "login_curs" cursor command to look like so:

    SELECT sid, name, xstatus, password FROM master..sysxlogins a join
    Your_DB..sysusers b on a.sid = b.sid
    WHERE srvid IS NULL AND name <> 'sa' 

By using this logic instead, the sp_help_revlogin will only generate sp_grantlogin, and sp_addlogins for users of the database Your_DB.
Another possible use might be to generate the script for all logins, then delete the logins you do not want to move. This method allows you to be selective in the logins that will be created on the new server.

Conclusion

Here I have shown you a method to quickly generate a script that will move all logins from one server to other, as well as offered you ideas on how to move a sub set of users. I am sure you can find other uses for this sp. Using sp_help_revlogin is much easier than re-entering all logins on a new server. In addition, re-entering logins would most likely establish a new password for each login moved, where as this sp allows you to move the passwords. Moving the passwords from one server to another is more user friendly. SQL Server users will be grateful that they do not have to remember a new password, and it makes the migration a little more transparent to the SQL Server users.

Script to Create sp_hexidecimal and sp_help_revlogin

Reference URL  

SQL Server - Transaction/Sec

Windows based Performance Monitor to find Transaction/Sec for SQL Server

 Go to Control Panel --> Administrative Tool --> Performance  

Other Article


http://blog.sqlauthority.com/2010/10/04/sql-server-find-total-number-of-transaction-on-interval/

Smart PDF Creator 5.8

Smart PDF Creator will easily convert files such as DOC, XLS, HTML, RTF ,TXT to PDF format. You will experience user friendly interface which is very easy to work with. Smart PDF Creator also features batch conversion; you will be able to convert as many files as you want. All you have to do is to add your file into the program and click Convert. We have also included advanced options like PDF security which allows you to set a password for your PDF file thus no one else will be able to edit it. There are three ways to convert your files to PDF format: Smart PDF Converter will create a special toolbar menu within MS Word, all you have to do is to open your file and press the Create PDF button, you can also use the Virtual PDF Printer from within any program that supports printing and finally you can just right click the file which you need to convert to PDF format and select the "Convert to PDF button". Smart PDF Creator comes with step by step instructions, unconditional technical support and 100% money back guarantee. This software runs on all Windows systems

For More Details Log On to
http://www.freedownloadscenter.com/Business/Word_Processing/Smart_PDF_Creator.html

 

TeamViewer 5.0.8703

TeamViewer is a simple and fast solution for remote control, desktop sharing and file transfer that works behind any firewall and NAT proxy. The software can also be used for presentations, where you can show your own desktop to a partner. With the VoIP audio and video capability you can talk to your partners for free or chat with them and give your sessions a more personal touch by using a webcam. It’s that easy: To connect to another computer just run TeamViewer on both machines without the need of an installation procedure. With the first start automatic partner IDs are generated on both computers. Just enter your partner's ID and password into TeamViewer and the safe connection is established immediately. For private persons TeamViewer is free of charge. For several millions of users worldwide TeamViewer is a standard tool to give support and assistance to people in remote locations.

For More Detail Log on to
 http://www.freedownloadscenter.com/Network_and_Internet/Remote_Computing_Tools/TeamViewer.html

Microsoft Visual Studio 2010

A powerful IDE that ensures quality code

Visual Studio 2010 is packed with new and enhanced features that simplify the entire development process from design to deployment. Customize your workspace with multiple monitor support. Create rich applications for SharePoint and the Web. Target multiple versions of the .NET Framework with the same tool. Eliminate the dreaded "no repro" problem with IntelliTrace. And much more.

For More Details Log on to

http://www.microsoft.com/visualstudio/en-us/ 

 

SQL Interview Questions

SQL Interview Questions

Cool Interview

Tech Interviews

Data Base

 

Everything Search Engine

Everything Search Engine

Locate files and folders by name instantly.

Small installation file Clean and simple user interface Quick file indexing Quick searching Minimal resource usage Share files with others easily Real-time updating More...

For more information please visit the Everything FAQ

Download Everything for Windows 2000, XP, 2003, Vista, 2008 and Windows 7

Everything-1.2.1.371.exe (334 KB)

Everything-1.2.1.371.zip (portable, 272 KB)

(See list of changes) ▪ Older versions ▪ MD5

Reference URL