10g (1) 11c (1) 11g (5) 12c (4) 3.0 (1) ApEx (4) Cloud (11) database (10) DBA (1) EBR (1) EC2 (2) education (3) 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 (3) standards (6) Sun (1) support (6) W8 (1) WebLogic Server (5)

Wednesday, February 13, 2019

The story continues...

There is a way of import data into SQL Server. A strange - or versatile if you want - way. Still there are a lot of tries before it is actually working. The best method is to export data to Excel sheets.
Then import them into the target database also using Excel sheets.

However suddenly during one of my import sessions suddenly the import screen locked. It is still locked while I am writing this.

So...SQL Server Manager is a strange tool that behaves very odd.

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?

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.