Friday, January 29, 2010

How to Add a Windows User (Network Service) to SQL Server

In relation to the post
Alen's Notes: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'
here is how to add Windows users to SQL Server:

* Open the SQL Management Studio and go to Security -> Logins.
* Right-click Logins folder and select New Login...

* On the following screen click Search

* On the search window click Advanced

* In Select User or Group window, that opens, click Find Now.
* From the list of users and groups in the results pane, scroll to find and select the Network Service user. Click OK.

This will allow the selected account access to the SQL Server. From there you can add appropriate authorization and access rights to the account for different databases and/or other database objects, like views, stored procedures, and so on.

Wednesday, January 27, 2010

SQL Linked Servers

One great thing when using SQL Server, or an application which consumes a database on SQL Server, is that you can get the data from another server and/or database. One such example would be displaying reference data from another database.

The following link shows the naming conventions in MS SQL Server:
The most important thing here is 4-part naming convention where you simply add servername.database.schema.table into a query, referencing remote data.

Before that is possible, however, it is required to add a linked server and provide proper authentication and authorization to the calling server.

Monday, January 25, 2010

Migrating from PHP to .Net

Adding to the previous post about Phalanger, here are some resources about the migration from PHP to .Net platform.

However, Phalanger seems to be the best option for merging PHP into the .Net environment.

Sunday, January 24, 2010

Phalanger - The PHP Language Compiler for the .NET Framework

Phalanger - The PHP Language Compiler for the .NET Framework

For all those who need to migrate PHP applications to .Net platform, here is one possible option.
Phalanger is a PHP language compiler for Microsoft .Net platform. Read introduction here. It seems to be possible to mix PHP and other .Net languages on a web site, thus enabling step-by-step migration of existing PHP-based applications.
Phalanger project's homepage is here.
Also, read the following paper that describes, in more detail, how to use Phalanger, what the benefits are, etc.

Wednesday, January 20, 2010

My Favorite Yahoo! Widgets

Below is the list of my favorite Yahoo! widgets:
- HDD Activity Widget
- Multi Clock
- Network Interface Statistics Monitor
- World Clock Pro
- Notes

Sunday, January 17, 2010

Using wkTask Manager

If you use wkTask Manager to switch between applications, start applications, or close them and you happen to have Windows Mobile 6.5 with Touch Flo interface, your regular Windows start menu may disappear in certain situations and the only way to get it back is to do a reset.

The solution is to add “\Windows\shell32.exe” to the list of exceptions. No title or class name are needed.

Illustrated instructions are here:

You can also disable regular OK/X close button:

Saturday, January 16, 2010

Firefox for Windows Mobile

Fennec is the name of the small mountain fox. It has now been selected for the Mozilla’s browser for mobile devices. At the link above you can download the Windows Mobile version of the new Gecko-based browser. Current version is 1.0a3.

Friday, January 15, 2010

First Release of MobileTDL

I just uploaded the first release of MobileTDL – my mobile version of ToDoList. The project is located at

and the initial working version can be downloaded from the Featured Downloads link on the right-hand side. This version has been fixed from a project I took over so all the options now work.

The new versions will include new and changed features. One of my main things is export to Outlook and making operation a bit more finger-friendly.

Thursday, January 14, 2010

Save MySQL?

Interesting development in the Open Source database (RDBMS) arena. Since Sun has acquired MySQL AB earlier and now Oracle has purchased Sun it appears that the most popular Open Source database will end up being owned by the world-largest (closed source) database provider. What follows is only a matter of imagination and will be interesting to follow through.

Some people are reasonably concerned about the future of MySQL and have created a petition to save MySQL. Should you want to read more and/or sign the petition, go here.

Tuesday, January 05, 2010

Slide2Unlock2 TPro Skin

TPro skin for S2U2 will change the appearance of S2U2 screen when your PocketPC device is locked. The appearance will be more in line with HTC Sense style and will fit perfectly with Touch Flo 3D interface. It will also change the appearance of the Settings screen, making it (much) more finger friendly and readable.

An amazing thing is that clicking the Tasks icon will display the list of tasks ordered by due date. This makes it a perfect addon I was looking for. Now there’s almost no need to go past the lock screen in my normal use of the device.

Comm Manager Tab for TouchFlo 3D

Here is an XDA Developers forum thread about Comm Manager, an addon for Touch Flo 3D that allows access to the communications manager as a tab. This makes it easier to access phone/bluetooth/wifi on/off buttons as no digging one level lower is needed through the regular communications manager tab.

Add Currency Pair to TouchFlo 3D Stocks Tab

Touch Flo 3D has the Stocks tab that displays the stock quotes from Yahoo Finance and that’s fair enough. Now, some of us might need to also see the currency exchange rate. The solution is simple and obvious, just maybe not that straightforward.

There is a great tip at PocketNow Tips and Tricks page that explains how to add a currency exchange pair to the Stocks tab. Simply use the currency pair instead of the stock/index quote in the following format: for EUR/AUD exchange rate I used “EURAUD=X”. The same goes for other formats, if supported by Yahoo Finance.