3,499 reputation
21529
bio website
location Bern, Switzerland
age 48
visits member for 3 years, 2 months
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.


Feb
21
revised What permissions does the service account need to use database mail?
added 12 characters in body
Feb
21
revised Post Database upgrade on new instance
added 53 characters in body
Feb
20
revised Error creating database in SQL Server Management Studio
added 8 characters in body; edited title
Feb
20
revised SQL Server Table Backup
added 9 characters in body; edited title
Feb
19
comment Normalisation of practise database
By default, every table ought to have a primary key! It's what reliably, uniquely identifies each row of the table - so NO, by no means just ignore adding primary key to your tables! That's a horrible design ....
Feb
19
revised Normalisation of practise database
deleted 16 characters in body; edited title
Feb
19
revised Separating a date column in Access into Month, Day and Year while keeping the new columns ordered by a seperate column(primary key)
added 2 characters in body; edited title
Feb
19
revised Error: 18456, Severity: 14, State: 11
added 10 characters in body
Feb
18
revised SQL Server database recovery
added 52 characters in body; edited title
Feb
17
revised Best practice to avoid a composite key?
added 129 characters in body; edited title
Feb
17
awarded  Enlightened
Feb
17
awarded  Nice Answer
Feb
17
revised How to force drop database in SQL Server 2008
added 18 characters in body; edited title
Feb
14
revised Deny permissions for master in SQL Server
added 69 characters in body; edited title
Feb
13
revised Can I alter a view being referenced with schemabinding if the change fulfills the binding requirement?
added 11 characters in body
Feb
12
revised Database restore on new server and upgrade to SQL Server 2012
added 21 characters in body; edited title
Feb
11
revised Speed of Searching Text vs INT/BIGINT - SQL Server 2012
Product is officially called **SQL Server** (and not MS SQL, MSSQL MS-SQL or anything like that....)
Feb
10
revised Import and export data from SQL Server table using query
edited body; edited title
Feb
10
comment Reset SQL Server sa password
No, no data will be lost! You can easily uninstall and re-install SQL Server and then re-attach the existing .mdf files to the new installation again.
Feb
8
revised Why is SQL Server 2012 working set memory low?
added 14 characters in body; edited title