meta user
network profile
| bio | website | adsi.mvps.org |
|---|---|---|
| location | Bern, Switzerland | |
| age | 47 | |
| visits | member for | 2 years, 3 months |
| seen | 22 hours ago | |
| stats | profile views | 207 |
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.
catch me at mscheuner -at- gmail -dot- com if you need to :-)
|
22h |
revised |
Migrating a database from SQL Server 2012 to the cloud edited title |
|
2d |
revised |
Search for multiple keywords related to separate columns on a single table deleted 5 characters in body; edited title |
|
May 23 |
revised |
How can I delete duplications with one query? edited tags |
|
May 22 |
revised |
Separate table by often changed / not often changed data? edited body; edited title |
|
May 21 |
revised |
One filegroup, multiple datafiles, how to get list of tables in each file added 12 characters in body |
|
May 21 |
revised |
MySQL many to many relation edited tags |
|
May 21 |
revised |
SQL Server TDE - add master key and certificate Product is called **SQL Server** - not "MSSQL" or "MS SQL" or "MS-SQL" or anything like that |
|
May 20 |
awarded | Constituent |
|
May 19 |
revised |
How to create new users for restored databases? Product is officially called "SQL Server" - neither MSSQL, nor MS SQL, nor MS-SQL or anything like that.... |
|
May 17 |
revised |
How to restore SQL Server 2008 R2 backup to SQL Server 2008 added 7 characters in body; edited title |
|
May 17 |
revised |
Get the 2nd or 3rd occurrence of a value in a delimited string Product is officially called "SQL Server" - neither MSSQL, nor MS SQL, nor MS-SQL or anything like that.... |
|
May 17 |
comment |
convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112) I would recommend to always explicitly specify a length for a varchar. In different places, you get different default lengths; as a parameter to a procedure, you get a default length of 1 character - typically not what you expect. |
|
May 17 |
comment |
Is there a system primary key associated with each row? No, at least nothing you can get your hands on easily. Every row has some system-level location information - file id, page id and offset inside the page - but that information is very much internal to SQL Server and not easily accessible from the outside (and definitely not useable to select your row from T-SQL!) |
|
May 15 |
revised |
Missing values in INNER JOIN MS-Access? edited tags |
|
May 15 |
revised |
Manually entering data using Management Studio added 1 characters in body; edited title |
|
May 14 |
awarded | Nice Answer |
|
May 14 |
revised |
Scheduled stored procedure on all databases in my server added 4 characters in body |
|
May 14 |
revised |
Is CakePHP with MySQL good for Social Network developmet deleted 1 characters in body; edited title |
|
May 14 |
comment |
How to check if I am hitting the Express Edition size limit? SQL Server 2008 R2 Express also has a 10 GB limit (just for completeness) |
|
May 14 |
revised |
SQL Server 2012 Simple Recovery Model with LOG_BACKUP log_reuse_wait_desc deleted 3 characters in body; edited title |
