Search This Blog

Tuesday, December 17, 2013

Brain Teaser Series - The Chocolate Shop!!

Everyone loves candies and chocolate. It’s even more fun when you can some free ones.


Here is puzzle for you.


A candy shop sells a chocolate for $1 each and for every 3 empty wrappers gives one chocolate. How many chocolates can you get for $15?


Enjoy!!



Brain Teaser Series - The Chocolate Shop!!

Friday, December 6, 2013

Exuberant India - Visit Mussoorie (Fun Retreat in a Hillstation Close to Delhi)

Mussoorie, Queen of the Hills, located some 290 km north of New Delhi, is among the most popular hill stations of the country. At 6500 feet elevation, it has some of the most spectacular views of Himalayas. Some of the landmarks of this popular hillstation are the old graceful houses – Captain Young’s Mullingar Mansion, the oldest existing building in Mussoorie, Houses of Irish pioneers – Tipperary, Killarney, Shemrock cottage and the Tara hall, the houses of Scot pioneers – Scottsburn, Wolfsburn and of course the houses of the English rulers – Connaught Castle, Grey castle, Hampton court and Castle hill. There evidently were a lot of fans of the legendary writer Sir Walter Scott as we find old estates of the name of Kenilworth, Rockeby, Waverly and also Abootsford – the name of Sir Scott’s own house in England.


Mussoorie has lot to offer and fun retreat for a quick getaway from Delhi.





How to get there:


travel-plane


Air: The nearest airport is Jolly Grant at Dehradun (61 km). However, Delhi is the most convenient airport.


travel-rail


Rail: The nearest railhead is Dehradun 35 km, connected by rail with major cities and towns of India. Taxis and buses are available outside the railway station for transit to Mussoorie, there is a Mussoorie bus stand near the station.


travel-icon


Road: < 300 KM from Delhi. You can drive, take a bus or private cab to get there.


Where to Stay:


Here is a list of some of the good hotels in the area


Jaypee Residency Manor*****dlx,

Barlowganj,

Tel: 0135 2631800,

Fax: 2631022,

E-mail: reservations.jrm@jaypeehotels.com


Savoy Hotel (Heritage),

The Mall,

Tel: 0135 2632010/120,

Fax: 2632001,

E-mail: savoyhotelmussoorie@yahoo.com

(Rs. 1500-5000/-)


Country Inn Mussoorie***,

Nalapani House,

Hayacoolie Estate, Kincraig,

Telefax: 2631190/4,

E-mail: info@countryinn.co.in


Hotel Green Castle***,

The Mall,

Tel: 0135 2630987,

Telefax: 2632657,

E-mail: greencastle@vsnl.com


Hotel Solitaire Plaza***,

Kincraig Road,

Tel: 0135 2632164/5,

Fax: 2632147


What to do:


Sightseeing:



Cloud’s End

The resort is surrounded by thick deodar forests. The bungalow built in 1838 by a British major and one of the first four buildings of Mussoorie, has now been converted into a hotel.




Camel’s Back Road

A lovely promenade along the wooded slopes.


Children’s Lodge 

A vantage point of Mussoorie, with extensive views of the northern hill ranges.




Gun Hill 

The second highest point in the town, it offers a panoramic view of the surroundings and the snow covered mountains in the north.


You can find more information at the state site: http://uttarakhandtourism.gov.in/sections/mount_places/ZjY0ZjZhhnE1NHNkZg==/ZjY0ZjZoc2RmYTU=




Exuberant India - Visit Mussoorie (Fun Retreat in a Hillstation Close to Delhi)

Monday, December 2, 2013

Rebuild all index in a database

Several times my colleagues asked me about rebuilding all indices in a database. While there are several solution available, I like to use the one below. Please note that sp_MSforeachtable is undocumented but internal so we can expect a much better performance than our own cursor.


None the less, this has helped me alot, I hope it helps you too!!


 


USE <DBName>

GO

EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’, ‘ ‘, 80)”

GO

EXEC sp_updatestats

GO



Rebuild all index in a database

Friday, November 29, 2013

Finding the Nth highest value in a table

I recently was asked by a colleague about finding the  Nth highest value in a table. For example if there is an employee table then finding the 10th highest salary or something similar.


I thought about it and created a query below which obviously is not showing anyone’s salary :) but shows how we can implement it.


Enjoy! and please comment.


declare @nth smallint


set @nth = 4


if (@nth <= 0)

begin

– default to 1 if inappropriate value is provided

set @nth = 1

end


set nocount on;


declare @t table (Id int identity(1, 1), Value decimal(18, 3))

insert into @t (Value) values (1234.56)

insert into @t (Value) values (5678.90)

insert into @t (Value) values (2345.67)

insert into @t (Value) values (3456.78)

insert into @t (Value) values (6789.10)

insert into @t (Value) values (7890.12)

insert into @t (Value) values (8912.34)

insert into @t (Value) values (4567.89)


select [Value] = max([t1].[Value])

from @t [t1]

left join (select top (@nth – 1) [Value]

from @t

order by value desc) [t2] on [t2].[Value] = [t1].[Value]

where [t2].[Value] is null


select [OrderId] = ROW_NUMBER() over (order by value desc)

, [Value] = value

from @t


set nocount off



Finding the Nth highest value in a table

Friday, November 8, 2013

Experience with MS SQL Server

After years of experience with SQL server, I have gathered some of the practices that are good for writing SQL queries, procedures and functions.

Here is my work as presentation, enjoy!!

Monday, October 7, 2013

Devil's Circuit

On 6th October 2013, Delhi region saw and experienced Devil’s Circuit, India’s First Obstacle Run Non Competitive Series. People looking for some adventure and fun, wanted to spend their Sunday in a different way soaked themselves up in mud, freezing water, climbed ropes and walls.. yesterday was for them!!! The day saw participants from various walks of life, students, young professionals, foreign nationals, families…just about everyone!!! The spirit of the participants was amazing!! After the race all the participants who completed the race got a beer(for refreshing yourself :) ), Devil’s T-Shirt and an energy drink and of course a medal upon completion. Live music playing throughout the circuit kept the crowd and participants cheered up!!


You could google for pictures of the event and get prepared for the next Devil’s Circuit. For those of you who missed participating in this one, there’s another one scheduled in March 2014 in NCR, followed by next one in Pune, then Hyderabad and finally in Bangalore!!!


Go ahead and have some fun….



Devil's Circuit

Wednesday, October 2, 2013

SQL Server Fun - Averages with Rollup

Here is tsql way of getting averages and also rolling up. Below example is using adventureworks database that is available with SQL server. It is getting average pay rate by each department and also overall by the company.


use [AdventureWorks]

select[Department] = case when grouping(d.GroupName) = 1 then ‘Company Average’

                              else d.GroupName end,

            [Average Pay Rate] = avg(p.Rate)

from (select [EmployeeID], [Rate] = max([Rate])

            from [HumanResources].[EmployeePayHistory]

            group by [EmployeeID]) p

      inner join [HumanResources].[EmployeeDepartmentHistory] h

                  on h.[EmployeeID] = p.[EmployeeID] and h.[EndDate] is null

      inner join [HumanResources].[Department] d on d.[DepartmentID] = h.[DepartmentID]

group by d.[GroupName]

with rollup

order by 1


SQL Server Fun - Averages with Rollup

Monday, September 30, 2013

My PMI 2013 conference experience – Healthcare in India

I recently attended the PMI 2013 National Conference hosted at “The Leela” Gurgaon. It was indeed a grand event that I enjoyed thoroughly. I was particularly intrigued by the presentation in the field of Healthcare in India from the Fortis group CEO Vishal Bali. Having the background in the field and experienced in the international market at the USA, I am really excited about the opportunities in this Sector in India.


