Unlock new opportunities for data-driven decision-making by grasping the significance of SQL and structured data in current data and analytics ecosystems like Microsoft Fabric.
2025-03-21
6,511 reads
Two days of Data, Beer and Bratwurst. What did it bring me, find out by reading this photo-rich article.
2024-05-24
452 reads
An experienced DBA asks an AI to perform some common tasks. Read to see how it fairs and if an AI will impact DBA jobs.
2024-03-11
7,816 reads
Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.
2024-02-03 (first published: 2024-01-03)
5,027 reads
Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
2023-12-11
9,500 reads
Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().
2023-11-20 (first published: 2023-11-15)
13,863 reads
You will learn how a blockchain works and then use a SQL database to analyze data from a series of transactions.
2023-09-08
5,018 reads
In this article, we will discuss the purpose and use of the WHERE LIKE clause in SQL Server and how it can help you construct more efficient queries.
2023-06-02
Learn how to get started with Google Cloud MySQL and PostgreSQL databases by creating and configuring a database.
2023-05-26
1,009 reads
As we continue into the era of supporting more and more database platforms in our data estates, self-monitoring goes from being a very difficult task to a truly daunting task. I am personally advanced at diagnosing Microsoft SQL Server performance issues, but when that PostgreSQL server gets added, I just have to hope nothing goes wrong for a few years while I learn.
2023-04-10
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Comments posted to this topic are about the item Having a Little Fun at...
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
Comments posted to this topic are about the item String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers