Kiran Marke's BLOG

Swine Flu And Pune

2009-08-12T01:22:00.000-07:00

We all are battling with "Swine Flu". News channels are all flooded in these news only. Everyday we receive news of 1-2 persons being killed by this dangerous virus. People here in Pune are really feared with this situation. Person coughed once is also seen in doubt. We cant help on this actually, the symptoms for "Swine Flu" are not different from the normal cold, cough symptoms. People having cold or cough alone are also gathering at Naydu and other government recommended hospitals for swine flu testing. I think this is really dangerous as these people are exposing themselves among the "Swine Flu" infected people. One should get tested if one has following symptoms together: fever, cough, runny\stuffy nose, sore throat, chills, fatigue, headache. Government should educate everyone on these actual Swine Flu symptoms.

This situation will become worse in coming days. Dahi-Handi and Ganapati festivals are approaching. and They are highly celebrated in Pune. We talk about keeping 6-10 feet distance from the infected people but will we be able to control the "H1N1 virus" if people will group together for such activities?. I think, rather than government imply force on janata for not celebrating these festivals in public manner, people here should understand the current situation and act accordingly. I think we should not celebrate "Dahi-Handi" and "Sarvajnik Ganeshostav" this year. People can worship Ganesh Murthi at their home. But in this way also you cant control on people gathering when it comes to the "Ganapati Visarjan". Better option is not to celebrate any festival. The ideal approach would be to observe curfew in the city for at least 10 days. and government should provide medicines to infected persons to their home.

Another thing i observed here is about the Masks distribution. I had to take pair of 3 layered mask for Rs 50. The similar mask was previously available for Rs 5. This is not the condition where we should look for our own benefit, and try to make profit out of the situation. Also even if city is facing shortage of the N-95 masks, everyone is going after them. Doctors have suggested that not everyone need N-95 masks and it is only for relatives of infected personnel. Two 3-layered masks overlapping one another will do.

For the precaution measures i am trying to remain away from Pune. Because right now i don't have any major responsibility work in office, I have taken leaves from office and taking rest here in kalyan. But i wont be able to do this for long time. Like me it is not possible for many people to keep away from work and leave Pune , my advice to them would be to drink a lot of water and juices, Vitamin 'C' food while working.

Considering the population and poverty of the nation, it is really worst thing happened that "Swine Flu" got spread in India. Till now the patients found are from cities only. If "Swine Flu" reaches to villages, then it would be real disaster. Let us hope, before this happens we will take control over it.

Tum Bin Jaaoon Kahan...

2009-07-11T03:21:00.000-07:00

Yesterday, I found Hariharan's version of this song in my friend's Orkut favorite videos. I was not aware of this version and movie. The song is sung in full of feelings and i really loved it the manner in which it is used in the movie.

But then critic inside me waked up. I downloaded all 3 versions of this song and started comparing. All of them are truly masterclass. I liked Harharan's version most. This may be because way in which it is used in the movie. You actually feel, hariharan tried to pour a lot of feelings inside it. Only on feelings basis, i will keep Hariharan's version at Top, Rafi's at 2nd position and Kishore's at 3rd position.

Hariharan's Version:

Rafi's Version:

Kishore's Version:

~ Kiran

"About Me" Pages

2009-07-04T03:25:00.000-07:00

I was going through web to have new way to implement personal profile page. Here I found 60 beautiful and effective About Me pages.

~ Kiran

Pronounce Name Correctly! :)

2009-06-22T22:45:00.001-07:00

This one is really a useful site. In our daily project work, we interact with Americans who have unfamiliar names. This site helps us to pronounce their name correctly. "How to say that Name" : http://www.howtosaythatname.com/

I am glad to see my name in the database. http://howtosaythatname.com/component/option,com_mtree/task,search/Itemid,4/searchword,Kiran/

Check Your Hearing! :)

2009-06-22T03:52:00.001-07:00

They say that it is common for people who are over 25 years of age to not be able to hear above 15kHz. I tested my hearing. I can hear up to 17Khz. Check yours. :) http://www.noiseaddicts.com/2009/03/can-you-hear-this-hearing-test/

Audit log Design : Using AFTER INSERT, UPDATE, DELETE Trigger

2009-06-10T07:17:00.001-07:00

In my last project, we had to implement Audit log functionality for SQL Server Data Changes. Due to very strict timeline(Project was of 2 months and Out of that Audit functionality was having only 10 days to implement), we were goggling for ready made design for Audit functionality. But our efforts gone into vain. Didn't find any good.

SQL Server 2008 is having in built functionality to capture data changes in the form of Change Data Capture Tool(CDC). We tried to convince the client to use the SQL Server 2008. But they didn't agree.:(. We had to go with SQL Server 2005.

We followed trigger based approach. We created AFTER INSERT, UPDATE, DELETE triggers on the all client tables, and recorded all the changes happened. The design was very simple. Hope this helps you guys.

Features included are:

Audit Log SHOULD have turn off & turn on switch.
Audit Log MUST capture information like who made the changes, what changes, when the changes occurred.
Audit Log SHOULD have rollback facility.
Retrieval of Audit details in Paging.
Audit retrieval WOULD have following APIs
- Get all changes
- Get all today’s changes.
- Get all changes for period.
- Get all changes for particular transaction.
- Get single Audit Log entry for given Id

Block diagram to show entire architecture used for Audit:

Audit Log Table:

