Tomaz Kastrun tomaztsql - Bluesky Statics

Little useless-useful R functions – Typing speed benchmark Did you ever wonder how fast and with accuracy your typing is? For this instance, we will introduce some random pangrams, code samples and random strings sotrted by level of difficulty. # list of phrases is generated with the help of LLM. Because ..lazy!!!! phrases_db <- list( pangram = list( easy = c( "The quick brown fox jumps over the lazy dog", "Pack my box with five dozen liquor jugs", "How vexingly quick daft zebras jump", "The five boxing wizards jump quickly", "Sphinx of black quartz judge my vow" ), medium = c( "The quick brown fox jumps over the lazy dog while the cat watches", "A wizard's job is to vex chumps quickly in fog with zebra tricks", "Crazy Frederick bought many very exquisite opal jewels last week", "We promptly judged antique ivory buckles for the next prize winner", "Six big devils from Japan quickly forgot how to waltz in my room" ), hard = c( "The job requires extra pluck and zeal from every young wage earner, quickly!", "Grumpy wizards make a toxic brew for the jovial queen who lives in a palace", "Back in June we delivered oxygen equipment of the same size to a new complex", "A quivering Texas zombie fought republic linked jewelry and quartz watches", "The explorer was frozen in his survey before he made a quartz and jade box" ) ), pangram_slo = list( easy = c( "Škrbast mož fizično dviguje hlapca", "Iščem vzdolžen grb ptujskih fac", "Črn šef Gambijk hupa vzdolž cest" ), medium =c( "Ščepec soli fajn zažge tobak v sodih ruma", "Cagav bledoličnež nima škafa za prst juhe", "Vzdržljivi fant mečka gobec hišnemu psu" ), hard = c( "Škodoželjno ga je zafrknil - ni mu pustil več hlebca", "Majceni krastači vrh polža se gabi študij fizike", "Prgišče klofute včasih bolj zaleže od močne brce", "Pretkani gofljač razmišlja o zgodbicah sužnjev", "Fantu, ki je zbrcal špičasto mevžo, hudo grozijo" ) ), rstats = list( easy = c( "The mean is sensitive to outliers", "Always visualize your data first", "Check for missing values early", "The sample size was too small", "R is a language for statistics" ), medium = c( "The p-value was significant at alpha 0.05", "Always check your residuals for normality", "Correlation does not imply causation", "The model explains 87 percent of variance", "Use cross-validation to prevent overfitting", "The confidence interval contains the true mean", "Random forests reduce variance through bagging" ), hard = c( "The heteroscedasticity in residuals violates OLS assumptions", "Apply Bonferroni correction for multiple hypothesis testing", "The likelihood ratio test compares nested model specifications", "Multicollinearity inflates standard errors of coefficients", "Use bootstrapping when parametric assumptions are violated" ) ), code = list( easy = c( "x <- c(1, 2, 3, 4, 5)", "mean(x, na.rm = TRUE)", "print('Hello, World!')", "df <- data.frame(a = 1:5)", "sum(is.na(data))" ), medium = c( "df <- data.frame(x = 1:10, y = rnorm(10))", "result <- sapply(my_list, mean, na.rm = TRUE)", "filtered <- subset(df, value > 0 & group == 'A')", "model <- lm(y ~ x + z, data = train_set)", "apply(matrix_data, MARGIN = 2, FUN = sd)" ), hard = c( "result <- lapply(my_list, function(x) mean(x, na.rm = TRUE))", "ggplot(data, aes(x, y)) + geom_point() + theme_minimal()", "df %>% group_by(category) %>% summarise(avg = mean(value))", "tryCatch(expr = risky_function(), error = function(e) NULL)", "Map(function(x, y) x^2 + y, list_a, list_b)" ) ), chaos = list( easy = c( "df$column[1:5]", "list[[1]]$value", "x <- y + z * 2", "a & b | !c", "func(x = 1, y = 2)" ), medium = c( "data[[1]]$results[[2]]$value", "df[df$x > 0 & !is.na(df$y), ]", "paste0('value_', 1:5, collapse = ', ')", "grepl('^[A-Z]{2,3}$', strings)", "sprintf('%s: %.2f%%', name, pct * 100)" ), hard = c( "purrr::map2_dfr(.x = list_a, .y = list_b, .f = ~.x + .y)", "regex <- '\\\\d{4}-\\\\d{2}-\\\\d{2}\\\\s\\\\d{2}:\\\\d{2}'", "eval(parse(text = paste0('func_', i, '(x = ', j, ')')))", "do.call(rbind, lapply(1:n, function(i) df[sample(nrow(df), 1), ]))", "Reduce(function(acc, x) c(acc, x^2), 1:10, init = numeric(0))" ) ) ) …

