July 2012 – Knowledgebase

Only creating a schema, when it does not exist in a Microsoft SQL Server database.

17 July, 2012 Roel van Lisdonk 0 Comments 1 category

If you want to create a schema in a Microsoft SQL Server database only when it does not exist, use: declare @SchemaName nvarchar(128) set @SchemaName = 'Staging' if not exists(select top 1 1 from information_schema.schemata

Fix / restore user and login mappings in SQL Server

17 July, 2012 Roel van Lisdonk 0 Comments 1 category

If you restore a SQL Server (< 2012) database on an other database server make sure you fix the user and login mappings by following the steps on http://atakala.com/browser/Item.aspx?user_id=amos&dict_id=2036 Short fix: use MyDatabase go sp_change_users_login

How to fix: Can’t drag and drop custom Team Foundation Build Activity on XAML build process template in Microsoft Visual Studio 2010.

12 July, 2012 Roel van Lisdonk 0 Comments 1 category

A .NET 4.0 assembly containing a custom Team Foundation Build Activity can only be dragged and dropped from the toolbox on your build process template XAML file, when it is first registered in the GAC.

How to correctly use select top 1 inside a inner join of an update statement in T-SQL.

11 July, 2012 Roel van Lisdonk 0 Comments 1 category

And the answer is: don’t use select top 1, instead use the row_number() function and the OVER clause. Lets assume we have a table structure like: Table [Observation] Multiple observations during a TimeSpan

Convert string to bytes and bytes to string without encoding

10 July, 2012 Roel van Lisdonk 0 Comments 1 category

I wanted to save information found in a file to a database without having to deal with encodings, well I found my solution at http://stackoverflow.com/questions/472906/net-string-to-byte-array-c-sharp [TestClass] public class RliResearchTester { [TestMethod] public void

Month: July 2012

Only creating a schema, when it does not exist in a Microsoft SQL Server database.

Fix / restore user and login mappings in SQL Server

How to fix: Can’t drag and drop custom Team Foundation Build Activity on XAML build process template in Microsoft Visual Studio 2010.

How to correctly use select top 1 inside a inner join of an update statement in T-SQL.

Convert string to bytes and bytes to string without encoding

Microsoft TechEd Europe 2012

Continuous testing with Mighty Moose and Microsoft Visual Studio

TIP: Reassign keyboard shortcuts, when using TDD with Microsoft Visual Studio and TestDriven.Net

How to set DropDownList.SelectedValue for unit testing in ASP .NET web forms.