Healthcare is directly or indirectly linked with the economic growth of the country, while it directly produces opportunity for healthcare professionals, it indirectly creates lot of opportunity in other fields like management, IT etc. Not only that, it helps in increasing the life expectancy thereby the overall working task force in the economy. While that is for the global vision, I am concerned about specifics in the healthcare industry in India. There is a lot to be done and opportunity to learn from the systems in other countries – what was done right and what can be done better.


I am particularly interested in hearing from the industry experts about topics like – Preventive care, Diagnosis standardization, Patient centric approach with information sharing and the most talked about topic for all insurance companies – fraud prevention.


These are some of the burning topics especially in healthcare in India.  I have had some experience of working in these areas and seen both the good and the bad of systems.


Looking forward to hear from some of the experts….



My PMI 2013 conference experience – Healthcare in India

Wednesday, September 25, 2013

Brain teaser series....Candy Jar

Find the right candy jar…


Who does not love candy? I always loved those colorful candies but I liked that one colored candy. Now I got red candy and blue candy but I like to get the red one, here is my trouble. There are 3 jars (not transparent) that are mislabeled, one jar has red candy, one has blue candy and one has a mix. Now the mix is not necessarily 50-50, it could be any ratio. I have to blindly pick candy from the jars and find out which jar has which type of candy in the minimal possible turns. How many turns are needed to find out which Jar has what candy?


Did you know that red jelly beans are kid’s favorite. Have fun :)


Brain teaser series....Candy Jar

Tuesday, September 24, 2013

Saloon... Not to Visit!!!!

We had a wedding in the family and had to visit the saloon for touch up’s! :) My regular saloon was closed that day so I ended up going to another one nearby! And I should mention that I went along with my MIL(mother-in-Law),  who is pretty easy going lady I must say!


Anyways, so we went to this saloon and here are the reasons I wouldn’t recommend ANYONE going there


- Hygiene Levels are POOR and


- Value for Money is ZERO!!


The saloon is narrow vertical shape and space is to cramped that it will be difficult not to rub yourself against the other person while moving from the entrance to the chair where I had to sit down for the services! I had to get myself arm waxing and pedicure to get some relief to my usual aching swollen feet due to pregnancy! The saloon ladies were trying to upsell all their services by suggesting better quality products, which I would say is a part of their job so I really don’t mind that. However, the point from where the bad experience started was the hygiene levels were pretty bad. Instead of using a warm wet towel to clean the arms after waxing they used a cloth and it seemed that that cloth was already used on someone!! Eww!!! Further,  I had asked them to apply astringent on my arms after waxing to close the open pores and they had never heard of this concept!! Not sure which place they were trained from!


Now let us come to value for Money! My MIL was getting a facial and pedicure done and as expected they were successful in upselling the facial with some add on’s for better results. The Add on’s  as they suggested did not really make much of the difference in the results as they had said, moreover the standards to do the pedicure for me and my MIL(we opted for same pedicure) were totally different in terms of the products they used! They also claimed that the pedicure we opted included message for 40 mins. Mine was done in 40 mins however; my MIL’s was completed in 15 mins flat! Not worth the value of ur money and time!


 


The saloon is based in Dwarka Sector -11 and goes by the name of “Elegant Looks Ladies Beauty Parlor”!


 


Share your views if anyone else had similar experience!!


 


 



Saloon... Not to Visit!!!!

Business Intelligence (BI)

What is business Intelligence

I am sure a lot of people can define business intelligence but what we need to know is how it applies to us our business, our life and things we do. Over the last few decades, we have collected data and we probably have overwhelming data about a person, from financial records to personal email, phone records etc. While this information is useful for your own records it provides a vast scope for someone in the field of offering services or goods a great opportunity to find out what they can launch or produce.


While this is a short example and a survey could do that but have you ever thought of magic. While magical tricks (are tricks) and some are really sophisticated, business intelligence is the magic for this data. Data is any piece entered into a system but when we interpret it, it becomes information. When this goes beyond a regular interpretation, business intelligence comes into play.


Have you ever thought about this if the person entering next in the car dealership will buy the car or not? Well, if you are into sales there, you know the other brain tricks (that I will talk about in another topic) but you wish you knew so you could spend your time appropriately. Well based on the vast data that we have, a simple survey may be a tool that could give you the answer with pretty high confidence. For example, how many car this person already own, is he / she a house owner? how many children? etc.


Business intelligence is not about what we can see but what we cannot see. With that said, here is my introduction to BI.


Would love to get some feedback and comments…


Business Intelligence (BI)

Saturday, September 21, 2013

How to get Windows Folder sizes recursively

Ever need to know the folder sizes that has several sub-folders, windows explorer takes really long time and requires checking properties of each folder.


This script will do the job just need excel installed on your machine


Creates a clean excel sheet



‘ PLEASE NOTE THAT YOU WOULD NEED EXCEL INSTALLED ON YOUR MACHINE


Dim oFS, oFolder

Dim objexcel, r, lnameArray, lname, nameLength

set oFS = WScript.CreateObject(“Scripting.FileSystemObject”)

set oFolder = oFS.GetFolder(“D:\GE”)

Set objExcel = createobject(“Excel.application”)

objexcel.Workbooks.add

objexcel.Cells(1, 1).Value = “Folder Path”

objexcel.Cells(1, 2).Value = “Folder Name”

objexcel.Cells(1, 3).Value = “Size (MB)”

objexcel.Cells(1, 4).Value = “# Files”

objexcel.Cells(1, 5).Value = “# Sub Folders”

objexcel.Visible = True

Wscript.Sleep 300

r=2


ShowFolderDetails oFolder, r


‘    objexcel.ActiveWorkbook.SaveAs(“LogonReport.xls”)

‘    objexcel.Quit

MsgBox “Done”


Function ShowFolderDetails(oF,r)

Dim F

objexcel.Cells(r, 1).Value = oF.Path

objexcel.Cells(r, 2).Value = oF.Name

objexcel.Cells(r, 3).Value = oF.Size /1024\1024

objexcel.Cells(r, 4).Value =  oF.Files.Count

objexcel.Cells(r, 5).Value =  oF.Subfolders.count

r = r+1

for each F in oF.subfolders

ShowFolderDetails F, r

next

End Function




How to get Windows Folder sizes recursively

SQL Server FUN - Split received string using XML


Several time, we have a need to split the string based on a delimiter, for instance to handle multiple input filter parameters etc.


Most of the time we end up using a user defined function that accepts a string and a delimiter and returns a table of split values. Function may be in-efficient at times.


Here is an XML way to split the input string and get a result within a table



declare @xml as xml


,@str as varchar(100)


,@delimiter as varchar(10)


set @str=’A,B,C,D,E’


set @delimiter =’,’


set @xml = cast((‘<X>’ + replace(@str, @delimiter, ‘</X><X>’) + ‘</X>’) as xml)


select N.value(‘.’, ‘varchar(10)’) as value from @xml.nodes(‘X’) as T(N)





SQL Server FUN - Split received string using XML

SQL Server FUN - Identity insert

Insert in identity column for a table


Sometimes there is a need to insert data into a table that has identity column. Example when you would like to restore a table from a backup including the same IDs so integrity is maintained. Here is simple script

–set identity insert on

set identity_insert <table_name> on


–set identity insert off

set identity_insert <table_name> off

 



SQL Server FUN - Identity insert

One of the all time technology world buzz word - "Lean"

