3,689 reputation
21733
bio website
location Bern, Switzerland
age 49
visits member for 3 years, 6 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
7
revised How to tell what invoked a trigger in SQL Server?
added 19 characters in body; edited title
Aug
7
revised SQL Server 2008 R2, error creating file for FileStream
deleted 5 characters in body; edited title
Aug
5
revised SQL Server : ALTER TABLE tablename SWITCH PARTITION 2 to tempempty
deleted 2 characters in body; edited tags; edited title
Aug
4
revised SQL Server : what licence is required?
edited body; edited title
Aug
4
revised Transferring Data from SQL Server to SQL Server Express?
added 9 characters in body; edited title
Aug
3
comment Execution Plan in Microsoft SQL Server
@AaronBertrand: absolutely - one of the trickier aspects of plan caching ...
Aug
3
answered Cannot open database “user_auth.mdf” requested by the login. The login failed. Login failed for user 'web_user'
Aug
3
revised How to merge multiple .ndf files into 1 .ndf file
deleted 3 characters in body; edited tags
Aug
3
revised Cannot open database “user_auth.mdf” requested by the login. The login failed. Login failed for user 'web_user'
added 26 characters in body
Aug
3
comment Cannot open database “user_auth.mdf” requested by the login. The login failed. Login failed for user 'web_user'
If you created the database using SSMS, you should use the logical database name and not the file with .mdf in your connection string! Use Server=XYZ;Database=user_auth;User ID=web_user;Password=web_user for your connection string and let SQL Server worry about the file-related details.
Aug
2
revised Execution Plan in Microsoft SQL Server
added 157 characters in body
Aug
2
revised TempDb Growing Big on Staging SQL Server 2005
added 18 characters in body; edited title
Aug
2
revised Text Storage and Database Design Optimization in a SQL Server Database
deleted 1 character in body; edited title
Aug
2
revised Rebuilding an entire Microsoft SQL Server Database
added 1 character in body; edited title
Aug
2
answered Execution Plan in Microsoft SQL Server
Aug
2
revised Execution Plan in Microsoft SQL Server
deleted 3 characters in body
Aug
1
comment Good pattern to run SQL Server 2008 CDC changes
Side note: you should not use the sp_ prefix for your stored procedures. Microsoft has reserved that prefix for its own use (see Naming Stored Procedures), and you do run the risk of a name clash sometime in the future. It's also bad for your stored procedure performance. It's best to just simply avoid sp_ and use something else as a prefix - or no prefix at all!
Aug
1
revised Good pattern to run SQL Server 2008 CDC changes
added 71 characters in body; edited title
Jul
31
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....
Jul
31
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 ....