new blogger

I have found recently a useful article at HowTo Market Your blog in 2007. It gives me good idea about problems for new bloggers. Just a few to discuss:

1. Get own domain.
   For new blogger it is much easier to start with any available service such as blogger.com. It will help to be use to blog, adjust layot, templates. Then is possible to switch to a custom domain name on blog, for instruction how to do that follow Advanced Use.


2. Host your own blogging software. Looking ...
   Wordpress 2.2 is available for download. To run WordPress your need hosting with PHP and MySQL.


3. Content is a king. Writing a blog give you a way to improve a writing skills. But don't forget to read what other bloggers has created. Communicate with other bloggers.


4. Feel and Look. Find a free wordpress template and customize it to suite your needs. It will help to boost you happiness and willingness to write anything


5. Enable permalinks. An URL that points to a specific blogging entry even after the entry has passed from the front page into the blog archives. Because a permalink remains unchanged indefinitely, its use avoids link rot. Most of weblogging systems support such links, including Wordpress, Movable Type, LiveJournal, RapidWeaver, Pivot and Blogger


6. Create keyword rich headlines, create unique title tags. The TITLE tag can be found by viewing the html source of your page, and it looks <TITLE>This is a title tag</TITLE>


7. Enable trackback and ping functionality, and ensure your blog pings pinging-services.
   It is part of service provided by blogger.com


8. Publish full feeds. No idea how to do that, except this is probably a feature of blogging software. Next question coming - what is pundits?

Send output to serial port in VBScript

'
' How To use VBScript with serial communication.
' Save this as test.vbs file
' Run by double-click
'

Dim MSComm

Set MSComm = CreateObject("MSCommLib.MSComm")
MSComm.CommPort = 2
MSComm.PortOpen = True

' send text
MSComm.Output = "otput text to send"

'send binary data
MSComm.Output = GetData(4321) & GetData(0) & _

GetData(1234) & GetData(0) & GetData(2345)

Function GetData(w)
Dim LoByte,HiByte
LoByte = w And &HFF
HiByte = (w And &HFF00&) \ &H100
GetData = ChrB(HiByte) & ChrB(LoByte)

End Function

Cool domain name for sale

Catchy name for sale - www.asp.com for 89.000$.

Deal could be found on moniker.com, and 'Buy Now' price is 125.000 with 15% of service fee. This domain name is on sale since December 13, 2006. Details shows around 800 unique visitors per day.

Site name is acronym for Active Server Page technology from Microsoft. Now Microsoft move forward from ASP to ASP.NET, but still ASP has been used in number of web sites.

Is that price right?

How to add text in CEditView

1. CEdit::ReplaceSel

ReplaceSel replaces only a portion of the text in an edit control.
To access CEdit control, use GetEditCtrl() function.

GetEditCtrl().SetSel(-1, -1); // end of edit text
GetEditCtrl().ReplaceSel(buf); // append string..
GetEditCtrl().SendMessage(EM_SCROLLCARET); // ..and show caret

2. CWnd::SetWindowText

SetWindowText will replace all of the text, therefore first is required get all widows text into local variable, append text to the end and show on screen by using SetWindowText

CString str;
GetWindowText(str);
str += " appended string ";
SetWindowText(str);

Bug tracking system

Possible solutions:

1. Create one in-house system. As a advantage is flexible and required to support
2. Take service, available on Internet. Sometimes is very costly, sometimes not.
3. Use one of solutions existing for Microsoft Share Point. Problem if database groves more than 4 GB. In this case will be required to by SQL Server licence.

How To find information in SQL Server database

1. Enumerate all columns in tables with table name like BAND

SELECT CL.* FROM INFORMATION_SCHEMA.TABLES CL WHERE TABLE_NAME LIKE '%BAND%'

2. Enumerate all columns in all tables with column name like MYCOLNAME

SELECT CL.* FROM INFORMATION_SCHEMA.COLUMNS CL WHERE column_name
LIKE '%MYCOLNAME%' ORDER BY table_name

3. Enumerate all columns in all tables with column name like MYCOLNAME, show table name as well

SELECT CL.TABLE_NAME, CL.COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS CL
INNER JOIN INFORMATION_SCHEMA.TABLES TB
ON TB.TABLE_NAME = CL.TABLE_NAME
WHERE CL.COLUMN_NAME LIKE '%MYCOLNAME%'
AND TB.TABLE_TYPE = 'BASE TABLE'
ORDER BY CL.TABLE_NAME

4. Find duplicate rows in a table in SQL Server

SELECT COL1, COL2, COUNT(*)
FROM T1
GROUP BY COL1, COL2
HAVING COUNT(*) > 1

5. Enumerate processes

USE master
SELECT * FROM sysprocesses

Video pedia

There is no video encyclopedia on Internet.

Something close to idea of video encyclopedia is How To Do sites and one of the examples of such site is http://www.5min.com/

Youtube has no relation to organized video storage. The main idea is freedom, nothing else, only ultimate freedom.

Why is more difficult to organized video than other type of information?