Category Archives: SQL

SSMS – How to Start SQL?

Posted on April 11, 2017 by huiyuqian

SSMS stands for SQL Server Management Studio, which is a Microsoft product. SQL stands for Structured Query Language. Here we will summarize the basics on how to start using SSMS or write SQL queries. have SSMS installed have access and … Continue reading →

Posted in SQL | Tagged , , | Leave a comment

Import SQL Server Data to R

Posted on January 7, 2015 by huiyuqian

Before starting importing the data to R, we may first check if our R version and packages are most recent. R-Statistics blog have a very nice post on how to update R on Windows by using “installr” package: http://www.r-statistics.com/2013/03/updating-r-from-r-on-windows-using-the-installr-package/ Run … Continue reading →

Posted in R, SQL | Tagged , , , | Leave a comment

MS SQL Installation & Count Direct/Indirect Reporters for Each Manager

Posted on June 29, 2014 by huiyuqian

SAS was the main language I used for programming in recent years. It is fine to use  DATA steps and/or PROCs, especially PROC SQL for data manipulation with SAS. However, MySQL/Oracle SQL/MS SQL has been something I would like to … Continue reading →

Posted in SQL | Tagged , | 1 Comment