Posts Categorized: Pythian
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.
This Log Buffer Edition is sparkling with fresh and budding blogs. This Log Buffer #280 is is encompassing Oracle, SQL Server and MySQL blogs. Please give your feedback in the comments. Enjoy
In a typical organization, all work together to bring out a common good for the outside world. It’s interesting to see how all of these entities blog about technology, and there is more and more interest shown by managerial technologists about databases. This Log Buffer Edition appeases their appetites. Enjoy!
HOPE Volleyball Summerfest (Helping Other People Everywhere, Ottawa-Carleton Inc.) celebrated 30 years of fun for a cause this year. The charity has donated more than $3.5 million to over 110 charities since it began. Here are a few highlights from Team Pythian at HOPE on July 14th. It was a great day!
This past week I attended OSCon, the annual conference for open source’s true believers. And there was a religious fervor in the air, particularly from the point of view of someone more accustomed to Oracle conferences. The companies generating buzz were the small companies built around development of their own open source products. There are a surprising number of them out there, especially relating to multiple forks of a popular product like MySQL or Hadoop.