How to deploy On-Premise Microsoft SQL Database to Windows Azure SQL Database

This short article shows you how to move On-Premise Microsoft SQL Database to SQL Azure Database.

In the past we have struggling to restore the database to SQL Azure but unfortunately this is not happening.

Somehow Microsoft added a feature Deploy Database to Windows Azure SQL Database in SQL Management Studio.

To export the On-Premise Microsoft SQL Database to Windows Azure SQL Database, do the following.

1.      Start SQL Management Studio 2014.

2.      Right click on the database that you want to export, for example “NORTHWND (tree item)”.

3.      Select Deploy Database to Windows Azure SQL Database.

clip_image002

4.      Click on “Next > (button)” in “Deploy Database ‘NORTHWND'”.

clip_image004

5.      Click on “Connect… (button)” in “Deploy Database ‘NORTHWND'”.

clip_image006

6.      Type the authentication for your Windows Azure SQL Server.

clip_image008

7.      Select on “S0 (list item)” if you remember the price showing in my previous blog. Click Next.

clip_image010

8.      Review the summary then click on “Finish button)”.

clip_image012 

9.      Click Close when it is done.

 

clip_image014

You can now sign in to your portal and check.

Posted in .Net, Cloud, Community, Servers | Tagged , , , , | Leave a comment

How to get Windows Azure with USD 100 credit for 3 months

This short instruction let you know how to get Windows Azure with USD 100 for 3 months.

Go on to the link below:

https://www.itprocloudessentials.com/?MC=CloudPlat&MC=MSAzure&MC=WinServer&MC=SysMagSof

Click Activate Now.

clip_image002

Once you get the Validation Code then you can fill in the rest of the details in the Azure portal.

clip_image004

Seriously, I am not sure how long will this offer available but I activated one.

Posted in .Net, Community | Tagged , , , , , | Leave a comment

How to download and install Power BI

This short writing shows you where to get Power BI Desktop.

1.      Go to Powerbi.com

2.      Click Products then choose Power BI Desktop.

 pbi1

3.      Click on Download.

 pbi2

4.      Run the file that you just downloaded.

Posted in .Net, Community, Microsoft Office, Office 365 | Tagged , , , , | Leave a comment

Skype for Business always crash

This short steps is for those Skype always crash.

For me, my Skype crashes every time I type my authentication after I installed Microsoft Project or Microsoft Visio.

Do the following.

1. Start your Microsoft Word.

2. Click on File.

clip_image002

3. Click on Update Option.

clip_image003

4. Click Update Now.

clip_image004

That resolved my problem.

Posted in Community, Microsoft Office, Office 365 | Tagged , , , | Leave a comment

Create SQL Azure Database

This short article is to show you how to create SQL Azure Database and the cost of creating them.

I use the Fee Trail license that I have.

1. First login in to my portal.azure.com.

2. You will see SQL Databases

3. Click on that and click the + on top.

4. Type in your Database name.

clip_image001

5. Create the new Server if you do not have one.

6. Type in the Server name and the login.

The login is important because that is how you can login using your SQL Management Studio.

clip_image003

7. The critical part is now, make sure you don’t choose the server that you don’t need. The default one chosen for me is the S2 which cost thousands. I choose the S0 which you can see it is USD 12.65.clip_image005

8. Once you choose your server then click Select.

9. Now you can click Create.

You can see your SQL Azure Database is Deploying now.

clip_image007

You will see your database in SQL Databases. When you click on the database then you will see the details.

sqlazure5

Posted in .Net, Community | Tagged , , , | Leave a comment

Adjust date and time using Internet Server

This short article shows you how to adjust the date and time automatically from the Internet Server.

You need to do this if you have many computers with the spoiled battery like I do or you have changed your time zone. This task sounds simple but I have taken quite some times to get it done.

To do this using GUI.

1.      Right click the Clock.

2.      Left click on “Adjust date/time (menu item)”.

image

 

3.      Left click on “Additional date, time, & regional settings (hyper link)” in “Settings”.

image

4.      Left click on “Set the time and date (link)” in “Control Panel\Clock, Language, and Region”.

image

5.      left click on “Internet Time (tab item)” in “Date and Time”.

image

6.      left click on “Change settings… (button)” in “Date and Time”.

image

7.      Left click on “Update Now”.

image

To do this in command prompt.

1.      Start Command Prompt as Administrator.

2.      Type net startw32time.

You might not need to run this command if your Windows Time service is already running.

3.      Type w32tm /resync /force.

Many websites are asking you to type w32tm /resync you bet, that will not work all the time for me.

Posted in Community, Operating System | Tagged , , , , , , | Leave a comment

Choose component to install in Microsoft Office 2016

This short article shows you an option to choose components to install while installing Office 2016.

Don’t know for what stupid reason Microsoft has removed the installation step that let you choose what component you would like to install for Microsoft Office 2016.

The only way to choose the component is to edit configuration.xml. How do you get configuration.xml file?

1.      Download the Office 2016 Deployment Tool http://www.microsoft.com/en-us/download/details.aspx?id=49117.

Then you will get a file officedeploymenttool_6612-6353.exe.

 

2.      Run officedeploymenttool_6612-6353.exe then you get another 2 file, configuration.xml and Setup.exe.

3.      Edit the configuration.xml.

<Configuration>

  <Add OfficeClientEdition=32 Branch=Current>

    <Product ID=O365ProPlusRetail>

      <Language ID=en-us />

      <Language ID=en-us />

      <ExcludeApp ID=Access />

      <ExcludeApp ID=Groove />

      <ExcludeApp ID=InfoPath />

      <ExcludeApp ID=Lync />

      <ExcludeApp ID=OneNote />

      <ExcludeApp ID=PowerPoint />

      <ExcludeApp ID=Publisher />

      <ExcludeApp ID=SharePointDesigner />

    </Product>

    <Product ID=VisioProRetail>

      <Language ID=en-us />

    </Product>

  </Add>

  <!–  <Updates Enabled=”TRUE” Branch=”Current” /> –>

  <!–  <Display Level=”None” AcceptEULA=”TRUE” />  –>

  <!–  <Property Name=”AUTOACTIVATE” Value=”1″ />  –>

</Configuration>

Based on the above ExcludeApp ID Office 2016 will only install Word, Excel, Outlook, and Visio.

4.      Run Setup.exe /configure configuration.xml.

 o2016a

It took me 5 hours to install over 2 mega bit line. It is called We’ll be done in just a moment.

Posted in .Net, Community, Microsoft Office, Office 365 | Tagged , , , , , , | Leave a comment