Blending life, nature and technology.
microsoft
SQL Server 2008 R2 Express
Jul 29th
Microsoft SQL Server 2008 R2 now has a maximum database size limit of 10Gb as opposed to the former limit of 4Gb. Small organizations and Microsoft Access migration will find this useful.
Heres a link for downloading SQL 2008 R2 Express
Heres an easy installation guide link.
Fedora 13 on Toshiba A505-S6986
May 28th
Installed this operating system – click here for fedora 13 - on a 2nd partition on my laptop. I installed the full x64 DVD iso version.
Needed to get the wireless card working, this is what l did.
My first partition already has Windows 7 installed. Both operating systems co-exist perfectly. Make sure you install Windows 7 first. I usually reserve about 45Gb from any laptop harddrive for my linux installations, this gives about 1.5Gb for the swap partiton and the rest dedicated to linux.
The card is a Realtek RT8191SE / 8102E – got this from Windows 7 command prompt by simply typing ipconfig/all
Download and extract the linux drivers from Realtek taiwan website here
Commands:
Change into the extracted files subdirectory then -
82 su -
83 ls
84 cd /home/steve/Downloads
85 ls -al
86 cp rtl8192se_linux_2.6.0015.0127.2010 /usr/src/rtl8192se_linux_2.6.0015.0127.2010 -r
87 cd /usr/src/
88 ls -al
89 cd rtl8192se_linux_2.6.0015.0127.2010
90 ls
91 cp -rf firmware/RTL8192SE /lib/firmware
92 make
93 ls
94 cp HAL/rtl8192/r8192se_pci.ko /lib/modules/`uname -r`/kernel/drivers/net/
95 depmod -a
96 reboot
Samsung Camera Codec…
Apr 1st
If you own a Samsung pocket camera, such as the Samsung TL-100 which records HD video [720 resolution], you probably have problems playing the AVI video files on your window PC media player. You might want to try using DivX or simply downloading and installing Xvid Codec – GNU from xvid.org. See also this link.
Heres the link to Xvid.
OpenOffice…
Mar 25th
I’ve been looking for a “free” alternative to Microsoft Office 2007 for general work on my laptop. I decided to try out OpenOffice which l know is installed on my Ubuntu linux partition. Theres a windows version which installs pretty quickly and with no problems on Windows 7 – l use Windows 7 64bit Home Premium on my laptop. You can download openoffice from here, and join in the currently over 100 million downloads so far tally.
Much to my surprise, l found out that l could open Word 2007 documents, as well as create PDF files from OpenOffice with no problem. Even Word 2007 has an option for saving your documents in the open document format. Now l can create word 2007 documents at my office, save these and reopen them on my laptop without worrying about data lose during conversion or between these 2 different programs. I’m probably going to be installing OpenOffice on any relatives computer l set up!
Network…
Mar 6th
Finally decided to revisit my home network – LAN and Wireless, especially with respect to wifi security.
My setup essentially is this: a private Gigabit Local Area Network [LAN] using 192.168.0.x ip address range served by a dhcp server running off Smoothwall Express – an open source based excellent firewall program. I downloaded the iso from here, and installed it on a hardly used old but trusty Dell Poweredge 2300 server. My main server – running Windows 2008 has a static ip address and runs on a Dell Poweredge SC430. The 10/100/1000 gigabit switches – mainly cisco/netgear – enable me move large 3d rendered graphics files and family video files been edited across my server to/fro my prime Quad-core windows 7 64bit 8gb workstation.
For wireless – l gave away my old linksys a/b router – this router supports only WEP which is easily hackable. Retained my Dlink DIR-625 wireless router – set to 172.168.0.x ip address range, with the ethernet input from the smootwall green output. Smoothwall setup was Green+Red – Green is for the internal LAN while red represents the external network/internet interface from usually a home cable modem. I use WPA2-PSK for security at 802.11n wifi speed. The main reason l got this particular wireless router is – it offers parents the ability to lock out kid internet access at specific time. You simply reserve specific ip address for say kid x’s PC. Set a rule such as : internet off from 9pm to 5am workdays.
My 2nd wireless router is the Buffalo Airstation Turbo G WHR-G545 – 802.11g which l set at 172.168.16.x ip address range, with security set at WPA-PSK, key set to renew every 60mins. It supports TKIP as well as AOSS also. Installed at the 2nd half of the home, this gives adequate wireless coverage to any laptop that can authenticate with the right password.
Lingo:
A PSK is a 256-bit value, known to every device in the WLAN. That PSK is usually generated by combining the WLAN’s name (Service Set Identifier, SSID) (define) with a passphrase (an ASCII (define) string, 8-63 characters.)
Installing Sharepoint 2010 Beta..
Feb 19th
Microsoft Sharepoint 2010 beta software requires the following:
- Application server role, web server IIS Role
- SQL Server 2008 native client
- Microsoft “Geneva” framework runtime
- Microsoft Chart Controls for Microsoft Framework 3.5
- Microsoft Filter Pack 2.0
- SQL Server 2008 Analysis Services ADOCMD.NET
I attempted to install this on a development Windows 2008 R2 server, which already had SQL Server 2008 R2 installed. Out of the list below, l only needed to pre-install the Geneva framework runtime, MS chart control and ADOMD.net SQL 2008 Analysis services – even though l had SSAS installed as a SQL Server 2008 component.
Will post pictures later.
To install, you download the 575Mb Office2010 beta executable from Microsoft’s Sharepoint Website.
Running this, you first select – install software prerequities to deal with above. A reboot is required. The you select install sharepoint server.
Source for the Beta Product key – click here.
Since l would be using a separate SQL Server instalation – not sql server express, l did not select standalone. Then l selected complete installation, and changed my install paths to Drive D not Drive C – which l always reserve soley for OS installations only. Next, you select run the sharepoint configuration wizard. Click close. Select yes to restart necessary services. I selected Create a new server farm.
Preventing DNS hijacking by your ISP…
Jan 24th
Here is a link and interesting discuss on doing this if you use comcast. Here is a direct link to their solution webpage. Here is the link to OpenDNS. I’ve always found it annoying when you get redirected to a comcast search control+ad page, or a bing.com page when you mistype a url. This might be great for basic users, but power users would not l suspect like – you type hotmail.com in IE8 and your browser re-directs you to bing.com with hotmail.com as the first search result.! Now you need 2 clicks to simply get to hotmail.com
Transferring logins and passwords between SQL Server 2005 and SQL Server 2008
Jan 15th
This link is very useful and details how to transfer the logins and the passwords between instances of Microsoft SQL Server 2005, and Microsoft SQL Server 2008, on different servers. – Microsoft Knowledge Base: #246133
Microsoft SQL Server, Error: 15401
Jan 15th
Got this error a lot when trying to add NT user accounts on a SQL Server 2008 installation that was connected to a Windows 2008R2 server running Active Directory 2008 at Windows 2000 functional level. Same error message appeared when troubleshooting this from a SQL Server 2005 instance in the same server environment.
You’ll keep getting “Windows NT User or group ‘MyDomain\MyUser’ not found. Check the name again. Microsoft SQL Server, Error: 15401″
Azure sample database setup….
Dec 29th
Notes on setting up the sample database – adventureworks [click here] for Microsoft’s cloud computing sql server called Azure:
- you need an account – get one from sql.azure.com - it takes some time for your access information to arrive by email.
- download the sample database using link above
- extract/unzip to a known location
- make sure you add your home/work/workstation actual external facing ip address to the firewall settings
- wait for 5-10 mins for your ip address to be accepted by the azure online firewall system
- run the script commands below
See commands/reference pictures below:
Server Name: serverx serverx.database.windows.net
Administrator Username: userx
Server Location: South Central US
db name: ankh
cd dw
buildawdwaz.cmd tcp:serverx.database.windows.net userx@serverx passwordx
cd lt
buildawltaz.cmd tcp:serverx.database.windows.net userx@serverx passwordx









