SQL Server 2008 Experience

Microsoft SQL Server 2008 Experience page on which you can watch many videos for Developers, decision makers and for fun as well.

You will watch and listen the real people who are behind the creation of SQL Server 2008.

Click here:
SQL Server 2008 Experience

SQL Server 2008 ScreenSaver and wallpaper

You can download the SQL Server 2008 ScreenSaver and Wallpaper.
Download here

Upgrading Visual Studio 2008 to Visual Studio 2008 SP1 and SilverLight

If you have tried to install SP1 for Visual Studio 2008 and have experienced failure then follow the steps as mentioned below:

These steps applies to if you have Visual Studio 2008 alone, or on the top of some Beta components of SQL Server and Visual Studio 2008.

Tricks before you begin installation:
1- Disable Automatic updates.
2- Disable any of the Anti-virus, spyware etc.
3- Set Windows Firewall to Off.
4- Keep the VS 2008 Installation media ready.

Step -1: Visual Studio 2008 Service Pack Preparation Tool

Step -2: Microsoft Visual Studio 2008 Service Pack 1

In this step-2, you may experience that at the end of installation wizard "SQL Publishing Wizard 1.3" is running forever, if you face the same then cancel the setup, and it will show you the finish dialog. Now you can successfully perform Step-3.

Step -3: Microsoft Silverlight Tools Beta 2 for Visual Studio 2008

Once these steps are performed then you can go to Visual Studio --> Help menu --> About Visual Studio, and you will see that SP1 is installed along with SilverLight as show in the figure below. Also it will install all the updates during the installaion procedure.

Migrating a Website from Visual Studio 2005 to Visual Studio 2008

The first time you open a Visual Studio 2005 website, you’ll be asked if you want to adjust it to use ASP.NET 3.5



If you choose Yes, the web.config file will be modified to target .NET 3.5. If you choose No, your website will continue targeting ASP.NET 2.0, but you can modify this detail at any time by choosing Website's Start Options. Either way, you won’t be asked again, because your preference is recorded in the hidden solution file that’s stored in a user-specific Visual Studio directory.

SQL Server 2008 New Feature - Insert statement supports multiple record

With SQL Server 2008, we have got an interesting enhancement in Insert statement.

Originally from previous releases of SQL Server until SQL Server 2005, an INSERT statement was supposed to accept set of values for one row/record at a time.

INSERT INTO Customers (Name,Qty,Price)
Values('A',2,12)

INSERT INTO Customers (Name,Qty,Price)
Values('B',3,24)

But with SQL Sever 2008, we can insert multiple rows/records at a time just separated by comma as a delimiter:

INSERT INTO Customers (Name,Qty,Price)
Values('A',2,12),('B',3,24)

This will help the developers to save their time while inserting data.

Review of uCertify's C# 70-528 exam .NET Preparation Kit

I feel that ASP.NET 2.0 has not been so easy to understand for many .NET folks. Likewise being a Microsoft Certified Technology Specialist in .NET 2.0 Web Applicaions is a complex task too.

You can achieve it, if right methodology of learning and practicing the concepts has been used.

Ucertify's preparation kit titled
70-528-CSHARP - C#.NET 2.0 Web-based Application Development practice test will help you learn fast, understand completely and qualify the test for sure.

The preparation kits of ucertify are designed to give you look and feel of real test environment and you will find yourself more cmfortable while appearing for real test, as you have been practicing on the same type of environment only.

There are many features ranging from study tips to how tos. I especially liked study notes and flash cards which will help each of us to recall the concepts so quickly especially when you are not in mood to read through the bulky notes or lengthy web articles :), I also found them useful while you want to quiz your ASP.NET 2.0 knowledge.

Ucertify's .NET 2.0 Web Application preparation kit will suffice all you need to learn about ASP.NET 2.0 exam objectives and really qualify the test.