sql
Posts featuring SQL or SQL Server
Exploring your database with shiny
Programatically querying a database with flexible SQL queries and visualising the results with shiny. Continue reading Exploring your database with shiny
Iterating over multiple database tables with the tidyverse
Extracting data from multiple database tables with dplyr and purrr. Continue reading Iterating over multiple database tables with the tidyverse
Dynamic SQL queries with R
Programmatic querying with dynamic schema, table and column names. Continue reading Dynamic SQL queries with R
Separate SQL
Why you should consider keeping your SQL queries in a separate file. Continue reading Separate SQL
Passing parameters to SQL Server functions using R
Using interpolation to parameterise an input into the SQL Server DATEADD function, via R. Useful when you want to pass a variable somewhere deep inside your SQL query Continue reading Passing parameters to SQL Server functions using R
Even Simpler SQL
A follow up post, with improved SQL and dplyr code Continue reading Even Simpler SQL
simpler SQL with dplyr
comparing dplyr with SQL nested queries - and there is only one winner Continue reading simpler SQL with dplyr