Microsoft Technology: November 2009

Friday, November 27, 2009

The Evolution of Visual Basic

Visual Basic 1 – Visual Basic 3:

Made Windows programming accessible
Helped make Windows the premier platform in the world

Visual Basic 4 – Visual Basic 6:

Made targeting COM and OLE approachable for most developers

Visual Basic 7 – Visual Basic 9:

Bringing the "ease of use" to the .NET platform
Helped establish the CLR as the premier managed runtime in the world

Visual Basic 10:

Continuing this trend to make it easy to use and leverage the platform

The Evolution of C#

C# 1.0:

With the launch of the C# language, it was a major shift we took to a full managed environment. This was a big step for programming languages at Microsoft.

C# 2.0:

With the second release of C# we introduced fully reified Generics into the language. This was a very powerful addition to the type system.

C# 3.0:

C# 3.0 introduced LINQ which we talked about previously

C# 4.0:

Not just “dynamic” as in late-binding, but those features that allow the compiler to “get out of the developer’s way”.

Thursday, November 26, 2009

Visual Studio 2010 - Highlighting References

This is another enhanced feature of visual studio 2010 Editor, the new feature is Highlighting References.

When you click on the identifier in the code window, immediately all instances of that identifier will automatically highlighted in the document.

For Example, See the exhibit, here I clicked on the variable, "iTotal" then all the references of the "iTotal" is highlighting as shown in the display.

In this screenshot, I marked two identifiers in red color box. It is also having same identifier name "iTotal". But it is not highlighting, because it is belongs to different reference. Highlighting feature works well.

You can navigate all the highlighted references by just pressing SHIFT+CTRL + UP ARROW or Down Arrow

These highlighting features will only works on identifier or any user defined methods, not any internal keywords.

Visual Studio 2010 - Zoom Text Editor

This is an enhanced editor feature in Visual Studio 2010. You can Zoom the text content in Visual studio IDE. This feature already integrated with all Microsoft products, but in Visual Studio, it is introduced in VS 2010 version only.

In Visual Studio 2010 code editor window, you can quickly Zoom in or Zoom out by pressing and holding the CTRL key and Scroll Mouse Wheel.

Also you can zoom the textual tool windows of VS 2010 IDE, for example, the Output window.

Note: The zoom feature does not work on any design surfaces, designer windows that contain icons, for example, the Toolbox or Solution Explorer.

See the Exhibit Of sample of this new feature:

Wednesday, November 25, 2009

Introduction to Asp.net 3.5 using VS 2008

Note: Please Wait Till Loading the Presentation File. It will Be Visible thru on Blog Site

Asp.Net Mvc Design Pattern

Note: Please Wait Till Loading the Presentation File. It will Be Visible thru on Blog Site

Overview of Visual Studio Team System 2010

Note: Please Wait Till Loading the Presentation File. It will Be Visible thru on Blog Site

New Features in VS 2010 - IntelliSense suggestion Mode

In Visual Studio (VS) 2010 is come up with new features in IntelliSense.

Visual Studio 2010 provides two alternatives for IntelliSense statement completion.

They are

1. completion mode

2. Suggestion mode.

In prior version of Visual Studio’s IntelliSense search only the sequential character, in VS 2010, IntelliSense search the character in the Members from IntelliSense List.

You can toggle the mode by using CTRL+ALT+SPACEBAR

Completion Mode:

Suggestion Mode:

Note: Use Capital Case to search. For Example, use RL to search ReadLine

Some More Example of IntelliSense:

Here IntelliSense listing the members based on the character cu

This IntelliSense listing the members based on the character RL

This IntelliSense listing the members based on the character SW

Tuesday, November 24, 2009

Uninstall SQL Server 2005 - Manual Process

Here are the steps to uninstall SQL Server 2005 components manually.

In Add or Remove Programs, uninstall all SQL Server 2005 components in the following order:

• SQL Server 2005

• SQL Server 2005 Analysis Services

• SQL Server 2005 Reporting Services

• SQL Server 2005 Notification Services

• SQL Server 2005 Integration Services

• SQL Server 2005 Tools

• SQL Server 2005 Books Online

• MSXML 6.0 Parser

• SQLXML4

• SQL Server VSS Writer

• SQL Server 2005 Backward Compatibility

• Anything else that is related to SQL Server 2005

• SQL Server Native Client

• SQL Server setup support files

After uninstalled all the components listed above, Download and then install the Windows Installer Cleanup Utility

Run Windows Installer Cleanup Utility, Select the components related to SQL, and then click Remove. You can select multiple components by using CTRL key.

if you Remove button, it will throw warning message then click ok to accept

Hope it Helps!

How to Execute SQL Queries thru SQLCMD

You can execute the all kind of SQL Expression thru command prompt. Here I explained simple example

1. Open Command Prompt

2. Enter SQLCMD –S "SQL SERVER INSTANCE NAME" -D "DATABASE NAME"
3. once you enter above line, it will connect to the database by using windows authentication
4. then write a query, press enter

