Today I will change blog status to give the some other information, for those who already know, it will not be a big surprise.
These site have free software and every day offer for free licensed software you’d have to buy otherwise!
Link:
http://www.giveawayoftheday.com/
P.S.: They offer software under specific terms and conditions, which limit the software usage to non-commercial only, and may also limit software updates and technical support.
SQL Bulk Insert
Very nice post explaining how to do a bulk insert from a text File specifying a field delimited with comma or other. It cames with examples including SP's .
Follow the link:
http://www.sqlteam.com/article/using-bulk-insert-to-load-a-text-file
Follow the link:
http://www.sqlteam.com/article/using-bulk-insert-to-load-a-text-file
Web Analytics
Although i have an IT profile i like to see what´s going on these area I'm using mainly Google Analytics. I have noticed in Web Analytics that exists many concepts, i will detach some concepts like Converstion Rate( percentage of unique visitors who take a desired action), Bounce rate (% users that enter and get out in less 10 Seconds) if the percentage is high > 80%, your site needs like mine to be rebuild and have the content that attract visitors.
There are other tools to get the job done like webtrends, ClickTracks
To take the juice out of ClickStream"
There Some Questions to make to our software
- Why the visitor came to our web site ?
- Where they are located ? (Region,City,Country)
- what are they searching ? ( Products and Services, or both)
- What time they spend in average ?
- What is my convertion rate for my campaign X,Y,Z
These and other questions must have a response .
Internally we have to adpot our sites to the target market, we must have accurate content.
In the search engine we have to include the Keywords that are meaningfully to our brand and site.
I'm not encouraging no one to go to direct submission software tools for the submission of the web site because that can trap us and not giving the expected results. For these propose we must submit directly to Google, Yahoo, Msn or Live Search because these are that major search engines around, but we can not forget the local search Engines.
There are other tools to get the job done like webtrends, ClickTracks
To take the juice out of ClickStream"
There Some Questions to make to our software
- Why the visitor came to our web site ?
- Where they are located ? (Region,City,Country)
- what are they searching ? ( Products and Services, or both)
- What time they spend in average ?
- What is my convertion rate for my campaign X,Y,Z
These and other questions must have a response .
Internally we have to adpot our sites to the target market, we must have accurate content.
In the search engine we have to include the Keywords that are meaningfully to our brand and site.
I'm not encouraging no one to go to direct submission software tools for the submission of the web site because that can trap us and not giving the expected results. For these propose we must submit directly to Google, Yahoo, Msn or Live Search because these are that major search engines around, but we can not forget the local search Engines.
Virtual Machines
Virtual machines let's install on new machines programs, Os's like a real PC. For company's it allows to get green and get the correct use of the hardware and LAN infrastructure , if you get hardware problems you could go to other PC and with simple file copy restore your Virtual Machine.
Advantages in using Virtual machines:
There are several software to do virtualization i have worked with VMWARE Server which is free, but there are other like Xensource Express which is free as well. there are other software options which are not free, but with another level of consolidation of servers.
PS: You have to make a registration process to get the licenses keys
Advantages in using Virtual machines:
- Test environment for your program's
- It takes little time to setup the second VM, just file copy.
- Can use several VM's
- Put the Hardware functioning to according to it's potential
- Can use these machines to training events
- Less investment more ROI in IT
- Software evaluation without taking risks
- Can use Open Source in more suitable way.
- Consolidation storage and LAN
There are several software to do virtualization i have worked with VMWARE Server which is free, but there are other like Xensource Express which is free as well. there are other software options which are not free, but with another level of consolidation of servers.
- Vmware Server
- Xensource Express
PS: You have to make a registration process to get the licenses keys