CREATE TABLE [Administration].[AuditLog](
[AuditLogID] [bigint] IDENTITY(1,1) NOT NULL,
[TransactionID] [bigint] NOT NULL DEFAULT ([dbo].[ufn_GetTransactionID]()),
[ApplicationName] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL DEFAULT ([dbo].[ufn_GetApplicationName]()),
[ObjectID] [int] NOT NULL,
[OperationID] [tinyint] NOT NULL,
[PerformedBy] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL DEFAULT ([dbo].[ufn_GetContextLogin]()),
[PerformedAt] [datetime] NOT NULL DEFAULT (getdate()),
[TSQL] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrimaryKeyColumn] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PrimaryKeyValue] [int] NOT NULL,
[PreviousValue] [xml] NULL,
[NextValue] [xml] NULL

Table Schema:

Name	Data Type	Description
ID	bigint	Primary key - AuditLogID
TransactionID	bigint	Transaction ID used while performing DML query. This column is used to find out all the changes made in single transaction.
ApplicationName	nvarchar(max)	Application though which SQL query is made.
ObjectID	int	Table Id – To know on which table the operation happened.
OperationID	tinyint	1 = Delete 2 = Insert 3 = Update
PerformedBy	nvarchar(100)	To store who has performed the operation.
PerformedAt	datetime	Time when operation occurred.
TSQL	nvarchar(max)	To store exact query which made this AuditLog entry.
PrimaryKeyColumn	nvarchar(max)	To store primarykey column name of the Table on which operation occurred.
PrimaryKeyValue	int	Primary key value.
PreviousValue	XML	PreviousValue for changed row. Note: For insert operation this value is null.
NextValue	XML	CurrentValue for changed row. Note: For delete operation this value is null.

Stored Procedures:

1. [Administration].[usp_EnableAuditLog]

Description: Enables Audit for database activities.

CREATE PROCEDURE [Administration].[usp_EnableAuditLog]
AS
BEGIN
-- All 3 steps are done in transaction-block.
-- 1. Create IUD trigger on all ARIC tables.
-- 2. Create cleanup job.
-- 3. Set Audit flag to true in database.
END

2. [Administration].[usp_DisableAuditLog]

Description: Disables Audit.

CREATE PROCEDURE [Administration].[usp_DisableAuditLog]

AS
BEGIN

-- Both below steps are done in transaction-block.
-- 1. Delete all IUD triggers which were used for auditing purpose from all the ARIC tables.
-- 2. Delete cleanup job.

-- 3. Set Audit flag to false in database.
END

3. [Administration].[usp_GetAuditLog]

Description: Retrieve log depending on specified input parameters.

CREATE PROCEDURE [Administration].[usp_GetAuditLog]
@TransactionID BIGINT = NULL,
@TableName NVARCHAR(100)= NULL,
@UserName NVARCHAR(100)= NULL,
@StartDate DATETIME = NULL,
@EndDate DATETIME = NULL,
@PageSize INT = NULL,
@PageNumber INT = NULL,
@TotalPages INT OUT

AS
BEGIN

-- This Stored procedure is used by below 4 APIs
-- a. Get all changes
-- b. Get all today’s changes.
-- c. Get all changes for period.
-- d. Get all changes for particular transaction.
-- Retrieves changes entries as per input criteria specified.
-- Entries are returned in pages.
END

4. [Administration].[usp_GetAuditLogEntry]

Description: Retrieves single log information according to AudiLogID.

CREATE PROCEDURE [Administration].[usp_GetAuditLogEntry]
@AuditLogID BIGINT

AS
BEGIN

-- Retrieves single log information according to AudiLogID
END

5. [Administration].[usp_Rollback]

Description: Revert the update change occurred.

CREATE PROCEDURE [Administration].[usp_Rollback]
@AuditLogID BIGINT

AS
BEGIN

-- Reverts the update change occurred.
END

Other Audit Log Fields can be found out by using In built SQL Server functions or DMVs. For example,

TransactionID:

SELECT TRANSACTION_ID FROM SYS.DM_TRAN_CURRENT_TRANSACTION;

ApplicationName:

SELECT program_name FROM sys.dm_exec_sessions WHERE session_id = @@SPID

ObjectID:

Here ObjectID is the tableID in which trigger got fired. We calculated it as follows:

SELECT @ObjectID = parent_id FROM sys.triggers WHERE object_id = @@PROCID;

TSQL:

Here TSQL represents, the query responsible for firing the trigger.

DECLARE @ExecStr NVARCHAR(100);
DECLARE @inputbuffer TABLE
(
          EventType NVARCHAR(MAX),
          Parameters INT,
          EventInfo NVARCHAR(MAX)
)

SET @ExecStr = 'DBCC INPUTBUFFER(' + LTRIM(RTRIM(STR(@@SPID))) + ')'

INSERT INTO @inputbuffer
EXEC (@ExecStr)
SET @TSQL = (SELECT EventInfo FROM @inputbuffer);

OperationID:

SELECT @DeletedCount = COUNT(1) FROM deleted
SELECT @InsertedCount = COUNT(1) FROM inserted
IF @InsertedCount= 0 AND @DeletedCount = 0
       RETURN;
SET @OperationID = CASE WHEN @DeletedCount > @InsertedCount THEN 1 – DELETE
           WHEN @DeletedCount < @InsertedCount THEN 2 -- INSERT
           WHEN @DeletedCount = @InsertedCount THEN 3 -- UPDATE
END

etc…..

~ Kiran

Meeting with Dr. Kakarmath

2009-03-28T06:13:00.000-07:00

Last to last Sunday when I met to Dr. Kakarmath, that was one of the scheduled meeting of Giants International Group.

By the way, I am the member of Giants International Group and Dr. Kakarmath is the president of this group for Kalyan Metro. For last several years, the organization is busy in doing social work, such as helping poor but needy and talented students getting free school books and school dresses, tree plantation on open spaces etc. ( I have mentioned only those activities in which i was involved. Actually there are so many to mention that space here will come short.).

