Recent Blogs

AvatarByRashid Aziz

Cloud computing

Cloud Computing:
Cloud Computing is a term that is often bandied about the web these days and often attributed to different things that — on the surface — don’t seem to have that much in common. So just what is Cloud Computing? I’ve heard it called a service, a platform, and even an operating system. Some even link it to such concepts as grid computing — which is a way of taking many different computers and linking them together to form one very big computer.

A basic definition of cloud computing is the use of the Internet for the tasks you perform on your computer. The “cloud” represents the Internet

 How Cloud Computing Works:
The basic cloud computing foundation is comprised of a data center (servers, network switches, Internet connectivity, etc.), virtualization software (used to segment physical resources between users), operating system (Windows, Linux, etc.) and applications (Apache, MySQL, etc.). Together, these components “power the cloud” for millions of people using popular services such as Google’s Gmail. Here’s an illustration:
It’s On-Demand
Cloud computing is mostly “pay-as-you-go”. Quite simply, you only pay for what you need without contractual requirements. Imagine launching hundreds of servers “in the cloud” to number crunch decades of data for your client. Once the servers have fulfilled their purpose, you would simply “terminate” them and pay only for the time used. A few example uses:
• Web site overflow • Database hosting • Gaming server
The possibilities are endless!
Flexible, Configurable
Cloud computing solutions are offered in many flavors of hardware and software’s options:
• 32-bit and 64-bit “virtual servers” • Linux and Windows • High I/O throughput • Gigabit network interfaces • Gigabytes of storage and memory
Whatever your requirements, you won’t find a lack of options to choose from.
Cloud Computing Architecture:
Cloud architecture, the systems architecture of the software systems involved in the delivery of cloud computing, comprises hardware and software designed by a cloud architect who typically works for a cloud integrator. It typically involves multiple cloud components communicating with each other over application programming interfaces, usually web services.
This closely resembles the Unix philosophy of having multiple programs each doing one thing well and working together over universal interfaces. Complexity is controlled and the resulting systems are more manageable than their monolithic counterparts.
Cloud architecture extends to the client, where web browsers and/or software applications access cloud applications.
Cloud storage architecture is loosely coupled, where metadata operations are centralized enabling the data nodes to scale into the hundreds, each independently delivering data to applications or users.
Cloud Computing Application:
There are three types of services offered. 
  • Infrastructure as a service
  • Platform as a service
  • Software as a service
Infrastructure as a service
in this type,the service provider provides the necessary servers,hardware and networking components to an organisation for a fee.The organisation in turn installs the necessary programs in the service provider’s server and uses them.The service provider is responsible for the maintenance of the servers.
Platform as a service
In this type,the service provider provides the necessary softwares and the tools for creating softwares which are installed in their server to an organisation for a specified amount.The organisation creates the necessary softwares on his platform and uses them.Its like renting in a house which has all the necessary things.
Software as a service
In this type the applications hosted in the service provider s server are made available to customers via the internet.The provider also interacts with the user through a front end panel.The provider provides the necessary support to the customer.The services range from e-mail to data processing.
Cloud Computing Standards:
Computer hardware (Dell, HP, IBM, and Sun Microsystems)
  • Storage (3PAR, EMC, Hitachi Data Systems, IBM, Mezeo, NetApp, ParaScale, and Sun Microsystems)
  • Infrastructure (Cisco Systems, Juniper Networks, and Brocade Communications)
Computer software (3tera, Eucalyptus, g-Eclipse, and Hadoop)
  • Operating systems (Solaris, AIX, Linux including Novell, Red Hat, and Ubuntu)
  • Platform virtualization (Citrix, IBM, Linux KVM, Microsoft, Sun xVM, VMware, and Xen)
  • Communications (HTTP, XMPP)
  • Security (OAuth, OpenID, SSL/TLS[85])
  • Syndication (Atom)
  • Browsers (AJAX)
  • Offline (HTML 5)
  • Virtualization (OVF)
  • Solution stacks (LAMP)
  • Data (XML, JSON)
  • Web Services (REST)
