Microsoft SQL Server

NoCoug SQL Challenge Entry

I love puzzles. So when I heard about the NoCoug SQL Challenge I felt tempted to give it a go. The Northern California Oracle Users Group (NoCoug) has challenged us to find a good way to calculate the probability of getting different sums for x throws of a n-sided die using only SQL. The probabilities for the faces of a single die are stored in a table and that’s all you need to start playing with the problem. The SQL Challenge rules can be found on the NoCoug website, along with some other relevant information.

The MySQL Bible is Here!

A year ago, the outline was being written. A lot of work was crammed into the intervening months, and I am happy and proud to announce that the MySQL Administrator’s Bible has been published, and is sitting on the shelf at many major booksellers already. The official publication date is today — Monday, May 11th, 2009 — although some stores have had copies for a week, including Amazon.com.

Sydney SQL Server User Group — April 2009 Meeting

The presentation in two parts was exactly what an Oracle DBA like me would need to have a peek into the security territory of SQL Server. I was afraid it would be really “deep dive” and assumed lots of SQL Server knowledge but I was actually fine. I think it would be cool to have a full day real deep dive and looking at what Peter was talking about, I’m convinced that he could keep going further and further into details should we give him more time.

Quick Install Guide for Oracle 10g Release 2 on Mac OS X Leopard & Snow Leopard

I was very surprised that Oracle released Oracle Database for Mac OSX, especially, version 10g now that 11g has been out for almost 2 years. There is no quick install guide for OS X but only a standard Oracle® Database Installation Guide 10g Release 2 (10.2) for Apple Mac OS X (Intel). It’s fine but if you want to install Oracle on your MacBook and not for production use then you might take some shortcuts and follow a quick instructions so I gathered my notes while installing just released Oracle Database 10.2.0.4 on my MacBook, here they are.

Page 36 of 50« First Page...10...3435363738...50...Last Page »