Dr. Kakarmath has been my family doctor for last 10 years. So we have developed good relationship between us. I met him after Giants meeting. In a flow of talk, I just asked him about his dispensary and asked him to come out of the daily paperwork for keeping patients information.(I was knowing the fact that he keeps one file per family and whenever any family member visits his dispensary; he keeps paper, scribbled after checking the patient and prescription given to him, inside it. That is the way, he keeps patients information.). I queried the reason behind not using the software to keep this information. In reply to that, Doctor told me that he was aware of the softwares available in the market but all softwares were meant for the hospitals or for the dispensaries having beds for the patients.

When I see the family doctors in my area, all of them still use diaries or the folders similar to Dr. Kakarmath to keep patients information and their last prescription given. I think small doctors are still away from this Software Revolution. I have promised Dr. Kakarmath to help in this case. and have started working on it. I hope the software which I am implementing will come up as handy tool for him and some of his doctor friends.

As a part of the software, I am done with the database design. And really forcing myself to create a very good UI. I am learning WPF but i think, getting mastery in WPF will take some time. So I will start with Windows Forms only. Some of my friends are also having experience in implementing their own softwares.( obviously in different domain.). Their experiences will guide me to frame user friendly and well presented GUI.

I will keep on posting my experiences on my blog.

~ Kiran

Delete All Databases Except System Databases

2009-03-25T03:12:00.001-07:00

Many times I require to create databases with different configurations for testing purpose.(This includes databases having special characters in their names, databases with different sizes, databases having data files on different locations. etc). As soon as I finish unit testing of the functionality , I have to delete those many databases manually from SQL Server Management Studio.

Today,Two times I had to delete 15 such databases manually :(. But now no more manual work. I have written SQL script for it :)

USE [master]
GO

DECLARE @database_name NVARCHAR (4000);

-- Collect all user created databases into cursor
DECLARE databases_cursor CURSOR FOR
SELECT name FROM sys.databases as d where d.database_id > 4
OPEN databases_cursor

FETCH NEXT FROM databases_cursor
INTO @database_name

WHILE @@FETCH_STATUS = 0
BEGIN
    PRINT 'Dropping Database ' + @database_name
    DECLARE @cmd NVARCHAR(4000);
    SET @database_name = REPLACE(@database_name,']',']]');
    SET @cmd = 'ALTER DATABASE ['+@database_name+'] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; DROP DATABASE ['+@database_name+'];'
    EXECUTE sp_executesql @cmd
    FETCH NEXT FROM databases_cursor
    INTO @database_name
END
CLOSE databases_cursor
DEALLOCATE databases_cursor

KeePass : Password Manager

2009-01-24T03:20:00.000-08:00

I have so many passwords with me for every website I visit. Other than that there are Windows Network login, Net Banking, Gmail, Yahoo, MSN, My Office Email passwords. Hussss...the list is endless. It was really difficult task for me to keep remembering all those passwords. Many of the times, I was dependable on 'Forget Password' link to reset my password and set new one. And you will agree me, it is really boredom task.

Thanks to KeePass. This software has really saved me from this trouble. KeePass is a free open source password manager, which helps me to manage my passwords in a secure way. You can put all your passwords in one database, which is locked with one master key. So you only have to remember one single master password to unlock the whole database.

I am currently using it and very much satisfied with it. :)

These features (http://keepass.info/features.html) and screenshots (http://keepass.info/screenshots.html) will help the first time users.

~ Kiran

Search Engine for Videos!

2009-01-09T22:42:00.000-08:00

Truveo : I was in search for such site so long. Earlier i used to run around video sharing sites (There are so many. YouTube, MySpace, Google Videos, Metacafe etc) for searching any particular video.

This site does this whole thing for me. This search engine lets me find and play videos from all over the web.[:)]

~ Kiran

Animoto!

2009-01-02T23:25:00.000-08:00

There is a lot of fun on the Internet! Animoto is one of them.

This web application turns your pictures into very interesting movie trailers. and you require only 3 steps to get it. Just a) get your images b) get music background and c) provide some details.

The only single problem is you can produce, remix, and share videos freely of 30 second length only. But it is worth to try this out. :)
Here is my first composition.[:D]

10 Minute Mail!

2008-12-29T06:51:00.000-08:00

Today I came across really a fascinating website. 10 Minute Mail.

Many a times you need to provide your email address while downloading any software or file and then respond to a confirmation link to prove it. More often you don’t trust the website or you want to avoid bunch of spam getting after that; you end up not downloading the file\software.

This is the one area the website targets. The website provides you a temporary e-mail address. Any e-mails sent to that address will show up automatically on the web page. You can read them, click on links, and even reply to them. The e-mail address will expire after 10 minutes.

~ Kiran

Online photo editor!

2008-12-23T08:45:00.001-08:00

PiZap is an online photo editor. You can play with some demo photos or upload your own. You can then add text, stickers, change faces and a whole lot more. Here's an example.

~ Kiran

Cut on your arm!!

2008-12-23T08:01:00.000-08:00