Cloud Computing Concerns:
Cloud Computing: changing the way we use computers forever
Cloud computing enables businesses to run online applications and services – rather than locally installed software. Cloud Computing is a new ‘pay-as-you-go’ internet model, sometimes referred to as SaaS (Software as a Service). It is being embraced by companies worldwide so that they can offer their workers the latest versions of business applications (e.g. Office) and server products (e.g. Exchange) at a much lower price – whilst lowering energy bills, hardware purchases and IT support costs.
Cost Savings:
Developers, consultants, small business owners and corporations are all attracted to cloud computing because of its cost-effectiveness. Rather than spending thousands of dollars on hardware, bandwidth and energy costs, people are now turning to the cloud in droves.
·         No up-front software purchases
·         No annual software upgrades fees
·         No onsite IT professional install costs
·         No server hardware costs
·         No expensive PC upgrades costs (supports older hardware)
·         Reduced ongoing IT support costs
Infinitely Scalable:
You may not own several thousand servers, but with a few simple clicks, you can create the next Google with some ingenuity and creativity using a reliable, proven computing platform. Popular websites such as and are using cloud computing to power their online presences for millions of users. And when they require additional horsepower? Well, with a little programming (or a “scaling manager” such as RightScale), it’s as simple as launching more “pre-built” servers to handle the increase in load.
You Are In Control
Gone are the days of expensive hosting solutions, outrageous setup fees and asinine limitations on what you can install and run on a server. Within minutes, you could be running a brand-new Windows or Linux server for pennies an hour. No wait time, no hassle, no fuss. The most visible cloud computing player in the industry is Amazon Web Services, LLC (AWS). A subsidiary of, AWS offers a suite of services which include Elastic Compute Cloud (EC2), Elastic Block Storage (persistent storage), SimpleDB and more. Amazon runs the largest known installation of the open source XEN virtualization technology — The heart of its cloud computing offering.
Collaboration with Hosted SharePoint in the Cloud:  

Unlimited users can access Hosted SharePoint from anywhere, plus it’s ready to be built out—making this an incredibly scalable and convenient example of why cloud computing is taking off in a big way. Then there’s the cost-savings, with plans starting at $30 per month and up to 200 GB. SharePoint Hosting is your ticket to a fully-maintained and stable solution.

Future Foundations

SharePoint Foundations is the software delivering full functionality—minus the maintenance, setup, and capital cost that come standard with on-site services. We partner with one of the nation’s largest and most-proven SharePoint hosting and Exchange hosting companies—bringing both considerable experience and expertise to this solution.

Hosted Sharepoint Services in the Cloud

Because Hosted SharePoint resides in the cloud, you can be assured of full security, virus protection and backup systems to keep your information safe and sound. All while giving you the dependable performance you expect and deserve in the Hosted SharePoint environment.

AvatarByRashid Aziz

Installing and configuring active directory using powershell

Signing PowerShell Scripts 

PowerShell supports a concept called “execution policies” in order to help deliver a more secure command line administration experience.  Execution policies define the restrictions under which PowerShell loads files for execution and configuration.  The four execution policies are Restricted, AllSigned, RemoteSigned, and Unrestricted. see detail
Disable Loopback check
In order to browse sites on the VM using host headers then PowerShell command must be run.
To disable the loopback check, run this command from PowerShell:
New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name “DisableLoopbackCheck”  -value “1” -PropertyType dword

How-To Administer Active Directory Domain Services User Accounts Using Windows PowerShell

The Active Directory Module for Windows PowerShell, which is included with Windows Server 2008 R2, can be used to administer Active Directory Domain Services (AD DS) objects, including user accounts. What follows is an in-depth look at administering AD DS user accounts by using the Active Directory Module for Windows PowerShell.
There are a number of tasks that can be performed on user accounts by using the cmdlets included with the Active Directory Module for Windows PowerShell, such as:
§  Retrieving user accounts
§  Creating user accounts
§  Deleting user accounts
§  Modifying user accounts
§  Disabling user accounts
§  Enabling user accounts
§  Unlocking user accounts
See details: click here 

 Windows PowerShell 2.0 Brings Scripting to Active Directory

Sometimes, it seems like Microsoft can take forever to produce the solutions we need. I mean, tens of thousands of worldwide employees, and still no “Halo 4”? But sometimes, the wait is simply because it’s trying to produce the right solution — and in the case of Active Directory scripting and automation, the wait has paid off. Windows Server 2008 R2 ships with a Windows PowerShell 2.0 module that enables fantastic scripting and automation for Active Directory. 
See details: click here 

Active Directory Administration with Windows PowerShell

