Blog Archives

SQL Server 2017 Machine Learning services with R book

Posted on August 6, 2018 by tomaztsql — 2 Comments

Yes, I am finally blogging this. 🙂 This blog post is slighty different, since it brings you the tittle of the book, that my dear friend Julie Koesmarno (blog | twitter) and I have written in and it was published…

Tagged with: books, DBA, machine learning, Microsoft, Microsoft R Server, ML Services, MRAN, R, SQL Server, thoughts
Posted in Uncategorized

Filling [propagading] empty values with last nonNull value using T-SQL

Posted on August 5, 2018 by tomaztsql — Leave a comment

So you have NULL values in your SQL Server table and you want to populate those NULL values with the last non-NULL value, based on a particular order. Once you have only one NULL values encapsulated between two populated values,…

Tagged with: Microsoft, query, SQL Server, T-SQL, tricks, window functions
Posted in Uncategorized

Real-time data visualization using R and data extracting from SQL Server

Posted on July 23, 2018 by tomaztsql — 3 Comments

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

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

Posted on July 15, 2018 by tomaztsql — 5 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

R null values: NULL, NA, NaN, Inf

Posted on July 4, 2018 by tomaztsql — 5 Comments

R language supports several null-able values and it is relatively important to understand how these values behave, when making data pre-processing and data munging. In general, R supports: NULL NA NaN Inf / -Inf NULL is an object and is…

Tagged with: CSV, Data import, data types, import CSV, NA, NULL, R, SQL Server
Posted in Uncategorized

Connecting Azure Machine Learning studio with on-premises SQL Database

Posted on June 29, 2018 by tomaztsql — Leave a comment

Azure Machine Learning Studio has been around for the past 3 years and a lot of new features have been added. I am positive, many more will follow. One of more thrilling features has been the ability to connect to…

Tagged with: Azure, Gateways, Machine Learning Studio, Microsoft, ML Studio, SQL Server
Posted in Uncategorized

Real-time data visualization with SQL Server and Python Dash

Posted on June 18, 2018 by tomaztsql — 3 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 graphs and tables… on R graphs and tables in Power B…
	SQL Server 2017 Mach… on SQL Server 2017 Machine Learni…
	SQL Server 2017 Mach… on SQL Server 2017 Machine Learni…
	AI, Machine Learning… on Using Python Pandas dataframe…
	AI, Machine Learning… on Using Python Pandas dataframe…