This blog post is long over due and has been rattling in my head for long time. Simply and boldly put it, community is everyone involved behind the result of your search for a particular problem. And by that I…
Blog Archives
What and who is IT community? What does it take to be part?
Tagged with: articles, Azure, blog, books, community, Powershell, Python, R, SQL Server
Posted in Uncategorized
Posted in Uncategorized
Python Pandas MultiIndex and reading data from SQL Server
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
Posted in Uncategorized
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
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…
Using Python Pandas dataframe to read and insert data to Microsoft SQL Server
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
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
R or Python? Python or R? The ongoing debate.
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…
 | Tommy G Bolling on Installing SSIS, SSRS and SSAS… |
 | windows7bugs on Installing SSIS, SSRS and SSAS… |
 | Juan Andres Mercado on Installing SSIS, SSRS and SSAS… |
| Important checklist… on Essential list of useful R pac… | |
 | Holger K. von Jouann… on Essential list of useful R pac… |