Windows PowerShell™ is a command-line shell and scripting language that can help information technology (IT) professionals control system administration more easily and achieve greater productivity.
See details: click here 

Managed Service Accounts

This section contains topics that explain how to use the Active Directory to accomplish many of the common tasks that are associated with service account management using PowerShell:
·         Creating a Managed Service Account
·         Finding Managed Service Accounts per Computer
·         Finding Managed Service Accounts
·         Associating a Managed Service Account with a Computer
·         Removing a Managed Service Account from a Computer
·         Deleting a Managed Service Account
·         Installing a Managed Service Account
·         Resetting the Password of a Managed Service Account
See details: click here 
AvatarByRashid Aziz

Setup new virtual machine using hyper-v manager

To add a new Guest Virtual Machine, Launch Hyper-V Manager from “Administrative Tools” and connect to the server with the Hyper-V Role (if not the localhost). In the Actions Menu on the right, click New“. Click “Next” on the “Before you begin wizard introduction window.
In the Specify Name and Location window, enter the name of the Guest Operating System. If you do not want to save the Virtual Machine in the default location then check the box for “Store the Virtual Machine in a different location” and browse and locate your new location. Once this done, click “Next”.
In the Assign memory window, set the memory for the Guest OS and click Next. Default is 512MB.
In the Configure networking window, select the Virtual Network (should have been created at the time of enabling the Hyper-V roles or can be done later on). If you choose the connect to the Virtual network later, select “Not connected” and click Next.
In the Connect Virtual Hard Disk window, create a new Virtual Hard disk and set its size. Default is 127GB. Here again, you can choose to save the disk in a different location than the defaults. Also, if you already have a Virtual Disk and want to use it, you can do so or choose to attach a Virtual Hard Disk later. Once, Virtual Hard Disk (VHD) is created, click “Next”.
In the Installation Options window, choose the media to perform the installation. This could be your physical CD/DVD drive or an ISO image on the system or Floppy disk or even from a Network installation server. Choose the installation option and click “Next”.
Now, you can see the new VM under the Virtual machines box in the Hyper-V Manager.   When you click on it, in the bottom left, you can check the options specific to this virtual machine. The Settings option allows you to change any parameter like memory set at the time of creating the VM. One of the key thins to note is the “Integration Services” found under Management in the left pane. Integration services run under the guest operating system to provide some level of “integration” between the host and the guest OS like time sync, Guest OS backup etc.

Click Start under the VM or right-click and select Start to start the Virtual OS. This starts and runs in the background. Click Connect to actually, open a console session with the Guest OS. Depending on your Host system performance level you can run multiple guests OSs at any given time.
In the Summary window, check your options and click Finish if all is good to go. Here you can choose to start the Virtual Machine immediately after it is created. Default is to keep the VM OFF.
AvatarByRashid Aziz

Free web analytics tool

Web Analytics:
Web analytics is the measurement, collection, analysis and reporting of internet data for purposes of understanding and optimizing web usage. It measures and analyzes various online activities like page visits, bounce rate, conversion rate etc. Web syndication: The process of making content available to other sites via web feed. 
Google Analytics:
Google Analytics shows you how people found your site, how they explored it, and how you can enhance their visitor experience. With this information, you can improve your website return on investment, increase conversions, and make more money on the web. Google Analytics has made it easy for non-specialists and specialists alike, across your organization, to practice performance focused marketing.
Getting Started with Google Analytics
The key to any website’s success is being able to measure success or failure, and having the data to make good decisions. In order to provide a positive user experience on your site, you need to understand your visitors and what they’re doing so that you can constantly improve upon it.  This is where Google Analytics comes into play.  The Google Analytics tool is available free of charge to anyone who wishes to use it, so here we go…
Step 1: Get a Google account:
For getting started you have to create an account by visiting In the top right corner you should see a Sign In link. Click it or you can use your existing Gmail account if any.
 This will take you to a login page that will also allow you to sign in & sign up 
Step 2: Get a Google Analytics account:
Go to, click on Access Analytics (a big blue button at the time of this writing) and login using your Google account.
 Once you’ve logged in you’ll be prompted to sign up for Google Analytics. Click the Sign Up button.