Cut anything (lover's name??) you want on your arm!!! Go here

English To Hindi Translation Bots in Google Talk

2008-10-07T22:36:00.000-07:00

Google Talk Team announced translation bots for many languages to help you translate texts using your Google Talk interface. If you don’t know, a bot is a piece of software that acts as a chat contact and provides some fun or useful functionality.
Today morning I added English To Hindi translation bot. It works amazingly.

You should also try this out. You just need to add en2hi@bot.talk.google.com in your gtalk contact list.
The post below will give you more information:
http://teck.in/language-translation-bots-for-google.html
~ Kiran

माझे मराठीला योगदान

2008-09-11T22:50:00.000-07:00

Proud to be Marathi? Yes, Then let us be ready to enrich our language with some new ideas,with some new words.
In our daily routine many times we use english words as is. The website http://www.marathishabda.com/shabda/ is platform to introduce marathi words for them. I have pasted author's preface below as is.

कठीण व उगीचच मोठे असलेले, उदा महाविद्यालय, केशकर्तनालय, मराठी शब्द वापरताना फार त्रास होतो ना? अनेक ईंग्लिश शब्द तर आपण जसेच्यातसे वापारतो. कारण त्यांना पर्यायी शब्दच नाहीत.
तसेच काही वाक्ये वापरताना गोंधळ उडतो. उदा “मी त्याचा वडील आहे” हे योग्य की नाही? मग काय म्हणायला हवे? प्रश्न पडतो..
माझ्या मातृभाषेसाठी मी काहीतरी केले पाहीजे हे नेहमी वाटते ना? चला आपण सगळे मिळून मराठी ला वेगळी ऊंची देउया. ह्या जागेचा वापर करुन आपण ते साध्य करु शकतो.
हे कसे करता येइल ते मी तुम्हाला सांगतो. आपल्याला एखादा शब्द खटकला की, त्याचे मराठी बारसं कसे करायचे त्याचा विचार करायला सुरुवात करायची. एखादा पर्यायी शब्द सापडला की, ह्या जागेवर येउन, तो दान करायचा. समजा तुम्ही आणि ईतरांनीही काही दानं दिली असतील तर, त्या वेळी मी एक मतं चाचणी घेइन. ज्या पहील्या ३ शब्दांना जास्त मते असतील ते शब्द मी आपल्या शब्द संचयात नोंदवेन.
तुम्ही दिलेल्या दानाबद्दल मी तुम्हाला प्रत्येक निवडलेल्या शब्दाला एक दान देणार. ज्यामुळे तुमच्या “योगदाना” खरे मुल्यं सगळ्यांना ह्या जागेच्या माध्यमातुन दिसेल.
आपला एक सामाजिक कट्टा पण आहे. - http://www.marathishabda.com/forum ह्या कट्ट्यावर बरीच दिग्गज मंडळी तुम्हाला भेटू शकतील. तुम्ही त्याच्याबरोबर चर्चा करू शकता. मतं चाचणी सुध्दा ईथेच घेतली जाईल. ह्या कट्ट्यावर जाऊन तुम्हाला एक “वापरू” बनवावा लागेल.
आता प्रश्न राहीला तो नवे शब्द कसे तयार करायचे ह्याचा. हे पहा- कालच मी एक नवीन शब्द वाचला. हा पर्यायी मराठी शब्द कसा वाटतो पहा.

Ghost fishing: पाताळकोळी, भुत्याकोळी
तुम्हीही असे नवीन शब्द सुचवा. आपण सगळे मिळून नवीन मराठी शब्द तयार करू. नवीन शब्द तयार करण्यासाठी मी काही वाटा (Categories) करतोय, उदा, “घरातील शब्द”. आपण इथून सुरूवात करूया. अजुन पुढच्या सुचना मी देइनच.

चला तर या माझ्याबरोबर…

~ Kiran

Mail Forwards!!! - My New Blog!

2008-09-10T04:22:00.000-07:00

This blog will hold all the good forwards i have ever got.
Here is the link for it. Mail Forwards!!!
Watch out for more and more forwards on this blog. They could be helpful to you pleasing your mates.

Online file conversion...

2008-07-30T06:55:00.000-07:00

Zamzar:

You may have come across the situation when you have some files and don't have softwares or utilities to run them. Website Zamzar will help you in that case.
You just need to upload the file you want to convert and choose the format to convert that file to on the Zamzar website. Within few minutes you will get link in your mailbox for accessing the converted file.

~Kiran

पु.ल. च्या फँन्ससाठी खास मेजवानी!

2008-07-29T23:24:00.000-07:00

खाली दिलेली लिंक तुम्हाला पु.ल.च्या बर्‍याचश्या लेखांचे संकलन केलेल्या वेबसाइट वर घेउन जाईल.
येथे क्लिक करा
~ किरण

…and finally I have learnt motorcycling!

2008-07-19T08:20:00.000-07:00

….husssh…and finally I have learnt motorcycling!. Actually it was enjoyable journey while learning it [:)]. I thought, I should share it with you all.

Have you ever watched film award functions?? Whenever any actor wins a title, he gives a long speech to thank all of them whoever have contributed in his success. If the same thing is told me to do then first of all I will thank to traffic police (better word “Mamu” [:)]). Why? Why because he has not caught me yet while driving, even if I don’t have driving license with me.

Jokes apart. But really if somebody forces me to take their names, then I will take Archana’s and Ankit’s name.

I brought up in that family background which has not seen 2 wheeler in its veranda before I buy it.(In last week only, i bought Bajaj Discover). In school-hood, I have learnt cycling. That cycle was the only 2 wheeler we had. But I had not got a chance to learn motorbike.

I should thank Archana for giving me confidence in driving her “Scooty Pept” during traffic peak hours. As I had learnt the cycle, I could balance the vehicle very well but there are some small small things which are necessary while driving; she taught me them. She taught me how to use mirrors while driving and how to use indicator buttons while taking turns and etc.

Ankit helped me knowing details about the “geared” bike. He taught me, how we can control the bike using its clutch and break combination, changing the gears while driving.
One important thing, he trained me to understand bike’s language. [:)]. That makes me identify differences between the noises engine makes while I accelerate and therefore to know whether I should change gear or not.

~ Kiran

Let us conserve water and electricity!

2008-07-17T07:45:00.000-07:00

Today, as soon as i entered into the office and opened my desktop, a mail flashed on my desktop screen. The subject line was "Humble request". and The sender was "Neha Shaikh". I have recieved so many mails from her to help the child or old person immediately for rare blood group. I always feel there is hidden social worker in her. (Later on, i came to know that she is member of "Vanrai" group which activates against tree cutting.)

