Announcement for Blog

Dear/Respected All,

I am pleased to announce that my blog is now available at for better features and presentation for users or readers

The primary objective of my blog is to share my experience and notes with all technical persons. It would mean the world to me if you’d stop by my blog at some point.

I really appreciate the response of readers on my blog and I hope the same response will be continuing in future.

This Message/Post can be forwarded to anyone who might be interested.

Varinder Sandhu

MVC- Model–View–Controller

I have attended the training session on MVC with Logiciel at Ludhiana on 3rd May 2011.  It was a good session.

Session Detail:

  • Introduction and Overview
  • Demo Project (Lab)
  • Question/Answer

There is lot of detailed stuff available over the internet. So just sharing you very brief notes…

MVC Pre-requisites

  1. Visual Web Developer 2008 Express Edition SP1
  2. SQL Server 2008 Express Edition
  3. Micorosft.NET Framework 3.5 SP1
  4. Microsoft ASP.NET MVC

MVC can be defined as an architectural pattern that is used while developing interactive application on the web.

Model: The model object knows about all the data that need to be displayed. It only represents the data of an application.

View: The view represents the presentation of the application. The view object refers to the model. It uses the query methods of the model to obtain the contents and renders it.

Controller: It acts as interacting glue between models and views. It accepts input from the user and makes request from the model for the data to produce a new view.

Related Articles :

Migrating from Crystal Reports to SQL Server 2008 Reporting Services

I have attended the Microsoft Webcast topic: “Migrating from Crystal Reports to SQL Server 2008 Reporting Services”

Here sharing with you the Key Points of this Webcast

New Feature in SQL Reporting Services in SQL 2008 R2

Major Enhancement  

  • New Data visualization controls
  • SharePoint Integration change
  • Introduction of Reports Parts
  • New Report Designer
  • New Report Builder
  • Same BIDS Designer for Report Server 2008 and 2008R2 reports
  • Redesigned Report Manager user Interface
  • Extended Protection network authentication settings

Why Migrate from Crystal Reports?

  • High Cost of adding new users
  • High Cost of Upgrading
  • High cost of maintenance fee
  • Performance
  • Exclusive features like unlimited reports within the sub-reports (Crystal Can’t do that)

You can download the archive webcast click here

Useful URL:

Microsoft Test Manager 2010

I have attended the Microsoft webcast topic “Developers and Testers Working Together”

It was really useful tool for tester provided by Microsoft in Visual Studio 2010.

This new feature is known as “Microsoft Test Manager”   so sharing with you very brief information as below:

Visual Studio 2010 introduces a new set of tools and capabilities that enable testers to easily create actionable bugs when a defect is found. The level of data collected and attached to the bug enables developers to quickly take action and locate the root cause of the bug.

For more information you can go to give URL as below:

You can download the archive webcast click here

Soft Skills for IT Professionals

In today’s life we all know soft skills are very important for IT Professionals. I have attended the Microsoft Live webcast topic “Key skills for today’s IT Professionals” on 21st April, 2011

Lot of detailed stuff is available over the internet but here sharing with you the brief key points …

Soft skills are often described by using terms often associated with personality traits, such as:

  • Social Graces
  • Language
  • Personal Habits
  • Optimism
  • Responsibility
  • A Sense of Humor

A person’s soft skill is an important part of their individual contribution to the success of an organization.

Key Soft Skills IT Professionals

  • Email Writing
  • Communication
  • Presentation
  • Planning
  • Time Management

Soft Skills complement Technical Skills or hard skills.

It’s often said that hard skills will get you an interview but you need soft skills to get the job.

SQL Server – Validation of Backup

Database backup are insurance policy for a database, we need to ensure that backups created are valid and useful. To validate the backup, we can use following command

Restore verifyonly from <backup device>

When a backups is validated, SQL Server performs the following steps

  • Calculated a checksum for the backup and compare to checksum stored in the backup files
  • Verify that the header of backup is correctly written and valid
  • Transits the page chain to ensure that all pages are contained in the database and can be located

For more details click here

SQL Server – Policy Based Management

SQL Server 2008 has a new feature called Policy Based Management, also know as Declarative Management Framework (DMF), to tackle the problem of standardizing your SQL server instance. Although Policy Based Management can be used just to alert an administrator when an object is out of compliance, depending upon the type of policy, you can also enforce compliance by preventing changes that would violate a policy.

Policy Based Management introduces the following new objects that are used to design and check for compliance:

  • Facts
  • Conditions
  • Policies
  • Policy Targets
  • Policy Categories

For more information click here