I decided to find it little more about it. A new term has been coined, Lean software development. Well the work and definition below is from various sites and sources on internet. I would like to thank them and not claim this is my work. This is to insitgate discussion and blog the very purpose of having this site.


Lot of you may know about Sixsigma, this is kind of an extension, here is what I found. Looking forward to get some feedback.


Lean software development is a translation of lean manufacturing principles and practices to the software development domain. Adapted from the Toyota Production System, a pro-lean subculture is emerging from within the agile community.


Eliminate waste

  • unnecessary code and functionality

  • delay in the software development process

  • unclear requirements

  • bureaucracy

  • slow internal communication

Amplify learning

Software development is a continuous learning process with the additional challenge of development teams and end product sizes. The best approach for improving a software development environment is to amplify learning. The accumulation of defects should be prevented by running tests as soon as the code is written. Instead of adding more documentation or detailed planning, different ideas could be tried by writing code and building. The process of user requirements gathering could be simplified by presenting screens to the end-users and getting their input.

The learning process is sped up by usage of short iteration cycles – each one coupled with refactoring and integration testing. Increasing feedback via short feedback sessions with Customers helps when determining the current phase of development and adjusting efforts for future improvements. During those short sessions both Customer representatives and the development team learn more about the domain problem and figure out possible solutions for further development


Decide as late as possible

As software development is always associated with some uncertainty, better results should be achieved with an options-based approach, delaying decisions as much as possible until they can be made based on facts and not on uncertain assumptions and predictions. The more complex a system is, the more capacity for change should be built into it, thus enabling the delay of important and crucial commitments.

An agile software development approach can move the building of options earlier for customers, thus delaying certain crucial decisions until Customers have realized their needs better. This also allows later adaptation to changes and the prevention of costly earlier technology-bounded decisions. This does not mean that no planning should be involved – on the contrary, planning activities should be concentrated on the different options and adapting to the current situation, as well as clarifying confusing situations by establishing patterns for rapid action.


Deliver as fast as possible

In the era of rapid technology evolution, it is not the biggest that survives, but the fastest. The sooner the end product is delivered without considerable defect, the sooner feedback can be received, and incorporated into the next iteration. The shorter the iterations, the better the learning and communication within the team. Without speed, decisions cannot be delayed. Speed assures the fulfilling of the Customer’s present needs and not what they required yesterday. This gives them the opportunity to delay making up their minds about what they really require until they gain better knowledge. Customers value rapid delivery of a quality product.

The Just-in-Time production ideology could be applied to software development, recognizing its specific requirements and environment. This is achieved by presenting the needed result and letting the team organize itself and divide the tasks for accomplishing the needed result for a specific iteration. At the beginning, the Customer provides the needed input. This could be simply presented in small cards or stories – the developers estimate the time needed for the implementation of each card.


Empower the team

There has been a traditional belief in most businesses about the decision-making in the organization – the managers tell the workers how to do their own job. In a Work-Out technique, the roles are turned – the managers are taught how to listen to the developers, so they can explain better what actions might be taken, as well as provide suggestions for improvements. Most experienced project managershave simply stated the key for a successful project – “Find good people and let them do their own job.”

Another mistaken belief has been the consideration of people as resources. People might be resources from the point of view of a statistical data sheet, but in software development, as well as any organizational business, people do need something more than just the list of tasks and the assurance that they will not be disturbed during the completion of the tasks. People need motivation and a higher purpose to work for – purpose within the reachable reality, with the assurance that the team might choose its own commitments. The developers should be given access to Customer; the team leader should provide support and help in difficult situations, as well as make sure that skepticism does not ruin the team’s spirit.


Build integrity in

The Customer needs to have an overall experience of the System – this is the so called perceived integrity: how it is being advertised, delivered, deployed, accessed, how intuitive its use is, price and how well it solves problems.

Conceptual integrity means that the system’s separate components work well together as a whole with balance between flexibility, maintainability, efficiency, and responsiveness. This could be achieved by understanding the problem domain and solving it at the same time, not sequentially. The needed information is received in small batch pieces – not in one vast chunk with preferable face-to-face communication and not any written documentation. The information flow should be constant in both directions – from Customer to developers and back, thus avoiding the large stressful amount of information after long development in isolation.

Automated tests are also considered part of the production process, and therefore if they do not add value they should be considered waste. Automated testing should not be a goal, but rather a means to an end, specifically the reduction of defects.


See the whole

Software systems nowadays are not simply the sum of their parts, but also the product of their interactions. Defects in software tend to accumulate during the development process – by decomposing the big tasks into smaller tasks, and by standardizing different stages of development, the root causes of defects should be found and eliminated. The larger the system, the more organizations that are involved in its development and the more parts are developed by different teams, the greater the importance of having well defined relationships between different vendors, in order to produce a system with smoothly interacting components. During a longer period of development, a stronger sub- contractor network is far more beneficial than short-term profit optimizing, which does not enable win-win relationships.

Lean thinking has to be understood well by all members of a project, before implementing in a concrete, real-life situation. “Think big, act small, fail fast; learn rapidly” – these slogans summarize the importance of understanding the field and the suitability of implementing lean principles along the whole software development process.


One of the all time technology world buzz word - "Lean"

Thursday, September 5, 2013

Another Brain Teaser - Coins puzzle - probability

Flip the coin…

I always loved those coin tricks and wondered how it happened. While making the coin magically disappear is definitely a mind trick (will talk about that too) but the coin flipping is mathematical. Here is an easy one, I flipped two quarter-coins and immediately announced that one came out as head. What is the chance that the second coin will also be a head?

If you were in Las Vegas would you bet on head or tail for the second coin? Have fun :)



Another Brain Teaser - Coins puzzle - probability

Monday, September 2, 2013

Jargons used at work place that need to go away.....what do you think

Jargons commonly used at workplace that seem to provide no value and may be repetitive and frustrating for others….


What do you think?


  1. Low hanging fruit

  2. Touch base

  3. No Brainer

  4. Think outside the box

  5. End of day or close of business

  6. When rubber hits the road

  7. Win-win

  8. Touch points

  9. Below the radar

  10. Drill down


Jargons used at work place that need to go away.....what do you think

Sunday, September 1, 2013

Puzzle: Run for your life...

Mr. Joy enjoys some risk and likes to explore the nearby area. In the beautiful surrounding there is a train track that goes through a mysterious tunnel. One fine morning Mr. Joy decided to take a walk through the tunnel. While Mr. Joy was 1/4 way on the tunnel, he hears the train whistle. A quick thinker Mr. Joy calculates that if he runs back he would just make it out of the tunnel before train gets in the tunnel and if he runs forward he will just make it out of the tunnel before train hits him. While Mr. Joy saved his life, he left you with a problem, how fast was this train travelling compare to Mr. Joy?


This is old school physics problem with all basic assumptions for this kind of puzzle. Assume Mr. Joy can run with same speed in both direction. He can accelerate to his top speed right away. Train barely misses him if he would run in either direction


Looking forward to see some solution(s)



Puzzle: Run for your life...

Thursday, August 29, 2013

Gastronomy Delight Of Delhi

 


Delhi has been long time been known as the food Capital of India. Delhi gives you the option to choose from cuisines for a fine dining experience or the street food, latter one being more famous.

Street Food in Delhi – As I am drafting this my mouth watering with the thought of the Golgappa’s, Aloo Chaat, Tikki!!! These three items in the street food category are the 1st one that comes to one’s thought!! Though every locality in Delhi will have a famous “Chaat wallah” as they are referred here, but the best one’s located in Bengali Market near C.P.(Connaught Place in Central Delhi) Also, one can get a taste of Bengali style of golgappe at CR Park(Chittranjan Park) in South Delhi. Golgappe or Pani Puri, as they are popularly called, are small water balls filled with boiled diced potatoes and chickpeas and topped with sweet n spicy water made with tamarind pulp and some spices.