But today, mail message body was suggesting something different. It was request to all of us to use less water and electricity. The reason for this scarcity of water and electricity was long break in the mansoon leading to reduced water level in dams.

Whatever be the reason of it. But i love Neha's proactiveness making people aware to their responsibilites. I also want to put forward my steps in that direction. I loved the last sentence from her mail “Together we can really make a difference.” :). I am pasting excerpt from her mail:

Hi All,
As we all are aware that there are no rains since last one and a half months and MSEB has planned to begin load shedding program for Pune, we can definitely do something to conserve water and electricity.
This is my humble request for the following:
1) Kindly ask everyone to switch off the machines at EOD if their machine is not a server, if
anybody’s machine needs to be kept on for project requirements then that is an exception.
2) Kindly ask them not to waste water and use only as much as required. Usually we do not consume all the water we fill up in the bottle and the next day we just pour off the water and fill up the bottle again. We can save a plenty amount of water by not doing this.
3) Can we save electricity at office by not using all the tube lights and bulbs and only use only as much as we require?? We can at least keep toilet/pantry lights off and can switch them on
when we need it and again switch them off after the use.
4) Kindly ask people to switch off the conference room lights after the meeting is over. I have observed that people just get out of the room without switching off the lights and the lights are
burning even if there is no one inside the room. We can also ask the people to just burn one light in the conf room while in the meeting.
5) Last but not the least, we can also request people to follow above at home to conserve water and electricity. I would really appreciate if you forward the mail to your friends/relatives.
“Together we can really make a difference.” :)

~ Kiran

Tips for a Successful Technical Presentation

2008-07-01T23:22:00.000-07:00

While surfing the internet, i came across a very good article.
Tips for a Successful Technical Presentation

~ Kiran

Disconnect all users from database

2008-06-04T23:26:00.000-07:00

This is to reply Mohit's comment on my yesterday's post "Forcefully Disconnect All Users and Drop a Database" . I thought it would be nice to have it as new post rather than just a comment.

He had mentioned one scenario where there are times when you just have to disconnect other users from the database. We can acheive it by just killing all the processes connected to that particular database. I have written small stored procedure to do this:

CREATE PROCEDURE dbo.removeConnections
@database_name SYSNAME
AS
BEGIN
DECLARE @spid INT
DECLARE @query NVARCHAR(255)

DECLARE processes CURSOR FOR
SELECT spid FROM master..sysprocesses
WHERE dbid = DB_ID(@database_name)
AND spid != @@SPID

OPEN processes

FETCH NEXT FROM processes
INTO @spid

WHILE @@FETCH_STATUS = 0
BEGIN

PRINT 'KILLing '+RTRIM(@spid)
SET @query = 'KILL '+RTRIM(@spid)
EXEC(@query)

FETCH NEXT FROM processes
INTO @spid

END
CLOSE processes
DEALLOCATE processes
END
GO

~ Kiran

Forcefully Disconnect All Users and Drop a Database

2008-06-03T23:22:00.000-07:00

Yesterday, one of my colleague was telling me that he was not able to delete the database. When I checked the issue at his desk, I saw that other users were connected to that database without his knowledge and hence he was getting error while deleting it.

One way to get rid of it immediately:

ALTER DATABASE MyDatabase
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DROP DATABASE MyDatabase

~ Kiran

Confusing @@VERSION?

2008-05-22T23:09:00.000-07:00

I was confused when i first ran the SELECT @@VERSION query and saw the result out of that query. Try to run the following query in SSMS:

PRINT @@VERSION
GO
PRINT 'Edition: ' + CONVERT(CHAR(30), SERVERPROPERTY('Edition'))
GO
PRINT 'Product Version: ' + CONVERT(CHAR(20), SERVERPROPERTY('ProductVersion'))
GO
PRINT 'Product Level: ' + CONVERT(CHAR(20),SERVERPROPERTY('ProductLevel'))
GO

Result:-
---------------------------------------------------------
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Edition: Enterprise Edition
Product Version: 9.00.3042.00
Product Level: SP2

I have highlighted the confusing part in RED. This is Windows NT Service Pack Level, Not the SQL service Pack Level.

The reason i went to conclusion that the output provided by the query is very detailed one but i guess they missed to include sql server pack infrmation there.[;)]. Anyway we can get that information through SERVERPROPERTY('ProductLevel').

~ Kiran

Want to download YouTube videos???

2008-05-11T02:54:00.000-07:00

There are two very simple ways i see to download YouTube videos.

1. Kiss YouTube way:
If suppose your YouTube URL is something like http://www.youtube.com/watch?v=sdUUx5FdySs. You just need to add word "kiss" in front of the youtube.com in your URI. The page in this modified URL (http://www.kissyoutube.com/watch?v=sdUUx5FdySs) will have the link to save that clip.

2. Keepvid way: http://keepvid.com/
Keepvid is a very good site for downloading videos from any site. On Keepvid's first page, you just need to choose the site you want to download from and copy the link of the page with the video on it and paste it in the textbox provided.

~ Kiran

Car Puzzle!

2008-05-09T09:06:00.000-07:00

Solution:

~ Kiran

RSS In Plain English

2008-05-09T04:40:00.000-07:00

This is really nice video to get to know what really RSS feed means.

~ Kiran

@@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT

2008-05-08T02:06:00.000-07:00

@@IDENTITY, SCOPE_IDENTITY, and IDENT_CURRENT are similar functions because they all return the last value inserted into the IDENTITY column of a table.
@@IDENTITY and SCOPE_IDENTITY return the last identity value generated in any table in the current session. However, SCOPE_IDENTITY returns the value only within the current scope; @@IDENTITY is not limited to a specific scope.
IDENT_CURRENT is not limited by scope and session; it is limited to a specified table. IDENT_CURRENT returns the identity value generated for a specific table in any session and any scope.

