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…
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…
In this Microsoft SQL Server 2025 series: We have looked into the settings of SQL server and generating SAS token. And now we will need to set the needed Azure services. Create Event Hub in Azure Portal In Portal create…
In this Microsoft SQL Server 2025 series: Optimized locking is a new feature in SQL Server 2025. It helps to reduce lock memory as very few locks are held even for large transactions. In addition, optimized locking avoids lock escalations…
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…
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…
In this Microsoft SQL Server 2025 series: Continuing with SQL Server 2025 T-SQL functions for Regular Expressions for replace and substring functionalities. REGEXP_SUBSTR() Returns one occurrence of a substring of a string that matches the regular expression pattern. If no…
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.…
In this Microsoft SQL Server 2025 series: SQL Server 2025 introduces a JSON index on JSON columns that accelerates querying data from JSON objects. In addition, JSON index supports functions like JSON_VALUE, JSON_PATH_EXISTS, and JSON_CONTAINS. There are some limitations, namely…
In this Microsoft SQL Server 2025 series: With multiple new T-SQL support for JSON, we will look into JSON Type, JSON_CONTAINS, JSON_ARRAYAGG and JSON_OBJECTAGG. The native json type was introduced in Azure SQL Database and Azure SQL Managed Instance, and…
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…
Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond
A daily selection of the best content published on WordPress, collected for you by humans who love to read.
Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond
A blog about SQL Server and the Microsoft Business Intelligence stack with some random Non-Microsoft tools thrown in for good measure.
for Application Developers
Data Driven Business Models
Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond
Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond
Tomaz doing BI and DEV with SQL Server and R, Python, Power BI, Azure and beyond
Data for Life :)
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
Intimidating Databases and Code
Ramblings
A modern business theme
DevOps could be the disease you die with, but don’t die of.
Business Intelligence Blog
Information about SQL (PostgreSQL & SQL Server) from the Asylum.
A blog about Life, SQL & Everything ...
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 a blog on SQL Server, Replication, Performance Tuning and whatever else.
As aventuras de um DBA usando o Poder do $hell