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 this be…

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 this be…

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 private k…

Good stuff on Normal forms

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

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.

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.

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.

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.