Unable to connect to remote server (SSRS)

I attempted to log into a new installation of SSRS Manager and received an error : Unable to connect to remote server .

This is what I did to fix the issue:

I went to C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config file.

I changed the value for the SecureConnectionLevel key to 0. It was previously set to 2.

<Add Key ="SecureConnectionLevel" Value="0"/>

I logged back into SSRS Manager and was able to after that.

Migrating to SQL Server Azure

I have recently migrated a production database to SQL Azure. I used the following tool :

SQL Azure Migration Wizard v3.63

http://sqlazuremw.codeplex.com/

The reason why you have to use the wizard is because SQL Azure does not contain some syntax that normal SQL Server 2008 R2 contains. Unless you want to sit there and change every creation script that you made prior to Azure (like what I did for 2 days :( ) I suggest you use the tool. The migration wizard will go through your database and create "CREATE" and "INSERT" scripts for you. You are allowed to run the scripts manually or use the tool again to insert and create the database for you. I choose to do the entire path.

After the wizard was complete I logged back into the SQL Azure portal and copied the Data Source key and used it in our application and BAM it worked.

Helping out a beginner student in SQL

I recently was asked by a student that is currently taking a database class using SQL Server and he asked the following question.

"Can I multiply a percent (ex. 10%) to an existing column?"

SELECT (COLUMNNAME * 1.10) AS NEWCOLUMNNAME FROM TABLENAME