Golgappe


 


Aloo Chaat is shallow fried diced potato until very crispy and mixed with spicy masala and tamarind or lemon juice. This is served very hot. Aloo chaat is also a local delicacy and can be found in every part of local market in Delhi.


 


aloo-chat


Tikki – Tikki is made of boiled and mashed potato. Its shaped into a semi flattened patty with a filling in the center made of peas mixed in spicy masala!! The patty is then shallow fried in a pan until crispy golden from both the sides! The patty is served hot with tamarind chutney, mint chutney, some sliced onion and little bit of curd!! For the tikki to taste divine, the key is the crispiness in the patty. The patty should be flattened a bit more that the regular method and shallow fried until its crispy. The best tikki is available in Noida Sec 25 market.


tikki


If you are in Delhi, do ensure that you do not leave the city without tasting these Delights of Delhi!!!


 



Gastronomy Delight Of Delhi

Search Database for Keywords or across all tables

/* Visit my blog


http://exuberantindia.com/


*/


CREATE PROC dbo.KeywordSearchDB

(

@SearchStr nvarchar(100)

)

AS

BEGIN

CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))


SET NOCOUNT ON


DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)

SET  @TableName = ”

SET @SearchStr2 = QUOTENAME(‘%’ + @SearchStr + ‘%’,””)


WHILE @TableName IS NOT NULL

BEGIN

SET @ColumnName = ”

SET @TableName =

(

SELECT MIN(QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME))

FROM     INFORMATION_SCHEMA.TABLES

WHERE         TABLE_TYPE = ‘BASE TABLE’

AND    QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME) > @TableName

AND    OBJECTPROPERTY(

OBJECT_ID(

QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME)

), ‘IsMSShipped’

) = 0

)


WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)

BEGIN

SET @ColumnName =

(

SELECT MIN(QUOTENAME(COLUMN_NAME))

FROM     INFORMATION_SCHEMA.COLUMNS

WHERE         TABLE_SCHEMA    = PARSENAME(@TableName, 2)

AND    TABLE_NAME    = PARSENAME(@TableName, 1)

AND    DATA_TYPE IN (‘char’, ‘varchar’, ‘nchar’, ‘nvarchar’)

AND    QUOTENAME(COLUMN_NAME) > @ColumnName

)


IF @ColumnName IS NOT NULL

BEGIN

INSERT INTO #Results

EXEC

(

‘SELECT ”’ + @TableName + ‘.’ + @ColumnName + ”’, LEFT(‘ + @ColumnName + ‘, 3630)

FROM ‘ + @TableName + ‘ (NOLOCK) ‘ +

‘ WHERE ‘ + @ColumnName + ‘ LIKE ‘ + @SearchStr2

)

END

END

END


SELECT ColumnName, ColumnValue FROM #Results

END


 


Save the procedure and call it for testing


exec dbo.KeywordSearchDB @SearchStr = ‘test’



Search Database for Keywords or across all tables

Friday, July 19, 2013

Facts about Japan

1 – Do you know that Japanese children clean their schools every day for a quarter of an hour with teachers, which led to the emergence of a Japanese generation who is modest and keen on cleanliness.


 2 – Do you know that any Japanese citizen who has a dog must carry bag and special bags to pick up dog droppings. Hygiene and their eagerness to address cleanliness is part of Japanese ethics.


 3 – Do you know that hygiene worker in Japan is called “health engineer” and can command salary of USD 5000 to 8000 per month, and a cleaner is subjected to written and oral tests!!


 4 – Do you know that Japan does not have any natural resources, and they are exposed to hundreds of earthquakes a year but do not prevent her from becoming the second largest economy in the world?


 5 – Do you know that Hiroshima returned to what it was economically vibrant before the fall of the atomic bomb in just ten years?


 6 – Do you know that Japan prevents the use of mobile in trains, restaurants and indoor


 7 – Do you know that in Japan students from the first to sixth primary year must learn ethics in dealing with people -


 8 – Do you know that the Japanese even though one of the richest people in the world but they do not have servants. The parents are responsible for the house and children -


 9 – Do you know that there is no examination from the first to the third primary level; because the goal of education is to instill concepts and character building, not just examination and indoctrination. -


 10 – Do you know that if you go to a buffet restaurant in Japan you will notice people only eat as much as they need without any waste. No waste of food.


 11 – Do you know that the rate of delayed trains in Japan is about 7 seconds per year!! They appreciate the value of time, very punctual to minutes and seconds


 12 – Do you know that children in schools brush their teeth (sterile) and clean their teeth after a meal at school; they maintain their health from an early age -


 13 – Do you know that students take half an hour to finish their meals to ensure right digestion. When asked about this concern, they said: These students are the future of Japan


 It is time that our young generation inculcates all the good things and help in nation building. 



Facts about Japan

Friday, June 28, 2013

पत्नी और घड़ी के बीच का संबंध

पत्नी और घड़ी के बीच का संबंध :


 


1. घड़ी चौबीस घंटे टिक-टिक करती रहती है और पत्नी चौबीस घंटे चिक-चिक करती रहती है!


2. घड़ी की सूइयाँ घूम-फिर कर वहीं जाती हैं और उसी प्रकार पत्नी को आप कितना भी समझा लो, वो घूम-फिर कर वहीं जायेगी और अपनी ही बात मनवायेगी!


3. घड़ी में जब 12 बजते हैं तो तीनों सूइयाँ एक दिखाई देती हैं, लेकिन पत्नी के जब 12 बजते हैं तो एक पत्नी भी 6-6 दिखाई देती है!


4. घड़ी के अलार्म बजने का फिक्स टाइम है लेकिन पत्नी के अलार्म बजने का कोई फिक्स टाइम नहीं है!


5. घड़ी बिगड़ जाये तो रूक जाती है लेकिन जब पत्नी बिगड़ जाये तो शुरू हो जाती है!


6. घड़ी बिगड़ जाये तो मैकेनिक के यहाँ जाती है पत्नी बिगड़ जाये तो मायके जाती है!


7. घड़ी को चार्ज करने के लिये सेल(बैटरी) का प्रयोग होता है और पत्नी को चार्ज करने के लिये सैलेरी का प्रयोग होता है!


8. लेकिन सबसे बड़ा अंतर ये कि घड़ी को जब आपका दिल चाहे बदल सकते हैं मगर पत्नी को चाह कर भी बदल नहीं सकते उल्टा पत्नी के हिसाब से आपको खुद को बदलना पड़ता है!



पत्नी और घड़ी के बीच का संबंध

HEART ATTACK

 


HEART ATTACKS AND WATER !


 How many folks do you know who say they don’t want to drink anything before going to bed because they’ll have to get up during the night.


 Heart Attack and Water – I never knew all of this ! Interesting…….


 Something else I didn’t know … I asked my Doctor why people need to urinate so much at night time. Answer from my Cardiac Doctor – Gravity holds water in the lower part of your body when you are upright (legs swell). When you lie down and the lower body (legs and etc) seeks level with the kidneys, it is then that the kidneys remove the water because it is easier. This then ties in with the last statement!


 I knew you need your minimum water to help flush the toxins out of your body, but this was news to me. Correct time to drink water…Very Important. From A Cardiac Specialist!


Drinking water at a certain time maximizes its effectiveness on the body:


ü  2 glasses of water after waking up – helps activate internal organs


ü  1 glass of water 30 minutes before a meal – helps digestion


ü  1 glass of water before taking a bath – helps lower blood pressure