5. terminate the query with GO statement, press Enter
6. It will display the records as shown below.

To Terminate from SQL, Type Exit, then press Enter

Monday, November 23, 2009

Select Distinct Record thru SSIS without using SQL Query

In SQL Server Integration services (SSIS), we can retrieve the distinct records from table without using SQL Query.

SSIS provided a Data Flow component, which is known as "Sort", helps to implement this operation.

The main purpose of this sort components are

1. Sorting Record (Order By operation in SQL) - Ascending and descending

2. Removing duplicate record (Distinct Operation in SQL)

Here I explained "distinct" operation in SSIS by simple example.

1. Place "Data Flow Task" in "Control Flow" Designer Page of SSIS

2. Double Click on this Control, it will take you to Data Flow Tab Page in Designer

3. Place some source control, configure with Data source and table on which you want to filter distinct data (unique). here I used OLE DB Source Editor, and configured with Sales.SalesOrderHeader Table from "Adventure Works2008" Database

4. I planned to retrieve distinct customer ID from this table. I placed Sort control and make an input from source control. Configure "Sort" as shown below.

5. check "Remove rows with duplicate sort rows", click Ok

6. Use some destination component and configure it. Here I used Data Reader Destination which will load on memory

7. Now if you execute this package, it will return unique data with ascending order.

Total Records: 31,465 rows

Distinct Records: 19,119 rows

Friday, November 20, 2009

Enable FileStream in SQL Server 2008

Problem:

Today I tried to install Sample database of "Adventure works 2008" in my system, then it throws the error like…

"AdventureWorks2008 OLTP requires FILESTREAM which is not enabled for the instance you selected. FILESTREAM must be enabled BOTH via the Sql Server configuration Manager and via Management Studio for this instance."

Solution:

This Error Message itself provides the solution for the problem. We have to enable FILESTREAM in two locations. One is SQL Server Configuration Manager and other location via SQL Server Management Studio (SSMS). Here I explained that "how and where we have to enable the FILESTREAM"

SQL Server Configuration Manager:

Go To Start --> Programs --> Microsoft SQL Server 2008 --> Configuration Tools --> SQL Server Configuration Manager

Right Click on the SQL Server Services Instance, Then Select Properties
Go To FILESTREAM Tab
Check Enable FileStream, as shown in the Exhibit

Click Apply
Restart SQL Server Services

SQL Server Management Studio (SSMS):

Right Click on the SQL Server Database, Select Property

In Advanced Section, Select FileStream Access Level to "Full Access Enabled"

Select Ok
Restart SQL Server Services again

After Enabled FileStream in the given two locations, I continued my installation, it is installed well.

Microsoft SQL Server 2008 Books Online (July 2009)

SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008.

Books Online includes the following types of information:

Setup and upgrade instructions.

Information about new features and backward compatibility.

Conceptual descriptions of the technologies and features in SQL Server 2008.

Procedural topics describing how to use the various features in SQL Server 2008.

Tutorials that guide you through common tasks.

Reference documentation for the graphical tools, command prompt utilities, programming languages, and application programming interfaces (APIs) that are supported by SQL Server 2008.

Descriptions of the sample databases and applications that are available with SQL Server 2008. You can download the sample databases from the SQL Server Community Projects and Samples page on CodePlex.

NOTE: Non-English installs of Books Online may encounter minor issues. To address these issues try rerunning the installation.

Download SQLServer2008_BOLOct2009.msi

Tuesday, November 17, 2009

ASP.NET MVC 2 Beta

ASP.NET MVC 2 Beta provides a new Model-View-Controller (MVC) framework on top of the existing ASP.NET 3.5 SP1 runtime.

ASP.NET MVC 2 is a framework for developing highly testable and maintainable Web applications by leveraging the Model-View-Controller (MVC) pattern. The framework encourages developers to maintain a clear separation of concerns among the responsibilities of the application – the UI logic using the view, user-input handling using the controller, and the domain logic using the model. ASP.NET MVC applications are easily testable using techniques such as test-driven development (TDD).

The installation package includes templates and tools for Visual Studio 2008 SP 1 to increase productivity when writing ASP.NET MVC applications. For example, the Add View dialog box takes advantage of customizable code generation (T4) templates to generate a view based on a model object. The default project template allows the developer to automatically hook up a unit-test project that is associated with the ASP.NET MVC application.

Because the ASP.NET MVC framework is built on ASP.NET 3.5 SP 1, developers can take advantage of existing ASP.NET features like authentication and authorization, profile settings, localization, and so on.

Download AspNetMVC2_Beta_VS2008.exe and ASP.NET-MVC-2-Beta-Release-Notes.doc

Friday, November 13, 2009

Microsoft SQL Server 2008 R2 November CTP