To start the account signup process you’ll be prompted to enter your Web site’s URL (domain name), your site’s country and time zone. Google will automatically create an account name for you based on the URL you entered, but you can override it if you have a preference. Click the Continue button.
On the next page enter your name, phone and country (if different than your Web site.) Click the Continue button.
On the next page you’ll need to agree to the Google Analytics Terms of Service which you’ll probably never read. Agree to the terms and conditions and click the Create New Account button.
Finally! You’ve arrived at the tracking code. Google offers both the “new” and “legacy” tracking code. I can’t imagine why you’d want to go with the legacy tracking code, so select and copy the New Tracking Code.This code goes on the bottom of every Web page you want to track just before the </body> tag. You’ll either want to add it yourself or share it with your Web developer.If you have multiple domains you want to track then you’ll want to generate unique tracking codes for each site. Each domain will need it’s own “profile.” You can create additional Web site profiles by clicking Add New Profile on your Google Analytics landing page.
Step 3: Add Users:
If you’re working with a Web Design or internet marketing company and they need access to your account you can provide it without giving access to your Google account. On your analytics overview page near the bottom you’ll see a User Manager link. Click on it.
On the next page click on Add User.
You can then add the email address of your Web designer or search engine marketer so they can access your reports and continue to help you out. They should be able to provide you with their email (which must be associated with their own Google Account.)
Then choose View Reports Only if you just want to share the reports with them (so they can view them) or Account Administrator (if you want to provide full access to your account.)
Whether you have one or multiple domains you’re running reports on, you’ll need to select them under Available Website Profiles and Add>> them to the Selected Website Profiles. Select all the domains you wish to share and click the Save Changes button.


Your Google Analytic Dashboard is going to give you a high level overview of what is going on with your site.  The GA dashboard gives you a high level snapshot of what’s happening with your website.Here is a few of the things of note that you’ll see on your dashboard:
1)Date Ranges– Defaults to last 30 days; but you can change that and can set up comparison date ranges.2)Main Menu – Quick links to your reports, expandable and present throughout Google Analytic3)Help Resources– Common to all reports – if you forget what you’re looking at these offer some quick reminders as well as help point you in the right direction for how to use the data you’re looking at.4)Overview Graph – Several metrics are offered to choose from and comparison options are available.5)Site Usage Statistics– A high level view of the visitors that came to your site, how many pages they saw, how long they stayed, how many left from the same page they landed on (bounced), and how many had been there before.6)Widgets– Select up to 12 graphical overviews of reports that you’d like to see at a glance.  Move them around, remove them from the dashboard, or add new ones as needed.
Site Metrics:
Metric name
Site Usage
This field identifies the number of single-page visits to your site over the selected dimension. For example, if you apply this metric to the Ad Campaign dimension, it’ll display the number of single-page visits to your site by users that reached your site via a particular ad campaign.
Bounce Rate
Site Usage
The percentage of single-page visits (i.e. visits in which the person left your site from the entrance page).
Site Usage
This field identified the number of times a user has clicked on your Ads.
Site Usage
This field indicates the total number of pageviews for your site when applied over the selected dimension. For example, if you select this metric together with Request URI, it will return the number of page views over the returned result set for the Request URI for your report.
Time on Site
Site Usage
The time a visitor spends on your site.
Site Usage
The number of times your visitors has been to your site (unique sessions initiated by all your visitors). If a user is inactive on your site for 30 minutes or more, any future activity will be attributed to a new session. Users that leave your site and return within 30 minutes will be counted as part of the original session.
Site Usage
A user that visits your site. The initial session by a user during any given date range is considered to be an additional visit and an additional visitor. Any future sessions from the same user during the selected time period are counted as additional visits, but not as additional visitors.


Google Analytics – Report Hierarchy 

Google Analytics has taken the task of getting useful information out of countless bits of raw data and transformed it into a simplified process and user interface.  They do this through a drill-down report interface.  We start out at a 30,000 foot level with the Dashboard view.  You can customize your dashboard with up to 12 report snapshots that can be changed at any time, and get a high level snapshot of what’s happening with your website.
Then the information is separated out a bit in the Overview Reports.  With an overview you are getting more details than what the dashboard offers for the major report categories: Visitors, Traffic Sources, Content, Goals, and Ecommerce 
 Specific ReportsOur specific reports show us the details of the visitors to our sites, where they’re coming from, what they’re looking at,  and the actions they’re taking