ü  1 glass of water before going to bed – avoids stroke or heart attack


I can also add to this… My Physician told me that water at bed time will also help prevent night time leg cramps. Your leg muscles are seeking hydration when they cramp and wake you up with a Charlie Horse.


Mayo Clinic Aspirin Dr. Virend Somers, is a Cardiologist from the Mayo Clinic, who is lead author of the report in the July 29, 2008 issue of the Journal of the American College of Cardiology.


Most heart attacks occur in the day, generally between 6 A.M. and noon. Having one during the night, when the heart should be most at rest, means that something unusual happened. Somers and his colleagues have been working for a decade to show that sleep apnea is to blame.


 1. If you take an aspirin or a baby aspirin once a day, take it at night.


 The reason: Aspirin has a 24-hour “half-life”; therefore, if most heart attacks happen in the wee hours of the morning, the Aspirin would be strongest in your system.


 2. FYI, Aspirin lasts a really long time in your medicine chest, for years, (when it gets old, it smells like vinegar).


 Please read on…


 Something that we can do to help ourselves – nice to know. Bayer is making crystal aspirin to dissolve instantly on the tongue.


 They work much faster than the tablets.


 Why keep Aspirin by your bedside? It’s about Heart Attacks.


 There are other symptoms of a heart attack, besides the pain on the left arm. One must also be aware of an intense pain on the chin, as well as nausea and lots of sweating; however, these symptoms may also occur less frequently.


 Note: There may be NO pain in the chest during a heart attack.


The majority of people (about 60%) who had a heart attack during their sleep did not wake up. However, if it occurs, the chest pain may wake you up from your deep sleep.


If that happens, immediately dissolve two aspirins in your mouth and swallow them with a bit of water.


Afterwards: – Call 911. – Phone a neighbor or a family member who lives very close by.- Say “heart attack!” – Say that you have taken 2 Aspirins.


Take a seat on a chair or sofa near the front door, and wait for their arrival and …DO NOT LIE DOWN!



HEART ATTACK

Thursday, June 27, 2013

Joke


Santa Apne Dost K Ghar Se Apne Ghar Jane Laga To Bahar Barish Ho Rahi Thi . .
Dost: Aaj Mere Paas Hi Ruk Jao. Barish Bohat Tez Hai.
Santa : Ok … . . Dost Ne Bistar Lagaya aur Dekha To Santa Ghayab Tha.
1 Ghante Baad Santa Bheegta Hua Aaya aur Kehne Laga. . .
‘Yaar Main Ghar Waalon Ko Bataane Gaya Tha K Aaj Barish Ki Wajah Se Main Ghar Nahi Aa Sakunga’




Joke

Wednesday, June 26, 2013

Joke

A man who is a manager in 5 star hotel calls his wife.
Husband: Aaj khaane mein kya pakaya hai?
Wife: Steamed fine long grain white rice hand-picked in the emerald green lap of the Vindhyas, accompanied by a golden lentil soup that was gently simmered over the smouldering kisses of angels.
Husband:matlab??
Wife:dal chaval.
Husband:to itna ghumaya kyo
Wife:maine to wohi kaha jo tum 5 star wale public ko kehte ho.



Joke

True Story


कुछ दिन पहले मेरे पास एक फ्रेंड रिक्वेस्ट आई । यह किसी प्रिया अरोड़ा के नाम से थी ।अमूमन मेरे पास पुरुषों की रिक्वेस्ट तो आती रहती हैं मगर इस बार एक सुकन्या ने र…िक्वेस्ट भेजी थी सो चौंकना स्वभाविक था ।एक्सैप्ट करने से पहले मैने आदतन उसकी प्रोफाइल को चैक किया तो पता चला अभी तक उसकी मित्रता सूची में कोई भी नहीं है । शक हुआ कि कहीं कोई फेक तो नहीं है फिर सोचा नहीं…., हो सकता है फेसबुक ने इस यूजर को नया मानते हुए इसे मेरे साथ मित्रता करने के लिए suggest किया हो ।प्रोफाइल फोटो नदारद देखकर मैनें अंदाजा लगाया शायद नई है और उसे फोटो अपलोड करनी नहीं आती या फिर वो संकोची हो सकती है anyway मैनें उसे ऐड कर लिया ।सबसे पहले उसकी ओर से धन्यवाद आया फिर मेरे हर सटेटस को लाईक और कमेंटस मिलने शुरू हो गए ।मैं अपने इस नए कद्रदान को पाकर बेहद खुश हुआ. सिलसिला आगे बढ़ा और अब मेरी निजी जिंदगी से संबधित कमेंटस आने लगे ।मेरी पसंद नापसंद को पूछा जाने लगा । अब वो कुछ रोमांटिक सी शायरी भी पोस्ट करने लगी थी. एक दिन मोहतरमा ने पूछा : क्या आप अपनी बीवी से प्यार करते हैं ? मैनें झट से कह दिया : हाँ. वो चुप हो गई । अगले दिन उसने पूछा : क्या आपकी मैडम सुंदर है ? इस बार भी मैने वही जवाब दिया :हाँ बहुत सुंदर है । अगले दिन वो बोली : क्या आपकी बीवी खाना अच्छा बनाती है? ” बहुत ही स्वादिष्ट” मैनें जवाब दिया । फिर कुछ दिन तक वो नजर नहीं आई । अचानक कल सुबह उसने मैसेज बाक्स में लिखा “मैं आपके शहर में आई हूँ क्या आप मुझसे मिलना चाहेंगे” मैनें कहा : श्योर । “तो ठीक है आ जाइये ओम सिने गार्डन में मिल भी लेंगे और मूवी भी देख लेंगे” ।
मैनें कहा नहीं- “मैडम आप आ जाइये मेरे घर पर, मेरे बीवी बच्चे आपसे मिलकर खुश होंगे । मेरी बीवी के हाथ का खाना भी खाकर देखियेगा । बोली : नहीं, मैं आपकी मैडम के सामने नहीं आऊँगी आपने आना है तो आ जाओ ।
मैंने उसे अपने यहाँ बुलाने की काफी कोशिश की मगर वो नहीं मानी । वो बार बार अपनी पसंद की जगह पर बुलाने की जिद पर अड़ी थी और मैं उसे अपने यहाँ । वो झुंझला उठी और बोली : ठीक है मैं वापिस जा रही हूँ तुम डरपोक अपने घर पर ही बैठो । मैनें फिर उसे समझाने का प्रयास किया और सार्वजनिक स्थल पर मिलने के खतरे गिनायें पर वो नहीं मानी । हारकर मैंने कह दिया : मुझसे मिलना है तो मेरे परिवार वालों के सामने मिलो नहीं तो अपने घर जाओा । वो अॉफलाइन हो गई । शाम को घर पहुँचा तो डायनिंग टेबल पर लज़ीज खाना सजा हुआ था । मैनें पत्नी से पूछा: कोई आ रहा है क्या खाने पर ? हाँ प्रिया अरोड़ा आ रही है ।
व्हाट !! वो तुम्हें कहाँ मिली तुम उसे कैसे जानती हो?
“तसल्ली रखिये साहब, वो प्रिया मैं ही थी, आप मेरे जासूसी मिशन के दौरान परीक्षा में पास हुए. आओ मेरे सच्चे हमसफर, खाना खायें, ठंडा हो रहा है


Nand Kishore



True Story

Joke

Punjab me 1Train k niche 100 Sardar aa gye! 99 Mar gye, 1 Bach gya.

Reportr ne Usse Pucha ‘ye Kaise hua?’

Sardr-Galat Announcement hui,

