4,039 reputation
21938
bio website
location Bern, Switzerland
age 49
visits member for 4 years, 1 month
seen yesterday

Note to all SO beginner:

Please read (and embrace!) Jon Skeet's helpful hints on how to write a good question (or at least his short version here ) - one that has a chance that someone can answer it.


A Pascal/Delphi programmer and database freak at heart, I work as a C# developer on line-of-business applications (mostly ASP.NET).

I'm interested mostly in distributed systems (WCF), database (design and SQL), and Active Directory.


I'm an MCPD .NET 4 Web Developer, MCPD .NET 4 Windows Developer, MCPD Enterprise Application Developer (.NET 3.5), and MCTS for WCF, ADO.NET, Winforms and ASP.NET.


Mar
25
answered Differentiate SQL Server Express from SQL Server installed in a server
Feb
20
answered how to identify table name using a column name if we are not aware about the table name
Nov
29
answered Column name or number of supplied values does not match table definition error
Sep
11
answered Index optimization for table that is truncated every day
Aug
3
answered Cannot open database “user_auth.mdf” requested by the login. The login failed. Login failed for user 'web_user'
Aug
2
answered Execution Plan in Microsoft SQL Server
Mar
18
answered SQL Server 2008 R2 Missing Index
Mar
8
answered Subqueries are not allowed in this context. Only scalar expressions are allowed
Dec
2
asked Quickly restoring a backup over top of an existing database - error “database in use”
Nov
22
asked Clustering vs. transactional replication vs. availability groups
Sep
21
answered Custom Auto-Generated Sequences with SQL Server
Aug
28
answered Constant values in columns
Jul
8
answered When do you add your foreign keys?
May
13
answered Remove collation from all database columns
Apr
22
answered Does SQL Server place shared locks on scanned records when using REPEATABLE READ
Apr
19
answered Server side trace to database
Mar
25
answered Back up my ASPNETDB
Feb
13
answered PK Fragmentation on INT IDENTITY column
Feb
6
answered How to force drop database in SQL Server 2008
Jan
28
answered How to query last restore date in SQL Server?