SQL Fiddle: a tool for database developers


(via)

SQL Fiddle is a tool for database developers to test out their SQL queries.  If you do not know SQL or basic database concepts, this site is not going to be very useful to you.

[ link ]

See also: JsFiddle, a playground for web developers

ASP.NET: Adding Membership to an mdf file

In case you need to add Membership to an *.mdf file you need to use the tool: aspnet_regsql.exe.

This tool can be found in:

C:\WINDOWS\Microsoft.NET\Framework\<versionNumber>\

In my case it was:

C:\Windows\Microsoft.NET\Framework\v4.0.30319\

Now getting the tool working with an *.mdf file (MyData.mdf) should be done like this:

C:\Windows\Microsoft.NET\Framework\v4.0.30319>aspnet_regsql.exe -C "Data Source=
.\SQLEXPRESS;Integrated Security=True;User Instance=True" -d "C:\Users\Teusje\do
cuments\visual studio 2010\Projects\MySite1\MySite1\App_Data\MyData.mdf" -A all

Start adding the following features:
Membership
Profile
RoleManager
Personalization
SqlWebEventProvider

................

Finished.

C:\Windows\Microsoft.NET\Framework\v4.0.30319>

More information about can be found here and here (msdn).

Enjoy ;)