New Improved SQL Server 2019! Now with more Spark!
May 8,
2019
If your server racks are anything like mine, they look impressive and powerful, clean and efficient. From the front, that is. Look behind the rack and there is a tangled rat’s nest of power cables, network connections, and those big clumsy things connecting to KVM switches. It’s worse on the inside. Data platforms and software […]
Power BI: How to Save Memory for Better Performance
Apr 24,
2019
The tabular mode data storage used by Power BI, Power Pivot, and the SQL Server Analysis Services thrives on sufficient memory. Take away memory and performance plummets. You may be wasting memory and thus performance if you do not take advantage of opportunities to trim excess fat when you are first importing your data. And, […]
Turning Your AzureML Experiment into a Web Service
Apr 16,
2019
Great! You’ve created a promising machine learning model using AzureML Studio. How do you make it available to colleagues for practical use? In Microsoft-speak, how do you “operationalize” it? The AzureML Studio makes it very easy to convert an existing experiment into an Azure web service that can be accessed from any application that supports […]
Your Linear Regression Need Not Be Linear
Jan 31,
2019
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 […]
Using .RProfile to Customize your R Environment
Jan 22,
2019
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 […]
