Archive

Author Archive

Beginner Techies guide to Software Development Industry

June 20, 2015 Leave a comment

Hi all, hope you are a new techy who is willing to join software industry in later. If so you are most welcome to read this one.

First thing, you should have a dream what is your ambition to be. You can google for available opportunities, corresponding responsibilities and salary scales in current computer related job market. Second, don’t neglect your current academic stuffs if you are studying in computer science related field. Because basics are the most important thing in many intern and initial interviews. There are students who got many qualifications but still waiting for a job.This is due to lack of preparation and ignore basics. If you are just start your academics in computer field. Start today; don’t waste your time. Try to understand everything you learn. There may be some theatricals boring parts. At least try to understand programming parts and practical.Don’t copy and paste in assignments and in home works. I know it’s very easy and we understand lot. But you miss errors and how to think in different problem situations.

Computer Language skills

There are myths about this in many students mind.

1 : You should know each and every language industry required. This is not so true. Sure companies need specialist in their development environment. It’s almost enough to learn similar technologies. For an example normally most of institute teach c/c++ or java. C# coding is much similar to java and most of programming concepts are similar except some advance parts. When you are competing for beginner level it’s enough to learn only one language but you must excel in that language.

2 : What language is the best one to study.

There are trending languages but it changes. You should keep in touch with that trending. There are many computer technologies related online magazines that publish posts about that. e.g. mashable.com If you are planning to do academic projects try to do with that language. It’s worth hundred time than reading a tutorial.

3 : Programming concepts

As I mentioned earlier basics are the most important. Algorithms and Data structures gives you confident for developing logics in given problem.Design patterns makes you perfect in designing programs and finding solution . Language is not a problem when  you know programming logics correctly. And you can learn any language within small time.

Hope this post will guide to beginner techies who is willing to join with software industries.

Until my next post cheers..!!!

Categories: Uncategorized

Beginner techies guide to Internet World

May 18, 2015 Leave a comment

Thanks all who commented for last post.I know most of you don’t need that post but if you are an actual beginner it’s more useful and you can save your time for testing those basic things.

Blogging

The term “Blog” is derived from Web log.These sites are useful to address internet community.They are listed as Social Network because Interaction of community and authors.Authors publish articles and readers comment to those articles.But not like other common Social Networks most of blogs address to special groups.It depends on What you write.If it’s a sport blog.Readers will be sport fans.If its your personal blog then readers will be your friends and followers.Sometimes no one reads blogs because its not worthy to anyone or cant find your blog URL.Why bloggers do this imgresblogging.Do they want to spent time for nothing ?. No.The main thing its big plus point if you are trying to join IT related industry.And also when we blogging we need to search many things so we can improve our knowledge from that.To become a good writer first you need to be a good reader.Not only that we can also earn from blogs by publishing ads in our blog.Google adsense is the famous one but there are many more similar once.

There are many free blog providers.I recommend  Blogger.com if you are a very beginner.It has a collection of themes and features.But I prefer imgreswordpress.com since it provides many plugins widgets and themes than blogger.Most people don’t write blogs because they have nothing to write.I can remember how did I post my first blog post.I was waiting and waiting.It took me nearly 6 months to write.I posted just some basic java code sample and its result.Usually you don’t find any interesting thing to post until you start your first one..!! Techies world isn’t wait for no one start today don’t delay it..!!! use following link to refer more about blogging..  http://rasikaonline.blogspot.com/

And also you can use blog posting sw like Livewriter that is a free imagesoftware to edit as MS Word and post your article.Remember no one can find you when you are posting with different name.So don’t worry about what you post.Just give a try.One last thing don’t copy articles itself.If you have to then publish source link as well.

Tweeting

Twitter.com is a micro blogging site which allow us to publish small post imgreswith at most 14o characters. The main advantage of this is you can stay touch with new technologies by following big heads of tech world.Even you can follow Bill Gates there without his permission.But you can hide your post from others by adding some privacy.
There are some rules in tweeting posts.you can notice some other person using  @tweeterusername tag(eg:@csupmag for this techzoom magazine)and if it’s a general term use #term(eg: #techzoom).Also another this if you want to retweet someones post use RT tag before post.And also you can connect it with Facebook account and can update fb status updates from twitter.First check some other tweeter accounts what they tweet and then decide what to tweet..!!!for more info use following links http://bit.ly/oxM3xN.
I think its better to stop this now.Please drop your questions comments and suggestions if you are interested about this post.I hope to give some special searching techniques in internet and some other techy stuffs in next post.
Until next post cheers..!!!
Categories: Uncategorized

Issue in accessing blogger site with live writer

January 1, 2015 Leave a comment

Today I installed live writer 2012 into my PC but I couldn’t access Blogger sites with live writer. But it worked with WordPress and other sites. I searched and found that Google has changed their security policy and remove access to blogger with external tools like live writer.I could overcome this issue with following steps:

Go to https://myaccount.google.com/ or simply account settings. Under Signing in title it has option Access for less secure apps set to Blocked. Just click on this option and set to enable. And another thing if you don’t have blogger account this option might not visible.

Categories: Issues Tags: , ,

Solution for problem with starting MSDTC and Missing Local DTC in Windows 7

June 28, 2012 2 comments

When I tried to execute one of C# application that is using transaction scope, I found that i couldn’t start MSDTC service( I was using windows 7(64bit)).I tried following link and solved that problem.

