Tomaz Kastrun (@tomaztsql) Bsky

Release Notes for SQL Server Management Studio (SSMS) Release notes for SQL Server Management Studio (SSMS).

And SSMS 22.5 is out.
learn.microsoft.com/en-us/ssms/r...

1 week ago 5 4 0 0

Nice. Love it

1 week ago 0 0 0 0

Little useless-useful R functions – Date Palindrome It is a rare thing that a date can be a palindrome. But it happens. And the idea is the following, to cover all different date formats and for the given period IsPalindromeDateRange <- function(date = Sys.Date(), end_date = NULL, formats = "all", verbose = TRUE) { ## Helper stuff is_palindrome <- function(x) { chars <- strsplit(x, "")[[1]] identical(chars, rev(chars)) } reverse_string <- function(x) { paste(rev(strsplit(x, "")[[1]]), collapse = "") } date_to_digits <- function(date, format = "%Y%m%d") { format(date, format) } date_formats <- list( YYYYMMDD = list( name = "YYYYMMDD", format = "%Y%m%d", example = "20251202", regions = "International/ISO standard" ), MMDDYYYY = list( name = "MMDDYYYY", format = "%m%d%Y", example = "12022025", regions = "United States" ), DDMMYYYY = list( name = "DDMMYYYY", format = "%d%m%Y", example = "02122025", regions = "Europe" ), YYMMDD = list( name = "YYMMDD", format = "%y%m%d", example = "251202", regions = "" ), DDMMYY = list( name = "DDMMYY", format = "%d%m%y", example = "021225", regions = "" ), MMDDYY = list( name = "MMDDYY", format = "%m%d%y", example = "120225", regions = "United states - short" ) ) date <- as.Date(date) if (identical(formats, "all")) { check_formats <- names(date_formats) } else { check_formats <- formats invalid <- setdiff(formats, names(date_formats)) if (length(invalid) > 0) { warning("Unknown formats ignored: ", paste(invalid, collapse = ", ")) check_formats <- intersect(formats, names(date_formats)) } } if (!is.null(end_date)) { end_date <- as.Date(end_date) # Hearlthy checker start < end if (date > end_date) { temp <- date date <- end_date end_date <- temp } total_days <- as.integer(end_date - date) + 1 if (verbose) { cat("From:", format(date, "%Y-%m-%d")) cat("To: ", format(end_date, "%Y-%m-%d")) cat("(", total_days, " days)", sep = "") cat("\n") cat(" Formats: ", paste(check_formats, collapse = ", "), "\n\n", sep = "") } # Emopyt data frame results <- data.frame( date = as.Date(character()), day_of_week = character(), format = character(), digits = character(), stringsAsFactors = FALSE ) check_date <- date checked <- 0 while (check_date <= end_date) { for (fmt in check_formats) { digits <- date_to_digits(check_date, date_formats[[fmt]]$format) if (is_palindrome(digits)) { results <- rbind(results, data.frame( date = check_date, day_of_week = format(check_date, "%A"), format = fmt, digits = digits, stringsAsFactors = FALSE )) } } check_date <- check_date + 1 checked <- checked + 1 } # Results if (verbose) { if (nrow(results) == 0) { cat("No date palindrome found in this range.\n\n") } else { # Get uniques per date format unique_dates <- unique(results$date) cat(sprintf("Found %d palindrome occurrence%s (%d unique date%s):\n\n", nrow(results), if (nrow(results) > 1) "s" else "", length(unique_dates), if (length(unique_dates) > 1) "s" else "")) cat(strrep("─", 60), "\n") cat(sprintf(" %-12s %-10s %-12s %s\n","Date", "Day", "Format", "Digits")) cat(strrep("─", 60), "\n") display_results <- results for (i in seq_len(nrow(display_results))) { row <- display_results[i, ] cat(sprintf(" %-12s %-10s %-12s %s ↔ %s\n", format(row$date, "%Y-%m-%d"), substr(row$day_of_week, 1, 10), row$format, row$digits, reverse_string(row$digits))) } cat(strrep("─", 60), "\n\n") if (length(check_formats) > 1) { #funky stuff cat("Summary by format:\n") format_counts <- table(results$format) for (fmt in names(format_counts)) { cat(sprintf("%s: %d palindrome%s\n", fmt, format_counts[fmt], if (format_counts[fmt] > 1) "s" else "")) } cat("\n") } } } } # Sanity Check results <- sapply(check_formats, function(fmt) { digits <- date_to_digits(date, date_formats[[fmt]]$format) is_palindrome(digits) }) if (verbose) { any_palindrome <- FALSE for (fmt in check_formats) { digits <- date_to_digits(date, date_formats[[fmt]]$format) is_pal <- results[fmt] status <- if (is_pal) "PALINDROME!" else "Not a palindrome" if (is_pal) any_palindrome <- TRUE cat(sprintf(" %s %-15s : %s %s\n", date_formats[[fmt]]$name, digits, if (is_pal) "<>" else " ", status)) } cat("\n") } } …

Little useless-useful R functions – Date Palindrome

It is a rare thing that a date can be a palindrome. But it happens. And the idea is the following, to cover all different date formats and for the given period IsPalindromeDateRange

1 month ago 0 1 0 0

CoPilot in SSMS reads from my database/sql server instance, but doesn't show me any executed queries. This is *so* dangerous for your production data - CoPilot could just pass some of your sensitive data to the LLM provider... #ai #llm #datasecurity #gdpr

1 month ago 4 2 2 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. 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.…

1 month ago 2 0 0 0

The “fair length” rule.

1 month ago 1 0 0 0

Enjoy 😎🥰

2 months ago 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…

3 months ago 0 0 0 0

You are welcome.
Feedback is always welcome!

3 months ago 0 0 0 0

>>New R package - LazyMouse<<

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

#rlanguage #Rstats #Github

3 months ago 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

3 months ago 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…

3 months ago 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…

3 months ago 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…

3 months ago 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…

4 months ago 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…

4 months ago 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…

4 months ago 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…

4 months ago 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…

4 months ago 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…

4 months ago 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…

4 months ago 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…

4 months ago 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…

4 months ago 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…

4 months ago 0 0 0 0

Advent of Code 2025

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

4 months ago 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…

4 months ago 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...

4 months ago 13 6 0 0

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

4 months ago 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…

4 months ago 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

4 months ago 1 0 0 0

Posts by Tomaz Kastrun