‘Shatabdi Platform pe aa rhi h!’ Sab Ghabra k Platform se Utar k Patri pe Aa gye!

Par Train Platform pe nhi, Patri pe Ayi.

Reportr-Aur Aap Samjhdar nikle Jo Patri pe nahi utre!

Sardar-Ji nahi, Mai to Suicide karne Aaya tha, Announcmnt Sunkar Patri se Hat k Platform Pe Let gya.



Joke

Friday, June 21, 2013

Joke


Santa and Banta were playing chess

(joke doesn’t end here)…

Santa – chal yaar bas karte hein. … Banta – Haan yaar, waise bhi tera sirf haathi bacha hai aur mera sirf ghoda.

(joke doesn’t end here either)…

Phir wahan Vishwanathan Anand aata hai.

Vishy – Chalo Santa-Banta chess khelte hein.

Santa-Banta: nahi. Aap to hume aasaani se haraa doge.

Vishy: chalo yaar. Tum dono aur main akela.

Santa-Banta: phir bhi hum haar jaayenge.

Vishy: Ok. Main left haath se khelunga.

Santa-Banta: haan. Phir theek hai.

(the joke still doesn’t end here).

Dono obviously haar jaate hein aur Vishy chalaa jaata hai.

Santa: badi sharmnaak baat hai yaar. Let hand se bhi haraa diya usne.

(wait yaar joke still is on).

Banta: abe bewakoof banaa gaya who hume.

Santa: who kaise.

Banta: Saala lefty hi hoga….



Joke

Thursday, June 20, 2013


Monsoon’s showing off like hell…and so is the widespread of mosquitos and pathogens..Have a mosquito problem??? Take a look at this remedy!

At your next outdoor gathering try this SAFE and EFFECTIVE method of keeping mosquitoes at bay! Simply slice a lime in half and press in a good amount of cloves for an ALL NATURAL mosquito repellent…







Violence Post Silence (Rhyme not intended)

I do not know what he gained from it, his weird stare right in the morning. Once he saw me coming he started walking at an angle so that he could reach in close proximity, for what? a better view? Saare uncle log subah subah park  mein yoga kar rahe hain, is anokhe insaan ka dimaag kahin aur hi hai!

At times I stare back, at times I stop with arms folded and smile, when younger I would hit, this time I just moved on, I have too many priorities to think about, than to waste my time on a nymphomaniac , or so I thought and remained silent. … I went out in the day, came back late evening and within this short duration of commuting, I had a few more perverts to ignore. It is like home work piling up after each bell, a daily grotesque ritual.

The drunk cycle rickshaw puller whose rickshaw I jumped off from, the ten or more men who sat on charpoys along the bridge and watched me do so, giving their necks a hard time;

(( Bell ))

The auto rickshaw driver who refused to follow the route I was describing

(( Bell ))

The two jerks in the car while we were stuck in traffic (if only that man would listen to me and not take the longer route! and if only he wouldn’t turn back so often!)

(( Bell ))

The men who walked by as I walked home from market;

(( Bell ))

The men sitting in their car and drinking;

(( Bell ))

The man in the car which had to stop for me (i think he stared more out of hatred) and so on.

(((( Longer bel l))))

—–home——

If you think it is easier or more convenient to ignore, it is not.

It could cause you neck troubles, because you strain to look away, and at times if being stared at from different angles, you got to find a weird angle for your own neck as well, to avoid every freakin eyeball.

It is not easy, it requires a lot of thought and energy to maintain this version of “peace”. If your mother tells you its safer, it is not. Silence encourages idiots to be bullies and you restrict your own self with your fears. And fear is unsafe for your health.

AT times you take drastic steps out of frustration, which gets built over time. I have used the pepper spray to almost brutal results, not too often though. When it is in my hand, I try and draw power from it, which I could have drawn from within myself, if I weren’t scared, which would happen if I were not told to ignore, to keep quiet and to keep this daily shit within me.

In the end, some day you might get violent, so its better to use lesser energy on dialogue, complaint or being stern etc every day.

No matter what you do, you can’t miss that stare, and to ignore itself, becomes a task, a horrible home-work. And I so regret that I wasted my energy in ignoring them. might as well have taught a lesson or two. Next time, next time for sure!

a tiring day…indeed..






Wednesday, June 19, 2013





Long time back, prior to any examination I would be scared to death. I was never scared of ignorance though, which cruelly haunts me now. I was not worried about that which happens around me, I was only scared of not remembering that which was deemed important as per our syllabus.

Year after year, I would invest time… and energy in accepting unquestioned information as also fear of forgetting the same, the fear of failure, the fear of being mocked at or not being accepted. As soon as the exams were over, the relevance of that text would decline, I would never think of how it would be of use to me, how it could assist me in my exploration of life, it was a task which was to be done well.

A few of those report cards are still lying somewhere in some file. I remember making fake chapattis for my doll with a pink one though; They haven’t served much purpose than informing me of the numbers representing how much I had forgotten. They do not tell me of what all I actually missed beyond my syllabus, what all I missed by not truly understanding what was in my syllabus.

Like a mindless machine, I functioned, functioned well as per certain standards, and came out with some papers claiming something about me in certain codes. I was eligible for certain things in life from here onwards according to someone who I don’t really know.

A system which managed to homogenize even the artwork you make in drawing exam (conical peaks, rivulet, sun, sun rays, tree, hut), though being questioned, seems far from a revolution it strongly demands. The solutions are not to be alternate, as they are called, but be able to change the system from within. I remember getting a 40 out of 100 in my drawing examination, for I drew tortoise and snails, maize and as I very clearly remember, no sun. I enjoyed sketching then, and did not really care about the grades for it.I lied to my parents that especially for drawing examination, marks are out of 60, I wish I could have cared even less for grades in other subjects. i wish I had enjoyed reading those texts as much as I enjoy reading our prescribed texts now, or I enjoyed reading my story-books then. It is not too much to wish for I hope.





Once in a soap factory in Japan, the soap cover was mistakenly packed without soap in it i.e. empty box. To avoid the it in the future, they purchased an X-Ray machine of 60,000 Dollars to check if soap is Packed in every cover or not, in the assembly line..

Same problem occurred in India

What did they do?  They Simply put a Fan beside the Assembly line.

Empty boxes were flown away!

“Jai ho Indian Dimag ki”





So you run, and you run as if it were your last train. There is a streak of madness, almost a wild chase, for reasons  not required to be explained, but the point is, you run.

You run like you haven’t in quite some time, ever since you chose to be a potato feasting on school books. You run and as you run you can’t recall the last time you did so, you keep trying but memory fails to erupt an image.

No you don’t find it thrilling. … Your legs tremble, your heart palpitates as if those were the last few seconds of life.Your knee jerks, you feel the heat in your cheeks, but you run, you know you are getting slower and slower, but you run.

And when you do stop, you feel as if you are dying, only to reflect the next moment and realize, you are already dead.

At times, it is a realization as harsh as this, which shakes you up and demands that you get up and start living, that you stop letting yourself be this haggered body with no stamina or strength.

I felt dead today and it is not very nice.





Long time back, when we were in school, there came a phase when almost the entire city would gift  a wind chime as a birthday present.

If you would receive a present, you could study the shape of the box, shake it a bit, and you need not guess anymore, it would be the most innovative present on planet, the one and onl…y, wind chime!!! I understand, it is not the gift that matters, but the intent. But after hanging a wind chime in your washrooms as well, you do feel cautious of every new box that comes your way.

