tag:blogger.com,1999:blog-200385222024-03-13T08:52:14.021-05:00AjasHadiAjas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.comBlogger151125tag:blogger.com,1999:blog-20038522.post-47652375599870455602011-01-06T10:10:00.003-05:002011-01-18T13:23:27.066-05:00iphone 4 ipod touch Change Delete Edit Update wifi wireless key wireless password wireless connection wireless networkSo I had this problem today where the wireless key had changed for one of the wireless networks I have setup on my iphone 4. So question is how do you Edit or Update or Delete the old wireless key?<br /><br />Here is what I ended up doing.<br /><br />1. Go the Settings, Click on Wi-Fi<br />2. It will take you to Wi-FI Networks screen. On top you will have Wi-Fi as ON. Just below it you will have Choose a Network... option<br />3. In my case, since I had to enter the new key for wireless network that was already setup before, I clicked on Other...<br />4.On the Other Network screen, I entered the name of the wireless network, under security, I made it WEP (mine was WEP,yours could be different), and then I got screen for password or wireless key rather, where I typed in the *new wireless key*. Thats it. I was able to join my existing wireless connection again.<br /><br />Few other suggestions I found over the net.<br /><br />1. Go to WiFi Networks and click on arrow next to the wireless network name and choose Forget this network. I didnt try this because the message says, this will make sure iphone doesnt automatically connects to your wireless network everytime it see's it.<br /><br />2. The other one I found was to reset *only the network settings*. Now in my case I had already setup 3-4 wireless networks and I didnt want to erase them and start over again. So I didnt go this route.<br /><br />Try it and let me know if it works for you.<br /><br /><span style="font-weight: bold;">Updated on Jan 18 2011.</span> It seems suggestion no.1 i.e. forget this network also works. You do that and next time click on network name to connect and iphone / ipod touch will ask you for the network key password.<br /><br />Thanks,Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-15629173864453924752011-01-05T11:40:00.008-05:002011-01-18T13:24:01.129-05:00iphone 4 ipod touch Change Delete Edit Update Delete wifi wireless key wireless password wireless connectionSo I had this problem today where the wireless key had changed for one of the wireless networks I have setup on my iphone 4. So question is how do you Edit or Update or Delete the old wireless key?<br /><br />Here is what I ended up doing.<br /><br />1. Go the Settings, Click on Wi-Fi<br />2. It will take you to Wi-FI Networks screen. On top you will have Wi-Fi as ON. Just below it you will have Choose a Network... option<br />3. In my case, since I had to enter the new key for wireless network that was already setup before, I clicked on Other...<br />4.On the Other Network screen, I entered the name of the wireless network, under security, I made it WEP (mine was WEP,yours could be different), and then I got screen for password or wireless key rather, where I typed in the *new wireless key*. Thats it. I was able to join my existing wireless connection again.<br /><br />Few other suggestions I found over the net.<br /><br />1. Go to WiFi Networks and click on arrow next to the wireless network name and choose Forget this network. I didnt try this because the message says, this will make sure iphone doesnt automatically connects to your wireless network everytime it see's it.<br /><br />2. The other one I found was to reset *only the network settings*. Now in my case I had already setup 3-4 wireless networks and I didnt want to erase them and start over again. So I didnt go this route.<br /><br />Try it and let me know if it works for you.<br /><br /><span style="font-weight: bold;">Updated on Jan 18 2011.</span> It seems suggestion no.1 i.e. forget this network also works. You do that and next time click on network name to connect and iphone / ipod touch will ask you for the network key password.<br /><br />Thanks,Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-6495453584174614002010-03-31T10:59:00.010-05:002010-03-31T11:22:19.755-05:00Java Keytool Export Private Key, PKCS#12 or .p12 export or conversion from java keystoreSo, I had to create a PKCS#12 type or .p12 extension certificate from a java keystore which was created using java keytool. FYI, I have jdk 1.4.2. I came to know that using keytool you cannot export the private key. <br /><br />I tried various options available in keytool i.e. create a keystore of type PKCS#12 to begin with instead of the default JKS (java keystore). -storetype PKCS12.<br /><br />All this didnt work and on further search on google, I came across 2 free products which can help you a lot in terms of handling the keystore, generate keystore, export private key and so on.<br /><br />You can download these free products from here.<br /><br />The tools are <a href="http://sourceforge.net/projects/portecle/" target="_blank">portecle-1.5</a> http://sourceforge.net/projects/portecle/<br /><br /><a href="http://www.icewalkers.com/download/KeyTool-IUI/3073/adl/" target="_blank">KeyTool IUI – GUI</a> http://www.icewalkers.com/download/KeyTool-IUI/3073/adl/<br /><br />For my needs, i.e. generate a PKCS#12 certificate from an existing java keystore, <a href="http://sourceforge.net/projects/portecle/" target="_blank">portecle-1.5</a> worked just fine and it was very easy to use. <br /><br />I also tried the <a href="http://www.icewalkers.com/download/KeyTool-IUI/3073/adl/" target="_blank">KeyTool IUI – GUI</a> just for testing the tool and it helped me to export the private key of my RSA key pair. The reason I wanted my private key in a seperate file is to use this online site which allows conversion of certificate types online. The url is https://www.sslshopper.com/ssl-converter.html.<br /><br />Hope this helps someone. :-)<br /><br />Helpful Links/Tutorial for keytool, PKCS#12 :<br /><br /><a href="http://www.herongyang.com/crypto/Key_Formats_PKCS8_PKCS12.html" target="_blank">Cryptography Tutorials - Herong's Tutorial Notes</a><br /><br /><a href="http://conshell.net/wiki/index.php/Keytool_to_OpenSSL_Conversion_tips" target="_blank">Keytool to OpenSSL Conversion tips</a><br /><br /><a href="http://www.anandsekar.com/2006/01/19/exporting-the-private-key-from-a-jks-keystore/" target="_blank">Exporting the Private Key from a JKS keystore</a><br /><br /><a href="http://blog.facilelogin.com/2008/07/exporting-keystore-private-key-with.html" target="_blank">Exporting keystore private key with WSAS</a><br /><br /><a href="http://mindprod.com/jgloss/keytoolexe.html#EXPORTING" target="_blank">Exporting Private Keys</a><br /><br />Good Luck. :-)Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com6tag:blogger.com,1999:blog-20038522.post-92065002004954101202010-03-03T17:15:00.001-05:002010-03-03T17:16:46.484-05:00Good stuff on Normal forms<a href="http://www.tonymarston.net/php-mysql/database-design.html#1nf" target="_blank">Database Normalization stuff here</a>Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-59177230661467050142010-03-03T17:01:00.002-05:002010-03-03T17:04:14.386-05:00SQL Server Index ArticlesHere are some good articles on SQL Server Indexes.<br /><br /><a href="http://www.sqlteam.com/article/sql-server-indexes-the-basics" target="_blank">SQL Server Indexes: The Basics</a><br /><br /><a href="http://www.mssqltips.com/tip.asp?tip=1793" target="_blank">SQL Server Indexing Basics</a><br /><br /><a href="http://odetocode.com/Articles/70.aspx" target="_blank">SQL Server Indexes</a>Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-56716289699953107662010-03-03T16:56:00.004-05:002010-03-03T17:01:39.759-05:00How to Use SQL Server Group ByI found this great article on <a href="http://www.sqlteam.com/" target="_blank">SQLTeam</a> which shows <a href="http://www.sqlteam.com/article/how-to-use-group-by-in-sql-server" target="_blank">How to Use GROUP BY in SQL Server</a><br /><br />Very good step by step guide.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-34648857558272270702010-02-24T13:56:00.002-05:002010-02-24T14:11:48.039-05:00SQL Server Exists Not Exists dont work with min max Aggregate functionsIn my <a href="http://ajashadi.blogspot.com/2009/12/sql-server-rowcount-returns-1-if-min.html">last post</a>, I mentioned how @@ROWCOUNT gets affected when MIN, MAX i.e. aggregate functions are used.<br /><br />Today, I had similar issues while using EXISTS and NOT EXISTS. I was using NOT EXISTS and records were showing up when really it should have removed the results.<br /><br />select col1 from tbl1 where not exists (select min(something) from tbl2 where tbl2.col9 = tbl1.col2) <br /><br />select col1 from tbl1 where not exists (select distinct something from tbl2 where tbl2.col9 = tbl1.col2) <br /><br />Hope this helps.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-89775754275941602472009-12-04T12:09:00.003-05:002009-12-04T12:15:42.780-05:00SQL Server @@ROWCOUNT returns 1 if Min Max used in queryHi,<br /><br />I came across this crazy issue today. You expect @@Rowcount to return number of rows returned by query right. But in my case it was returning 1 for 0 rows returned. <br />Here is an example.<br /><br />SELECT *<br />FROM yourtable WHERE 1 = 2<br /><br />SELECT @@ROWCOUNT -- THIS GIVES 0<br /><br />But if you have MIN function being used, the result will be different<br /><br />declare @company_id int<br /><br />SELECT @company_id = min(company_id) <br />FROM yourtable WHERE 1 = 2<br /><br />SELECT @@ROWCOUNT -- THIS GIVES 1<br /><br />Apparently, since NULL was the result set, @@rowcount was giving 1 as the count.<br /><br />I hope this helps someone.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-46901335100291498712009-10-29T08:51:00.002-05:002009-10-29T08:56:46.214-05:00SQL Server Insert Into Identity ColumnWe all know that if you have an identity column and if you try to insert a value in the identity column, you will get an error. Here is how you can avoid the error<br /><br />First thing to do here is to set Identity to ON on the tblname you want to insert row in. <br /><br />SET IDENTITY_INSERT tblname ON<br /><br />INSERT tblname (ID,colname) VALUES(5,'ajas')<br /><br />SET IDENTITY_INSERT tblname OFF<br /><br />Do not forget to set IDENTITY_INSERT to off once you are done with inserting the record because you dont want it to be off if you have an application where developers will be working on it.<br /><br />Hope this Helps.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-9626605398709578002009-10-27T08:30:00.008-05:002009-11-01T22:02:49.617-05:00RDP End a Disconnected sessionWe all have had issues where in a RDP disconnected session wont allow other users to login until the administrator manually kills that disconnected session. Well, I just found out that there is a setting in Windows Server 2003 which would allow to automatically kill a RDP Disconnected session.<br /><br />Go to Start - Administrative Tools - Terminal Services Configuration.<br /><br />In Terminal Services Configuration, select Connections - RDP-Tcp. Right click RDP-Tcp and select properties. Go to sessions tab and select override user settings which is disabled by default. Here is a snapshot of the setting.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_yt7cinI9tdQ/Sub6WmWqoAI/AAAAAAAAAZg/Y2Z16pmzs30/s1600-h/TSC.jpg"><img style="cursor:pointer; cursor:hand;width: 320px; height: 158px;" src="http://1.bp.blogspot.com/_yt7cinI9tdQ/Sub6WmWqoAI/AAAAAAAAAZg/Y2Z16pmzs30/s320/TSC.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5397276469609799682" /></a><br /><br />Many thanks to <a target="_blank" href="http://www.sumoc.com/blog/index.cfm/2008/3/10/How-to-autologoff-remote-Desktop-Users"> Cameron Childress for this post</a> titled <a target="_blank" href="http://www.sumoc.com/blog/index.cfm/2008/3/10/How-to-autologoff-remote-Desktop-Users"><br />How to Automatically Log Off Disconnected Remote Desktop / Terminal Services Sessions</a><br /><br /><a href="http://blogs.msdn.com/rds/archive/2006/11/14/terminal-services-ts-remote-configuration-primer-part-ii.aspx">This article is also good.</a>Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-27876145549028874912009-09-22T08:26:00.006-05:002009-09-22T08:37:50.902-05:00Lets Fifa - Fifa 10 Demo TrailerIts that time of the year again. Yes, Fifa 10 demo is available for download.<br /><br />Here are some videos of previews. Enjoy!!!<br /><br />Awesome trailer<br /><br /><div style="width:400; height: 400px"><script src="http://www.ooyala.com/player.js?hide=endscreen&height=340&embedCode=VzcDJyOp2gYR4oD90I5AIsVQhJMaF82W&autoplay=0&width=400"></script><a href="http://fifa.easports.com/" style="color: black; font-size: 10px; text-decoration: none;">EA SPORTS FIFA 10</a></div><br /><br /><object width="400" height="344"><param name="movie" value="http://www.youtube.com/v/2FM4UPrAjnc&color1=0xb1b1b1&color2=0xcfcfcf&feature=player_embedded&fs=1"></param><param name="allowFullScreen" value="true"></param><param name="allowScriptAccess" value="always"></param><embed src="http://www.youtube.com/v/2FM4UPrAjnc&color1=0xb1b1b1&color2=0xcfcfcf&feature=player_embedded&fs=1" type="application/x-shockwave-flash" allowfullscreen="true" allowScriptAccess="always" width="400" height="344"></embed></object><br /><br /><script src="http://player.ooyala.com/player.js?orderDirection=desc&height=360&width=400&pcode=V1dWI6kUqVLb2fzXleCBXzNMRnjk&orderBy=uploadTime&hide=sharing%2Cendscreen&limit=100&labels=%2FTitles%2FFIFA%2FenUS"></script>Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com1tag:blogger.com,1999:blog-20038522.post-54434842945246720232009-08-31T09:22:00.002-05:002009-08-31T09:25:02.246-05:00SQL Server Hidden Gems PerhapsIf you ever wanted to get name of all the databases on your server, you can use this query<br /><br />In SQL Server 2000, select name from master..sysdatabases<br /><br />In SQL Server 2005, select name from sys.databases<br /><br />:-)Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-21950996373474657122009-08-30T17:13:00.004-05:002009-08-30T17:50:07.337-05:00ColdFusion CFID CFTOKEN Get lastvisit timecreated from CGLOBALI had a recent need to get information of CFID & CFTOKEN to see how many records we have in our datasource for CDATA, CGLOBAL and also from which date i.e. Last Min date to Last Max date the CGLOBAL table has values for. So I wrote this short query and then finally i cast the column as datetime so we can sort by date otherwise the sort will occur by string.<br /><br />select cast( substring(data, charindex('ts',data) + 4 , 19) as datetime) as 'lastvisit' , <br /> cast( substring(data, charindex('ts',data,charindex('ts',data)+4 ) + 4 , 19) as datetime) as 'timecreated', lvisit from cglobal<br /><br />where charindex('ts',data) gets the first occurrence and len('2009-08-18 22:36:55') gives you an idea of how many characters you need to extract and turns out its 19 characters.<br /><br />Link to how <a href="http://kb2.adobe.com/cps/185/tn_18514.html">ColdFusion Purges Client Variables</a><br /><br />Hope this helps someone.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-5403384584511575542009-08-26T12:16:00.005-05:002009-08-31T09:32:19.896-05:00ColdFusion Optimization Performance tuningNice articles for ColdFusion Optimization and performance tuning.<br /><br /><a href="http://kb2.adobe.com/cps/185/tn_18540.html">Adobe link for performance and scalability</a><br /><br /><a href="http://www.talkingtree.com/blog/index.cfm/2004/11/23/CFStability1">ColdFusion Tips For troubleshooting by Steve Erat</a><br /><br /><a href="http://www.webapper.com/blog/index.php/2009/08/03/coldfusion-request-tuning-settings-in-depth/">ColdFusion Request Tuning Settings in Depth</a><br /><br /><a href="http://www.talkingtree.com/blog/index.cfm?mode=alias&alias=CFStability2">ColdFusion Tips For troubleshooting by Steve Erat Part 2</a><br /><br /><a href="http://www.coldfusionmuse.com/index.cfm/2008/8/11/troubleshooting-part1-gathering-information">Nice post by Mark Kruger</a><br /><br /><a href="http://www.coldfusionmuse.com/index.cfm/2008/8/11/troubleshooting-part2-Stuff-to-try">Sick Server Troubleshooting Part 2 - Things to Try</a><br /><br /><a href="http://www.coldfusionmuse.com/index.cfm/2008/8/12/troubleshooting-part3-Attacking-the-Code">Sick Server Troubleshooting Part 3 - In the Soup</a><br /><br /><a href="http://www.stickyminds.com/BetterSoftware/magazine.asp?fn=cifea&id=99"><br />About Java Memory Management</a><br /><br /><a href="http://coldfusion.sys-con.com/node/41701">Toward Better CF Server Administration Part 1 of 2</a><br /><br /><a href="http://charliearehart.sys-con.com/node/41739"><br />Toward Better CF Server Administration Part 2 of 3</a><br /><br />Updated on Mon Aug 31. From Ben Forta's book, <a href="http://java.sun.com/developer/technicalArticles/Programming/Stacktrace/">Understanding Java Stack Traces From Exception.log</a><br /><br /><br />To Be Continued...Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-75072646357000607042009-08-26T08:38:00.003-05:002009-08-26T08:44:37.480-05:00SQL Server Hidden Gem - How to get next value of Identity for a column in a tableHi,<br /><br />This is very nice tip if you ever wanted to find the next value of identity column without doing an insert, I repeat without doing an Insert.<br /><br />Lets say you have a table named company. Then you would use this command<br /><br />SELECT IDENT_CURRENT('company') + IDENT_INCR('company')<br /><br />where IDENT_CURRENT gives the current or last identity value used by that table and IDENT_INCR gives the increment you/anyone had set during creation of table. It could 1, 2 etc depending on your logic.<br /><br />The other way of finding next value of identity is after an insert statement by using SCOPE_IDENTITY(). You would add 1 or 2 and so on depending on the autoincrement setting you used during the table creation.<br /><br />Hope this helps.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-58504274913131701842009-08-25T16:04:00.000-05:002009-08-25T16:05:53.079-05:00Spread The MAX Widget Around, Win Cool Prizes<img style="visibility:hidden;width:0px;height:0px;" border=0 width=0 height=0 src="http://counters.gigya.com/wildfire/IMP/CXNID=2000002.0NXC/bT*xJmx*PTEyNTEyMzQxNzU*NTMmcHQ9MTI1MTIzNDE4MjAzMSZwPTc3NDM3MSZkPW1heDA5d2lkZ2V*Jmc9MyZvPTk3MDIwZjAzYTllZTQ5OTA4MjQ1MWFjOWUyZjczMWZmJnM9Zm9ydGEuY29tJm9mPTA=.gif" /><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="MaxWidget" width="400" height="400" codebase="http://fpdownload.macromedia.com/get/flashplayer/current/swflash.cab"> <param name="movie" value="http://max.adobe.com/widget/MaxWidget.swf" /> <param name="quality" value="high" /> <param name="bgcolor" value="#869ca7" /> <param name="allowScriptAccess" value="sameDomain" /> <embed src="http://max.adobe.com/widget/MaxWidget.swf" quality="high" bgcolor="#869ca7" width="400" height="400" name="MaxWidget" align="middle" play="true" loop="false" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.adobe.com/go/getflashplayer" FlashVars="crtr=1&gig_lt=1251234175453&gig_pt=1251234182031&gig_g=3&gig_s=forta.com&gig_crtr=1"> </embed> <param name="FlashVars" value="crtr=1&gig_lt=1251234175453&gig_pt=1251234182031&gig_g=3&gig_s=forta.com&gig_crtr=1" /> </object>Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-24030727203777315142009-08-17T22:11:00.003-05:002009-08-17T22:27:40.311-05:00Unable to RDP. Enable Disable Microsoft Terminal Services Client Control mstscax.dllSo today i.e. Aug 17 2009 I was not able to remote desktop to my work computer from home. I am on WinXP Pro SP 2 with Internet Explorer 7 and I was able to remote desktop earlier without any issues. <br /><br />Today, I was getting the popup message saying you need to install active x control. See below <br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_yt7cinI9tdQ/SoodU_cUy3I/AAAAAAAAAZA/xWcxCIXN4Hg/s1600-h/RDP_Msg.jpg"><img style="cursor:pointer; cursor:hand;width: 320px; height: 103px;" src="http://4.bp.blogspot.com/_yt7cinI9tdQ/SoodU_cUy3I/AAAAAAAAAZA/xWcxCIXN4Hg/s320/RDP_Msg.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5371137752057564018" /></a><br /><br />I knew this had to do with Microsoft Terminal Services Client Control mstscax.dll and you need to enable it for RDP to work. For some reason, Internet Explorer 7, in its manage or enable disable add on feature wont show the Microsoft Terminal Services Client Control mstscax.dll. Here is a way to make it available so you can enable it.<br /><br />1. When you get the pop up to install active X control as pop up , you get 2 options, Run and Dont run (install or dont install basically). I selected Dont Install. I will tell you later why I picked dont install, so hang on to that thought ;-).<br /><br />2. Once I selected dont install, I got an small alert box or message info in yellow box from Internet explorer saying click here to enable / disable add on or something like that and had a hyperlink to click on. When I clicked on this hyperlink, the add ons were listed and the Microsoft Terminal Services Client Control mstscax.dll was listed at top as disabled. I enabled it and everything worked after that and I was able to Remote desktop again. Funny but when I was going through Internet explorer options to manage add ons, i was not able to see Microsoft Terminal Services Client Control mstscax.dll either enabled or disabled.<br /><br />Thats it. Follow this steps and it should work for sure. About the selecting Dont install option, I kept on selecting run or install option but I kept on getting the run active x popup again and again and nothing was getting installed. So when I selected Dont run, luckily everything started working out fine.<br /><br />Hope this helps.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com1tag:blogger.com,1999:blog-20038522.post-56556982771375718922009-08-04T21:38:00.001-05:002009-08-04T21:38:52.691-05:00Dalcha v/s Hawks. Aug 1 2009. Final.After 3 weeks of thrilling and exciting games, it's the Hawks who won the CPL trophy. Like any other league game, this match was no different and the Hawks had to work hard to win the finals as the Dalcha's pushed them to the limit. We witnessed Ujwal's semi final performance which was unbelievable and in the finals, it was his counterpart Sagar, who performed brilliantly, to lead the Hawks to a famous victory.<br /><br />The Hawks started with Sashi and Bhavin. Binnoy opened the bowling and gave only 5 runs of the first over. Sashi got out going for a big shot and Vinay joined Bhavin at the crease. Bhavin hit a six and four of consecutive balls and Hawks were looking good again with 16 for 1 after 2 overs. Vinay who played brilliantly in the semi final, couldnt get it going as He was not given any room by some fiery bowling from Binnoy. Kareem bowled well in the next over and got another wicket, this time of Vinay who made 5. Ujwal brought himself into the attack and got the prize wicket of Bhavin on the very first ball. The Hawks were in deep trouble under tough conditions and some smart bowling by the Dalchas. Captain Sagar joined Sirish in the middle and both started to rotate the strike well. Sagar stepped up on a day when his team needed the most. He hit 2 big straight sixes and 2 fours and suddenly the Hawks were flying high again. Sagar made an impressive 25 and was well supported by Sirish. So the Hawks finished with a decent total of 70, atleast 10 more than what it looked like when Dalcha were on the top. Kareem was pick of the bowlers for the Dalcha taking 3 wickets.<br /><br />The Dalcha had become smarter team as the tournament progressed and they showed that initially in their run chase. Harsha and Manvesh started cautiously and made sure they got run a ball. The Dalcha were 12 for no loss at end of 2 overs. Manvesh was first to go as He was run out for 5. Ashish joined the party at the right time and hit a big six over mid wicket. He followed that with another four and the Dalchas were taking the game away from the Hawks. The Dalcha's were 30 for 1 after 4 overs and looked all set for a victory with classy Harsha and powerful Ashish looking in control of the run chase. Sagar bowled the 5th over and what turned out to be the game winner. He took 2 wickets and gave only 1 run as the Dalcha's were 31 for 3 after 5 overs. Ashish made 14. Ujwal joined Harsha and took singles easily. Harsha hit two timely fours and once again the Dalcha's were breathing again. They were now 41 for 3 after 6 overs. Sagar bowled the 7th over and got the big wicket of Harsha, who top scored for the Dalcha with 15 runs. At the end of the 7th over, Dalcha were 44 for 4. 21 were needed now of the last 3 overs. The 8th over resulted in 9 runs and Dalcha neeed 18 of the last 2 overs. When Ujwal got out to the bowling of Mathew Hoggard Pavan, the game slipped away from the Dalcha's. Pavan gave only 2 runs in the 9th over and took 2 wickets in what was an amazing bowling performance. Dalcha needed 16 in the last over and they got only 1 run as they finished on 56 for the loss of 8 wickets giving the Hawks, the CPL championship.<br /><br />A great performance from both the teams under tough conditions. The game was played with good spirit and it was a pleasure to witness good sportsmanship from both the teams. The Dalcha got stronger and better as the tournament progressed. The Hawks on the other hand came up with close finishes, one after another, and showed they have strong batting and bowling, which is matched perfectly with their fielding.<br /><br />It has been a pleasure to write about the amazing talent we have here in Chattanooga. We have seen some brilliant displays equally matched with some classy sportsmanship and friendliness. I would like to say thank you for taking the time to read the bulletins and for your feedback. Before I end this and before I forget, I have one final thing to say. I want to thank you all for such an overwhelming response and reception you gave me at the presentation ceremony. I was speechless and it was out of the world feeling . Thank you all and thank you Bindu for that big whistle of yours. I enjoyed it very much.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-90173911388504574742009-08-04T10:55:00.005-05:002009-08-04T11:05:42.780-05:00Birthday Cake using Coldfusion & SQL ServerSo, I made this cake for one of my colleagues at work, M.J. , and I was thinking what to write on the cake.<br /><br />After a while, I got this idea of why not write something which she does, i.e. write queries every now and then. <br /><br />So, I wrote a CFQuery tag for her on the birthday cake.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_yt7cinI9tdQ/Snha5GOgWKI/AAAAAAAAAY4/OXabz_miOzc/s1600-h/CF_Life.jpg"><img style="float:center; margin:0 0 10px 10px;cursor:pointer; cursor:hand;width: 320px; height: 240px;" src="http://3.bp.blogspot.com/_yt7cinI9tdQ/Snha5GOgWKI/AAAAAAAAAY4/OXabz_miOzc/s320/CF_Life.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5366138892982442146" /></a><br /><br />ColdFusion is the way to go, pretty much, in normal life too. ;-)Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com1tag:blogger.com,1999:blog-20038522.post-6938455459493066442009-08-02T14:12:00.001-05:002009-08-02T14:12:54.969-05:00Blazers v/s Hawks. Aug 1 2009. Semi Final 2.Who is the man, you ask and I say, Bhavin. Fantastic, Amazing, and Brilliant, at his best; He has performed in every game and He didnt dissapoint his team in the Semi Final against Blazers. He stood tall again and his innings along with Vinays power hitting, made the difference to the game. Before I go into the match details, one more thing, I would like to add. For some reason, I forgot to give credit to star batsman Vinay, for his beautiful innings on the opening day when He scored 30 plus. When I wrote Preview for Semi Final 2, I wrote about him as one of the danger batsman to watch out for and also updated the bulletin page for that game.<br /><br />The Blazers won the toss and elected to field first, which I guess most captains did in CPL and won 90% of the games. So nothing wrong with that. Sashi and Bhavin opened the innings and Ravi Bachala bowled the first over. He gave only 8 runs and it was a decent start. The Hawks started carefully and by end of 4, they were 36 for 1, with Sashi gone for 10. In came the dangerous hitting batsman Vinay. The very first over He faced, He blasted 2 sixes and 2 fours as 22 runs came of the 5th over. So from 36 in 4, Hawks were 58 at the end of 5 overs. Vinay got out going for another big hit but not until He had made a quick fire 21 of just 6 balls. Bhavin continued where Vinay had left and in the 6th over, He hit 2 big sixes over mid wicket region. In the next over, He hit 2 more sixes, this time over squre leg and the Hawks were on the top with 98 after just 7 overs. Some more big hits and good support from Pranav and Abhilash who scored 7 each, took the Hawks to the highest total of the tournament, 127. Bhavin top scored for the Hawks with 64 not out. An innings of sheer brilliance and class, as He dominated the bowlers at will. He hit 7 sixes and 2 fours and ended up with tournament record of maximum sixes in an innings.<br /><br />The Blazers started with the dynamic duo of Manohar and Ramesh. Manohar started the innings with a big six over square leg, sending a message, that this game is up for grabs. He followed the six with a four and the game was wide open. 15 runs came of the first over and the Blazers had started with a thunder. But some disciplined bowling by Hawks resulted in only singles and twos. The batsmen tried to go for their shots because of the huge total they were chasing. The Blazers lost wickets regularly in the process and could not catch up with the ever increasing run rate. Manohar top scored for the Blazers with 13, followed by Sunil, who made 12. In the end, the total of 127 was too much of a task. The Hawks ended up winning this game easily. Pavan was the pick of the bowlers as He took 4 wickets.<br /><br />The Blazers had one bad day at the office and that meant advantage Hawks. Just like how South Africa and Sri Lanka lost only 1 game in the whole T20 World Cup, the Blazers found themselves in the same situation. Things didnt go well from the beginning and it was an off day for them. The Hawks on the other hand went from strength to strength and came up with a victory to reach the finals.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-69009716475231924642009-08-02T12:19:00.000-05:002009-08-02T12:20:20.953-05:00Veterans v/s Dalcha. Aug 1 2009. Semi Final 1.The word Ujwal means bright or you can say shining. Indeed, true to its meaning, Captain Ujwal shined when his team needed the most. He remained calm and cool and bowled probably the best over of the tournament, when it looked like they were going home early from the party.<br /><br />Radha won the toss and elected to field first which was no surprise as the field was wet and conditions suited the team batting second. Ashish opened the batting with Harsha. Ashish started the proceedings with a big six over squre leg region in the very first over as 9 runs came of it. Good start right. Radha gave debutant Ramesh, who was a last minute addition, the 2nd over. What does Amchi Mumbai boy Ashish do? Well, He saw the first ball and defended it. Next ball, He whacked it way over long on for a big six. But next ball He tried again but this time it took an edge and He was caught behind by Keeper Rajesh. Another wicket fell in same fashion in the same over. End of over 2, Dalcha were 17 for 2, out of which, Ashish scored 14. He ended up top scorer for Dalcha in this game. Ujwal, played sensibly, along with Arif, who again hit a huge towering six over midwicket. Ujwal made 7, Arif made 8 and when they were out, Dalcha were 47 at end of 7 overs but had lost 5 wickets. Wickets kept on falling until Krishnan stood firm at the crease. He put on a brave show as He scored 11 not out which included a four, and made sure Dalcha finished their 10 overs. Dalcha ended up with 64 at end of 10 overs and lost 8 wickets. Remember the number of wickets, as it will get interesting later on. ;-)<br /><br />The Veterans started with Chari and Neelanjan, hero of the last league game. The Veterans couldnt get it going because of some tight bowling by Ujwal and Ashish. Ujwal gave 2 runs in the first over and Ashish gave 4 in the 2nd and Veterans were stuck at only 6 runs at the end of 2 overs, probably the lowest total of the tournament after 2 overs. Ujwal bowled 3rd over and got a wicket first ball. In came Shiva, who was opener for Veterans in earlier games. First ball He faced, He hit a big, and I mean very big six over long on, keeping his tradition for hitting big sixes. Perhaps, his real name is Sehwag rather than Shiva, because thats the only way He knows to play. He was very unlucky as He was run out for 8 in just 3 balls. Bindu was the next man in. He was dropped early on in his innings and He made sure He made most of it as He hit 2 big sixes over mid wicket to up the run rate and bring back Veterans into the game. He was well supported by Captain Radha at the other end. Radha hit some fours and the game was well within Veterans reach. Binoy took 2 crucial wickets as He had Bindu caught on the boundary and in the next over, He got the prize wicket of Radha. Bindu made 16 and Radha top scored for the Veterans with 20. So after 8 overs, Veterans were 55/5 and needed only 10 of 2 overs. The 9th over was bowled by Kareem, who stepped up at the right time. He gave only 3 runs, as 3 balls were dot balls and also took 1 wicket and game changed completely. From an easy situation of 10 in 12 balls, the Veterans now needed 7 in 6 balls with 3 wickets in hand. So who would bowl last over? Ashish had bowled only 1, Ujwal 2, Kareem 3, Binnoy 3 and Arif 0. So what does Ujwal do? Bring the experienced Abdul Razzaq Arif or give Ashish a chance? He brings on himself when all eyes are set for the biggest prize at stake, the entry ticket for the final of CPL. The first ball was a single. 6 needed of 5. The next ball was a dot ball. 6 needed of 4 balls. A wicket fell on 3rd and 4th ball. So now 6 were needed of only 2 balls. 5th ball resulted in single. So now 5 were needed of just 1 ball. The last ball also resulted in single and the Veterans fell short by a small margin. Credit to Ujwal for bowling that last over under tense situation. The Veterans who looked good throughout the game and were winning easily, lost the plot in last 2 overs of the game. Kareems 9th over and Ujwal's final over resulted in a famous win for Dalcha.<br /><br />Here is an interesting stat from the game. When only 7 were needed of last over, Veterans had lost only 6 wickets. What it means is, they needed only 6 runs to win the game as the tie would have resulted in a win for them, since they had lost 6 wickets compared to 8 by Dalcha. They lost 2 wickets in the last over, and a tied game would have given us another interesting stat. As per rules, 1. we look at wickets, and since they were 8 down in last over same as Dalcha's, rule 2 would have applied i.e. 2. we look at what both teams had scored after the end of 5 overs and you wont believe what was the equation. Dalcha were 30 for 4 at the end of their 5 overs and the Veterans had scored the same, yes, that is correct, 30 runs but had lost one less wicket i.e. 3. So even this rule was favouring them to win the game. Yes, it was that kind of a game and it was that close of a finish. Cricket is indeed a funny and tricky game. You never know what will happen.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-32190232424456003192009-07-27T21:05:00.000-05:002009-07-27T21:06:37.833-05:00DareDevils v/s Blazers. July 27 2009. Match 18.Ravi Bachala's timely 31 enabled the Blazers to another victory. He put up a show of classy batting today for the Blazers. DareDevils fought back well but could not come up with a win. What this means is that DareDevils are out of semi final race. They play Cheetahs next in the last round robin game of the tournament.<br /><br />The Blazers won the toss and elected to bat first. Ravi Bachala started the innings with Ravi K. By the time, the first wicket fell, Blazers had scored 19 of 2 overs. Ravi Bachala was timing the ball well and hit 2 sixes and 2 fours on his way to an impressive 31 runs. When He got out, the score was 59 in 5 overs. This was the break through, the DareDevils needed, as they tightened the screws on the Blazers. Sunil played his part and scored 10. Ramesh batted sensibily along with debutant Makam Ravi, to take the Blazers to a total of 84. For DareDevils, Suman took 3 wickets with his accurate bowling.<br /><br />The DareDevils lost a wicket in the first over. Vinod joined Suman and both setup a partnership of 24 runs with 6 runs coming of every over. Vinod was next to go. He tried to go for his shots and was out, caught and bowled by Sunil for 15. Selva came in and started hitting shots showing his intention. Suman again played well and made a classy 16. He hit a beautiful straight drive for a four in his innings, which was a delight to watch. Selva went after the bowling but it was little too late for the DareDevils. They ended up on 74 in their 10 overs. Selva top scored with 29 not out.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-7127994873047651362009-07-26T13:44:00.001-05:002009-07-26T13:44:56.217-05:00Blazers v/s Veterans. July 25 2009. Match 17.A power packed innings from Manohar resulted in a win for the Blazers in a tight last over finish. The Veterans and Blazers gave an impressive performance but Manohar's innings made the difference.<br /><br />The Veterans were put in to bat by the Blazers. Shiva looks to be like Sehwag for the Veterans as He hit 2 big sixes again, one in the very first over. He made a quick fire 17. Rajesh and Radha formed a good partnership and both top scored for the Veterans with 26 runs. Both hit some amazing shots over square leg and mid wicket. Rajesh hit 3 fours and a six, Radha hit 2 sixes with one four. The Veterans scored a challenging total of 90 runs in their 10 overs.<br /><br />The Blazers started with Dennis and Ramesh. Ramesh, minus his usual business formal dressing this time, started with a bang as He hit a big six over square leg. He followed that with another six and Blazers were right on track. Dennis played his part and hit a huge six over mid wicket region and the game was going away from the Veterans. But Dennis was out in the deep and now 47 were needed of the last 4 overs. Manohar came to the crease and started hitting the ball well. He took 22 runs of the 7th over over as the game changed completely. Now only 25 were needed of the 3 overs and the Blazers made sure they didnt lose the plot. Manohar made 37 not out and was well supported by Harish who made 9. But the credit should also go to Ramesh who made a brilliant 20 under pressure conditions along with Dennis, who made 21. A complete team performance from Blazers as they emerged victorious in a tense finish, by scoring 91 in 9.4 overs.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-26606908123716283392009-07-26T13:12:00.000-05:002009-07-26T13:13:09.076-05:00DareDevils v/s Power Builders. July 25 2009. Match 16.The DareDevils registered their first victory of the tournament eventually knocking out Power Builders from the semi final race. Some decent batting from DareDevils made sure they got a much deserved victory in only 8 overs.<br /><br />DareDevils won the toss and asked Power Builder's to bat. The Power Builders started well with Satish and Harsha. Harsha scored 20 and Satish top scored for the Power Builders with 31. The Power Builders were 37 for 1 after 4 overs and finished with only 73 in 10 overs as no other batsmen performed. Mohan picked up 3 wickets for the DareDevils followed by Senthi and Selva with 2 each.<br /><br />The DareDevils started with Abhishek and Suman. Abhishek took the game away from Power Builders as He hit 2 big sixes. This is just what DareDevils needed after their tough loss a day before against the Veterans. After 2 overs, they were 22, way ahead of the required run rate. Karim bowled his heart out and gave away only 2 runs, with 1 wicket, in the 3rd over to bring back the Power Builders. Abhishek made 16. Vinod joined Suman and played some impressive shots. He took 21 of one over and it was all over for the Power Builders. Suman played good at the other end and made sure He stayed till the end. He made 17 and made sure the daemons of the Veterans game wont come alive. Vinod top scored for the DareDevils with 25 runs. The DareDevils scored 74 in 8 overs and won the game easily.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0tag:blogger.com,1999:blog-20038522.post-15439129796885849352009-07-26T12:49:00.000-05:002009-07-26T12:50:18.064-05:00Cheetahs v/s DalCha. July 25 2009. Match 15.The Cheetahs found themselves unlucky again as the match ended up in a very close finish. The Dalcha's would be very happy to get their 3rd win when it looked like they are about to throw the game away.<br /><br />Cheetahs won the toss and asked Dalcha's to bat. The Dalchas started badly and were 3 down for 25 at the end of 5 overs. In came captain Ujwal and Arif to the crease. They started rotating strike well and got 25 runs in next 2 overs. They were 49 for 3 after 7 now and were heading towards a decent total. But Ujwal and Arif thew caution to the wind and started going after the bowlers. The last 3 overs resulted in 40 runs and Dalcha were sitting pretty with a total of 89 in 10 overs. Ujwal played a captains knock and top scored with 44 not out, with 4 fours and a six. He was very well supported by his partner Abdul Razzaq a.k.a Arif, who scored 32 not out with 3 sixes.<br /><br />The Cheetahs started with Anand and Ganesh. Ganesh was first to go, bowled by Karim. Anand played good and hit a six before He was bowled by Karim for 14. Ram and Sudhakar, started playing well and formed a good partnership. Ram got out at 14 and Sudhakar made 11. Pradeep came to the crease and started hitting the ball well. Cheetahs were 56 for 4 after 6 overs and needed another 34 in last 4 overs. But they started losing wickets and when Pradeep fell, it was all over for Cheetahs. Pradeep made 21. 11 were needed of the last over and after some good shots from Ramesh, it was 3 needed from the last ball. The shot was played to long off and crazy throw resulted in an overthrow as Cheetahs got a second run and were running for the third run, which would have given them a victory. But Kareem, kept a cool head and walked over to non strikers and ran out the batsman. The game was tied but Dalcha's won, since they had lost less wickets. The Cheetahs finished with 89/8 after 10 overs. Kareem picked up 3 crucial wickets and remained cool in the end to get the run out.Ajas Mohammedhttp://www.blogger.com/profile/17775044000504284452noreply@blogger.com0