Wednesday, December 11, 2013

See you all in Seattle

In June 2014 I hope to see a whole lot of you at ODTUG's awesome conference Kscope14...

You will not regret going to Kscope14. There is a ton of great content and loads of awesome brainpower to pick ;-) And if you can find the time for it in between all the great stuff, you might consider attending one of my two presentations:
  • Analytic Functions - Advanced Cases
Analytic functions can often help you using data across rows in ways that allow you to solve tasks that otherwise might have called for slowly using the data one row at a time procedurally. The presentation explains a set of advanced usecases of analytic functions showing use of RANK, DENSE_RANK, ROW_NUMBER, RATIO_TO_REPORT, LAG, REGR_SLOPE, ROWS BETWEEN, and more to efficiently solve actual real life tasks, such as top selling items, picking by FIFO, picking route, forecast sales, and more.
  • External Data via HTTP, FTP, Webservices
There are many ways you can access external data from within the Oracle database. The presentation will show ways of using HttpUriType, UTL_HTTP, JPUB, UTL_FTP, UTL_DBWS, APEX_WEB_SERVICE to retrieve external data. Calling SOAP or REST webservices or proprietary formats over http or https (SSL) or FTP will be discussed and shown. There will be demos of some of the method combinations - how many will depend on time available ;-)

Monday, December 2, 2013

SQL Book Club - Any recommendations?

I got a note from Steven Feuerstein the other day about a group of developers in Stockholm starting an SQL Book Club. What a great idea :-) Anyway, they had asked Steven if he had any recommendations for good books on Advanced SQL. And Steven asked me the same question...

And now I'm asking the blog readers: Do you have any favorite books on writing Advanced SQL you can recommend to this new SQL Book Club?