link:http://social.technet.microsoft.com/Forums/en-ZA/winserverhyperv/thread/d3de5460-fb42-4af0-ac75-27c22741c7e9 .

Then I found that there are no Local DTC in MSDTC.(I checked with component services ( start->type component services)).I tried following steps too.But still no luck.(But hope sometimes it works).

msdtc

1) Stop the Distributed Transaction Coordinator service in the Services Control Panel

2) At a command prompt run "msdtc -uninstall" without quotes. This removes the MSDTC service from the Services Control Panel and the associated service hive along with the CIDs and CID.Locals from the registry:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSDTC
HKEY_CLASSES_ROOT\CID
HKEY_CLASSES_ROOT\CID.Local

3) Skip this step if you want to preserve existing configuration, such as network transactions and other MSDTC security settings. Otherwise manually delete the following registry keys if they exist:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSDTC
HKEY_CLASSES_ROOT\CID
HKEY_CLASSES_ROOT\CID.Local
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC

4) At a command prompt run "msdtc -install" without quotes. This reinstalls the MSDTC service and the 4 registry hives above.

5) At a command prompt run “msdtc –resetlog” without quotes

Then I browsed to C:\windows\System32\MSDTC folder but I couldn’t access that one.Next I reboot machine and logged in safe mode and deleted that folder and create new MSDTC folder.

Still I couldn’t found Local DTC.Then I stopped windows firewall service in services.msc and virus guard firewall service.Then I tried above steps.Eureka now it works fine. I found that it was happen due to some Microsoft updates.It’s not fair to forget the key factors in solving this.Thanks Dilshan and Kavinda bro’s.

Hope this one help you to solve your MSDTC problem.Until next post cheers..!!!

Categories: Issues Tags: , , ,

MSSQL useful tips

March 13, 2012 Leave a comment
  • MSSQL set null when value is not numeric in select query
SELECT CASE ISNUMERIC(column1) WHEN 1 THEN column1 ELSE NULL END FROM table1
  • SQL Server Error Messages – Msg 8152 – String or binary data would be truncated.  The statement has been terminated.

This error message is occurred when I tried to insert data to values from another table.It’s due to one column in the table that im inserting data have lesser length than other table column.(varchar(25) – varchar(max)).It couldn’t found previously because second table column I have used max length but when inserting data it filled with strings that contains more than 25 characters.

I found another command to skip that error and continue but its like a try catch statement without catch part(thanks yasindu bro for nice example).

SET ANSI_WARNINGS OFF

Need to use above command before inserting records.but sometimes it’s not working

  • Inserting multiple records to a table

This isn’t simple thing but I previously work with MySQL and that is different and we can’t use

INSERT INTO tblName (column1,column2)
VALUES
('Value1','value11'),
('Value2','value22'),
('Value3','value33')
INSERT INTO tblName (column1,column2)
select ‘Value1′,’Value11’
UNION ALL
select ‘Value2′,’Value22’
UNION ALL
select ‘Value3′,’Value33’
Categories: Issues, Programming, TSQL Tags: , ,

How to find a specific string from stored procedures, triggers and functions in database

January 12, 2012 Leave a comment

There are several tables and views containing stored procedures, functions and triggers definitions

Views – SYS.SYSCOMMENTS, SYS.SQL_MODULES

Tables – INFORMATION_SCHEMA.ROUTINES

I recommend following query it shows all SPs and Fns that contains any specific text.If we want to search only procedure then  filter in where clause “AND obj.Type=’P’”

SELECT DISTINCT obj.name AS Object_Name,obj.type_desc 
FROM sys.sql_modules sm INNER JOIN sys.objects obj ON sm.object_id=obj.object_id 
WHERE sm.definition Like ‘%search text%’

If we want to search specific function or objects names we can find dependencies using following system stored procedure

EXEC sp_depends @objname =searchobjectname

There is another way to find specific text using INFORMATION_SCHEMA.ROUTINES. But for me it didn’t give me all the results.

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE
‘%search text%’

AND ROUTINE_TYPE=’PROCEDURE’ (for procedures only)

And  also SYS.SYSCOMMENTS view can use to same usage but I got duplicates from some results.

SELECT SO.NAME, SC.TEXT
FROM SYS.SYSOBJECTS SO

JOIN SYS.SYSCOMMENTS SC ON SO.ID = SC.ID

WHERE SC.TEXT LIKE ‘%search text%’
–SO.TYPE = ‘P'(for procedures)

Hope this post helps you.Feel free to give your suggestion on this post.Until next post cheers..!!!

Categories: TSQL Tags: , ,

How to get Twitter ID

January 5, 2012 Leave a comment

Before I start I wish you all a very happy new year 2012.It took long time after my last since I got new job and many changes happened in recent months.

I was learning WPF(Windows Presentation Foundation) and I tried to create RSS Feed reader.I tried to get twitter feeds from my twitter account and I searched in google and I found a code but it needed twitter id for that.I found it can be also replace by username.But this code is also useful.

I open http://api.twitter.com/users/show/rasikalb.json {this is for me common url http://api.twitter.com/users/show/%5Breplace username].json}url and it shows some useful json code that we can get many twitter account details.last line contains  twitter id.

image

We can access our twitter feed from http://twitter.com/statuses/user_timeline/%5BuserId or username].rss it shows as follows.Using this rss file we can read tweets.

image

Hope to post about SQL, C# useful tips in future.Until next post cheers ..!!!

Categories: Uncategorized Tags: ,