Little useless-useful R functions – Typing speed benchmark

Did you ever wonder how fast and with accuracy your typing is? For this instance, we will introduce some random pangrams, code samples and random strings sotrted by level of difficulty. # list of phrases is generated with the help of LLM.…

24.02.2026 20:10 — 👍 2 🔁 0 💬 0 📌 0

The “fair length” rule.

22.02.2026 12:09 — 👍 1 🔁 0 💬 0 📌 0

Enjoy 😎🥰

17.02.2026 08:17 — 👍 1 🔁 0 💬 0 📌 0

LazyMouse – R package for randomly moving mouse cursor New R Package called LazyMouse with single function for randomly moving mouse cursor in your favorite R IDE. For every R developer, R data scientists and all those everyday R users, that also need a break and do not want the computer to go into sleep mode. To install the package, use: install.packages("remotes") remotes::install_github("tomaztk/LazyMouse") The complete installation (with all dependencies and packages preinstalled), can be found in the details on my github repository LazyMouse and the file: Install_package.r. For better convenience have RTools installed as well in your working environment and have Rcpp, remotes and devtools. Happy R coding

LazyMouse – R package for randomly moving mouse cursor

New R Package called LazyMouse with single function for randomly moving mouse cursor in your favorite R IDE. For every R developer, R data scientists and all those everyday R users, that also need a break and do not want the computer to go…

06.01.2026 13:53 — 👍 0 🔁 0 💬 0 📌 0

You are welcome.
Feedback is always welcome!

04.01.2026 13:25 — 👍 0 🔁 0 💬 0 📌 0

>>New R package - LazyMouse<<

Check it out
github.com/tomaztk/Lazy...

#rlanguage #Rstats #Github

03.01.2026 15:35 — 👍 5 🔁 0 💬 2 📌 0

May the 2026 be like stochastic optimization where uncertainty will be embraced, learning will be continuous, and randomness will be turned into advantage and noise will be building block for resilience. #math #stochasticOptimization #calculus #mathematics

01.01.2026 10:36 — 👍 0 🔁 0 💬 0 📌 0

Advent of 2025, Day 24 – SQL Server 2025 – Documentation and learning materials

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec…

24.12.2025 14:13 — 👍 0 🔁 0 💬 0 📌 0

Advent of 2025, Day 23 – SQL Server 2025 – T-SQL Features – String concatenation with || and compound assignment ||=

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON…

23.12.2025 11:16 — 👍 0 🔁 0 💬 0 📌 0

Advent of 2025, Day 22 – SQL Server 2025 – T-SQL Features – UNISTR n this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL Server 2025 – New T-SQL functions – JSON Index Dec 04: Microsoft SQL Server 2025 – New T-SQL functions – Product() Dec 05: Microsoft SQL Server 2025 – New T-SQL functions – BASE64_ENCODE() and BASE64_DECODE() Dec 06: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_LIKE() Dec 07: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_SUBSTR() and REGEXP_REPLACE()

Advent of 2025, Day 22 – SQL Server 2025 – T-SQL Features – UNISTR

n this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL…

22.12.2025 16:45 — 👍 0 🔁 0 💬 0 📌 0

Advent of 2025, Day 21 – SQL Server 2025 – Change Event Streaming – part 2

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec…

21.12.2025 19:00 — 👍 0 🔁 0 💬 0 📌 0

Advent of 2025, Day 20 – SQL Server 2025 – Change Event Streaming In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL Server 2025 – New T-SQL functions – JSON Index Dec 04: Microsoft SQL Server 2025 – New T-SQL functions – Product() Dec 05: Microsoft SQL Server 2025 – New T-SQL functions – BASE64_ENCODE() and BASE64_DECODE() Dec 06: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_LIKE() Dec 07: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_SUBSTR() and REGEXP_REPLACE()

Advent of 2025, Day 20 – SQL Server 2025 – Change Event Streaming

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL…

20.12.2025 18:57 — 👍 0 🔁 0 💬 0 📌 0

