3,609 reputation
21733
bio website
location Bern, Switzerland
age 48
visits member for 3 years, 5 months
seen 3 hours ago

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.


3h
comment How to change the instance name of SQL Server Express 2008?
@CraigEfrein: I don't think it was - at least I never read anything about this being possible in SQL Server 2014 now....
3h
revised Performing deltas / diffs over VPN from Oracle to SQL Server database
Product is officially called "SQL Server" - and neither MS-SQL, nor MSSQL, nor MS SQL or anything like that ....
3h
revised how can I install Microsoft SQL Server 2005 Express Edition on Windows 8.1
added 5 characters in body; edited title
3h
revised Reindexing Clustered Primary Key
deleted 24 characters in body
2d
comment utf8mb4 in SQL Server Express
The nchar/nvarchar types are Unicode and thus capable of handling Chinese, Japanese, Cyrillic, Arabic, Hebrew etc. characters. char/varchar are not Unicode, and thus very limited in their support for non-Latin alphabets. If you need far eastern characters, use nvarchar for your strings. Drawback: nvarchar always uses 2 bytes per character for its encoding
2d
revised utf8mb4 in SQL Server Express
added 23 characters in body; edited title
2d
revised Reading Data from SQL Server database
added 4 characters in body; edited title
2d
revised Spatial Index ignored when using additional non-spatial conditions
edited body; edited title
2d
revised Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012
deleted 22 characters in body; edited title
Jul
26
comment How to fix the SQL from SQL Server to Oracle?
Bad habits to kick : using old-style JOINs - that old-style comma-separated list of tables style was discontinued with the ANSI-92 SQL Standard (more than 20 years ago)
Jul
26
revised How to fix the SQL from SQL Server to Oracle?
added 50 characters in body; edited title
Jul
25
awarded  Notable Question
Jul
25
revised Derive daily delta from total daily counts? Tsql
added 13 characters in body; edited tags
Jul
25
revised Get complete value of varchar(max) field - SQL Server 2005
added 61 characters in body; edited title
Jul
22
revised Explanation requested for slow DELETE with SQL Server
deleted 11 characters in body
Jul
22
revised CREATE DATABASE defaulting to wrong log path
deleted 7 characters in body
Jul
22
revised Long running simple query SQL Server 2008 R2
added 9 characters in body
Jul
22
revised Recovery from lost SQL Server data file
added 31 characters in body; edited title
Jul
22
revised How do I include nulls during comparisons in SQL Server?
deleted 37 characters in body; edited title
Jul
22
revised Setting up a new database
added 31 characters in body