R programming

What is R?

R is statistical programming language created for developing and building enhanced analysis, visualization, data mining and so on,related with data. Includes a number of packages, and being open-source allows R to be accepted by many developers and statisticians.

R in rank

Last years its ranking is rising and after acquiring Revolution Analytics by Microsoft helped R to boost its popularity.Revolutionary Analytics (current name is Microsoft R)  is the statistical software company developed open source versions of R for each customer types.

KDnuggets 2014 poll


Storing and Querying XML Data in SQL Server

Using Transact-SQL for XML

Using mode queries in TSQL for XML allows server to convert result set to related XML formats.Four modes are available for this process:

  • RAW - converts each row and gives XML format related with each row, could get 'element' command
  • AUTO - same as RAW format, however has less flexibility
  • EXPLICIT - much more complexity in queries, PATH way is recommended
  • PATH - more flexibility and simplicity,used instead of previous mode
For more practice you can test it on Management Studio:


Microsoft Machine Learning

In December 2016 Microsoft R Server 9.0 was released, and several additional big-data tools and features have been upgraded with new version, including brand new R package for Machine Learning — Microsoft ML.To handle large corpus of text data and high-dimensional categorical data mentioned package has more functionality, from speed-performance and scalability aspect too.


Designing and implementing views

Reducing the complexity and facilitating the readability of queries are realizing by implementing views. Possible to name it as 'virtual table' too. From both performance and complexity aspects, it allows us to turn situation to an advantageous side. Let's look at where to use views:in calling the queries without any executing of table, in giving permission to any user to view specific column,data, in boosting the performance mainly.
From security aspect, let's assume that person A gives table permission to person B, except displaying employees' salary info.Here A prefer to create a view and grant B a permission to access just only view, not whole table.