First Invisible Speaker from People People

December 12, 2011 Leave a comment

This speaker comes from company People People, and what makes this speaker stand out from the others is it’s unusual look. This is probably the only speaker on the market that is made out of transparent materials, so it’s completely see-through and almost invisible.

speaker_floor_peoplepeople

 

Read More . . . .

Categories: Accessories, Gadgets

Apple unveils iPhone 4S

October 4, 2011 Leave a comment

Apple on Tuesday announced the iPhone 4S, a 3G smartphone with improved hardware designed to allow the device to run applications faster than its predecessor, the iPhone 4.

The iPhone 4S will run on a dual-core A5 processor, which also will allow the device to run graphics up to seven times faster than prior models, said Phil Schiller, senior vice president of worldwide product marketing at Apple, during an event held at the company’s Cupertino, Calif. campus. That could allow for a better gaming experience and 1080p video playback. The iPhone 4′s A4 chip provides up to 720p of video playback.

Iphone 4s

Read More . . . .

iPhone 5 – Release Date and Features

October 3, 2011 Leave a comment

As the 5th generation of the iPhone is on the verge of being released, and with all the speculations spreading on the Internet about the iPhone 5, people are anticipating and desperately waiting for the launch of the smartphone. Many fans and current Apple iPhone consumers are wondering what groundbreaking features Apple will add to the new iPhone 5.

iPhone-5

Read More . . . .

Seagate 4TB GoFlex Desk External Drive

September 8, 2011 Leave a comment

Need some extra storage space? How about a lot of extra storage space? Well, it looks like Seagate has decided to push external storage up a notch with the announcement of its new GoFlex Desk drive with a capacity of 4TB. It’s not clear if we’re looking at a single 4TB drive, of if Seagate has fitted two 2TB in the re-designed enclosure.

Flex_Desk

Read More . . . .

 

Sony MDR-DS7500 Wireless 3D Surround Headphone

September 2, 2011 Leave a comment

MDR-DS7500, Sony latest wireless headphone comes with a newly developed chipset for 3D audio as well as Dolby NR professional Logic II z decoder supporting audio signals up to 7.1Ch.

 

MDR-DS7500

Read More . . . .

GIGABYTE G1.Sniper 2 Gaming Motherboard

August 29, 2011 Leave a comment

Gigabyte announced the launch of the new G1.Sniper 2 motherboard, the latest G1-Killer Series motherboard designed for extreme gaming on the latest Intel Z68 chipset and Intel i7 Core ‘Sandy Bridge’ processors. Featuring several state-of-the-art onboard solutions from renowned industry leaders Creative and Bigfoot Networks, as well as many additional and exclusive GIGABYTE features, the GIGABYTE G1.Sniper 2 motherboard takes no prisoners in its quest for gaming supremacy.

Gigabyte_Sniper2

Read More . . . .

 

SoftBank unveils “Yahoo Phone” in Japan

August 22, 2011 Leave a comment

SoftBank, the owner and operator of Yahoo! in Japan, launches the world’s first Yahoo! Phone in partnership with Sharp. So how exactly does the Yahoo Aquos 009SH differentiate itself from the hundreds of other Android smartphones on the market?

yphoneRead More . . . .

Samsung Galaxy R – Dual Core processor Phone

August 11, 2011 Leave a comment

Samsung launched a new Samsung Galaxy R mobile phone with stunning looks and design. It comes with the Android OS v2.3 Operating system (Gingerbread) and 1GHz NVIDIA Tegra 2 AP20H Dual Core processor.

Samsung-Galaxy-R

Read More . . . .

iPhone 5 Launch Second Week In September?

August 4, 2011 Leave a comment

Since iOS 5 is expected in September, we are expecting that Apple iPhone 5 to launch around the same time. Previously, a report suggested that the iPhone 5 release date would be September 5th.

iPhone-5-Concept-Design

Read More . . . .

 

Nokia 500 – 1GHz Symbian phone

