My experiments with Microsoft Technologies

Visual Studio 2010 Tips and Tricks # 5 : Block Editing, Multi-line Coding

noreply@blogger.com (Prashant Danda - http://freshant.com) — Sat, 26 Mar 2011 23:09:00 +0000

This is one of my favorite tricks in VS 2010 IDE. This one is more cool than my previous post [Visual Studio 2010 Tips and Tricks #4: Code Snippets ]
Did you know you can select any vertical area of your code by using “ALT” key and your “Mouse” in the Code area inside the editor.
Say we need to create Model class with lots of string variables and “Get”, “Set”. You can follow the tip#4 and use prop code snippet (or) you can use this Block Editing tip.

First select a vertical region of your code by pressing the “Alt” key and selecting a vertical line as shown above.

Start typing “public string” and see it fills in all the lines not just one line (as shown above).

Now press “Esc” to go out of this mode and start typing your Member names

Now again vertical select a region by pressing “Alt” key and use your mouse.

And enter “{ get; set; }” and your properties are done.

Yes but it looks ugly with lot of spaces in between, so use my previous tip [ Tip to autoformat code ] and select these lines and press “Ctrl + E + Ctrl F” to tidy up the code.

When there are lot of similar lines this approach is very helpful to code faster.
Say you want to convert all the properties from “public” to “internal”, this can be done very easily using our “Block” editing trick.
First use “ALT” key and select all the public word in all the lines.

Now start typing “internal” and you just renamed multiple lines. You may ask why not use “Quick Replace” but this is very helpful if you only want to apply the changes to only few lines and not the entire document.

This approach is very useful in situations say to enter comments for all lines, say to prefix “M_” or “_” to convert local variables to global etc..

Deployment is currently disabled

noreply@blogger.com (Prashant Danda - http://freshant.com) — Sat, 26 Mar 2011 21:17:00 +0000

So you write a new MS Test Unit test and you try to run the test and you get a “Deployment is currently disabled” error? So how to fix this.
This happens if your unit test is referring a method which has a deployment Item (say whether it is a test file or a referred dll), in your code you would see [DeploymentItem(pathtofile)] Annotation.
This is a very simple fix.
Try to find out which “.testsettings” file is currently in use, by default it is the “Local.testsettings”, double click on it to open the “Test Settings” popup window, in that window click on “Deployment” Item in the left to see the “Deployment” settings screen as shown below.
Check the checkbox which says "[*] Enable deployment” and try to save the file and try running your test again and it should work.

Visual Studio 2010 Tips and Tricks # 4 : Code Snippets

noreply@blogger.com (Prashant Danda - http://freshant.com) — Thu, 24 Mar 2011 04:19:00 +0000

This is not a new feature, Code Snippets did exist in previous versions of Visual Studio.
Let us look at what are code snippets and how to use them.
Trust me they are very helpful for rapid application development.
Assume you are creating a class with member variables and basic getter, setter methods. Now you can sit and write the entire line for each member variable (or) you can make it rapid by following the steps shown below,
If you right click on your project and select “Add –> New Class –> enter class name”, it creates the class stub.
Now go in to the class and type “prop”

A drop-down gets shown select “prop” and hit tab twice (tab-tab)
It will auto-fill the default datatype “int” and puts the “Get/Set” for you.

Now if you want to change the datatype, click on “tab” and enter say “DateTime” on top of “int”.
And click another “tab” and type in your property name and that’s it you just wrote one member variable so fast

Now having enjoyed rapid authoring, you may be wondering is there more auto-fill’s for most common syntax/structures.
Yes there is, for example, say you want to enter try catch. Just enter try and the dropdown shows available snippets,

Select “try” and hit tab-tab

Cool right you just saved yourself time entering the braces and aligning them etc..
Yes, so your next question is how do I know what all snippets are there, it is very easy,
Just right click on your code, select “Insert Snippet” or use short cut key “CTRL + K AND CTRL + X” to show the “Insert snippet” option.
Select the folder, say “Visual C#” and see all available snippet options, as shown below,

Use lot of snippets while you are coding and increase your coding productivity.
Become a “Ninja Coder”
Stay tuned for my post about “how to create custom snippets”.

Visual Studio 2010 Tips and Tricks # 3 : View Call Hierarchy

noreply@blogger.com (Prashant Danda - http://freshant.com) — Thu, 24 Mar 2011 03:25:00 +0000

One of the features I like the most with VS 2010 that I use daily is the “Call Hierarchy”.
Say you are in a method and you want to know what all methods “Call In” to your method, then this is the most easiest way to do it.
Just click on your method and use shortcut key (CTRL + K and CTRL+T) and the call hierarchy window will be shown, or just right-click and select “View Call Hierarchy”.
You can keep drilling down.
Another nice feature is the “Call Sites” window which is on the Right hand side of the “Call Hierarchy” window. It shows the entire line where the method is called and also gives the file name and the line number. Double click on the row and it takes you to the file.
VS 2010 is one of the best IDE’s out there, make full use of it

Visual Studio 2010 Tips and Tricks # 2 : Resolve Namespaces

noreply@blogger.com (Prashant Danda - http://freshant.com) — Thu, 17 Mar 2011 03:44:00 +0000

With Visual Studio 2010 there is a new feature available called “Resolve”.
Using “Resolve”, you can automatically add using statements to a class.
Shortcut key to invoke this is => Press Ctrl key and “.” key and automatically the namespace will be added.
Shown below in this picture, when we enter “DataSet” and if we press “Ctrl” and “.” keys it automatically shows all the namespaces which have the “Data Set” class.

We can move up and down using arrow keys to select the right namespace and then if we click enter, that using statement is automatically added to our using section at the top – “How cool !”

Follow my blog for more tips and tricks like this

Visual Studio 2010 Tips and Tricks # 1 : Navigate To

noreply@blogger.com (Prashant Danda - http://freshant.com) — Thu, 17 Mar 2011 02:23:00 +0000

With Visual Studio 2010 there is a new feature available called “Navigate To”.
Using “Navigate to”, you can search for a file name (or) object name (or) method name in your entire solution.
Shortcut key to invoke this is => Press Ctrl key and “,” key to bring up the dialog (like shown below), then start typing your search term and it will auto-fill.

In the above picture we can see that it lists filenames that start with “Default” like “Default.aspx” & their entire path location as well as it shows all the classes which have “Default” in their name like example “_default” and also it shows all properties “UseDefaultCredentials”.
Also if we click on the search result row, it shows the exact file name and the line number.
This is very useful to search in solutions which have lots of projects and files.
If you are lazy to type, click on the text and press “Ctrl” and “,” key and it even auto-fills the search text. (like shown below in this image).

Follow my blog to see more tips and tricks, coming soon.

Technorati Tags: VisualStudio2010,Tips,Tricks

Internal test

noreply@blogger.com (Prashant Danda - http://freshant.com) — Fri, 17 Dec 2010 17:51:00 +0000

This is an internal test

Microsoft Application Architecture – Demystified….

noreply@blogger.com (Prashant Danda - http://freshant.com) — Sat, 20 Mar 2010 17:17:00 +0000

We can learn syntax by reading a book but how does someone learn good practices & solid architecture and design.

The question is answered, there is a very good bible I would say of architecture which Microsoft has released and it is a pdf file that can be download for free (good things in life are always free !!!) from this url given below,

http://www.codeplex.com/AppArchGuide

Download PDF here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=ce40e4e1-9838-4c89-a197-a373b2a60df2&displaylang=en

This book is awesome, it covers most of the jargons, the approaches, the design patterns to use in different layers.

This book explains the following,

Domain driven design,
Layered architecture,
Service – Oriented architecture,
Rich Client application design,
Rich Internet Application (RIA) design,
Presentation / Service / Business / Data Layer Guidelines,
Talks about REST – Representational State Transfer
Talks about workflow, messaging & cloud.

This is really an awesome book, a must read for any developer.

Autodiagrammer – Visual Studio Class Diagram generation tool

noreply@blogger.com (Prashant Danda - http://freshant.com) — Sat, 27 Feb 2010 19:28:00 +0000

For one of my projects I was trying to use the Visual Studio Class diagram to quickly generate class diagram to understand the existing design. The VS IDE kept giving errors on not being able to generate class diagram. So I was searching for a 3rd party Free class diagram generating tool and found “Autodiagrammer”.

Sacha Barber has done an excellent job coding this tool, it uses reflection and hence you can run this on compiled dot net projects and it will generate a beautiful class diagram and even align it for you.

You can download it from Code project here

Ubuntu – Linux for Human Beings !!!

noreply@blogger.com (Prashant Danda - http://freshant.com) — Sat, 27 Feb 2010 18:12:00 +0000

I wanted an OS where I can download files from the net without the worries of malware or virus and I came upon “Ubuntu”. They had a very nice caption - “Linux for Human Beings”.

I have prior experience working in Caldera Open Linux & Red Hat, but somehow I got drifted & now landed on Microsoft world. I have seen my peers type very fast on terminal shell or on vi editor (especially kicha & deepak) and always wondered how they can keep staring at a black and white console without any graphics for the entire day. But distributions have changed a lot, no need to mount/unmount devices, it has become like windows (plug & play) and Ubuntu really rocks, it has the similarity to its windows counterparts and at the same time provides the security of a linux distribution.

Definitely give it a try.

You can download Ubuntu from here Downbload Ubuntu 9.10
Also there is “Google Chrome” , “Transmission Bit Torrent Client” and lots of applications.
And entire thing runs great even on just 512 MB Ram on my VM.
What more can one ask for !!!!

unrecognized tag prefix or device filter ‘asp’

noreply@blogger.com (Prashant Danda - http://freshant.com) — Sat, 07 Mar 2009 11:03:00 +0000

You have possibly landed on my blog because you got this error when you were trying to compile your project in Visual studio 2005 and are going mad trying to find a solution. So was I :)

You would be getting this error if you had used Master Pages in your project.

That is open your masterpagename.master markup and you would see that under the <head> tag or where ever you had used <asp:contentplaceholder > tags you will notice that the “asp” is underlined in red and the error you get in your Error list is

“Unrecognized tag prefix or device filter ‘asp’”.

The solution is simple, close all the currently open pages in visual studio , how to do that easily would be click on any one open page and right click on the file name example “Default.aspx.cs” and say “Close all but this” and then close the current file too (right click close)

Then search your PageMaster.master and open it in IDE (either design or source view) and try to compile now.

If you have nested master pages try to open all those and compile, it should compile easily without errors.

This may sound stupid but that is how it works !!!!!

Sharepoint developer

noreply@blogger.com (Prashant Danda - http://freshant.com) — Mon, 30 Jun 2008 02:20:00 +0000

What i really liked about microsoft technologies is the availability of learning material, forum help, technical support, including videos, how-to's etc which is relatively less for other technologies.

Microsoft should really be appreciated in the extent of materials they provide for developers to learn their technologies.

What if you do not have the required infrastructure or software or licenses to install their stuff to learn - dont worry they have online hands on labs, all you need is a internet connection, and you can join a lab and login to a virtual server and you can configure and learn their stuff (only thing is you need a big monitor like i have at home, as once you are in a test lab, there are test instructions to read as well as to see the server desktop so it is kind of tough to do on a normal monitor).

I recently came across this excellent site which provides all the necessary material for a share point developer.

http://www.microsoft.com/click/SharePointDeveloper/

It has quick start papers, hands on labs and web casts to learn developing using sharepoint.

Review of the uCertify training material for 70-300 Exam

noreply@blogger.com (Prashant Danda - http://freshant.com) — Mon, 30 Jun 2008 02:11:00 +0000

70-300 exam is the Microsoft exam for Analyzing Requirements and Defining Solution Architectures.
Recently i was requested to review uCertify training material and here i am presenting my feedback.
This exam unlike other microsoft exams deals with the entire lifecycle of a project, the key exam objectives include right from the feasibility of the project, through design, requirements specification and elaboration and continues with the process definition and maintenance.
If a person had already passed a microsoft exam one can easily understand that nowadays we need practical experience to pass the exam as microsoft has introduced lot of simulation and practical scenario based questions which cannot be cleared if one tries to
memorize or to study question banks. So one needs a proper blend of practical as well as theoretical knowledge to clear these exams.
At the same time practical experience alone is not enough and we do need to brush up some basics through study material, where kits like
ucertify come to help.
I am presenting here what i liked about this product.

Learn Exam Objectives along with Study Notes

Main thing one needs to understand to pass MCP exams is we need to clearly understand the skills measured by the exam or the key objectives which are generally presented as topics and sub-topics in the preparation guides.
Example:-
Envisioning the Solution >> Develop a solution concept>> Analyze the feasibility of the solution. Most training material i had seen do not link material to key objectivies, ucertify did a pretty good job in this, as soon as you launch their tool, from their menu we can access the Exam Objectives via Notes >> Exam Objectives.
What is still better is we can read study notes linked to exam objectives, by clicking on the objectives with notes menu. So now we have all the study notes per topic or sub-topic linked to the exam objectives which is very helpful when you want to revise the topics before appearing.
Also the kit has a very good printing option, so that we can print and read the material.

Study Tips:

The study tips are really useful, which list the pre-requisities for the exam, skills needed, what to practice and how to face the test, which are all inside the kit under the articles section. The articles section had very less articles and I felt for an exam of this nature the kit should have given more articles.

Flash Cards:

Flash cards is a very good way of remembering key points while learning. I really like the flash card concept in the kit. 135 Flash card questions were present.

Test questions:

The kit had diagnostic tests as well as practice tests. We can also create our own type of tests by selecting X questions from a pool of Y questions.
Also the kit has option to test to see if there is a new version of material available on their site and if so we can download the update from their site.

Overall the kit from uCertify is really helpful to jump start ones preparation for the 70-300 exam and i would recommend it to any one planning to clear the exam.

Here is their website if you are looking for obtaining training material.

http://www.ucertify.com/

Codeplex - Microsoft's answer for open source

noreply@blogger.com (Prashant Danda - http://freshant.com) — Thu, 24 May 2007 05:43:00 +0000

I was amazed to see the list of open source microsoft projects available at code plex.

Some of the popular ones which we have been using like the Atlas and the Ajax extension sample controls are all from codeplex.

"CodePlex is Microsoft's open source project hosting web site. You can use CodePlex to create new projects to share with the world, join others who have already started their own projects, or use the applications on this site and provide feedback"

http://www.codeplex.com/CodePlex

The license details are provided here,

http://www.codeplex.com/CodePlex/Project/License.aspx

Few projects which are very impressive are,

1) BlogEngine.Net - your own dot net blog engine

2) Scorm 2004 implementation for dot net

3) Sharepoint utilities

4) Sandcastle help file builder - for VS2005 IDE (very helpful)

5) Same Desk - brings desktop on the web (unlike silverlight i did not have to install anything to see those applications very impressive) snapshot attached below.

On SameDesk i open a calculator, was able to browse this blog and also search something on the map on the left hand side and the web page looks exactly like a desktop and the app looks like a windows application. :)

you can try this out here live - http://www.openspot.com/

Some implementations given above would take several months if teams were to start coding them from scratch and some i could not believe if it may be completed, but code plex gives the entire source code free.

Every dot net developer should check codeplex without fail.

Also there are server enterprise patterns & implementations.

Sql Server 2008 Code named Katmai

noreply@blogger.com (Prashant Danda - http://freshant.com) — Wed, 23 May 2007 04:08:00 +0000

Sql Server 7.0 followed by Sql Server 2000 followed by Sql Server 2005 and the next release is Sql Server 2008 or code name "Katmai".

If you have been working on Sql Server 2005 you will understand how robust it is and the set of all new features it has compared to 2000, the next release katmai is adding on to sql 2005.

The good news is, it is adding to Sql 2005 and not like totally replacing it. Thank god or we got to learn a whole new set of stuff again :(

"Microsoft officials listed a number of overarching goals for SQL Server "Katmai" such as tighter integration with the 2007 Microsoft Office system. In addition, the release will make good on the parting pledge of Paul Flessner, former Microsoft senior vice president of the Data Storage and Platform Division, to go beyond relational data. SQL Server "Katmai" will enable users to manage any data type, including relational data, documents, geographic information and XML, company officials said.

In addition, the new version of the data management and analysis platform provides an integrated development environment with Microsoft Visual Studio and .NET Framework that will accelerate development of new applications with an increased level of data abstraction as well as permit developers to synchronize data from virtually any device into the central data store, company officials said. "

If you are interested to know more about katmai read about it here,
http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx

Importance is being given to BI and integration with office 2007 and .Net 3.0

May be Microsoft should take it a little bit slower, they are too rapid. We are still riding on top of your car and if you go so fast we may take a deadly fall.

I know a lot of clients still use Sql Server 2000 and are still worried about even upgrading to Sql Server 2005.

Sql Server 2000 - Incorrect syntax near the keyword 'IDENTITY'

noreply@blogger.com (Prashant Danda - http://freshant.com) — Mon, 21 May 2007 16:35:00 +0000

Incorrect syntax near the keyword 'IDENTITY'

Let us say there is a table in sql server 2000 which does not have a identity key, you inspect it manually and find out that there is a column which is unique and you can make it in to an identity column and decide to go and open your Query analyzer and try to do an alter table add identity something like this,

ALTER TABLE [dbo].[projects] ALTER COLUMN [id] IDENTITY(100, 1) Not Null

Here i want the seed to start at 100 and increment by 1 since i got 99 rows already with proper ids.

But this would not run properly, we will get an error something like,
Incorrect syntax near the keyword 'IDENTITY'

There is no problem in the syntax the issue is sql 2000 cannot add an identity just like that to an column since there is lot of other background work that needs to be done.

So it is not possible to do it via single T-Sql statement.

But you can add the entire identity via enterprise manager very easily,

Just right click on the table >> design table >> click on the id column >> make identity = yes in the columns property area below and then set the identity seed (starting value) and the identity increment.

When you do this, this is what enterprise manager does in the background,


BEGIN TRANSACTION

SET QUOTED_IDENTIFIER ON

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

SET ARITHABORT ON

SET NUMERIC_ROUNDABORT OFF

SET CONCAT_NULL_YIELDS_NULL ON

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET ANSI_WARNINGS ON

COMMIT

BEGIN TRANSACTION

CREATE TABLE dbo.Tmp_projects

(

id int NOT NULL IDENTITY (101, 1),

name varchar(50) NULL

) ON [PRIMARY]

GO

SET IDENTITY_INSERT dbo.Tmp_projects ON

GO

IF EXISTS(SELECT * FROM dbo.projects)

EXEC('INSERT INTO dbo.Tmp_projects (id, name)

SELECT id, name FROM dbo.projects TABLOCKX')

GO

SET IDENTITY_INSERT dbo.Tmp_projects OFF

GO

DROP TABLE dbo.projects

GO

EXECUTE sp_rename N'dbo.Tmp_projects', N'projects', 'OBJECT'

GO

ALTER TABLE dbo.projects ADD CONSTRAINT

Myuniqye UNIQUE NONCLUSTERED

(

id

) ON [PRIMARY]



GO

COMMIT

If you look at the above, it is basically creating a temporary table and inserting all the records from the main table and then renaming the temp table to original table name.

The problem is many projects want developers to save the script changes so that they can apply the same on to development / test / production servers, so developers want to save the script.

There is a way to do that too, actually 2 ways,

1) In Enterprise manager when you click design table and after you made the change, there is a small icon at the top which reads,"save changes script" (should be the third icon from the left if you have icons unmodified), so this basically scripts the entire change for you to save it.

2) Start Sql Profiler, perform the operation and then save changes script is the second way to do it.

This link too verifies the same,

http://www.sqlmag.com/Article/ArticleID/22080/sql_server_22080.html

Visual Studio 2005 Tips & Tricks #1 - Automatically format the code

noreply@blogger.com (Prashant Danda - http://freshant.com) — Fri, 11 May 2007 06:54:00 +0000

Visual Studio 2005 Tips & Tricks - Automatically format the Code

I have seen many managers pay more attention to how code is written (mainly to alignment, spacing and indendation), even previous programming languages like FORTRAN 77 & COBOL 65 had particular column numbers where we need to code exactly.

But mainly coding is formated to make it more readable and to look neat for another developer to read and to try to understand.

But most of the developers do not align their code properly making it worse to read and understand, though this is not a new feature in VS2005 it is one of the essential features for any IDE to possess and here it is. Note: It is also present in VS2003, and other famous editors like homesite etc but many developers do not use it and still we see poorly aligned code making it hard to read.

Open the IDE, go to Edit >> Advanced >> Format Document, and

the source and code behind is automatically formated and aligned very neatly with indendation.

Tale of a .Net Component

noreply@blogger.com (Prashant Danda - http://freshant.com) — Fri, 11 May 2007 05:32:00 +0000

Most of dot net books or articles on the web are task based, meaning they explain a method or a property or a small task and explain how to do it and the entire MSDN is something similar.

It is very rare to find a full fledged project implementation or a book which explains how to code a project, from scratch to rollout and updates.

If we look at real life that is what one expects, the best practices how to seperate layers of code, when to write components vs when to write controls, how to reuse code, but there were few implementations in the past like the pet shop project where an entire project was given as download for enthusiastic developers to learn. That is how i coded my first dot net project not by learning from a book or from msdn but by looking at the code of a sample dot net project provided by microsoft.

Today was the last post of a 5 part series explaining from scratch how to write a dot net component, i liked this article a lot and hence am posting it on my blog.

Tale of a .Net Component - Part 1 (Explains the requirement & the design)
http://www.devsource.com/article2/0,1895,2095440,00.asp

Tale of a .Net Component - Part 2 (Explains the class design)
http://www.devsource.com/article2/0,1895,2097685,00.asp

Tale of a .Net Component - Part 3 (Properties creation)
http://www.devsource.com/article2/0,1895,2099681,00.asp

Tale of a .Net Component - Part 4 (Depth in to code)
http://www.devsource.com/article2/0,1895,2104404,00.asp

Tale of a .Net Component - Part 5 (Testing & Rollout)
http://www.devsource.com/article2/0,1895,2111753,00.asp

The author of this excellent series is Peter Aitken (author of more than 40 books), http://www.pgacon.com/default.htm

I am sure any developer would love to read such articles.

Sql Server 2005 - How to change sqlserver authentication mode - windows authentication / sql server and windows authentication mode

noreply@blogger.com (Prashant Danda - http://freshant.com) — Thu, 03 May 2007 08:23:00 +0000

Sql Server 2005 - How to change sqlserver authentication mode - windows authentication / sql server and windows authentication mode:

When we install Sql server 2005 during the installation it would prompt us for what kind of authentication mode to use (windows authentication or mixed mode[both sql and windows]), but at any point of time we can change this (similar to how we do it in sql2000) but with the new sql server management studio, the way we do it has slightly changed, this blog entry explains how to do the same.

1) Launch Sql Server Management Studio (SSMS), usually found in start > program files > Microsoft sql server 2005 > Sql Server Management Studio,

2) SSMS is nothing but a single IDE which combines both sql server 2000 enterprise manager and sql server 2000 query analyzer.

3) Since the mode is right now windows authentication, select the server type as "database engine" and then server name: the name of the sql server 2005 instance you are trying to connect to and authentication as "windows authentication" and click connect,

Note: If sql server 2005 is not yet started you may get an error msg (but in sql 2000 it used to start the sql server if it was not yet started but in 2005 it does not start it automatically).

4) Now the ssms will be connected, start the object explorer, several ways to start it, easiest is to press F8 or click on the icon in the menu which has the tool tip object explorer, (3rd from the right), object explorer is nothing but an tree view of all existing sql server instances, the databases and other agents (similar to sql 2000 enterprise manager left hand tree).

5) Right click on the sql server 2005 instance name and select properties to open the server properties popup window, in this window click on "security page" in the left hand side tree menu, and this page shows the server authentication, change it from windows authentication to sql server and windows authentication.

6) Now we need to perform one more additional step, configuring "sa" login or some other login and enabling it.

7) In the object explorer (F8) expand security, click on logins, the existing logins are shown in the right hand side, right click "sa" the default system administration login and select properties to show the properties window for "sa" login, here change the password of the login.

8) The main step is click on status page in the left hand side and change the status of the login to enabled (if not you will not be able to connect back using sa login)

Thus you can change the authentication modes in sql server 2005, but this may require a restart of the instance.

After restarting sql server 2005 try launching ssms and this time select mode as "sql server authentication" and enter login - "sa" and the password which you had changed in previous step and click "connect" and it should log you in.

Tags: Sql Server 2005, Sql Server,sql-server-2005

Sql Server 2005 - A look at Installation : Instances

noreply@blogger.com (Prashant Danda - http://freshant.com) — Fri, 02 Mar 2007 17:27:00 +0000

About Sql Server 2005 Instances:

More than one Sql Server 2005 can be installed on the same server, each installation is an instance,
On the same machine you can have both Sql server 2000 and also Sql Server 2005 running side by side (like i do on my laptop),
When you install Sql Server 2005 you are asked whether you want it to be installed as a default instance (no name for the instance) or you want to give it a name.
During installation you can look at already existing instances as shown in the figure,

Why we need multiple instances?

If you are planning to have a test environment and a production environment i would recommend installing Sql Server Developer edition on another pc and use it as a test environment, i do not like having test and production on the same OS box. Then why do we need multiple instance support? which is a great question, my answer is below,
When you need to have multiple versions of sql server like 2000 & 2005 each run in their own instances,
When you need to give admin or sa access to two different administrators to maintain their own sql servers,
When you want to have another instance on the same OS where you can first test the service packs and ensure it works fine on the production OS and then do it to the other live instance,
When you install other software like Vault or Sharepoint Portal Server 2007 or Visual Studio IDE 2005 they install their own instances of sql server 2005 or Sql Server 2005 Express editions.

SqlServer 2005 - About Sql 2005 & various editions

noreply@blogger.com (Prashant Danda - http://freshant.com) — Fri, 02 Mar 2007 16:38:00 +0000

Sql Server 2005 is a robust database which is a version upgrade after 5+ years, the previous one was Sql Server 2000 and the one before was Sql Server 7.0

Microsoft spent 5 years to come up with this next release which has a lot of cool features,

Improvements in performance,
More analysis tools,
Integrated development with cool dot net IDE and management studio,
CLR capabilities,
Http end points,
Support for service broker and SOA,
Better Sql jobs control with the new Sql Agent,
Database Snapshots feature,
Great database mirroring,
Log shipping feature,
Replication improvements,
and lots n lots of T-Sql and Sql improvements.

I have been working with Sql 2000 for the past 5+ years, and it is one of my favourite databases, i had previous experience working with My Sql and i used to wonder why such a robust database like Sql did not have some good features which mysql had at that time. Example: it had paging at the backend level, you can specify in a query itself how many rows you want, even oracle had pagenum but sql lacked it in 2000 sql server.

The new sql 2005 is very promising and has made up for all the lacking features.

Sql Server 2005 is shipped free with VS Dot net IDE as sql express edition, it comes with sharepoint portal server 2007 and a bunch of other dot net applications. Any developer should learn the new features of Sql server 2005 and my entries would be helpful in that regard.

Sql Server comes in 5 editions:

Sql Server 2005 Enterprise edition,
Sql Server 2005 Standard edition,
Sql Server 2005 Work group edition,
Sql Server 2005 Developer edition (free for development and testing, exactly like EE),
Sql Server 2005 Express edition (free like former MSDE)

Best ways to learn sql server 2005:

1) Books online free download - http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

2) Free E-learning courses from Microsoft - (for a limited time it is free soon to end)

https://www.microsoftelearning.com/sqlserver2005/

http://www.microsoft.com/events/series/technetsqlserver2005.mspx

3) Official site - http://www.microsoft.com/sql/default.mspx

4) Cost in $$ for Sql server 2005 - http://www.microsoft.com/sql/howtobuy/default.mspx

5) Made up your mind try it for free (180 day evaluation) - http://www.microsoft.com/sql/downloads/trial-software.mspx

6) Edition comparisons - http://www.microsoft.com/sql/editions/enterprise/comparison.mspx

7) Post a comment on my blog, if i know the answer will let you know :)