Google Analytics Overview
The graph at the top of each report. This is an overview graph of the report you are viewing. The date range of the data will match the range you have set and is plotted with daily data points by default.
Daily Data Points 
But you never have to accept the defaults with Google Analytics.  You have the option to change this to either weekly or monthly data points using the “Graph By” buttons.
Weekly Data Points
Monthly Data Points 
Once you have the date data points just how you like them there are several options for the graphed metric.  
Now you can set up a variety of metrics to be plotted out on the graph.  
Comparing Two Metrics
Google Analytics Goals:
GA is the tool to “improving your site and increasing your marketing ROI.”  And ask any financial guru, knowing ROI is important.  Knowing how to increase it is even better. 
Advertising ROI 
Integrated with AdWords and AdSense
Optimize your AdWords performance with post-click data on your keywords, search queries, match type and more. AdSense reports show publishers which site content generates the most revenue.
Complete campaign tracking capabilities
Track email campaigns, banner ads, offline ads and more.
Ecommerce reporting
Trace transactions to campaigns and keywords, get loyalty and latency metrics, and identify your best revenue sources.
Cross Channel and Multimedia Tracking
Mobile Tracking
Track mobile websites, mobile apps and web-enabled mobile devices, including both high end and non-javascript enabled phones.
Internal Site Search
Understand visitor intent, find out what your customers are really looking for and speed up time to conversion.
Find out whether your site usage metrics under perform or outperform those of your industry. Opt-in benchmarking compares your key metrics against aggregate performance metrics while preserving the confidentiality of your data.
Flash, video and social network application tracking
Track usage of your Ajax, Flash, social networking and Web 2.0 applications.
Customized Reporting
Advanced Segmentation
Isolate and analyze subsets of your traffic. Select from predefined custom segments such as “Paid Traffic” and “Visits with Conversions” or create new custom segments with a flexible, easy-to-use segment builder. Apply segments to current or historical data and compare segment performance side by side in reports.
Custom Reports
Create, save, and edit custom reports that present the information you want to see organized in the way you want to see it. A drag and drop interface lets you select the metrics you want and define multiple levels of sub-reports. Once created, each custom report is available for as long as you want it.
No more digging through reports. Put all the information you need on a custom Dashboard that you can email to others.
API and developer platform
Export data, create integrations, and develop client applications with the Google Analytics Data Export API. Customize Google Analytics tracking with the Google Analytics Tracking API.
Advanced Analysis Tools
Perform advanced data analysis with pivot tables, multiple dimensions and filtering features. Fast-on-the-fly tools let you dig deeper and manipulate data right in the report tables.
Analytics Intelligence
Google Analytics monitors your reports and automatically alerts you of significant changes in data patterns. You can also set up custom alerts to notify you when specific thresholds are reached.
Custom Variables
Custom variables allow you to define multiple, and even simultaneous, tracking segments based on hits, session or visit level data. Custom variables provide you the power and flexibility to customize Google Analytics and collect the unique site data most important to your business.
Data Export
Export your data with the Google Analytics Data Export API or email and export your data directly from the Google Analytics interface into Excel, CSV, PDF and tab delimited files.
Sharing and Communicating
Email reports
Schedule or send ad-hoc personalized report emails that contain exactly the information you want to share.
Sophisticated administrator and user controls
Control how sensitive data is shared and which reports are available to users on your account.
Visualizing Data
Motion Charts
Motion Charts add sophisticated multi-dimensional analysis to most Google Analytics reports. Select metrics for the x-axis, y-axis, bubble size, and bubble color and view how these metrics interact over time. Choose the metrics you want to compare and expose data relationships that would be difficult to see in traditional reports.
Geo Targeting
Identify your most lucrative geographic markets.
Visualize your conversion funnel. Fix leaks by seeing which pages result in lost opportunities and where your would-be customers go.
Spark lines
Thumbnail size graphics save you clicks and summarize the data in your report.
Score cards
See summary metrics in the context of historical or site average data.
Google Integration and Reliability
1st party cookie
Google Analytics has always exclusively used 1st party cookies to ensure reliable tracking and protect visitor privacy.
Google data center and collection methodology
Google Analytics runs on the same globally renowned infrastructure that powers Google, maximizing data integrity and privacy.
Part of a larger family of related Google products
Google Analytics is part of a suite of industry-leading advertising and analysis tools including AdWords and Website Optimizer.
AvatarByRashid Aziz

