Dell R810 - FATAL: Error inserting acpi-cpufreq

If you encounter the following error when trying to load the acpi-cpufreq driver, there is the possibility that your Dell server BIOS setting is not configured properly.

[root@localhost cpufreq]# modprobe acpi-cpufreq
FATAL: Error inserting 
acpi_cpufreq 
(/lib/modules/2.6.32-131.17.1.el6-0.11.smp.gcc4.4.x86_64/kernel/arch/x86/kernel/cpu/cpufreq/acpi-cpufreq.ko): 
No such device

Go to your Dell BIOS setting and look for Power Management. Once you inside the Power Management window, look for the Power Management setting. Change the setting to OS Control if is different setting. Reboot and you should be able to load the acpi-cpufreq driver successfully.For more information on Dell Power Management, please go to this link and look for BIOS based P-state management. 

Nokia Phone Browser - Operation could not be completed

I first experienced this problem when i upgraded Nokia PC Suite from 7.1.26.1 to 7.1.30.8. There seems to have few solutions available indicated on this forum but you might want to try the repair method also. At least it works for me.

So how to repair? Very simple. Goto Start->All Programs->Nokia PC Suite and choose uninstall. A Nokia PC Suite windows will pop up as shown below.

Choose Repair Nokia PC Suite and that's it, hope this method can help you also. :)

Dell R810

Support 4 CPUs and 32 DIMM slots in 2U casing

2.5" HDD slots, total 6

2.5" SATA HDD (HDD from Seagate)

6 PCIe slots, 2 half heights, 4 full heights through riser card, one more PCIe slot occupy by RAID card

First riser card

Second riser card

RAID card

CPU board configuration

Memory configuration details

Overview

Upload files to Google Drive from other website

If you want to upload file, example a pdf file that resides on another website, you will have to download the file into your local PC before you can upload it to Google drive. To speed up this process, actually you can directly paste the link into open file dialog box and let the Windows OS do the work for you.

When you are in Google Drive, just select upload Files...

In the File Open dialog, just paste the url link directly into File name: box

After you click Open, the File Open box will grey out for a while (depend on your file size and connection speed as Windows is taking time to download the file). Once the File Open box disappear, you will see your file get uploaded to Google Drive.

Get Singapore Stock Market Quotes in Google Docs

*20 August 2018 update: Due to data unavailability for both Google Finance and Yahoo finance, i had created a new Google Apps Script to download and import SGX daily price list data to Google sheets. Please refer to this link for details.

* 24 Feb 2014 update: Recently, i have had some problem with getting the result from Yahoo finance and the cell always show #VALUE! with error - "The data could not be retrieved. Please check the URL". I tried to use GoogleFinance again and it seems like they finally start to support SGX stocks. So to get the price of stock like Keppel Land, just type the following in the cell

=GoogleFinance("SGX:K17")

So the syntax is quite easy, just type in the stock quote name with SGX: precede in front. The only problem is the limitation of 2 decimal points...

For more information on what data can be retrieved, please refer to this link.

=====================================================================

If you are using Google Docs to keep track of your stocks statistics, this will be something very useful to you. By having the ability to import stock market quotes directly, you can manipulate this data further, example - to calculate paper gain/loss quickly.

Google actually provide a useful tool which is GoogleFinance* for this purpose but unfortunately, Singapore stock is not supported. Luckily, there is still this tool call ImportData which we can use to import structured data from other website like Yahoo Finance.

To do this, first,  you need to know your stock symbol. You can get this easily by typing the stock name in the get quotes field. Screenshot shows the list of possible stocks after i type in Keppel Land.

After you know your stock symbol, you just need to type the following in the cell of your spreadsheet document and replace the italic word with your own options. You can go to the following link for all the special tag options.

=ImportData("http://finance.yahoo.com/d/quotes.csv?s=stock symbol&f=special tag")

For example, if you want to get last trade price for Keppel Land, i just type the following:

=ImportData("http://finance.yahoo.com/d/quotes.csv?s=k17.si&f=l1")

and that's it, you can see that Google Docs will load the last trade price in the cell as shown below:

Configure ramdisk for Openfiler

Create a new file under /etc/bootloader.d directory. In this new file, type add_options ramdisk_size=32000. Please note that the unit is in kilobytes. The example below shows the new file is called ramdisk.conf and the content of this file.

[root@abc ~]# cd /etc/bootloader.d
[root@abc bootloader.d]# ls
distro-defaults.conf  plymouth-bootloader.conf  ramdisk.conf  syslinux_bg.png
[root@abc bootloader.d]# more ramdisk.conf
add_options ramdisk_size=32000

After the file is created, type bootman to apply the configuration as shown below

[root@abc ~]#bootman

Restart your machine and you can check whether is it successful by typing cat /proc/cmdline as shown below:

[root@abc ~]# cat /proc/cmdline
mce=dont_decode cciss.cciss_allow_any=1 splash quiet ramdisk_size=32000 ro root=LABEL=/ initrd=/initrd-2.6.32-71.18.1.el6-0.20.smp.gcc4.1.x86_64.img BOOT_IMAGE=/vmlinuz-2.6.32-71.18.1.el6-0.20.smp.gcc4.1.x86_64

Create a filesystem on /dev/ram0 and mount it up and you will have a 32MB ramdisk.

PowerShell to check MSSQL database status

A very simple Powershell script to check database status.

[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null
$s = New-Object ('Microsoft.SqlServer.Management.Smo.Server') ServerName
$db = $s.Databases.item("databaseName")
"status: " + $db.status + " isaccessible: " + $db.isaccessible

Example output:
Database status is normal

status: Normal isaccessible: True

This output is created by renaming the log file.

status: RecoveryPending isaccessible: False

For more status description, please refer to this Microsoft site.