Classic ASP (not ASP.Net) code debugging with VS Dotnet IDE 2005

noreply@blogger.com (Prashant Danda - http://freshant.com) — Wed, 21 Feb 2007 15:15:00 +0000

I am not sure how many developers would need this but i needed it badly, i think i am the only one doing ASP coding and ASP.Net 2.0 coding at the same time :) So having used the 2005 IDE, you feel like your hand is broken when you go back to do classic ASP coding for old maintenance projects, where only way to debug is Response.Write but imagine how it would be if you can set breakpoint in classic ASP code and step in, step out F11, F10, Shift F11, F5 wouldn't it be great.

So i started my googling to find a solution which would make my daily coding life better and i was able to do it.

So here i am sharing my experience, "How to debug classic ASP using VS Dot net IDE 2005"

1) You need not have a sln or a project file, you can even open one single ASP file and debug it from top to bottom,
2) Open your ASP file in VS Dot net IDE 2005, then open IE and browse the page, this is done so that the ASP rendering process (IIS server but not aspnet_wp.exe, not w3wp.exe but dllhost.exe comes in to task manager),
3) Go to your default web site in IIS or your virtual directory >> right click properties >> home directory >> configuration >> Debugging tab >> in the debugging flags section,
check - Enable ASP server-side script debugging

