10g (1) 11c (1) 11g (5) 12c (4) 3.0 (1) ApEx (4) Cloud (11) database (10) DBA (1) EBR (1) EC2 (2) education (4) EOUC (1) ExaData (1) F2F (1) Forms (7) java (1) language (2) memorabilia (2) Metalink vs MOS (4) multi-cultural (4) on-line communities (1) oracle (7) performance (5) projects (1) reciproke (1) Reports (2) RUP (1) sales (2) services (5) silence (1) SOA (3) SQL Server (2) standards (6) Sun (1) support (6) W8 (1) WebLogic Server (5)

Monday, March 06, 2017

Are you trying to use GROUP BY in x++

Yes, I know, it is far from Oracle. But anyway...the syntax in the SQL world is
SELECT orderheader, sum(ordervalue)
FROM some_table
WHERE some criterias
GROUP BY orderheader
But when in x++ the order is another...
SELECT orderheader, sum(ordervalue)
FROM some_table
GROUP BY orderheader
WHERE some criterias

 I mean...come on! What the ...well. What is going on?

Tuesday, September 20, 2016

If you are going to read one article on PL/SQL this autumn...

Well...this is the one:  Bryn is the PL/SQL-guy to read.

Why not read it this month...The conclusion is:
"PL/SQL is better suited to the task of executing SQL statements and processing their results than any other programming language that can do this. It brings these signific
ant benefits:
  1. optimal expressiveness, maintainability, and therefore maximum chance of correctness
  2. optimal security
  3. optimal performance
It has never been said better...

Tuesday, September 06, 2016

A truly international company Oracle is...

Got this letter today because I want to subscribe to Oracle Magazine. I have done so during my 25 years in the Oracle world of databases et al.

Dear Lars Str,
Thank you for being a loyal subscriber to Oracle Magazine! I wanted to reach out today to share our new and improved subscriber features.
We're adding an extra level of security to your subscriber sign-in. When you sign into your Oracle Magazine account, you need to enter a password along with your email address.
Your temporary password is: 0345676826
Please use this temporary password to access your account now or reset your password here.
Once you sign in, you will gain immediate access to Oracle Magazine's award-winning digital content-now available for mobile devices too.
That's right! You can now access Oracle Magazine via iPhone, iPad, or Android mobile app or online through your desktop or laptop browser. We're proud to offer more convenient ways to view and engage our content on the go or right at your desk.
Enjoy your reading experience!

My name is Lars Sjöström but the letter ö mingled my name up...Strange...Very strange, no UTF-encoding? No i18n at all...

Truly Strange.

Wednesday, October 28, 2015

Setting up SQL Server 2012 vs Oracle some version

Setting up a SQL Server 2012 for various reasons. What are the differences vs a set up of a database, that are to be reached from remote. Well...there are some...There is a difference in terminology. And annoying default - but they are surely there for a reason - settings.

 A very good thing is that there is no TNSNAMES.ORA...:-). The Windows authorization mechanism handles all of that. So when everything is in place the remote PC finds everything very smoothly, thru the network.

Every change of the settings are done in various parts of the  SQL Server 2012 Manager-tool.

In SQL Server there is a concept of "USER" and (?) a "LOGIN". couple the USER to a specific LOGIN.

CREATE USER myuser FOR LOGIN myuser;

You have to Enable TCP/IP protocol.

The annoying - imho - is the default setting that disables access from outside. So just find the Enable SQL Server & Windows Authorization.

From zero to an accessible database the time should not be more than 8-12 hours for a regular database knowledgeable person. But bare in mind that that is a straight forward installation.

Friday, April 24, 2015

Ran into trouble immediately...

Trying to install Oracle 12c database on a laptop. Now, the laptop is a laptop that is handled by a service organization. I have no authorization to create a user on that laptop...

So...the creation of the Windows user for the Oracle_Home-processes failed.

Will try again and use the Built-in Windows user.

What is there to do?

Monday, January 27, 2014

This is a text from Sten Vesterli

It is very good in its description of the process of an IT-person in the organisation. Thank you Sten!

New employees start as non-contributors. They have low business knowledge and even though they might know the technology used in the organization, they do not know the existing systems or how it is specifically used.

As the employee masters the existing systems and technology, they move into the role of geek. These are the people with high technical skills, but low business understanding. Unfortunately, many IT people stay at this point on the IT value path, which is where they are vulnerable to outsourcing.

Some people move on to a role as analyst with a more business-oriented role. They start to understand the business, but the amount of learning necessary often means that their technical skills regresses.

A very few people move on from the analyst role toward being a star employee. Once they have mastered the business, they pick up the technology again, but now with a much better understanding of how technology can be used for strategic advantages fro the organization.

The valuable stars have both technical skills and business knowledge, but the path to IT stardom doesn't have to lead through years in the geek role. New non-contributors should be encouraged to take the value shortcut and learn the business first before building up their technical skills

Saturday, January 18, 2014

Container databases is The Future - or not?

Well probably not since there is no flashback.  What is a container database? Well there is lots to read on the internet. Of course. But it is - as I see it - the base for Clouds, private, public or hybrid.