Install SQL Server in Ubuntu 16.04

The other day I was trying to connect a Laravel application with a SQL Server database. I have been working in ubuntu and at the beginning I thought I have to install a Windows Virtual Machine to accomplish that but, after google a little bit I found that Microsoft has a version of the SQL Server for linux. The process is simple, just run the following lines in your ubuntu shell:

sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install msodbcsql
sudo apt-get install unixodbc-dev gcc g++ build-essential
sudo pecl install sqlsrv pdo_sqlsrv
sudo echo "extension= pdo_sqlsrv.so" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`
sudo echo "extension= sqlsrv.so" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`

After this process you are going to have a trial version of the database in your ubuntu.

Git clone error: RPC failed; result=22, HTTP code = 500

The other day I was trying to clone a repository with no success, the errr I received was:

$ git clone https://githost/username/repository.git

error: RPC failed; result=22, HTTP code = 500
fatal: The remote end hung up unexpectedly

After a search I found that if you are pretty sure about your connection account and url the problem is with http.postBuffer. To increase the http.postBuffer you should execute the following command:

git config --global http.postBuffer 524288000


The number 524288000 could change according to your necessities.

After that you can run git clone without troubles.

How to change URL of a remote git repository

A few days ago one of our developers quit his job and we assigned the laptop to another person. All the git repositories were configured with his account, so we had to change the url for every git repository.

The process to change the repository url is very simple.

To see what is the actual repository you have to use the command git remote -v, then you will see two lines showing you the fetch url and the push url. Something like the following lines:

origin  githost:USERNAME/REPOSITORY.git (fetch)
origin  githost:USERNAME/REPOSITORY.git (push)

To change the fetch url you have to execute the following command:
git remote set-url origin githost/USERNAME/OTHERREPOSITORY.git

And to change the push url the command is:
git remote set-url --push origin githost:USERNAME/OTHERREPOSITORY.git

That is it! You changed your urls.

Android Studio Renderer Problem

When I installed Android Studio on my Macbook air ad created the first project I got a problem when I tried to open a layout in the Desing view. The problem was:

The first thing you have to do in order to correct this problem is to check if you have Android 1.8 installed in your machine. To do that you have to run the following command:

If you see java version "1.8.0 ..." the problem is in your Android Studio configuration. You can check the java version in Android Studio in Android Studio->

If you see something different from Java 1.8 you have to configure Java 1.8 in the Info.plist file of Android Studio.

Go to Applications->Android Studio->Contents->Info.plist

Open the Info.plist and in the attribute <key>JVMVersion</key> put  <string>1.8*, 1.8+</string>

My old configuration was:

Now I have:

Re run Android Studio and now you are could open layouts in Design tab and view the interface render.

How to include structured data in your enterprise web site

Recently we have been trying to improve the rank of our web page in Google. There are a lot of online services that can evaluate the state and rank of a web page in order to give some advices of what to do to improve the positioning. These kind of  analysis are called SEO analysis.

One of the points we found to improve in our web page was the lack of structured data included in the page. In this post I am going to explain how we included some basic structured data in the Yottadata web page using some tools provided by Google.

According to Google  "Structured data refers to kinds of data with a high level of organization, such as information in a relational database. When information is highly structured and predictable, search engines can more easily organize and display it in creative ways. Structured data markup is a text-based organization of data that is included in a file and served from the web. It typically uses the schema.org vocabulary—an open community effort to promote standard structured data in a variety of online applications." . You can find the complete explanation here.

The most common format to include structured data in a web page is the JSON-LD format. It is the format we used in our web page.

Let's start talking about how we integrate the structured data in the Yottadata web page. First of all, we started using the Google Markup Helper service that helps webmasters to create this kind of content. We opened the service and we are going to see the following page:

The structured data we wanted to add was for our company web page so we choosed Local Businesses in the Website tab and then we wrote the url of our page, in this case www.yottadata.co. You can choose the more convenient data type to your page and even copy and paste the html code directly to the service. Finally we have press the Start Tagging button.

The service is going to load the HTML code and provide the main attributes for the selected data type.



On the right panel we can see the attributes we have to complete for the Local Business data type. To complete the information you just have to click the elements directly from the web page and select the attribute that matches with the selected element. The following image shows an example with the name attribute:




If you do not find an element to match with the attribute in the scheme you can add it manually using the button 'Add missing tags' at the end of the right panel




and wrote the information manually.




At the end of the process you have to press the 'CREATE HTML' button and the markup service is going to generate the code.







By default it generates the code in html tags but we prefer to use de JSON-LD format so despite of select Microdata we selected  JSON-LD.






This is going to generate JSON-LD code that you can simply copy and paste into your header tag.





To validate the structured data in the web page you can use another Google service called the testing-tool for structured data. There you can put the url or the generated code and validate the structured data included by pressing 'RUN TEST'.






The following image shows the results in our web page:





I hope this post will serve as a guide for webmasters to include structured data into the web pages. If you see drafting problems feel free to correct me.