User profile service configuration in sharepoint 2010

User Profile Service: The User Profile service stores information about users in a central location. Social computing features use this information to facilitate productive interactions which enable users to collaborate efficiently. In order to provision My Site Web sites, enable social computing features such as social tagging and newsfeeds, and create and distribute profiles across multiple sites and farms, you must enable the User Profile service.Here you will find out step by step procedure in setting up the User Profile Service application, focusing on its configuration and administration and how we can enable the creation of user profiles via an Active Directory import. SharePoint 2010 introduces the notion of “Service Applications” which builds upon the “Shared Services Provider (SSP)” which was introduced in SharePoint 2007. Service Application: Service Applications are individual services that can be configured independently and can be shared across other sites within your farm with some service applications that can also be configured across farms. The individual service applications provided with SharePoint 2010 are listed as follows;
  • Access Services
  • Business Data Connectivity
  • Document Conversion
  • Excel Services
  • Managed Metadata Service
  • Performance Point
  • Search Service
  • Secure Store
  • State Service
  • Visio Graphics Service
  • User Profile Service


User Profile Service Setup Before attempting setup up of our first User Profile Service Managed Metadata Service is setup and configured Managed Metadata Service The Managed Metadata service allows you to utilize managed metadata and provides you with the ability to share content types across sites. Setup: To setup our Managed Metadata Service, navigate to Central Administration / Application Management / Manage Service Applications.Click New and select “Managed Metadata Service”

Enter the follow details;

Name: Managed Metadata Service Database Server: <server_name> Database Name: Managed Metadata DB



Now utilize the sp_farm account for the Application Pool Identity. Application Pool Identity:


Click Create. Lastly, navigate to Central Administration / System Settings / Manage services on server and start the Managed Metadata Web Service.


 Now that we have successfully configured our Managed Metadata service we can now focus our attention on the User Profile Service.  The User Profile Service provides our SharePoint farm with all the social networking features that we have come to love in SharePoint 2007, plus more.  It forms the basis of My Site support, User profile pages, Audiences and some of the newer features in SharePoint 2010 social computing such as social tagging. Before we begin, we need to ensure that our Farm account (DOMAIN\sp_farm) is listed as a member of the Local Administrator’s group where the User Profile Synchronization service will be deployed. Let’s now navigate to Central Administration / Application Management / Manage Service Applications. Click New and select “User Profile Service Application”The “Create New User Profile Service Application” window pops up in which you will enter the following details; (you will obviously enter in the details based on your environment setup) Name: User Profiles Create new application pool: SharePoint – User Profiles


Register Managed Account: Register a new managed account: e.g. DOMAIN\sp_userprofiles (nb: this account will need to be provisioned in Active Directory first)


Profile Database : Enter your Profile Database server details and database authentication.  You will notice that SharePoint 2010 introduces the ability to configure Failover Server which allows you to associate your SharePoint databases with another SQL server for failover purposes utilising SQL Server database mirroring.   We will not specify a Failover Database server for any of our databases at this present time.  


Synchronization Database Specify your Synchronization Database which is used to store configuration and staging data for synchronization of profile data such as that from Active Directory.



Social Tagging Database Next, specify your Social Tagging Database which is used to store tags and notes that are created by users.  Social Tagging is a new feature in SharePoint 2010 which is not only displayed against the items that user’s are tagging, but are also displayed in the user’s activity feed.



Next, select your Profile Synchronization Instance Server..Click Create.


We will now venture back into Central Administration / System Settings / Manage services on server.Scroll down to the User Profile Service and User Profile Synchronisation Service and start both.  The User Profile Service should start without any further user interaction, however the User Profile Synchronization Service will ask for your SharePoint Farm credentials.You should now have the User Profiles service application listed and started.



Click Ok. Both services should now be listed as started.

AvatarByRashid Aziz

How to upgrade SharePoint 2007 site to SharePoint 2010

Upgrade SharePoint 2007 Site to SharePoint 2010

There are lot of people out there who are really excited about the SharePoint 2010 release. Today I will be providing you with a guide to upgrading your SharePoint 2007 content databases to SharePoint 2010 using database attach upgrade method.
To complete this operation, you need to complete the following steps

1.       Pre Upgrade Check

