Invalid Object Name – Management Studio Doesn’t Recognize new object

Today I’ve created a new table using SQL Server Management studio 2008, it creates successfully.

When I try to write a Query using this table, Management studio underlined the table name as Invalid object Name

I checked in the list of tables thru intelliSense feature, it does not recognize the table.

But lists on the object Explorer table’s lists after refresh.

After gone thru SQL Documentation, i came to know, this problem can be solved by Refreshing the IntelliSense Cache.

Following is the way to Refresh the IntelliSense Cache
Edit -> IntelliSense -> Refresh Local Cache

Now i checked the intelliSense lists, it lists the table.

Hope it helps!

StopWatch - BeeMobile Sample

I have created a Stopwatch Application using Beemobile controls. Beemobile products helps to develop windows mobile application with rich look

In this Application I used 3 beemobile control:
* IWheel
* TVistaButton and TForm (Transaparent Control)

Download Demo Video: StopWatch.wmv

SQL Server 2008 R2 Books Online

SQL Server 2008 R2 Books Online includes the following types of information:

1. Setup and upgrade instructions.

2. Information about new features and backward compatibility.

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

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

5. Tutorials that guide you through common tasks.

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

7. Descriptions of the sample databases and applications that are available with SQL Server.


Download SQLServer2008R2_BOL.msi

Unable to Access IIS components

Today, One of My friend, Trying to deploy Webservice in local Webserver, but Throws the following Error!

you must install the following IIS components:

IIS 6 Metabase and IIS 6 Configuration Compatibility
ASP.NET
Windows Authentication

For more information, press F1.

But He installed IIS in his PC, but still it says the same error.

Note : If you are not installed, then follow the steps given in my previous post, How to Install IIS in Vista & Windows 7

If you are using other Other Operating System, then follow the manual.

After Installed IIS, We tried many times to publish the Web service, but still we faced the same issue, finally we come to know, My friend doesn't have proper priviledge to deploy to IIS. If you want publish on IIS, you should have admin rights.

So We run Visual studio thru "Run as administrator", then we tried to deploy the Web service.

Wow ... It works Well!

Hope it Helps you, if face the same problem!

SQL Server 2005 evaluation software - Expired

The SQL Server 2005 evaluation software is no longer available. Learn more about the enhancements and new features in SQL Server 2008.


Reference:
http://technet.microsoft.com/en-us/sqlserver/bb498185.aspx

How to Install IIS in Vista & Windows 7

This Post guides you to Install IIS in your Vista or Windows 7 Operating systems.


Follow the steps to install IIS:


Go to Control Panel, Then Click On Programs (this Exhibit only for Windows 7, remaining steps are common to both)

In Programs and features, click "On Turn Windows Features on off", 

It Displays a window with list features which are installed and available to install.

Check the “Internet Information Services”, Expand the tree (+), it will displays lot of features, check it, if necessary, Then Click on Ok Button to install.

After Install, Vista will Expect reboot, but In Windows 7 not required to reboot.


To check the IIS, Go to Start, Type “InetMgr”, If Exists, it will filter and displays on the top as shows below, 

run this, It will open the IIS Manager.

Hope it helps you!

BeeMobile For MVP - Free of Charge

Dear Friends,


Good Opportunities for Microsoft Most Valuable Professional (MVP) !!!


Bee Mobile is providing the Products free of charge for you and your company, if you are a MVP.


Please send an email together with a link to your MVP profile to beemobile@beemobile4.net


Reference:
http://beemobile.blogspot.com/2009/03/are-you-mvp.html


This product really rocks!


beeMobile product helps to develop mobile application with modern touch control suite. it provides high look, transparent screen, ease of access to mobile application.
I found many features and samples about this product from their native site. Have a look at this at, http://beemobile4.net/?mod=products


Here i placed some samples about BeeMobile products.


The following is the sample of Region Controls, we can use this control in multiple ways, like shown below: Menu, Keyboard, toolbar, etc., 

The following is a sample of iWheel Control, it provides same look feel of IPhone DatePicker

The following the sample of Transaparent Control, it provides the transparency effects.

Microsoft SQL Server JDBC Driver 3.0 - Windows & Unix

Microsoft has released a new Java Database Connectivity (JDBC) driver. The SQL Server JDBC Driver 3.0 download is available to all SQL Server users at no additional charge, and provides access to SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 and SQL Server 2000 from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5 and above.

This release of the JDBC Driver is JDBC 4.0 compliant and runs on the Java Development Kit (JDK) version 5.0 or later. It has been tested against major application servers including IBM WebSphere, and SAP NetWeaver.

Download Java Database Connectivity (JDBC) driver

Windows Mobile Hands-On Labs

Dear friends,


If you want to learn about Windows Mobile application development, the “Windows Mobile Hands-On Labs” will help you.


Have a look at this link. http://msdn.microsoft.com/hi-in/windowsmobile/bb264328(en-us).aspx

How to Reset Microsoft Device Emulator - Smart Device

Whenever I used to check my mobile application thru Microsoft Device Emulator, it shows my previous application, because I saved my previous application along with Microsoft Device Emulator.


Now I want to clear my previous apps from the device. To do that, I follow these steps, which helps me to reset the Microsoft Device Emulator with default settings


I found there are many steps to reset the device

1. Clear Saved State – This will clear the saved content
2. Reset -> Soft or Hard
Soft: This will restart the device Hard: This will reinstall the OS Completely
3. Press Device Power Button: This will do the Soft Method

Hope this helps!

Expression Blend 4

Expression Blend 4 enables you to create websites and applications based on Silverlight 3 and Silverlight 4, and desktop applications based on Windows Presentation Foundation (WPF) 3.5 with Service Pack 1 (SP1) and WPF 4.
Expression Blend provides support for prototyping, interactivity through behaviors, special Silverlight functionality, and on-the-fly sample data generation.

Expression Blend includes new behaviors that are quickly and easily configured. To support the development of line-of-business (LOB) applications, Expression Blend introduces support for Views and ViewModels.

Download Blend_Trial_en.exe

Get Groups Count in SSRS

Today One of My Friend asked me, How to Get the Count of groups in a SSRS Report. I have suggested the following solution.

=CountDistinct(Fields!FieldName.Value, "DataSet1")

CountDistinct - This is a Method which will return the Unique Count
Fields!FieldName.Value – Here pass the group field name
"DataSet1" – Scope Detail, Where the group field exists

This Expression will return the Group counts exists in a report

Hope it helps you!

Getting started with Microsoft SharePoint Server 2010

This book provides basic information about the capabilities of and requirements for Microsoft SharePoint Server 2010. The audiences for this book include application specialists, line-of-business application specialists, information architects, IT generalists, program managers, and infrastructure specialists who are just starting to learn about SharePoint Server 2010 and want a quick introduction plus installation steps.


Download SharePtServGetStarted.doc