By Sumit Gupta on January 19, 2012
Mysql mostly provide a Case sensitive search because of its default collate configuration. However SQL server use different collate and hence by default it is not case sensitive. It is good to not having case sensitive search by default, as except password compare you most often doesn’t need case sensitive search. Do you? well I never really need that, anyways. Those who wonder how they can get case sensitive search should look this good article
http://blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/
It simply case to change the collate value of column for which you want to get case sensitivity, by defining COLLATE Latin1_General_CS_AS to field declaration.
You can check existing collate of each field using
1
| EXEC sp_help [tablename] |
1
| ALTER TABLE [tablename] ALTER COLUMN Password VARCHAR(32) COLLATE Latin1_General_CS_AS |
However why are you wondering for case sensitive for password field? aren’t you doing MD5 or other conversion on your password for security already ? 
.
Posted in Database, MS SQL Server, SQL | Tagged COLLATE, Password Protection, Search, SQL, SQL Server |
By Sumit Gupta on December 14, 2011
After a very bad experience in hosting service and try like of godaddy, 1and1, bluehost and few other, I finally reach HostGator. They are still a traditional hosting provider but at least their server works. It is not that you cannot find a good hosting then hostGator, but comparing to $$ spend on hosting decide the quality a lot. I use company like Rackspace and Hosting.com, they are really what a quality hosting should be, but considering their fee, it is not reachable to every day to day client.
However, I use their USA server and it was not quite good, maybe too much overloaded, though for my blog I use their Indian Server and since it is new server and probably not so much loaded yet, it works great for me from last 3 months. They have down time of about 10-15 minute here and there, maybe server just get too overloaded at time, been a shared hosting server, but otherwise it is normally a good speed. My clients are happy that my project management system finally works for them, and this is great achievement in itself.
Anyways, my new working environment is going solid. Increase my productivity a lot just waiting for good results to come with time.
Posted in Blog: My thoughts |
By Sumit Gupta on November 16, 2011
Just look at my Stats counter and it show about 6500 spam comments been posted on my blog so far in 1 year time span. This is small number as compare to page visit per day on blog, but still looks like lot of people try to spam me. Phew I am somewhat safe till date.
Posted in Joyous, Other | Tagged Joyous |
By Sumit Gupta on November 5, 2011
Been involve in technical field, I have encounter lot of technical hurdles. There has been some new problem always, and I somehow manage to escape them by solving those problem. Though not all problems are solvable is what I learn overtime and you need to take different route to nullify the effect of such things. In last 3 years, I had a good time with all freedom I enjoying working on project that I love to and try to finish and accomplish them with my methods. It has been a great evolution process for my knowledge.
Though it doesn’t seems as comfortable now, as the difference between me and my dream has grown bigger. My dream is around building a team of technical person help or work with me to achieve goals we set. We want to achieve the standards we set over other counterpart of ours. Though the term team seems to be the biggest challenge to get at this stage. With economy going no where, finding good person is becoming equally hard. About 18 months ago, you will find all sort of talent around you, but now I see a downside which is effective by two things mainly:
1. No one is willing to take responsibility of work. It is not that this is uncommon thing to human, but it has increased a level where you just cannot trust your employee to any degree. Even if you pay them double the salary, but they know they are just employee and one day they use your double salary to get hired in another company with even more money.
2. Freedom from work, eventually you will read on internet or articles in magazine that people look for freedom at work, but I said they look for freedom from work. If you don’t ask them to follow your well tested methodology and don’t ask them to finish in time, they are happy to work for you, but otherwise they says we need freedom to work our way and hence they don’t like you.
These unfriendly act of candidate here leave me in two mind to go with them or not to go with them. I see some of them does has good thinking brain, but they are not willing to work. I can make good software but I am not god to make good human.
Always in search of good developer who help me go along, but I decide not to work with one who is not more than an employee. I will now work for great peoples only, either they are my client or my team members.
Posted in Blog: My thoughts, Rants | Tagged Rant |
By Sumit Gupta on October 11, 2011
I see lot of people asking about GDI+ Generic Error. Since this is “generic” error nobody can tell what is wrong with code. So did a work around and get it working. I had this error quite a time in early days of my programming and just found same error in one of junior’s code. Well from my experience I can say one thing. GDI+ Generic error 99.9% means “developer miss a detail or overlooked something”. Most common reason of error are negligence of
1. Path should be physical path
2. All folder should present before you create file.
3. Previous files should be in write mode if case of overriding files.
4. Make sure permission are for writing to User of process.
5. Do not include any special character which windows do not permit in folder name or file name.
6. FILE FORMAT has nothing to do with this error most often.
7. Recheck permission if you try all above.
8. Recheck Path again .
Point #7 and #8 are most important solution and always works for me.
Posted in .NET, ASP.NET, C#.NET, VB.NET/VB, WPF | Tagged .NET, GDI+, Generic Error |
By Sumit Gupta on October 11, 2011
Lately I got a chance to work on lot of server. Working on 6-7 server in 15 days it not much for a full time server admin, but for a programmer who only manage server to fasten his development process is really long ask. During this process I have 2 encounter with Plesk and unfortunately both time Plesk proves to be a pain in neck.
First encounter was during setup a new Windows machine. My client purchase a Leased Term license of plesk and in return plesk send them 10 days temporary license which is expected to install on server and later plesk will auto update the license from online server. This is what I understand during our communication with plesk. However my client took 15 days to pass me the license and server access or you can say they hire me after 15 days of buying license. When I install plesk and try to upload license it naturally says, it is expired. Then we try to contact Plesk support, we call USA support, India Sales support, email to plesk, but no response and no guidance how we get corrected license. After 7 days of talking with plesk we drop the idea of having plesk on server.
Here comes the second problem with plesk. You just cannot run the “uninstaller” because they never build uninstaller for their PERFECT software. luckily my client get the computer formatted at no additional cost, otherwise I have to search and delete all file manually, which I don’t want for two reason. I hate deletion they always leave traces anyways and it is lot more work then expected.
We later use Microsoft’s Free WebsitePanel. An Awesome software with ease of use for our purpose. We can install any version of SQL Server, MySql, PHP, ASP.NET and configure that easily. Plus we pay nothing to get it.
My second encounter came with a Linux/CentOs Based VPS with Plesk, where I need to upgrade the PHP version from 5.1 to 5.3 on client demand. I search on internet and found that Plesk do not distribute PHP so they do no provide any upgrade method. But there is atomic shell script available to help update. I did that update. PHP was upgraded. We run it, but as you have expected Plesk is broken now. Been on VPS it frequently goes out of memory and create all problems. We ultimately decide to drop that server as it is just test server .
I got saved both time and will never try a Plesk. Horrible software, powered by horrible support. Plesk is good for non experience, but nightmare for custom requirements. Never use it if you love to configure your server for speed or customization.
Posted in Rants, Server Configuration | Tagged Plesk, VPS, Websitepanel, Windows |
By Sumit Gupta on September 19, 2011
Well if you search topic on google you will find lot about it. But here is quick guide for me with little explanation.
1. Plesk do not ship PHP as it’s integrated part, so it ask you to upgrade outside plesk and they do not provide support on it.
2. On Linux you can use default APT or YUM to upgrade PHP. In my case it is CentOS/Red hat flavour so this article apply to that mainly. Now when I try to upgrade from PHP 5.1 to PHP5.3 I cannot do that as default CentOS repo shows PHP53 as different package and do not come under default upgrade. And it though gets in conflict with PHP5.1′s current install.
3. I try to Erase existing package and thought to install PHP 5.3 afresh. But it shows a list of 110 dependencies which mainly consist of Plesk’s module. Otherwise it was fairly okay to YUM ERASE PHP. So, I have to opt for this solution which works 100% for where I read about it.
4. Atomic Corp create a script then on Red Hat favour enable 5.1 to 5.3 upgrade (Their WIKI: http://www.atomicorp.com/wiki/index.php/PHP ) Once you run this SH script you can re-run YUM to do the update. Steps are:
1
2
3
| # wget -q -O -http://www.atomicorp.com/installers/atomic.sh
# yum upgrade php
# service httpd restart |
Bingo !!! PHP upgraded. No server restart needed.
Posted in Operating System, PHP, Server Configuration | Tagged atomic, php, PHP Upgrade, Server upgrade |
Recent Comments