Blog Archives

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. Addition to list of sample strings, we have also

Tagged with: , , , , , , , , ,
Posted in R, Useless R functions

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: Besides embeddings, the new AI functionalities in T-SQL with new SQL Server 2025 are also creating external models, calculating embeddings and chunks. CREATING EXTERNAL MODELS It creates an external model object that is

Tagged with: , , , , , , , , , ,
Posted in Azure AI, SQL Server, Uncategorized

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

In this Microsoft SQL Server 2025 series: Yesterday we looked into functions for working with vector data type and started also tinkering with VECTOR_SEARCH. With AI there are couple of T-SQL functionalities, that we will also cover. AI_GENERATE_EMBEDDINGS AI_GENERATE_EMBEDDINGS is

Tagged with: , , , , , , , , ,
Posted in Azure AI, SQL Server, Uncategorized

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

In this Microsoft SQL Server 2025 series: After short introduction into the  sp_invoke_external_rest_endpoint we will look into creating a REST endpoint for using LLM. Deploy LLM model In your Azure tenant, go to Azure AI Foundry and deploy a model

Tagged with: , , , , , , ,
Posted in Azure AI, Azure Machine Learning, SQL Server, Uncategorized

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

In this Microsoft SQL Server 2025 series: This new functionality, you can call to the system stored procedure sp_invoke_external_rest_endpoint, and call / get: – Call REST/GraphQL endpoints from other Azure services– Have data processed via an Azure Function– Update a Power

Tagged with: , , , , , , , , , ,
Posted in Azure AI, Power BI, R, SQL Server, Uncategorized

Advent of 2025, Day 6 – SQL Server 2025 – New T-SQL functions – REGEXP_LIKE()

In this Microsoft SQL Server 2025 series: SQL Server 2025 introduces a new T-SQL functions for Regular Expressions (RegEx). With multiple RegEx functions, the LIKE function indicates if the regular expression pattern matches the string or is in a string.

Tagged with: , , , , , , ,
Posted in SQL Server

Little useless-useful R functions – Markov babbler

This one is named, yes, you guessed it, after Markov chains. 🙂 The babbler is there to connotate the simplicity of useless R function. It’s simple calculation of probability of words chaining and drawing the multiple times appeared chained words

Tagged with: , , , , , , , , ,
Posted in R, Uncategorized, Useless R functions

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

Tagged with: , , , , , , , ,
Posted in Azure AI, Azure Machine Learning

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

Tagged with: , , , , , ,
Posted in R, Uncategorized

Advent of 2024, Day 25 – Microsoft Azure AI – Documentation and learning path for Azure AI Foundry

In this Microsoft Azure AI series: Documentation and material for Azure AI Foundry are plentiful and growing on a daily basis, since the topic on AI and GenAI is evermore so popular. General and best way to start is with

Tagged with: , , , , , , , , , , , , , , , ,
Posted in Azure AI
Follow TomazTsql on WordPress.com
Programs I Use: SQL Search
Programs I Use: R Studio
Programs I Use: Plan Explorer
Rdeči Noski – Charity

Rdeči noski

100% of donations made here go to charity, no deductions, no fees. For CLOWNDOCTORS - encouraging more joy and happiness to children staying in hospitals (http://www.rednoses.eu/red-noses-organisations/slovenia/)

€2.00

Top SQL Server Bloggers 2018
TomazTsql

Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond

Discover WordPress

A daily selection of the best content published on WordPress, collected for you by humans who love to read.

Revolutions

Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond

Reeves Smith's SQL & BI Blog

A blog about SQL Server and the Microsoft Business Intelligence stack with some random Non-Microsoft tools thrown in for good measure.

SQL Server

for Application Developers

Business Analytics 3.0

Data Driven Business Models

SQL Database Engine Blog

Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond

Search Msdn

Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond

R-bloggers

Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond

Data Until I Die!

Data for Life :)

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

Grant Fritchey

Intimidating Databases and Code

Madhivanan's SQL blog

A modern business theme

Alessandro Alpi's Blog

DevOps could be the disease you die with, but don’t die of.

Paul te Braak

Business Intelligence Blog

Sql Insane Asylum (A Blog by Pat Wright)

Information about SQL (PostgreSQL & SQL Server) from the Asylum.

Gareth's Blog

A blog about Life, SQL & Everything ...

SQLPam's Blog

Life changes fast and this is where I occasionally take time to ponder what I have learned and experienced. A lot of focus will be on SQL and the SQL community – but life varies.

William Durkin

William Durkin a blog on SQL Server, Replication, Performance Tuning and whatever else.

$hell Your Experience !!!

As aventuras de um DBA usando o Poder do $hell

Design a site like this with WordPress.com
Get started