Posts

iphone 4 ipod touch Change Delete Edit Update wifi wireless key wireless password wireless connection wireless network

So 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? Here is what I ended up doing. 1. Go the Settings, Click on Wi-Fi 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 3. In my case, since I had to enter the new key for wireless network that was already setup before, I clicked on Other... 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. Few other suggestions I found over the net. 1. Go to WiFi Networks and click on arrow next to the wireless network name and choose Forget this network. I didnt try t
Post a Comment
Read more

iphone 4 ipod touch Change Delete Edit Update Delete wifi wireless key wireless password wireless connection

So 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? Here is what I ended up doing. 1. Go the Settings, Click on Wi-Fi 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 3. In my case, since I had to enter the new key for wireless network that was already setup before, I clicked on Other... 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. Few other suggestions I found over the net. 1. Go to WiFi Networks and click on arrow next to the wireless network name and choose Forget this network. I didnt try t
Post a Comment
Read more

Java Keytool Export Private Key, PKCS#12 or .p12 export or conversion from java keystore

So, 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. 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. 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. You can download these free products from here. The tools are portecle-1.5 http://sourceforge.net/projects/portecle/ KeyTool IUI – GUI http://www.icewalkers.com/download/KeyTool-IUI/3073/adl/ For my needs, i.e. generate a PKCS#12 certificate from an existing java keystore, portecle-1.5 worked just fine and it was very easy to use. I also tried the KeyTool IUI – GUI just for testing the tool and it helped me to export the p
6 comments
Read more

Good stuff on Normal forms

Database Normalization stuff here
Post a Comment
Read more

SQL Server Index Articles

Here are some good articles on SQL Server Indexes. SQL Server Indexes: The Basics SQL Server Indexing Basics SQL Server Indexes
Post a Comment
Read more

How to Use SQL Server Group By

I found this great article on SQLTeam which shows How to Use GROUP BY in SQL Server Very good step by step guide.
Post a Comment
Read more

SQL Server Exists Not Exists dont work with min max Aggregate functions

In my last post , I mentioned how @@ROWCOUNT gets affected when MIN, MAX i.e. aggregate functions are used. 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. select col1 from tbl1 where not exists (select min(something) from tbl2 where tbl2.col9 = tbl1.col2) select col1 from tbl1 where not exists (select distinct something from tbl2 where tbl2.col9 = tbl1.col2) Hope this helps.
Post a Comment
Read more

SQL Server @@ROWCOUNT returns 1 if Min Max used in query

Hi, 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. Here is an example. SELECT * FROM yourtable WHERE 1 = 2 SELECT @@ROWCOUNT -- THIS GIVES 0 But if you have MIN function being used, the result will be different declare @company_id int SELECT @company_id = min(company_id) FROM yourtable WHERE 1 = 2 SELECT @@ROWCOUNT -- THIS GIVES 1 Apparently, since NULL was the result set, @@rowcount was giving 1 as the count. I hope this helps someone.
Post a Comment
Read more

SQL Server Insert Into Identity Column

We 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 First thing to do here is to set Identity to ON on the tblname you want to insert row in. SET IDENTITY_INSERT tblname ON INSERT tblname (ID,colname) VALUES(5,'ajas') SET IDENTITY_INSERT tblname OFF 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. Hope this Helps.
Post a Comment
Read more