Using Python with SQL Server 2017 SSRS should not be an obstacle, since the framework and the technology is the same as with R language. With SQL Server 2017, Python got a full and functional support for native SSRS. The…
TomazTsql
Tomaz doing BI and DEV with SQL Server and R
Blog Archives
SQL Saturday Slovenia 2018
SQL Saturday Slovenia 2018 is coming back in town. And it will be, as always, awesome. I prefer not to use superlatives, but the schedule speaks for it self. The event will take place on Saturday, 8th December 2018, at the…
Running R scripts within in-database SQL Server Machine Learning
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…
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…
 | ankit on Using Python Pandas dataframe… |
| Enabling R Scripts i… on Playing with Regression predic… | |
 | Jared Prins on Running R scripts within in-da… |
| Python In SQL Server… on Using Python with Microsoft Re… | |
| SQL Server: Using R… on Using R sp_execute_external_sc… |
