I have spent the last week reading 'SQL Tuning By Dan Tow' and of course hosting Christmas Eve for my family. It has been a little hard to find the Christmas Spirit in between the chapters of this book. I have never been a real Champ in mathematical procedures, so you can imagine that this has been quite a challenge for me.
I can do the diagram, that Dan Tow teaches, but when it comes to getting the numbers to place into this diagram, I fail to see the logic and therefore comes to a dead end.
Today I am sitting in the Miracle Office in Ballerup. There´s not much to do and we are only 6 persons in the office.
I want to wish everyone, who has been following this blog, a Happy New Year.
Kind Regards
Jan Wigh
torsdag den 27. december 2007
tirsdag den 11. december 2007
Workshop
Today I had a small workshop session hosted by Peter Gram, an extremely skilled Database Specialist at Miracle. We went through the Oracle Start Up Processes, the Backup procedures, the functions of RMAN, Archive Log Mode and we performed backup and restore/recover a couple of times. Also, we managed to squeeze in a little bit about security.
It was extremely nice to be able to do these exercises together with Peter, who was very good at explaining the scenarios and the course of action.
Also, Peter was very good at giving me little challenges during the Workshop.
This also gives me an idea of where I need to improve etc. My overall evaluation of the workshop is, that I have a fair understanding of how the database is set up and a lot of what Peter told/showed me, I recognized from Toms book and from the Oracle Concepts Guide.
However, I still have a long way to go, especially when it comes to the SQL commands and the whole process of actually doing the exercises, when you suddenly don´t have a book where the example is described for you into every detail.
I came up with the idea of this Workshop, because I thought that there was a lack of Practical exercises in this education programme. I really feel that a couple more of these workshops can help me improve a whole lot.
It was extremely nice to be able to do these exercises together with Peter, who was very good at explaining the scenarios and the course of action.
Also, Peter was very good at giving me little challenges during the Workshop.
This also gives me an idea of where I need to improve etc. My overall evaluation of the workshop is, that I have a fair understanding of how the database is set up and a lot of what Peter told/showed me, I recognized from Toms book and from the Oracle Concepts Guide.
However, I still have a long way to go, especially when it comes to the SQL commands and the whole process of actually doing the exercises, when you suddenly don´t have a book where the example is described for you into every detail.
I came up with the idea of this Workshop, because I thought that there was a lack of Practical exercises in this education programme. I really feel that a couple more of these workshops can help me improve a whole lot.
mandag den 3. december 2007
An eye opening weekend...
This weekend has been quite an Eye-Opener. This, due to the following chain of events.
1.) Miracle had their annual Christmas Party. This gave me the opportunity to finally meet the last handful of people that I hadn´t already met (among these, 'The Chosen One'- See point 2.). It also gave me the opportunity to taste the authentic Miracle Beer from our very own Brewery. Cheers!!
2.) I found out that 'The Matrix' wasn´t actually too far off. There really is a 'Chosen One' or a 'God', if you will, in the world of PL/SQL. But his name isn´t Neo, but Egan. Morten Egan. And he actually works for Miracle, right here in little Denmark. He can do everything in PL/SQL.
I was actually taken back by the fact, that he could even manage to speak to me in plain Danish.
He is going to be VERY tired of my e-mails and my phone calls during the next two months.
Mark my words, Mr. Anderson, Ehhh I mean Mr. Egan.
3.) I finished the first two books: 'Expert Oracle Database Architecture by Tom Kyte' and 'Mastering Oracle SQL and SQL*Plus by Lex de Haan'.
4.) I got to meet James Morle, one of the founders of the Oak Table Network.
A very nice guy whom I am going to get to know him even better, when I am to read one of his books later on in the programme.
5.) I spoke to Tom Kyte on the phone.
That gave me the opportunity to tell him about what I got out of reading his book. And also give him credit, for bringing down to earth, the most technical stuff in the book, so even an ignorant like myself, can actually learn a little something about Oracle.
Speaking of Tom. Mogens would like me to send Tom a question, which can challenge him a little bit. This is pretty hard for me, since all I know about Oracle, is what I have been taught out of this book.
Therefore, I need the help of you guys out there. If you can come up with a question for Tom, please leave a comment on the blog. It could be fun if we could challenge him just a little :-)
Well, from tomorrow I will start reading two Whitepapers; 'Building Robust Applications in a Database-Centric Way by Toon Koppelaars' and 'YAPP by Anjo Kolk'.
After reading these, I will start reading 'Oracle 9i Concepts Guide'. And just to make sure, that I won´t get bored, I will also read a chapter a day from the book; 'Oracle Insights - Tales from The Oak Table'.
The Oak Table book is written by eleven 'Gurus', I think it´s safe to say.
To qoute the cover from the book; 'Eleven leading authorities on Oracle´s database engine share their unique insights on how best to exploit the software'.
The eleven 'Gurus' are Dave Ensor, Tim Gorman, Kyle Hailey, Anko Kolk, Jonathan Lewis, Connor McDonald, Cary Millsap, James Morle,
David Ruthven, Gaja Krishna Vaidyanatha
and of course Mogens Nørgaard.
Quite a list...
Jan
1.) Miracle had their annual Christmas Party. This gave me the opportunity to finally meet the last handful of people that I hadn´t already met (among these, 'The Chosen One'- See point 2.). It also gave me the opportunity to taste the authentic Miracle Beer from our very own Brewery. Cheers!!
2.) I found out that 'The Matrix' wasn´t actually too far off. There really is a 'Chosen One' or a 'God', if you will, in the world of PL/SQL. But his name isn´t Neo, but Egan. Morten Egan. And he actually works for Miracle, right here in little Denmark. He can do everything in PL/SQL.
I was actually taken back by the fact, that he could even manage to speak to me in plain Danish.
He is going to be VERY tired of my e-mails and my phone calls during the next two months.
Mark my words, Mr. Anderson, Ehhh I mean Mr. Egan.
3.) I finished the first two books: 'Expert Oracle Database Architecture by Tom Kyte' and 'Mastering Oracle SQL and SQL*Plus by Lex de Haan'.
4.) I got to meet James Morle, one of the founders of the Oak Table Network.
A very nice guy whom I am going to get to know him even better, when I am to read one of his books later on in the programme.
5.) I spoke to Tom Kyte on the phone.
That gave me the opportunity to tell him about what I got out of reading his book. And also give him credit, for bringing down to earth, the most technical stuff in the book, so even an ignorant like myself, can actually learn a little something about Oracle.
Speaking of Tom. Mogens would like me to send Tom a question, which can challenge him a little bit. This is pretty hard for me, since all I know about Oracle, is what I have been taught out of this book.
Therefore, I need the help of you guys out there. If you can come up with a question for Tom, please leave a comment on the blog. It could be fun if we could challenge him just a little :-)
Well, from tomorrow I will start reading two Whitepapers; 'Building Robust Applications in a Database-Centric Way by Toon Koppelaars' and 'YAPP by Anjo Kolk'.
After reading these, I will start reading 'Oracle 9i Concepts Guide'. And just to make sure, that I won´t get bored, I will also read a chapter a day from the book; 'Oracle Insights - Tales from The Oak Table'.
The Oak Table book is written by eleven 'Gurus', I think it´s safe to say.
To qoute the cover from the book; 'Eleven leading authorities on Oracle´s database engine share their unique insights on how best to exploit the software'.
The eleven 'Gurus' are Dave Ensor, Tim Gorman, Kyle Hailey, Anko Kolk, Jonathan Lewis, Connor McDonald, Cary Millsap, James Morle,
David Ruthven, Gaja Krishna Vaidyanatha
and of course Mogens Nørgaard.
Quite a list...
Jan
Abonner på:
Opslag (Atom)