Building on the trusted, productive, and intelligent data platform delivered with SQL Server® 2008, The Microsoft® SQL Server® 2008 R2 November Community Technology Preview (CTP) provides a wealth of new improvements that will help your organization scale with confidence, improve IT efficiency, and enable managed self-service BI. This CTP release includes new and enhanced capabilities for application and multi-server management, complex event processing, master data services, and end user reporting. Also introduced is PowerPivot for Microsoft® Excel (previously known as project “Gemini’) to empower users to easily access, integrate, analyze and share information using Microsoft® Office tools they are already familiar with.

Key features in this CTP release include:

A new Control Point Explorer for central multi-instance and application utilization management.
Built-in wizards to help you quickly set up and enroll instances and Data-Tier Application components into central management.
Dashboard viewpoints for quick insight into application and instance utilization.
Report Builder 3.0
PowerPivot for Microsoft® Excel
Master Data Services
StreamInsight core technology engine.

To read what is new in SQL Server® 2008 R2 November Community Technology Preview click here.

Note:

1 ) Some components in the Microsoft® SQL Server® 2008 R2 November Community Technology Preview have certain Internet-enabled features, including the Customer Experience Improvement Program and Error and Usage Reporting component, enabled by default to help us identify and address issues that you may encounter while using SQL Server®. For more information and instructions on how to disable these features, see the SQL Server® Privacy Statement.

2 ) Some components in the Microsoft® SQL Server® 2008 R2 November Community Technology Preview have two different methods to complete the installation process:

Attended Installation – an interactive user interface will guide you through the set-up process and obtain all of the information and consent required to complete the installation. This includes the displaying, acknowledgement, and archiving of the applicable SQL Server license terms.

Un-attend Installation – this is a DOS command Line set-up process that does not have an interactive user interface to guide you through the set-up process. In this case, you will be required to enter a parameter during installation that indicates your acceptance of the license terms.

Here is the copy of the Microsoft® SQL Server® 2008 R2 November CTP license terms for your review.

Download Files

Microsoft .NET Services SDK (Nov 2009 CTP)

Microsoft .NET Services is part of the Azure Services Platform. Microsoft .NET Services includes two services: the Access Control Service and the Service Bus.

This SDK includes API libraries and samples for building connected applications with the .NET platform. It spans the entire spectrum of today’s Internet applications – from rich connected applications with advanced connectivity requirements to Web-style applications that use simple protocols such as HTTP to communicate with the broadest possible range of clients.

Download SDK

MSMQ Activation for WCF Workflow Service Application

This article describes how to set up MSMQ activation for WCF Workflow Service Application hosted in Windows Activation Service (WAS).

In .NET Framework 4 and Visual Studio 2010, you can build pure Windows Communication Foundation (WCF) services, pure Workflow Foundation (WF) applications, or a workflow service, which is a workflow application exposed as a WCF service. The out-of-box messaging activities, e.g. Send and Receive activities, come with implicit WCF endpoints, which can be employed for external communication to the workflow, including WCF activation of the workflow instance when the first message arrives. A workflow service, like any application with a communication component, can benefit from the advantages of queuing technologies. Adding a queue element to application design can improve robustness. The queue can also provide load-balancing support and improve scalability.

Download HowToSetUpMSMQActivation.docx

Thursday, November 12, 2009

No template information found - Visual Studio tools for Application (VSTA)

Problem:

Today I tried to create new project in “Visual Studio tools for Application” (VSTA IDE).

But it throws the following Error

"No template information found. See the application log in Event Viewer for more details. To open Event Viewer, click Start, click Control Panel, double-click Administrative Tools, and then double-click Event Viewer."

After close this error message, project template window displays empty as shown here

Solution:

1. Find the VSTA.EXE in your drive

2. open command prompt (CMD.EXE)

3. set the location VSTA.EXE in command prompt

4. run VSTA /setup

Note: before run this close your application then try.

/Setup Extracts the project templates for the host application and initializes the host-specific environment for the current user. This switch requires administrator privileges.

If not works,

First run VSTA /ResetSettings Then run VSTA /setup

After run this command, if you create new project, it will displays the following template window.

Hope it helps!

Wednesday, November 11, 2009

SSIS : Registry Location Of Data Source

Whenever you create a data sources in Visual studio IDE of SSIS, it will be stored in registry and it can be re used for other projects as well.

This will be available to the user login, who created it.

Data Source Manager in SSIS Designer

In the following Registry Locations, all the data sources are storing:

Registry Location:

HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\Packages\{SomeGUID}\Settings\Data\Connections

How to create Data source is SSIS?

Before I explain, how to create Data source is SSIS?

We need to know the following:

What is Data Source?
What is the use of it?

A data source is a connection reference to the database, Database may be anything like SQL, Oracle, DB2, Excel, MS Access, etc.,

A data source contains the credentials of the database, which you want to access. By using this data source, we can access all the database objects like Tables, views, stored procedures, etc., Also we can perform all the database activities like creating and modifying DB objects.

I hope you understood about Data source and its usage. Now you can create the Data Source by the following way: