Not always is the answer 42 as explained in Hitchhiker’s guide. Sometimes it is also 6174. Kaprekar number is one of those gems, that makes Mathematics fun. Indian recreational mathematician D.R.Kaprekar, found number 6174 – also known as Kaprekar constant…
TomazTsql
Tomaz doing BI and DEV with SQL Server and R, Python and beyond
Blog Archives
Installing R using Powershell
Installing R from scratch and creating your favorite IDE setup is especially useful when making fresh installation or when you are developing and testing out different versions. This blogpost will guide you through some essential steps (hopefully, there will not…
Window Aggregate operator in batch mode in SQL Server 2019
So this came as a surprise, when working on calculating simple statistics on my dataset, in particular min, max and median. First two are trivial. The last one was the one, that caught my attention. While finding the fastest way…
Tagged with: batch mode, execution plan, Python, Query execution, R, row mode, sp_execute_external_script, SQL Server, SQL Server 2019, window functions
Posted in Uncategorized
Posted in Uncategorized
Friday five MVP award blog post
Short blog post on contribution to Friday five MVP Award blog post from September 2018. Link to the blog: https://blogs.msdn.microsoft.com/mvpawardprogram/2018/09/28/friday-five-september-28/ Happy New Year 2019! See you in 2019.
Using Python with Microsoft Reporting Services (SSRS)
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…
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
 | Saul Salcedo on Real-time data visualization w… |
| Distilled News | Ana… on Installing R using Powers… | |
| Number 6174 or Kapre… on Number 6174 or Kaprekar consta… | |
 | tomaztsql on Working folders, logs and sess… |
| tomaztsql on Real-time data visualization w… |
