3,704 reputation
21733
bio website
location Bern, Switzerland
age 49
visits member for 3 years, 7 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.


Aug
28
revised How to setup SSL in SQL Server 2012 with own certificate?
deleted 1 characters in body; edited tags; edited title
Aug
27
revised Freeing space after deleting rows
deleted 1 characters in body
Aug
27
revised How to call Oracle's stored procedure from DB2 stored procedure?
It's a **STORED** procedure - as in **STORED** inside your database server - has nothing to do with a "store" .....
Aug
27
revised SQL Server 2012 Reporting Services: “Unable to connect to the remote server”
added 17 characters in body; edited title
Aug
21
comment EF Code First uses nvarchar(max) for all strings. Will this hurt query performance?
YES, using varchar(max) everywhere hurts your performance - don't do it! Use appropriate datatypes - use varchar(max) ONLY if you REALLY need more than 8000 characters! (I have never seen a person's name or e-mail be that long!) - See What's the Point of Using VARCHAR(n) Anymore? for more info
Aug
21
revised SQL Server 2012 Availability Group issue
deleted 29 characters in body; edited title
Aug
16
revised No SQL Server instances show in upgrade setup
added 13 characters in body; edited title
Aug
15
revised Merge replication issue : conflicts with new data
Product is called **SQL Server** - not "MSSQL" or "MS SQL" or "MS-SQL" or anything like that
Aug
15
revised Error creating XTP Table in SQL Server 2014 CTP1 with Powershell
added 2 characters in body; edited title
Aug
15
revised How to create a trigger in a different database?
added 4 characters in body
Aug
14
revised Distributed transaction and Read Committed Snapshot
added 1 characters in body; edited title
Aug
14
revised Tracking changes in stored procedures within a database
added 6 characters in body; edited title
Aug
13
revised Cannot connect remotely to a named instance
edited body
Aug
12
revised Auto Update Statistics Duration and Interruptions
deleted 15 characters in body
Aug
8
revised Moving away from CmdExec steps in job without losing logging detail (SQL Server 2008)
Product is officially called "SQL Server" - neither MSSQL, nor MS SQL, nor MS-SQL or anything like that....
Aug
8
revised Convert all ntext columns to nvarchar(max)
deleted 282 characters in body
Aug
6
comment SQL - I have just Differential backup but database exists
SQL is not a database product - it's the Structured Query Language - a querying language only. So you'll need to tell us what concrete database product (and which version) you're using - please update your tags accordingly!
Aug
5
revised FTs catalog in SQL Server for multiple FT index
edited body; edited title
Aug
5
revised Selecting from an excel spreadsheet into SQL Server table
added 42 characters in body; edited title
Aug
4
revised How do I view a Microsoft SQL Server Compact Database
added 14 characters in body; edited title