This will be our primary analysis and reporting tool  which will provide information regarding your SharePoint 2007 farm and actions that may be required to take prior to upgrading to SharePoint 2010 
Launch a Windows command prompt on your SharePoint 2007 Server and go the the stsadm directory path which is given below.
C:\PROGRAM FILES \COMMON FILES\Microsoft Shared\Web Server Extensions\12\bin
Run the following command
stsadm.exe –o preupgradecheck
When the pre-upgrade process completes, you will receive the following message “Operation completed successfully” .It will then launch your web browser displaying the results in HTML format, titled “SharePoint Products and Technologies Pre-Upgrade Check Report”.  These results can also be located under the following location
C:\PROGRAM FILES \COMMON FILES\Microsoft Shared\Web Server Extensions\12\Logs

2.       Backup database using PowerShell

Below is the PowerShell script to do database backup. You need to change SQL server name, database name and location where you want to save backup file. You can also do database backup using SQL management studio.
$s = New-Object (‘Microsoft.SqlServer.Management.Smo.Server’) “localhost”
$dbBackup = new-object (“Microsoft.SqlServer.Management.Smo.Backup”)
$dbBackup.Database = “WSS_Content_Intranet”
$dbBackup.Devices.AddDevice(“C:\Test\WSS_Content_Intranet.bak”, “File”)
Copy the database backup file to your SharePoint 2010 machine.

3.       Restore database using PowerShell

Below is the PowerShell script to do database restore. You need to change SQL server name, database name and location of the database you want to restore. You can also restore database using SQL management studio.
[System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.SMO’) | out-null
[System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.SMOExtended’) | out-null
$s = New-Object (‘Microsoft.SqlServer.Management.Smo.Server’) “localhost”
$dbRestore = new-object (“Microsoft.SqlServer.Management.Smo.Restore”)
$dbRestore.Database= “WSS_Content_Intranet”
$dbRestore.Devices.AddDevice(“C:\Test\WSS_Content_Intranet.bak”, “File”)
$dbRestore.NoRecovery = $false
$dbRestore.ReplaceDatabase = $true

4.       Create your SharePoint 2010 Web Application and Site Collection

Go to SharePoint 2010 central admin and under “Application Management” click “Manage Web Applications”
Click “New” under “Web Applications” tab
Fill new web application form and click “Ok”
Fill the required fields and click “Ok” to create site collection

5.       Verifying the Content database

The Test-SPContentDatabase is a great reporting tool that will list any missing setup files, web parts and provide you with information on how to remedy any errors.  It will also specify whether these missing features will block the upgrade from succeeding. 
Test-SPContentDatabase –Name <database name> -WebApplication <URL>
Launch the SharePoint 2010 Management Shell and type the above command, ensuring you have entered your Database Name and URL. e.g. below
Test-SPContentDatabase –Name WSS_Content_Intranet -WebApplication http://testsite

6.       Remove Database from Web Application

Ensure that there are currently no databases connected to the web application that we will be attaching to.  You can check this via Central Administration / Application Management / Manage content databases. 
Go to SharePoint 2010 central admin and click “Manage Content Database” under “Application Management”
Select your newly created web application “testsite” and click on the database which is attached to it.
Check “Remove Content database” and click “Ok” to remove content dataset from web application.

7.       Attach database to SharePoint 2010 web Application

We can now proceed and attach our restored SharePoint 2007 database via the following stsadm command line 
stsadm -o addcontentdb -url <URL> -databasename <database name>
In my instance, the command looked as follows;
Stsadm –o addcontentdb –url http://testsite –databasename WSS_Content_Intranet
We can now verify that the upgrade was completed successfully by first navigating back to Central Administration / Application Management / Manage content databases, which now displays the upgraded database under my designated Web Application.
We can also view the upgrade status page which is located within Central Administration / Upgrade and Migration / Check upgrade status.

8.       Visual Upgrade

To perform the Visual upgrade, navigate to Site Actions / Visual Upgrade. You can also user PowerShell script to perform visual upgrade to all sites and sub sites in site collection. Script is given below. You need to change the database in the given script name according to your environment.
$db = Get-SPContentDatabase WSS_Content_Intranet
$db.Sites | Get-SPWeb -limit all | ForEach-Object {
$_.UIversion = 4; $_.UIVersionConfigurationEnabled = $false;
Go to SharePoint 2010 central admin and click “Create Site Collections” under “Application Management”