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

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

Using Github actions for creating Unity catalog tables in Azure Databricks

Managing your tables and data DDL and CRUD using Github actions (or any DevOps tool) is a great way to have your Azure Databricks Unity catalog developed from ground up with DevOps pipelines. And to evolve further catalogs, schemas or

Tagged with: , , , , , ,
Posted in Azure Databricks, Spark

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

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

Advent of 2024, Day 24 – Microsoft Azure AI – Evaluation in Azure AI Foundry

In this Microsoft Azure AI series: With evaluation you performing iterative, systematic evaluations with the right evaluators and measure and address potential response quality, safety, or security concerns throughout the AI development lifecycle, from initial model selection through post-production monitoring.

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, Fabric, enterprise Power BI, SQL Server BI, Data Modeling, SSAS Design, SSRS, 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