Advent of 2025, Day 19 – SQL Server 2025 – New T-SQL functions – CURRENT_DATE In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL Server 2025 – New T-SQL functions – JSON Index Dec 04: Microsoft SQL Server 2025 – New T-SQL functions – Product() Dec 05: Microsoft SQL Server 2025 – New T-SQL functions – BASE64_ENCODE() and BASE64_DECODE() Dec 06: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_LIKE() Dec 07: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_SUBSTR() and REGEXP_REPLACE()

Advent of 2025, Day 19 – SQL Server 2025 – New T-SQL functions – CURRENT_DATE

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec…

19.12.2025 13:50 — 👍 0 🔁 0 💬 0 📌 0

Advent of 2025, Day 18 – SQL Server 2025 – Optimized locking In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL Server 2025 – New T-SQL functions – JSON Index Dec 04: Microsoft SQL Server 2025 – New T-SQL functions – Product() Dec 05: Microsoft SQL Server 2025 – New T-SQL functions – BASE64_ENCODE() and BASE64_DECODE() Dec 06: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_LIKE() Dec 07: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_SUBSTR() and REGEXP_REPLACE()

Advent of 2025, Day 18 – SQL Server 2025 – Optimized locking

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL Server…

18.12.2025 20:08 — 👍 0 🔁 0 💬 0 📌 0

Advent of 2025, Day 17 – SQL Server 2025 – Query hint ABORT_QUERY_EXECUTION In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL Server 2025 – New T-SQL functions – JSON Index Dec 04: Microsoft SQL Server 2025 – New T-SQL functions – Product() Dec 05: Microsoft SQL Server 2025 – New T-SQL functions – BASE64_ENCODE() and BASE64_DECODE() Dec 06: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_LIKE() Dec 07: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_SUBSTR() and REGEXP_REPLACE()

Advent of 2025, Day 17 – SQL Server 2025 – Query hint ABORT_QUERY_EXECUTION

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec…

17.12.2025 18:57 — 👍 0 🔁 0 💬 0 📌 0

Advent of 2025, Day 16 – SQL Server 2025 – Optional parameter plan optimization (OPPO)

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec…

16.12.2025 18:54 — 👍 1 🔁 0 💬 0 📌 0

Advent of 2025, Day 15 – SQL Server 2025 – T-SQL functions for AI External_Models, Chunks and Embeddings

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and…

15.12.2025 19:00 — 👍 0 🔁 0 💬 0 📌 0

Advent of 2025, Day 14 – SQL Server 2025 – Vector arrays or embeddings with function AI_GENERATE_EMBEDDINGS In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL Server 2025 – New T-SQL functions – JSON Index Dec 04: Microsoft SQL Server 2025 – New T-SQL functions – Product() Dec 05: Microsoft SQL Server 2025 – New T-SQL functions – BASE64_ENCODE() and BASE64_DECODE() Dec 06: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_LIKE() Dec 07: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_SUBSTR() and REGEXP_REPLACE()

Advent of 2025, Day 14 – SQL Server 2025 – Vector arrays or embeddings with function AI_GENERATE_EMBEDDINGS

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type…

14.12.2025 15:16 — 👍 0 🔁 0 💬 0 📌 0

Advent of 2025, Day 13 – SQL Server 2025 – Vector function

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL Server…

13.12.2025 17:47 — 👍 0 🔁 0 💬 0 📌 0

Advent of 2025, Day 12 – SQL Server 2025 – New vector data type and Vector functions In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL Server 2025 – New T-SQL functions – JSON Index Dec 04: Microsoft SQL Server 2025 – New T-SQL functions – Product() Dec 05: Microsoft SQL Server 2025 – New T-SQL functions – BASE64_ENCODE() and BASE64_DECODE() Dec 06: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_LIKE() Dec 07: Microsoft SQL Server – New T-SQL functions – REGEXP_SUBSTR() and REGEXP_REPLACE()

Advent of 2025, Day 12 – SQL Server 2025 – New vector data type and Vector functions

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec…

12.12.2025 19:41 — 👍 0 🔁 0 💬 0 📌 0

Advent of Code 2025

I just completed all 12 days of Advent of Code 2025! #AdventOfCode adventofcode.com

12.12.2025 05:32 — 👍 2 🔁 0 💬 0 📌 0

