Tomaz Kastrun @tomaztsql - Bluesky Profile

Little useless-useful R functions – Absurd bias DAG with useless mental shortcuts Exploring graphs is always a fun. Attaching the edges and nodes with real examples of psychological effects and accompany them with useless mental shortcuts is beyond fun. This is why we will call it a "cognitive bias" explorer using DAG. Here are the graphs edges and nodes and we are calling them biases and weird links. Because, yes 🙂 Let's mix the math with psychology.

Little useless-useful R functions – Absurd bias DAG with useless mental shortcuts

Exploring graphs is always a fun. Attaching the edges and nodes with real examples of psychological effects and accompany them with useless mental shortcuts is beyond fun. This is why we will call it a "cognitive…

25.05.2025 18:29 — 👍 0 🔁 0 💬 0 📌 0

💻⚡️ Old-school commands, brand-new muscle! Watch #MicrosoftFabric CLI crush clicks and super-charge Power BI now

👉 guyinacu.be/fabriccli #PowerBI #DataOps

21.05.2025 15:15 — 👍 4 🔁 3 💬 0 📌 0

Announcing SQL Server 2025 (preview): The AI-ready enterprise database from ground to cloud - Microsoft SQL Server Blog Announcing SQL Server 2025—empowering customers to develop modern AI applications securely using their data, complete with best-in-class security, performance, and availability.

SQL Server 2025 is in public preview! Yeees!!!
www.microsoft.com/en-us/sql-se...

22.05.2025 03:03 — 👍 2 🔁 0 💬 0 📌 0

Here is a tariff that might help the economy.
Put tariff on exporting data to excel. 😂

14.04.2025 05:47 — 👍 2 🔁 0 💬 0 📌 0

DataSaturday Pordenone 2025

22.02.2025 08:21 — 👍 2 🔁 0 💬 0 📌 0

🎉It's Fabric February week!🎉

I'm speaking at #FabricFebruary on Thursday the 6th Feb. I'll be exploring the how, why, and when you should bring #MicrosoftFabric and #Databricks together...and the answer isn't just "it depends"...promise!

Check the full agenda at fabricfebruary.com

03.02.2025 10:44 — 👍 9 🔁 4 💬 0 📌 0

Replication backward compatibility - SQL Server Review these resources for backward compatibility in replication before you upgrade or if you have several versions of SQL Server in a replication topology.

[docs] Updated your favorite Transactional Replication version compatibility with the details on compatibility with #Azure #SQLDB & #Azure #SQLMI (all update policies):
Kudos to @sasapopovicsql.bsky.social and team:
learn.microsoft.com/en-us/sql/re...
#azuresql #sqldb #sqlmi #replication

04.02.2025 12:04 — 👍 3 🔁 2 💬 0 📌 0

DeepSeek R1 on Azure AI Foundry Starting with the end of January 2025, DeepSeek R1 model has had a huge impact on how the AI community, developers and general public see Generative Models. Not only that is free (as of writing this blog post), but the refinement of the information made it possible, that the models are smaller than original GPT-4 and similar. Benefiting in smaller costs for training, running and improving reasoning.

DeepSeek R1 on Azure AI Foundry

Starting with the end of January 2025, DeepSeek R1 model has had a huge impact on how the AI community, developers and general public see Generative Models. Not only that is free (as of writing this blog post), but the refinement of the information made it possible,…

02.02.2025 10:01 — 👍 0 🔁 0 💬 0 📌 0

Ben & @wstrasser.bsky.social kicking off #DataCommunityAustria Day

24.01.2025 08:04 — 👍 12 🔁 1 💬 3 📌 0

Today is #DataCommunityDayAustria! I'm having the pleasure to present my #UnitTesting for #Databases session for the first time in less than 1 hour, join me in the Symphonia room at 9:15AM

24.01.2025 07:20 — 👍 4 🔁 2 💬 1 📌 0

09.01.2025 06:56 — 👍 5 🔁 0 💬 0 📌 0

08.01.2025 07:09 — 👍 0 🔁 0 💬 0 📌 0

Little useless-useful R functions – QR-Code Clock Ever wanted to have a clock on the wall or in the office, that is not binary. But it is QR-Code clock 🙂 Well, now you can have it. This useless R function generates new QR Code for every given period and tells the time. Run this function: library(qrcode) while (Sys.time()+1 > Sys.time()){ n_o_w <- paste0("Current time is ",as.character(format(Sys.time(), "%X"))) print(n_o_w) qr_code(n_o_w, ecl = "M" ) |> plot() Sys.sleep(10) }

Little useless-useful R functions – QR-Code Clock

Ever wanted to have a clock on the wall or in the office, that is not binary. But it is QR-Code clock 🙂 Well, now you can have it. This useless R function generates new QR Code for every given period and tells the time. Run this function:…

08.01.2025 06:15 — 👍 0 🔁 0 💬 0 📌 1

