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/


Mar
13
asked How to migrate SQL Server Stored Procedures using temporary tables or table variables to Oracle?
Mar
13
asked Can I determine if a stored procedure uses dynamic sql without parsing the definition?
Mar
12
asked Are there other sites forbidding SQL developer to use c style comments?
Mar
10
asked How can can I get object definitions stripped of all comments?
Mar
10
asked Can I call SMO from pure T-SQL?
Mar
8
answered What standard should I follow when naming tables and views?
Mar
8
asked Why are Denali sequences supposed to perform better than identity columns?
Mar
8
asked How can I assign different random values to each row in a SELECT statement?
Mar
8
asked Why does SQL*PLUS need a slash after CREATE TYPE?
Mar
8
asked Which fillfactor is used by ALTER INDEX REBUILD?
Mar
7
asked In a Trigger, can I determine if a column was explicitly set to a values or not mentioned in update statement?
Mar
6
asked How to convert primary keys into clustered primary keys for a great number of tables keeping referential identity
Mar
5
asked Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?
Mar
4
answered How do you document your databases?
Mar
1
answered Multiple Oracle Instances — is this a good practice?
Feb
25
asked How to combine date and time to datetime in SQL Server?
Feb
25
asked Is where x = 0 or x is null to be replaced by where isnull(x, 0) = 0 resp. where NVL(x, 0) = 0
Feb
22
asked What is the purpose of sqlbulkcopy's useinternaltransaction property?
Feb
20
asked Why do primary keys have names of their own?
Feb
20
asked Which are the Oracle basics required for advanced Oracle.DataAccess usage?