We would mostly purchase gifts from a few limited gift centres which would be overflowing with those. They were in different shapes and sizes, in varied styles, in multiple colors. There were explorations in different materials as well, plastic, glass, wood, metal, clay etc.You visit a house, and you would see a wind chime in the most unexpected places, for they had just so many! Many houses could be very well considered museums of wind chimes.I remember being scared at nights, for our neighbours’ huge wind chime, hanging at their entrance would sound ghostly in the wind.

Slowly people started passing them forward through festivals and other occasions where exchange happens. We were all entrapped within a system of wind chimes. It was almost like a nightmare where the wind chime virus is crazily multiplying, and you are getting deeper and deeper into the wind chime well and then there is a wind chime whirlpool and their sound is echoing in the valley which is flooded with wind chimes and there is a storm and crazy lightning and guess what, every drop sounds like a wind chime! People are running everywhere but they can’t escape those gifts. Their houses have no space left, how much more can you accumulate? The world has no space left, you leave the world and you realize that the universe is but a wind chime. You cannot take it anymore…darkness…sleep.

Today is but a new day.

This morning I was greeted with the sight of an old faithful green wind chime, gifted to me by my friend on my birthday. I ran to check the washrooms, the wind chime with the mermaid is there no more. I checked in my room, the red wind chime s probably removed, it did look hideous though. And I suddenly wondered, where did the wind chimes disappear?







My dearest papa, I am so lucky to have you as my father, you have always been there for me no matter what, you have influence my life in a very positive way , I love you with all my heart and soul and pray to god to make you my papa in all the births, this picture of mine reminds me of you, when I look at it I see you or should I say your shadow, love you a lot papa, I truly wish I could love and support my children as much, me and Deepak Mehtani know very well that you have so much of concern and love for us now spreading to KAR     Nisha Gurnani and Rajiv Aggarwal  they are lucky to have you as grandpa/FI. I take this opportunity to wish you a very happy Father’s Day from all of us may you keep loving and blessing us *hugs* OXOXO — with Subhash Mehtani.




















Haryanvi called his mobile service customer care:

“Re maari bhains ne sim khaa li aur bhaag gi…”

Customer Care executive (irritated): … “to main ke karoo?”

Haryanvi replied: “rey baavle, tu mane yo bataa ki roaming to naa lagegi?…”










I took the road to nowhere, for I have never traced its entire length. No matter how much I walk, it seems to never end.

The grass is green where birds do hop, where dogs sleep and cows graze. The crows sit on the wet branches, their leaves heavy with droplets from last night.

Brown Ducks, they swim in circles, while… those in white call for attention. The clouds are dark and the lake glitters, water flows and is no more still.

People walk in silence, for in silence is so much to hear. Some run, some sit and watch, I just choose to walk.

It rains, a very friendly rain.





PUNJABI: GOD GIVE ME ROOM FULL OF GOLD


GUJRATI: GOD GIVE ME ROOM FULL OF DIAMONDS


MARWARI: GOD GIVE ME ROOM FULL OF GEMS



SINDHI: GOD GIVE ME KEYS OF ALL THESE ROOMS


PROUD TO BE A SINDHI. SINDHI ROCKS !!!!!



Ek sindhi aur ek Marwadi ne samundar ke kinaare board lagaa dekha jis par likha tha:


“Doobte ko bachaane waale ko Rs. 500 ka Inaam”.


Marwadi: Main jump lagaata hu, tum mujhe bachaana. Is tarah Rs. 500 milenge aur hum fifty fity kar lenge.


Ye kah kar marwadi ne jump lagaa diya.


Sindhi Khaamoshi se dekhta raha to marwadi ne chilla kar kaha: Mujhe tairna nahi aata, tum mujhe bachaate kyun nahi?


Sindhi: Tum ne board ke neeche nahi padaa.


Neeche likha tha: “Laash nikaalne waale ko Rs. 5000 ka Inaaam”.



Saturday, May 18, 2013

Challenges with Cloud Migration

One of the biggest challenge in cloud adoption is moving the existing application to the cloud. I had the opportunity to do that with one of the existing applications. One of the most important aspect is to get the buy-in from the management and application management groups.


Once we had the will, the vision and commitment to do the move, we were able to get it done. Of course the path was not easy and filled with lot of challenges. One of the key factor is that most of the existing applications are not written with cloud in mind and do not follow the principles of service oriented architecture (SOA) or design. The key was also in understanding that at some point application will move to the next level with SOA model.


Challenges at hand were: move existing setup as is with minimal interruption to the cloud and plan out application phase – II to make it cloud ready application. Of course the second part was more of a business strategic decision but it definitely helped with pushing the first one.


While virtualized environment comes with its own benefits, there is also a loss of granular control for the application team for there are more regulations put into place and a requirement to keep the environment pristine. We used private cloud solution to limit the impact of moving the application from physical servers to the cloud hosted environment and although it does not represent cloud design and architecture it enables moving the applications as is into cloud helping out with overall view to move to cloud.

Key factors:


  • Resistance to move to cloud environment by application team –> solve by getting buy-in from management team and vision of moving application to cloud architecture

  • Rules around access are stricter and loss of granular control –> solve by showing the expertize received with hosted cloud environment, no more struggle for hardware maintenance and 99.9% uptime, done via cloud

  • While physical machine setup was designed to meet uptime requirement by ensuring all servers are always up and running the cloud philosophy is that failures will happen so the more failure points we create the less chances of outage we have –> show how this will be beneficial with SOA application

  • Learning curve on service management and uptime –> show how service dashboard, dedicated team especially in case of private cloud is very useful

  • Difficulty working with layer – layers of services below own application –> show how this will be beneficial when newer version of SOA based application is developed

  • Cloud scalability and flexibility are the key to get buy ins

Once all set it is all about planning, executing and monitoring the project to completion. Goals should be established with detailed task to take every steps with appropriate mitigation plan that will be custom based on the application in consideration.



Challenges with Cloud Migration

Wednesday, May 15, 2013

Our Pitaji

PitajiPitaji over 90 years young


Aaj bathe bathe achanak Pita Ji ki yad aa gayi. Ankhen num ho gaien aur kisi tereh apne aap ko sambhala aur socha ki kuch unke bare mein likh kar apne bachon or rishetedaron se share karoon.


Pitaji was a towering personality – 6 feet tall with stout built and looked very tough. In fact he was like a coconut – hard from outside but very soft from inside. He was in Delhi Police and I have a very vivid memory of seeing him in uniform – he used to dress immaculately and looked a very smart person and I used to look at him with awe and thought that someday I too will become a Police Officer. But that was not to be. Nonetheless I came to work in the Ministry of Home Affairs in a senior position and dealt with matters relating to Delhi Police. By the time I had joined Home Ministry my dad had retired from Delhi Police. His colleagues, who used to come to me, always remembered him with respect.


When we were growing up, all we used to hear from the families of his colleagues was that he was an honest person. I think that his honesty was rewarded when all his children got well placed in Government jobs with their own efforts.


I never saw him losing his cool. Even if he was angry it never got reflected on his face. When annoyed, he was like boiling water – will never come out of the utensil – unlike milk; and kept the annoyance to himself. One characteristic about him which very few will know – he was a very good singer and I do remember him singing songs particularly when my mother was upset for some reason or the other. He was a very good communicator and always put across his view point effectively. He always was in jolly mood and used to say that keeping himself happy was the secret of his health.


I cannot help but narrate one incident that left a lasting mark in my memory. One day he was on his way to the Police Station on his Bullet Motorcycle. Suddenly from the opposite side a car hit his bike and he fell down. The driver of the car tried to run away but was prevented by the public. As he was trying to compose himself, a girl emerged from the car and with folded hands requested my father that they be allowed to go as she was getting late for annual university exam. Though the public was in mood to oblige, my father intervened and said that it is a question of her career and he allowed them to go. Later he was taken to the hospital where he realized that he had fractured his left arm. The owner of the car did come to the Police Station and asked forgiveness and offered compensation, which my father firmly refused. Since that day his stock in the eyes of his colleagues and family touched new heights.


