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,369 reads
Two days of Data, Beer and Bratwurst. What did it bring me, find out by reading this photo-rich article.
2024-05-24
445 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,762 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)
4,877 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
8,673 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)
12,890 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
4,855 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
999 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 Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Comments posted to this topic are about the item Create an HTML Report on...
Hi everyone I have a SP that finds the average based on 3 tables. ...
I have a large table with 17M+ rows for our package record audits. I've...