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

Sunday, January 3, 2010

Snake Wrangling for Kids

Snake Wrangling for Kids @ Jason R Briggs: "“Snake Wrangling for Kids” is a printable electronic book, for children 8 years and older, who would like to learn computer programming. It covers the very basics of programming, and uses the Python 3 programming language to teach the concepts.

There are 3 different versions of the book (one for Mac, one for Linux and one for Windows), and the printable 1.4MB PDFs can be downloaded from the Google Code project for free (zipped size is about 1MB):

http://code.google.com/p/swfk/downloads/list"

Online whiteboard: alternative to Google Wave


Scribblar is great for
* Online training and tutoring
* Revising artwork and images
* Creative brainstorming
* Sales and product demos
* Interviews and tests

Ebook: Invent your own computer games with python


"Invent Your Own Computer Games with Python" is a free e-Book that teaches you how to program in the Python programming language. Each chapter gives you the complete source code for a new game, and then teaches the programming concepts from the example.

"Invent with Python" was written to be understandable by kids as young as 10 to 12 years old, although it is great for anyone of any age who has never programmed before.

read the book here