TechNucleus

This is not a tuff job to do but recently one my friend asked me the same question and i replied with the following query.

SELECT SKUID, COUNT(SKUID) FROM SKURequests
GROUP BY SKUID
HAVING COUNT(SKUID) > 1

 

Even though it is very simple, i thought to share in my blog so it may help some one who needs it.

Recently i tried to import the data from the excel document to my SQL database and received the following error.
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source – XXXX.XLS

SQL Server 2005 provides a way to generate a scripts for database schema such as Tables, Stored Procedures, Triggers, Functions, Views etc. That’s a good feature you need when you want to move the database schema form one environment to another environment. But what about data? You guys might faced a challenge to fetch data from production to development and you can not use backup and restore option since If you do so, what ever changes you made in development database will be vanished.

Now a days everyone is using JavaScript frameworks/library in there JavaScript based application development for easier development, especially for AJAX.

There is list of notable JavaScript Frameworks/libraries are available, but the question is which one appropriate to choose.

Recently i developed a report as i do normally by using Page Header (Images and Report Heading), Body (Data within tables) and Page footer (Page Numbers and date and time of report generation). When displaying on the web page or export to excel, all fields and layout shows correctly with out any issue. But the problem is when export to excel, some of the columns were merged as shown below.

Look into this article to get quick understanding and basics on WCF.

Before you leave:

• Tell me whether you like this article or not? Rate this post accordingly by selecting the stars below.
• Any suggestion, question or comment? Please post it in the comments below.

Go to this link. I found the article which is very nice and useful for improving virtual server performance.

AHCI(Advanced Host Controller Interface) mode brings 3 main advantages:

1. Supports NCQ (Native Command Queuing) allowing SATA drives to accept more than one command at a time and dynamically reorder the commands for maximum efficiency.
2. Supports hot plugging of devices.
3. Supports staggered spin ups of multiple hard drives at boot time

If  your device manger shows unknown PCI Communications controller and not sure what that device is?

When ever we develop ASP.NET application, we keep our entire environmental specific settings into web.config file. Based on where we deploy the application (Dev, Test, Prod), we will comment out other environments which is a manually process. Personally I prefer different web.config files for different environments and based on the Build option you select it should dynamically create the appropriate web.config file for that environment.

Recently my wife asked me what is the difference between UNIX and Linux. Basically I dont know much about these operating systems becauseI always work with windows operating systems. Since my wife asked the difference between those and even i want to know other operating systems, so I immediately jumped into google and find the following information.