In the script error messages section, check send detailed ASP error messages to client. (as shown in picture below).

4) Now comes the important step, open your vsdotnet ide 2005, and open the single ASP page and click Debug >> Attach to process >> check the check box [ ] show processes from all users, then look for a process called dllhost.exe Type = x86, Script and the username running it is YOURPCNAME\IWAM_YOURPCNAME.

Click Attach and wait for few minutes and click ok, now go back to your ASP page place a break point and then refresh the IE, and you should see it stops at the breakpoint.

Happy Debugging ASP :)

VSDotnet IDE 2005 making use of IIS instead of development webserver

noreply@blogger.com (Prashant Danda - http://freshant.com) — Tue, 20 Feb 2007 21:49:00 +0000

How to use IIS as the default web server instead of inbuilt ASP.Net development web server

When you create a new web project in VS dot net IDE 2005, by default it uses the inbuilt ASP.Net development web server for debugging and running,

So the URL will be something like,
http://localhost:2500 or a dynamic port,

This is actually the internal development web server. But for developers who are familiar with using IIS this may actually be a head ache. Also if you are using port 80 to code certain applications or using AJAX with 80 port then it may be tough to debug using fiddler or in general to stop and restart. So it is better to use IIS.

Listed below are the series of steps which you can easily do to change it to use IIS,

1) Create a virtual directory on IIS and point it to the folder where the source code resides, for example I use D:\drive instead of C:\inetpub\wwwroot, so i create a Virtual directory called "WebSite1" and point it to D:\proejcts\dotnet\website1\ = the folder where the sln file and the vbproj or csproj resides.

