Change database collation

--script to change database collation - James Agnini
--
--Replace with the database name
--Replace with the collation, eg SQL_Latin1_General_CP1_CI_AS
--
--After running this script, run the script to rebuild all indexes
ALTER DATABASE COLLATE

PlatformNotSupportedException Pocket PC

PlatformNotSupportedException when connecting from Pocket PC to a SQL Server Database.
>> If i try to connect to SQL Server with default collation
>> (i.e. SQL_Latin1_General_CP1_Cl_AS) then SqlClient is working fine and everything is fine.
>> Arif

Control your Pocket PC from your desktop

Good for developers.

Create Time table through Dimension Wizard

If you don't have any time table (table that contains dates as data) for your analysis project, just follow these steps (screens took from New Dimension wizard) and you will have a physical table in your database having data as dates.

Step 1
 

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

End.

DSL Providers in Kuwait

Here is the list of DSL providers in Kuwait.

1. 
2. 
3. 
4. 

Microsoft ActiveSync for Windows Vista

If you are trying to install classis Microsoft ActiveSync (4.x) on windows vista, you will get this error,

“ActiveSync cannot be installed on Windows Vista”

Because now Microsoft ActiveSync has been changed into a new and more powerful Synchronizing tool for Windows Vista. Windows Mobile Device Center 6.1.

Hard reset i-mate K-jam

To perform a hard reset
1. Press and hold the Comm Manager button and Voice Command button on the device.

2. Keep the two buttons pressed, and at the same time, use the
stylus to lightly press and hold the RESET button.