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…
Blog Archives
Real-time data visualization using R and data extracting from SQL Server
In the previous post, I have showed how to visualize near real-time data using Python and Dash module. And it is time to see one of the many ways, how to do it in R. This time, I will not…
Tagged with: data analysis, environment, R, R Studio, real-time, SQL Server, Visualization
Posted in Uncategorized
Posted in Uncategorized
Real-time data visualization with SQL Server and Python Dash
The need for visualizing the real-time data (or near-real time) has been and still is a very important daily driver for many businesses. Microsoft SQL Server has many capabilities to visualize streaming data and this time, I will tackle this…
Tagged with: data stream, data wrangling, Python, real-time, SQL Server, Visualization
Posted in Uncategorized
Posted in Uncategorized
Using R in SQL Server Reporting Services (SSRS)
SQL Server Reporting services (SSRS) is an outstanding tool for creating, deploying and managing paginated, mobile, KPI reports as well as Power BI reports. Tool provides simple way to share and get data insights in your corporate environment. (Photo source:…
Tagged with: analytics, R, Reports, SQL Server, SSRS, statistics, Visualization
Posted in Uncategorized
Posted in Uncategorized
Animated barplot and google map with R
It might happen that you will need a animated graph of any kind. For purposes of plotting demographic data and changes through the years, Google Maps and plotting maps, merging and converting jpg files into a animated gif, sure will…
Clustering executed SQL Server queries using R as tool for
When query execution performance analysis is to be done, there are many ways to find which queries might cause any unwanted load or cause stall on the server. By encouraging DBA community to start practicing the advantage or R Language…
Tagged with: clustering, DBA, Query execution, R, SQL Server, SQL Server R Services, T-SQL, Visualization
Posted in Uncategorized
Posted in Uncategorized
R graphs and tables in Power BI Desktop
Power BI Desktop enable users to use R script visual for adding custom visualization generated with R language – regardless of R package used. Before using R script visual, you will need to enable it by setting path to R…
 | laresbernardo on LazyMouse – R package fo… |
| laresbernardo on LazyMouse – R package fo… |
| Randomly Moving the… on LazyMouse – R package fo… | |
| Advent of 2025, Day… on Advent of 2025, Day 23 – SQL S… | |
| Advent of 2025, Day… on Advent of 2025, Day 22 – SQL S… |
TomazTsql 