Blog Archives

Window Aggregate operator in batch mode in SQL Server 2019

Posted on January 18, 2019 by tomaztsql — 2 Comments

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…

Using Python with Microsoft Reporting Services (SSRS)

Posted on November 19, 2018 by tomaztsql — 1 Comment

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…

Tagged with: data analysis, prediction, Python, SSRS, Visualization
Posted in Uncategorized

Using Python Pandas dataframe to read and insert data to Microsoft SQL Server

Posted on July 15, 2018 by tomaztsql — 7 Comments

In the SQL Server Management Studio (SSMS), the ease of using external procedure sp_execute_external_script has been (and still will be) discussed many times. But the reason for this short blog post is the fact that, changing Python environments using Conda…

Tagged with: data analysis, dataframe, Microsoft, pandas, Python, sp_execute_external_script, SQL Server
Posted in Uncategorized

Real-time data visualization with SQL Server and Python Dash

Posted on June 18, 2018 by tomaztsql — 7 Comments

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

R or Python? Python or R? The ongoing debate.

Posted on January 28, 2018 by tomaztsql — 9 Comments

On every SQL community event, where there could be a cluster of sessions dedicated to BI or analytics, I would have people asking me, “which one would you recommend?” or “which one I prefer?” So, questions about recommendation and preferences…

Tagged with: Python, R, statistics, thoughts
Posted in Uncategorized

SQL Saturday statistics – Web Scraping with R and SQL Server

Posted on November 13, 2017 by tomaztsql — 5 Comments

I wanted to check a simple query: How many times has a particular topic been presented and from how many different presenters. Sounds interesting, tackling the problem should not be a problem, just that the end numbers may vary, since…

Tagged with: Microsoft, Python, R, SQL Server, SQL Server R Services, SQLSaturday, statistics, T-SQL, web scrape
Posted in Uncategorized

Robust IRIS Dataset?

Posted on October 25, 2017 by tomaztsql — 3 Comments

This blog post was born out of pure curiosity about the robustness of the IRIS Dataset. Biological datasets do not need to be that big in comparison to datasets of customers, consumption, stock and anything that might be volatile. When…

Tagged with: Iris Dataset, Python, R, SQL Server, SQL Server R Services
Posted in Uncategorized

	Number 6174 or Kapre… on Number 6174 or Kaprekar consta…
	tomaztsql on Working folders, logs and sess…
	tomaztsql on Real-time data visualization w…
	Saul Salcedo on Real-time data visualization w…
	Installing R using P… on Installing R using Powers…