4,385 reputation
83985
bio website pauerschell.blogspot.com
location Germany
age 62
visits member for 3 years, 10 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/


Dec
22
comment Isn't a tab (char(9) ) whitespace in the ANSI/ISO SQL-92 specification (Section 8.2, , General rules #3)?
Yes thanks. That helps a lot.
Dec
22
comment Remote RESTORE of database through SSMS
Can you access the sql servers local filesystem by some share?
Dec
21
comment How to write a check constraint to disallow empty varchar fields?
@ypercube CHECK (val > '' ) doesn't work in SQL-Server.
Dec
21
comment How to write a check constraint to disallow empty varchar fields?
+1 But I'm curious if there other ways to write this constraint.
Dec
20
comment How to catch and handle only specific Oracle exceptions?
That is exactly what I condensed from Sathyas proposals myself.
Dec
20
comment How to catch and handle only specific Oracle exceptions?
can't I go just go without the when others raise lines ?
Dec
20
comment Is Using Execute Immediate Bad Practice in Oracle?
@Jack Please help me by answering question dba.stackexchange.com/questions/9441/…
Nov
27
comment Single versus Multiple databases
Is pureXML a key feature you intend to use or is it just something that DB2 provides?
Nov
27
comment Single versus Multiple databases
Scalable to what? To serve a single hospital to serve a group of hospitals? You may also ask such questions on healthcareit.stackexchange.com/questions which is currently in public beta.
Oct
31
comment Are there ways to only replace SQL Server stored procedures when the definition has changed?
@Nick make it an answer
Oct
31
comment Are there ways to only replace SQL Server stored procedures when the definition has changed?
I have to replace procedures with *= syntax by left join syntax and it is not granted that all customers have the same version due to customizing. I want to apply the fix to only those who have the version I modified
Oct
31
comment Are there ways to only replace SQL Server stored procedures when the definition has changed?
I agree with that argument. But please see my last edit.
Oct
30
comment What specifically does OracleBulkCopy do, and how can I optimize its performance?
I have a PowerShell skript running, calling bulkcopy into an Oracle database from an SQL Server data reader, all target tables with primary Keys and I have no problems with tables with up to 205278 rows. But I'm very careful to first full the master tables before filling the details tables. I did not remove any of the other index on the table and I have no problems when the tables are initially empty.
Oct
30
comment What specifically does OracleBulkCopy do, and how can I optimize its performance?
I'm not sure about checking primary key constraints. I happed to bulk insert the same data into an Oracle table 2 times and Select * shows 2 the duplicated rows. In that state Delete is not possible, but truncate table helps to get back to a clean state.
Oct
27
comment What specifically does OracleBulkCopy do, and how can I optimize its performance?
Are you using a DataReader to read the data from the source?
Oct
24
comment How to find “outer join in the where” syntax in SQL 2005 using cmptlevel 80?
I always felt that replacing the server is the only right moment to fix that problems. Are you saying that there is a tool that would have helped?
Oct
24
comment How to find “outer join in the where” syntax in SQL 2005 using cmptlevel 80?
My problem is the display of the result. QueryAnalyzer and SSMS have bad habits of truncating the result. BTW the offending code must be fund. Artefacts ignored -- keep *= as comment to make work harder and the rest must manually fixed.
Oct
11
comment How do I create a database+tablespace+user in Oracle 11gR2?
Yes XE has no Database Configuration Assistant. I have an x86 Version of XE running in XP. It uses some WEB interface for Configuration. Without trying I can't predict how your version behaves under Windows 8. The next few days I have no resources to check that.
Sep
29
comment Login Problem as SYSDBA ORA-01031
That seems to be the right hint. I found fresh log entries
Sep
29
comment Login Problem as SYSDBA ORA-01031
It is the same remote machine to which I connect using two different windows accounts.