Microsoft Certifications

Hi

Just wanted to share good news with you...

Now you can get 10% on Microsoft Certifications...

Certification Promotion Code: "IN7DE629"

Just use this promotion code and get 10% off, there is no limit on this... Discount Voucher Code to receive a 10% discount off an applicable Microsoft Certification exam until March 31, 2009.

Discount Voucher can be utilized to sit for any of the New Generation of Certifications i.e. Microsoft Certified Technical Specialist (MCTS), Microsoft Certified IT Professional (MCITP) and Microsoft Certified Professional Developer (MCPD) exams until May 31, 2009.

If an exam candidate fails an exam on his/her first attempt, they can use the same Discount Voucher Code to retake the same exam for free.

All retake exams must be completed by May 31, 2009 and are subject to compliance with Microsoft Certification Exam Retake Rules.

Not valid for 072-series exam.

code analysis for C#

StyleCop is a free static code analysis tool from Microsoft that checks C# code for conformance to StyleCop's recommended coding styles and a subset of Microsoft's .NET Framework Design Guidelines. StyleCop analyzes the source code, allowing it to enforce a different set of rules from FxCop. The rules are classified into the following categories:

Documentation
Layout
Maintainability
Naming
Ordering
Readability
Spacing
StyleCop includes both GUI and command line versions of the tool.

Code Analysis in .Net

FxCop is a free static code analysis tool from Microsoft that checks .NET managed code assemblies for conformance to Microsoft's .NET Framework Design Guidelines. Unlike the Lint programming tool for the C programming language, FxCop analyzes the compiled object code, not the original source code. It uses MSIL parsing, and callgraph analysis to inspect assemblies for more than 200 defects in the following areas:

Correctness
Library design
Localization
Naming conventions
Performance
Security
FxCop includes both GUI and command line versions of the tool. Microsoft Visual Studio 2005 and Visual Studio 2008 Team System Development Editions both include a "Code Analysis" feature based on FxCop.

differences strored procedures and triggers

Stored Procedure:

A stored procedure can be created with no parameters, IN parameters, OUT parameters. There can be many parameters per stored procedure.

One has to manually call this Object to do some actions.

Trigger:

It is a fragment of code that tells Database to fire or run BEFORE or AFTER a table is modified.

It has the power to make sure that a column is filled in with default information make sure that an audit row is inserted into another table after finding that the new information is inconsistent with other stuff in the database.

Cursors in SQL Server

SQL Server is very good at handling sets of data. For example, you can use a single UPDATE statement to update many rows of data. There are times when you want to loop through a series of rows a perform processing for each row. In this case you can use a cursor.

cursors are the SLOWEST way to access data inside SQL Server. The should only be used when you truly need to access one row at a time. The only reason I can think of for that is to call a stored procedure on each row.

cursors are over thirty times slower than normal SQL queries.

Reference : http://www.sqlteam.com/article/cursors-an-overview

differences between primarykey and uniquekey

One of the basic question in any interviews is What is the difference between primary key and unique key?

Just give the below ponts, he/she will be very happy with the answers.

The Major differences between Primary Key and Unique Key are:

1) Primary Key doesn't allow null values, But Unique key does all nulls(Only One per key).

2) You can have No.Of Unique Keys on a single table, but you can have atmost only one primary key.

3) Primary Keys are used to define Referential Integrity Constraints.