to take a database offline you need to create a new query and replace “YOUR_DATABASE” with the database you want to take offline ..
use [master]
go
alter database [YOUR_DATABASE] set offline with rollback immediate
to take it back online …
use [master]
go
alter database [YOUR_DATABASE] set online
when trying to install the update using automatic update the installation failed on my system with no proper error message .. after some extraction and manual installation it shows that the .net framework 4 was missing …
thanks microsoft for hiding this information and causing half an hour of extra work …
to format a usb thumb drive you need a software called “gparted”.
installing gparted
to install it use the following command:
sudo aptitude install gparted
or you may also use the “Software Manager”,

search for “gparted” and install it.

run gparted
after the installation run it either by starting it with the command
gparted &
using the terminal or you may also find it in the mint menu listed in the group “Administration”

or just type “gparted” into the search box.
formatting
select the device you want to format from the dropdown list in the top right corner

when you made sure you have selected the correct device right-click the partition and select “Unmount”

then right-click the partition again and select the format you want the thumb drive to have from the sub-menu “Format to”

apply the changes by clicking on the ‘return’-button “Apply All Operations”

you have to confirm the operations to take effect

once the thumb drive is formatted you may close all windows and mount it by clicking on it in a nautilus window.
to get the sound working start up windows 7 and download the realtek AC’97 sound driver to your desktop. therefore click on the following link, accept and click ‘next’ and download the very first driver “Vista/Win7 (32/64 bits) Driver only (ZIP file)” from any mirror …
http://www.realtek.com.tw/downloads/downloadsCheck.aspx?Langid=1&PNid=14&PFid=23&Level=4&Conn=3&DownTypeID=3&GetDown=false
and extract it by right-clicking and selection “Extract All…”

select “Extract” on the next screen and wait for the file to be extracted.

when it is done click on the “Start”-Button and right-click “Computer” and select “Manage”.

the computer management console opens. select “Device Manger” in the left tree.

on the right side you should now see a device with a warning sign named “Multimedia Audio Controller”

double-click on that and select “Update Driver…” in its properties.

choose “Browse my computer for driver software”

and click the “Browse…”-button in the new window

select the lately extracted folder and click on “OK”

make sure the option “Include subfolders” is checked and confirm the step by clicking on the “Next”-button.

confirm the windows security popup by clicking on “Install this driver software anyway”

and wait for the installation to finish.

you now have sound in your vm.
just added the following new link and also updated the bundle .. thereby i noticed that the two new blogs added yesterday where not made public .. i also fixed that …
http://www.ksaelen.be/wordpress/
the blogroll can also be followed via it’s own soup:
http://dynamics-ax.soup.io
after trying to get lessc working following the post http://ken.edmonds-commerce.co.uk/css/four-commands-away-from-installing-less-css-on-ubuntu/ with no luck i finally managed it as follows (and as i just notices these are also only four command) …
sudo aptitude install git nodejs
sudo git clone https://github.com/cloudhead/less.js.git /opt/lessc
open your .bashrc file using the command
gedit ~/.bashrc
and add the following new line to make lessc work
alias lessc='nodejs /opt/lessc/bin/lessc'
as the alias takes no effect in the opened terminal open a new terminal and it will work
when trying to install windows 7 in virtualbox i got the following error message …
the cause of this error was a faulty windows 7 image file .. after re-copying it and validating the md5 the error disappeared and installation was successful …
