We all know Bose only for its great sound equipments, they are now entering automobile industry.
They have developed a new automobile suspension system which make car to travel much smoother than a luxury sedan. As of now it is done in trial basis.
More info: Bose.com
Saturday, January 26, 2008
Friday, November 03, 2006
How to find database connection strings
When ever we create an application which has to be connected to a database, it needs a connection string. We all know the connection strings for widely used databases like SQL Server, MS Access, Oracle. If not we will find it in web. Then, how to find connection strings for less popular or rarely used databases. Yes you can.
Step 1: Open a notepad application
Step 2: Save the empty file with any name with udl extension (*.udl). Type the filename with extension with in quotes. Step 3: Double click the saved file.
Step 4: It will have 4 tabs (Provider, Connection, Advanced, All). Select "Provider" tab
Step 5: Select the provider. (To connect a database we need a driver or provider. If it is installed in the machine, it will be displayed in the Provider tab) and click Next. For Ex: Microsoft OLE DB for SQL Server
Step 6: Fill the appropriate information in the Connection tab, such as server name, username, password, database. Check the "Allow saving password" option. After filling the information click "Test Connection". It should pop up with the information"Test Connection succeeded".
Step 7: Click "Ok" to close the window. Click "Yes" for the next dialog.
Step 8: Now open the file in notepad. You will get the connection string.
Step 1: Open a notepad application
Step 2: Save the empty file with any name with udl extension (*.udl). Type the filename with extension with in quotes. Step 3: Double click the saved file.
Step 4: It will have 4 tabs (Provider, Connection, Advanced, All). Select "Provider" tab
Step 5: Select the provider. (To connect a database we need a driver or provider. If it is installed in the machine, it will be displayed in the Provider tab) and click Next. For Ex: Microsoft OLE DB for SQL Server
Step 6: Fill the appropriate information in the Connection tab, such as server name, username, password, database. Check the "Allow saving password" option. After filling the information click "Test Connection". It should pop up with the information"Test Connection succeeded".
Step 7: Click "Ok" to close the window. Click "Yes" for the next dialog.
Step 8: Now open the file in notepad. You will get the connection string.
Wednesday, November 01, 2006
When to use SQL Server Cursor
We mostly use Cursors when there is a need for row by row operation, which cannot by replaced by a nested queries. The greatest disadvantage in Cursors is it stores the result set in an memory and processes one by one. Suppose for 1000,00 records it occupies huge memory and performance is will very poor. In those cases it is always better to go for While Loop instead of a cursor. This improves the performance drastically.
declare @loopvar int
declare @maxcnt int
declare @cnter int
declare @outermax int
create table #temptable (
ROWID INT IDENTITY(1,1),
productgp int )
Insert into #temptableselect distinct id from products where status = 1 order by ID
set @outermax = @@ROWCOUNT
set @cnter = 1
While (@cnter <= @outermax)
Begin
// Do your process here
// Do your process here
set @cnter = @cnter +1
end
Use Cursors only if resultset is less in number, say less than 5000 records.
declare @loopvar int
declare @maxcnt int
declare @cnter int
declare @outermax int
create table #temptable (
ROWID INT IDENTITY(1,1),
productgp int )
Insert into #temptableselect distinct id from products where status = 1 order by ID
set @outermax = @@ROWCOUNT
set @cnter = 1
While (@cnter <= @outermax)
Begin
// Do your process here
// Do your process here
set @cnter = @cnter +1
end
Use Cursors only if resultset is less in number, say less than 5000 records.
Monday, July 24, 2006
Remove Auto Complete
Tuesday, June 27, 2006
Microsoft's Code sharing site
Microsoft has launched Code sharing site called www.codeplex.com
It has lot of source code with shared souce code licenses.
Popular products already available on the site include Microsoft's Atlas AJAX development tool kit and Iron Python beta 1
Make use of it.
It has lot of source code with shared souce code licenses.
Popular products already available on the site include Microsoft's Atlas AJAX development tool kit and Iron Python beta 1
Make use of it.
Friday, June 23, 2006
India Tax Calculator (AY 06 - 07)
Use the following link to calculate tax (AY 06-07)
http://www.taxmann.com/taxmanndit/xtras/taxcalc.aspx
http://www.taxmann.com/taxmanndit/xtras/taxcalc.aspx
Tuesday, June 20, 2006
Chip breaks speed record in deep freeze
What is your PC clock speed?
(800 MHz, 1 GHz, 1.8 GHz , 2.4 GHz, 2.6 GHz, 3 GHz Dualcore, 3.6 GHz)?
If your find the answer in the above line then, it shows you have a Grand old PC
Research has gone to such an extent, and created a chip with clock speed of 350 GHz at room temperature.
It is also possible to have a chip with a clock speed of 1THz (@ - 459 F or 0 K or -273 C ) when liquid helium is used for cooling.
It is made up of (SiGe). Silicon and Germanium, it is manufactured by IBM and Georgia Tech.
For more Information: http://news.zdnet.com/2100-9584-6085568.html
Now imagine how fast your windows will boot and how fast you can do CTRL+C CTRL+V?
(800 MHz, 1 GHz, 1.8 GHz , 2.4 GHz, 2.6 GHz, 3 GHz Dualcore, 3.6 GHz)?
If your find the answer in the above line then, it shows you have a Grand old PC
Research has gone to such an extent, and created a chip with clock speed of 350 GHz at room temperature.
It is also possible to have a chip with a clock speed of 1THz (@ - 459 F or 0 K or -273 C ) when liquid helium is used for cooling.
It is made up of (SiGe). Silicon and Germanium, it is manufactured by IBM and Georgia Tech.
For more Information: http://news.zdnet.com/2100-9584-6085568.html
Now imagine how fast your windows will boot and how fast you can do CTRL+C CTRL+V?
AIM: To write a program that can run in watches, remote controls
All these time, we know using Microsoft technologies we can write applications that can run in PC, PDA, windows mobile, etc. Have you ever thought of writing application for watches, remote controls, cameras, and devices having very less memory, inexpensive processor and very less power?
Yes, Microsoft has done it.
.Net Framework for Usual applications
.Net Compact Framework for PDA and windows mobile (smart phones)
.Net Micro Framework for watches and remote controls.
At present MSN Direct Smart Watch works in .Net Micro Framework platform.
For more information:
http://www.aboutnetmf.com/entry.asp
Is it possible in Java technologies?
Yes, Microsoft has done it.
.Net Framework for Usual applications
.Net Compact Framework for PDA and windows mobile (smart phones)
.Net Micro Framework for watches and remote controls.
At present MSN Direct Smart Watch works in .Net Micro Framework platform.
For more information:
http://www.aboutnetmf.com/entry.asp
Is it possible in Java technologies?
Subscribe to:
Posts (Atom)