Blogs

How to change in SQL Server the key column to an identity by using T-SQL and OVER clause

 

Relational model with invoices master-detailIf you have to change the type of a key column on SQL Server, and the new column type has to be integer, and even identity, you can do it by using some criteria in order to get the rows ordered (PK= index clustered= order by in physical disk by this column)..

We will change the type of the PK column of a table in a sample with 2 typical invoice tables master-detail where the key columns are nchar. 'invheader.invoiceid' is the primary key of the master table and 'invlines.lineid' is the primary key of the detail table..

 

How to access from SQL Server to MySQL databases

 

Connect SQL Server to MySQL with linked serverWe could need to access to MySQL from SQL Server.

An easy way to do it is creating a linked server that uses an ODBC connection..

 

Review "Learning Hadoop "

 
Learning Hadoop 2 book
With almost 350 pages, 'Learning Hadoop 2', I was very pleasantly surprised!
This is a book that chapter by chapter, provides a guide with the appropriate depth in the apprenticeship of this technology, which is today one of the most flourishing. It has a lot of examples that we can execute and analyze..

Data Science - Dynamic analysis on outliers with R

 

05_fractal_outliers_density.gif

The outliers, or extreme values, are a usual topic when analyzing data, regardless its data source. Here I present a didactic and visual approach on treating with them. R code is available to download.

Geo Data Science with R

 

Gap between healthy expectancyLiving longer, living better? 

Following analysis is made with R and the Google Vis library for plotting the interactive maps. 
It's equally important to measure the longer living as well as its quality..

Use SEMrush to win the battle to your competitors

 

Herramienta Semrush para análisis SEM y SEO

 

SEMrush is one of the best tools of SEM and SEO for marketing online professionals.

If you are a professional of online marketing, either offering services of SEM and SEO positioning to third parties, or belong to the marketing department of a company that invests in Adwords, I am convinced that after trying it you can't stop using it..

..

How to fix broken links with Semrush

 

The broken external links from our web is a major problem because, besides subtracting useful publication, depending on the importance of the external source to supplement the informations of our post, penalize post, and our domain if we have a lot of face to the search engines like Google.
As broken links without significant and is an easy thing to detect for any robot or spider, few SEO tools not report any broken links on our website when making our typical SEO site audit. In this post we will explain how to use the Semrush tool to detect and correct these broken links.

How to do competitive analysis and find the best keywords

 

Search keywords

Let's see how SEMrush, one of the tools SEO indispensable, can help us improve our SEO positioning allowing us to track the keywords which we are working and which are not and, more importantly, find out if those words are running our competition and whether they are highly sought words. So, with this competition analysis, we evaluate by what keywords we bet on our strategy of organic positioning, which is better rule, and how we should adapt our publications and organize your linking strategy, internal and external, to improve Any word positioning on search engines.

Angular — Directives: handling scope

 

AngularJS

When creating your directive you need to decide how are you going to handle scope. There are two options: isolated from the outside world, linked to the parent scope.

Interview with Matt Mayevsky, author of "The Clouds Economy"

 

Matt Mayevsky, author of Clouds EconomyThis time we interviewed Matt Mayevsky to explain to us in their own words what their Cloud Economics, objectives and motivations, the difficulties found along the way, and where it is headed 'The Clouds Economy' project ..

Syndicate content