More help on msdn.
~ Kiran

Leap Year has not been handled in SQL Server 2008 CTP

2008-05-07T02:36:00.000-07:00

SQL Server 2008 CTP installables were not working on this year's FEB 29. I was using SQL Server 2008 CTP on one of my projects and found the above issue. All the installations worked properly on March 1.
~ Kiran

A Leader Should Know How to Manage Failure

2008-04-23T04:58:00.000-07:00

(Former President of India APJ Abdul Kalam at Wharton India Economic forum , Philadelphia, March 22,2008)
Question: Could you give an example, from your own experience, of how leaders should manage failure?
Kalam: Let me tell you about my experience. In 1973 I became the project director of India's satellite launch vehicle program, commonly called the SLV-3. Our goal was to put India's "Rohini" satellite into orbit by 1980. I was given funds and human resources -- but was told clearly that by 1980 we had to launch the satellite into space. Thousands of people worked together in scientific and technical teams towards that goal.
By 1979 -- I think the month was August -- we thought we were ready. As the project director, I went to the control center for the launch. At four minutes before the satellite launch, the computer began to go through the checklist of items that needed to be checked. One minute later, the computer program put the launch on hold; the display showed that some control components were not in order. My experts -- I had four or five of them with me -- told me not to worry; they had done their calculations and there was enough reserve fuel. So I bypassed the computer, switched to manual mode, and launched the rocket. In the first stage, everything worked fine. In the second stage, a problem developed. Instead of the satellite going into orbit, the whole rocket system plunged into the Bay of Bengal. It was a big failure.
That day, the chairman of the Indian Space Research Organization, Prof. Satish Dhawan, had called a press conference. The launch was at 7:00 am, and the press conference -- where journalists from around the world were present -- was at 7:45 am at ISRO's satellite launch range in Sriharikota [in Andhra Pradesh in southern India]. Prof. Dhawan, the leader of the organization, conducted the press conference himself. He took responsibility for the failure -- he said that the team had worked very hard, but that it needed more technological support. He assured the media that in another year, the team would definitely succeed. Now, I was the project director, and it was my failure, but instead, he took responsibility for the failure as chairman of the organization. The next year, in July 1980, we tried again to launch the satellite -- and this time we succeeded. The whole nation was jubilant. Again, there was a press conference. Prof. Dhawan called me aside and told me, "You conduct the press conference today." I learned a very important lesson that day. When failure occurred, the leader of the organization owned that failure. When success came, he gave it to his team. The best management lesson I have learned did not come to me from reading a book; it came from that experience.

Difference between Focusing on Problems and Focusing on Solutions

2008-01-23T03:03:00.000-08:00

Difference between Focusing on Problems and Focusing on Solutions

Case 1

When NASA began the launch of astronauts into space, they found out that the pens wouldn't work at zero gravity (ink won't flow down to the writing surface). To solve this problem, it took them one decade. They developed a pen that worked at zero gravity, upside down, underwater, in practically any surface including crystal and in a temperature range from below freezing to over 300 degrees C.

And what did the Russians do...?? …………………………………………………..They used a pencil.

Case 2

One of the most memorable case studies on Japanese management was the case of the empty soapbox, which happened in one of Japan's biggest cosmetics companies. The company received a complaint that a consumer had bought a soapbox that was empty. Immediately the authorities isolated the problem to the assembly line, which transported all the packaged boxes of soap to the delivery department. For some reason, one soapbox went through the assembly line empty. Management asked its engineers to solve the problem. Post-haste, the engineers worked hard to devise an X-ray machine with high-resolution monitors manned by two people to watch all the soapboxes that passed through the line to make sure they were not empty. No doubt, they worked hard and they worked fast but they spent a whoopee amount to do so.
But when a rank-and-file employee in a small company was posed with the same problem, he did not get into complications of X-rays, etc., but instead came out with another solution. He bought a strong industrial electric fan and pointed it at the assembly line. He switched the fan on, and as each soapbox passed the fan, it simply blew the empty boxes out of the line.

Moral: "Always look for simple solutions,
Devise the simplest possible solution that solves the problems"

~ Kiran

Tumko Paya Hai To Jaise Khoya Hoon Kehna Chahoon Bhi To Tumse Kya Kahon

2007-09-30T04:16:00.000-07:00

When I first heard this song on SA RE GA MA PA, I just got mad after its lyrics. Aunik sung that with tremendous feelings...
I could not resist myself from hearing the original song... I guess this is one more masterpiece from sonu...
What awsome lyrics...and What a awsome song...

Here it goes:

Song : Main Agar Kahoon
Music : Vishal-Shekhar
Lyrics : Vishal Dadlani-Javed Akhtar & Kumaar
Singers : Sonu Nigam, Shreya Goshal

Tumko Paya Hai To Jaise Khoya Hoon
Kehna Chahoon Bhi To Tumse Kya Kahon
Tumko Paya Hai To Jaise Khoya Hoon
Kehna Chahoon Bhi To Tumse Kya Kahon

Kisi Zabaon Mein Bhi Woh Labaz Hi Nahi
Ki Jeene Mein Tum Ho Kya Tumhein Mein Bata Sakun

Main Aagar Kahoon Tumsa Haseen
Kaynaat Mein Nai Hai Kahin
Tareef Yeh Bhi To Sach Hai Kuch Bhi Nahi
Tumko Paya Hai To Jaise Khoya Hoon..

