Blog Archives

Python Pandas MultiIndex and reading data from SQL Server

Posted on June 26, 2019 by tomaztsql — 1 Comment

Python Pandas multiIndex is a hierarchical indexing over multiple tuples or arrays of data, enabling advanced dataframe wrangling and analysis on higher data dimensionality. Everyone have had come across multiIndex in Python Pandas and had little annoyancens as the first…

Tagged with: multi index, multiIndex, pandas, Python, Python Pandas, reading, sp_execute_external_script, SQL Server
Posted in Uncategorized

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 — 13 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 — 10 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

	DAX Time Functions… on Time functions in DAX
	Advent of Code 2019… on Advent of Code 2019 challenge…
	Hangman game with R… on Hangman game with R
	Hangman game with R… on Hangman game with R
	Rob Pattyn on Installing SSIS, SSRS and SSAS…