Having all the R functions, all libraries and any kind of definitions (URL, links, working directories, environments, memory, etc) in one file is nothing new, but sometimes a lifesaver. Using R function source is the function to achieve this. Storing…
TomazTsql
Tomaz doing BI and DEV with SQL Server and R
Blog Archives
Running R scripts within in-database SQL Server Machine Learning
Tagged with: external data, external file, R, R script, source, sp_execute_external_script, SQL, SQL Server
Posted in Uncategorized
Posted in Uncategorized
First release and update dates of R Packages statistics
R has been around long time and the packages have evolved through the years as well. From the initial releases, updates, to new packages. Like many open-source and community driven languages, R is not an exception. And getting the first…
T-SQL job title generator
While writing a sample random function in using T-SQL Server, I have remembered, why not write a job title generator for T-SQL domain only. You might have seen so called bulls**t job title generator and similar, but this one is…
T-SQL date and time manipulation
Manipulating date and time in T-SQL is a daily and very common task that every DBA, SQL Developer, BI Developer and data scientist will come across. And over the years, I have accumulated many of the simple date or/and time…
Tagged with: cast, convert, data types, date, Microsoft, SQL Server, T-SQL, time
Posted in Uncategorized
Posted in Uncategorized
Top SQL Server bloggers of 2018
SQLShack community web-site by company ApexSQL have announced on 1st of September 2018 the list of SQL Server bloggers. The list of top SQL Server bloggers is absolutely worth checking for entry-level learning, for troubleshooting and for advanced topics. There…
SQL Server 2017 Machine Learning services with R book
Yes, I am finally blogging this. 🙂 This blog post is slighty different, since it brings you the tittle of the book, that my dear friend Julie Koesmarno (blog | twitter) and I have written in and it was published…
Tagged with: books, DBA, machine learning, Microsoft, Microsoft R Server, ML Services, MRAN, R, SQL Server, thoughts
Posted in Uncategorized
Posted in Uncategorized
Filling [propagading] empty values with last nonNull value using T-SQL
So you have NULL values in your SQL Server table and you want to populate those NULL values with the last non-NULL value, based on a particular order. Once you have only one NULL values encapsulated between two populated values,…
| Distilled News | Dat… on Running R scripts within in-da… | |
| Analyzing Update Dat… on First release and update dates… | |
 | TMW on T-SQL job title generator |
| Choose Your Next SQL… on T-SQL job title generator | |
 | suxstellino (Alessan… on T-SQL job title generator |
