Itai Goldstein

Cheat Sheets

This might come handy for some of you out there: cheat sheets for developers and students.

Hope you’ll find it useful.

Generating SQL Server DB scripts

This solution is probably known to a lot of you out there, but for the ones who don’t, here is the solution in a Step-By-Step tutorial:

In SQL Server Management Studio right click on one of the databases on your Object Explorer, and choose Tasks->Generate Scripts…:

Then you’ll be introduced with the SQL Server Scripts Wizard:

Next, you need to choose the database you would like to generate scripts for, in this step you can choose whether to script all objects in your database, or you can set the ones you want in a latter step:

Now you need to choose your script options:

In the following steps you need to configure which object types you would like to script, and choose the specific objects (unless you decided to check the “Script all objects in the selected database” option):

The Object types you want to script:

And the objects:In the last step, you need to choose where to output the script to:

That’s it.

Hope you’ll find it useful.

Configuring AJAX Extensions In SharePoint

Using SmartPart in SharePoint can reduce web parts development time.

The SmartPart install document includes instructions on configuring AJAX Extensions on SharePoint website configuration file, but it lacks 2 issues I’ve encountered while enabling SmartPart on my SharePoint website:

1. This is pretty straight forward – if you’re using a more advanced version of the AJAX extensions – you should update its full assembly name:

   Assembly="ReturnOfSmartPart, Version=1.3.0.0, Culture=neutral, PublicKeyToken=9f4da00116c38ec5"

2. Under runtime->assemblyBinding tags add a dependent assembly tag:

   <dependentAssembly>
     <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35" />
     <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0" />
   </dependentAssembly>
   

Hope you’ll find it useful.