What I have read, heard or seen on 2016-12-13. A nice T-SQl piece of code to split a string with FTparser in SQL Server 2008+: Split string with sys.dm_fts_parser Also, I learned how to read data from SQL Server into RMarkdown: library(RODBC) cn <- odbcDriverConnect(connection="Driver={SQL Server};server=.;database=test;trusted_connection=yes;") ## Warning in odbcDriverConnect(connection = "Driver={SQL ## Server};server=.;database=test;trusted_connection=yes;"): [RODBC] ERROR: ## state 08001, code 17, message [Microsoft][ODBC SQL Server Driver][Shared ## Memory]SQL Server does not exist or access denied. ## Warning in odbcDriverConnect(connection = "Driver={SQL ## Server};server=.;database=test;trusted_connection=yes;"): [RODBC] ERROR: ## state 01000, code 2, message [Microsoft][ODBC SQL Server Driver][Shared ## Memory]ConnectionOpen (Connect()). ## Warning in odbcDriverConnect(connection = "Driver={SQL ## Server};server=.;database=test;trusted_connection=yes;"): ODBC connection ## failed myQuery <- sqlQuery(cn, "SELECT * FROM MyTable ") ## Error in sqlQuery(cn, "SELECT * FROM MyTable "): first argument is not an open RODBC channel myQuery ## Error in eval(expr, envir, enclos): object 'myQuery' not found Written on December 13, 2016