Small project database, with old backup, ended up in corrupt state. This happened. A corrupted database; all-in-all 150MB. I was super annoyed. Let alone, I had some R and Python code there and some – yes 🙂 – predictive models,…
TomazTsql
Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond
Blog Archives
My MSSQL database is corrupt and I can not get to my predictive models. Now what? Stellar to the rescue.
Tagged with: corrupted database, database, Microsoft, MSSQL, R models, sp_execute_external_script, SQL Server, stellar, T-SQL
Posted in Uncategorized
Posted in Uncategorized
Sudoku game with R
Sudoku is a classical logical game based on combinatorial number replacement puzzle. Objective is to to fill 9×9 matrix with digits so that each column, each row, and each box (3×3 sub-grid) of nine contain all of the digits from…
Working with Windows CMD system commands in R
From time to time, when developing in R, working and wrangling data , preparing for machine learning projects, it comes the time, one would still need to access the operating system commands from/in R. In this blog post, let’s take…
Tagged with: cmd, file compare, file copy, file rename, ipconfig, R, R.version, shell, sys.info, sys.which, System, system commands, system2, systeminfo, tasklist, tibble
Posted in Uncategorized
Posted in Uncategorized
Custom Power BI filter pane with hide/show feature
Having as much possible Power BI estate when it comes to putting the visuals for data exploration, is everyone’s dream. But the slicers for “slicing and dicing” the data is also very important. Having all the slicers hidden has always…
Tagged with: custom filter, DAX, diamonds dataset, filter, filter pane, Power BI, show / hide, Visualization
Posted in Uncategorized
Posted in Uncategorized
Time functions in DAX
Time functions in DAX are besides simple calculation functions, the most useful functions; mainly because time slicers are one of the most frequently used slicers in Power BI. New functions are coming to DAX (Data Analysis Expression Language) regularly, and…
Advent of Code 2019 challenge with R
I have decided to tackle this year’s Advent Of Code using R (more or less). I know there are more preferred languages, such as Python, C#, Java, JavaScript, Go, Kotlin, C++, Elixir, but it was worth trying. Into the 8th…
November 2019 update and decomposition tree
I am super excited about all the new features that November 2019 update brought to Power BI Desktop. Complete list is here. Great new visual for all the data analysts is: decomposition tree. To enable the decomposition tree, navigate to…
Tagged with: AdventureWorks, Decomposition tree, features, Power BI, Power BI Desktop, Visualization
Posted in Uncategorized
Posted in Uncategorized
 | tomaztsql on Sudoku game with R |
 | Bill Venables on Sudoku game with R |
| tomaztsql on Sudoku game with R |
| Solving Sudoku with… on Sudoku game with R | |
| Bill Venables on Sudoku game with R |