2) Right click on the virtual directory tab and go to properties in IIS and click on ASP.Net tab, in the dropdown change the dot net version from 1.1 to 2.0

3) Then open your VS dot net solution file and right click on your project >> go to property pages >> click on start options to see a screen like the one shown below,

In the above screen, select Use Custom server, Base URL: http://localhost/website1

Now try debug >> start without debugging, you will be using IIS to render the page. Though this is simple it takes few minutes to ponder this setting.

Sharepoint enable anonymous access and extranet sites

noreply@blogger.com (Prashant Danda - http://freshant.com) — Tue, 30 Jan 2007 18:20:00 +0000

It is very common practice to create 2 sites one for intranet and one for extranet users and also enable anonymous access for extranet sites for certain pages and parts.

Unfortunately doing this is not a piece of cake in sharepoint and requires few manual interventions, here is an excellent article with snapshots which explains how to do this.

http://andrewconnell.com/blog/articles/HowToConfigPublishingSiteWithDualAuthProvidersAndAnonAccess.aspx

Dot Net 3.0 Question Bank for Interview Preparation / General Knowledge

noreply@blogger.com (Prashant Danda - http://freshant.com) — Wed, 10 Jan 2007 17:26:00 +0000

My friend Sarath showed me this link today which has a huge collection of very well prepared question bank material.

Main point is it has lot of WCF WPF and Dot Net 3.0 questions.

Full eBook with 4000 .NET 3.0 ,C#, Ajax,JAVA,.NET and SQL ServerInterview questions
http://www.questpond.com/SampleInterviewQuestionBook.zip

Download the JAVA , .NET and SQL Server interview sheet and rateyourself.
This will help you judge yourself are you really worth ofattending interviews. If you own a company best way to judge if thecandidate is worth of it.
http://www.questpond.com/InterviewRatingSheet.zip

2000 Interview questions of .NET , JAVA and SQL Server Interviewquestions (worth downloading it)
http://www.questpond.com/InterviewQuestions.zip

Core Java and OOP's Interview questions
http://www.questpond.com/OOPsAndCoreJava.zip

Servlets / JSP Interview questions
http://www.questpond.com/ServletsJSP.zip

Architecture Interview Question
http://www.questpond.com/ArchitectureInterviewQuestions.zip

Project Management Interview questions must to read for all aspiringproject managers
http://www.questpond.com/ProjectManagementInterviewQuestions.zip

Full Address book application in C# with technical specification ,estimation and test cases
http://www.questpond.com/AddressbookProject.zip

Web services Interview questions
http://www.questpond.com/WebServicesAndRemoting.zip

SQL Server 2005 Database optimization Interview questions
http://www.questpond.com/DatabaseOptimization.zip

SQL Server 2005 DTS Interview questions
http://www.questpond.com/DTSInterviewQuestions.zip

SQL Server datawarehoue and Data mining Interview questions
http://www.questpond.com/DatawareHousingandDataMining.zip

SQLCLR Interview questions
http://www.questpond.com/SQLCLRInterviewquestion.zip

SQL Server XML Interview questions
http://www.questpond.com/SQLServerXML.zip

Basic .NET Framework interview questions
http://www.questpond.com/FrameWorkSampleInterviewQuestions.zip

..NET Interop and COM Interview questions
http://www.questpond.com/InteropdotnetInterviewQuestions.zip

ASP.NET Caching Interview questions
http://www.questpond.com/CachingInterviewQestions.zip

Localization globalization Interview questions
http://www.questpond.com/LocalizationAndGlobalization.zip

Do not know how estimations are done here's a complete book on it
http://www.questpond.com/HowtoPrepareSoftwareQuotations.zip