Friday, April 30, 2010

When was your server last restarted?

Since Tempdb gets recreated every time the server is restarted, all you need to know is when was tempdb created -
SELECT create_date
FROM  sysdatabases
WHERE database_id = 2;
Another way -
SELECT sqlserver_start_time
FROM sys.dm_os_sys_info

Thursday, April 22, 2010

MariaDB-better branch of MYSQL Database server


MariaDB is a backward compatible, drop-in replacement branch of the MySQL® Database Server. It includes all major open source storage engines, including the Maria storage engine.
You can find the MariaDB code on Launchpad, and download binaries here.
MariaDB is community developed in collaboration with Monty Program. Our ambition is to make MariaDB the best open and free branch of MySQL Database Server for the end user, developer and partner communities.

http://www.youtube.com/watch?v=AL1l9Puh0sk

Gotta watch this