Tag: SQL

Feed: R-bloggers. Author: Posts on R Lover ! a programmer. So, a programmer, a frequentist, and a bayesian walk into a bar. No this postisn’t really on the path to some politically incorrect stereotypical humor. Juttrying to make it fun and catch your attention. As the title implies this postis really about applying the differing viewpoints and methodologies inherent inthose approaches to statistics. To be honest I’m not even going to spend a lottime on the details of methods, I want to focus on the conclusions each of thesepeople would draw after analyzing the same data using their favored methods.This ... Read More

Feed: R-bloggers. Author: R Views. Andrie de Vries is the author of “R for Dummies” and a Solutions Engineer at RStudio Phillip (Armand) Bester is a medical scientist, researcher, and lecturer at the Division of Virology, University of the Free State, and National Health Laboratory Service (NHLS), Bloemfontein, South Africa In this post we complete our series on analysing the HIV pandemic in Africa. Previously we covered the bigger picture of HIV infection in Africa, and a pipeline for drug resistance testing of samples in the lab. Then, in part 3 we saw that sometimes the same patient’s genotype must ... Read More

Feed: R-bloggers. Author: . As I was preparing some graphics for a presentation recently, I started digging into some of the different color palette options. My motivation was entirely about creating graphics that weren’t too visually overwhelming, which I found the default “rainbow” palette to be. But as the creators of the viridis R package point out, we also need to think about how people with colorblindness might struggle with understanding graphics. If you create figures in R, I highly recommend checking it out at the link above! To leave a comment for the author, please follow the link and ... Read More

Feed: R-bloggers. Author: chris2016. Principal component analysis (PCA) is very useful for doing some basic quality control (e.g. looking for batch effects) and assessment of how the data is distributed (e.g. finding outliers). A straightforward way is to make your own wrapper function for prcomp and ggplot2, another way is to use the one that comes with M3C (https://bioconductor.org/packages/devel/bioc/html/M3C.html) or another package. M3C is a consensus clustering tool that makes some major modifications to the Monti et al. (2003) algorithm so that it behaves better, it also provides functions for data visualisation. Let’s have a go on an example cancer ... Read More

Feed: R-bloggers. Author: Colin Fay. How to build a CLI for R, with npm. Background This blog post was triggered by a discussion on Twitter with MartinSkarzynski,who was looking for a way to build a CLI that launches an RScript.Here’s a way to do this using npm. Please note that this blog post won’t teach you how to build the commandline tool, it will quickly go over the way to create a system-widecommand line interface, using npm. If you want to learn more about building the utility, see thisfantastic series of blogpostsby Mark Sellor. Now, the idea is to have ... Read More

Feed: Recent Announcements. The SQL Server Multi-AZ deployment option offers you an easier and more effective way to design and operate applications and databases, making them more available, fault tolerant, and scalable than traditional single datacenter infrastructures or multi-datacenter infrastructures. When you create your SQL Server database instance to run using Multi-AZ on SQL Server 2016 or 2017 latest minor versions for the Enterprise Edition database engine, Amazon RDS will automatically provision a primary database in one Availability Zone and maintain a synchronous "standby" replica in a different Availability Zone using Always On Availability Groups. If you are modifying an ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Vivek Raju. By Kautham Dhanasekaran, Solutions Architect at Tech MahindraBy Saurabh Shrivastava, Partner Solutions Architect at AWSBy Vivek Raju, Manager, Global Integrator SA at AWSAs cloud becomes the new normal, many businesses want to use its potential to improve their customer experience. Amazon Web Services (AWS) helps businesses migrate to the cloud and provides best practices for the modernization of their applications. Organizations all around the world are using the breadth and depth of AWS services to become more cloud-native. Telia used the AWS platform to modernize their customer information management (CIM) platform ... Read More

Feed: Planet MySQL; Author: EverSQL; I recently stumbled upon a very interesting post by Lukas Eder, where he describes 10 query transformations which do not depend on the database’s cost model. He posted it a couple of years ago, though when I read it, I assumed some portions of it may still be relevant today. In the original post, several databases were tested to see if their internal optimizer will be able to automatically re-write the SQL queries and optimize them. In those tests, MySQL under-performed in several of the use cases (the tested version was MySQL 8.0.2, which was ... Read More

Feed: R-bloggers. Author: melliferrari. Learn to experiment with R to make analyses and figures more reproducible If you’re in the UK and not too far from York you might be interested in a Royal Society of Biology course which forms part of the Industry Skills Certificate. More details at this link Introduction to Reproducible Analyses in R 24 June 2019 from 10:00 until 16:00 The course is aimed at researchers at all stages of their careers interested in experimenting with R to make their analyses and figures more reproducible. No previous coding experience is assumed and you can work on your own ... Read More

Feed: R-bloggers. Author: Laura Swales. Julia Silge is joining us as one of our keynote speakers at EARL London 2019. We can’t wait to hear Julia’s full keynote, but until then she kindly answered a few questions. Julia shared with us what we can expect from her address – which will focus on how Stack Overflow uses R and their recent developer survey. Hi Julia! Tell us about the StackOverflow Developer Survey and your role at Stack Overflow The Stack Overflow Developer Survey is the largest and most comprehensive survey of people who code around the world each year. This ... Read More