Blogging is the way to express an idea in an informal way by a person, who has either worked with it, or planning to work with it, or has seen it at work. In databases, ideas are the foundations of everything, and these Log Buffer Edition is presenting ideas from bloggers in Log Buffer #282.
If you are looking to kick start your community contributions or looking to volunteer more than what you already do, I have an awesome suggestion for you — nominate yourself to serve as an IOUG Oracle RAC SIG Board Officers volunteer. Find out more here.
Pythian is pleased to announce our speaking schedule at this year’s Oracle Open World 2012! Here are the speaking sessions that we will be participating in, including one session that we will be co-presenting with our friends at Harvard Business Publishing.
This Australian conference represents the climax of Technology, Development, and Applications users in one go. As icing on the cake, mobile technology and telecommunications will also feature during this scintillating saga of expertise and sharing of knowledge.
I won’t try to bamboozle you: Diving into Moose’s metaclass system is not easy because playing with classes that beget classes is heady, confusing stuff. It often feels like trying to type by looking at the keyboard in a mirror. But once that dragon is tamed, it can do truly wonderful, terrible things…
The Log Buffer Edition is one-stop joint to know about the latest blog entries regarding the database technologies like Oracle, MySQL, and SQL Server. Enjoy this Log Buffer #281.
When a new cursor is given to Oracle to execute, it first needs to check if there is already such cursor in the Shared Pool, so we will not need to go to the expensive process of a hard parsing it again. To check this quickly, a hash value is generated from the text of the SQL .
Continuing on from my last post, I felt like cleaning up some more data and using more SQL Server 2012 features. I happened on DATEFROMPARTS on MSDN and felt like playing with it.
A new feature in SQL 2012 that I am very excited about is TRY_CONVERT which makes data conversion much easier. When you pair TRY_CONVERT with some Case statements, you can easily pipe the inconvertible data to other columns, which can then be reviewed and (hopefully) fixed prior to cutting over your data. I’ve mocked up a quick demo so you can see how powerful this new feature is.