If you can't remember what every single symbol and operator does in SQL, don't worry -- most of us can't either. That's what cheat sheets are for and Periscope Data has just the thing for the average database developer.
Tagged With databases
While much focus and discussion of the so-called "Big Data revolution" has been on the data itself and the exciting new applications it is enabling -- from Google's self-driving cars through to CSIRO and University of Tasmania's better information systems for oyster farmers -- less focus has been on the underpinning technologies and the talent driving these technologies. At the heart of the Big Data movement is a range of next generation database technologies that enable data to be amassed and analysed on a scale and speed hitherto unseen.
In large enterprises where ITIL is an acronym that doesn't need explaining, you'll often find IT pros arguing the merits of a configuration management database (CMDB) to track and manage technology assets. Forrester analyst Glenn O'Donnell argues that while tracking configurations is vital, the CMDB approach is far too limited for modern IT.
When Microsoft and Oracle announced their strategic cloud partnership back in June, one of the promised features was pre-built virtual images for Oracle's namesake database, Java Platform SE and WebLogic Server. Those have now been released in preview, and are free to use initially.
Microsoft and Oracle's new partnership means that you can run Oracle's namesake database software on Hyper-V and Azure, and Java apps will eventually be supported on Azure. It's good news for enterprises running a mixed Oracle/Windows environment and looking to expand into the cloud, and also suggests that Oracle is also going to give up on its own attempts in the virtualisation market.
Running database servers in the cloud presents several challenges, one of which is ensuring performance . A paper comparing the performance of SQL Server in its traditional and cloud versions (the latter known as SQL Database) highlights the need to adjust apps to suit the different approaches.
Movie editor Walter Murch (Cold Mountain, Jarhead, The Unbearable Lightness Of Being) discusses how he makes use of technology to organise the editing process in a new interview on the Filemaker site (requires Quicktime). Editing on Avid is pretty much par for the course these days, but Murch makes the point that keeping track of what shots you have to work with was a useful task for computers even in the non-digital-editing era. Despite the frequent plugs for Filemaker, it's a good general reminder that creativity doesn't happen in a productivity vacuum: being organised (and using the appropriate tools) is key to getting the best results.