Advent of 2025, Day 11 – SQL Server 2025 – External REST endpoint invocation using LLM

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec…

11.12.2025 22:43 — 👍 0 🔁 0 💬 0 📌 0

SSMS 22.1 Release SSMS 22.1 is now available and includes improvements and updates for GitHub Copilot in SSMS, and a set of fixes for SSMS.

Wednesday Wisdom: You can bring your own model (BYOM) to GitHub Copilot in SSMS with your personal subscription.

Also, we released SSMS 22.1 yesterday!

techcommunity.microsoft.com/blog/sqlserv...

10.12.2025 17:01 — 👍 13 🔁 6 💬 0 📌 0

I just completed "Reactor" - Day 11 - Advent of Code 2025 #AdventOfCode adventofcode.com/2025/day/11

11.12.2025 05:51 — 👍 7 🔁 0 💬 0 📌 0

Advent of 2025, Day 9 – SQL Server 2025 – External REST endpoint invocation In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL Server 2025 – New T-SQL functions – JSON Index Dec 04: Microsoft SQL Server 2025 – New T-SQL functions – Product() Dec 05: Microsoft SQL Server 2025 – New T-SQL functions – BASE64_ENCODE() and BASE64_DECODE() Dec 06: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_LIKE() Dec 07: Microsoft SQL Server – New T-SQL functions – REGEXP_SUBSTR() and REGEXP_REPLACE()

Advent of 2025, Day 9 – SQL Server 2025 – External REST endpoint invocation

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec…

10.12.2025 21:52 — 👍 0 🔁 0 💬 0 📌 0

Day 10 - Advent of Code 2025

I just completed "Factory" - Day 10 - Advent of Code 2025 #AdventOfCode adventofcode.com/2025/day/10

10.12.2025 09:21 — 👍 1 🔁 0 💬 0 📌 0

Advent of 2025, Day 9 – SQL Server 2025 – New T-SQL functions – REGEXP_MATCHES() and REGEXP_SPLIT_TO_TABLE() In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL Server 2025 – New T-SQL functions – JSON Index Dec 04: Microsoft SQL Server 2025 – New T-SQL functions – Product() Dec 05: Microsoft SQL Server 2025 – New T-SQL functions – BASE64_ENCODE() and BASE64_DECODE() Dec 06: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_LIKE() Dec 07: Microsoft SQL Server – New T-SQL functions – REGEXP_SUBSTR() and REGEXP_REPLACE()

Advent of 2025, Day 9 – SQL Server 2025 – New T-SQL functions – REGEXP_MATCHES() and REGEXP_SPLIT_TO_TABLE()

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type…

09.12.2025 22:43 — 👍 1 🔁 0 💬 0 📌 0

Day 8 - Advent of Code 2025

I've completed "Playground" - Day 8 - Advent of Code 2025 #AdventOfCode adventofcode.com/2025/day/8

08.12.2025 19:28 — 👍 3 🔁 0 💬 0 📌 0

Advent of 2025, Day 8 – SQL Server 2025 – New T-SQL functions – REGEXP_INSTR() and REGEXP_COUNT()

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some…

08.12.2025 16:31 — 👍 1 🔁 0 💬 0 📌 0

Advent of 2025, Day 7 – SQL Server 2025 – New T-SQL functions – REGEXP_SUBSTR() and REGEXP_REPLACE() In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some functions Dec 03: Microsoft SQL Server 2025 – New T-SQL functions – JSON Index Dec 04: Microsoft SQL Server 2025 – New T-SQL functions – Product() Dec 05: Microsoft SQL Server 2025 - New T-SQL functions - BASE64_ENCODE() and BASE64_DECODE() Dec 06: Microsoft SQL Server 2025 – New T-SQL functions – REGEXP_LIKE() Continuing with SQL Server 2025 T-SQL functions for Regular Expressions for replace and substring functionalities.

Advent of 2025, Day 7 – SQL Server 2025 – New T-SQL functions – REGEXP_SUBSTR() and REGEXP_REPLACE()

In this Microsoft SQL Server 2025 series: Dec 01: Microsoft SQL Server 2025 – Introduction and installation Dec 02: Microsoft SQL Server 2025 – New T-SQL functions – native JSON data type and some…

07.12.2025 17:15 — 👍 1 🔁 0 💬 0 📌 0

Posts by Tomaz Kastrun (@tomaztsql.bsky.social)