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


Aug
30
awarded  Notable Question
Aug
24
asked How can I test sql scripts intended to run with sqlcmd -v in Sql Server Management Studio
Aug
14
awarded  Popular Question
Aug
7
awarded  Nice Question
Jul
21
comment Downsides to using SQL 2012 Upgrade as opposed to a fresh install?
Thanks for the hint to upgrade the databases. At this point in time it is easy to use the upgrade advisor to check them for incompatible items. You better do the same when you attach your databases to a fresh installed server.
Jul
18
comment Should I use SQL JOIN or IN Clause?
Might depend on DBMS. I know for sure that SQL-Server is optimizing Select *. (cf. Itzik Ben-Gan in Microsoft® SQL Server® 2012 T-SQL Fundamentals)
Jul
17
awarded  Popular Question
Jun
8
awarded  Constituent
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Jun
8
awarded  Caucus
May
15
awarded  Popular Question
May
14
awarded  Popular Question
May
3
awarded  Popular Question
May
1
awarded  Nice Question
Apr
30
awarded  Popular Question
Apr
2
awarded  Popular Question
Mar
11
accepted What is the replacement for EXEC sp_dboption <dbname> in SQL Server 2012?
Mar
11
comment What is the replacement for EXEC sp_dboption <dbname> in SQL Server 2012?
Yes that works for me. SQL-Server 2005, 2008, 2012
Mar
11
asked What is the replacement for EXEC sp_dboption <dbname> in SQL Server 2012?