August 2, 2011 Leave a comment

Beleaguered cellphone maker Nokia has unveiled its first Symbian-based smartphone running on 1GHz processor, Nokia 500. Nokia 500 is based on the current version of Symbian OS, Anna.3

Nokia_500_dark-azure_blue_Front_Right

Read More . . . .

Compound Operators in SQL Server

July 5, 2011 Leave a comment

There was a time when we all wished SQL Server supports compound operators just like any other programming languages. Wouldn’t it be nice to have a shorter syntax for assigning the result of an arithmetic operator?  Well, SQL server 2008 introduced Compound operators that allow you to perform several arithmetic operations using an operand along with equal to (=) operand.

 For example:

Declare @var1  int

Set @var1 = 150

Set @var1 += 100

Read more…

 

 

What are SQL Query Hints?

July 5, 2011 Leave a comment

SQL server usually selects the best query plan required to execute a T-SQL query. However, there might be cases where the plans selected are not the best. In such situations, you can use the query hints to suggest the best possible plan/method of executing a query. The Query hints can be applied on all operators in a query. These hints apply to SELECT, DELETE, INSERT, UPDATE and MERGE. You can use the Query hints in the OPTION clause after the query.

Few commonly used Query hints with examples are as below.

Read more…

 

Understanding MERGE Transact SQL Statement

July 5, 2011 Leave a comment

By using “Merge”, you can perform insert, delete and update on a table in a single SQL statement. This helps in synchronizing the tables as well.

However while using merge there are several points that you need to keep in mind. Few

  • In a “Merge” statement, a “When Matched” clause with a search condition cannot appear after a ‘When Matched’ clause with no search condition.
  • A “Merge” statement must be terminated by a semi-colon (;).
  • An action of type ‘DELETE’ is not allowed in the ‘WHEN NOT MATCHED’ clause of a MERGE statement.
  • At least one of the three MATCHED clauses must be specified, but they can be specified in any order. A variable cannot be updated more than once in the same MATCHED clause.
  • Any insert, update, or delete actions specified on the target table by the MERGE statement are limited by any constraints defined on it, including any cascading referential integrity constraints.

Few examples of merge are as given below.

Read more…

 

 

SSIS : Sequence Container

July 5, 2011 Leave a comment

Sequence containers is used to group the package into multiple separate control flows, each containing one or more tasks and containers that run within the overall package control flow. There are several advantages in using sequence container

  1. Provides facility to set property of multiple tasks by setting the property of sequence container.
  2. Provides the facility of disabling groups of tasks to focus debugging on one subset of the package control flow.
  1. Scope for variables that a group of related tasks and containers use can be controlled easily.
  2. Managing and visualization of group of tasks becomes easier using sequence container.
  3. We can also expand and collapse the container, hence making the package look neat.

Using Sequence Container

Create a new SSIS package ( refer video to create new SSIS package). Drag the sequence container from the toolbox on the left hand side into the package.

Read more…

 

SSIS : Using and Configuring For Loop Container

July 5, 2011 Leave a comment

What is For Loop Container?

For loop defines a repeating control flow. It has similar behavior as the “FOR” loop available in programming languages.  The For Loop container uses 3 expressions as definition

  1. Initialization expression:  it assigns value to the loop counters. This expression is optional.
  2. Evaluation expression : It contains the expression to test whether the loop should continue executing  or exit.
  3. An optional iteration expression that increments or decrements the loop counter.

The expressions used must be valid SSIS expression. A variable is generally used in the expression.

Using and Configuring For Loop Container

(Task in hand: print counter variable value for each iteration times.)

Drag a for loop container into the SSIS Control flow window from the Toolbox. Double click on the for loop container to view the “For Loop Editor”. As mentioned earlier it contains 3 expressions. Now create a variable by name “TestVariable” of type “int32”.

Use this variable as counter in the container using expressions as shown below.

Read more…

 

 

Follow

Get every new post delivered to your Inbox.