Skip to content

Tag: guides

Table formatting for PDF

September 28, 2018 by edpflager

Using R Markdown to create PDF files for sharing, you can chose several different options for printing tables of data: default, kable and tibble. If you are using HTML, you have another option called paged, which allows you to specify the number of rows and columns to display, and the viewer can page between pages …

Continue Reading

Font Formatting – Typefaces

September 28, 2018 by edpflager

First a little background – I’ve been working with R – the free open source statistical computing and graphics software for about a year, exploring various libraries and add-ons, trying to get a better understanding of it. This was spurred on by a couple of things. First, in SQL Server 2016, Microsoft incorporated R into …

Continue Reading

NAT:HNS error with Docker SQL Server container on Windows10

July 20, 2018 by edpflager

As with many things I post here, this article was the result of a problem I encountered, and how to resolve or work around it. I have been working with Docker on Windows and was attempting to run a container provided by Microsoft that included SQL Server. The process is fairly easy, just pull the …

Continue Reading

Running Kettle (Pentaho Data Integration) on Mac OSX 10.12 Sierra

July 20, 2018 by edpflager

A new version of Mac OSX and a new version of Pentaho Data Integration (aka Kettle) but the same old problem getting Kettle to run. Apple tries to keep their operating system locked down and secure, so if you download applications from the Internet that aren’t from the Apple App Store, the files are quarantined. …

Continue Reading

Use Linux SQL Server with R (ODBC)

July 20, 2018 by edpflager

This is my second article on using Microsoft’s new Linux version of SQL Server with R. This time, I’ll cover how to use RODBC to gather data from SQL Server. As a bit of background, over the past few months, I have been working to learn R, a free software environment for statistical computing. Its been …

Continue Reading

Use Linux SQL Server with R (JDBC)

July 20, 2018 by edpflager

Over the past few months, I have been working to learn R, a free software environment for statistical computing. Its been gaining popularity over the past few years, and Microsoft just gave it a huge boost by integrating R into their Power BI visualization software and the Windows version of SQL Server 2016. Since a …

Continue Reading

Posts navigation

  • Previous
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • Next

Recent Posts

  • Diagram SQL Server Graph Databases in R – Part 4
  • Diagram SQL Server Graph Databases in R – Part 3
  • Diagram SQL Server Graph Databases in R – Part 2.5
  • Diagram SQL Server Graph Databases in R – Part 2
  • Diagram SQL Server Graph Databases in R – Part 1

Categories

Archives

RSS BI news

  • Query Generation in R
  • Verbose data.table and uncovering hidden cedta’s data table awareness decisions
  • Weather Forecast from MET Office
  • Geocoding function
  • Take 4+: Presentations on ‘Elements of Neural Networks and Deep Learning’ – Parts 1-8

RSS R related news

  • Query Generation in R
  • Visualizing Language Loss in Taiwan: Create an “Age-Sex Pyramid of Language” with ggplot2
  • Verbose data.table and uncovering hidden cedta’s data table awareness decisions
  • Weather Forecast from MET Office
  • Geocoding function

Tags

Ambassador Bridge Big Data CDH centos Cloudera cookbook Docker ETL external article goofy graph database guides Hadoop HortonWorks How-to howto HUE humor impala inspiration install kettle LaTax LDAP Linux Mac metadata Mint MySQL nat: HNS failed nginx PDI Pentaho photogs R R Markdown RStudio rvest SQL Server SysAdmin technical Ubuntu Windows Windsor YARN
© 2019 | WordPress Theme by Superbthemes