I have been working on an iphone application project about time tracking for the attronies.. It is almost done and is on the way .I took me quite a while to develop it as we had many issues about its workflow and layout. but finally we figured all out !!

See the animated gif image below and tell me what you think .. I will keep updating the progress.

Generating long, high-quality random passwords is
not simple.  So here is some totally random raw
material, generated just for YOU, to start with.


go to


https://www.grc.com/passwords.htm

So you want to find the table name ' A' being used in all the procedures.

Use this query

SELECT ROUTINE_NAME, ROUTINE_DEFINITION

    FROM INFORMATION_SCHEMA.ROUTINES

    WHERE ROUTINE_DEFINITION LIKE '%license%'

    AND ROUTINE_TYPE='PROCEDURE'

where '%license%'  is the Table name to be found .. 

Src: http://www.curioustimes.de/iphonesimulatorcropper/index.html

Info

I hacked this small tool to take screenshots of my app running in the iPhone-Simulator. Before that, i took a screenshot and cropped the application screen with the help of Pixelmator. Especially when you need screenshots in different languages this takes a lot of time (version by version of your app).

Another point to mention, you should upload screenhots in iTunes Connect as a JPEG in the resolution 320x460 pixels. This is without the status line on top.

Usage

It is very easy to use. Just start your iPhone app in the Simulator. Be sure that the Simulator window is not covered by any other window. Start this app and press the „Capture“-button.


Hint: If it cannot find the iPhone-Simulator, then use the Fuzzy detection slider and move it step by step to the right until it founds the simulator!


For example this a screenshot (from a very old version) of my app running in the iPhone-Simulator:



After pressing the „Capture“-button you will get this result, which is ready to be uploaded in iTunes Connect:

This is my first iPhone app that streams Seven nepali FM over iphone using either wifi or 3g network.

See the screenShot

Today I had a very bad day. My friend left me a job that he estimated for 2 hours and Now I need to finish that ..There is no chance that i can write multiple pages sql Stored procedures /query and create report in 2 hours ..

It is going to take me at least 15 hours for everything .. Ok that is not the point .. the point .. I spent 5 hours to write all the query .. tested in Sql query manager and ran great ... Thought I was really good .. created a report layout .. added few dataset and ran the report using VS 2005 IDE .. Now the drama begins .. It took 5-10 mins to render report by VS 2005. I went to sql server machine.. checked for task manager .. CPU uses was more than 50% for that 10 mins time .WOW .. When I ran the same query in query manager .. it took less than 5 seconds .. I was upset .. restarted VS .. restarted computer .. nothing happened .. recompiled code .. redeployed .. Nothing ..Nothing at all.. I googled about it .. I am not only one.. If u have same problem ..

Google about "Parameter Sniffing " ..U will see many article about it .. In short the solution was: Suppose I have :

create proc newProc { @name varchar(200) }

as select name from nametable where name=@name

.. go

everytime u call it from outside with even NULL value or some value not equal to varchar(200) SQl server tried to create a brand new execution plan ..

and it takes forever to run the script if u have pretty complex sql..

Sol Very simple .

create proc newProc

{ @name varchar(200) }

@declare @newName varchar(200)

set @newname=@name as

select name from nametable where name=@newname .. go

done !! SQL just ignores to create execution plan and runs the last used plan ..

Ok ..so lesson of today:

There are lot of thing u dont know about .