May 2012 – Knowledgebase

Using the SSDT and SSDT Power Tools in Microsoft Visual Studio 2010

29 May, 2012 Roel van Lisdonk 0 Comments 1 category

If you are developing an application that has a SQL Server database as backend, then during development you probably will have Microsoft Visual Studio 2010 and Microsoft SQL Server Management Studio open. The free SSDT

Shifting to express products like Microsoft IIS Express 8 and Microsoft SQL Server 2012 LocalDb for development.

24 May, 2012 Roel van Lisdonk 0 Comments 1 category

Most express products have some things in common: – Contain the same features as the full product (except for some limitations like, no more then 4GB memory or no more then 10 users etc.) –

How to dynamically switch between IIS Express and full IIS in Microsoft Visual Studio 2010 by using a csproj.user file.

24 May, 2012 Roel van Lisdonk 0 Comments 1 category

If you want to give every developer the choice to use IIS Express or full IIS during development in Microsoft Visual Studio 2010 sp1, you can use a csproj.user file for you project. This file

And we are ready for takeoff with TFS in the cloud with Microsoft Visual Studio Team Foundation Service Preview

24 May, 2012 Roel van Lisdonk 0 Comments 1 category

We finally got access to the Microsoft Visual Studio Team Foundation Service Preview. To learn more about this source control in the cloud thing, check: http://blogs.msdn.com/b/visualstudioalm/archive/2011/09/14/learning-about-team-foundation-service-preview.aspx

Simplest way to add forms authentication to you Web.config in ASP .NET, when using AspNetSqlMembershipProvider

24 May, 2012 Roel van Lisdonk 0 Comments 1 category

If you’ve got a website and this website contains a Login.aspx and a Default.aspx page in the root. The simplest way to deny all unauthenticated user access to the website is adding the following to

How to delete and reseed all data in a SQL Server database

23 May, 2012 Roel van Lisdonk 0 Comments 1 category

If you want to delete all data in a SQL Server database and reseed the tables that contain a identity column, you can use the following code: exec sp_msforeachtable "alter table ? nocheck constraint all";

Solution for: Microsoft Lync keeps asking me to sign in after update

21 May, 2012 Roel van Lisdonk 0 Comments 1 category

After some updates today Microsoft Lync kept on asking me to sing in. If I canceled the dialog an Exchange server error was displayed: Error Lync cannot connect to the Exchange server. To restore this

Unable to load VertiPaq engine in PowerPivot for Excel

21 May, 2012 Roel van Lisdonk 0 Comments 1 category

Problem Solution Installing the latest version of Microsoft SQL Server 2012 PowerPivot voor Microsoft Excel 2010 found at: http://www.microsoft.com/downloads/nl-nl/details.aspx?FamilyID=4b5d8276-d8c8-49b3-a653-f09f744ed9c5 resolved the problem.

Check for Null or empty string in VBScript

21 May, 2012 Roel van Lisdonk 0 Comments 1 category

To check if a string is empty in VBScript, you can use the function Len. Both message boxes will be shown. Notes A String in VBScript can’t be set to Null. An unset

How to do JavaScript unit testing from C# with MSTest and JSTest

11 May, 2012 Roel van Lisdonk 2 Comments 1 category

I wanted to run regular MSTest unit test written in C# to assert JavaScript code. There are several ways to accomplish this, but in this case I use JSTest. Just add JSTest to your C#

Month: May 2012