Shokhiyon Mein Dooobi Yeh Aadayein
Chehre Se Jhalki Hui Hain
Zulf Ki Ghani Ghani Ghatayein
Shaan Se Dhalki Hui Hain
Lehrata Aachal Hai Jaise Badal
Bhaahon Mein Bhari Hai Jaise Chandani
Roop Ki Chandani

Main Agar Kahoon Yeh Dilkashi
Hai Nahi Kahin Na Hogi Kabhi
Tareef Yeh Bhi To Sach Hai Kuch Bhi Nahi
Tumko Paya Hai To Jaise Khoya Hoon..

Tum Hue Meherbaan
To Hai Yeh Dastan
Hoo Tum Hue Meherbaan
To Hai Yeh Dastan
Abb Tumhara Mera Ek Hai Karwaan
Tum Jahan Mein Wahan

Main Agar Kahoon
Humsafar Meri
Apsara Ho Tum Ya Koi Pari

Tareef Yeh Bhi To Sach Hai Kuch Bhi Nahi
Tumko Paya Hai To Jaise Khoya Hoon..
Kehna Chahoon Bhi To Tumse Kya Kahon

Kisi Zabaon Mein Bhi Woh Labaz Hi Nahi
Ki Jeene Mein Tum Ho Kya Tumhein Mein Bata Sakun

Main Aagar Kahoon Tumsa Haseen
Lyricsmasticom
Kaynaat Mein Nai Hai Kahin
Tareef Yeh Bhi To Sach Hai Kuch Bhi Nahi
Tumko Paya Hai To Jaise Khoya Hoon…

~ Kiran

Good web link differentiating CLR and JVM

2007-06-08T23:35:00.000-07:00

http://www.itwriting.com/dotnet4.php#jvm

~ Kiran

Choose your side...

2007-05-09T23:16:00.000-07:00

Binary People - There are 10 types of people in the world: Those who understand binary, and those who don't...

Even a stopped watch is right... Twice a day!!!

2007-01-15T00:11:00.000-08:00

Never cry for any relation in life
Because for the one whom you cry
Does not deserve your tears
And the one who deserves
Will never let you cry......... ........

Treat everyone with politeness
Even those who are rude to you,
Not because they are not nice
But because you are nice........ ......... ......

Never search your happiness
In others
Which will make you
Feel alone,
Rather search it in yourself
You will feel happy
Even if you are left alone....... ......... ......

Always have
A positive attitude in life.
There is something positive
In every person.
Even a stopped watch is right
Twice a day......... .........

Amazing Magician!!!!

2007-01-07T20:57:00.000-08:00

Amazing magic Trick , Great illusionism ...

courtesy : youtube.com

I am alive!!

2007-01-05T03:47:00.000-08:00

This is just to inform you guys.....I am alive....I was pretty busy with my work!!! sonner some stuff will arrive :)

~ Kiran

Superb Ad!!

2006-12-22T05:30:00.000-08:00

Superb Advertisement- shows popularity and respect for Gandhi'ji, A great ad.... Ironically from a non- Indian company!!
This ad won the EPICA awards for best ad.

See Advertisement

About Google Code Search

2006-11-02T22:02:00.000-08:00

Google Code Search helps you find function definitions and sample code by giving you one place to search publicly accessible source code hosted on the Internet. With Google Code Search, you can:

* Use regular expressions to search more precisely
* Restrict your search by language, license or filename
* View the source file with links back to the entire package and the webpage where it came from
Want to read more...

Live Local

2006-10-31T22:09:00.000-08:00

If you want to have route between two cities on the map, Use Live.Com site.

Route between Pune and Kalyan

SQL Server Lesson 2 : sp_refreshview system stored procedure

2006-10-26T00:42:00.000-07:00

When a new column is added to a table being referenced by a view, the new column will not automatically be reflected to the view, especially if the view is doing a SELECT * from the table.

For the new column to be reflected on the view, you have to refresh the definition of the view using the sp_refreshview system stored procedure. The sp_refreshview system stored procedure refreshes the metadata for the specified view.

Let us check this by example.

Create Table Customers:
CREATE TABLE [dbo].[Customers] (
[CustomerID] INT,
[CustomerName] VARCHAR(100),
[Address] VARCHAR(100)
)

INSERT INTO [dbo].[Customers] VALUES(100, 'Kiran Marke', 'Kalyan');
INSERT INTO [dbo].[Customers] VALUES(101, 'Ankit Jain', 'Ahmedabad');

CREATE VIEW [dbo].[CustomersView]
AS
SELECT * FROM [dbo].[Customers]

Now just do this
SELECT * FROM [dbo].[CustomersView]

This will give all records from the view with all the columns of [dbo]. [Customers] table.

Now let's add one more column to to above table
ALTER TABLE [dbo].[Customers] ADD [Gender] CHAR(1)
UPDATE [dbo].[Customers] SET [Gender] = 'M'

Now once again perform SELECT * FROM [dbo].[CustomersView]

This view will not include the new [Gender] column in the output.
EXECUTE sp_refreshview '[dbo].[CustomersView]'
After issuing this statement, the view will now include the new [Gender] column in the output.

Google helps you build your own search engine

2006-10-24T23:05:00.000-07:00

Google is opening up its vast online index so other web sites can build their own specialty search engines.
Check on this link: http://www.google.com/coop/cse/

FileInfo Class Properties

2006-10-19T07:19:00.000-07:00

Interestingly, the creation time, last access time and then last write time properties are all writable:

For example:
FileInfo f = new FileInfo(@"C:\MyFile.txt");
Console.WriteLine(f.CreationTime.ToString());
f.CreationTime = new DateTime(2001, 1, 1, 7, 30, 0);
Console.WriteLine(f.CreationTime.ToString());

Reason given behind this is(Which is quite good also):