Little useless-useful R functions – Vanishing sentences Let’s play with some words. More in particular with vanishing words. Using two packages: ggplot2 and gganimate we will construct a animation (looped), where sentences will be vanishing, word by word. A nice way to train the ggplot animations. The function is combination of data frame wrangling and visualizations: vanishing_sentence <- function(sentence, output_file = NULL, interval = 0.5) { words <- unlist(strsplit(sentence, " ")) vanishing_order <- sample(seq_along(words)) sentence_data <- data.frame( word = words, position = seq_along(words), vanish_step = match(seq_along(words), vanishing_order) ) # sequence animation_data <- do.call(rbind, lapply(1:(max(sentence_data$vanish_step) + 1), function(step) { sentence_data %>% mutate(visible = ifelse(vanish_step >= step, TRUE, FALSE)) %>% group_by(position) %>% summarize(word = ifelse(visible, word, ""), .groups = "drop") %>% mutate(step = step) })) p <- ggplot(animation_data, aes(x = position, y = 1, label = word)) + geom_text(size = 6, hjust = 0.5, vjust = 0.5, fontface = "bold") + theme_void() + theme( plot.margin = margin(1, 1, 1, 1, "cm"), plot.background = element_rect(fill = "white", color = NA) ) + transition_states(step, transition_length = interval,state_length = 1) + enter_fade() + exit_fade() + ease_aes("linear") # render and save if (!is.null(output_file)) { anim <- animate( p,nframes = length(words) + 10, fps = 10,width = 800,height = 400, renderer = gifski_renderer(output_file) ) return(anim) } else { animate( p, nframes = length(words) + 10, fps = 10, width = 800, height = 400 ) } }

Little useless-useful R functions – Vanishing sentences

Let’s play with some words. More in particular with vanishing words. Using two packages: ggplot2 and gganimate we will construct a animation (looped), where sentences will be vanishing, word by word. A nice way to train the ggplot animations.…

06.01.2025 13:28 — 👍 0 🔁 0 💬 0 📌 0

Cleopatra lived closer in time to 'yeet' being in the dictionary than to the construction of the Great Pyramid of Giza.

05.01.2025 01:55 — 👍 7835 🔁 1774 💬 96 📌 161

OCD for everyone 🫣

04.01.2025 07:49 — 👍 1 🔁 0 💬 0 📌 0

2025 is interesting number!

20² + 25² = 2025
5² * 9² = 2025
1³ + 2³ + 3³ + 4³ + 5³ + 6³ + 7³ + 8³ + 9³ = 2025
(1 + 2 + 3 + 4 + 5 + 6 + 7 + 8 + 9) ² = 2025

#math #numbers

01.01.2025 14:09 — 👍 2 🔁 0 💬 1 📌 0

#DataWeekender 7.0: Call for Speakers Data Community Weekender is a free online conference running on Saturday March, 1st 2025 for the Microsoft Data Platform Community.Our main organizati...

Happy New Year #sqlfamily 💛 we are kicking off 2025 with a call for speakers for our 7th event which will take place on 1st March. There will only be three tracks this time each with a dedicated topic:

- #MicrosoftFabric
- #PowerBI
- #SqlServer

sessionize.com/dataweekende...

#DataWeekender #CFS

01.01.2025 14:03 — 👍 12 🔁 6 💬 0 📌 0

Some of the more useful Tidyverse functions R functions for every data engineer using Tidyverse Tidyverse has long been an amazing collection of R packages, primarily for data engineering and data science. Common among these packages is the same language grammar, great design and structure, making data science easier. Motivation Data engineering is important step that helps improve data usability, data exploration and data science. Preparing the data needs therefore needs to be done in a manner, that is easy to read, repeat and exchange between others engineers.

Some of the more useful Tidyverse functions

R functions for every data engineer using Tidyverse Tidyverse has long been an amazing collection of R packages, primarily for data engineering and data science. Common among these packages is the same language grammar, great design and structure, making…

01.01.2025 08:18 — 👍 0 🔁 0 💬 0 📌 0

Advent of Code 2024

I just completed all 25 days of Advent of Code 2024! #AdventOfCode adventofcode.com

25.12.2024 08:49 — 👍 1 🔁 0 💬 0 📌 0

Day 25 - Advent of Code 2024

I've completed Part One of "Code Chronicle" - Day 25 - Advent of Code 2024 #AdventOfCode adventofcode.com/2024/day/25

25.12.2024 06:50 — 👍 1 🔁 0 💬 0 📌 0

Day 24 - Advent of Code 2024

I've completed Part One of "Crossed Wires" - Day 24 - Advent of Code 2024 #AdventOfCode adventofcode.com/2024/day/24

Doors with Franz Kafka!

24.12.2024 16:05 — 👍 1 🔁 0 💬 0 📌 0

Day 22 - Advent of Code 2024

I just completed "Monkey Market" - Day 22 - Advent of Code 2024 #AdventOfCode adventofcode.com/2024/day/22
Part 2 got me thinking :)

22.12.2024 19:32 — 👍 3 🔁 0 💬 0 📌 0

Interviewer: Can you explain this gap in your resume?

Me, crying: No, I just git-merged wrong branch.

22.12.2024 06:22 — 👍 2 🔁 0 💬 0 📌 0

Day 21 - Advent of Code 2024

I just completed "Keypad Conundrum" - Day 21 - Advent of Code 2024 #AdventOfCode adventofcode.com/2024/day/21

aaaaa....I lost my coool with day 21

21.12.2024 09:01 — 👍 3 🔁 0 💬 0 📌 0

Day 20 - Advent of Code 2024

I've completed "Race Condition" - Day 20 - Advent of Code 2024 #AdventOfCode adventofcode.com/2024/day/20

20.12.2024 19:24 — 👍 1 🔁 0 💬 0 📌 0

NIce :D :D :D

20.12.2024 16:03 — 👍 1 🔁 0 💬 0 📌 0

Day 19 - Advent of Code 2024

I just completed "Linen Layout" - Day 19 - Advent of Code 2024 #AdventOfCode adventofcode.com/2024/day/19

20.12.2024 16:02 — 👍 2 🔁 0 💬 0 📌 0

Tomaz Kastrun

Latest posts by tomaztsql.bsky.social on Bluesky

@tomaztsql is following 20 prominent accounts