Currently browsing

August 2012

Case Sensitive SQL Query Search and Joining

Case Sensitive SQL Query Search and Joining     This article gives you a total overall idea related to collation. It not only contains definition but also contains SQL comparisons and joins with different type collation table in different database. So let’s start Collation is defined by a set of …

Understanding Processor Architecture Simplify Computer Complexity

Understanding Processor Architecture: Simplify Computer Complexity Computers are complex systems. We study computer systems by using layers of abstraction. We use a hierarchical structure to simplify the management. Each level of management filters out unnecessary details on the lower levels and presents only an abstracted version to the higher-level management. …

C Tutorial Some Lab assignments on Inheritance

C++ Tutorial: Some Lab assignments on Inheritance Question: Create a class called Musicians to contain three methods string ( ), wind ( ) and perc ( ).    Each of these methods should initialize a string array to contain the following instruments    –  veena, guitar, sitar, sarod and mandolin under string …

Database Schema

Database Schema     In this article, I am trying to express my view related to SQL Server Schema. Hope it will be interesting and informative.   Definition   A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema …

Understanding Processor Architecture ISA

Understanding Processor Architecture: ISA A programmer uses the Instruction Set Architecture (ISA) as an abstraction to understand the processor’s internal details. This abstraction suits us very well as we are interested in the logical details of the processor without getting bogged down by the myriad implementation details. The ISA specifies …

Transaction and SAVEPOINT

Transaction and SAVEPOINT   Transaction is a very important part of SQL developer. In this article I am taking about the SAVEPOINT of MS SQL Server and how we use the power of save point. Hope it will be interesting. When we are working with T-SQL statement we are using …

OpenServo

OpenServo OpenServo is an open community-based project started by Mike Thompson with the goal of creating a low-cost digital servo for robotics. The hardware and software design of the OpenServo is free for anyone to use and modify to meet their particular needs. It is currently being developed by a …

C Tutorial Passing arguments by reference and returning by reference

C++ Tutorial: Passing arguments by reference and returning by reference. Pass by ReferencePass by reference in C++ is implemented as the variable aliasing. The function definition for pass by reference is defined as follow: void incr(int &num){ num++;} The call to this function is incr(a); The call to this function …

NOT IN clause is a Performance Killer

NOT IN clause is a Performance Killer   Performance is a very important factor in terms of web based applications. Sometimes I find that the developer use the NOT IN clause in SQL statement which decrease the performance of entire SQL statements. Developers told that we don’t have any options …

Piklab IDE for PIC and dsPIC microcontrollers

Piklab IDE for PIC and dsPIC microcontrollers Piklab is an integrated development environment for applications based on Microchip PIC and dsPIC microcontrollers similar to the MPLAB environment. Support for several compiler and assembler toolchains, programmers, debuggers and simulators is integrated. A command-line programmer and debugger is also available. Piklab home: …

Inheritance Derived Class Declaration

Inheritance: Derived Class Declaration The derived class inherits all the features of its parent class and adds its own new features too. The declaration of derived class specifies its relationship with the base class along with its own typical futures than the base class. During the derived class declaration we …

Orphaned or Ghost processes

Orphaned or Ghost processes     When a Microsoft SQL Server client disconnects from a SQL Server, the connection process should be cleared up on the server side. If the connection processes are not cleared up for any reason, they become “orphaned” or “ghost” processes.   These processes may use …

New book explains how to build Linux 26 kernels

New book explains how to build Linux 2.6 kernels O’Reilly has published a book for Linux users interested in learning to build their own kernels. Linux Kernel in a Nutshell describes how to build and install Linux 2.6 kernels, starting with downloading the source. It was written by well-known kernel …