4,400 reputation
84085
bio website pauerschell.blogspot.com
location Germany
age 62
visits member for 3 years, 11 months
seen Nov 22 '13 at 19:11

Database developer for SQL-Server and ORACLE. Doing a lot with PowerShell.

I'm German and it is now only 4 years that I started bloging (in english) and now i'm contributing to several OpenSource Projects. Codeplex SQLPSX is the most important of them. There I'm porting SQLIse to Oracle and now to MySQL too.

If your are interested in databases and PowerShell (or other ways to use ADO.NET) please visit: http://sqlpsx.codeplex.com/


Jan
9
comment How does the Oracle DUAL table work?
We once even succeeded in creating our own DUAL table shading the oracles DUAL table and were able to insert and fetch more than one row from it.
Jan
9
comment What is the significance of a semicolon at the end of SQL*Plus commands?
+1 To make things more confusing, you can use / on the following line instead of the ; in some cases.
Jan
8
comment Performance implications of MySQL VARCHAR sizes
+1 this question applies similar to all DBMS. My observation many varchar sizes tend to grow.
Jan
7
comment What can I do to find out since which release a given DBMS supports a feature, function, etc?
Thanks. That's the kind of presentation I'm looking for. Only my focus is SQL-Server and Oracle.
Jan
7
comment What can I do to find out since which release a given DBMS supports a feature, function, etc?
Thanks. I just tried it successful on some SQL-Server functions.
Jan
6
comment Can I change the SID of an Oracle database?
No I work as DBA for the develop and some test Oracle databases.
Jan
5
comment Feature comparison: Oracle Database and Microsoft SQL Server
Best we can collect some or many links to such comparisons.
Jan
4
comment What is an effective way of labeling columns in a database?
@joe never noticed that Oracle is different. Can you give a link?