He was a man with very strong will. He used to smoke hell of a lot. One day in the presence of his family he vowed not to smoke and believe me that day onward he never smoked. I really do not know any person with that strong will and character. There are very many stories like that and I will narrate them sometime later.


 


He led a very healthy and active life. He passed away peacefully on 7th December, 2007 at the age of 96 years.


 



Our Pitaji

Monday, May 13, 2013

HYPOCRISY CENTRAL BUREAU OF INVESTIGATION – A CAGED PARROT AND INTELLIGENCE BUREAU – A ‘CHICKEN’

Only last week, while examining the affidavit filed by the Director, Central Bureau of Investigation (CBI), on  probe in coal scam, the Hon’ble Supreme court remarked: “CBI has become a caged parrot speaking in master’s voice,” and that it has many masters in the Government. The court taking note of the fact of sharing and alterations in draft probe report of the coal block allocation scam, observed that “It’s a sordid saga that there are many masters and one parrot.” 


 And now the Bangalore Bench of the Central Administrative Tribunal (CAT) has cast serious aspersions on the functioning of the Intelligence Bureau.  Giving its ruling on the plea of a woman IPS Officer against her premature repatriation to her Cadre due to her ‘maladjustment or lack of  adjustment’ to the IB’s work culture; the Tribunal called IB a chicken and an Augean’s Stable requiring systematic clean up. The CAT observed that ‘IB is like a chicken. A bird? Yes. Can if fly?  No.’  Ruling in favour of the Petitioner,  the CAT also directed the Cabinet Secretary to head a nine-member panel to bring about integral competency and specific accountability of all intelligence services.


 The above two stinging remarks of the judiciary against the functioning of the government intelligence agencies say it all about the rotten system that has marred the functioning of these agencies over the decades.  However, rather than taking the remarks of the judiciary in the right spirit and to address the issues involved and put the right systems in place, the Congress Party has chosen to criticize the judiciary. Mr. Digvijay Singh of the Congress has expressed his unhappiness in no uncertain terms on the Supreme Court calling the Central Bureau of Investigation (CBI) a ‘caged parrot’ and the Central Administrative Tribunal (CAT) terming the Intelligence Bureau as a ‘Chicken’. He has questioned the apex court and CAT by saying – ‘Are we not belittling our Institutions. When pressed further for comments by TV Journalists, he had the audacity to say that they better get the comments of the apex court and the CAT who had made these remarks. 


          The remarks of Mr. Digvijay Singh need to be looked into in the backdrop of the kind tirade the entire Congress Party had launched against the Comptroller & Auditor General (CAG) of India,  particularly on his reports in the 2G and Coal Scams.  Where had the wisdom of Mr. Digvijay vanished when the entire Congress Party was belittling the institution of CAG.  It is only when the problem comes to your doorstep that you start talking about the respect for our Institutions. This is nothing but hypocrisy. 



HYPOCRISY CENTRAL BUREAU OF INVESTIGATION – A CAGED PARROT AND INTELLIGENCE BUREAU – A ‘CHICKEN’

Saturday, May 11, 2013

DIVINE MOMENTS

Reyan2 Reyan1


reyanvideo


When I came to know that my daughter was expecting a third time, I was not very much excited. The time passed by and the little angel arrived last October. I, along with my wife spent some time with them around October.  In March 2013, we got a chance to be together in Mauritius.  When we arrived in the hotel in Mauritius, I saw the little one lying in pram and looking all around.  I came closer to the pram and he has had a close look at me and gave me a broad smile. I just cannot forget that moment – it was a million dollar smile that he gave me – in fact such moments cannot be weighed in monetary terms.  Such are the divine moments.  I called him and he instantly started shaking his hands and legs as if telling me that he wanted to hug me.  I took him in my lap and sat on a Chair.  I made be stand facing me and started talking to me – what I was talking I really do not remember.  The little angel started replying to my utterances in the same vein as I was talking to him.  I remember having asked him ‘India Chaloge’ – and you know what he started giggling chuckling and his repertoire of vowel-sound coos inspired everyone around.   Every time I repeated this question, he will laugh all the more loudly.  My daughter captured those moments in the camera and even today when I have nothing to do or am feeling low, I run that video and it gives me immense pleasure.


After being together for a week or so, we parted our ways – we came back to India and my daughter returned to Kenya.  We were carrying fond memories of our stay in Mauritius and uppermost in my mind was giggling sound of my grandson – Reyan.


After our return to India, my daughter and I were talking on Skype.  The little one was fast asleep.  However, when he heard me talking to his mother, he opened his eyes and started making noises as if he was seeking my attention.  The camera was focused on him and he looked at me and gave me broad smile and started shaking his hands and legs as if he wanted me to lift him.  That day onwards, I have made it a point to talk to him every day. Talking to him has become part and parcel of my daily routine.  It seems to me as if he also waits for me every day.  I do not know how he is going to react when he comes to India in July this year.  I am anxiously waiting for that DIVINE moment.



DIVINE MOMENTS

Friday, May 10, 2013

AMAZING BUT TRUE

A man with 39 wives, 94 children and 33 grandchildren live under one roof.


Mr Ziona lives in a four storied building with 100 rooms in the State of Mizoram.


And you know who all live in this 100 room building – the 66 years old Ziona with his 39 wives, 94 children and 33 grandchildren – a total of 167 persons live under one roof. The family consumes around 200lb of rice and more than 130lb of potatoes every day. And the gentleman has not yet called it a day and is willing to go to any extent to marry and expand his family.


The wives take turns cooking, while his daughters clean the house and do washing. The men do outdoor jobs like farming and taking care of livestock.


Mr. Ziona heads a local Christian religious sect, called the “Chana”, which allows polygamy. Formed in June 1942, the sect believes it will soon be ruling the world with Christ and has a membership of around 400 families.



AMAZING BUT TRUE

AMAZING FACTS ABOUT INDIA

  • World’s largest, oldest, continuous civilization.

  • World’s Largest democracy.

  • Never invaded any country in her last 1000 years of history.

  • Invented the number system. Zero was invented by Aryabhatta.

  • Established Harappan culture in Sindhu Valley (Indus Valley Civilization) When many cultures were only nomadic forest dwellers over 5000 years ago.

  • 300,000 active mosques in India, more than in any other country.

  • Sanskrit is the mother of all the European Languages – is the most suitable language for computer software – a report in Forbes magzine July 1987.

  • Chess (Shataranja or AshtaPada) was invented in India.

  • Is one of the few countries in the world, which gained independence without violence.

  • Second largest pool of Scientist and Engineers in the World.

  • Largest English speaking nation in the world.

  • Largest number of Post Offices in the world.

  • Martial Arts were first created in India, and later spread to Asia by Buddhist missionaries.

  • Yoga has its origins in India and has existed for over 5,000 years.


AMAZING FACTS ABOUT INDIA

Thursday, May 9, 2013

SQL Server - Use T-SQL to delete files older than X days

Sometimes there is a need to delete backup files via tSQL. Here is a script that can do the trick.

– -d represents number of days, – 2 represents file older than 2 days set the parameter as needed

exec xp_CMDShell ‘Forfiles -p “C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA” -s -m *.trc -d -2 -c “Cmd /C del @FILE”‘



enjoy!


SQL Server - Use T-SQL to delete files older than X days

Wednesday, May 8, 2013