Virtualization is going to hit you soon

Well Apple is talking about it, microsoft is talking abt it, all Fortune 100 and Fortune 500 companies are using it.

Soon virtualization is going to hit every developer,

We all have heard about VMWare, Microsoft Virtual PC (we are talking about giants), but this small company is rocking too, they have a 50$ product for virtualization and it rocks.
http://www.parallels.com/en/products/workstation/

I spoke with my pal who works for VMWare, some of the features he is talking about make me open my mouth.

VMotion - http://www.vmware.com/products/vi/vc/vmotion.html

Ok so here is my version of "VMotion for Dummies"

So you are in this super duper Server of yours, you installed VMWare and you have 10 virtual machines, suddenly your raid card or network card smokes out, so what do you do !!!!!!!!

Go nuts and drive ppl around you nuts. :) No here is what you do.

If you are smart enough you setup a VMWare Garden (ha ha ha that rings a bell, like IIS Web Farm), and you install VMotion, so if anything to hardware failure happens, the VMotion kicks in and it moves the virtual machine from one VM Ware server to another VMWare server.

Wow, where do these guys get such ideas from and the interesting of all is, when VM is moving it still servers.

So at last in this world 100% uptime is guaranteeed.

hey scripting guy

I had a need today to play with some VB Script, i was amazed to see the number of samples provided by microsoft,

http://www.microsoft.com/technet/scriptcenter/resources/qanda/default.mspx

This book has a lot of samples, what surprises me is, one team example scripting team @ MS is doing this but why not teams like Message Queue team or other teams !!!!!!!!

May be Institutionalization is tough there tooo :)

GC Memory leask

http://blogs.msdn.com/ricom/archive/2004/12/10/279612.aspx

Exterminate Agents

An interesting site which explains what db2 agents are and how to kill them

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0504poon2/

Command Prompt CSharp Compilation

Here is the string for compiling the .cs files c:\bin>csc /t:library fileName.cs.

Sql Server number of tables, procedures etc

Use db1
select count(*) from sysobjects where xtype = 'U' and status > 0
select count(*) from sysobjects where xtype = 'P' and status > 0
Use db2
select count(*) from sysobjects where xtype = 'U' and status > 0
select count(*) from sysobjects where xtype = 'P' and status > 0

Here xtype can also be
Object type. Can be one of these object types:
C = CHECK constraint
D = Default or DEFAULT constraint
F = FOREIGN KEY constraint
L = Log
FN = Scalar function
IF = Inlined table-function
P = Stored procedure
PK = PRIMARY KEY constraint (type is K)
RF = Replication filter stored procedure
S = System table
TF = Table function
TR = Trigger
U = User table
UQ = UNIQUE constraint (type is K)
V = View
X = Extended stored procedure

Sql Server Table Column counts

It has been a long time since i added anything to the tech blog.

Got one very nice UDF here for finding the number of columns in each table.
Was very useful as i had to upgrade a clients db after a long time.

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE FUNCTION dbo.udf_Tbl_ColCountTAB (

@Table_Name_Pattern sysname = NULL -- Pattern for matching
-- to the table name, Null=all
, @Col_Name_Pattern sysname = NULL -- Pattern for matching
-- to the column name, NULL=all
) RETURNS TABLE
-- NO SCHEMABINDING do to use of INFORMATION_SCHEMA
/*
* Returns a count for the number of columns in each table or
* view that satisfies the Table_Name_Pattern
*
* Example:
select * FROM dbo.udf_Tbl_ColCountTAB (null, null)
*
*/
AS RETURN

SELECT TOP 100 PERCENT WITH TIES
c.TABLE_NAME
, COUNT(*) NumColumns
FROM INFORMATION_SCHEMA.[COLUMNS] c
inner join INFORMATION_SCHEMA.[TABLES] t
ON C.TABLE_SCHEMA = t.TABLE_SCHEMA
and c.TABLE_NAME = T.TABLE_NAME
WHERE TABLE_TYPE = 'BASE TABLE'
and 0=OBJECTPROPERTY(OBJECT_ID(t.TABLE_NAME),
'IsMSShipped')
and (@Table_name_pattern IS NULL
or c.TABLE_NAME LIKE @Table_Name_Pattern)
and (@Col_Name_Pattern IS NULL
or c.COLUMN_NAME LIKE @Col_Name_Pattern)
GROUP BY c.TABLE_NAME
ORDER BY c.TABLE_NAME

GO

GRANT SELECT ON dbo.udf_Tbl_ColCountTAB to PUBLIC
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

பிரசாந்த்

பிரசாந்த்

Wow that is actually my name in Tamil. It is cool that it is being shown since it is in Unicode

http://home.att.net/~jameskass/keybtaml.htm

Used this link to paste it

Tracking who read your mail

Well i had a very interesting code which i had to look on friday. So what is so interesting about this code, the answer is it magically tracks who read your mail.

No i am not talking about the outlook read receipt, that shows an annoying alert to the receiver saying "the person who sent it wants a receipt do you want to send yes/no" - who on earth would like to send this receipt, I always click no :)

So how do we solve the problem, you want to know whetehr the person to whom you sent it actually read it or not. So what do we do.

Let us answer few questions, does the person who receives your email has html viewing capacity, does he have internet access, if so bingo!!!!!!!!!!! our idea will work.

This is what you do,

Inside the email you place a hook, an image it could be a simple image not so fancy one of those 2 kb ones, the html tag can be something like,
img src = www.yourwebsite.com/tracker.gif?param=343343

So that does the trick, now what you do is write a server side code (either php or asp.net or jsp or some SSC) and you put a listener.

As soon as the person opens hte mail, it downloads the images and your site get a hit with the param, so you can identify whether the mail was opened or not.

Isnt that cool!!!!

No more installation issues

With VmWare providing application appliance model, moving forward there will be no more installation issues, no need to worry about dot net framework Vs IIS installation which comes first, no more issues about vb run time or java runtime.

all we need to do is ship the vmplayer to the client with all the items installed and they will import it.

Wow !!! what a great idea.

We have read about hardware virtualization now this is software virtualization.

Who knows tomorrow we will have human virtualization too !!!!!!!