Nik's Technology Blog

Travels through programming, networks, and computers

SQL Server Login Change

If you happen to install Microsoft SQL Server under a Windows account you later want to change to another Windows account you will have to login to Windows using the account it was installed under (Go to Control Panel>Administrative Tools>Services to find this out). You should then stop all SQL server services (MSSQLServer, SQLServerAgent, Microsoft Search, Full-Text Search, Distributed Transaction Coordinator etc). In Control Panel, click on Administrative Tools and then Services. For every SQL service you have installed you will need to view and edit the logon properties, changing the account for each one. A reboot should then complete the process.

SQL DTS Designer -

Currently working on trying to automate the bulk input of web log files into a MS SQL database with DTS Designer and Active-X script.

Managed to concatenate fields and perform VB commands on the data prior to input. However running through a directory of files to input is somewhat more difficult.

Ideal DTS import solution

Adding Contraints to SQL tables

Constraints are important within a database structure as they insure database integrity.

This useful SQL command shows how to add constraints to existing SQL tables.

In this command a constraint between 2 tables (tblCountries and tblCompanies) is being created called FK_tblCompanies_tblCountries.

alter table dbo.tblCompanies add constraint FK_tblCompanies_tblCountries foreign key (ISOCountryCode) references dbo.tblCountries(ISOCountryCode)

SLANGUAGE - The New Text Messaging?

According to T-mobile the new form of mobile phone communication will be a combination of pictures, sounds and slang phrases. These will produce a new abbreviated language which will be unique between groups of friends.

This news comes as the UK networks finally become MMS cross compatible. Enabling users of different networks to send picture messages to one another is seen as key to the take up of MMS.

HTML Tabindex

Tabindex is very useful when designing large forms as it dictates what element the tab key jumps to next. Only works in IE. Tabindex of -1 is ignored. Tabindex's of 0 come after the highest tabindex.

NOKIA WAP form GET and POST size restriction

The amount of data that you can send to the server using WML forms and Nokia WAP enabled phones such as Nokia 3330 and Nokia 7110 is limited. The URL and querystring lengths are also affected since they affect the size of the HTTP header. To fix this problem you have to change the CONNECTION TYPE property to CONTINOUS in the settings menu of the mobile.

Maximum size for a WML deck

The maximum size of a WML page varies between different handsets. When coding WML pages Microsoft recommend that they are less than 1200 characters to be compatible with the majority of cellphones.