SQLpassion Live Training about Query Tuning Fundamentals
On May 3, 2022 I will run an SQLpassion Live Training about SQL Server Query Tuning Fundamentals. If you have a database driven application which reacts very slowly when...
2022-04-04
39 reads
Blog Posts
SSAS getting message: “Unable to convert one or multiple M partitions into native source queries.”
The Issue Recently one of our team members faced the following issue: We have SSAS Tabular model deployed in DirectQuery mode taking data from MSSQL server database. Suddenly SSAS...
2022-04-04
8 reads
Tech Lunch News
Ve středu 9.3.2022 jsme se tradičně sešli nad novinkami ze světa dat, datových skladů, Power BI, Azure apod. Jestli jste chyběli (ale příště dorazíte, že? :D), zde je malý...
2022-04-04
3 reads
Two Years of “Good Morning!”
Two years ago at the start of the pandemic, I wasn’t feeling great about things. I saw that quite a few others weren’t all that thrilled about how things...
2022-04-04
36 reads
Daily Coping 1 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-01
25 reads
Power Automate – Returning the Last Day of the Month
Have you ever needed to set a property or field to the last day of the month? This is a common business problem that can
2022-04-01 (first published: 2022-03-25)
404 reads
Starting LocalDB–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Lots of people have never worked with LocalDB,...
2022-04-01 (first published: 2022-03-28)
211 reads
Daily Coping 31 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-31
14 reads
KQL Series – Big Data Analytics with Azure Data Explorer
This blog pos illustrates how Azure Data Explorer and Azure Synapse Analytics complement each other for near real-time analytics and modern data warehousing use cases. This solution is already...
2022-03-31
42 reads
KQL Series – create a database in our ADX cluster
In the previous blog post we created an Azure Data Explorer (ADX) cluster. In this blog post we will create a database that we will ingest data into, as...
2022-03-31
63 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers