Blog

We hope that the examples below will help you if you want to change the size of a column in SQL.

{mobile_block=responsive_ad_728_90}

Changing the size of a column with a SQL query

The syntax for changing the size of a column with SQL query is:

ALTER TABLE [table_name] ALTER COLUMN [column_name] [data_type]

For example, if a database contains a table "Students" with column "Name" that is nvarchar(10) and you want to change it to nvarchar(100) the following query will do the job:

Default behaviour in Ubuntu 12.04 fir wireless conectivity is to ask a user for a password every time the system is started displaying message "Wireless Connection Authentication Required". Also, if you have a weak wireless signal it could happen that Ubuntu has problems to connect and continue asking for password.

{mobile_block=responsive_ad_728_90}

Here is the tutorial how to force Ubuntu to remember wireless connection password and to connect automatically without asking you every time.

1) Click on the connection icon on the taskbar

Unity, a default desktop shell in newer Ubuntu releases doesn't have an option for changing default font type and size as Ubuntu had in the previous versions.

Somehow, I think that default font size in Ubuntu 12.04 Precise Pangolin is too big for modern screen resolutions. Here are instructions how to change default font size in Ubuntu:

1) Instal gnome tweak tool with the command:

Unity Launcher is an application switcher and launcher in Ubuntu Unity.

In some cases, it goes in the background, behind all windows and the Unity Shell, and it's not possible to move it to the frontend, in front all other windows (what is its default and normal behaviour). This happens no matter whether you enabled Unity Launcher auto hide option or not.

{mobile_block=responsive_ad_728_90}

We received a lot of questions how to show most popular articles and posts regarding our tutorial about implementing page view counter in SilverStripe.

Here is the solution that we also implemented on our blog system.

Let's say that we have blog article page represented with class BlogPostPage and implemented logic for page hit/view counter.

{mobile_block=responsive_ad_728_90}

How to display most popular pages

1) Create new method in the page class