UTF-8 Support in SQL Server 2019

UTF-8 has been the predominant character encoding system for the world-wide web since 2009 and as of October 2018 accounts for over 90% of all web pages. As of October 2018, UTF-8 is not supported by Microsoft SQL Server. SQL Server 2019 will remedy this situation, as current SQL Server community technology previews illustrate. The […]
Read More ›

Your Linear Regression Need Not Be Linear

Anyone who has ever done a linear regression in R has seen an R formula. R formulae are examples of the Wilkinson notation, sometimes called the Wilkinson-Rogers notation. This same notation is used by other applications including Matlab and Octave to indicate relationships between variables. In most cases, R users have seen the Wilkinson notation […]
Read More ›

Using .RProfile to Customize your R Environment

When R starts up, it looks for several files to initialize its configuration. R has its own configuration file called Rprofile.site located in the /etc folder. It is probably wise not to mess with this file unless you are very confident in your understanding. Most R users are aware that during startup, R reads an […]
Read More ›

Preparing SQL Data for R Visualizations Using Power Query Pivot

The Data Frame The fundamental data structure used by the majority of R functions and packages is the data frame. In a data frame, sets of related values constitute rows, while an individual column vector in a data frame contains comparable measures that can be summed, averaged, or subjected to any number of numerical manipulations. […]
Read More ›

Artificial vs Surrogate Keys

Shakespeare famously asked “What’s in a name?” A great deal, as it turns out, since the words used to describe things affects how we perceive them and think about them. Perhaps it’s the rapid rate of change that makes technology particularly susceptible to the effects of how we use words to describe things. Terms too […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.