How to change the owner of a SQL database when the owner has been removed.

On a  server some of the databases are inaccessible to the SA user.
This requires running this command to see who the owner is

sp_helpdb DBNAME

Once you know how to change the owner just run this to change the owner to the SA and you can then perform the admin you require


USE dbname
EXEC sp_changedbowner 'SA'

When you a problem with a remove or even a local pc and you are worried that it is not going to restart properly you can force a restart with this command.

shutdown -t 0 -r -f

How to identify SQL Collation used

SELECT DATABASEPROPERTYEX('DBName', 'Collation') SQLCollation;




Just type in the DBName of the database you want to check

Virtualisation: Technologies

Cloudstack takes virtualisation to the next level.

• Its open source
• It supports Xen Server, Xen Server Cloud, VMWare, KVM and OracleV

http://cloudstack.com/

Good tools to keep your pc clean

Good tools to keep your pc clean

CCleaner 

Defraggler 

http://www.piriform.com/

Important Security Bulletins

It is essential to follow and act on the latest security trends and apply the recommended patches to systems.
In the ideal world it is best to prevent than react. If you have the systems in place you will be able to put the emphasis into prevention.
Here are some sites that should be followed.
http://secunia.com/advisories/
http://technet.microsoft.com/en-us/security/advisory
http://technet.microsoft.com/en-us/sec
http://www.livehacking.com

How to find mac address - Apple Mac

Click the Apple menu at the top left of the screen

Click 'About This Mac'

Click the 'More Info...' button

Click the 'Network' option;

Look under the 'Ethernet' section, you will see the system's MAC address list