If you have a program that effectively modifies a file by simply reading it in, then deletingit and creating a new file with the new contents, then you’d probably want to modify the creation date tomatch the original creation date of the old file.

SQL Server Shortcut keys.......

2006-10-16T23:25:00.000-07:00

Bookmarks: Clear all bookmarks. CTRL-SHIFT-F2
Bookmarks: Insert or remove a bookmark (toggle). CTRL+F2
Bookmarks: Move to next bookmark. F2
Bookmarks: Move to previous bookmark. SHIFT+F2
Cancel a query. ALT+BREAK
Connections: Connect. CTRL+O
Connections: Disconnect. CTRL+F4
Connections: Disconnect and close child window. CTRL+F4
Database object information. ALT+F1
Editing: Clear the active Editor pane. CTRL+SHIFT+ DEL
Editing: Comment out code. CTRL+SHIFT+C
Editing: Copy. You can also use CTRL+INSERT. CTRL+C
Editing: Cut. You can also use SHIFT+DEL. CTRL+X
Editing: Decrease indent. SHIFT+TAB
Editing: Delete through the end of a line in the Editor pane. CTRL+DEL
Editing: Find. CTRL+F
Editing: Go to a line number. CTRL+G
Editing: Increase indent. TAB
Editing: Make selection lowercase. CTRL+SHIFT+L
Editing: Make selection uppercase. CTRL+SHIFT+U
Editing: Paste. You can also use SHIFT+INSERT. CTRL+V
Editing: Remove comments. CTRL+SHIFT+R
Editing: Repeat last search or find next. F3
Editing: Replace. CTRL+H
Editing: Select all. CTRL+A
Editing: Undo. CTRL+Z
Execute a query. You can also use CTRL+E. F5
Help for SQL Query Analyzer. F1
Help for the selected Transact-SQL statement. SHIFT+F1
Navigation: Switch between query and result panes. F6
Navigation: Switch panes. Shift+F6
Navigation: Window Selector. CTRL+W
New Query window. CTRL+N
Object Browser (show/hide). F8
Object Search. F4
Parse the query and check syntax. CTRL+F5
Print. CTRL+P
Results: Display results in grid format. CTRL+D
Results: Display results in text format. CTRL+T
Results: Move the splitter. CTRL+B
Results: Save results to file. CTRL+SHIFT+F
Results: Show Results pane (toggle). CTRL+R
Save. CTRL+S
Templates: Insert a template. CTRL+SHIFT+INSERT
Templates: Replace template parameters. CTRL+SHIFT+M
Tuning: Display estimated execution plan. CTRL+L
Tuning: Display execution plan (toggle ON/OFF). CTRL+K
Tuning: Index Tuning Wizard. CTRL+I
Tuning: Show client statistics CTRL+SHIFT+S
Tuning: Show server trace. CTRL+SHIFT+T
Use database. CTRL+U

Thanks Microsoft@persistent Team

2006-10-03T21:11:00.000-07:00

Thanks Microsoft@persistent team for celebrating my birthday. :)

29th September: My Birthday

2006-10-03T07:30:00.000-07:00

Rushit and company made 29th September, 2006 memorable for me.

On 28th September, I went home early as I had no work pending in the office. I was looking for partner for dinner, but couldn’t find anyone. So went alone. When I came home after dinner, no one was at home. I just got surprised because they all should have been there at home, as they also had left office early like me.

As there was no one at home to chat, there were only two options available with me. One was watching TV and another was to have some study. I preferred watching TV. But I was just busy surfing TV channels as none of the channels had any good program available. It was that kind of boring life, I had that day.

But I was totally unaware of some memorable moments were waiting for me in next half an hour. At 11:30pm Rajesh, Rakesh, and Kiran entered room. Vijayendra, Rushit and Preeti followed them. I cut a cake on exact stroke of 12:00 am and everybody cheered with birthday song.

That was totally embarrassing situation for me, when everybody just attacked on me to give birthday- bumps. But I really enjoyed them also.

This was followed by photo-session to catch “my good looking face” ;) which was covered with the cake I cut. I tried to smile, but the same time was not able to hide very sorrow reactions after getting those free kicks by my friends.

That was really wonderful night, I spent with my friends.

SQL Server Lesson :1

2006-09-27T05:44:00.000-07:00

If any user-created stored procedure has the same name as a system stored procedure, the user-created stored procedure will never be executed.

That is:

USE Kiran_DB
GO
CREATE PROCEDURE sp_who
AS
PRINT 'Some Text'
GO
EXECUTE sp_who

Will not print the above text.

This will still return information about current SQL Server users and processes.

My First Post

2006-09-17T01:51:00.000-07:00

Everyone's personality is determined by a combination of the genetic and the environmental factors.

Following are the words I learned yesterday(Date- 16-09-2006), which shows different personality types.

1. An Egoist:

Every decision you make is based on the following answer: "What is there for me?"

2. An Egotist:
You always talk aboult your own accomplishments.
3. An Altruist:
You are always interested in welfare of others.
4. An Introvert:
--- Leave me alone type attitude.
You may seem unsocial, yet your greatest desire is to be likedand accepted.
You may be shy and quiet, often moody and unhappy and you prefer solitude or at most company of one person
to a crowd.
5. An Extrovert:
--- Let's do it together type attitude.
Your thoughts, your interests, your whole personality are turned outwords.
6. An Ambivert:
You are at neither extremes. You have both introverted and extroverted tendencies.
7. An misantrope:
You hate everyone.
8. An misogynist:
You hate women.In ur past, you deeply wounded by a women, so u always avoid going across against woman.
9. An misogamist:
You hate marriage.
10. An ascetic:
You practices self denial as a spiritual discipline.

Hi Friends,

2005-11-20T20:37:00.000-08:00

So........ I started Blogging.